How to delete contacts that havent opened emails in last few months

Go to solution
Occasional Participant

How to delete contacts that havent opened emails in last few months

How to I delete contacts that are sent my emails weekly, but haven't opened my emails for months after initially signing up to receive them? 

Out of 700 emails sent only about 250 ever open them every week.


Hello everyone,

Thank you all for reaching out to the Community with your feedback and questions on creating a cumulative did not open report! As mentioned in previous responses by other Constant Contact employees, we have recently added a Contacts Segments feature to help with creating a Did Not Open list. This tool allows you to create a list that did not open report of contacts for the last 90 days or over your last 500 campaignsPlease continue to share any further feedback on creating a cumulative did not open reports in our feedback section of the Community.

Community & Social Media Support

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

You're not alone on your email marketing journey. Connect with a Marketing Advisor to see how they can help you develop the right strategy for your business and get the most out of your Constant Contact experience.

View solution in original post

152 REPLIES 152
Frequent Participant

THREE CHEERS for what 'Tom D.' above said!


Come on now CC?  It should NOT take another 7 months for you to implement this much needed feature?  I swear..... AWeber is looking better and better!


And the cost is much less!  ..........Sam in Henderson, NV of 

I understand and am very sorry for your frustration, Sam.  But the best I can do for you and all our customers is to be honest in the date when we will have this feature.  There is also a workaround in place that I am more than willing to improve on if you have any suggestions.  If this solution is not acceptable to you and you would prefer to take your business elsewhere then I understand.


Constant Contact's commitment to understanding the needs of small businesses and nonprofits and delivering products that lead to their success was the most important deciding factor in my choice to come work here.   In the three months since I have started, I have been reassured each day of everyone's commitment to this mission – from the brilliant engineers I work with to the empathetic sales and support staff that I overhear each day delivering an outstanding experience to everyone that contacts us.


I recognize that we have fallen short on some of the features of the products, and we are working hard to improve those. However, I am certain that when you evaluate the entire package of what we offer compared to others, I am certain that you could not have a better partner than Constant Contact who is dedicated to making you successful.


I will get off my soapbox now.. thank you for listening (err... reading). :smileyhappy:

Jonathan Mandell
Product Manager - Reporting and Analytics

Well, I had similar questions about tracking open e-mails (my list is just over 5,000) and have now read all the posts on this thread. I am very encouraged by the reasonable answers recently post by Jonathan. I have over 35 years experience in IT and his responses sound like they come from a true professional (I cannot say the same for the prior posts from other CC staff in this thread... they sounded like 'B' team responses to me... good but not great!). Good luck Jonathan... I look forward to your improvements in 2012... BTW, can you also fix the KLUDGY  editing features for e-mail marketing, it's a PITA.


So, until improvements are made, here's my take on managing e-mail lists:


1. Do not trust the 'open' statistics... they are not accurate and can only be used as a relative guide  to your previous mailings.

2. Do not believe the 'Bounce' statistics... I do not think they are 100% based upon limited testing on my part... Jonathan, I would appreciate your comments on this item.

3. Trust your customers to delete themselves from the lists until the above two items get addressed.

4. In terms of cost: That is dependent upon the individual business model and their expectations. For my business (a restaurant), a penny or two for a monthly mailing is a very good deal... sure beats snail mail... and I have no plans to change vendors given that all services are not fully mature from a technical viewpoint and Jonathan's posts give me hope that CC might now have a solid technical leader with common business sense.


So, that's my 2 cents. 

Occasional Participant

Just as a follow-up: I had 461 bounced-mails (out of over 5,000) on my last mailing that were listed as 'non-existent addresses'. Since I did not believe that all 461 were 'non-existent', I downloaded those addresses and sent them out via my business e-mail account and asked them to reply or I'd take them off my list. Well, I got quick returns from 7 people requesting that they stay on my list. I know that this thread is primarily about tracking people that never open emails (and to that I say 'Good Luck')... but I think it is a much more serious issue when you cannot depend upon the system identifying 'non-existent' addresses!!! Sure 7 people out of 461 is a low percentage... but it really should be ZERO for this category! Jonathon, any comment?

Frequent Participant

I have been CC Customer since 1999!  I recently closed my account because CC refuses to give us an easy to use tool to remove subscribers that never open our Newsletters?


I had a credit of $187 in my account!  CC refused to credit me that $187!  But I asked them to close my account anyway....that was about two weeks ago?


However?  Recently things have changed for me!  I do battle with HOAs (Homeowner Associations) since 2003. Check out our "Doorway" Page at


I am here today to beg CC to let me have my Old Account back please?  Including the $187 credit?


I know very well that iContact and the rest are not nearly as 'Robust' as CC is !


And I am hopeful that will generate some Donations so that I can better afford CONSTANT CONTACT!


Thanking CC in advance!  :smileyface:

Hi Sam -

The best way to reactivate in your case is to call our billing dept.  Call the regular support # (866) 289-2101and press 3 for billing. They can reactivate you and assign the credit to your account.  I hope you were told when you cancelled, this money is held for you and yes, you can assign it to the reactivated account.


EDIT: I reactivated it through chatting with the billing team  - I don't typically manage support issues myself, but my team walked me through this one, so you are all set to get mailing...


Welcome back!


Rosalind Morville
Frequent Participant



Bless Your Heart!


You made this old man a Happy Guy!







Thanks. The audio file make me smile, but not as much as the words themselves.  Welcome home Sam.

Rosalind Morville

Thanks again Tom for the great info!  There is certainly something wrong (in my opinion) with how the export of data works since I would not have expected that the unsubscribe date would overwrite the date the contact was added.  I would expect both fields to be available.  So I am looking into what can be done to fix this sooner.


In the meantime, that date is stored in the Contacts -> Removed Contacts and pulling up an individual contact shows the date that they were added, last updated, and removed date.  I know this is certainly not a great solution since it would take a lot of time to go through all your removed contacts but you could at least get a sample.

Jonathan Mandell
Product Manager - Reporting and Analytics
Regular Participant

Jarrad, where is the 'accepted solution' button then?I can't find it?

Hi Kate,


The Accepted Solution is only available to the person who originally created the topic.






If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Frequent Participant

Although not ideal I thought I would just share what I have done to work around all of CC's frustrating lack of functionality. Thank you to the post warning everyone about Confimed Opt-in Emails via CC as I was potentially going to look into that until I also found out you get one email to that list and they are in or out permanatly , as I had asked if I could send multiple confirmations to a list to try and weed contacts out over time.


So basicallyI tried to make my own confirmation email. First I have been exporting my list of opens over the past few months (reminder - CC only keeps the past 3 months - lame) so that I would have a historical list of who has opened my emails according to CC. Next I exported my complete contact list. I opened my compiled "Openers" list and colored them green in excel. I then copied these contacts into my complete list excel file and sorted them. Manually and painfully I went through and deleted all the green cells with their match so that I ended up with a list of "non openers". So now I had two excel files, one of openers, and the other of openers.


Next I imported these lists into CC and deleted my default contact list, leaving me with two new lists.


So now I created a new contact list called "Confirmed customers" and made this my default list so its also where people who filled out my subscribe form would wind up. (I may be different in that my contacts come more from other web leads and opt-ins then those who directly fill out the "subscribe to newsletter form")


Thats pretty much the difficult work (thanks CC!)


So now I have created a series of email confirmations myself requesting people to "Re-Join My List". I suggest going through the process yourself just to see what it looks like. But when a current subscriber clicks to join they just have to go in and re-submit their information. HOWEVER because I made a new default list, when they re-submit their information they are putting themselves on my "Confirmed Customers" contact list. Once they do that they end up on both my "Confirmed Customers" list and my "non openers" list, so I go in and remove them from the "non-openers" list, thus keeping both lists clean and separate.


Here is one of the emails I sent in case you want to see it: Confirmation Email #2


So hopefully after a series of these emails I will haveany one I thought to be a "non openers" confirm their emails for me without the permanacy of CC's Confirmation Opt-In email and the inability to send multiple confirmation emails. And then when my series of confirmation emails are done I will simply delete my "non-openers" list lessening the funds I have to send monthly to CC.


I am not sure if this is the best solution, but it is A solution and am sharing purely because of that. Thank you CC for making it simple to keep my list clean!


Also if anything was confusing and needs clarification just let me know.




Frequent Participant

I have forgotten......even though I was told:  How To


I do NOT like CC's New Editor!  The old one was MUCH BETTER in every way!


I got a phone call from a CC Support Person who told me how to switch back to the Old Editor?  But of course?  I have forgotten How To Do It?


Can someone here tell me how to Switch Back to the Old CC Editor?


Thank You!


Sam in Henderson of

Hi Sam,


We cannot switch you back to the old WYSIWYG editor, but you may be able to access our Classic Wizard by creating a new email and selecting Classic Wizard as your choice of editor. Keep in mind that the Classic Wizard is no longer being supported and you may run into issues with it.


If you're having trouble with your current email with the WYSIWYG editor, try adding a new block or clearing styles from the current block.


If you need immediate assistance, please call us at 1-866-289-2101. We are open until 8:00 PM EST Saturday and Sunday.




If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!

Thank you both Bryon and Andrew for sharing your work arounds with the community.  I will continue to look into the issues you have brought up and will post more info every week or two here as I have more to share.  In the meantime I am collecting all these best practices for working with our products.  My goal is to find a way to share this info with all of our customers since I am certain that many will benefit.  

Jonathan Mandell
Product Manager - Reporting and Analytics
Regular Participant

What a wonderful discussion going on here! I might actually reference this thread on my blog, it does a great job of illustrating why having a CRM system in place is so important for all businesses, large and small. CC is great for the phsical construction and delivery of emails. List management, tracking, and reporting however....that's where CRM really shines.



InfoGrow - Accelerating Growth Through Better Sales and Marketing Decisions

Link Your Constant Contact efforts to Microsoft CRM with CRM2Emails, available on the CC Marketplace.

Is there really no way to generate a report of people that didn't open a specific email, STILL?


I actually called in for support 3 months ago to find out how to do this, or where I could find the report, and was basically told that in order to accomplish that kind of report, that I more or less had to save a .csv file of ALL the subscribers, then a seperate .csv of the subscribers that DID open the email, and manually remove them one by one from the master list.




Every other AR that I've ever worked with has this as a "basic" function that can be done with one click of the mouse. Plus, I've seen this exact thing requested here on the board several times. Not only that, but the lady I spoke with on the support call, said that she's had that request more than a few times.


I'm in disbelief that it wasn't a feature to begin with, but I'm really concerned that the issue hasn't been addressed even after repeated requests by paying customers.



How do I find all the emails in my mailing list that never open the messages we send them?  I want to cleanup my list.  We have had it for several years. 


Is there a clean up function to find emails that never open or are bad etc?



UPDATED: October 2018


We have recently added the Contacts Segments tool that allows you to create a list of contacts that did not open any of your last 5 emails, a specific email, or any email. Please click here to learn more about using our Segments feature.


The information below is the steps to manually create a did not open list.


Hi -


Great question!  If you want to remove those contacts who haven't opened an email from you, you can check out these FAQs on how to location contacts that do not open your email and how to remove them from a listJust a note, we track opens by inserting a very tiny image and when your contacts choose to download images, we count that as an open. That means that if someone doesn't download images but does open your email is not counted.


To clean up your bounces, check out FAQ 5288: Managing, Removing, and Preventing Bounced Emails.


Any questions, let us know! Hope those FAQs help!

Hi There-


Well, I've been waiting since December - or was it January - when Jonathan promised we would get a simple reporting function allowing us to find those who: a) hadn't opened emails in some time b) opened emails consistently.


It is just plain common sense to be able to reward both of those groups. It leads to good feelings and more business.


Acutally, I've been waiting since I discovered this lack in '05 after about a year with Constant Contact, when I had enough history that this data would be useful.


The ability to see this data only one email at a time is very restrictive. I've sent out over 100,000 emails in the last twelve months. Do you really suppose I am going to go through each one to get basic data?


After 7 years of patience and work arounds, this is leading me to conclude that Constant Contact is only for hobbyists or the very small not-quite-a-real business.


Sincerely yours,

Tom Dotz

Hi Tom,


We have been working hard on these reports and I would love to show you the progress we have made.  Would you be willing to chat about this next week sometime?




Jonathan Mandell
Product Manager - Reporting and Analytics