Integrate With Looker Studio

Here's How to Integrate Looker Studio with Bionic for Agencies.

Learn in Bionic Academy: Automate Reporting

Bionic has a full integration with Looker Studio which provides you with a virtually unlimited scope of reporting options and presentations directly from your Bionic data.

With this integration, you can connect to your Advertiser data and have the power of Looker Studio to generate dashboards, report presentations, and even custom calculated fields.

In this article, we'll cover:

1. Create a Data Source
2. Configure the Bionic Connector
3. Create Report in Looker Studio
4. Switch Between Data Sources

Create a Data Source

Looker Studio works at the Advertiser level. You will need to create a data source connection for each Advertiser you want to report data on. Here's how to create a Data Source in Looker Studio:

1. In Looker Studio, click on the Create button.
2. Press Data source.
3. Enter 'Bionic' in the search box.
4. Click on the Bionic Partner Connector.
5. Press Authorize. (Note: You may have use the authorize button twice to proceed.)
6. Enter Your Bionic login credentials.
7. Press Submit.

Configure the Bionic Connector

Once the data source has been created and authorized, you will need to set a couple of basic options to configure the connector:

1. Name Your Data Source - Since the data source is specific to the Advertiser, it's recommended to rename the data source to reflect that Advertiser.
2. Advertiser - When selecting an Advertiser, you will be presented with the full hierarchy of Advertisers. You can opt to select just an individual Advertiser. This will give you data for just this Advertiser. Or, for any of the Parent Advertisers there will be an option (with sub-advertisers). Selecting one of these will pull all of the data under that Advertiser and all Sub-advertisers.
3. Currency - By default, monetary data will use the Advertiser's default. You can leave this option blank if the Advertiser's default currency is appropriate. If you need to change the currency, choose the appropriate currency from the drop down menu.
4. Other Actions - Log Off Bionic is currently the only option available in this list. While you do not need to log out of Bionic under normal circumstances, this option is available in case you need Google Data Studio to log out
5. Use Report Template - When selected (it is by default), a report template will be used to display a dashboard of your data. You can use this template as a base to start from, or opt to build a report from scratch.
6. Once options have been configured, click Connect.

Create Report in Looker Studio

Once you have set up a Bionic Connector in Google Data Studio, it will immediately display the list of fields available for you to use. Here's how to create a report in Looker Studio:

1. Click on Create Report.
2. When prompted, confirm by clicking Create Report.

3. You can use the controls provided in Bionic to change layout, theme, filters, charts, etc.

Switch Between Data Sources

If you have set up Bionic connectors for multiple Advertisers, you will need to choose which Data Source to use for reporting when you go into Google Data Studio. Here's how to switch between data sources:

1. On the Looker Studio home page, Select the Data Sources tab.
2. Click on the Data Source Name.