Forum Moderators: martinibuster

Message Too Old, No Replies

AdSense calculations of averages wrong

         

Xoc

3:44 am on Apr 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



On the reports page, Google doesn't calculate the averages correctly when the period includes the current day. The average Page Impressions, Clicks, and Earnings are all wrong.

The problem is that Google calculates the averages using an integer number of days for the period. But if the period includes today, then it gets counted as as a full day, even though only a part of the day has occurred.
The only time the averages are calculated correctly is when it is near midnight.

For example:

Let's suppose that today is the 15th day of the month and you run the report for "this month". Also suppose that through the first 14 days of the month, the site has produced $100 in income, or $7.14 a day. If you run the report at 23:59 on the 14th, it will report that the average income is $100/14 = $7.14. At 00:01 on the 15th, it reports that the average income per day is $100/15 = $6.67. Only two minutes have passed, yet the average income per day has dropped $.47 a day in their calculations.

The problem occurs because of integer arithmetic. If they used a floating point number for the numbers of days in the period, the problem goes away. At 23:59 the math would be $100/13.99930 = $7.14. At 00:01 the math would be $100/14.00069 = $7.14. At 6 a.m. they should divide by 14.25, at noon 14.5, at 6 p.m. 14.75, not 15 throughout the whole day.

The same is true of Page Impressions and Clicks.

I sent a bug report to Google.

Sunflux

4:42 am on Apr 15, 2004 (gmt 0)

10+ Year Member



As suggested by the often extremely lagged reporting, I'm not sure that the programs making the calculations even have the possibility of knowing what percentage of the day the numbers account for.

Dpeper

4:48 am on Apr 15, 2004 (gmt 0)

10+ Year Member



You look at those stats? I dont even bother looking at them any more(there so lagged). I just wait till the end of the month and look and see how big of a check I am expecting.

FromRocky

5:18 am on Apr 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I just wait till the end of the month and look and see how big of a check I am expecting.

One a month? Are you sure? It updates within 24 hrs.

Jenstar

5:35 am on Apr 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



This has been one of those annoying things Google has always done. You have to go and select the period by dates if you want to exclude the current day when calculating anything from the current month.

Dpeper

9:57 pm on Apr 18, 2004 (gmt 0)

10+ Year Member



I might of been being a little, sarcastic. :)