CiviCRM Community Forums (archive)

I do a mass mailing with a link to a Drupal webform.
About 20% of recipients open the email
About 30% of these ( or 6% of total) show as having a click through
About 30% of these have completed the survey.
Any ideas on how to best
1- Send a reminder to the 80% who have not opened the email (and only to these) (data in CiviCRM)
2- Send an other reminder to the ones who have opened but not clicked on the link (data in CiviCRM)
3- Send an other email to the ones who have clicked on the link, but not completed the survey (data in CiviCRM and Drupal)
4- Send a thank you to the 2% who have completed the survey (data in Drupal)

Thanks

Interesting questions. And agree with Eileen re the 'open count' - my estimate is that is well under half of who read.

Even 4/ isn't straightforward that I can see since the table Webform provides is only username, so then you need some trickery to yank out the email addresses of those so you can tag them in civicrm so you can email them again. Keen to hear who knows some tricks for this.

I do a mass mailing with a link to a Drupal webform.
About 20% of recipients open the email

We do the open tracking by embedding a 1×1 pixel transparent image in the HTML part of the email, so – as others noted – this will almost always miss some of the recipients (who are offline when reading, who have their client configured not to show external images, who have the client set to show the text version of the email by default, etc.).

Any ideas on how to best
1- Send a reminder to the 80% who have not opened the email (and only to these) (data in CiviCRM)
2- Send an other reminder to the ones who have opened but not clicked on the link (data in CiviCRM)

You need to look at the contents of the civicrm_mailing_* tables. _job is about the runs taken to deliver the mailing, _event_queue notes events, and the other _event_* tables say what kind of events these were. A sensible join across these should do the trick.

3- Send an other email to the ones who have clicked on the link, but not completed the survey (data in CiviCRM and Drupal)
4- Send a thank you to the 2% who have completed the survey (data in Drupal)

Hm. Import this as a custom data field to CiviCRM and create a smart group, maybe?

peter,
Yes that would work, but it is still a lot of manual operations. I was trying to setup a process that I can use recurrently or even have users use easily.