Google Analytics

You can enable simple data extraction with the Google Analytics connector in the Dataddo app 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

The connector supports all the fields available in the official API. Full list is available here.

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. On this page you can check the mutual compatibility of the chosen metrics and dimensions.

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, and 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).

How to create a Google Analytics Data Source

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

   
Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Google Analytics. You can type Google Analytics into the search bar to find the connector faster.
Google Analytics - step 3
Number 4 From the drop-down menu, choose your Google Account connected to Dataddo, and then select Analytics Account, Property and View. Click on Next to continue with the setup. Google Analytics - step 4
a) Add new account
If you want to connect a new Google Account, that is not on the list, click on Add Account. You will be redirected to Google Sign In page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Google Analytics - step 4 add new
Google Analytics - step 4b
b) Authorize Google Account
If you have not authorized your Google Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Google Analytics - step 4a
After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector.
Number 5

Choose a Name for your Data Source, select the Metrics, the Dimensions and the Data Labels. To continue to the next page, click Next.

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

Google Analytics - step 5
Google Analytics - step 5a

Number 6

The next page is optional. You can fill Filter and Segment, and select whether you want to include View ID as a column. Click on Next  to continue.

Google Analytics - step 6
Number 7

On the snapshotting page, you can 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.

  • a) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • b) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query or PostgreSQL.
Google Analytics - step 7
Number 8

Configure your snapshotting preferences by choosing your Data range, Sync type, Snapshotting frequency, Time and Timezone. Confirm your setup by clicking on Next.

NOTE: If you need to load historical data, check our guide.
Google Analytics - step 8

Number 9 In the last step you can preview your data. Click on Save and your new Data Source is ready.
Google Analytics - step 9 preview
* Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are: 
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attribute or breakdowns, or their combination - you may not have any values for them.
Google Analytics - step 9 error

Congratulations, your new Data Source is ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you setup the Data Source.