“How do I import Google Ads data into Google Sheets?”Digital marketer
“How do I export Google Adwords metrics to Google Sheets?
“Is there a way to sync Google Ads and Google Sheets?
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.
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’.
2 – Search for Two Minute Reports. Then install it.
3 – You now have the add-on installed on your Google Sheets file.
Import Google Ads Data Source
1 – Launch the add-on. A navigation pane on the right side appears.
2 – Click ‘Add +’ under Data Sources.
3 – Name your data source. Then select Google Adwords. Google Ads is the same as Google Adwords.
4 – Log-in to your Google Ads account.
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.
6 – Go through the login process until the tool instructs you to close the tab since the sign-in is successful.
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 +’.
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.
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.
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.
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 +’.
3 – Once inside, you can set the terms of the report schedule.
-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.
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.
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.
3 – Once inside, click the plus symbol.
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.
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.