The Google BigQuery → Facebook Audience pipeline has an alpha status and is not publicly available. To enable the feature in your OWOX BI project, contact Support at firstname.lastname@example.org.
How the pipeline works
The Google BigQuery → Facebook Audience pipeline automatically imports the audience segment data from Google BigQuery to Facebook.
There is no need to gather data into the .csv table and upload it manually via the Facebook interface anymore. Just combine the segment data by SQL query in your Google BigQuery project, set up the pipeline, and OWOX BI will start uploading data to Facebook on a daily basis.
Prior to setting up the pipeline, make sure you have:
1. The relevant data for the segment creation. It can be either _fbp or CRM data (e.g. emails, phone numbers). Data can be taken from different datasets and tables, yet it should be stored within a single Google BigQuery project.
2. SQL query to combine data. You will need to add the query to the pipeline settings. As a result of the query run, you should receive a list of specific identifiers. See the details in the table below.
|Segment data type||Value format in the SQL query|
An identifier that is assigned to a user by Facebook.
A list of fields with the following values:
3. Facebook Pixel ID. It is required if you are going to create segments based on _fbp.
Please make a test run of your SQL query in Google BigQuery before you apply this query to the pipeline.
How to set up the pipeline
The Google BigQuery → Facebook Audience pipeline has an alpha status and is not publicly available. To enable the feature in your OWOX BI project, you should send your request to email@example.com.
You will then be provided with a direct link to the pipeline set-up page. Follow the instructions below to complete the pipeline creation.
Step 1. Select Google BigQuery as a data source.
Step 2. Select Facebook as a destination location for the audience segment import.
Step 3. Grant OWOX BI access to Google BigQuery. Make sure your Google account is assigned the "BigQuery Data Editor" и "BigQuery User" roles in Google Cloud Platform.
Step 4. Select the required Google BigQuery project.
Step 5. Grant OWOX BI access to your Facebook Audience account.
Step 6. Select an ad account for the audience segment import. Make sure your Facebook account is assigned the edit rights for the relevant ad account.
Step 7. Select a segment data type.
If you select “Website user behavior data”, ensure that the _fbp (facebook browser id) is collected. Read more
For the “Website user behavior data” data type, you should also provide a Facebook Pixel ID that is used for the selected ad account.
Step 8. Create an audience.
Step 9. Сlick Create pipeline.
The pipeline will be created with the Blocked status. To unblock the pipeline, navigate to the Query tab and paste SQL query. As a result of the query run, you should receive a list of identifiers (e.g. _fbp for “User behavior data” or phone numbers for “CRM data”).
SQL query requirements:
- If the ”User behavior data“ type is selected, define all the following parameters in the upper case format after the SELECT statement: FBP, EMAIL, PHONE, IP, USER AGENT. See the example below.
SELECT cd.value AS FBP, user.phone AS PHONE, user.email AS EMAIL, device.ip AS IP, device.userAgent AS USER_AGENT FROM ……
- If the ”CRM data“ type is selected, define both EMAIL and PHONE parameters in the upper case format after the SELECT statement. The example is shown below.
SELECT user.email AS EMAIL, user.phone AS PHONE FROM ……
Step 10. Once you paste the SQL query, click Activate pipeline.
If the query is written correctly, the pipeline will change its status to Running. OWOX BI will start creating the segment. Once the segment is created, it will be sent to Facebook Audience automatically. Information is updated every 24 hours from the moment the pipeline is created.
At any time, you can adjust your SQL query. To do it, go to the Query tab, make the edits, then click Apply changes.
If you need assistance, contact Support at firstname.lastname@example.org.