Breadcrumbs

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

OAuth Code

OAUTH_AUTHORIZATION_CODE

Alphanumeric

✅

-

-

Authorization tokens needed for Bing 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 bing ads account.

OAuth State

OAUTH_STATE

Alphanumeric

✅

-

-

OAuth Response

OAUTH_ACCESS_TOKEN_RESPONSE

Alphanumeric

➖

-

-

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'
    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:
    - 102