How to get Google Ads data in Looker Studio?

Integrating Google Ads with Looker Studio via TMR can significantly improve your campaign performance analysis and decision-making. In this article, let’s see how to connect your Google Ads account with Looker Studio via Two Minute Reports.

Required Permissions: By accessing your Google account, Two Minute Reports can see, edit, create, and delete your Google Ads account and data. To connect your Google Ads account for campaign data analysis and reporting, please click “Allow” when prompted on your login page.

Step 1: Streamline your Google Ads account in Looker Studio

Go to https://apps.gox.ai/. Choose Two Minute Reports for Looker Studio.

  • Select Google Ads from the list of connectors.

  • Next, connect your Google Ads data. Click New Connection to start creating your Connection in Looker Studio.

A Connection is a link between the data source and the Connector. For example, you must use the Google Ads Connector to create a Connection with your Google Ads account to get your ads data.
  • The Adding new connection dialog box appears. Here, you can connect the required Google Ads account in two easy steps:

  • Creating a Connection: Name your Connection and authorize the Gmail account associated with your Google Ads account.

  • Select accounts for use: Once authenticated, enable the necessary ad accounts to extract actionable campaign insights, as shown above. Please note that you can create reports only for the enabled ad accounts. 

And that’s it. You can now configure your Google Ads account to extract meaningful results.

Step 2: Configure your Google Ads account with TMR 

  • In the Query Configs section, click + Add New.
Query Config lets you group multiple accounts, making it easier to view centralized insights in your Looker Studio dashboard.

The Adding New Query Configuration dialog box appears. Name the query config, select (from the list of enabled) ad accounts from the dropdown, and configure your Google Ads report. Once done, click Save.

  • You’ve successfully created a new configuration. Now you can use this Query Config to extract data from your Looker Studio reports.

Step 3: Create a Google Ads report with TMR in Looker Studio

  • After creating the Query Config, click Create Report at the top-right corner, as shown below:

  • Select the Query Config that you’ve created (in our case, it’s ‘Google ads query’) from the list of options. Click Next and choose ‘Create report from scratch’ to open the Looker Studio dashboard.

  • Once the Looker Studio dashboard opens, select your team and the required Query Config from the dropdown. Next, click Connect at the top-right corner.

  • Once you click Create Report, you’ll be directed to the Looker Studio dashboard. Here, you can drag and drop the associated Google Ads metrics and dimensions to analyze campaign insights faster.

  • To make your Looker Studio report compelling, use charts and visualizations. Click Add a chart and choose relevant chart types to configure your dashboard.

For example, you can use bar charts to demonstrate your Google Ads campaign trends and scorecards to highlight crucial KPIs like clicks, ROAS, and conversions. You can also add a date range control to visualize campaign performance over a specific period, allowing you to track changes and optimize strategies accordingly.

Note: When using excessive charts and other visualizations, your Looker Studio dashboard might slow execution. Try our five tips to increase the speed of your Looker Studio reports to optimize the performance of your Looker Studio dashboard.

We hope you found this article helpful. If you have any questions, please contact our support team via support@twominutereports.com.

Was this helpful?