Overcoming sampling in Google Analytics with Dataddo

One of the main constrains when using free version of Google Analytics is data sampling occuring in ad-hoc reports. In cases where the query cannot be satisfied by existing aggregates (i.e., Audience overview), Google Analytics computes the requested report from raw session data and if the number of sessions to the property in the given date range exceeds the number of 250K, sampling is employed. This feature is particularly annoying when the size of data sub-set you are after (i.e. visits from specific source) is relatively small (<1%) in comparison to the whole set. In such case, the distortion might be so large, making the final output useless.

The obvious solution to cope with this issue is to shorten the data range. However, this approach usually requires multiple queries and manual merging and processing the data in spreadsheet editor. Fortunatelly you can use Dataddo and its Google Analytics connector allowing you to automatically collect data from Google Analytics in defined period. The data can be incrementally stored and directly analyzed right in the system.

Step 1 : Define data source

Presuming you have already registered in Dataddo, you can utilize Google Analytics connector to programatically gather the data from Google Analytics. Besides automated data collection, the connector allows you to define multiple dimensions and metrics or set advanced filters. You can explore our Wiki to overview the complete functionality of Google Analytics connector.

add_sourcega-connector-incremental

Step 2 : Auto-sync period & incremental data storage

The system allows you to define the period of automatic collection using following parameters :

  • Timezone
  • Hour
  • Day in month
  • Month
  • Day in week

In this case, when we want the data to be collected every day at 01:00, set the parameters to following values:

Hour Day in month Month Day in week
01 Every day in month Every month Every day in week

Also, since we want the data to be incrementally stored, set data storage option to incremental. New data will be placed on top of existing.

Step 3: You are done!

Now, when everything is set-up, you can fully appreciate the vast functionality of Dataddo platform. Feel free to integrate the data with your CSVs, XMLs or perhaps with the data from other Google Analytics accounts. You can check whether the data are being collected properly in import logs.

import-log