Overview: Query Builder for Facebook Ads (Ads Reporting)
How to access the Query Builder for Ads Reporting
Navigate to Data Manager > 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 Ads Reporting radio button.
Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following
How to use the Query Builder for Ads Reporting
Pro Tip: Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Reach by Campaign," "Clicks by Region," or "Impressions by Device Platform."
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Facebook Ads Account for each field. Learn more here.
How to create a Custom Ads Reporting Metric [Example]
In this example, we'll create a Custom Metric to report on "Link Clicks" tracked in the Facebook Ads Account, split up based on the Device that was used to perform the action. We only want to view this data for our "Red" Campaign that's currently running.
How to add a Custom Ads Reporting Metric to a Databoard
- When you create a new Custom Metric using the Query Builder for Facebook Ads (Ads Reporting), 24 months of historical data is available. Because of this "Last Year" may not initially display a comparison percentage.