Earnings
- Adrian Monk
- Rayand Ramlal
Team | @Adrian Monk @Rayand Ramlal @Rafat Khan |
|---|---|
Reviewer | @Igor Rahal Linkewitsch |
Links | Excel File:
Databricks Notebook: |
Metrics List
Metric and Definition | Query | Comments |
|---|---|---|
Mobile Order & Pay (“MO&P”) | SELECT
TH_FISCAL_YEAR,
TH_FISCAL_WEEK,
SUM(AMOUNT) AS SALES
FROM STG.DERIVED_MASTER_TABLE_NEW
WHERE PARTITION_DATE_KEY BETWEEN 'START_DATE' AND 'END_DATE'
AND IS_PASS_THROUGH = 0
AND COUNTRY_NM = "CANADA"
AND SERVICE_MODE_CD IN ('MOBILE ORDER DRIVE THRU', 'MOBILE ORDER EAT IN', 'MOBILE ORDER TAKE OUT')
AND LEFT(REGISTERED_ACCOUNT_ID,7) = 'us-east'
GROUP BY 1,2 | Included in known diner sales & digital sales. |
White Label Delivery (“WL”) Delivery sales initiated from the TH mobile app | SELECT
TH_FISCAL_YEAR,
TH_FISCAL_WEEK,
SUM(AMOUNT) AS SALES
FROM STG.DERIVED_MASTER_TABLE_NEW
WHERE PARTITION_DATE_KEY BETWEEN '$START_DATE' AND 'END_DATE'
AND IS_PASS_THROUGH = 0
AND COUNTRY_NM = "CANADA"
AND SERVICE_MODE_CD IN ('WHITE LABEL DELIVERY','DELIVERY')
AND LEFT(REGISTERED_ACCOUNT_ID,7) = 'us-east'
GROUP BY 1,2 |
|
3P Delivery Delivery sales initiated and fulfilled by third-party delivery providers, such as UberEats, SkipTheDishes and DoorDash | SELECT
A.PARTITION_DATE_KEY,
SUM(A.AMOUNT) AS SALES
FROM STG.DERIVED_MASTER_TABLE_NEW A
INNER JOIN TLOG.TLOG_SALE_TICKET_TENDERS B
ON A.TICKET_ID = B.TICKET_ID
WHERE A.PARTITION_DATE_KEY BETWEEN 'START_DATE' AND 'END_DATE'
AND IS_PASS_THROUGH = 0
AND COUNTRY_NM = 'CANADA'
AND TENDER_NAME IN ("UBER EATS CREDIT","Credit Uber Eats","Uber Eats Credit","CRÉDIT UBER EATS","SKIP CREDIT","Skip Credit","CRÉDIT de DoorDash","CRÉDIT DE DOORDASH","DoorDash Credit","DOORDASH CREDIT","Crédit de DoorDash","Doordash")
GROUP BY 1 |
|
Kiosk Sales via Kiosk; can be split into registered and un-registered Kiosk sales using left(registered_account_id,7) = ‘us-east’ | Restaurant list as of Jan 2025 | |
Catering Catering sales | Includes all types of catering | |
Loyalty In-Store Sales from regular loyalty scans in-restaurant. Excludes MO&P, WL delivery, catering, and kiosk |
| |
Mobile Order & Pay (“MO&P”) Weekly Offers Total Mobile Order & Pay ticket sales with a weekly offer used on that transaction |
| |
White Label Delivery (“WL”) Weekly Offers Total White Label Delivery ticket sales with a weekly offer used on that transaction |
| |
Loyalty In-Store Weekly Offers Total Loyalty In-Store ticket sales with a weekly offer used on that transaction |
| |
Total Weekly Offers Sum of MO&P weekly offers + WL weekly offers + Loyalty In-Store weekly offers | Sum of MO&P weekly offers + WL weekly offers + Loyalty In-Store weekly offers |