Google Analytics

Dataddo's Google Analytics connector enables simple data extraction without writing a single line of code.

Automatic Data Synchronization

Our Google Analytics connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.

Available metrics and dimensions

Our Google Analytics connector supports all the fields available in the official API. Full list available here: https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/

Combining metrics and dimensions

Not all the available metrics and dimensions can be combined together. If the chosen combination is not possible, it will result in the connector error. Please proceed to the following link to check the mutual compatibility of the chosen metrics and dimensions: https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/

Limits

Google Analytics API has a data extraction limit of 10 000 rows per single request. Our connector features automatic pagination, so the data extraction is distributed into multiple calls, so the extraction limit can be effectively increased to 250,000 rows.

Multi-account extraction

Our Google Analytics connector supports automatic extraction from all the available Google Analytics accounts. This feature is particularly useful when you have multiple accounts and need to automatically extract the same metrics and dimensions across them (e.g. online agencies) 

Creating a Google Analytics Data Source

To create a Google Analytics data source, navigate to Sources at the top left of the Dataddo app.

Top Bar Marked-png-1

Then click on New Sources from the top right corner.

Source Selection Page-png-1

From the list of connectors, choose the Google Analytics connector.

search

You will be redirected into the Google Analytics connector. First of all, you will need to give Dataddo authorization to connect with your Google Analytics account. Once you click on Authorize, you will be redirected to your account to log in.

configure account

Having a problem with the authorization process?

You can contact us or create a ticket and we will add it for you if possible

After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more Google Analytics accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu. Once you select the account you will also have to select the Analytics Account, the Property, and the View.

account

Next, you can name your data source, and select the attributes that you require.

NOTE:  You can only select 10 metrics and 7 dimensions per source

attributes

Missing metric or attribute?

If you feel like some metrics or attributes that you would like to use are missing, you can contact us or create a ticket and we will add it for you if possible.

The next page is for optional fields such as filters, segments, or the view ID. You can fill any of them or leave them empty and click Next.

optional

TIP: If you are planning to use our multi-account extraction feature to extract data from multiple Google Analytics accounts, you must have the Include View ID option turned ON, to be able to identify which records belongs to each account when doing your data analysis.

On the snapshotting page, you will set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
  • Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
  • If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.

snapshotting options

Lastly, you configure your snapshotting preferences, choosing Data range (if available), Snapshotting frequency, and Snapshotting retention. 

snapshotting configuration

Now you are all set and ready. Click on See Preview to review all the selections you've made before saving the Data Source using the button in the top right corner Save source.

preview

Your new source is now created. You can click on Add source to a flow to bind the source with a flow. To create a flow, please follow our Creating a data flow guide.

Visual example

video