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.
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).