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.


	Sign in to your Dataddo account and click on Sources at the top of the page.
	Click on Create Source in the top right corner.
	From the list of sources, choose Google Analytics. You can type Google Analytics into the search bar to find the connector faster.
	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.
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.
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. After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector.
	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
	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.
	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.
	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.
	In the last step you can preview your data. Click on Save and your new Data Source is ready.
*	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.