Predicting the impact of promotions on sales with Google Sheets
Sales season is on. Black Friday and Christmas are traditionally some of the promotion strongest dates during the year. However for many marketing analysts and data driven marketers a lot of uncertainty develops on how to predict the outcome of promotional efforts. Obviously most promotions will probably lead to more orders, but to how much incremental revenue will it lead? Can it even have a negative effect by cannibalizing sales in the time following the promotions? Or is the overall effect positive nonetheless? This guide provides step-by-step instructions on how develop a forecasting model for your business based on past promotions. 
Tags: analytics, dataanalysis, beginners, googlesheets