I'm attempting to create my own DE's of the tracking exports so that I have a consolidated view of tracking data since I can only pull 30 days at a time using the Tracking Extract (Data Extract Activity). I've created all the automation to do this.
My question is around the Primary Key. I'm using an "Add Only" (aka Append) when I import to the DE. Essentially creating a consolidated copy of the data extract.
However, I'm unable to do so because a primary key is required for an "Add Only" and in several of the data extracts (i.e. Clicks, ClicksImpressions, Opens), there's not a unique data attribute since customers can click and open more than once. So, some of the records won't import.
I've read several threads where people are doing this, but no one has mentioned how to get around the primary key issue (that I've found). I don't want to perform an overwrite. Any and all help is appreciated.