Tricky~23min

The Timezone Ghost

Revenue dashboard shows Monday mornings spike hard every single week. Finance suspects a batch process or fraud. The data says organic Sunday and Monday traffic are identical. So where is the Monday spike actually coming from?

Tables you'll query

revenue_eventsdaily_revenue_report

What you'll learn

SubqueriesDate & Time FunctionsAggregations & GROUP BY
Investigate this case →