Expand my Community achievements bar.

SOLVED

Connecting Archived Event Tracking Logs and the Recipient schema

Avatar

Level 3

Which field can be used to connect the Archived Event Tracking Logs and the Recipient schema?

I'm trying to create a Campaign Workflow that queries the Tracking Log to include everyone who has ever opened an email.  I can't seem to link that back to the Recipient schema to get the email sent though.

Thanks

Tom

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Tracking connects to recipient by way of broadlog. You have to include the recipient's key as 'externalId' in your calls to Message Center, or otherwise reconcile on the delivery's address, e.g. @email (which isn't necessarily the primary key).

Thanks,

-Jon

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

Tracking connects to recipient by way of broadlog. You have to include the recipient's key as 'externalId' in your calls to Message Center, or otherwise reconcile on the delivery's address, e.g. @email (which isn't necessarily the primary key).

Thanks,

-Jon