To Export only active subscribers by list, you have two options:
Option 1: Create a Dynamic List of Active Subscribers and Export the List
To create a dynamic list:
- Open the Subscribers & Lists folder and click Lists
- Click the Add List button at the top of the grid and then select the type Dynamic
- Name the list (could use the same name as the original, and then add the word "Active Subs" to the beginning)
- Select the list you want to see only the active subscribers from
- Leave the rules blank
- Click Save Rules
Then run the Export Subscribers by List Report, selecting this dynamic list.
- Click Reports
- Click Custom Reports
- Double click Export Subscribers by List
- You'll see a grid listing all of your lists
- Double click new dynamic list you just created
- To view the report, click the link in the message box to view the report in Excel
Option 2: Export a List, Then Filter by the Unsubscribe Column
First, run the Export Subscribers by List report:
- Click Reports
- Click Custom Reports
- Double click Export Subscribers by List
- You'll see a grid listing all of your lists
- Double click the list you would like to export
- To view the report, click the link in the message box to view the report in Excel
- Next, sort the list by highlighting the column "Unsubscribed From All" in excel.
- Copy all of the subscribers with the value of "N" in this column to a new Excel file. These are the active subscribers. Anyone with a "Y" value is unsubscribed from all.
Comments
0 comments
Please sign in to leave a comment.