Connecting Archived Event Tracking Logs and the Recipient schema | Community
Skip to main content
thomash82948276
Level 2
November 23, 2018
Solved

Connecting Archived Event Tracking Logs and the Recipient schema

  • November 23, 2018
  • 1 reply
  • 2111 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
January 7, 2019

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