2 ways to import campaign data from Google Ads to Google Sheets

By Two Minute Reports   •   January 01, 2024   •   10 min read
2 ways to import campaign data from Google Ads to Google Sheets

Loved by 4000+ Brands and Agencies across the globe

/images/client/zynga.png
/images/client/cossette.png
/images/client/lupage.png
/images/client/yelp.png
/images/client/kpimedia.png
/images/client/g2.png

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

  • HomeOnce 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.
  • HomeClick on the Menu icon near Data Queries and choose Data Sources
  • Home

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

    1 gads.gif

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

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

    2 gads.gif

  • HomeClick on Save .
  • Home

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

    x gads.gif

  • Home

    Now, select the Menu icon and choose Data Queries.

    y1.gif

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

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

    3 gads.gif

  • Home

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

    4 gads.gif

  • Home

    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..

    5 gads.gif

  • Home

    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.

    6 gads.gif

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

    Click on Run Query.

    7 gads.gif

  • HomeClick 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

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

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

    8 gads.gif

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

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

    9 gads.gif

  • HomeClick on Submit.
  • Home

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

    10 gads.gif

  • Home

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

    11 gads.gif

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.

Start using these quick templates for google sheets Now

1. TMR: Google Ads PPC Report(Monthly)

This Template provides a detailed comparison of metrics including Clicks, Impressions, CTR, CPC, CPA, Cost, Conversions, and Conversion Rate between two months. It also enhances the user experience by dynamically changing charts, facilitating easy comparison of various metrics.

Description:

1. Month on month % change (select metrics): This section includes a dropdown box that allows users to compare different metrics. It also features a dynamic chart for the current month's data.

2. Top 10 Keywords: This section presents the top 10 keywords, sorted based on clicks.

3. Device stats based on clicks: This section displays the total number of clicks made through different devices.

4. Device stats based on conversion rates: This section showcases the conversion rates from different devices.

5. Monthly performance: This section provides an overview of the monthly performance analysis for the last three months.

2. Facebook Ads, Google Ads & analytics - complete side-by-side Analysis

This template provides a comprehensive overview of data from various sources, including Facebook Ads, Google Ads, and Google Analytics. It serves as a centralized platform for monitoring the performance of your ads across these platforms.

The template allows for easy data comparison between Facebook Ads and Google Ads, based on the metrics selected by the user from the dropdown menu. This comparison can be done on a monthly, weekly, 7-day, 14-day, and 30-day basis, as well as for the last 14 days.

Scorecard charts display the monthly differences in all metrics.

Additionally, the template shows the number of new and existing users for Google Analytics on a monthly, weekly, 7-day, 14-day, and 30-day basis, as well as for the last 14 days.

Scorecard charts illustrate the difference in user count between new and existing users on a month-on-month, week-on-week, moving average, and 14-day overview basis.

A stacked column chart provides insight into the number of new and existing users over the past 3 months.

KPI spreadsheets for each data source offer more detailed information.

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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

What to export from Google Ads to 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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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.

  • Home

    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

tmr_gds.pngTwo 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

Connect other Platform Data Sources with Google Sheets

Facebook Ads

Facebook Ads

Social media ad platform for targeted audience reach.

Linkedin Ads

Linkedin Ads

Professional social media platform's advertising data source.

Snapchat Ads

Snapchat Ads

Social media advertising platform for Snapchat users.

Tiktok Ads

Tiktok Ads

Advertisement data on the TikTok social media platform.

FAQs

How do I export Google Ads to Google Sheets?

You can use our Google Sheets add on Two Minute Reports to get google ads data in google sheets. Please go through the method 1 and method 2 mentioned in this article.

How to automatically pull data from Google Ads to Google Sheets?

You can use our feature Schedule Reports to schedule the queries automatically at your preferred time to automate the whole process without manual intervention.

How do I extract data from Google Ads?

Connect your Google Ads data source using our Google Sheets add on Two Minute Reports and pull the data you want from Google Ads.

How do I extract reports from Google Ads?

You can use our pre-built templates that can be used by connecting your Google Ads data source on our Google Sheets add on Two Minute Reports.