Geo-targeting Project [29-25]
Let's directly compare the sales performance between the targeted stores and the rest of the stores.
create table final_results as
sum(total_sales_q1) as sum_q1,
sum(total_sales_q2) as sum_q2,
calculated sum_q2 / calculated sum_q1 - 1 format=percent. as incr_percent
group by target;
Did the code fail?
Copy and run the code below to create the input data sets.
The sales has gone up by an average of 6% for the targeted stores.
The rest of the stores weren't performing very well.
On average, the sales have gone down by about 5%.
It is safe to say that the direct marketing campaign is a great success!