Weighted SEO Rate Calculator
Combine CTR, conversion rates, and other ratios from their underlying counts. Compare the true weighted result with the misleading simple average and download the calculation.
SEO reporting calculator
Combine CTR and conversion rates without averaging percentages
Enter the numerator and denominator for each row. The calculator adds the underlying counts, then divides the totals—the defensible way to combine rates across pages, queries, campaigns, or periods.
Input rows
Use counts, not pre-calculated rates
CTR
Use clicks as the numerator and impressions as the denominator.
Conversion rate
Use conversions as the numerator and eligible visits, sessions, leads, or users as the denominator—consistently.
Do not mix units
Rows must represent the same definition and measurement window. A mathematically valid result can still be analytically misleading.
How the weighted-rate formula works
Combine the underlying counts first: total numerator ÷ total denominator. For Search Console CTR, that means total clicks divided by total impressions. For conversion rate, use total conversions divided by the consistently defined eligible visits, sessions, users, or leads.
The built-in example has 20,000 clicks from 100,000 impressions and 500 clicks from 1,000 impressions. The two row rates are 20% and 50%. Their simple mean is 35%, but the combined result is 20,500 ÷ 101,000 = 20.297%, displayed as 20.3%. The smaller row should not receive the same influence as the row with 100 times as many impressions.
When a simple average is valid
A simple mean of rates equals the combined rate when every row has the same denominator. It can also be the intended statistic when the analytical question deliberately gives each unit equal weight—for example, “What is the average location-level conversion rate?” That is a different question from “What percentage of all visits converted?” Label the unit and denominator so readers know which one you answered.
| Question | Calculation | Interpretation |
|---|---|---|
| What share of all impressions clicked? | Total clicks ÷ total impressions | Combined CTR |
| What is the average page’s CTR? | Mean of page CTRs, with inclusion rules | Each included page has equal weight |
| What share of all eligible visits converted? | Total conversions ÷ total eligible visits | Combined conversion rate |
A correct formula can still produce a misleading report
- Use the same numerator and denominator definition in every row.
- Do not mix date windows, countries, devices, or attribution models without labeling the cohort.
- Do not add duplicated totals to their component rows.
- Do not reconstruct Search Console average position with this calculator; Google defines that metric differently.
- Keep the raw exported counts and note filters, exclusions, and data freshness.
Google defines Search Console CTR as clicks divided by impressions in its Performance report documentation. A current r/SEO example inspired the calculator; the arithmetic is independently reproducible.
Community discussion
Discuss: Weighted SEO Rate Calculator
Have a question, a useful example, or a different perspective? Join the discussion, share evidence, and help other readers reach a better answer.
Be the first to ask a focused question, share a practical example, or add useful evidence.
Ask a question or join the discussion