Summary

Video Summary

%%html
<iframe src="https://www.youtube.com/embed/RRHhJDpIt8k?modestbranding=1&rel=0&color=white" width="560" height="315" title="BANA 6043 Regork Presentation" frameborder="0" allowfullscreen></iframe>

Written Summary

Our project was focused on improving Regork’s promotional campaigns and coupon use within different demographics. We studied the data made available by completejourney to figure out top campaigns, coupon use over the year and average sales trends within different demographics. Through our analysis we found that campaigns 18, 13 and 8 had the highest total sales generated in 2017. Further analysis regarding figuring out what the campaigns were promoting should be done, to determine why campaigns 18,13 and 8 had such a high lead from the rest of the campaigns. We also figured out that there was an increase in coupons redeemed during the months of August and November. We believe these increases are caused by students going back to school in August and customers holiday shopping during November. People in the age group 45-54 had the highest total coupons redeemed. We also determined that the average sales price did not vary too greatly across the different demographics. Demographics including married couples, homeowners and high-income households did have a higher sales value.

Given our findings our recommendations to Regork are as follows; promotional campaigns and coupon distributions should be introduced during opportune times such as back to school and right before the holidays to generate more revenue. Promotional campaigns and coupons should be targeted towards people within the age groups of 45-54, married and are homeowners, as they have a high spending power and use coupons often. Although high-income households had a higher average sales value it might not be advisable to target that population during campaigns since they might not have much use for them. Instead, Regork can focus more on helping low-income households.

Environment

%load_ext watermark
%watermark -v -p jupyterlab

Python implementation: CPython
Python version       : 3.9.13
IPython version      : 7.31.1

jupyterlab: 3.4.4