get cpc based on clicks

[Ranjith A]

Hi All,

I want to get cpc based on clicks. right now its a reverse process is i am using.(means based on the price i am getting clicks) i want same in reverse.

example i want cpc for 500 clicks per month. 

is there any option is there?

Thanks

[Anash P. Oommen (AdWords API Team)]

Hi Ranjith,

Not sure if you are trying to get estimates, or trying to derive one column out of other column values in reports. If you are dealing with existing stats, then some useful formulae are:

Ctr = Clicks / Impressions

Total Cost = Sum (clicks * cpc for those clicks) // since you may have changed your bid in between.

AverageCpc = Total Cost / sum(Clicks)

Cheers,
Anash P. Oommen,
AdWords API Advisor.