I am looking to pull all the email jobs that a particular email address has received. The issue is our transactional unit uses email as a the subscriber key and our promotional unit uses unique subscriber keys.

I am looking to pull, based on the email address, anything that email has gotten regardless of what what the sub key is.

  • Hi Daniel. Can you share what you have tried so far in terms of researching a solution? Please take a minute reading few these helpful tips for asking questions: salesforce.stackexchange.com/help/how-to-ask Feb 2, 2019 at 12:33
  • 1
    It will be impossible to retrieve all historical information about sends. The data views you need to connect to get that kind of information have a retention period of about 6 months, so if there was anything sent to your customers before that, you won't be able to retrieve all data. Feb 4, 2019 at 10:46

1 Answer 1


Your only option would be to use the _Sent data view. Because the _Sent data view doesn’t have an email address and only subscriber key, you’ll need to join the data with the _Subscriber data view. Note that all data views only go back 6 months worth of data so it is not a full history of information.

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.