Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Creating Report with Subject(email parameters) as one dimension

Avatar

Avatar
Validate 1
Level 1
noddyakhtar
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
noddyakhtar
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
noddyakhtar
Level 1

19-07-2018

Hi ,

I am trying to create report and want to keep Subject as one Dimension of my report. Since its XML attribute i am not able to bring it up in cube too.

Please let me know .

Thanks

Nadeem

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

20-07-2018

Hello Noddy,

The subject of the mail is in a mailParameters memo (XML) field of the mailing and this is the mailParameters / subject element.
As for any memo / XML field with Adobe Campaign, it can not be used in Query (Query, Enrichment, etc.) or Javascript (queryDef) activity.
On the other hand, it can be exported without any problem from the Extraction file activity:

1532009_pastedImage_0.png

So you can export this as a csv file and use it as a report.

This seems to be the only way we can extract subject using a workflow.

Note: This will export personalized fields as it is , so if you have used , something like :

<% = recipient.firstname%> then the Javascript code will be exported as such in the export file.

Regards,

Adhiyan

Answers (1)

Answers (1)

Avatar

Avatar
Springboard
Level 9
Gaurang
Level 9

Likes

143 likes

Total Posts

435 posts

Correct Reply

45 solutions
Top badges earned
Springboard
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Springboard
Level 9
Gaurang
Level 9

Likes

143 likes

Total Posts

435 posts

Correct Reply

45 solutions
Top badges earned
Springboard
Validate 100
Validate 50
Validate 25
Validate 10
View profile
Gaurang
Level 9

25-07-2018

Hi,

Were you able to find something relevant for your query here?

Gaurang