Facebook Ads Data Connector User Guide
The following article is a guide for automating reports with your Facebook Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Facebook Ads data. To create a Facebook Ads report, you will need at least one Facebook Ads account and access to Google Sheets or Looker Studio.
Available Data
- Key Performance Indicators - including reach, spend, impressions, and clicks
- Amount Spent - breakouts by age, gender, and location
- Purchases - by Impressions, clicks, and spend
- Campaign performance - by KPIs
- Engagement metrics - ads, videos, and apps
- Pixel Events - lead generation and live
- Ad Set Performance - by KPI
- Ad Engagement - broken down by likes, clicks, reacts, comments, saves, and shares
- Video Engagement - broken down by plays, cost, and portion viewed
- App Engagement - with cost per mobile and desktop install
- Pixel Event Data - eCommerce and lead generation
- Hourly data - pixels, impressions, and amount spent
- Revenue by region - when UTM parameters are applied and data is exported to Google Analytics
- Spend vs. revenue - when UTM parameters are applied and data is exported to Google Analytics
- Custom Conversions - custom conversions are available.
- Complete List of Fields.
API Limitations
Facebook provides a comprehensive list of the types of demographic information are no longer available following App Tracking Transparency requirements in iOS14.
- Combining breakdowns - See the valid combinations of breakdowns.
- Purchase breakouts - by device and publisher platform
- Offsite metrics
- Daily sums for Reach and other "unique" metrics - reach and other metrics beginning with the prefix "unique" are live metrics and cannot be used in daily sums
- Conversions by Country - no longer available following the iOS14 update
- 37 month lifetime limit - Lifetime metrics reflect only 37 months of data.
- Custom events - Custom events are not available.
- Custom metrics - Custom metrics do not come through Facebook Ads' API and must be replicated with formulas in your report.
Connection Requirements
Your Facebook account must have Ad Analyst access for a successful connection.
Connector Configuration
In the connector configuration screen for Facebook Ads, you are able to select several different attribution options.
You can choose between Ad Set (Default) or Account. Account refers to outdated settings that were removed as of January 19, 2022. However, some of our customers still use this setting to bypass the Ad Set attribution settings and default all Ad Sets to 7 day click, 1 day view. This can be a useful setting to use if you are having difficulty with Zero or Null Values in Facebook Ads Reports.
Your next option is "Is Campaign using SKAd Network?" SKAd Network is the default type of attribution that Facebook uses following the iOS14 update that occurred on April 26, 2021. This defaults to Get All Campaigns. You can also choose Yes and get only campaigns that use SKAd Network or No and get only campaigns that do not.
Finally, you may also choose whether to allow Action Attribution Setting to be modified and whether campaign is using SKAd network to be modified. Choosing these options will allow for more flexibility within your report. However, if you are blending data with several sources, it will not work. Whatever settings you have chosen in the configuration screen will apply regardless of selecting these options when blending.
Get the most from your Facebook Ads connector
Use our free template
Facebook's API is constantly changing. We always update our templates so that our customers can have easy to use, working reports. You can easily copy reports from our templates, or change the color schemes and add your logo to showcase your brand.
Create breakdowns by Objective
This feature is available in Facebook Ads Manager but not in the API. Here is a workaround that you can use.
Create a filter on your table. Choose Include > Campaign ID (ad sets, campaign insights, campaigns, insights) > RegExp Match.
Backfilling
We initially backfill 13 months of data when you first create a report with us. With Facebook's API, it is possible to backfill up to two years of data.
Troubleshooting
Follow the instructions in our Troubleshooting Facebook guide to get your reports working again.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Instagram Ads Data Connector User Guide
The following article is a guide for automating reports with your Instagram Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Instagram Ads data. To create an Instagram Ads report, you will need ...Facebook Insights Data Connector User Guide
The following article is a guide to automating reports with your Facebook Insights connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Facebook Insights reports. To ...Microsoft Ads Data Connector User Guide
The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin ...Twitter Ads Data Connector User Guide
The following article is a guide to automating reports with your Twitter Ads connector. It includes information on available data as well as tips on how to get the most out of your Twitter Ads reports. To begin creating reports with your Twitter Ads ...Pinterest Ads Data Connector User Guide
The following article is a guide to automating reports with your Pinterest Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Pinterest Ads reports. To begin ...