Imports data from Google Ads.
Before you can download data from Google Ads you have to give access to a Onesecondbefore account.
Another method is to organize the access yourself. Below is described how to do this.
Apply for a Developer Token of the Adwords account you would like to import data from. You also need this access if you want to mass-update the Google Ads account.
You can apply for a Google Ads Developer account under: `TOOLS & SETTINGS > SETUP > API Center`. There you can apply for a Developer Token.
Then you need to give your Google Account access. There are two ways to do this:
Take the steps below to download data from Google Ads with a service account.
conn_id
client_email
from the Service Account `Read` access to the Google Ads accountTake the steps below to download a Google Spreadsheet with a delegated account. Please take note of the security precautions needed to secure this connection method.
extract:
conn_id: google_cloud_default
google_ads_conn_id: google_ads
type: query
login_customer_id: 1234567890
customer_id: 2345678912
query: |
SELECT user_list.description,
user_list.name,
user_list.size_for_display,
user_list.size_range_for_display,
user_list.size_for_search,
user_list.size_range_for_search,
user_list.eligible_for_search,
user_list.eligible_for_display
FROM user_list
WHERE user_list.name LIKE 'OSB Audience%'
property | type | required | description |
---|---|---|---|
conn_id | string | no | Default is google_cloud_default . Connection string as handed to you by the Onesecondbefore team. If your cloud is Google Cloud, the conn_id is not obliged. It will
take the client_cloud.db_conn_id. |
google_ads_conn_id | string | no | Default is google_ads . Contains an extra connection to retrieve the Developer Token. |
type | enumerator (query) | no | Default is query . Export type. Currently only support for query , which let's you export the result of an AWQL or AdWords Query. |
login_customer_id | int | no | The login customer id is the id of the Google Ads account that has the Developer Token. This does not have to be the same as the Google Ads account you will import data from. |
customer_id | int | yes | Google Ads account you will import the data from. |
query | int | yes | Contains a query in the Google Ads Query Language. |
item | description |
---|---|
API | Google Ads API |
Pre-formatted schema | Yes. Comes with a pre-formatted and described schema. |