Looker Studio destination setup from Coupler.io

Review this guide to learn how you can set up Looker Studio as your destination application for data sources supported by Coupler.io.

Initial Setup

• Select Looker Studio as your destination application
• Complete Authorization
• Create a report in Looker Studio

Advanced setup

• Date range dimension setting
• Advanced settings: Report / data source URL
• Advanced settings: Fields grouping

Initial Setup

1.Select Looker Studio as your destination application

And Click "Continue".

2.Complete Authorization

1.Click the "Generate data source" button:

2.For the first time, you will need to authorize Looker Studio with your Google account:

3.Then, authorize Coupler.io with your Google account:

4.Log in to Coupler.io and authorize Coupler.io: 

5.The Coupler.io data flow you've generated the data source for will be pre-selected. Click the "Connect" button:

3.Create a report in Looker Studio

1.Review fields, update their type if needed, and click "Create Report":

2.Add data to the report: 

3.Set up needed dimensions and metrics, rename the report:

The above steps are sufficient for generating and creating a report from your chosen data source(s) in the Looker Studio.

After they are completed, return to the Destination step setup of your Coupler.io data flow to proceed with an advanced setup, if needed.

Advanced setup

To access the advanced settings, open the Destination section of your data flow, and choose to edit it.

1.Date range dimension setting

Learn how to use the Date range dimension setting in this article.

2. Parameters & calculated fields

3.Advanced settings

Report / data source URL

• If you leave this field empty, clicking "Generate Data Source" / "View results" will create a new Looker Studio report.
• If you want to link your data flow to the specific Looker Studio report, copy your report's URL (or the data source URL in Looker), and paste it into the 'Report / data source URL' field:

Once you define the value here, clicking the "Generate Data Source" button on the data flow's edit page will redirect to this specified link:

Same for the "View results" button: after the data flow's run, you can click the 'View Results' button on the data flow page, and you'll be automatically redirected to the report.

Fields grouping

You can also enable 'Fields grouping' to group columns using the [GroupName]: [Field Name] pattern. To do it, simply enable the 'Fields grouping' toggle:

With this setting enabled, fields will be grouped by the pattern: