Google Ads

Section header image mobile

Experience the power of data-driven advertising with Coefficient's Google Ads integration. Seamlessly link your Google Ads account to import essential campaign data and supercharge your advertising strategies with in-depth insights and analytics.

Connecting to Google Ads

Import from Scratch with Google Ads

Schedule your Import, Snapshots, and Add Automations

FAQs for Google Ads

Connecting to Google Ads

When you begin a Google Ads import for the first time, you will need to go through a few steps to connect your account to Coefficient before being able to import data from Google Ads to Google Sheets using Coefficient.

1. Open the Coefficient Sidebar and click the Menu.

Menu_Icon (1).png

2. Select “Connected Sources”. 

Screenshot 2023-10-10 at 5.18.29 AM.png

3. Select “Add Connection” at the bottom and then “Connect” to Google Ads.

Screenshot_2023-05-24_at_6.57.19_PM.png

4. “Authorize” the connection.

Screenshot_2023-05-24_at_6.59.39_PM.png

5. Select the email address associated with your Google Ads account.

ChooseGoogleAccount.png

6. “Allow” access/permissions. When successful, you will be taken back to Google Sheets.

GoogleAccountAccess.png

Import from Scratch with Google Ads

1. From the Coefficient Sidebar select “Import from…”.

ImportFrom (1).png

2. Choose “Google Ads” from the list.

Screenshot_2023-05-24_at_7.13.32_PM.png

3. Select “Start from scratch”.

Screenshot_2023-05-24_at_7.11.04_PM.png

4. Select your Google Ads account from the “Import Preview” window. Select “Next”.

ℹ️ NOTE: This screen will only appear if you have multiple accounts to select from - if you do not have multiple accounts you will not see this screen - you can proceed to step 5 below.Screenshot_2023-05-26_at_6.45.39_PM.png

5. Select an object from those listed. (example: ”Campaign”). Popular objects are displayed at the top, but you can scroll down to find Other Objects.Screenshot_2023-05-26_at_6.40.19_PM.png

6. Select fields for your Segments, Dimensions, and Metrics needed for your import. Click inside the white box area for each section to search for the fields you need. The data previewer shows a sample of the data from the fields you select.

Screenshot_2023-05-26_at_6.48.31_PM.png

7. Customize your import by adding filters, and row limits as needed. Click the “Refresh Preview” option to update the sample data based on what customizations are added. Then “Import”Screenshot_2023-05-26_at_6.51.40_PM.png

8. Congratulations on your first Google Ads import with Coefficient! 🙌🏼Screenshot_2023-05-26_at_6.58.05_PM.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your Importa.png

2. Turn on Snapshotsb.png

3. Set Up Automations

c.png

FAQs for Google Ads

What objects/reports are supported with Coefficient’s Google Ads integration?

We support all Resources with Metrics, however, due to some Google Ads API limitations, custom fields are not currently supported.

How can I add the “Cost” of each Campaign to my Google Ads imports?

In the import preview window, within the “Metrics” section, search for “Cost Micros”. This field is in “micros” so you will need to divide by 1,000,000 to get the actual cost of the Campaign. (additional information here).

My import is only pulling in 100,000 rows. What can I do?

Coefficient's Google Ads integration supports up to 100K rows of data. If you require more than this, please contact support (support@coefficient.io) for further assistance.

Was this article helpful? 0 out of 0 found this helpful