Hi - When we build an A/B test in a marketing email where we’d be testing for example the performance of two different Subject Lines, Dynamics creates 2 different versions of the same email to account for the 2 subject lines. There is only one email record in the email table, and one journey record in the journey table. On the activity data side, each one of the 4 tables EmailSent EmailDelivered, EmailOpened and EmailClicked has a column named SendingID. In the case of an A/B test with only 2 options the SendingId has 2 different values depending on which version the contact would have been sent, received, opened, and clicked. I think that the SendingID should allow us to join to a table where the attributes of the email version (including subject line in this case – but could be something else in other cases) would be stored. Any info regarding such a table or where that information is stored? And would that change in Real-Time?
When you create an A/B test (e.g., two different subject lines), Dynamics only stores one “parent” Email record in the Email table.
The two A/B versions are variants of that single record, not new records.
The system distinguishes them using the SendingID in the activity tables: EmailSent
EmailDelivered
EmailOpened
EmailClicked So you’re right: SendingID is what links a recipient’s interaction to the specific A/B test variant they received.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
31
Share
Report
All responses (
Answers (
