View Single Post
  #1 (permalink)  
Old May 19th, 2009, 01:20 PM
ramuis78 ramuis78 is offline
Authorized User
 
Join Date: Jun 2006
Location: Chelmsford, MA, USA.
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default A/B testing 2 or more subject lines

Any idea how to update table with multiple subjects for one email distribution on % basis in ASP.NET/MySQL.

For example: We have a list of 1000 contacts (email addresses) and want to send email with different subjects on percentage basis.

Email body is same.

User selected # subjects, entered subject names and percentages.

Subject 1 : GPS on sale ------------ (user selected - 30%)
Subject 2: GPS Free------------ (user selected - 50%)
Subject 3: GPS - Upto 70% off------------ (user selected - 20%)

i.e

30% (300) of the emails should go out with Subject 1
50% (500) of the emails should go out with Subject 2
20% (200) of the emails should go out with Subject 3

-------------------------------------------------------------------------------------
Current Scenario:

1. All the above settings are stored in distributionsetup table (emailid, contactlistid, subject1,subject2,subject3, percent1,percent2,percent3,datetobesent etc....)
2. System will insert 1000 rows in distributionqueue table with subject1.
INSERT INTO distributionqueue (subject, fromname, fromemail, tofirstname,tolastname, toemail, company, datetobesent, sentstatus etc...)
SELECT 'GPS on sale' subject, fromname, fromemail, tofirstname,tolastname, toemail, company, '2009-05-20 10:00:00' FROM AddressBook where contactlistid= 1;
3. System will send email to 1000 contacts with the same subject (subject1)
------------------------------------------------------------------------------------

Requirement :

We need to update distributionqueue table randomly with following criteria.
50% (500) rows should get updated with Subject 2
20% (200) rows should get updated with Subject 3

Hope i explained well, let me know if you have any questions.

Any help highly appreciated.

Thank you

Last edited by ramuis78; May 19th, 2009 at 11:17 PM.. Reason: Not mentioned clearly