Community
Showing results for 
Search instead for 
Do you mean 
Reply

Unopened emails report

Accepted Solution Solved
Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom
Accepted Solution

Unopened emails report

A client wants a list of those who have not opened the emails. 

 

Using ACT Emarketing Team account with ACT 18 Premium

 

What reports are avalible and where are they please.


Accepted Solutions
Solution
Accepted by topic author ch1p
‎10-22-2016 02:30 AM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Unopened emails report

[ Edited ]

Currently there is no integrated, one-button solution for looking up these 'no-opens' contacts. This would be a good suggestion for our Share Your Ideas board.

View solution in original post


All Replies
Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom

Re: Unopened emails report

Sorry to chase but someone must know if this is possible. It would be a very poor product if you cannot see who has not opened emails!

Administrator
Posts: 4,024
Country: United_Kingdom

Re: Unopened emails report

[ Edited ]

Hi ch1p, 

 

Yes of course this is possible:

 

  1. Visit the reports area of Act! emarketing
  2. Select the campaign you wish to see the report of.
  3. Click the eye icon in the report overview graph box
    chrome_2016-10-17_13-17-23.png
  4. You'll then be able to see the amount of opens (or non opens) for each contact to which the campaign was sent. This detail can be exported by email to a .csv file.

You can find more information about the reports available in Act! emarketing in our video training library and in this Knowledgebase article.

Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom

Re: Unopened emails report

Hi Gary and thanks for the reply.

 

I found this section but wanted to create a ACT Group of everyone sent a campaign who did not open the email.

 

I could export the campaign and then those who opened and subtract one from the other and then import back to ACT so we can create a group but that seems a huge undertaking and therefore must be missing something.

 

What I expected was to be able to create a lookup from e-marketing directly in ACT so I could create a group and mange the results in sub groups.

 

I may be missing something but this option does not seem to be there.

Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom

Re: Unopened emails report

Hi again Gary

 

Found a work around that was not to labour intensive -

 

Used the History lookup of email to find campaigns as mail shots had been done in up to 10 batches.

Created a group with these in named after the campaign.

Now looked up each batch of response and added to a new sub group which I called opened

When completed looked up opened and tagged a field using edit lookup - replace.

Now went to original sent group and created a lookup, then looked up tagged field by does not contain and narrowed the lookup.

Now created a group for the campaign and called unopened.

 

Not ideal and I am sure there must be an easier way but at least this worked and I have a happy client !!

Administrator
Posts: 4,024
Country: United_Kingdom

Re: Unopened emails report

Hi ch1p,

 

It's not a direct option to look up only these contacts, but still possible to do so:

 

  1. Make sure you have updated your email campaign history from the emarketing menu
  2. Click on Lookup > Advanced > Search on Keywords
  3. Search All records for Contact Histories with the keywords  "Subject: campaign email subject"
  4. Click Create Lookup
  5. Perform another Search on Keywords
  6. Search Contacts in Current lookup for Histories with the keywords "Opens: 0"
  7. Click Create Lookup

The resulting contacts have not opened the campaign email.

Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom

Re: Unopened emails report

Hi Gary

 

Thanks for this - sounds a heck of a lot easier than my work around and will try for remaining Campaign groups.

Bronze Super Contributor
Posts: 1,544
Country: United_Kingdom

Re: Unopened emails report

Hi Gary,

 

That sounds good to go BUT will also narrow down to Contacts who have opened the specific campaign but have not opened another campaign shown in their History.

 

Maybe I'm mistaken but worth a double check for correct results.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Unopened emails report

Ah yes David, you are entirely correct.

 

With this in mind, you'd have to perform the Search on Keywords with only one search command:

So something like: "Subject: Campaign email subject, Sent: Tue 12 07 2016 02:59:49 PM, Opens: 0"

The time should remain the same for all contacts who are sent the email, so copying this detail from one contact who received the email, should allow you to build the query string.

In retrospect, this is the better method, as it's also fewer steps!

Bronze Super Contributor
Posts: 1,544
Country: United_Kingdom

Re: Unopened emails report

[ Edited ]

Hi Gary,

 

I understand your methodology but it's rather cumbersome and would benefit from an integrated Lookup like the 'Bounces' and 'Opt Outs'.

 

Is this possible because as ch1p has pointed out this would be a very useful Lookup to send a followup email campaign to.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org