Is there a way to export list of unsubscribe date and time? | Community
Skip to main content
A
Anonymous
February 5, 2015
Solved

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

  • February 5, 2015
  • 2 replies
  • 2728 views
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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
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. 

2 replies

A
Anonymous
February 5, 2015
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
 
A
Anonymous
Accepted solution
February 6, 2015
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. 
Terms & ConditionsAccessibility statement

Loading footer...