Transferring data to Google Data Studio

This guide explains how to transfer data to Google Data Studio to store and further process information.

Concept

Google Data Studio is an Active Destination. After you set Google Data Studio as the Destination of a Datastream, data is transferred to Google Data Studio each time data is fetched for the Datastream. For more information, see Destination types.

You can assign multiple Destinations to a Datastream. For more information on possible limitations, see Assigning multiple Destinations to a Datastream.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a Datastream whose data you want to transfer to Google Data Studio. For more information on creating a Datastream, see Introduction to collecting data.

Procedure

To transfer data from a Datastream to Google Data Studio, follow these steps:

  1. Add Google Data Studio as a Destination to the Workspace which contains the Datastream or to one of its parent Workspaces.

  2. Assign the Google Data Studio Destination to the Datastream.

  3. Configure transfer settings.

Adding Google Data Studio as a Destination

To add Google Data Studio as a Destination to a Workspace, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Click + Add.

  2. Click Google Data Studio.

  1. In the Configuration page, fill in the following fields:

    Name

    (Optional) Rename the Destination.

    For more information on advanced configuration settings, see Google Data Studio Destination reference.

  1. Click Next.

  2. In Step 1, specify a name for the new Google Data Studio data source.

  3. In Step 2, click Open in Google Data Studio.

  4. In Google Data Studio, paste the data source name into the highlighted field, and then click CONNECT.

  5. Copy the link generated in Google Data Studio.

  6. In Adverity, paste the link generated in Google Data Studio into Step 3.

  1. Click Create.

Assigning Google Data Studio as a Destination

To assign the Google Data Studio Destination to a Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, click + Add Destination.

  2. Click Assign Existing Destinations.

  1. Select the Google Data Studio checkbox in the list.

  2. Click Save.

Configuring transfer settings

To configure transfer settings, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, find the Google Data Studio Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. Fill in the following fields:

    GDS data sources

    Select the data sources in the Destination where to transfer data from the Datastream.

    Action for existing data

    To specify how Adverity loads data from a Data Extract to the Destination if the target table already exists, select one of the following options:

    • (Default) Select Overwrite to remove all data from the relevant table in the Destination before transferring the corresponding Data Extract.

    • Select Append to update the relevant table in the Destination with data from the Data Extract.

    Partition by date

    (Recommended) If selected, the target table is partitioned by a date column, and data is only replaced based on the date. This means that if you import data into a table with data already present for certain dates, the existing data for these overlapping dates is overwritten, and the data for other, unique dates remains unchanged.

    This option is only effective if you also enable the option Local Data Retention > Extract Filenames > Unique by day. For more information, see Configuring advanced Datastream settings.

    Partitioning is set during the first data transfer and cannot be changed through Adverity later.

  2. Click Save.