Skip to content

Google Ads Store Sales Improvement

Mr Lopes edited this page Nov 16, 2023 · 2 revisions

Description

Uploads store sales conversions to Google Ads.

Selector

ADS_SSI_UPLOAD

Requirements

  • Google Ads configured in intro tab
  • Store Sales Conversion created in Google Ads
  • Google Ads API Enabled in Google Cloud

Expected Schema

Column name Type Description Requirement
email STRING User email optional*
phone STRING Phone number in E.164 format optional*
mailing_address_first_name STRING optional*
mailing_address_last_name STRING optional*
mailing_address_country STRING Iso two letter format optional*
mailing_address_zip STRING optional*
time STRING 2020-04-16T12:00:00.000 required
amount NUMERIC Value in micros required
currency_code STRING USD (ISO 4217) required
custom_value STRING required if custom_key is set

Metadata

  • Conversion Name: Name of the conversion created on Google Ads
  • Google Ads Account: Define a Google Ads Account Customer Id to override the Account Id defined in the General Configuration on the "Intro" tab. If the Account Id defined in the General Configuration is a Mcc account, the Mcc account will still be used for authentication, however the override Account Id will be used as the Customer Id (Optional).
  • Should hash: TRUE or FALSE (DEFAULT=TRUE). Define if you would like Megalista to hash the data before sending. Use false if your data is already SHA256 hashed.
  • Custom Key: In case there is a custom variable created within Google Ads (Optional)
  • User Data Consent: Specifies if data consent was collected: GRANTED | DENIED | UNSPECIFIED (Optional)
  • Ad Personalization Consent: Specifies if data consent was collected: GRANTED | DENIED | UNSPECIFIED (Optional)

Additional information

Although all columns are optional, it's required that at least email, phone or all mailing fields are present.

More information on Store Sales in the support link.

Clone this wiki locally