Facebook Ads Data Connector User Guide

Facebook Ads Data Connector User Guide

Info
Facebook Ads is a powerful advertising platform that allows businesses to reach their target audience on Facebook, Instagram, and across the web. This guide will walk you through how to connect your Facebook Ads account to Power My Analytics, create reports in Looker Studio, and understand key metrics and considerations when working with Facebook Ads data.



Prerequisites

Before connecting Facebook Ads to Power My Analytics, ensure you have:
  1. Ad Account Analyst access to the Facebook account you want to connect

Adding Facebook Ads as a Data Source

To add Facebook Ads as a data source in Power My Analytics:
  1. To add the correct Facebook account, you must be logged in to that account in your browser. Open an Incognito window in your browser to log into the correct Facebook account before connecting with Power My Analytics.
  2. Navigate to your Hub and select Sources from the menu.
  3. Click + New Data Source and choose Facebook & Instagram from the gallery.
  4. Sign in to your Facebook account to authenticate.
  5. Grant Facebook business access: Select "Opt in to all current and future Businesses". Click Continue.
  6. Grant Facebook page access: Choose "Opt in to all current and future Pages". Click Continue.
  7. Grant Instagram account access: Select "Opt in to all current and future Instagram accounts". Click Continue.
  8. Finalize permissions: Click Save, then click Got it.

Creating a Looker Studio Report

To create a Looker Studio report using your Facebook Ads data:
  1. After adding Facebook Ads as a data source in the PMA hub, navigate to Reports > Looker Studio
  2. Select Facebook Ads under Create Looker Studio Report (opens official Looker Studio application in new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g. "Facebook Ads - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked for PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select Facebook Ads account (real data) or "Sample Account" (sample data)
      2. Click Next
    3. Step 3: 
      1. Choose "Ad Accounts", "Action Attribution Setting", "Is Campaign using SKAdNetwork", "Currency" for reports
      2. Optional: Allow "Ad Accounts", "Action Attribution Setting", "Is Campaign using SKAdNetwork" modification in reports
      3. Click Connect (top right) to complete the data source configuration
    4. Step 4: 
      1. Click Create Report (top right)
For a quick start, you can use our pre-built Facebook Ads demo template.

Understanding Attribution Options in Facebook Ads

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.

Key Reports and Fields

Popular metrics and reports for Facebook Ads include:
  • Performance Overview Metrics: Reach, Impressions, Frequency, CPM, Amount Spent
  • Campaigns (Performance) Metrics: Reach, Impressions, Amount Spent
  • Ad Sets (Delivery) Metrics: Reach, Frequency, Cost per 1,000 People Reached, Impressions, CPM
  • Ads (Engagement) Metrics: Post Reactions, Post Comments, Post Saves, Link Clicks, Page Likes, CPC
  • Video Engagement Metrics: Video Plays, ThruPlays, DMA, 25%, 50%, 75%, 95%, 100%, Average Play Time
  • App Engagement Metrics: Mobile App Installs, Cost Per App Installs, App Installs, Cost Per App Installs, Post Reactions, Post Comments, Post Saves, Post Shares
  • Offline Conversions Metrics: Offline Purchases, Offline Purchases Conversion Value, Cost per Purchases, Offline Leads, Cost per Leads, Offline Other Conversions, Cost per Offline Other Conversions
  • Locations Metrics: Reach
  • Designated Market Area Metrics: Impressions, Link Clicks
  • E-Commerce Pixel Events Metrics: Website Content Views, Website Adds to Wishlist, Website Adds to Cart, Website Checkouts Initiated, Website Adds of Payment Info, Website Purchases, Website Purchases Conversion Value
  • Lead Generation Pixel Events Metrics: Landing Page Views, Website Content Views, Website Registrations Completed, Website Searches, Website Leads, Website Leads Conversion Value
  • Hourly Breakdown Metrics: Reach, Impressions, Amount Spent
  • Device Breakdown Metrics: Reach, Impressions, Amount Spent
  • Live Pixel Events Metrics: Live Landing Page Views (hourly), Live Content Views (hourly), Live Leads (hourly), Live Adds to Cart (hourly), Live Purchases (hourly)
  • Actions Metrics: On-Facebook Purchases, Website Purchases, Offline Leads, Website Leads
  • Custom Conversions
  • Custom Events
For a complete list of available Facebook Ads fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Limited to 2 years, with an initial backfill of 13 months when you first connect your account.
  2. Data Span: Lifetime metrics cover 37 months of data.
  3. Live Metrics: Reach and metrics starting with "unique" are live metrics and cannot be used in daily sums.
  4. Campaign Daily Budget: Only current values for Campaign Daily Budget are available; historical data is not available for this field.
  5. New Account Delay: Wait 24 hours after adding a new account in Facebook before using it in PMA reports.
  6. Time Zone: All data is reported in time zone UTC-8:00 (UTC-7:00 during Daylight Saving Time).
  7. API and Authentication: Facebook and Instagram use the same underlying API. PMA's Facebook Ads, Facebook Insights, Instagram Ads, and Instagram Insights data connectors use the same authentication process.

Unavailable Data

  • Purchase breakouts by device and publisher platform
  • Offsite metrics
  • Conversions by country
  • Breakdowns by Objective

Report Custom Events

The Facebook Ads connector automatically includes any custom events you’ve configured in Facebook Ads. In Looker Studio, if your custom events have not appeared as available fields in your report, reconnect the Facebook Ads data source from within Looker Studio. The custom events fields should appear after reconnecting.

Replicating Custom Metrics

Custom metrics can be replicated with formulas in your report:

Create Breakdowns by Objective

Breakdowns by objective are available in Facebook Ads Manager but not in the API. You can use the following workaround:
  1. Create a filter on your table.
  2. Choose Include > Campaign ID (ad sets, campaign insights, campaigns, insights) > RegExp Match.

     

Report Result Rate

The Result Rate field is unavailable through Meta's Facebook API, so Power My Analytics cannot report total result rate for all KPIs. However, to report result rates for individual KPIs, please see our instructions at How to Report Result Rate in Facebook Ads.

Troubleshooting

Follow the instructions in Troubleshooting Facebook for information on issues that may affect the Facebook Ads connector.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Instagram Ads Data Connector User Guide

        Instagram Ads allows businesses to create and run paid advertisements on the Instagram platform. This guide will walk you through setting up Instagram Ads as a data source in Power My Analytics and creating reports in Looker Studio. Prerequisites ...
      • Facebook Insights Data Connector User Guide

        Facebook Insights provides valuable data about your Facebook Page's performance, audience, and content engagement. This guide will help you set up and use Facebook Insights as a data source in Power My Analytics. Prerequisites Before connecting ...
      • Google Ads Data Connector User Guide

        Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in ...
      • Pinterest Ads Data Connector User Guide

        Pinterest Ads is a powerful advertising platform that allows businesses to promote their products and services to Pinterest's vast user base. This guide will walk you through the process of connecting your Pinterest Ads account to Power My Analytics, ...
      • LinkedIn Ads Data Connector User Guide

        LinkedIn Ads is a powerful platform for B2B marketing, lead generation, and brand awareness campaigns. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports and gain valuable ...