Exporting Subject Lines of Deliveries | Adobe Higher Education
Skip to main content
robertc66522596
robertc66522596
Level 4
April 6, 2022
解決済み

Exporting Subject Lines of Deliveries

  • April 6, 2022
  • 2 の返信
  • 2447 ビュー

Hello,

 

We are hoping to add Subject Line to one of our daily exports (delivery or recipienttrackinglogs seem to make the most sense). We can find the field under email header parameters off of 'Delivery', however this is only available in the Data Extract activity, and since it can't be added through enrichment or a query, it errors out the export.

 

This question was asked years ago about ACS, and it seems like it was not possible: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/extracting-the-subject-line-of-an-email-delivery-in-acs/m-p/243738

- The suggestion for ACC (which is what we have), unfortunately makes the field visible, but unable to export as i note above.

 

Has anyone found a way to do this successfully? Any tips? I understand the subject lines could be personalized which makes it a little more tricky, but the subject line is important for analysis so hoping there is a way to export this data that we're not aware of.

 

Thank you for your help!

Robbie

このトピックへの返信は締め切られました。
ベストアンサー Marcel_Szimonisz

Hello @robertc66522596 ,

you can export subject line. I did try extract data and load it back as csv. 

 

Also the same is directly accessible from  broad log or tracking log as all is linked to delivery

 

Can you share the workflow details how it is set up?

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

2 の返信

Darren_Bowers
Darren_Bowers
Level 9
April 7, 2022

Hi @robertc66522596 - the subject as far as I am aware is only calculated during the delivery preparation phase and added to each individual send in the delivery. I don't believe the rendered subject is stored anywhere last time I looked.

One suggestion would be to extend the broadLog in your Target Mapping to include a subject field and pre-calculate the subject before the delivery using the workflow schema. That way, you could replace the subject in the delivery with the string variable and during the delivery it would add that variable into the extended broadLog schema.

It would add some size to your broadLog, but you would also be able to extract the actual sent subject for each send, if that is important to you.

Cheers

Darren

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor回答
Community Advisor
April 7, 2022

Hello @robertc66522596 ,

you can export subject line. I did try extract data and load it back as csv. 

 

Also the same is directly accessible from  broad log or tracking log as all is linked to delivery

 

Can you share the workflow details how it is set up?

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

    robertc66522596
    robertc66522596作成者
    Level 4
    April 11, 2022

    Thank you! We were able to get it from this suggestion, much appreciated.

      契約条件Accessibility statement

      Loading footer...