You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
\uD83D\uDCD8 KPI List - Expand for definitions and Code
Known Diner Sales (KDS) - all sales that are made by recognizable guests, i.e we have lotalty card tagged to the guest
Table |
STG.DERIVED_MASTER_TABLE_NEW
|
|---|
Query |
SELECT A.TH_FISCAL_YEAR,
A.TH_FISCAL_WEEK,
SUM(A.AMOUNT) AS SALES,
COUNT(DISTINCT A.TICKET_ID) AS TRNXS,
COUNT(DISTINCT A.REGISTERED_ACCOUNT_ID) AS GUESTS
FROM STG.DERIVED_MASTER_TABLE_NEW A
WHERE
PARTITION_DATE_KEY BETWEEN '<START DATE>' AND '<END DATE>'
AND PERIOD_DT BETWEEN '<START DATE>' AND '<END DATE>'
AND A.IS_PASS_THROUGH = 0
AND A.COUNTRY_NM = 'CANADA'
AND LEFT(A.REGISTERED_ACCOUNT_ID,7) = 'us-east'
GROUP BY 1
|
Known Diner Sales (KDS) - all sales that are made by recognizable guests, i.e we have lotalty card tagged to the guest
Table |
STG.DERIVED_MASTER_TABLE_NEW
|
|---|
Query |
SELECT A.TH_FISCAL_YEAR,
A.TH_FISCAL_WEEK,
SUM(A.AMOUNT) AS SALES,
COUNT(DISTINCT A.TICKET_ID) AS TRNXS,
COUNT(DISTINCT A.REGISTERED_ACCOUNT_ID) AS GUESTS
FROM STG.DERIVED_MASTER_TABLE_NEW A
WHERE
PARTITION_DATE_KEY BETWEEN '<START DATE>' AND '<END DATE>'
AND PERIOD_DT BETWEEN '<START DATE>' AND '<END DATE>'
AND A.IS_PASS_THROUGH = 0
AND A.COUNTRY_NM = 'CANADA'
AND LEFT(A.REGISTERED_ACCOUNT_ID,7) = 'us-east'
GROUP BY 1
|
Metric and definition | Query | Comments |
|---|
Known Diner Sales (KDS) - all sales that are made by recognizable guests, i.e we have lotalty card tagged to the guest |
SELECT A.TH_FISCAL_YEAR,
A.TH_FISCAL_WEEK,
SUM(A.AMOUNT) AS SALES,
COUNT(DISTINCT A.TICKET_ID) AS TRNXS,
COUNT(DISTINCT A.REGISTERED_ACCOUNT_ID) AS GUESTS
FROM STG.DERIVED_MASTER_TABLE_NEW A
WHERE
PARTITION_DATE_KEY BETWEEN '<START DATE>' AND '<END DATE>'
AND PERIOD_DT BETWEEN '<START DATE>' AND '<END DATE>'
AND A.IS_PASS_THROUGH = 0
AND A.COUNTRY_NM = 'CANADA'
AND LEFT(A.REGISTERED_ACCOUNT_ID,7) = 'us-east'
GROUP BY 1
| this metric is used as a baseline to see loyalty sales penetration to our system wide sales |
| | |