Breadcrumbs

Alli Solutions - Google Offline Conversion Uploader

This workflow automates the process of uploading offline conversions to Google Ads Platform. It also stores both the request payloads and platform responses for auditing and back-tracking in:

  • google_ads_offline_conversions_payload_log

  • google_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

Google 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

Google Ads Account ID

GOOGLE_ADS_ACCOUNT_ID

Alphanumerice


-

-

Enter your specific Google Ads Account ID.
Where to find it: While in Google Ads, look at the top right corner next to your account name, or check the URL after ?customerId=XXXXXXX. It will appear as a 10-digit number (e.g., 012-345-6789).

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