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