Funnel conversion analysis
Advanced Data AnalystFunnel analysis is a core framework in marketing analytics: it measures how effectively you convert prospects at each stage of a pipeline and surfaces where the biggest losses occur.
You're reviewing a Q1 SaaS marketing funnel. Each row shows the volume at a stage, from Website Visitors at the top down to Customers at the bottom.
Your task:
For each stage below Website Visitors, calculate three metrics relative to the prior stage:
- Stage conv rate: the fraction of the prior stage's volume that advanced
- Drop-off count: the absolute number lost between stages
- Drop-off rate: the fraction of the prior stage's volume that did not advance
Then calculate the overall end-to-end conversion rate from Website Visitors to Customers.
Need some help?
Hint 1
All three metrics compare consecutive stages: each is either a ratio or a difference between one stage's volume and the one directly above it.
Hint 2
Stage conv rate divides the current stage by the prior one. Drop-off rate is its complement. You can calculate it as 1 minus the conversion rate, or directly as the drop-off count divided by the prior stage.
Hint 3
For the overall conversion rate, think about which two stages represent the very start and very end of the funnel, with no intermediate steps involved.
Funnel conversion analysis
Advanced Data AnalystFunnel analysis is a core framework in marketing analytics: it measures how effectively you convert prospects at each stage of a pipeline and surfaces where the biggest losses occur.
You're reviewing a Q1 SaaS marketing funnel. Each row shows the volume at a stage, from Website Visitors at the top down to Customers at the bottom.
Your task:
For each stage below Website Visitors, calculate three metrics relative to the prior stage:
- Stage conv rate: the fraction of the prior stage's volume that advanced
- Drop-off count: the absolute number lost between stages
- Drop-off rate: the fraction of the prior stage's volume that did not advance
Then calculate the overall end-to-end conversion rate from Website Visitors to Customers.
Need some help?
Hint 1
All three metrics compare consecutive stages: each is either a ratio or a difference between one stage's volume and the one directly above it.
Hint 2
Stage conv rate divides the current stage by the prior one. Drop-off rate is its complement. You can calculate it as 1 minus the conversion rate, or directly as the drop-off count divided by the prior stage.
Hint 3
For the overall conversion rate, think about which two stages represent the very start and very end of the funnel, with no intermediate steps involved.