Import Google Ads Data To Google Sheets

“How do I import Google Ads data into Google Sheets?”
“How do I export Google Adwords metrics to Google Sheets?
“Is there a way to sync Google Ads and Google Sheets?

Digital marketer

Google Ads is one of the major marketing channels in the marketing industry. Like other marketing channels, it needs reporting. Whether keywords or ad creatives, marketers invest the time to check the performance of their campaigns.

You CAN import Google Ads data from the API to Google Sheets. You do copy and paste, add new rows manually, until your eyes and fingers can’t take it anymore. It’s an unbearable nightmare. This article teaches how to automate reporting step-by-step.

google ads to sheets9

How To Import Google Ads Data To Google Sheets

To connect Google Ads to Google Sheets, you need a Google Sheets add-on. These add-ons are usually paid add-ons. As mentioned, you can do it manually (for free) to save money. But in perspective, you might want to spend a little bit to save time. You choose.

Use Two Minute Reports in this use case. Two Minute Reports imports data from the Google Ads API directly to Google Sheets in minutes. No required coding skills.

Installing The Google Sheets Add-on

1 – At the top of your Google Sheet, click ‘Add-ons’. Then click ‘Get add-ons’.

tmr 2

2 – Search for Two Minute Reports. Then install it.

tmr 1

3 – You now have the add-on installed on your Google Sheets file.

tmr 3

Import Google Ads Data Source

1 – Launch the add-on. A navigation pane on the right side appears.

tmr 15

2 – Click ‘Add +’ under Data Sources.

tmr 4

3 – Name your data source. Then select Google Adwords. Google Ads is the same as Google Adwords.

google ads to sheets2

4 – Log-in to your Google Ads account.

google ads to sheets3

5 – Link your Google Ads account to the tool. To be sure, allow and give full access to the tool for seamless integration.

Make sure the account you’re giving access to has access to the Google Ads campaigns.

google ads to sheets4

6 – Go through the login process until the tool instructs you to close the tab since the sign-in is successful.

tmr 9

Import Google Ads Data Query

This point in the process is importing data from the Google Ads API to the spreadsheet.

1 – Click the burger icon. Then Click ‘Data Queries’.

2 – Click ‘Add +’.

tmr 11

3 – Name your data query. Then find the Google Ads data source you imported earlier.

4 – ‘Save on Sheet’ is the location of the sheet where the data is imported to. Add “A1” under Cell.

google ads to sheets7

5 – Under ‘Query’, select the Google Ads account you want to get data from. *See further down this blog post to learn how to give permissions on Google Ads.

6 – Select the ‘Metrics’ you want to import. In this example, we use Impressions, Clicks, and Cost

7 – Select the ‘Dimensions’ you want to import. In this example, we use Campaign name and Ad group name

8 – Select the date range to your use case.

As for the checkboxes, you may leave them unticked for now.

google ads to sheets8b

9 – Click ‘Run query’

Viola! You imported your Google Ads data to Google Sheets hassle-free. You can create reporting templates from here depending on your business needs.

google ads to sheets9

In this example, we imported and reported paid advertisements from Google Ads. The number of impressions, clicks, and cost reporting is now within reach. You can adjust the parameters depending on your use cases like keywords. Add keyword text as a dimension under the Query section.

If you’re doing paid search campaigns, it’s valuable to create a keyword and search term report. Paid search advertising is where an advertiser targets a keyword on Google. To create these reports, use Search term and Keyword text in Two Minute Reports. This illustrates the searches and keywords that users typed to end up on the landing page.

Schedule Google Ads Reports

Two Minute Reports has a scheduling function. This means the spreadsheet refreshes the acquired data from the API. Reports are automated even more.

1 – Click the burger icon. Then click Schedule Refresh.

2 – Click ‘New +’.

tmr fb5

3 – Once inside, you can set the terms of the report schedule.

-Name

-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.

-Timezone

tmr li3

4 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.

tmr fb7
tmr fb8

5 – Click ‘Save’.

Scheduling helps when you need to report on Google Ads engagements overtime. No more copy and paste every day, or every week, or every month.

Bonus: How to Add User Permissions on Google Ads

1 – Go to your Google Ads account.

2 – Go to the upper right and click Tools & Settings. Under Setup, click Access and security.

google ads to sheets10c

3 – Once inside, click the plus symbol.

google ads to sheets11

4 – Once inside, add the email address you want to give access to.

Choose at least Read only status depending on your use case. Give Standard or Admin access if needed.

google ads to sheets12

Conclusion – Create Google Ads Reports In Google Sheets Today

This is one of the many add-ons to connect Google Ads data in Google Sheets. These are the current methods to do API integrations between third-party tool. These add-ons cost money but the benefits outweigh more.

Avoid import and export spreadsheet hell. Maintain everything step-by-step in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. Start focusing on important stuff that impacts the business. Hire a web analyst to help you.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 5 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.