P52SQLBeginnerCalculate5 min
Calculate Conversion Rate With the Right Session Denominator
Calculate conversion with purchases and sessions at the same grain.
#calculate#conversion#aggregation
Scenario
A daily table has 1,200 sessions and 48 purchasing sessions. Orders contains 52 rows because four sessions bought twice.
Problem statement
Calculate session conversion rate.
Your Task
- Choose numerator and denominator.
- Calculate the percentage.
- Explain why orders are not the numerator.
Related Concepts
ConversionGrainSQL aggregation
Ready to count this problem?
Mark it complete when you have reasoned through the solution in your own words.