CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Dynamically pick up best Email template depending on results
Pages: [1]

Author Topic: Dynamically pick up best Email template depending on results  (Read 920 times)

crazywolf

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 4.10
  • PHP version: 5
Dynamically pick up best Email template depending on results
April 24, 2013, 09:16:27 am
Hi,
I have a complicated requirement from my client using Civi 4.2

Imagine a campaign needs to be sent to 100,000 people. They need to see which template is good for end users as they don't have that information with them.
To get around this issue, they want to run a particular campaign with 3 sets of email/SMS templates (1/2/3). They will send initially to 5000 people each i.e (5k X 3 templates) = 15,000 emails.

Depending on response i.e. clicks and opens of these 15K emails we then need to pick up the best response out of 3 templates and send remaining 85K using that template.

Here we get 4K opens for template 1, 3K for template 2 and 1k for template 3. We will pick up template1 for remaining 85K emails.

How can I do this?

Thanks

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Dynamically pick up best Email template depending on results
April 24, 2013, 06:07:33 pm
sending a sample mailing to get an idea of which gets best response is good strategy

so it sounds like you just need to get 3 x 5000 approx random contacts?

why not export all the Internal IDs you have for people with emails

fill a new column with 1, 2, 3 etc up to 20

then sort by that col so you have just the 1, 2 and 3

then import each set to a new group

then do your 3x  sample mailing to one of these groups?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Dynamically pick up best Email template depending on results
April 24, 2013, 06:08:05 pm
or are you asking for something clever?  :P
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Dynamically pick up best Email template depending on results
April 24, 2013, 10:19:22 pm
Hi,

I think the ability is there to manually use different templates & then look at the reports & compare the clickthroughs & for 3 sample or even a few more that doesn't sound too bad.

I don't think there is a single report that compares 3 mailings yet. I assume you have an idea how to select your sample groups.

Eileen
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Dynamically pick up best Email template depending on results
April 24, 2013, 11:46:48 pm
Would be nice to have a custom search "sample" that given a list of contacts pick up randomly x from a given group (and exclude another group, the other sample).

-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

crazywolf

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 4.10
  • PHP version: 5
Re: Dynamically pick up best Email template depending on results
April 25, 2013, 02:35:18 am
Quote from: petednz on April 24, 2013, 06:08:05 pm
or are you asking for something clever?  :P
Yeap, I am after something which will pick up best template. I have worked on a product called  Neolane and they have a workflow which can be programmed to pick up best templates on the click thru, open reports dynamically.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Dynamically pick up best Email template depending on results

This forum was archived on 2017-11-26.