Open the Coefficient Sidebar and click the Menu icon.
Select “Connected Sources”.
Import from Scratch with Google Ads
Schedule your Imports, Snapshots, and Automations
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.
Open the Coefficient Sidebar and click the Menu icon.
Select “Connected Sources”.
Select “Add Connection” at the bottom and then “Connect” to Google Ads.
“Authorize” the connection.
Select the email address associated with your Google Ads account.
“Allow” *access/*permissions. When successful, you will be taken back to Google Sheets.
Open the Coefficient Sidebar and click on the “Import from…” button. ****
Select “Google Ads” from the list.
Select “Start from scratch”.
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).
Select an object from those listed. (example: ”Campaigns”). Popular objects are displayed at the top, but you can scroll down to find Other Objects.
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.
