You can write job results in Treasure Data directly to your Facebook Custom Audience.
When you upload or create a Custom Audience, Facebook requires that you accept Custom Audience Terms. You see a notification when you export an ad object targeting a customer file or export value-based Custom Audiences. You receive subsequent reminders about Facebook Custom Audience terms every 90 days. For more information, see Better Facebook Ads ROI with Data-Driven Custom Audiences.
For sample workflows on how to write job results to Facebook Custom Audience, view Treasure Boxes.
Basic knowledge of Treasure Data, including the TD Toolbelt.
A Facebook Ad Account.
Authorized Treasure Data Facebook app access to a Facebook Ad Account
This section is optional if you use OAuth authentication.
The following permissions are needed with the token.
If you are not able to generate an access token to connect to Facebook, review Meta - Publisher Steps in Business Manager.
Before sending data to Facebook, the data must be hashed with SHA256 with no salt (is random data that is used as an additional input to a one-way function that hashes data). This requirement applies to all data except External Identifiers, App User IDs, and Page Scoped User IDs.
If you choose to prepare your data (normalization and hashing) before sending it to the connector, you can set the option No need to normalize and hash records to True.
Treasure Data result output normalizes your values automatically according to Facebook’s normalizing rules.
All values, uploaded to Facebook for matching, must be normalized using the normalizing rules of Facebook. Otherwise, the values miss chances to match (if they are not normalized). If you need to normalize the data manually, apply your own normalization before attempting to generate output results.
According to the data type, the following conversion behavior is applied while creating the resulting output.
EXTERN_ID (External ID)
No action is needed.
No action is needed.
MADID (Mobile advertiser ID)
Convert all characters to lowercase, keep hyphens.
EMAIL (Email addresses)
Trimming leading and trailing whitespace and convert all characters to lowercase.
PHONE (Phone numbers)
Removing any non-digit characters and leading zeros.
Trimming leading and trailing whitespace and convert all characters to lowercase. If the result does not match with “m” or “f”, an empty string is used (because it’s an invalid value, it is futile to attempt a match).
DOBY (Birth Year)
Removing any non-digit characters and get the first 4 digits.
DOBM (Birth Month) and DOBD (Birthday)
Removing any non-digit characters and get the first 2 digits.
FN (First Name) and LN (Last Name)
Trimming leading and trailing whitespace and convert all characters to lowercase. Remove all punctuation. Supports special characters in UTF-8 encoding.
FI (First Initial)
Apply the same as First Name and get the first character.
Convert all characters to lowercase and remove any non-alphabetic (a-z) characters.
Convert all characters to lowercase and remove any non-alphanumeric (a-z and 0-9) characters.
If your value is US State, use a 2-character ANSI abbreviation code, the Treasure Data platform does not cut off input string (into 2 characters), because of the need to support states outside the US.
ZIP (Zip code)
Trimming leading and trailing whitespace and convert all characters to lowercase, remove any non-alphanumeric or whitespace from the result.
If your value is US zip code, use exactly 5 digits, the Treasure Data platform does not cut off input string (into 5 characters), because of the need to support UK zip code format.
Long or double value; a null or empty value will be sent as 0. The column is supported by value-based Custom Audience only.
In Treasure Data, you must create and configure the data connection prior to running your query. As part of the data connection, you provide authentication to access the integration.
Open TD Console.
Navigate to Integrations Hub > Catalog.
Search for and select Custom Audiences.
Select Create Authentication.
Accept the connection or:
Select Authentication method:
Optionally, follow the prompts to log into a different Facebook account.
Optionally, log into your Facebook account and grant access to Treasure Data.
You will be redirected back to the Catalog. Repeat the first step (Create a new connection) and choose your new OAuth connection.
Name the connection.
The column name is case-insensitive, ie. you can use email or EMAIL.
Column names are case-insensitive. For example, you can use email or EMAIL.
Output results need to follow the Facebook User schema. Supported column names are:
EXTERN_ID: External ID
MADID: Mobile advertiser ID
EMAIL: Email addresses
PHONE: Phone numbers
DOBY: Birth Year
DOBM: Birth Month
LN: Last Name
FN: First Name
FI: First Initial
ZIP: Zip code
COUNTRY: Country code
PAGEUID: Page scope user id
If no supporting columns are found from the query result, you receive an error.
Ad Account ID (required)
This is your Ad Account ID without act_ prefix.
You choose to Add, Replace or Remove users from Custom Audience. Note: Facebook does not allow removing users from a low Audience size (less than 1000 users), or removing users will result in a low Audience size, and you will receive an error
Custom Audience Name
Name of Custom Audience to create/update, if none exists, one will be created. The exported result is added (appended) to the target audience.
Important note: If you have many Custom Audiences with the same name as this input, the latest Custom Audience Name will be used. We recommend that you give your Custom Audience a unique name.
Custom Audience Description
Optional description of Custom Audience.
No need to normalize and hash records (default false)
|Indicates whether the data has already been normalized and hashed. If not, TD automatically normalizes and hashes the records.|
Is Value Based?
|Create or update a Value-Based Custom Audience. This field is required when your data has LookAlike_Value column|
Your Facebook page used to collect Page scope user id. This field is required when you add or remove users by specifying
Source of customer data
Specify the source of the user information collected into this file. This field is required when Action is Add users and the Custom Audience Name does not exist.
Initial intervals in milliseconds between retries (optional, default 60000)
Interval to retry if a recoverable error occurs (in millisecond).
Retry limit (optional, default 5)
The number of retries before attempts end.
You can use an alias in your query to rename columns of your query result. For example:
SELECT an_email_column AS EMAIL, another_phone_column AS PHONE FROM your_table;
Here is an example Audiences list before the output of a query result:
From Treasure Data, run the following query with Output results into a connection of Facebook Custom Audience:
SELECT email, fn, ln FROM ( VALUES ('email@example.com', 'John', 'Doe'), ('firstname.lastname@example.org', 'Isaac', 'Miceli'), ('email@example.com', 'Christopher', 'Agar') ) tbl (email, fn, ln)
or for Page scope user ID
SELECT pageuid FROM ( VALUES('2018728488162687') , ('1785406501565085') , ('2341287802551031') , ('2487019361340533') , ('1093039407464499') ) tbl (pageuid)
The query will not match any real users, it’s for demo purposes only. Also, the query requires no source table (for the ease of testing out this feature), but you still must choose a database, so pick “sample_datasets” or any other arbitrary table. Uploading Page scope user ID requires Page ID, for example, Page ID:
The query should complete in a few seconds. After that, check your Audience List:
You can use Scheduled Jobs with Result Export to periodically write the output result to a target destination that you specify.
Within Treasure Workflow, you can specify the use of this data connector to export data.
Learn more at Using Workflows to Export Data with the TD Toolbelt.
After you output your user list into an Instagram Custom Audience,
If you see the following error:
This ad account is not connected to Business Manager. To create or edit a customer file Custom Audience, your admin needs to connect this ad account to a business account.
You must add your Ad Account to a Business Manager account.
Follow these steps:
Create Business Manager account: https://www.facebook.com/business/help/1710077379203657
Add Ad Account: https://www.facebook.com/business/help/910137316041095
Select one of the following:
Add an Ad Account
Adding an ad account moves the account permanently into Business Manager. You must be both the owner of the ad account and an admin in Business Manager to add the ad account. When you add an ad account and it's moved into your Business Manager, you cannot reverse the action. Also, note that all management of your ad account must be completed within your Business Manager profile. You can't add an ad account that's owned by another Business Manager. If you still want to work on an ad account that is owned by a different business, you can request access to it.
Request Access to an Ad Account
If you request access to an ad account in Business Manager, the admin of that Business Manager can grant you permission to work on it.
Create a new Ad account
If you create a new ad account in Business Manager, it'll permanently belong to that Business Manager. When the ad account is created within the Business Manager, the ad account can't be transferred to an individual owner who doesn't own a Business Manager role.