Complex~36min

The Invisible Promotion

The Q2 email campaign is being celebrated as a success — orders up 34%. Marketing wants to double the budget. Before you do: 89% of the "converts" had already ordered in the 30 days before the email went out.

Tables you'll query

campaignsusersemail_sendsorders

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY
Investigate this case →