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

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'
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101