How to Create a Report in Looker Studio

After adding your Data Source you can easily create a report in Looker Studio using Two Minute Reports. If you have not already added your Data Source, please check this article to add your Data Source in Looker Studio.

Creating a Report

  1. Go to Looker Studio.
  2. Click Blank Report.

  1. Under Connect to data, search for Two Minute Reports. You’ll be provided with all connectors TMR offers. Alternatively, you may select a data source from the TMR website.

  1. Select the data source you want. In this example, it’s Facebook Ads.

Authorize the Data Source

Info

The authorization process will depend on what tool or data source you want to connect but the overall process is similar. The example below is for Facebook Ads. Two Minute Reports also allow you to connect with other data sources. Check out our connectors page.

  1. Once you select a TMR data source, you need to give authorization and permissions. This authorization process depends on what tool you want to connect to. Authorize Looker Studio first.

  1. Then authorize Facebook Ads by logging into your Facebook account. You may name your data source as well.
  1. Complete the authorization in Facebook. And, you’ll see a popup “Data Source Added Successfully”. Go to our Facebook

Customize Query Configuration

Info

Query configuration is a setting in Two Minute Reports. It’s where you need to choose which account to get data from and other configurations from that data source.

  1. Next is to customize query configurations. Name your query config, select your data source you created earlier, then select the Ad account from Facebook. This is a Facebook Ads example and will depend on what data source you want to connect.
  2. Click on Save.

  1. Authorization should be complete and data source has been connected. The authorization is complete if there are no more blue Authorize button appears.

  1. Click the Connect button on the upper right of the page or click the Add button on the lower right of the page. This connects the data source to a newly created Looker Studio canvas.

Adding Dates and Charts

Once you are on the Looker Studio canvas, you can now add dates and charts on the report.

  1. Click Add a control at the top.
  2. Select date control.
  3. Drag it on the canvas.

  1. Click Add a chart.
  2. Select the time series chart.
  3. Drag it on the canvas.

  1. Click Add a chart.
  2. Select Scorecard.
  3. Drag it on the canvas.

Info

TMR imports dimensions and metrics from your favorite data source to Looker Studio. In this example you can now import the CPM metric from Facebook Ads. You can also use other dimensions like Account name or Ad title which came from Facebook. Check out our connectors page if you want to connect other data sources.

  1. Select a chart you added earlier to modify.
  2. On the right side sidebar click below Metric.
  3. Type in CPM and select it.

The metric from that data source is now on the report.

If you add more charts and a text box for labels, you’ll have something like this:

You can select various Looker Studio templates if you would rather not create a report manually.

Was this helpful?