Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling 7-Day Conversion Rates Query

Hard
SQL & Data ManipulationWindow FunctionsDate FunctionsRunning TotalsAsked 1 times

Problem

Write a query to calculate the rolling 7-day average of conversion rates for three different marketing campaigns for ActiveWizards.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Next questions
7-Day Rolling Conversions by ChannelMediumTranzact Holdings7-Day Rolling Conversion Rate SQLMediumOmnicom Health7-Day Rolling Conversion by ChannelMedium
0 / ~200 words