Connect Reverse ETL Source to Facebook Custom Audience
Configure a Reverse ETL source with your Facebook Custom Audience destination.
6 minute read
This guide takes you through the steps to connect a Reverse ETL source to the Facebook Custom Audience destination. You can create a new custom audience or use an existing audience to sync the data.
You can connect multiple Reverse ETL sources to the Facebook Custom Audience destination.
Mapping settings
In the mapping window, you will see the below two options:
Create a new Facebook Custom Audience: Use this option to create a new custom audience in Facebook. You can specify the Audience name and Audience description of the new Facebook audience.
Use an existing Facebook Custom Audience: Use this option if you have an existing custom audience. Choose the audience (automatically prepopulated by RudderStack based on your specified connection settings) from the dropdown.
Then, specify the below settings:
Setting
Description
Sync mode
Choose the sync mode to specify how RudderStack syncs the data to the custom audience.
Note: RudderStack supports only Mirror mode for this destination.
Enable hashing
Turn on the toggle to allow RudderStack to hash encode user data irrespective of the schema type chosen in the RudderStack dashboard.
Note: Facebook expects the user data to be hash encoded using SHA256.
Disable format
Turn on the toggle to not format the user data before sending it to the custom audience. Facebook has fixed data formats for all the allowed schema fields.
Specify the type of the custom audience from the dropdown.
Sub-type
Specify the sub-type of the custom audience from the dropdown.
Choose identifier mappings
Map your warehouse columns to specific Facebook Custom Audience fields:
If you have selected the Create a new Facebook Custom Audience option, RudderStack creates a new audience in Facebook with the same Ad Account ID configured in the connection settings.
Schedule settings
RudderStack determines how and when to run a sync based on the sync schedule you set for your Reverse ETL connection.
Schedule type
Description
Basic
Run syncs at a given time interval and specified time (in UTC).
CRON
Run syncs based on a specified CRON expression (in UTC).
Manual
Run syncs manually.
Sync observability settings
Setting
Description
Retain sync logs
This setting is toggled on by default and instructs RudderStack to store the sync logs in your warehouse. You can also configure the below settings:
Setting
Description
Sync log retention
Specify the retention period of the sync logs in your warehouse.
If you set it to 1, then RudderStack deletes any sync log older than a day (in UTC time).
Ordering ID that RudderStack adds when delivering the events from the warehouse.
messageId
UUID generated by RudderStack.
rudderId
UUID generated by RudderStack.
Schema fields mapping
The following table details the schema fields mappings specified in the RudderStack dashboard:
Dashboard field name
Marketing API schema field (RudderStack-supported field name)
Guidelines
EMAIL
EMAIL
Trim any leading or trailing whitespaces and convert all the characters to lower case.
PHONE
PHONE
Remove symbols, letters, and any leading zeroes. The country code is needed as a prefix, if the COUNTRY field is not specified in the dashboard.
GENDER
GEN
Use these values: m or male for male and f or female for female.
MADID
MADID
Use lowercase and keep the hyphens. This information will not be hashed.
EXTERN_ID
EXTERN_ID
This information will not be hashed.
DOB YEAR (YYYY)
DOBY
Use the YYYY format from 1900 to the current year.
DOB MONTH (MM)
DOBM
Use the MM format from 01 to 12.
DOB DATE (DD)
DOBD
Use the DD format from 01 to 31.
LAST NAME
LN
Use a-z only. Lower case only, no punctuation. Use special characters in the UTF-8 format.
FIRST NAME
FN
Use a-z only. Lower case only, no punctuation. Use special characters in the UTF-8 format.
FIRST NAME INITIAL
FI
Use a-z only. Lower case only. Use special characters in the UTF-8 format.
CITY
CT
Use a-z only. Lower case only, with no punctuation, no special characters, and no whitespace.
US STATES
ST
Use the 2-character ANSI abbreviation code in lower case. Normalize the states outside the US in lowercase, with no punctuation, no special characters, and no white space.
ZIP
ZIP
Use lower case and no white space. For US, use only the first 5 digits. For UK, use the Area/District/Sector format.
COUNTRY
COUNTRY
Use lower case, 2-letter ISO 3166-1 alpha-2 country codes.
RudderStack modifies the schema names visible in the dashboard to ensure better readability. However, during the event call, the field names must be exactly the same as the schema names specified by Facebook Marketing API, as mentioned in the table above.
Explicit formatting feature
By default, RudderStack formats the data as prescribed by Facebook before sending it to the destination, as shown in the below table:
Schema field name
Example input
Formatted output (before hashing)
EMAIL
ABC@gmail.com
abc@gmail.com
PHONE
0@96346895
96346895
GEN
FEMALE
f
DOBD
2
02
DOBM
1
01
LN & FN
Abc,@
abc@
FI
Mr.
mr.
CT
HN#
hn
ST
? AL ?
al
ZIP
11502 @bc
11502@bc
COUNTRY
IN
in
If you turn on the Disable Format toggle in the RudderStack dashboard, RudderStack does not format the user data in the format prescribed by the Facebook Marketing API.
FAQ
Where can I find the Custom Audience ID?
To get your Custom Audience ID, go to the Facebook Ads Manager account. On the left navigation bar, select Audiences and choose the Ad account you have created the custom audience for.
Click All Audiences and select the specific custom audience from the list.
Finally, click the History tab. Here, you will find the audience ID under the Item Changed column:
This site uses cookies to improve your experience while you navigate through the website. Out of
these
cookies, the cookies that are categorized as necessary are stored on your browser as they are as
essential
for the working of basic functionalities of the website. We also use third-party cookies that
help
us
analyze and understand how you use this website. These cookies will be stored in your browser
only
with
your
consent. You also have the option to opt-out of these cookies. But opting out of some of these
cookies
may
have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This
category only includes cookies that ensures basic functionalities and security
features of the website. These cookies do not store any personal information.
This site uses cookies to improve your experience. If you want to
learn more about cookies and why we use them, visit our cookie
policy. We'll assume you're ok with this, but you can opt-out if you wish Cookie Settings.