0

Is it possible to retrieve a primary key on tracking data extracts (sent, open, click, etc)? I would assume there is a key somewhere on SFDC MC side that identifies a unique record in their tracking database, but I don't see it when I perform a data extract.

This makes it really hard for us to ensure consistent, high quality data so it would be ideal if we could have a PK on each row. Wondering if anyone else has come across this and has a solution?

Improve this question

1 Answer 1

Reset to default
0

I don't think there is any Primayr Key in the tracking extract data. You will have to cook up your own key by concatenating field values. Below is what I used -

SubscriberKey + SendID + EventDate

Improve this answer
1
  • That is fine, but often on things other than send (open, click, etc) we get valid, duplicate entries (people clicking the same link multiple times a second). So this method doesn't work for us.
    – Jeff Sinclair
    Commented Jun 17, 2016 at 16:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .