Google Ads Exporter

📘

Check out the API docs here for more information.

Set up

Source

To get set up with the Google Ads connector, you will only need your Google login that has access to the Google Ads account you are looking to ingest data from.

Customer IDs

To set up the extract, we will require your Login Customer ID and your Customer ID:

• Login Customer ID - This is the customer ID (without hyphens) of the Google Ads account that your Google email account is associated with.
• Customer ID - This is the customer ID (without hyphens) of the Google Ads account you wish to pull data from. You can add multiple IDs, by separating them with a comma (no spaces).

Both IDs above may be the same, however, they may also differ in the following scenario; You have access to a Google Ads manager account, which has control of a different Google Ads account that you want to pull data from.

To retrieve your Customer ID sign into your Google Ads account then look in the top right corner of the page, and you should see your customer ID right there. It will be a sequence of numbers in the format xxx-xxx-xxxx.

Features

Reports detail

To upload click data using the Google Ads extract connector, you can reshape them into the required source table with the following SQL:

CREATE OR REPLACE TABLE EXAMPLE_TABLENAME (
    conversions VARCHAR NOT NULL
);

INSERT INTO EXAMPLE_TABLENAME(conversions)
VALUES (
    '{
        "gclid": "\<<A VALID GOOGLE CLICK ID>>",
        "conversionAction": "customers/\<<CUSTOMER ID>>/conversionActions/\<<CONVERSION ACTION ID>>",
        "conversionDateTime": "2024-01-14 11:30:00+00:00",
        "conversionValue": 5,
        "currencyCode": "GBP"
    }'
), 

This table has been simplified to the required data from the click conversion JSON representation, available here .

Limitations

🚧

Data update to Google Ads Conversion Action.

Data Freshness Constraint: Uploaded Click conversion can take up to 15 hours to be reflect on your account. For more details see here.

🚧

Connector will change data within Google Conversion Action.

Use of the report on this connector will result in changes to the data within your Google Ads Conversion Action for the GLICD used.

Our suggestion is also to experiment and explore the behaviour of the connector and the API, by first spending sufficient time testing things with conversion action before making any attempts to go to Production changes.