Conversion rate
The share of a starting group that completes an action: numerator over denominator, both defined for the same people and period.
FormulaConversion = people who did X ÷ people who could
Try it · 30 seconds · from Atterna’s practice
“Your conversion rate is 52%.”
On Meridian, 52% of registered buyers paid at least once in three weeks, and 4.2% of visits ended in an order. Which is the conversion rate?
Preparing the practice…
How we work it through
- 1
Write the denominator first: visits, visitors or registered users.
- 2
Keep numerator and denominator in the same period and the same population.
- 3
When two conversions disagree, compare their denominators before anything else.
On the practice dataset
The query we run on Meridian, Atterna’s practice marketplace, and what it returns.
SELECT (SELECT COUNT(*) FROM meridian.visit_orders) * 1.0
/ COUNT(*) AS visit_to_order
FROM meridian.visits;Result4.2% of 195,013 visits end in an order; 52% of registered buyers paid in the three weeks of orders — both called “conversion”
The common trap
An unstated denominator. The same word can mean per visit, per visitor or per registered user.
ExampleOn Meridian, 52% of registered buyers paid at least once in the three weeks of orders, while 4.2% of visits in the funnel extract ended in an order. Both are “conversion”.
When an AI answers
“Your conversion rate is 52%.”
- What it didn’t know
- It picked registered users as the denominator without saying so.
- Ask back
- “52% of what — registered users, visitors or visits? Give me the numerator and the denominator.”
Read next
Examples use Meridian, Atterna’s fictional practice marketplace.