Hi Everybody, I discovered significant differences in Ad-report statistics compared to the actual statistics!! Feedback on this thread would be highly appreciated. ??Question: Where do the differences in the written below statistics come from?? Ad report statistics : Clicks: 56 Impres: 9073 CTR: 0,62 % AvgCPC: $5.27 Cost: $295.04 CostPerConversion: $251.13 Conversions: 1 Conversion Rate: 2.27% Adwords calculates: Cost --> Clicks x AvgCPC ConversRate --> Conversions / Clicks Cost per Convers --> Cost / Conversions I was creating a Ad-report template in Excell with the above formulas on the Cels and this is what came out: Ad report statistics Cost: 56 clicks x $ 5.27 CPC = $ 295.12-------------------> $ 295.04 ConversRate: 1 Conversion / 56 clicks = 1.79 %-----------> 2.27 % CostperConversion: $ 295.12 Cost / 1 Conversion= $ 295.12--> $ 251.13 Note: I already checked if it had anything to do with decimal's in de AvgCPC but that wasn't the case! Hope we can help each other out on this!! Kind Regards
> Cost: 56 clicks x $ 5.27 CPC = $ 295.12-------------------> $ 295.04 That's simply due to rounding error. If you calculate the CPC to more decimal places, you'll see that you are not paying exactly $5.27 but rather $5.26857. Yet, you are using the rounded $5.27 figure which accounts for the difference in the totals. > ConversRate: 1 Conversion / 56 clicks = 1.79 %-----------> 2.27 % The correct answer is 1/56, obviously or 1.79% rounded off. Where you're getting 2.27%, I have no idea. You say that's what Adwords reports but that would mean one conversion in 44 clicks. A glitch in the system? Check it again tomorrow. It's important to note that stats reported by Adwords are not real time. If these are stats looked at during the day, it could account for the discrepancy in the conversion rate: it was calculated using 44 clicks, not the 56 you saw at the time. I never noticed this in the accounts I managed but then, I don't double-check the calculated figures I see. You do see some strange stuff sometimes which doesn't get corrected. Lots of us have seen click rates over 100% for example. Most times, that just the impressions numbers being updated before the clicks. Of course, you notice that only for a handful of impressions. I've also seen conversions when there was no clicks and no cost so you get 0 clicks in x impressions (0% and $0) and one conversion. If I recall, the conversion rate shows as 0% when it should be infinity. Downloading this data and calculating the rate in a spreadsheet or database will of course show infinity.