All Collections
Platform Knowledge Base
Platform
Looker Studio (Google Data Studio) Connector
Looker Studio (Google Data Studio) Connector
M
Written by Marcus Johansson
Updated over a week ago

Introduction

The BT Performance Connector allows users to query performance statistics and then use the data within a Google DataStudio context. It provides the same set of functionality as the performance report view in BidTheatre Studio.

Finding and accessing the connector

The Connector is currently not published in the public marketplace, so it will have to be added manually. The steps are outlined below or use this direct URL:

  • In Google DataStudio, click "Create" and then "Data source" in the left menu:
    โ€‹

  • Click "Build Your Own" option:

  • Paste the following ID into the text field at the bottom of the page

AKfycbw0Rl2Oz9rI7IyKmjBql2-NqdurpksPmQ5lEfivmSRfCh5_YqQySo_4NvshR5zOSOwu2w

Screenshot_2019-06-20_at_14.24.54.png
  • Click the "Validate"-button

  • Click "Select" below the BT Performance connector

Screenshot_2019-06-20_at_14.26.16.png
  • Done, now the connector is ready to be configured and used.

Signing in

You should now see a username and password field that allows you to sign in to BidTheatre.

For this you will need to create a new dedicated api user in BidTheatre Studio.

Proceed and sign in, using the new credentials for the dedicated user. You will now be signed in and the session will stay alive for as long as you're active. The connector will ask you to sign in again if you are inactive for more than 5 hours.

Screenshot_2019-06-20_at_14.27.53.png

Configuring the connector

After signing in, you are presented with a few configuration options that will allow you to control what data will be retrieved.

Screenshot_2020-01-09_at_15.48.34.png

Parameter

Description

Account / seat ID

Mandatory. The account/seat ID the request should be made for.

Advertiser ID

Not mandatory. Denotes the advertiser to retrieve data for.

Campaign ID

Not mandatory. Denotes the campaign to retrieve data for.

Bid Strategy ID

Not mandatory. Denotes the bid strategy to retrieve data for.

Group By

Mandatory. Allows the user to control how the retrieved data is to be grouped.

Using the connector in a report

After configuring the connector, click the blue "Connect"-button in the top right corner.

Screenshot_2019-06-20_at_14.31.06.png

You will now see all the fields that will be available in the data sets returned from the connector. To use the connector in a report, click "Create Report" in the top right corner

Screenshot_2019-06-20_at_14.33.25.png

If you see a dialog notifying you about that you're about to add a data source, click the "Add to report"-button.

Screenshot_2019-06-20_at_14.34.29.png

Testing the connector

Ensure that the connector is associated with the report, and proceed to click "Add a chart" in the toolbar. Choose a table and place it anywhere on the report canvas.

Screenshot_2019-06-20_at_14.35.56.png

This should trigger data to be retrieved from BidTheatre and displayed in the table.

Screenshot_2019-06-20_at_14.37.57.png

You can now change the date range, choose fields, change grouping while working with the report.

A note on date ranges

Although not clearly obvious, the data set retrieved is controlled by a date range. The default date range generated by Google Data Studio is last 28 days. As stated above though, the date range can be manipulated later on while working with the report.

Did this answer your question?