Customer Match enables businesses to match their owned and consented customer data with Google's extensive customer database, empowering them to engage with their customers through various Google platforms such as Search, the Shopping tab, Gmail, YouTube, and Display
This TD export integration enables the uploading of Customer Match data, such as user emails or phone numbers, directly to either Google Ads or Google Display & Video 360 (DV360) platform.
The TD Console provides a few integration options to upload the Customer Match data to Google platforms:
- Google Ads V2: update audience data to Google Ads, using its API feature. Currently, there is a limitation that the mailing address which includes first name, last name, country code, and postal code is not supported
- Google Display & Video 360 API: update audience data to DV360, using its API feature. Currently, the connector doesn't support user opt-out yet
- This integration has been implemented in such a way that Treasure Data is an official data partner of Google, and it solves all above mentioned limitations
- Basic Knowledge of Treasure Data™
- Basic knowledge of the Customer Match topic
- The user OAuth has direct admin access to the target Google Ads or DV360 account
- Upload at least 5,000 members to increase the chance of having enough matched
- The user list size is displayed as zero until it reaches a minimum of 1,000 members. Beyond this threshold, the size is rounded to the nearest two significant figures
- It can take up to 24 hours for a list to be populated with members
- It is recommended to append audience data to a user list once per day
- Avoid running multiple uploading jobs of the same user list
It is recommended to follow Google's policies for Customer Match, in particular:
- A good history of policy compliance
- A good payment history.
- Upload only customer information that you collected in the first-party context
- Restrictions on sensitive categories
On TD Console, you must create and configure the data connection before running your query. As part of the data connection, you provide authentication to access the integration following the below steps
- Open TD Console
- Navigate to Integrations Hub > Catalog
- Search for and select Google Customer Match
- Select Create Authentication, and provide the credential information for the integration as described below
- Select **Continue,**enter a name for the Authentication, and select Done.
| Field Name | Type | Description |
|---|---|---|
| Platform (Required) | string | The target platform, Google Ads or Google Display & Video 360, to upload the audience data to |
| OAuth Connection (Required) | OAuth | Authorize from an account having ADMIN access to the target Google Ads (or DV360) account |
The TD Console supports multiple ways to export data. Please follow the below steps to export data from the Data Workbench
- Navigate to Data Workbench > Queries
- Select New Query, and define your query
- Select Export Results to configure the data exporting
- Select an existing authentication, or create a new one following the above section
- Configure the exporting parameters as described in the Configuration Parameters below, and select Done
Your query should include the required columns for the target Identifier type, other columns will be ignored. Required columns don't accept a null or empty value (else the record is considered invalid and skipped).
Data requirement:
- Normalization: all plain text data should be in lowercase, and be removed any extra spaces before, and after
- SHA-256 hashing: email, phone, first name, and last name should be hashed using the SHA-256 algorithm. If not, they are hashed automatically by the connector
| Column name | Description | Required |
|---|---|---|
| Only Google emails are considered in the matching process. | At least email or phone or mailing address is required for the Contact information identifier type. The mailing address must includes all 4 columns [first_name, last_name, country_code, postal_code]. Phone must follow E.164 format. Visit https://en.wikipedia.org/wiki/E.164 for more detail. Country code must follow https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2 | |
| phone | The E.164 standard is applied | |
| first_name | Mailing address - first name. | |
| last_name | Mailing address - last name. | |
| country_code | Mailing address - country code (2-letter code in ISO-3166-1 alpha-2) | |
| postal_code | Mailing address - postal code | |
| mobile_id | Identifier for Advertising (IDFA) or Google Advertising ID (AAID) mobile device IDs | Required for the Mobile Advertising ID identifier type |
| Parameter Name | Type | Description |
|---|---|---|
| Advertiser ID (Required) | string | The ID of the target Google Ads account, or DV360 account, with or without dashes |
| List name (REQUIRED) | string | Name of the user list |
| Mode (REQUIRED) | string | The operation mode - Add (default): Query results are appended to an existing user list, or a new user list is created, if none exists by the specified List name. - Remove: Query results will be removed from an existing user list. |
| Identifier type (REQUIRED) | string | Two types of user identifiers are supported - Contact information: matching user profile using email, phone, or mailing address - Mobile advertising ID: matching user of a mobile application by uploading IDFA or AAID. If selected, the Application ID is mandatory |
| Application ID (OPTIONAL) | string | The ID of the mobile application. Required if Identifier type is Mobile advertising ID |
| Membership days (REQUIRED) | number | The number of days a user's contact information stays on the user list (if a value between 0 and 540 is specified). Default value: 10000 - no expiration |
| Ad consent (OPTIONAL) | string | Uploading data of the users from required regions, such as The European Economic Area, requires an explicit ad consent declaration |
| Ad personalize consent (OPTIONAL) | string | The consent flag for ad personalization |
You can also send segment data to the target platform by creating an activation in the Audience Studio.
- Navigate to Audience Studio.
- Select a parent segment.
- Open the target segment, right-mouse click, and then select Create Activation.
- In the Details panel, enter an Activation name and configure the activation according to the previous section on Configuration Parameters.
- Customize the activation output in the Output Mapping panel.
- Attribute Columns
- Select Export All Columns to export all columns without making any changes.
- Select + Add Columns to add specific columns for the export. The Output Column Name pre-populates with the same Source column name. You can update the Output Column Name. Continue to select + Add Columnsto add new columns for your activation output.
- String Builder
- + Add string to create strings for export. Select from the following values:
- String: Choose any value; use text to create a custom value.
- Timestamp: The date and time of the export.
- Segment Id: The segment ID number.
- Segment Name: The segment name.
- Audience Id: The parent segment number.
- + Add string to create strings for export. Select from the following values:
- Set a Schedule.
- Select the values to define your schedule and optionally include email notifications.
- Select Create.
If you need to create an activation for a batch journey, review Creating a Batch Journey Activation.
Within Treasure Workflow, you can specify the use of a data connector to export data.
Learn more at Using Workflows to Export Data with the TD Toolbelt.
_export:
td:
database: google_customer_match
+google_customer_match_export_task:
td>: export.sql
database: ${td.database}
result_connection: new_created_google_customer_match
result_settings:
type: google_customer_match
advertiser_id: 123456789
list_name: test
identifier_type: contact_info
membership_life_span: 100
mode: add
ad_user_data_consent: granted
ad_personalization_consent: granted_export:
td:
database: google_customer_match
+google_customer_match_export_task:
td>: export.sql
database: ${td.database}
result_connection: new_created_google_customer_match
result_settings:
type: google_customer_match
advertiser_id: 123456789
list_name: test
identifier_type: mobile_advertising_id
app_id: test
membership_life_span: 100
mode: remove
ad_user_data_consent: granted
ad_personalization_consent: granted