0
I'm not sure if I am using the correct technique for this so please forgive me if I am way off.
I have a large range of data from previous email campaigns. I have categorised the campaigns with boolean values (Y/N) for the subject line contents e.g: Subject Line Is Personalised, Subject Line Contains Urgency etc...
I am running the columns as Open Rate and the values as the 'Average Open Rate'. The row labels are the campaign names, and the Report Filters are all of the boolean values.
I am trying to automate the process to get the 'ultimate combination' that will result in the highest average open rate. Is there a way to automate this process rather than going through and manually selected Y/N options for the filters until I find the highest average?
As an example; I'm trying to do something that will end up with the filters in set to achieve the highest combination, something like this:
Subjectline - Personalised Y
Subjectline - Urgency Y
Subjectline - Product Groups N
Subjectline - Discount Value Y
Subjectline - Event Reference N
Subjectline - Contains Brands N
Subjectline - LOLS Y
I understand that for this table it isn't that time consuming to do it manually, but I want to run a similar operation on lager data sets and frequently so it would be awesome if I could automate it.
[Note: This is a x-post from Stackoverflow as I didn't get a response]
OK, please see my answer at your original post... if you think it ok you may remove this post yourself before admin does ;-) – Kenneth L – 2014-07-24T02:44:18.973