Thanks for pointing out my mistake Tony. I'll fix my post.
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.
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.
Thank you so much,
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
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.
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