How to get Google Ads performance data into Google Sheets

Google Ads is a simple pay-per-click service that allows you to create and run ads for your business. If you run and manage multiple Advertising campaigns tracking the performance of all those campaigns from different Ad accounts would become a tedious job.

With Two Minute Reports we make it easy to get performance data from all your campaigns across multiple Ad accounts into your own Google sheet. In this tutorial, we will show you how to pull Google Ads performance data into Google Sheets using Two Minute Reports without writing a single line of code.

Step 1: Install and Launch Two Minute Reports

Install Two Minute Reports, if you have not done already.

Sign in to any Google Sheet and go to Add-ons -> Get add-ons.

Search for Two Minute Reports and select Install.

Review and accept the permissions necessary to run Two Minute Reports. Two Minute Reports will be installed for you with the e-mail you are sign in to Google Sheets.

Open Google Sheets and go to Extensions -> Two Minute Reports -> Launch.

Step 2: Connect Google Ads to Google Sheets

Navigate to the Data Sources section, click on the Add + button at the top right corner to display the new Data Source form.

Name your data source and select Advertising -> Google Ads from the dropdown. Or type it in the search bar.

Click on sign-in to link your Google Advertising account with Two Minute Reports. If you get an error message do check if you have signed in with the correct Gmail account that is linked with Google Ads. Once you save your Data Source you can use this Data Source to query your Google Ads data in any spreadsheet.

Step 3: Getting Google Ads performance data in Google Sheets

To pull Google Ads performance data you start by creating a new query by navigating to Data Queries and clicking on Add new.

A query form will be displayed where you can name your query. Enter a name for your query. Select the Data Source that you have added from Step 1, and select a Google sheet to populate Advertising performance data.

After selecting Data Source you will get dropdowns with Ad accounts , Metrics , Dimensions. Select an Ad account or multiple Ad accounts you want to pull data for, also select the metrics, dimensions and date range and click on Run query.

Upon clicking Run query your Advertising data will be pulled from your Google Ads account into the sheet you have selected as shown below .

Run query Google ads

Once a query is added, you can make it refresh the latest data automatically by going to the Schedule Refresh section and adding a schedule.

Step 4: (Optional) Schedule Automatic data Refresh and email

Once you have fetched data once, you might want to get new data from your database at periodic intervals. You can do this creating a new schedule under the “Schedule Reports” section. You can schedule updates hourly, daily, weekly or monthly based on your needs.

You could also create a report and ask Two Minute Reports to email that report with updated data automatically. Under the email section enter the email Id of the recipients and save your new schedule.

When the time comes, Two Minute Reports will automatically fetch new data from your queries, and email your report to the said recipients. You have freed a lot of your time from mundane reporting tasks.

There are other features with Two Minute Report’s schedule refresh or data refresh feature. You may read our guide How to Refresh Data Automatically in Google Sheets.


Was this helpful?