I compared this site traffic data from Google Trends with the actual statistics recorded by Google Analytics and here’s the result.
The red line represents Google Analytics data while the blue colored line is from the original Google Trends chart.
As you may have noticed already, the data from Google Analytics and Google Trends not only follow a similar pattern, they even match in terms of absolute numbers with only minor variations. Awesome!
If you’re curious to do a similar comparison for your own website, follow these steps:
Step 1. Go to Google Analytics -> Traffic Sources and select the date range from May 1, 2007 until July 16, 2008.
Step 2. Now select the "Graph by Week" option in Google Analytics because Google Trends also displays weekly data in their charts.
Step 3: Export this Google Analytics data as CSV in Excel and divide all the numbers by 7 because we need average data per day while analytics gave us data for the whole week.
Step 4. Plot a line chart using Google Analytics data and resize the chart to give it the same dimensions as Google Trends chart. When the two have similar sizes, place the Analytics chart over the Google Trends chart as in the screenshot. Done.
Why would anyone need Alexa, Quantcast or Compete charts to compare traffic data when Google Trends can offer such accurate results.