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