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

2 Ways to connect Google ads to Google sheets

Here, we'll show you a step-by-step guide of how we build our comprehensive Google ads Report to analyze what's going on with your current (or past) Google Ads campaigns.. Without writing a single line of code you can automatically pull the latest data from Google Sheets to Google Sheets. Let me show you how to use our google sheets integration for importing data.

First, you can Check out the process to install, Two Minute Reports google sheets add on.

After installing the Two Minute Reports sidebar, we have two different approaches to create our Google Ads Report on Google Sheets.

Method 1: Connect Google Ads to Google Sheets using Two Minute Reports Sidebar.

Method 2: Connect Google Ads to Google Sheets using in-built Templates of Two Minute Reports.

Method 1: Connect Google Ads to Google Sheets using sidebar

• Once you install the Two Minute Reports add-on for Google sheets, you can launch the sidebar by going to the Extensions tab in a new Google sheet.
• Click on the Menu icon near Data Queries and choose Data Sources
• 

  Once the Data Sources section is open, click on Add+ to create a new Shopify Data source.

  

• Name your new Data Source and Select Google Ads from the drop down.
• 

  Click on Sign In with Google to authenticate your Google Ads data source.

  

• Click on Save .
• 

  Once you get a message “Data Source successfully authenticated save?” click on Yes.

  

• 

  Now, select the Menu icon and choose Data Queries.

  

• Start naming your new Query, Select your newly created Google Ads Data Source from the drop down below.
• 

  You can either choose One or Multiple Ad Accounts for Google Ads.

  

• 

  You can now choose your desired metrics from the listed categories below like Performance, Conversions, Videos, Calls etc.. and these consists of Impressions, Conversion values, Video views etc..

  

• 

  Once you choose your Metrics for your Google Ads Report, it is time to categorize your metrics with its specific Dimensions. In dimensions you have categories like Time, Store, Product etc.. which consist of Date, Store name, Product name etc..

  

• 

  Once you have chosen your combination of Metrics and Dimensions, you can move onto the Date Section where you can either use pre defined Date Ranges available or create your own custom Date Range.

  

• Next, Select the Sheet and Cell location for writing the data into your desired sheet and cell location.
• 

  Click on Run Query.

  

• Click on “Yes” to save your newly created query.

You would have your new Query saved in the sidebar and your desired data in the Spreadsheet.

Method 2: Connect Google Ads to Google Sheets using Templates

• Once you have installed the Two Minute Reports Add on for Google Sheets, open the add on and choose Templates
• 

  You can search for Templates and also add individual search filters for categories and Data source.

  

• Once you choose the Template, Click on Use to start mapping your Data Source and Ad Account.
• 

  Start mapping your Template by adding your newly created Google Ads Data Source and Spreadsheet.

  

• Click on Submit.
• 

  Your Template would be ready now. Click on “Go to new Spreadsheet“ to open your Template.

  

• 

  Once the sidebar is open, Click on Run all Queries and all the Template data will be updated to your spreadsheet.

  

Your Template is now ready!

Here! Have a Bonus….. Automate your Reports and Templates

Try out our exciting and unique feature, Schedule Refresh which automates your Reports and Templates to refresh automatically at your desired date, time and duration with a copy sent to your mail. Click here to learn more about Schedule Refresh.

Why connect Google Ads to Google Sheets

When you connect Google Ads with Google Sheets, this integration emerges as a game-changer for businesses and advertisers. This connection empowers you to seamlessly pull data from your Google Ads account into the familiar format of Google Sheets. By leveraging this powerful integration, you significantly enhance your data analysis, streamline reporting, and optimize your Google Ads advertising strategies. Let's delve into the key benefits of connecting Google Ads to Google Sheets, highlighting how this synergy can revolutionize your digital marketing efforts.

• 

  Enhanced Data Analysis and Reporting with Google Ads

  Using the Google Ads integration in Google Sheets unlocks a new realm of data analysis and reporting capabilities. With the versatile tools of Google Sheets, you have access to custom reports to analyze your Google Ads performance, making informed, data-driven decisions. This integration between Google Ads and Google Sheets simplifies the process of extracting data, ensuring real-time updates so your reports are always current with the latest Google Ads data.

• 

  Efficient Management of Multiple Google Ads Accounts

  For digital marketers managing multiple Google Ads accounts, integrating with Google Sheets is incredibly beneficial. This integration allows you to access and consolidate data from various Google Ads accounts into one Google Sheets spreadsheet. Particularly for those with a manager account in Google Ads, this offers a comprehensive view of ad performance across different campaigns and accounts, streamlining the process in Google Sheets and saving valuable time.

• 

  Customizable Data and Metrics in Google Ads

  Google Ads provides an array of data points and metrics. When you connect Google Ads to Google Sheets, you can select specific columns and data points most relevant to your objectives, including adjusting the date range for your analysis. This customization ensures that you're not just collecting any data, but the right data from Google Ads within the specified date range. Whether it's tracking negative keywords, analyzing user engagement, or scrutinizing the cost-per-click in your Google Ads campaigns, Google Sheets enables you to harness and extract data effectively. This powerful feature allows you to focus on specific aspects of your campaigns, such as performance within a certain date range, ensuring that your analysis is both targeted and relevant.

• 

  Automating Google Ads Data Refresh and Report Generation in Google Sheets

  Utilizing Google Sheets to automate the refresh report feature for Google Ads data can save countless hours of manual data entry. By implementing scripts through Google Apps Script or using add-ons, you can automate the import of Google Ads data into Google Sheets, including the refresh report process. This automation not only negates the need for downloading a CSV file but also facilitates making API requests for data retrieval from managed accounts. As a result, your Google Sheets documents are consistently updated with the latest information from your new Google Ads, ensuring that the refresh report feature keeps your data current. This level of automation in Google Sheets allows for timely and informed decision-making, as you're always equipped with the most recent data from your accounts without the hassle of manual updates.

• 

  Easy Accessibility and Collaboration with Google Ads and Google Sheets

  A significant advantage of connecting your Google Ads account with Google Sheets is the ease of access and collaboration it offers. As both platforms are under the same Google account, sharing insights and collaborating on Google Ads strategies becomes straightforward. Team members can pull data effortlessly, edit, comment on, and view Google Ads reports in Google Sheets, fostering an environment conducive to collaborative, data-driven decision making.

Integrating Google Adwords data with Google Sheets offers a plethora of benefits for businesses aiming to elevate their advertising strategies. From comprehensive data analysis to the efficient management of multiple accounts and automated reporting, this connection between Google Ads and Google Sheets is an invaluable asset. Embrace this integration to transform your approach to Google Ads data, leading to more successful and informed advertising campaigns.

The most important Google Ads KPIs to track in Google Sheets?

When connecting Google Ads to Google Sheets, it's essential to export key metrics and dimensions from your google ads account for thorough analysis. In Google Sheets, measure your ad campaign's effectiveness by closely monitoring the cost-per-click (CPC) and cost-per-thousand impressions (CPM) using the amount spent metric in your Google Ads account. Utilize Google Sheets to calculate the Click-through rate (CTR) and the average CPC or CPM, adjusting your campaign's structure accordingly. In Google Sheets, keep a vigilant eye on the bounce rate (%) and user engagements and their rate to enhance your website's user experience, directly influenced by your Google Ads performance.

Performance Metrics

As the name suggests, these metrics are the key identifiers on how your Ad, campaign and groups performance. Using these, a campaign manager can detect flaws or gains on an existing running ad/campiagn and make the necessary changes on the go.

Conversions

Maximize conversions by leveraging Google Ads insights in Google Sheets. In Google Sheets, understand the number, cost, and value of your conversions with metrics such as Cost per Conversion, Conversion Rate %, and Value per Conversion. Analyze both website and cross-device conversions in Google Sheets with All Conversions, and assess the impact of Display Network ads on View-Through Conversions using Google Ads data. Utilize these insights in Google Sheet to refine ad performance and optimize your budget for better results.

Campaign

In Google Sheets, group your Google Ads campaign results by name, status, ID, and serving status. Use Google Sheets to analyze start and end dates, advertising channels, sub-types, and bidding strategies. This comprehensive view in a Google Sheet helps to maximize ROI and understand campaign effectiveness over time.

Account

Organize your Google Ads accounts in Google Sheets by name or ID for a clearer overview of performance. Use Google Sheets to group performance data by currency or timezone, comparing across markets or locations. Monitor account status in Google Sheets to quickly address any issues and enhance operations.

Ad

In Google Sheets, identify ad performance by analyzing ad name, ID, type, status, final URL, image, headline, and description. Use Google Sheets to optimize ad content, keywords, and targeting strategies in your Google Ads (formerly Google AdWords) campaigns. Maximize ROI in Google Sheets by focusing on ads from your Google AdWords campaigns that generate the most conversions.

Ad Group

Use Google Sheets to assess ad group names, IDs, statuses, types, max CPC, and max CPM. Adjust and optimize ad performance in Google Sheets, reallocating budget efficiently. This data in Google Sheets aids in improving ad targeting and increasing conversion prospects while reducing costs.

Impression Share

In Google Sheets, optimize ad reach with Google Ads' Impression Share metrics. Monitor Search and Content impression share, Lost IS due to budget or rank, exact match impression share, and top location performance in Google Sheets. Use these insights to adjust bids and improve targeting in Google Sheets.

Video

Analyze your video ads performance in Google Sheets using Google Ads' video views, view rate, and watch rate metrics. Enhance video campaigns by creating engaging content and targeting the right audience, optimizing thumbnail impressions for TrueView in-display ads, and improving watch rates in Google Sheets.

Keyword

In Google Sheets, delve into keyword text analysis to determine effectiveness. 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.

By connecting Google Adwords data to Google Sheets, you can comprehensively analyze and optimize your advertising strategies, making data-driven decisions that enhance campaign performance.

Get Google Ads data in other tools too

Two Minute Reports enhances the integration of Google Ads with Looker Studio, offering advanced capabilities for data analysis and visualization. This efficient solution enables users to directly import data from Google Ads to Looker Studio, creating detailed reports and dashboards without the complexity of manual data entry. Looker Studio's customization options allow for crafting personalized formulas and layouts, providing a robust platform for handling large datasets from multiple Google Ads accounts. While the integration with Google Sheets remains an additional feature, the focus here is on the sophisticated analysis and visualization capabilities that Looker Studio brings to the table.

The connection between Google Ads and Looker Studio transforms the way marketers access and present their data. This seamless integration bypasses the need for downloading CSV files, streamlining the process of data manipulation and visualization, a step beyond the basic functionalities offered by Google Sheets. By leveraging Looker Studio's extensive formatting options and easy sharing functionalities, marketers can combine data of Google Ads with other sources for a comprehensive analysis, highlighting Looker Studio's superior capabilities in handling complex data scenarios  and offering in-depth insights that go hand in hand with the supportive role of Google Sheets.

Get to know more about Looker Studio integration