Facebook Ads Data Connector User Guide

Facebook Ads Data Connector User Guide

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 Data 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 + Add new source and choose Facebook Ads 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.
Notes
Power My Analytics' former Instagram Ads data connector has now been merged into the Facebook Ads data connector, and Instagram advertising data is provided through the Facebook Ads connector.

Creating a Data Studio Report

To create a Data Studio report using your Facebook Ads data:
  1. After adding Facebook Ads as a data source in the PMA hub, navigate to Reports > Data Studio
  2. Select Facebook Ads under Create Data Studio Report (opens official Data Studio application in new window)
  3. Google Data 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" and "Currency" for reports
      2. Optional: Allow "Ad Accounts" modification in reports
      3. Click Connect (top right) to complete the data source configuration
    4. Step 4: 
      1. Click Create Report (top right)
Note: If you need to configure the setting "Is Campaign using SKAdNetwork?" to "true" when creating a report, please submit a support ticket to PMA and we will assist you.
For a quick start, you can use our pre-built Facebook Ads demo template.

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
  • Boosted Posts: The boosted posts associated with the campaign
  • Custom Conversions
  • Custom Events
For a complete list of available Facebook Ads fields, refer to the Schema Explorer.

Limitations and Important Considerations

The Facebook Ads connector has specific limitations related to backfilling, historical data availability, reach reporting, unavailable data, and working with ad image fields. It also provides workarounds for features such as custom events, custom metrics, breakdowns by objective, and result rate reporting.

For full details on all Facebook Ads connector limitations, workarounds, and considerations, see Facebook Ads Data Connector Limitations.

Troubleshooting

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