Free weighted CTR calculator for multiple rows
Combine compatible click and impression rows correctly instead of averaging their percentages.
Try your own numbers.
The starting values are illustrative. Replace them with compatible numbers from your report.
Use this tool when a report contains several non-overlapping rows with the same click and impression definitions. The combined rate is calculated from total clicks and total impressions. That gives each exposure the appropriate weight rather than treating a tiny row like a large one.
Work through it, step by step.
Enter rows from one compatible source and scope. Do not combine a total row with its own breakdown, because the activity would be counted twice.
Add or remove rows as needed. Keep each row’s clicks and impressions together and provide a positive total impression count.
Compare the combined result with the simple average shown for context. The difference demonstrates why row-level rates should not be averaged casually.
Make it concrete.
One row has 1 click from 10 impressions and another has 10 from 1,000. Combined CTR is about 1.09%, while the unweighted average of their CTRs is 5.5%.
What to keep in mind.
The tool cannot detect overlapping rows or incompatible provider definitions. Your choice of inputs determines whether the combined figure is meaningful.
Your next useful step.
Use the weighted-rates comparison to review other aggregate calculations. Keep important segment differences visible even when the overall arithmetic is correct.
Working with this in Liftaven
Calculations run locally in your browser. These tools do not connect accounts or send your inputs to Liftaven. Use numbers from the same reporting period and keep currencies consistent. A calculated ratio describes your inputs; it does not establish the cause of a change.
Explore the workspaceSources & context
This note combines original practical guidance with the reporting references below. Follow provider documentation for current definitions and availability; suggested investigations are not guarantees of a particular result.