
Re: Chi square for campaign analyses
Kristof Jacobs May 2, 2016 3:28 AM (in response to Kristof Jacobs)no ideas?

Re: Chi square for campaign analyses
Marcus Sommer May 2, 2016 4:33 AM (in response to Kristof Jacobs)I'm not sure if such a statistical approach could be applied to your campaign and if it would be very reasonable. I would rather try a more "classical" method and create a consolidated datamodel from my sales and campaigndata which would contain fields like:
Campaign CustomerGroup #Customer PeriodCluster Days Sales Quota per customer Quota per day X Targets 50 before 30 X Control 1 25 campaign 10 X Control 2 50 after 30 X Control 3 75 long term effects 90 X Control 4 100 to get the quota per Customer/Days which could be then compared against eachother within a campaign and as well as overall.
 Marcus

Re: Chi square for campaign analyses
Kristof Jacobs May 2, 2016 12:02 PM (in response to Marcus Sommer )Hi Marcus
What you suggest is something we already do and now we want to go to the next level ... are the results of the targets significantly better then the control group or not. Which, I think, you would also want to do eventually.
If we can achieve this then we don't need any "classical" method were we would still calculate the Chi² manually :)
As mentioned, we have dozens maybe a hundred campaigns in a year with the ambition to generate a lot more but smaller campaign. It is something I just can't do manually.
Also we apply this method already in R and SAS. Now we want to see what QV can do and it would a shame if I had to calculate is manually in the script (which would be very difficult in the current model).

Re: Chi square for campaign analyses
Marcus Sommer May 3, 2016 3:20 AM (in response to Kristof Jacobs)I think you will need these classical method as a basis for your statistical analysis. Very probably I would create one or two scores (maybe a correlations between targets and controlgroups and/or before/aftersales) on the mentioned quoteresults.
And on these scorelevel you could try to apply various statistically analysis. Whereby you might need to extend your datas with some "invented" campaigns (randomly created customer and productgroups) which fill up your base of data to get a larger basement for a statistical evaluation.
Beside them I'm not sure if a statistical analyses is really helpful. Our experience is that while a campaign the sales for the pushed articles increase significantely but quite often they cannibalize only other products and the overall sales increase not very noticeable and if I then look on the extra cost for advertising, promoters and such things not many campaigns will be successful  from a pure financial point of view ...
 Marcus

Re: Chi square for campaign analyses
Kristof Jacobs May 9, 2016 4:03 AM (in response to Marcus Sommer )I don't want to go into detail how we evaluate campaigns but this is how we do it in other tools for a few campaigns and we want to continue doing this with QV for all our campaigns.
Today most campaign leaders believe they have a positive impact. And I follow you completely that from financial point of view most campaigns won't be a success. And that's exactly what we want to communicate. We want them to experiment with smaller groups (AB testing, control groups), determine which experiment was the best and then send out the whole bulk.
But smaller test mean more evaluations which we won't do manually. Therefore we want to use some statistical analyses to do that job for us.
Today we use Chi² in R and SAS but in QV I can't get it to work with the data in my example.
Is there a way to use the Chi² with the data I gave or what do I need to do the get this working?

Re: Chi square for campaign analyses
Marcus Sommer May 9, 2016 6:07 AM (in response to Kristof Jacobs)Have a look on the statistics chart wizard (menu extras) and a description will you find here on page 769: http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf.
From another community I have also the following informations which might be useful for you (here translated with google):
HI,
Thanks for the answers. Maybe time to bring some light on the matter.
There are two major methods of determination of correlation coefficients:
1. Pearson correlation
2. Spearman's rank correlation coefficient
If my comparisons agree between SPSS and QlikView correl () the Pearson and rangecorrel () the Spearman Correlation (both wellsided). Unfortunately, the manual is silent from it.
So, at first not bad by QlikView. The result is btw. 1 And 1.
1 it says, there is a 100% correlation.
And now for the Pvalue: This is a test which tells us whether this correlation is random or not. So an additional test to check his result. If the value as <5%, it is assumed that the correlation is not accidental. The test is somewhat controversial, but still standard.
Too bad that QT has no equal with integiert. In Excel does that. In SPSS and R, of course.
R integration into QlikView is designed sexy, but who has R views, know that is the very Zeitaufwenig.
I was hoping someone had once the same problem and may already have a formula for it. In the community there is unfortunately nothing useful
I explore just about 5070 different variants in which QlikView always fine me indicates the correlation. But come to the Pvalue for I have to always export the complete data set and import it into SPSS  pretty aufwenig.
LG MichaelAnother possibility might be to integrate R into qlikview: QlikView and R Integration for Predictive Analytics Example.
 Marcus



