Points Bank - Loyalty 2.0 [OLD]
This is the old method of tracking points and is no longer maintained, See below a comparison of tableau and the points table and look out for the new page for process and updates
New Page : Points Bank - Points Table [DONE]
How to track Points bank for Weekly execution
Instructions
Here are the resources to be updated each week:
Pull points data from Tableau https://reporting.rbi.com/#/views/PointsBankDashboard/PointsBankDashboard?:iid=1
Run this Notebook (https://dbc-9601831d-0d70.cloud.databricks.com/?o=2399142386962378#notebook/2280035661040204/command/3618400030029503) and copy the data into the excel below
This Notebook is on a scheduled job to refresh the tableau dashboard as well
Job : https://dbc-9601831d-0d70.cloud.databricks.com/?o=2399142386962378#job/16033
Excel to be updated : Points Bank Tracker.xlsx
Update the data you get from notebook into this tab in Excel : Data - Points Dash Sum
Refresh the pivot table with correct data ranges in this tab : Weekly Execution Slide
Insert a Row in column E - J and copy the formulas into it
Make any adjustments as necessary
Refresh the chart on the page
Known Diners - this data point comes from ??
Total Points = Base points + Bonus Points
Points Per guest = Total Points / Known Diners
All points are sum of daily for each week
Since we lost access old env @Lavanya Davluri has a copy to the old notebook