We have pivoted to using used a different method to measure offers the impact of the offer for weekly execution.
\uD83D\uDCD8 Key Highlights
There has been these following main changes
Data would be now for ALL RESTAURANTS and not STANDARD ONLY
We account for all offer types ( Weekly targeted offer, Challenges, Triggered offers and even global offers)
The way we measure incrementality has changed from in week offer user vs non offer users to Week over week , offer vs non offer users - see below for more details
Info |
---|
New Net of Control spend lift measurements |
...
...
📏 Step By Step Process
Check the offer IDs in the ‘OFFER LIBRARY’ section of the code in this notebook and run the entire notebook on Monday: https://timhortons-dev.cloud.databricks.com/?o=2205369574251959#notebook/2951651830674594/command/2951651830674675
On Tuesday, this scheduled job runs (https://timhortons-dev.cloud.databricks.com/?o=2205369574251959#job/555457410070667) and will have the results available
Open the latest Tuesday instance of the job run and get the latest week’s results
Create a new folder for the week here: https://rbioffice.sharepoint.com/:f:/t/THDigitalandLoyaltyAnalyticsandOffers/EuRmJCs0_7tEi1xGTsWIgycBtotItb1VRwTU8D3oXeB6Lw?e=TJZYyT
In Excel, add the latest results in the Data Tab and refresh the pivots
Update the chats in PPT: https://rbioffice.sharepoint.com/:f:/t/THDigitalandLoyaltyAnalyticsandOffers/Em7zYFEEmwVJvyDxYaCYYlYBJT7OuNOOcMYYfXttXeL9zA?e=BCLebf
Share results with the team
\uD83D\uDCCB Related Files and Links
...