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

SOLVED
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.

1 ACCEPTED SOLUTION

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.


Frankie.P
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

Hi Sharon, You are correct that that there is no report generated by our system which will tell you who has not opened your email. Sorry for the inconvenience. I see how a non open report could be useful and I will pass on your feedback. The FAQ Marissa posted is a workaround which would allow you to create a list of those contacts who have not opened your email. This list could then be exported and used to remove the contacts who have not opened your email from your active lists. Thank you for your feedback, Jarrad Community & Social Media Support Representative

Jarrad

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

I have been saying this for years. Constant Contact will not create a report such as this because it will reduce our mailing list and Constant Contact will lose money. I have 700 more people I want to add more than 60% of the people on my list are not opening and I want to delete them before I add 700 more which will INCREASE my price. I can't believe Constant Contact is not aware of how much this can help users... I think you guys don't WANT to help us with this.

Kevin

Hi Kevin,

 

We're more concerned with the quality of your list and not the quantity. We would rather see you have a list that performs well than a list full of contacts that do not open your mail or bounce. We do track opens via a 1 pixel image in your email. If images are not downloaded, the open will not track. Because of this, there could be contacts opening your emails that are not being counted.

 

One way to determine if a contact is still interested in your email is by doing a confirmed opt in mailing. This mailing will contain a link. If a contact does not click the link to confirm their interest, then they will not be added back into your list.

 

To do a confirmed opt in mailing, follow these steps:

 

  1. Enable your account for Confirmed Opt-in if it is not already turned on.
  2. Use the "Confirm Permission" template to send a confirmation email to the group of subscribers.

    From the My Settings > Manage My Settings > Confirmed Opt-in ON screen:

    1. Click the "Send a Confirm Contacts Email (Optional)" link.
    2. Enter an email campaign name and click Next.
    3. Go through the wizard, adding content as necessary.

      Note: We strongly recommend that you do not change the text in the body of the message as this may decrease the number of subscribers who follow through and confirm their permission.
    4. When you have finished, click Save & Next.
    5. Select the list that will receive the campaign and click Next.
    6. Set the email campaign delivery date and click Finish.

    From the Email Campaigns > Create screen:

    1. Enter an email campaign name and click Next
    2. Below the template categories in the left column click the "Create a confirmation email" link.
    3. Go through the wizard, adding content as necessary.

      Note: We strongly recommend that you do not change the text in the body of the message as this may decrease the number of subscribers who follow through and confirm their permission.
    4. When you have finished, click Save & Next.
    5. Select the interest category that will receive the campaign and click Next.
    6. Set the email campaign delivery date and click Finish.

Remember to turn Confirm Opt-in back off if you do not want to automatically confirm new subscribers at signup.

Jarrad

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!

"We're more concerned with the quality of your list and not the quantity. We would rather see you have a list that performs well than a list full of bounce backs. "

 

Perhaps I am missing something.  I read this topic to be folks concerned with email that was not opened and not email that was bouncing.  The bouncers are a no-brainier.  Two different scenarios in my mind. 

Thanks for pointing out my mistake Tony. I'll fix my post.

Jarrad

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!
Occasional Participant

This is a major problem that should be a simple solution for Constant Contact to implement. It would be extremely helpful to be able to run this report without wasting countless time trying to manipulate the data.

There is a product on AbleBits.com that removes duplicates Plus the first entry from spreadsheets in Excel.

Its called Removing Excel Duplicates. - it goes beyond what the standard remove duplicate does that comes with Excel

 

There is a 15 day trial

 

Export your list of all contacts

Then export list of contacts that opened emails

Merge them into the same spread sheet in excel

Run ablebits duplicate wizard in excel

Remove duplicates +1 (original)

 

What is left is those that never opened your email. Load them back into constant contact to do a seperate email to those.

Or do what ever you want with them

Thanks for that work around Dennis while we continue to work on a Did Not Opens report.  I want to also reiterate that someone that opens your email and is not displaying images in their email program will not be counted as an open unless they click on a link.  This is how every email company tracks opens.  So, it is possible to have people that will tell you they opened and read your email but they still appear as if they did not.  This is why we do not recommend removing everyone that appears as having not read your email.

 

Over the course of several email campaigns you can assume that those people that have images turned off will always have them off and those that have them on will always have them on, so you can track the improvement in open rate over time. 

 

Thanks,

Jonathan

Jonathan Mandell
Product Manager - Reporting and Analytics

For anyone interested I will be holding a webinar next Tuesday from 4-5 EST where I will walk though some new reporting concepts.  You have all been great at giving me some valuable feedback, so I would love it if you could join me.  There are only 15 spots open so please register.

 

 http://events.constantcontact.com/register/event?llr=v58u9ghab&oeidk=a07e5sn5rmreea09af6

 

Thank you so much,

Jonathan 

Jonathan Mandell
Product Manager - Reporting and Analytics
Frequent Participant

First off I am glad I found this post as I like many of the users have been looking for a better way to do this. Thank you for all the CC Staff replys as well, they've been quite comical in answering all the customer concerns without actually addressing the concern. The one post early one nailed it on the head. If CC has better list hygiene features then people will have smaller list and thus not have to spend as much.

 

Theres a saying in Marketing about how many people a happy customer will tell versus how many people an unhappy customer will tell.

 

I suggest you take a look at Benchmark Email. They are copying you for the most part so perhaps you should copy them on three great points. First they put it right in every customers face that they want CUSTOMER feedback to drive innovation and product upgrades/changes. Second, they listen (my "account manager" is abysmal). Third they have a feature that will automatically delete subscribers that dont open your emails within a set number of campaigns (5, 10, 15 ,etc).

 

Im currently demoing them for a potential switch. We will see what happens. Oh and iContact your third competitor is coming down the pipeline with an equally powerful list hygiene tool. Your welcome for the competitive intelligence.

''First they put it right in every customers face that they want CUSTOMER feedback to drive innovation and product upgrades/changes. Second, they listen (my "account manager" is abysmal). Third they have a feature that will automatically delete subscribers that dont open your emails within a set number of campaigns (5, 10, 15 ,etc)''.

 

I would welcome this, this is exactly what I would want to save me sending emails which are never opened, and more importantly NOT PAYING for emails which are never opened!

 

Thanks for the information BryonW, it seems I and many others may also follow suit and demo Benchmark for a potential switch if this isn't something CC can deliver but they can

Frequent Participant

Anytime Sue. I would recommend if you do demo it to just demo the heck out of it and try and break it to get the full experience. I am noticing some clunkiness with Benchmark so far, but that list hygiene feature is so attractive I am trying to see if I can work through the kinks. Hopefully I can.

 

Ill be curious to see what iContact comes up with. The big four (email marketing services) all seem to do 50-75% right, as Ive used 3 of the 4 and one just wishes one of them would get that final piece. iContact could be the first but they were saying maybe mid 2012 the hygiene function would be ready.

Hi All –

 

I wanted to jump  in and thank you for the lively discussion here.  As I think Jarrad or Marissa said, here or on other posts, we are always looking for feedback, and I can assure you the team working with you in the Community here is continuously providing your feedback directly to the product team.  As advocates for the customer, you have some pretty amazing representation in these two and your ideas are fed into the teams here that can have an impact.

 

With new features coming to market every few weeks, the product teams here is feverishly working to include both small customer delighters and large projects into each release.  The concerns and ideas for improvement in this thread have been shared. 

 

We are also looking at new and better ways of getting your feedback.  As this is your Community, we’d like to keep the moderation to a minimum, however, if you’d like to post about competitors – either positive or negative – you might want to find another forum.  Please connect with me in a private message if I can be of further assistance.

Thanks!

Rosalind Morville
Frequent Participant

Great Forum!  I too.........a long-time user of CC since 1999!  And desperately want a way to delete ALL subscribers NOT opening my Newsletters!  Personally?  I feel:  Shame on CC for NOT offering this tool!  I guess I will spend the next week exploring iContact and others.........I am very disappointed in CC not offering this tool?  Sam in Henderson  HOA1234.com and over 200 other websites!  http://www.HOA1234.com 

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. 

-----

 

Hello Sam,

 

I apologize that we do not have a tool that would automatically remove contacts who do not open nor a tool that would allow you with one click to remove those contacts.  That is something that we are looking into but at this time, the only way to do this is a few step process.

 

Here is a FAQ on how to location contacts that do not open your email and how to remove them from a list.

 

Just a note...We only report opens as those that open in HTML version AND allow the images to be viewed.  Your open rate may in fact be higher than what you are seeing and therefore some contacts may be opening but they are not being reported as so due to not viewing images.  I know that with Outlook and Gmail, you sometimes have to click to allow images.

 

I hope that helps!

Frequent Participant

Marrissa!  Thank You for such a prompt reply!

 

Hmmmmmm?  OK..........I will try to follow your instructions.......and the image thing?  I never would have given that any thought......but now that I think on it?  Yahoo Mail does have that feature on every e-mail............sigh. 

 

Seems everything is getting so very complicated any more?  I feel for you and CC ........but?  I am enthused that the 'Internet" is definitely KING!  More and more people watch their TV Shows on their computer!  That is reason why our Newest Website:  http://www,HOATV.co will hopefully garner tens of thousands of subscribers Nation Wide!  Yippee!......Sam in Henderson

Frequent Participant

Whoops............  http://www.HOATV.co 

You're welcome Sam!

 

Here is a link to show how you can enable your email client (Yahoo, etc) to display images automatically without having to click that link every time you get an email.

 

You can always share this information with your contact base as well so that we can track that they do in fact open.

 

Hope that helps! :smileyface:

"We only report opens as those that open in HTML version AND allow the images to be viewed."

 

I believe that clicking on a link in an email even though the images are disabled also constitutes an open.

 

Tony Schaefer
Constant Contact Solution Provider and SMS Marketing Specialist
www.cliquemarketing.biz


Regular Participant

I came into the forum to ask this very question.  I too want to delete people who are not opening my emails.  I have averaged about 2400 contacts since signing up with CC.  Yet, I only get about 10 - 15% opens depending on the topic.  I have asked several people who also use CC what their open rate is and it seems to be the average across the board, which leaves me to believe a lot of emails are either not making it to the intended recipients, or are being dumped into spam folders automatically.  Whatever the reason, I would rather pay for the 240 - 300 people who consistently open and forward my emails, than to pay for 2100, that are not.  The extra $15 a month may not seem like much to some, but for me it is alot, x's 12 that's $180 a year I am flushing down the toilet.

 

This is why I will not recommend CC to others.  I love everything else about the product but this issue is a deal-breaker.

 

I am trying to connect with a former co-worker who had a macro that allowed us to compare data in multiple rows of a spreadsheet, thereby isolating the "single" records.  This woul make it easier to delete the unused emails adresses.  If I get the info I was share.  In the meantime, I'll do downloads, sorts, and then delete one-by-one.

Frequent Participant

Hmmmmm?  I have owned two Yahoo Stores since 1999 http://www.ArizonaIndianJewelry.com ,,,,there are now approximately 45,000 Yahoo Stores  ...their Forum is here:  http://www.yourstoreforums.com/showthread.php?t=49973&highlight=constant+contact  and they are also trying to cut costs anywhere they can to survive this very bad economy!

 

I get a kick out of CC soliciting input from their customers to make CC better?

 

Well?  Please CC?  Give us this option!  I seriously feel CC is being foolish in thinking offering this will make them loose money?  Au Contraire CC!  Please give us this 'tool' to make CC yet a better value!

 

Sam of http://www.HOA1234.com