Using Google Sheets for Google Ads Business Data

Google Sheets and AdWords magically work together to make your organization more efficient and more successful. This feature allows users to import Google Sheets external data into Google ads business data.

So, what does this dynamic duo mean for you? It means unlimited options for serving automated and dynamic search ads.

Google Ads Business data is where you provide and manage data sources for ads, extensions, and targeting. This Business data section allows you to quickly review the upload history and the status of your ads. This area also gives you the ability to evaluate overall clicks, impressions, and campaigns associated with your Google Ads account.

The Data Game-Changer

Transferring data from Google Ads to Google Sheets and vis-versa has long been a long manual process. With this capability, organizations are spending less time moving from platform to platform, providing greater efficiency as a business.

New Account Features

With this integration, your Google Ads account will look a little different. When you head over to the Business data section of your Google Ads account, you’ll see a table with your data.

Ad customizer, ad extension, location targeting, and dynamic display ad data can all appear on this page.

While Google previously introduced different versions of dynamic ad capabilities, it wasn’t on this level. Sure, we had Dynamic Keyword Insertion (DKI), which automatically pulled a user’s search query into an ad. We even had AdWords Business data that allowed us to utilize ad customizations. This feature uses a parameter that automatically leverages information from Business data in ads, such as promotional prices.

No More Manual Process

Before the Google Ads to Google Sheets integration, if you had a promotional price change, you had to update it in Excel, then re-upload it to Google Ads. For some of us, promotions needed to be changed daily, making this a very time-consuming task.

This is when the Google Ads to Google Sheets solution comes in to save the day.

Automation Capabilities

As Google Sheets and AdWords work together to allow the automation of the import process (every 6 hours if you want), you no longer need to lift a finger to make changes, such as a price adjustment. Instead of bouncing around from one platform to the next to simply change a price, now you can do so from only one software solution.

Whoever is responsible for updating product prices can change them directly within a Google Sheet, or they can link Google Sheets to the source document used for updating pricing.

One of the best qualities of Google Sheets is that it comes with a plethora of Excel-based formulas and functions. It also includes Google Scripts, which allows you to build custom functions. A wide variety of capabilities are available on Google Sheets, enabling you to connect external APIs, internal CRMs, scrape your own website data, and much more.

Changing promotional ad prices is just one example of the many uses of this Google Ads Business data integration.

Paid Ad Example

Here’s another example that allows us to explore these capabilities even further:

Imagine you own an international donation website called “helpthoseinneed.com” that has a mission to provide food for those less fortunate. Below is an example of your display ad that’s fully automated and dynamic:

The audience sees this ad, but they don’t realize what you did behind the scenes:

• • You used a countdown parameter to end the ad at a designated date
  • You scraped the donation page and used an Excel formula to get your percentage-to-goal
  • You connected to openexchangerates.org’s API to convert your minimum donation ($5 USD) to Euros
  • You customized this ad to use the right messaging to target the country of the target audience
  • You imported your Google Analytics data into Google Sheets to see how many unique donations you’ve accumulated thus far

Customized Solutions

The implementation of this dynamic update can be as simple or complex as you make it. In its most basic form, you can use the Google Ads to Google Sheets data integration to change just one small element within your ad. For something more extensive, you can utilize formulas and Google Scripts to make a truly dynamic and automated advertisement.

Use the following links to learn more information about these topics:

• • Ad customizers
  • AdWords Business Data
  • Import.io
  • Blockspring webscraping
  • Connect Google Analytics to Google Sheets

How to Download Google Ads to Google Sheets

Installing the Google Ads add on for Google Sheets is very easy. All you have to do is download the add-on to your Google account and activate it. Be sure to follow these steps:

1. Go to Google Sheets (make sure you’re using the right Google account.) This web app can be found by going to sheets.google.com, or you can access it in your Google Drive.
2. Click the plus sign located under “Start a new spreadsheet.” This will appear in a small white box with the word “Blank” underneath it.
3. From the top menu, select Add-ons near the right side of the toolbar menu. This is where you can find a list of the add-ons for your account.
4. Click Get add-ons at the bottom of the drop-down list. This is where you go to install new add-ons.
5. A window will appear. Enter “Google Ads” into the search bar at the top of the screen.
6. Click Enter.
7. Select the add-on called “Google Ads.” This is the first option you see on the left side of the page.
8. Click the long blue bar labeled “Install”, which is found near the top center of the window.
9. You’ll then see a list of permissions. After reviewing them, select Allow to install the add-on. This new tool can now be found in the Add-ons list in your Google Sheets toolbar.

How to Link Google Ads to Google Data Studio

Google Data Studio is where all of your vital data makes it home. In order for your Google Ads account to utilize these valuable metrics, the integration must be set up correctly. Be sure to follow these steps to link these two Google accounts:

Select an individual account

1. Sign-in to Data Studio. You can access the platform by going to datastudio.google.com.
2. In the top left corner of the screen, click the plus sign next to “Create”, then choose Data Source from the drop-down menu. This allows you to choose where you would like to pull data.
3. Select the Google Ads connector. This should be the option you see next to the Google Analytics tool. This integrates your Google Ads account with Data Studio.
4. If a message appears prompting you to grant Data Studio access to your account, click AUTHORIZE. (Note: You can revoke this access at any time.) This page explains how Data Studio will be accessing your account and your data.
5. Choose ALL ACCOUNTS
6. Select the account you would like to use. You can search for them by name or account ID.
7. Click Overall Account Fields.
8. At the top right side of the screen, click CONNECT.
9. The data source field will populate.
10. The data source is now integrated with your data set.

Allow the Professionals at Symphonic Digital to Manage Your Google Ads Account

While this new Google Sheets, Google Ads Business data integration can make your business that much more effective, there are many more tactics involved in a successful digital advertising campaign.

If you’re looking for an experienced team to control your Google Ads account, look no further than Symphonic Digital. From ad design to copywriting, we know what it takes to create digital ads that lead to more conversations. Contact us today to see how we can help your business grow!