ExactTarget list of unsubscribes this year

I’m wondering how to access a unsubscribe list. Usually in a given blast, for ex 250 approx I’ll get 3 Unsubscribes. Where can I get a list of all Unsubcribes for this year? is there a place in ET?

I’ve also looked in ExactTarget Reporting and I looked at the Subscribers drop down from the main menu– it’s not here.


Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

It’s in a System Data View called Unsubscribe, which is accessible via Query Activity. JobID corresponds to the Job ID in the SFMC user-interface under Tracking > Sends.

A common process would be:

  1. Create a Data Extension with the desired columns.
  2. Compose a Query Activity that writes to the Data Extension
  3. Create a Data Extract Activity for the Data Extension
  4. Create a File Transfer Activity to upload the extracted file to the FTP share
  5. Create a Program or Automation that runs steps 1-4.

Method 2

The results should populate the data extension that you selected and created (which it seems you have).

If you do not see your results being populated, my guess is that your query results are empty. At first pass, I noticed that your JobID range is extremely high and I wonder whether that high range is the cause of your empty results.

You can see a quick snapshot of your jobs and their JobIDs if you go to Tracking > Sends. You should be able to see an overview of your recent email campaign sends and visually see whether your JobID numbers are within range.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Notify of

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x