Complex~38min
The Partner Trap
Partner-sourced deals are closing in 16.5 days. Direct deals take 31.5. The channel team wants to double down on partners. Finance asked you to check the cohort data before the board meeting tomorrow.
Tables you'll query
customersdealsrevenue_eventsreferral_sources
What you'll learn
CTEs (WITH clause)Window FunctionsCohort AnalysisAggregations & GROUP BY