MihsabaHow to use
Calculate average actual cost per click from campaign spend and clicks using a consistent currency and reporting period.
- Enter Advertising spend.
- Enter Number of clicks.
- Calculate, then review the results and method assumptions.
How it is calculated
Example
Spend of 150 across 500 clicks gives an average CPC of 0.30. With 750 clicks at the same spend, the average falls to 0.20.
Important notes
Actual average CPC differs from a maximum bid. Do not simply average campaign CPCs: sum their spend and clicks first. Keep currencies and reporting periods compatible.
Worked examples and interpreting results
Spend of 150 across 500 clicks gives an average CPC of 0.30. With 750 clicks at the same spend, the average falls to 0.20.
| Case | Calculation | Result |
|---|---|---|
| First average | 150 ÷ 500 | 0.3 |
| Average at 750 clicks | 150 ÷ 750 | 0.2 |
How to check the result
Actual average CPC differs from a maximum bid. Do not simply average campaign CPCs: sum their spend and clicks first. Keep currencies and reporting periods compatible.
Frequently asked questions
Is the average my maximum CPC bid?
No. This is a realized reporting average, not a bidding setting in the advertising platform.
How do I combine two campaigns?
Add both spends and both click counts, then divide the totals. Each campaign is weighted by its clicks.
Does this convert currencies or import campaign data?
It uses only entered numbers, without import or currency conversion. Align currency, period and metric definitions in your source before entering values.