Collect Actual Email addresses of those who opened emails

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

novawagon
Posts: 1
Joined: Wed Mar 10, 2010 12:32 am

Collect Actual Email addresses of those who opened emails

Post 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
marcel
Posts: 3
Joined: Thu Jun 30, 2011 3:59 pm
Location: Amsterdam, The Netherlands
Contact:

Re: Collect Actual Email addresses of those who opened email

Post 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.
Thanks
Marcel Groot
- Grootmedia.com
- Online-traffickers.com
- Reislanet.nl
Ad Operations Specialists
maschoff
Site Admin
Posts: 2602
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Collect Actual Email addresses of those who opened email

Post 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.
.
OpenEMM Maintainer
marcel
Posts: 3
Joined: Thu Jun 30, 2011 3:59 pm
Location: Amsterdam, The Netherlands
Contact:

Re: Collect Actual Email addresses of those who opened email

Post 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.
Thanks
Marcel Groot
- Grootmedia.com
- Online-traffickers.com
- Reislanet.nl
Ad Operations Specialists
Anton
Posts: 46
Joined: Sun Jun 24, 2012 9:58 pm

Re: Collect Actual Email addresses of those who opened email

Post 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.
Post Reply