Cumulative Did Not Open Report

[WesleyB64737]

So then the question becomes how to mass delete those names/emails that haven't opened in a while? My list is large as is the list of did not opens. I'm trying to figure out how to use spreadsheets to accomplish this but haven't had any luck so far.

I thought I could download all my contacts in one file and my did not opens in another and then use excel to combine them and then sort so that any contacts in both lists would be sorted as such. Then I could simply delete those lines and reimport the file as a new contacts list.

However, I can't figure out how to make that happen.

[Alex_S · Accepted solution]

Hi @WesleyB64737

I'm glad you've asked this question as a lot of our customers want this ability as well. With our new segments feature you can now isolate your contacts based on whether or not they have opened any of your emails. When you create the segment you'll want your criteria to look like this:

For the date range, you'll simply choose the start date from approximately when you started your account through the current day. After that, you'll select save and preview. This will generate your Cumulative Did Not Open report for your account. 

Once you have your segment created, you will have an option in the top right corner with three vertical dots. Click those dots and choose add to list from the drop down. This will allow you to put those contacts in a list (my suggestion would be that you create a new list called "Did Not Opens" or something similar to that. Once you have the contacts from that segment added to their own list, you can select them all and delete them. 

Thanks!

[WesleyB64737]

That's perfect!

[Alex_S]

I'm so glad this helps! Please reach back if you run in to any additional questions. 

We're here to help!

[AndrewC2585]

When you create a segment for contacts that "did not open" "last 5 emails", does it strictly mean the last 5 emails sent to them, or the last 5 emails sent from my account as a whole?