Google Data Studio

CREATING A GDS DESTINATION

Note: If you need to use a Service Account for authorization, please see this article.

1. Navigate through Connect > Datastreams and select the Datastream you wish to connect to GDS from the list.
2. In the left-hand menu of the Datastream overview, click Passive Destinations.
3. Click "Open in Google Data Studio".
4. Login and authorize your Google connection.
5. Any manual or scheduled fetches performed on this Datastream will now automatically be picked up by Google Data Studio.

CONNECTING MULTIPLE DATASTREAMS

Google will only accept one Datastream connection to Data Studio at any one time, therefore it is impossible to perform the above steps for multiple Datastreams and have them all export their data extracts to a single instance of Google Data Studio. 

Instead, you can collect all your desired Datastreams into a single Bundle, and then perform the above steps in CREATING A GDS DESTINATION selecting that Bundle in Step 1.

BEST PRACTICE - AVOIDING DUPLICATED DATA

In order to avoid duplicating data entries due to overlapping data collection ranges, we recommend setting the Local Data Retention to Unique By Day:

1. Navigate through Connect > Datastreams and select from the list the Datastream connected to your GDS Destination.
2. In the Datastream Overview, in the left-hand menu under Advanced Settings, click Local Data Retention.
3. In the configuration menu, under Extract Filenames, click the radio button Unique by Day.
4. Key Date Column lists the date/time formatted columns detected within the Datastream. Select the one that should govern the date used to define fetch ranges.
5. Save your settings.

FILE SIZE LIMITATION 

GDS has a hard data limit of 50MB, any extract in excess of 50MB will not be succesfully transferred to GDS. To solve this problem, you would need to breakdown your Fetch data into more manageable sections (e.g. breaking a large fetch into multiple fetches, each using shorter time ranges).