Dataddo Use cases, Tutorials, Web analytics

Automated Google Analytics data retrieval using Dataddo

One of the main struggles when doing regular reports using Google Analytics data is the need to conduct daily, weekly or monthly repetitive tasks, usually consisting of dataset definition, setting data range or manually exporting and copy-pasting the data . The whole process might get very time consuming, particularly when managing multiple Google Analytics accounts. To cope with this rather annoying issue, we have developed a solution enabling Dataddo users to programmatically in defined time period retrieve and synchronize data from Google Analytics. In following paragraphs will present a short tutorial how to use this great feature to both save your time and money. In case you want to know more about other capabilities of Dataddo Google Analytics connector, please check this video.

Define query

Providing you already have Dataddo account, go to “Sources” and click on “Add a new source” and select “Google Analytics”. In the Google Analytics connector interface set metrics, dimensions, date range and others according to your preferences.

Google Analytics connector - daily visits

Set data sync

Clicking on “Data sync” section in the Google Analytics connector allows you to define period in which the data should be automatically retrieved. First, set the time zone to make sure the schedule setting is in accordance with your local time. Select the period in which you want to grab the data (daily, weekly or monthly) and set all the appropriate fields – hour and day in week/day in month when fire the data grabbing process.  Also, set the “Data storage” to define the way how you want to store newly retrieved data in each iteration.  You can select either “Clean storage”, meaning that all historic data will be erased or “Incremental storage”, placing the new data on top of existing.

GA data sync

Check everything is up and running

When clicking back on “Sources”, you can see the list of all available sources. You can check date & time (clicking on clock icon), when the process will be fired next time. Also, the log of all past data synchronization activity is available within the overview.

GA sources

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s