Monday Offer Notebook Prep
A. Preparing list of guests who viewed the offer in app (takes the longest)
Download Offer User list from Amplitude link (
...
12. Run command 37 to check if the tables are properly uploaded
B. Update email sends
Change dates in the widgets from the measurement offer notebook (
...
3. Add the campaign id in the list below (command 21, “List of Offer Emails to Filter for”)
Tuesday morning update
Master Offer Notebook Update
...
Run All commands after and including 77 – to append new weeks data to the master offers table
Offer related queries
...
a. Change TH_FISCAL_WEEK to include the most recent week
Update Excel (1.Offer Impact_week xx)
Update “Net Loyalty SWS Impact” Tab
...
b. 30 Day Active from “Master Offer Notebook” command 20 “Active Registered Users”
Update Powerpoint
Net Loyalty SWS Impact
a. Click on chart à Chart Design à Edit Data in Excel
...