This workflow automates the process of uploading offline conversions to Bing Ads Platform. It also stores both the request payloads and platform responses for auditing and back-tracking in:
-
bing_ads_offline_conversions_payload_log -
bing_ads_offline_conversions_response_log
This enables you to:
-
Review accepted conversions
-
Review rejected conversions and failure reasons
Variables
|
Name |
Reference |
Type |
Required |
Default |
Options |
Description |
|---|---|---|---|---|---|---|
|
Bing 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 |
|
Bing Account ID |
BING_ACCOUNT_ID |
Alphanumeric |
|
- |
- |
Account id for Bing Ads |
|
Bing Login Customer Id |
BING_LOGIN_CUSTOMER_ID |
Alphanumerice |
|
|
|
Login customer ID for Bing. |
|
Google Customer Id |
GOOGLE_CUSTOMER_ID |
Alphanumerice |
|
|
|
Account Number |
|
Google Login Customer Id |
GOOGLE_LOGIN_CUSTOMER_ID |
Alphanumerice |
|
|
|
MCCID |
|
Currency Code |
CURRENCY_CODE |
Select |
✅ |
|
|
Currency for platform conversion uploads |
|
Table Name |
TABLE_NAME |
Alphanumerican |
✅ |
|
|
Table Name |