Advanced Looker Studio configuration

This reference explains in detail how to configure settings to load data into Looker Studio.

Introduction

When you use the Looker Studio destination, your data is loaded into Google BigQuery, maintained by Adverity.

For more information on using data sources in Looker Studio, see the Google documentation.

Looker Studio does not support overwriting data in the destination with key columns.

Looker Studio does not support the definition of dimension and metric fields. For this reason, all fields you load into Looker Studio are displayed as dimensions in Looker Studio. You can still create reports the same way.

Prerequisites

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

Getting an overview of Looker Studio data sources

To get an overview of Looker Studio data sources, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Destinations.

  2. Click the Looker Studio destination in the list.

  3. In the secondary menu, click Looker Studio data sources.

  4. Click a Looker Studio data source to get an overview of datastreams to which the data source is assigned.

Deleting Looker Studio data sources

To delete Looker Studio data sources, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Destinations.

  2. Click the Looker Studio destination in the list.

  3. In the secondary menu, click Looker Studio data sources.

  4. Select the checkboxes of the Looker Studio data sources you want to delete.

  5. In the top left corner of the page, click the drop-down menu displaying the number of selected Looker Studio data sources.

    Example of the 1 of X selected users (X represents the total number of users).

    Example of the drop-down menu with the number of selected Looker Studio data sources

  6. Click Delete selected Looker Studio data source.

Unassigning Looker Studio data sources from a single datastream

To unassign Looker Studio data sources from a single datastream, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. Open the chosen datastream by clicking on its name.

  1. In the Destinations section, find the Looker Studio destination in the list, and click on the right.

  2. Click Destination settings.

  1. In the Looker Studio data sources field, delete the Looker Studio data sources that you want to unassign from the datastream.

  2. Click Save.

Unassigning Looker Studio data source from multiple datastreams

To unassign a Looker Studio data source from multiple datastreams, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Destinations.

  2. Click the Looker Studio destination in the list.

  3. In the secondary menu, click Looker Studio data sources.

  4. Click the Looker Studio data source.

  5. Select the checkboxes of the datastreams from which you want to unassign the Looker Studio data sources.

  6. In the top left corner of the page, click the drop-down menu displaying the number of selected datastreams.

    Example of the 1 of X selected users (X represents the total number of users).

    Example of the drop-down menu with the number of selected datastreams

  7. Click Remove from data source.

Unassigning Looker Studio destination from a datastream

To unassign the Looker Studio destination from a datastream, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. Open the chosen datastream by clicking on its name.

  1. In the Destinations section, find the Looker Studio destination in the list, and click on the right.

  2. Click Unassign Destination.

  1. Click Unassign Destination And Delete Data.

When you unassign the Looker Studio destination from a datastream, you delete all data in the destination related to the datastream.

Troubleshooting: Data does not appear in Looker Studio after loading

After you have loaded data from a datastream into Looker Studio, your data may not appear in Looker Studio immediately. To resolve this problem, in Looker Studio, in the bottom left corner of the screen, click Refresh fields. The image below shows where this button is located in Looker Studio.

Troubleshooting: Data load into Looker Studio fails after changing the table structure of the data extract

A data load into Looker Studio may fail because of a change in the table structure of the data extract.

The following actions change the table structure of the data extract:

  • You change the data type of a column in the datastream's Data Mapping. For more information on the data types used in Adverity, see Data types used in data harmonization.

  • You change the maximum character length for columns that contain String values.

To resolve this problem, follow these steps:

  1. Unassign the Looker Studio destination from the datastream.

  2. Load data from the datastream into Looker Studio again.