Wondering how to get unsampled data from Google Analytics into Microsoft Excel? Analytics Edge provides a free solution: the Free Google Analytics Connector included with all Analytics Edge Add-ins has the ability to minimize sampling problems with large sites and long time frame queries (up to a million rows!). Simply add a date dimension (Date, Week, Month), then check the box to Minimize Sampling on the Options tab, and Analytics Edge will make separate queries for each date in the selected date range and merge the results into a single table.
How does this work?
Data sampling occurs in Google Analytics when the data you need for your report involves over 500,000 sessions. Google samples the data to make the report faster and reduce the load on their server. The single most effective technique to reduce sampling is to shorten the time frame for your query (involving fewer sessions). Analytics Edge breaks your request into separate queries with shorter time periods, then joins the results together for you. By using the date dimensions already in your query, all of the metrics reported are accurate — there is no special handling required for average or rate metrics (unlike with other tools).
Mixed time dimensions, accurate data
Note that if you use multiple time dimensions in the query, like Date and Month of Year, Analytics Edge will make queries for the smallest — the Date in this example. You will always get the finest resolution possible, and the most accurate numbers; Analytics Edge always queries Google Analytics asking for the HIGHER_PRECISION sampling level.
Let Analytics Edge take the effort out of your reporting efforts.