Set up Dataflows to push data to Google and Facebook Audiences
Last updated
Last updated
1. After logging into the CDP 365 system, find the menu on the left side of the screen.
2. Hover the mouse over Data app for a popup menu to appear, then click Destinations.
4. Find Facebook Audiences or Google Audiences connector.
5. After clicking Select, authenticate with Facebook or Google account.
6. Input Name for Destination, and select an account.
7. Click on Connect.
8. Go back to hover the mouse over Data app for a popup menu to appear, then click Batch Stream.
10. Select a Datasource.
Select the Segment Datasource that you created earlier.
NOTE: You can see how to create a Segment Datasource: here
After clicking the Create stream button, you will be redirected to the dataflow creation interface.
Select the field that you want to push to Google or Facebook Audiences.
Select Segment contains the customer data set that you want to push to Google or Facebook Audiences.
NOTE: You can see how to create a new segment: here
11. At the back of the data node, click Add column node.
12. In the Add column node, for Email and Phone fields, encryption is required.
Use function "AUDIENCE_ENCODE_SHA256"
Example:
AUDIENCE_ENCODE_SHA256(Phone)
AUDIENCE_ENCODE_SHA256(Email)
NOTE: The format of the phone number depends on the type of audience.
For GG Audiences: "+" + Country Code + Phone Number
Example: +84932123212
For FB Audiences: Country Code + Phone Number
Example: 84932123212
Note: Phone number must not have the first "0".
If your data phone number starts with "0", you can use the following function to remove the first "0":
13. At the back of Add column node, select Destination channel, then select Facebook or Google Audiences connected in step 7.
14. Mapping the encrypted Email Hash and Phone Hash above with the destination column.
Select Table
Create new audience: create new audience and push data into it
Existing audience: push data into an existing audience
Write Mode
Insert Only: Used to push new data to the audience
Replace: Used to entirely replace old data with new data
Remove: Used to delete data that matches the uploaded data
15. Click the Save Button.
ACTIVATE THE DATAFLOW
After clicking the Activate button, the data changes status from Paused to Active.
FORCE RUN
This is used to run the dataflow immediately without timeout in dataflows.
3. In My Destination, select the icon .
9. In Batch Stream tab, select the icon .