Request a Call
Online Chat
Knowledgebase: Zulu eDM Support

Find my Top 100 and VIP customers

Posted by Zulu eDM Team, Last modified by Zulu eDM Team on 07 May 2015 12:36 PM

Step 1. Go to Email Marketing > Campaign Metrics in the system menu

Step 2. Then you will need to select: 

1. The Groups you want to search within e.g. if everyone in your database you can select "Default Group"
2. The Campaigns you want to see the results for. We suggest selecting just the last 6-10 campaigns. 
3. Then you will need to select the fields that you require in the report. We suggest First name, Surname, Email and Subscribed Status. 

Once you click "Export" a CSV report will pop up on screen. This may take some time depending on how much data the system is looking through.

Step 3. The report will be downloaded and the CSV file will look like this.

What you will need to do first is sort through those contacts who have unsubscribed.

In the CSV file, click "Sort" and sort by the "Subscribed" column. 1=Subscribed, 0=Unsubscribed

Then you will need to sort by Open Rate %. Click on the "sort" option in excel again and select "Open Rate %". This will sort through the contacts so that those who are the most engaged (100%) will appear at the top of the list.

Now that the file is sorted you will be able to select the top 100 (or those who have opened all or most of the last campaigns) and re-import them back into the system into a Group called "VIP" or "Top 100" or for any other marketing purposes.

(0 vote(s))
Not helpful

Comments (0)

Copyright Zulu Labs Global Pty Ltd, 297 Dorcas Street South Melbourne VIC, Australia 3205. Ph +61 3 9001 1590