Is there a way to export list of unsubscribe date and time?

[Anonymous]

I'm trying to export a .csv of all of our leads who have unsubscribed, as well as the date and time that they did so. I'm not seeing a field like that in my smart list. Is this possible and if so, how?

[Anonymous]

Hi Julia,

I'm not sure about unsubscribe time, but you should be able to include "unsubscribe date" in your smart list. Try this:

1) Go to your Smart List.
2) Click on the "Leads" tab next to the "Smart List" tab.
3) Near the top-left corner, click on "Vew: Default" to open the drop-down menu.
4) Select "Edit Default."
5) In the pop-up window, use the "Find" search field for "Hidden Columns" and search for "unsubscribe."
6) One of the results should be "unsubscribe date." Select it, click the "Add >>" button, and then the "Save" button.
7) "Unsubscribe Date" should now be a visible column on your smart list that you can export.

Hope that helps.

-Alan
 

[Anonymous · Accepted solution]

Hi Alan, 

I tried that but there is no Unsubscribe Date listed in my columns. That may have been a field that your team added?

I ended up creating a new field --"Unsubscribe Date Time" and have set up a new smart campaign flow. Below is my formula. 
 

If (Data Value Changes) Unsubscribed, new value is true --> Change Data Value of Unsubscribe Date Time (my newly created field)  to {{system.dateTime}}.

This seems to be working for any new unsubscribes in the future. Bad news is I still don't have a solve for all of the people who unsubscribed in the past.