Page 1 of 1
Collect Actual Email addresses of those who opened emails
Posted: Wed Mar 10, 2010 12:38 am
by novawagon
I need to collect the email addresses and create a target group of those recipients who opened a mailing I sent out. I know I can see who opened each mailing by domain, but I need the actual addresses so I can create a target group to send future mailings to.
Any help is greatly appreciated.
Thank you,
jp
Re: Collect Actual Email addresses of those who opened email
Posted: Sat Jul 02, 2011 10:01 pm
by marcel
Yes I agree, that would be a great option. I have run PAID mailing systems for a large newspaper publisher, and that option
did wonders for me sending out "special" deal mailings to the best readers.
Re: Collect Actual Email addresses of those who opened email
Posted: Thu Jul 14, 2011 3:00 pm
by maschoff
OpenEMM 2011 R2 will offer default actions for openings and link clicks so that you can trigger specific actions like setting a flag. And based on the flags you can create target groups to identify openers or clickers.
.
Re: Collect Actual Email addresses of those who opened email
Posted: Thu Jul 14, 2011 3:10 pm
by marcel
Thanks for the update Maschoff, very cool
prvaltech, if you would like to discuss my experiences so far, feel free to pm me or via msn found in my profile.
Re: Collect Actual Email addresses of those who opened email
Posted: Fri Nov 08, 2013 5:32 pm
by Anton
It's pretty frustrating that there isn't a button to download the openers or some way to do this with the target groups. It seems as though can be done via sql pretty easily (once you work out what tables are involved!).
You can find your links by looking at the "linkId" in the URL on the trackable links tab, along with the mailingId
You can then export the clickers on a particular link from the table rdir_log_tbl, or just filter on the mailing_id and get all clickers (this probably includes unsubs though).
The openers appear to be in onepixel_log_tbl.
You also get the IP and open/click datetime.