Querying Recipient-level Email Subject Lines

[SkylerQu2]

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

[DavidKangni · Accepted solution]

Hi @SkylerQu2 ,

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

Thanks,

David

[SkylerQu2]

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]

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