Creating Report with Subject(email parameters) as one dimension | Community
Skip to main content
noddyakhtar
noddyakhtar
New Participant
Jul 19, 2018 10:32 AM UTC
Solved

Creating Report with Subject(email parameters) as one dimension

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Employee
Jul 20, 2018 12:40 PM UTC

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:

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

View reply

2 replies

Gaurang-1
Gaurang-1
Level 9
Jul 26, 2018 6:46 AM UTC

Hi,

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

Gaurang

Translate
Adhiyan
AdhiyanAccepted solution
Employee
Jul 20, 2018 12:40 PM UTC

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:

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...