Breadcrumbs

Google Ads - Upload Offline Conversions

You must follow the setup guide here: https://agencypmg.atlassian.net/wiki/spaces/PTD/pages/4871487827/How+to+Google+Offline+Conversion+Uploader

Name

Reference

Type

Required

Default

Options

Description

Custom SQL

GOOGLE_CUSTOM_SQL

Alphanumeric

✅

-

-

Enter the custom SQL to fetch Google Offline Conversion data. The SQL should return results with the following exact column names for successful upload: gclid, conversion_action conversion_date_time conversion_value

Currency Code

CURRENCY_CODE

Select

✅

USD

USD

EUR

CAD

Currency for platform conversion uploads

Customer Id

GOOGLE_CUSTOMER_ID

Alphanumeric

✅

-

-

Login Customer Id

GOOGLE_LOGIN_CUSTOMER_ID

Alphanumeric

✅

-

-

Manager Account Level

Table Name

TABLE_NAME

Alphanumeric

✅

-

-

Enter the Table name from whichever Data Base you are using(Redshift, Snowflake, Bigquery) ex. {client_slug}.{table_name}. This is the alli data source that will be queried.

Time Zone

TIMEZONE

Select

✅

CT

CT

PT

ET

MT

UTC

Timezone

Use Order ID

USE_ORDER_ID

Boolean

✅

TRUE

-

Include order id in the api payload

OAuth Code

OAUTH_AUTHORIZATION_CODE

Alphanumeric

✅

-

-

Authorization tokens needed for Google Ads Access. In order to get credentials for OAuth Code, State, and Response, add credentials using the blue "Use Credentials" button at the top and then click on "add credential group". Then follow the instructions, and save credential group to be easily identifiable. The user adding the credential group must HAVE ACCESS to the google ads account.

OAuth State

OAUTH_STATE

Alphanumeric

✅

-

-

OAuth Response

OAUTH_ACCESS_TOKEN_RESPONSE

Alphanumeric

➖

-

-

Below is the YAML template

YAML

source:
  template: Google Ads - Upload Offline Conversions
  inputs:
    GOOGLE_CUSTOM_SQL:
    CURRENCY_CODE: USD
    GOOGLE_CUSTOMER_ID:
    GOOGLE_LOGIN_CUSTOMER_ID:
    TABLE_NAME:
    TIMEZONE: CT
    USE_ORDER_ID: 'TRUE'
    OAUTH_AUTHORIZATION_CODE:
    OAUTH_STATE:
    OAUTH_ACCESS_TOKEN_RESPONSE:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101