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
Collect Actual Email addresses of those who opened emails
Moderator: moderator
Re: Collect Actual Email addresses of those who opened email
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.
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
Marcel Groot
- Grootmedia.com
- Online-traffickers.com
- Reislanet.nl
Ad Operations Specialists
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: Collect Actual Email addresses of those who opened email
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
Re: Collect Actual Email addresses of those who opened email
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.
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
Marcel Groot
- Grootmedia.com
- Online-traffickers.com
- Reislanet.nl
Ad Operations Specialists
Re: Collect Actual Email addresses of those who opened email
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.
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.