Advanced Looker Studio configuration

This guide 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. Go to the Destinations page.

  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.

Optimizing Looker Studio data sources for large reports

To avoid Looker Studio errors when sending large reports, enable the optimization of large reports. When this setting is turned on, your schema updates are sent to Looked Studio once every 10 minutes. Your data will be available in the Looker Studio with a delay of up to 10 minutes.

To edit your datastreams efficiently, keep this setting off and your data will be available in Looker Studio after the transfer without delays.

To enable large reports optimization for Looker Studio data sources, follow these steps:

  1. Go to the Destinations page.

  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 optimize for large reports.

  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 Optimise for large reports.

    To disable large reports optimization, click Optimise for regular reports.

Deleting Looker Studio data sources

To delete Looker Studio data sources, follow these steps:

  1. Go to the Destinations page.

  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. Go to the Datastreams page.

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

  1. In the Load section, find the Looker Studio destination in the list, and click Actions 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. Go to the Destinations page.

  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. Go to the Datastreams page.

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

  1. In the Load section, find the Looker Studio destination in the list, and click Actions 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 Adverity.

  • 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.