Connect Google Ads to Looker Studio: Tutorial & Free Templates (2024)

Connecting with Google Ads Account to Looker Studio and Automate It

We will discover all the steps to pull Google Analytics from your Google Ads account and add it to your Data Studio. Our state-of-the-art solution will not only help you automate, extract, and explore Google Ads Looker Studio but also help you save time. Our holistic Google Ads Looker Studio reports will analyze all aspects of your Google Ads account performance, visualize ads data, add to your Google Ads Data Studio, and create reports, so you don't have to write any code. Here's how our Google ads connector works.

1. Use the Two Minute Reports Google Ads Connector for Looker Studio.
2. Then connect Google Ads account to Google Data Studio and complete building Google Ads reports. 

This can be done in two ways.  

Method 1: Use Two Minute Reports for Google Ads Data Studio  

OR

Method 2: Choose from our thoughtfully designed built-in Templates to create a report.

Method 1: Use Two Minute Reports to connect to Google Ads Looker Studio

• Click on Products -> Two Minute Reports for Looker Studio. It will redirect you to the Two Minute Reports page. Now select the Accounts option. 
• The next window will show you the list of teams you are connected to. Choose the one you want to collaborate with.
• You will now be redirected to the Connecters page. It will first ask you if you want a quick tour of using TMR for Google Data Studio. If you already know how to use it, you can click on skip onboarding.
• Now, you will find data connectors for various channels and platform. Select the Google ads connector from the list. 
• Inside the dashboard, select Add New to add your Data Source.

In the next window, give a name to your data source and select Sign in with Google.

• select the account for your Google ads. Authorize your sign in with TMR by clicking on Continue.
• Once you are successfully logged in, click on Query configs > Add New to add your data source configurations.
• Now choose your required Data Source that you have already created. select Next.
• In the next window, set a configuration, select your Google ads account, and select Save.
• Now click on Create a Report at the top right corner to open the “Creating New Data Studio Report window.
• Select the Query Configuration  you would like to use and click on Next. 
• Once you are done setting your Data Sources and configurations for queries, click on Create Report From Scratch.
• Select the team and click on next.
• Verify your configurations and click on Connect.

The next window will show you all the fields and parameters for your Google ads Data Studio report. You can add or eliminate parameters like numbers, text, currency, URL for any field based on your requirement. Once done, click on Create Report on the top right corner and authorize your action. 

• Now your TMR is connected to Google Data Studio. You now have all the metrics and dimensions available on the sidebar and a table showing insights explored from Google Analytics. 
• Now it’s time to add Metrics to the report. You will find numerous metrics like impressions, account ID, clicks, account name, user engagement, account status, etc. Select the required metrics from the drop down.
•  Similarly for Dimensions, you can explore options like date, keyword, text, campaign name, campaign ID, keyword text, users’ visit, campaign start and end date, URL, and all other campaigns related insights. Choose one from the drop down.
• Note that you can also pick fields and parameters for Dimensions and Metrics from the data sidebar and drag and drop under Chart sidebar. 
• Now select Date range control under the Date filter. Choose a range or click on the duration in the drop-down menu.

Now just sit back and wait for Looker Studio Google Ads to visualize Google ads data and create a performance report for you in great detail.   

Method 2: Use Templates to connect to Google Ads Looker Studio

Repeat the first few steps, select data source. Then, click on “Create Report”.

• Set your configurations for data queries and click on Next. You will now see all the Google Ads Google Data Studio built-in templates for Google Ads overview, Google Ads vs Facebook Ads, Multi Data Source Dashboard, Google Ads Monitoring report, Google Ads Visibility overview, and so on. Click on the one that best fits your needs.
• Select the team you want to collaborate with and click on Next.

Pick your configurations for data source and click on Connect at the top right corner.

• You will see the customization window for parameters and fields for your Ads performance reporting. Eliminate or add fields and parameters as per your need and click on Create Report.
• Next, authorize the data export activity and complete creating the report with tables, graphs, charts, and other visualization tools. 
• You can enhance your charts by adding metrics like CTRs, active views, timezone, impressions, shares, views, etc. Choose one from the drop down. Similarly, you can add Dimensions for your performance report. As mentioned before, you can choose to drag and drop from the data sidebar. 

Now let Ads Looker Studio arrange all details and create a comprehensive Google Ads performance report for you. 

Why Connect to Google Ads Looker Studio?

While standard marketing tools give you straightforward performance analytics, you won’t get in-depth understanding unless you apply customized filters and evaluate performance from a 360-degree perspective. Here’s how connecting to Data Studio Google Ads with TMR helps. 

Generate comprehensive and dynamic Ads report

Use Looker Studio to connect to Ads and create reports with real-time data. Analyze ad performance, including clicks, impressions, and conversions, to enhance your advertising ROI.

Automate monthly and weekly reporting process

Simplify report creation with Looker Studio. Automate weekly or monthly updates, easily share reports with your team and stay informed on campaign performance, growth metrics, and KPIs. Save time with automated report generation for consistently updated information.

Increased data accessibility and collaboration

Unlock the capabilities of Google Data Studio for interactive dashboards and reports. Customize visual representations without changing the original data, fostering collaboration. Enable your team to access crucial insights for enhanced campaign planning and strategy.

Top KPIs of GA4 to be used in Looker Studio

Thoughtful use of ads on Looker Studio will not only help you get a holistic view of ads but will give you access to detailed performance analysis. Here are a few things you can explore while analyzing the Ads on Looker Studio. 

Videos

Assess ad performance for videos with  Ads metrics like views, view rate, and watch rate. Improve campaigns with engaging content and targeted strategies. Optimize thumbnail impressions for better view rates and create attention-grabbing videos for improved watch rates.

Conversions

Assess Cost per Conversion, Conversion Rate Percentage, and Value per Conversion to gauge campaigns' effectiveness. Analyze website and cross-device conversions with All Conversions and evaluate Display Network ads' impact on View-Through Conversions. Optimize budget and enhance ad performance with these valuable insights.

Impression share

Track Search and Content impression share, along with Lost IS due to budget or rank. Optimize results by examining exact match impression share and top location performance.

Keyword

Track top-performing search terms and evaluate match types and quality scores in Google Sheets. Use keyword ID in Google Sheets to organize and optimize campaigns for maximum effectiveness.

Analyze keyword effectiveness, track top-performing terms using search term data, optimize match types, and ensure relevance with quality scores. Organize campaigns efficiently using keyword IDs for maximum effectiveness.

Get Google Ads in Google Sheets too!

Two Minute Reports is also available as a Google Sheets add-on. This add-on is designed to simplify complex data analysis and visualization, making the best use of Google Sheets’ tools and features.

This add-on allows the creation of detailed reports and dashboards using insights from Google Ads without the complexity of manual data entry. TMR for Google Sheets also enables users to develop custom formulae in a user-friendly interface. 

With a seamless Google Ads to Looker Studio integration, comprehensive analytical capabilities, and automated workflows, strategic business intelligence has just become quicker and more accessible.