Set up Dataflows to push data to Google and Facebook Audiences

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.

3. In My Destination, select the icon .

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.

9. In Batch Stream tab, select the icon .

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: [phone]

• 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.