Tuesday, July 13, 2010

Google Analytic Continue

After finishing my first round of my Google Analytic Project, I suddenly had an idea, why not compare my own weekly aggregation results to the one provided by Google and to see if I am getting correct calculations. So I started to use the Google Analytic Query Explorer, entered all the parameters and get the data back right from the Query Explorer. The next thing I found was that, the data was not matched. I started to investigate. First I ran a query with ga:pagePath in the dimension, that should give me all the user visiting numbers over a week. I copy the data from Query Explorer into XLS and do the SUM function. Well this time I got the same result as in my own calculation. I started to think something fishy from Google. Then I do another test, I found something is more interesting, the visiting number for a particular path in the same week is displayed differently for the different time range. In other word, they should have displayed the consistent data for the same week regardless the difference of time range. So I am guessing that it is worth of opening a ticket to Google. So I did and after a while, I am happy that they are accepting the ticket and investigating the issue. The ticket can be found in the following link
http://code.google.com/p/gdata-issues/issues/detail?id=2100