Microsoft Ads - Upload Offline Conversions

Overview

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

Variables

Name	Reference	Type	Required	Default	Options	Description
Custom SQL	BING_CUSTOM_SQL	Alphanumeric	✅	-	-	Enter the custom SQL to fetch Bing Offline Conversion data. The SQL should return results with the following exact column names for successful upload: MicrosoftClickId, ConversionValue, ConversionTime, ConversionName
Currency Code	CURRENCY_CODE	Select	✅	USD	USD EUR CAD	Currency for platform conversion uploads
Login Customer Id	BING_LOGIN_CUSTOMER_ID	Alphanumeric	✅	-	-	Login customer ID for Bing.
Account Id	BING_ACCOUNT_ID	Alphanumeric	✅	-	-	Account id for Bing Ads
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

YAML

Below is the YAML template

YAML


source:
  template: Microsoft Ads - Upload Offline Conversions
  inputs:
    BING_CUSTOM_SQL:
    CURRENCY_CODE: USD
    BING_LOGIN_CUSTOMER_ID:
    BING_ACCOUNT_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:
    - 102