How to get total AverageCPC?

[Michael D]

Hi,

with reports im gettin the following AverageCPC-Values for one AdGroup for the last 7 Days:

How to get total AverageCPC of this?

4883333 5015000 2626000 4244000 3548000 3305000 5676667

The sum of this is: 29298000 29298000/7= 4185428,57142857 This means 4,185428571 € But on Adwords it shows me 4,04€ Do I miss something there? Thanks in advance. Cheers, Michael

[Dorian Kind]

Hi Mike,

I would assume that AverageCPC is weighted by clicks, not by days. So you would need to take the total cost of this adgroup for the week and divide it by the total number of clicks to get the same result.

Cheers,

Dorian

[Raghavendra Soudala (AdWords API Team)]

Hi Michael,

Generally Average CPC = Sum of costs/Sum of Clicks for that period of time.

So can you try calculating the total average CPC by the following method Sum of total costs(for those 7 days )/Sum of total clicks (for those 7 days ) instead of Sum of average CPC/No of days.

I hope it resolves your problem.

Thanks for your response@Dorian.

Cheers,

Raghavendra, AdWords API Team.