During a recent interview with an analyst working for a big multi-national retail store chain, I asked:
How do you check if promotion of a particular product had cannibalization effect on future Sales of the product or on other similar products?
The response I got was
By simply comparing Pre promotion Sales to Post promotion Sales.
This answer might fetch a good score quite a few Organizations and you might be surprised to see the percentage of analysts who give this answer. However, in any analytically evolved Organization, it will be considered incomplete, if not wrong!
This simplistic analysis works in steady state when there is no impact due to changes is external factors or factors you can not control for. However, this is hardly the case in any practical application. In today’s world, external factors can change overnight and the cost of making wrong conclusions can be hefty.
In this particular example, imagine what would happen if one of your competitor launches a better promotion for same product which causes your Sales to shrink by 50% in case of no promotion and 25% in case you are also running promotion. If you just do a simple pre vs. post comparison, you may end up concluding that the promotion caused your Sales to drop by 25%, while the reality is that it actually increased it by 50% (25% absolute increase on a base of 50%).
[stextbox id=”section”]Challenges with simple Pre vs. Post analysis?[/stextbox]
There are bunch of practical challenges you face in doing a simple Pre vs. Post comparison. How do you account for regulatory changes happening year on year (making it difficult to compare against base of previous years)? Or for Seasonal products (e.g. Ice-cream), how do adjust for sudden heat waves or temperature drops? What do you do when the entire Industry is expanding or shrinking?
In each of these scenarios, a Pre vs. Post analysis might lead you to a wrong conclusion. So, how do you arrive at effectiveness of Sales promotion?
A simple answer to this is performing tests or experiments in order to size the impact more accurately.
While testing is a subject which deserves multiple posts, I plan to cover simplest form of testing in this post. The simplest form of testing is popularly known as A / B testing or Champion / Challenger testing. This is your solution to the kinds of problems mentioned above in this post.
[stextbox id=”section”]So, what is A / B testing?[/stextbox]
Conceptually, it is a simple solution, where you change only the parameter / factor you want to test and run two alternates in parallel to find out which one works better. For example, to answer my initial question, we will find 2 sets of stores similar to each other, run promotion in one set and don’t run promotion in other set of stores. Once we run the test for required duration (to achieve statistical significance), we compare Pre vs. Post for both the sets of stores and find out if promotion has actually benefited the store or not?
The reading you get now will adjust itself for all external changes as long as the 2 sets of stores are similar. Isn’t it elegant?
[stextbox id=”section”]I understand A / B testing, where else can I use it?[/stextbox]
Applications of testing are limited by your thinking. It can help you in situations where coming out with a neat analytical solution is difficult or impossible. Following are just a few such examples:
[stextbox id=”section”]It sounds simpler than it actually is[/stextbox]
In case you have started thinking that this sounds easy, let me warn you. It sounds easier than it actually is. Following are some precautions you need to keep in mind while doing these tests / experiments:
[stextbox id=”section”]What next?[/stextbox]
Hopefully this post gives you a good overview of limitations of simple pre vs. post analysis and advantages of performing tests. Some time in future, I’ll cover multi-variate tests and Design of experiments. I’ll also share the best practices in designing a test.
For now, do let me know if you think you can apply this elegant concept in your respective areas and how can you benefit from it.
Image 2 credit: Maxymiser.com
Hi Kunal, Thanks for writing such a gr8 article.My doubt is that when I launch a mega sale which I want to expose it to every customer (new+repeat) ,then in this case do I have the choice of using any analysis technique for checking the efffectiveness of sale event other than Pre Post Analysis. Regards, AP