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.
Solved! Go to Solution.
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!
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!
That's perfect!
I'm so glad this helps! Please reach back if you run in to any additional questions.
We're here to help!
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?
Featured Article
Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.
See ArticleFeatured Thread
If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!
View threadFeatured Thread
Your email list is a valuable asset for your business. Let's learn the importance of growing it.
Join challengeWe’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.
Start Here