Querying Recipient-level Email Subject Lines | Community
Skip to main content
Level 3
May 13, 2025
Solved

Querying Recipient-level Email Subject Lines

  • May 13, 2025
  • 1 reply
  • 538 views

Hello,

 

In a delivery where the subject line is configured as dynamic content (e.g. <%=targetData.firstName%>), is it possible to query in recipient delivery logs for the specific subject line which was created for that recipient?

 

Querying for the field [delivery/mailParameters/subject] just returns the dynamic content code.

 

Thanks,

Skyler

Best answer by DavidKangni

Hi @skylerqu2 ,

 

It's not possible. If you have the data, you can recompute the subject line

 

Thanks,

David

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
May 14, 2025

Hi @skylerqu2 ,

 

It's not possible. If you have the data, you can recompute the subject line

 

Thanks,

David

David Kangni
SkylerQu2Author
Level 3
May 14, 2025

Hi David,

 

Thanks for your answer. Is the targetData passed to the delivery stored anywhere? E.g. in this case, the subject line was conditional based on a targetData.Test_Segment field. We do not have this configured to be stored in broadLogRcp - is there anywhere that this data is stored, or is it lost after the delivery is personalized?

 

Thanks,

Skyler

DavidKangni
Community Advisor
Community Advisor
May 14, 2025

Hi Skyler,

 

Not in the UI but if you have access to the database, you can run some queries on the temp tables before they get delete by the Database cleanup workflow. 

These temp tables are save under wkDlv_XXXX.

 

Thanks,

David

David Kangni