In SFMC, how would I be able to extract a report containing the opens, clicks and the name of the related email campaign for a single user? I have read through this post already: ExactTarget - get a report of all emails sent to individual subscriber?

I still require a little more detail because I'm not familiar with a Destination Data Extension or how to go about creating one. I also need this report to go back one year. Is that possible? We were trying this last week and kept running in to a 90 day maximum. Help is appreciated!


If you're familiar with writing SQL, this resource should give you what you need to connect a subscriber with sent, open, click data. A destination data extension is a regular data extension that serves as the "destination" for the output of your query.

As for the 90 day max, the only way around this is to get this data through a service engagement that you can initiate through you account manager.

| improve this answer | |
  • I'm a bit of a novice with SQL. So even if I write a query it's still going to be met with a 90 day max going back from the current day? – Pasquale Apr 13 '17 at 19:21
  • That is correct. You could begin storing the data so in the future you have access beyond 90 days. This would require the use of tracking extracts (if stored outside of marketing cloud) or query activities where you store in DEs in marketing cloud. – Daniel Apr 14 '17 at 2:11
  • What's the best way to learn to construct queries like this and to get them to store in a DE? I'm not an advanced user but it's something I'll need to learn. Your main answer above contains a link to the documentation but that level of instruction seems to lend itself best to people who already know what they're doing with SQL. – Pasquale Apr 14 '17 at 17:47
  • This might get you going: salesforce.stackexchange.com/questions/31622/… – Daniel Apr 17 '17 at 15:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.