Overview: Query Builder for Facebook Ads (Pixels)

HOW TO

How to access the Query Builder for Facebook Ads (Pixels)

Navigate to Metrics > Query Builder to access the Query Builder for Facebook Ads. Click the green + Create Custom Metric button and select your connected Facebook Ads Account from the Data Source drop-down list. Select the Pixel radio button.

these steps

How to use the Query Builder for Facebook Ads (Pixels)

Data Source: This is the Data Source that the Custom Metric is syncing data from.

Pixel: Select a Pixel from your connected Facebook Ads Account

Metric: Select a Metric from your connected Facebook Ads Data Source, such as "Custom Conversions" or "Events Received by URL."Selecting certain Metrics - like Custom Conversions - will expose additional fields - like Custom Conversion - so you can further specify your Metric selection.

Data Preview: After clicking Preview Data, a Data Preview of the Custom Metric will be displayed. Daily Metric values are displayed in this section, along with the total Metric values for the Date Range in bold at the bottom. You can view the Data Preview for different Date Ranges by clicking on the drop-down list at the top of the Data Preview.

Custom Query Name: Enter a name for your Custom Metric. This Custom Metric name will be available in the Designer after saving.

Save: Save your Custom Metric.

How to create a Custom Pixel Metric [Example]

In this example, we'll create a Custom Metric to report on Custom Conversions tracked by our Thank You Page.

Navigate to Metrics > Query Builder

Click the green + New query button

Select the appropriate Facebook Ads Data Source

Select the Pixels radio button

Since we want to track a custom conversion, we'll select Custom Conversions from the Metric drop-down list

After selecting Custom Conversions as the Metric, a new field is exposed called Custom Conversion. We'll click on this drop-down and will select TY Page as the specific conversion

In order to accurately explain what this Custom Metric is reporting on, we'll name the Custom Metric "Custom Conversions: Thank You Page"

Click Preview data to generate a Data Preview of the Custom Metric.

Once we confirm that these are the results we're looking for, we'll click Save to save the Custom Metric.

How to add a Custom Pixel Metric to a Databoard

Open the selected Databoard in the Databox Designer, or create a new Databoard.

Drag and drop a blank Datablock onto the Databoard from the Visualization Library.

Select the appropriate Facebook Ads Data Source in the righthand Property Manager. This must be the same Facebook Ads Account that was selected when creating the Custom Metric.

Select the Custom tab at the top of the Metric drop-down list.

Select the Custom Metric name to populate the Datablock.

Additional Information

Due to an API limitation Custom Metrics built using the Query Builder for Facebook Ads (Pixels) will have 28 days of historical data available once the metric is being used in your account.
Due to technical limitations, it is not currently possible to filter Custom Conversions by Ad, Campaign, or other Dimensions using the Query Builder for Facebook Ads (Pixels).
Due to how Facebook stores Custom Conversion data in their API, data may not be immediately available for the days closest to the current date in Databox. For example, if you're looking at data for the month to date, week to date, today, yesterday, and possibly the day prior may have incomplete data available.

This is the expected behavior of this integration. Please ensure those reviewing your dashboards using Facebook Ads Pixel data are aware that data delays may happen with current dates and this API is not "real-time".
Learn how to verify Custom Conversion data in Databox vs Facebook Ads here.