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. On Friday, August 22, 2014 7:34:28 AM UTC-4, Ranjith A wrote: > > 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 > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/d1f49502-064c-4bb2-87dd-1e547e3f8ed7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
