Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

How to track Points bank for Weekly execution

\uD83D\uDCD8 Instructions

Here are the resources to be updated each week:

  1. Pull points data from Tableau https://reporting.rbi.com/#/views/PointsBankDashboard/PointsBankDashboard?:iid=1

  2. Run this Notebook () and copy the data into the excel below

  3. Excel to be updated : Points Bank Tracker.xlsx

    1. Update the data you get from notebook into this tab in Excel : Data - Points Dash Sum

    2. Refresh the pivot table with correct data ranges in this tab : Weekly Execution Slide

      1. Insert a Row in column E - J and copy the formulas into it

      2. Make any adjustments as necessary

    3. 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

  • No labels