Skip main navigation

Calculating Projected Lift: Betty Spaghetty

Watch Raj Venkatesan walk through projected lift calculations based on the Betty Spaghetty experiment.
1.1
We looked at conceptually how we projected the test results from Arizona to the national level. Now let’s put some numbers here. We start with the control state, California. So the number of stores in California that were the control stores was about 10% of the chain stores in California. So from there, we project that in that chain, about 1,420 units were sold in California. Next is to know that California represented about 12% of the national sales. So to do that next, what we need to do is take,
49.1
1420 and divide by 12%. And that’s going to give us the total retail sales for the entire nation within that chain, okay? So the next step is then to say this retailer represented 25% of the sales of Betty Spaghetty across the entire nation. So what’s the next step? We’re going to take 11,833 / 25% and that’s going to be the national units sold. So 11,833. Let’s go back to the previous slide and see what was. So 11,833 was the national sales in that retailer and this retailer represented 25% of the national sales. So the national sales across all retailers was 11,833 over 25%.
113.5
The next step is to then say that the test period, the weeks in June and July when the TV ads were run, was 5.5% of the annual sales. So the annual sales expected without the TV ads. Remember, we’re doing the control state projection here. So the annual sales is obtained by taking 47,333 by 5.5%.
152.4
Now, the key thing to remember here is the test was run during June and July. The national campaign is going to run during the holiday season. So what we have to do is take the annual sales number and look at what percent of annual sales are going to happen during the holiday season. Just like I just said, Betty Spaghetty also has a very seasonal pattern in sales. And that’s true for most toys. A large percent of the toy sales happens during the holiday season. Now, for Betty Spaghetty that was about 45%. That’s a large number, right? So the holiday units sold without TV ads is 387,273. How do we get that? You take 860,606 times 45%, okay?
219.7
So this is what we call the base sales. Sales without TV ads. Now from the very experiment. Because we had test and control, we have some level of causal estimate that about 267% lift can be expected, because of the TV ads, because of marketing. So the lift was about 267%. So the number of units that we expect to sell during the holiday season. If we run the national campaign, it’s about 1 million. And that, we get from 387,273 x 267%. This is the expected sales of Betty Spaghetty during the holiday season if you run the national campaign. The keyword here is expected and holiday season. Okay, now what is the break even units?
299.6
So we have to compare the expected sales with the break even units. So what is that? So we had already calculated that. That was about 538,000. So the expected units is about 1.03 million. So should Ohio Art run the national campaign? How do you know that? So we know that expected sales is higher than breaking even units. But there is always a but, the test was run in June and July. The national campaign is running during the holiday season, right? So think about that. What are the implications? Should Betty do this campaign? Should Ohio Art have a national campaign during the holiday season for Betty Spaghetty? Think about that and we’ll be back.
This article is from the free online

Marketing Analytics

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education