Facebook Ads Data Connector User Guide
Last updated
The Power My Analytics Facebook Ads connector brings your Facebook and Instagram advertising data into Data Studio, Google Sheets, Microsoft Excel, BigQuery, and SQL destinations. This guide shows you how to connect your Facebook Ads account, create a report, choose an attribution window, and work with the fields, limits, and fixes that matter most when reporting on Facebook Ads.
Instagram advertising data is included in the Facebook Ads connector. The former standalone Instagram Ads connector was retired on April 1, 2025, so to report on Instagram Ads you connect your Facebook account here and select your Instagram ad account as an Ad Account in your report.
Prerequisites
Before connecting Facebook Ads to Power My Analytics, make sure you have Ad Account Analyst access (or higher) to the Facebook ad account you want to report on.
Connect Facebook Ads to Power My Analytics
Facebook Ads, Facebook Insights, Instagram Insights, and Instagram Ads all share the same Facebook sign-in, so one connection can power all of them.
- Make sure you are logged in to the correct Facebook account in your browser. If you use more than one Facebook account, open an Incognito window and log in to the right one before you start.
- Go to your Power My Analytics hub and select Sources from the menu.
- Click + Add new source and choose Facebook Ads from the gallery.
- Sign in to your Facebook account to authenticate.
- Grant business access: select Opt in to all current and future Businesses, then click Continue.
- Grant page access: select Opt in to all current and future Pages, then click Continue.
- Grant Instagram account access: select Opt in to all current and future Instagram accounts, then click Continue.
- Finalize permissions: click Save, then click Got it.
When you first connect, Power My Analytics backfills the most recent 24 months of your Facebook Ads data. A newly created Facebook ad account can take up to 24 hours to become available in your reports.
Create a Facebook Ads Report in Data Studio
- After adding Facebook Ads as a data source in your hub, go to Reports > Data Studio.
- Select Facebook Ads under Create Data Studio Report. Data Studio opens in a new window.
- Configure the data source in Data Studio:
- Step 1: Rename the data source from "Untitled Data Source" to something you'll recognize, such as "Facebook Ads - Organization Name". Choose your Power My Analytics hub from the dropdown. Leave Use report template for new reports checked if you want to start from the PMA demo template. Click Next.
- Step 2: Under User Account, select your Facebook Ads account for real data, or Sample Account for sample data. Click Next.
- Step 3: Choose your Ad Accounts, Action Attribution Setting, Attribution Window, and Currency (see Choose an Attribution Window below). Optionally check Allow "Ad Accounts" to be modified in reports, Allow "Action Attribution Setting" to be modified in reports, or Allow "Attribution Window" to be modified in reports so report editors can change these settings later. Click Connect in the top right.
- Step 4: Click Create Report in the top right.
If you need the setting "Is Campaign using SKAdNetwork?" set to "true" for your report, submit a support ticket and our team will help.
For a quick start, open the Facebook Ads demo template and copy it with your own data source.
Choose an Attribution Window
The Attribution Window setting lets you report Facebook Ads conversions on one fixed attribution window, such as 7 Day Click or 1 Day Click + 1 Day View, for every ad set in your report. You'll find it next to Action Attribution Setting in your Facebook Ads configuration in Data Studio, the Google Sheets and Microsoft Excel add-ons, and Data Builder.
Attribution Window options
| Option | What it reports |
|---|---|
| Adset Attribution Setting (Default) | Conversions as attributed by your Action Attribution Setting. With that setting on its default, each ad set uses its own attribution setting from Facebook Ads Manager. |
| 1 Day Click | Conversions within 1 day after someone clicked your ad |
| 7 Day Click | Conversions within 7 days after someone clicked your ad |
| 28 Day Click | Conversions within 28 days after someone clicked your ad |
| 1 Day View | Conversions within 1 day after someone viewed your ad without clicking |
| 7 Day View | Conversions within 7 days after someone viewed your ad without clicking (see 7-day and 28-day view windows) |
| 28 Day View | Conversions within 28 days after someone viewed your ad without clicking (see 7-day and 28-day view windows) |
| 1 Day Click + 1 Day View | The 1-day click and 1-day view windows added together |
| 1 Day Click + 7 Day View | The 1-day click and 7-day view windows added together |
| 7 Day Click + 1 Day View | The 7-day click and 1-day view windows added together |
| 7 Day Click + 7 Day View | The 7-day click and 7-day view windows added together |
| 28 Day Click + 1 Day View | The 28-day click and 1-day view windows added together |
| 28 Day Click + 7 Day View | The 28-day click and 7-day view windows added together |
How Attribution Window works with Action Attribution Setting
When Attribution Window is left on its default, your Action Attribution Setting decides how conversions are attributed. Default (Adset Attribution Setting) uses each ad set's own attribution setting from Ads Manager. Account Attribution Setting uses your ad account's attribution setting.
When you select a specific Attribution Window, conversion metrics use that window for every ad set, whatever each ad set's own setting is. Because every ad set reports on the same window, campaign and account totals add up even when your ad sets use different attribution settings in Ads Manager.
Conversion and action metrics follow the Attribution Window. These include Purchases, Leads, Adds to Cart, custom conversions, custom events, conversion values, purchase ROAS, Video Plays, ThruPlays, Cost per ThruPlay, and unique action metrics.
Meta does not attribute outbound click metrics (Outbound Clicks, Unique Outbound Clicks, and their CTR and cost-per metrics) or video watch metrics (video watched to 25%, 50%, 75%, 95%, and 100%, 30-second video plays, and average watch time) to an attribution window. These always follow your Action Attribution Setting.
Which Action Attribution Setting to choose
Keep Action Attribution Setting on Default (Adset Attribution Setting) so your report matches Facebook Ads Manager. Ads Manager reports each ad set's conversions on that ad set's own attribution setting, and Default requests your data from Meta the same way. Meta moved attribution settings from the ad account to each ad set in 2021, so Default is the right choice for most reports.
To check an ad set's attribution setting in Ads Manager, open the ad set and find Attribution setting with its performance goal. To see conversions on other windows in Ads Manager, open the Columns menu and select Compare Attribution Settings. To match one of those columns in your report, choose the same window in Attribution Window, if it's one of the options listed above.
Things to know before you choose a window
Combination options add two windows together. Metrics that can't be added across windows, such as unique metrics (for example Unique Purchases) and Cost per ThruPlay, read 0 when you choose a click + view option.
Older dates may read 0. Windowed metrics read 0 for dates Power My Analytics last synced before October 26, 2026, when the Attribution Window setting was added. Each daily data sync refreshes your most recent 28 days, so this typically affects dates before late September 2026. To fill in those dates, backfill your Facebook Ads data source for the date range you need. A backfill restores windowed data as far back as Meta provides insights for your ad account, except the 7-day and 28-day view windows described below.
7-day and 28-day view windows
On January 12, 2026, Meta stopped returning the 7-day view and 28-day view attribution windows through its API and did not name a replacement. For details, see Meta's announcement.
The 7 Day View, 28 Day View, 1 Day Click + 7 Day View, 7 Day Click + 7 Day View, and 28 Day Click + 7 Day View options use the 7-day and 28-day view data that Meta still returns today. These options work now, but Meta may stop returning this data without notice, and if that happens the view portion of these options will read 0. A backfill can't restore 7-day or 28-day view data for older dates. For reporting you can rely on long term, choose a click window, 1 Day View, or a click + 1 Day View option.
What You'll See in Your Report
The Facebook Ads connector provides the same metrics you see in Facebook Ads Manager, organized for the most common reporting needs. For the complete list of fields, see the Facebook Ads Schema Explorer.
Popular metrics by report type
- Performance overview: Reach, Impressions, Frequency, CPM, Amount Spent
- Campaigns (performance): Reach, Impressions, Amount Spent
- Ad sets (delivery): Reach, Frequency, Cost per 1,000 People Reached, Impressions, CPM
- Ads (engagement): Post Reactions, Post Comments, Post Saves, Link Clicks, Page Likes, CPC
- Video engagement: Video Plays, ThruPlays, video plays at 25%, 50%, 75%, 95%, and 100%, Average Play Time
- App engagement: App Installs, Cost Per App Installs, Post Reactions, Post Comments, Post Saves, Post Shares
- Offline conversions: Offline Purchases, Offline Purchases Conversion Value, Cost per Purchases, Offline Leads, Cost per Leads, Offline Other Conversions, Cost per Offline Other Conversions
- Locations and DMA: Reach by location; Impressions and Link Clicks by Designated Market Area
- E-commerce pixel events: 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: Landing Page Views, Website Content Views, Website Registrations Completed, Website Searches, Website Leads, Website Leads Conversion Value
- Qualified leads (from your CRM's sales funnel stages): Qualified Leads, Cost per Qualified Lead, Conversion Lead Rate
- Hourly and device breakdowns: Reach, Impressions, Amount Spent
- Live pixel events (hourly): Live Landing Page Views, Live Content Views, Live Leads, Live Adds to Cart, Live Purchases
- Actions: On-Facebook Purchases, Website Purchases, Offline Leads, Website Leads
- Boosted posts: the boosted posts associated with each campaign
- Custom conversions and custom events
Choosing the right metrics for website actions and pixels
Field names in the connector come from Meta's API, not from the names you may use in your own reports. For example, you might call a metric "Leads from Facebook Ads", but Meta's API calls it "On-Facebook Leads", so that is the field to use. Common matches between Ads Manager and the connector include:
- Website Purchases → Website Purchases
- Website Purchases Conversion Value → Website Purchases Conversion Value
- Website Purchase ROAS → Website Purchase ROAS
- Cost Per Purchase → Cost Per Purchases
- Lead → Leads
- Cost Per Lead → Cost Per Leads
To find a custom pixel field, search the field list for words in its name. Fields named in a language other than English appear in that language, so descriptive, easy-to-find names (such as "Demo Requests Facebook Ad Clicks") make reporting easier.
Custom events
The connector automatically includes any custom events configured in Facebook Ads. In Data Studio, reconnect your Facebook Ads data source for new custom events to appear. In Google Sheets, Excel, Data Builder, and data exports, custom event fields appear automatically.
Ad image fields
- Ad Creative Image is the recommended image field for most reports. It shows the high-resolution Ad Image URL when available and falls back to the Thumbnail URL otherwise. You may need to reconnect your Facebook Ads data source in Data Studio to see it.
- Ad Image URL is the highest quality image, but it is not available for every ad type.
- Thumbnail URL is lower quality but available for all ads.
- Image Asset URL, Video Asset Thumbnail URL, and Video Asset Thumbnail Hash are Dynamic Creative fields and can only be used with Impressions, Clicks (All), Amount Spent, and Reach.
Good to Know
- Backfill: Your first connection backfills 24 months of data, and backfills are limited to 2 years. Lifetime metrics cover 37 months.
- Time zone: All Facebook Ads data is reported in Pacific Time (UTC-8:00, or UTC-7:00 during Daylight Saving Time).
- Reach and unique metrics: Reach and metrics beginning with "Unique" are live metrics and can't be summed across days. When a unique metric is paired with a date dimension, your report shows cached data rather than live data.
- Live breakdowns: Age, Gender, Country, Region, DMA, Impression Device, Product ID, Frequency Value, Hour of Day, Place Page ID, Publisher Platform, Placement, Device Platform, and User Segment Key are requested live from Meta. Including any one of them makes the whole chart run live, so large reports (especially by Country) can take several minutes to load. Use shorter date ranges or fewer breakdowns per chart to keep reports fast.
- Campaign Daily Budget: Only the current value is available; historical budget values are not.
- URL fields after a new report: Website URL, Link URL, and other URL fields can stay blank for 2 to 4 hours (longer for very large accounts) while they backfill. They fill in automatically.
- DMA uses Comscore Markets: Meta replaced the Nielsen DMA breakdown with Comscore Markets in June 2026. The connector maps Comscore Markets to the existing DMA field, so your reports keep working with no action needed. Market names are unchanged, but the numeric market codes are different from the old DMA codes.
- User Segment Key: This audience segment breakdown is supported for Advantage+ Shopping and Advantage+ Sales campaigns. Other campaign types return "unknown".
- Custom metrics from Ads Manager: Recreate the custom metric's formula as a calculated field in your report, or as a calculated field in Data Builder with Create Field (Beta), which then flows to every destination like a native field.
Facebook Ads Data Connector Limitations
Most of the limitations below come from Meta's API and affect every third-party tool that reports on Facebook Ads, not just Power My Analytics.
Historical data for specific fields
Because of changes to Meta's API, new data requests for some fields are limited in how far back they can go. Fields beginning with unique_actions and cost_per_unique_action_type, and Hour of Day - Advertiser Time Zone, are limited to 13 months. Frequency Value is limited to 6 months.
What does this mean for me?
Data Power My Analytics already synced for these fields stays available beyond these limits, but a new backfill can't reach further back than Meta allows.
Reach with breakdowns
Since June 10, 2025, reports that combine the Reach metric with a breakdown are limited to the last 13 months (394 days). Affected breakdowns include Age, Gender, Country, Region, DMA, Placement, Platform Position, Publisher Platform, Device Platform, Impression Device, Conversion Device, Hour of Day, Action types, Action Target ID, Carousel Card, Place Page ID, and Template URL. See Meta's 2025 API changelog for the full list.
What does this mean for me?
If you need Reach by a breakdown for periods older than 13 months, report it without the breakdown, or keep a copy of the older data in Google Sheets or BigQuery.
Data that isn't available
Meta's API does not provide the following, so they can't be reported through the connector:
- Purchase breakouts by device and publisher platform
- Offsite metrics
- Conversions by country
- Breakdowns by objective (see the workaround below)
- 2-second continuous video views (the closest available metric is 3-second video plays)
- The Results and total Result Rate columns from Ads Manager
The connector also doesn't currently include Instagram follows or Instagram profile visits attributed to your campaigns, such as the Instagram follows column in Ads Manager.
What does this mean for me?
Use the workarounds in this guide where they exist: breakdowns by objective, result rate, and the Results column. For Instagram follower growth, add Instagram Insights or Facebook Insights as data sources; those report overall followers (organic and paid combined).
Off-Facebook actions and iOS 14 privacy changes
Since April 27, 2021, Apple's iOS 14 privacy changes limit what Meta can report for off-Facebook actions. Off-Facebook action metrics can't be broken down by Country, Region, DMA, Hour of Day, Age, Gender, Conversion Device, Device Platform, Placement, Publisher Platform, Impression Device, Action Target ID, Product ID, or Carousel Card.
What does this mean for me?
Breakdowns by publisher platform may show "unknown" or zero for conversions. This also applies in Ads Manager and every other reporting tool. On-Facebook metrics are not affected.
Attribution settings and totals
Meta can't add conversions together across ad sets that use different attribution settings. When ad sets in the same report use different settings (for example "7 day click, 1 day view" and "1 day click, 1 day view"), totals and scorecards can show zero or a dash.
What does this mean for me?
Choose a specific Attribution Window so every ad set reports on the same window and totals add up. If Ads Manager itself shows a zero or dash for a total, your report will show the same.
Advantage+ Catalog ad images
For Advantage+ Catalog (dynamic product) carousel ads, Meta picks product images from your catalog at the moment each ad is shown and doesn't return them through its API. Ad Creative Image, Ad Image URL, and Thumbnail URL show the same generic placeholder for these ads. Static (non-catalog) carousel ads are not affected.
What does this mean for me?
Report product-level performance with the Product ID dimension and pull product images from your own product catalog feed. Reconnecting the data source does not change this. Use the Is Dynamic Creative field to identify dynamic ads.
Instagram boosted post URLs
Boosted Instagram posts return a facebook.com URL rather than an Instagram post URL, because Meta delivers Instagram ads through Facebook's ad system. All other data, including the creative and caption, matches the Instagram post.
What does this mean for me?
Identify boosted posts by creative or caption instead of URL. For Instagram-native URLs of organic posts, use the Instagram Insights connector.
Breakdown combinations
Meta only allows certain combinations of dimensions and metrics in one request. If you see "Current combination of data breakdown columns is invalid", your chart combines fields Meta can't return together. The most common rules are:
- Dynamic Creative asset fields (such as Body Asset Text, Image Asset URL, Title Asset Text, and Video Asset fields) can only be used with Impressions, Clicks (All), Amount Spent, and Reach.
- Hourly breakdowns can't be combined with Reach, Frequency, or fields beginning with "unique" or "video".
- Frequency Value can only be used with Reach.
- Estimated Ad Recall Lift Rate and ThruPlays can't be broken down by DMA.
- Video play percentage and average play time fields can't be broken down by Region.
See Meta's Combining Breakdowns documentation for the full list.
What does this mean for me?
Split the chart into two charts, or remove one of the breakdowns, so each chart only uses combinations Meta supports.
Create Facebook Ads Breakdowns by Objective
Ads Manager can break results down by objective, but Meta's API can't, so charts may show "multiple" under Objective. To segment campaigns by objective, add a filter to your table: choose Include > Campaign ID (ad sets, campaign insights, campaigns, insights) > RegExp Match, and enter the campaign IDs that belong to each objective.
Report Facebook Ads Custom Conversions in Data Studio
Each custom conversion in your ad account has its own field, named after the custom conversion, plus a conversion value field (the custom conversion's name followed by Conversion Value). Website Conversions adds up all of your custom conversions. In Data Studio, reconnect your data source to see a custom conversion you created after the data source was set up.
To list custom conversions and other actions in one table, use the dimension Actions Collection Key [collection] with the metric Actions Collection Value [collection]; the key shows each action by its field name, including each custom conversion by its name. Use these two fields together, one pair per chart, and make any other field in that chart a dimension (such as Campaign Name), not a metric. By default, the custom conversions template shows all custom conversions and their totals for the selected date range across all campaigns, ad sets, and ads.
Filter custom conversions by campaign
- Click Add a control and select Drop-down list. Place the control in your report.
- In the Control sidebar, set the control field to Campaign Name.
- Use the dropdown to choose the campaigns you want to report on.
Look up custom conversions by name
- Select the custom conversions chart. In the Chart sidebar, scroll to Filter and click Add a filter, then Create a filter.
- Name the filter, for example "Custom Conversion filter".
- Next to Include, select Actions Collection Key [collection] and the condition Contains.
- Enter your search term, such as "purchase", and click Save.
Report Facebook Ads Result Rate
Meta's API doesn't provide the total Result Rate across all result types. Instead, you can create a result rate for a specific result, such as link clicks, leads, or conversions, by dividing it by Impressions in a calculated field.
Add a result rate to one chart
- Select the chart. In the Chart sidebar under Metric, click Add metric, then Add calculated field.
- Name the field, for example "Link Clicks Result Rate".
- Set Data Type to Numeric > Percent and Display Format to Percent(2).
- In Formula, enter
SUM(Link Clicks)/SUM(Impressions), replacing Link Clicks with the metric you need. Click Apply.
Add a reusable result rate to the data source
- In the Data sidebar, click Add a field, then Add calculated field.
- Name the field and enter
SUM(Link Clicks)/SUM(Impressions), replacing Link Clicks with the metric you need. Click Save, then Done. - Click the pencil icon next to the new field and set Data Type to Numeric > Percent and Display Format to Percent(2).
The field is now available in every chart that uses this data source.
Facebook Ads Troubleshooting
Facebook connector authorization error
Error: "Authorization Error - Error validating access token: The session has been invalidated because the user changed their password or Facebook has changed the session for security reasons."
This happens when your Facebook password changes or Facebook ends the session for security reasons. Reconnect your source:
- Go to your Power My Analytics hub and click Sources.
- Find the Facebook Ads source, open the three-dot Action menu, select Remove source, and click Confirm.
- Click + Add new source, select Facebook Ads, and sign in again.
Removing and reconnecting the source does not affect your existing reports.
A Facebook Ads or Instagram account is missing from the list when creating a report
You don't need to remove and reconnect your Facebook Ads source when you add an account to your Business Manager. Your hub updates the list of accounts your source can access every night, and you can update it right away:
- In your Power My Analytics hub, go to Sources, click the three-dot menu in the Actions column next to your Facebook Ads source, and select Add or remove accounts. If the account is listed, check it and click Save.
- If the account isn't listed, select Refresh accounts from the same menu, wait for the Accounts refreshed message, and then select Add or remove accounts again.
- If you added the account in Facebook within the last 24 hours, Meta may not have made it available yet. Wait 24 hours, then refresh again.
If the account still doesn't appear, see A Facebook Ads Account Is Missing From The List When Trying To Create A Report for the permission checks and what to do next.
Missing sums or zeroes on campaign reports
Zeroes or dashes in totals usually mean your ad sets use different attribution settings, which Meta can't add together. Choose a specific Attribution Window so every ad set reports on the same window, and keep Action Attribution Setting on Default (Adset Attribution Setting). If Ads Manager shows a zero or dash for the same total, your report will too.
If numbers still don't match Ads Manager, submit a support ticket with a screenshot from Ads Manager, a screenshot from your report, edit access to the report, and the page where the difference appears.
My report doesn't match Ads Manager
- Use the same date range in both, and exclude today, because Meta's API can lag behind Ads Manager.
- Make sure your data has been backfilled for the date range you're comparing.
- Check that you're using the matching field (see Choosing the right metrics for website actions and pixels). If you're comparing with the Results column, use the field that matches the label under the Results number (see Why Leads in Your Report Don't Match Results in Ads Manager).
- Make sure your attribution window matches the one shown in Ads Manager (see Which Action Attribution Setting to choose).
New campaigns show N/A for the campaign name
Campaign, ad set, and ad names come from a list that Power My Analytics refreshes with each nightly data sync, while metrics for dates that haven't synced yet come straight from Meta. A campaign created since the last sync can therefore show metrics with an N/A, null, or blank name. The name fills in on its own after the next nightly sync, for every date in your report, so you don't need to backfill or reconnect. See New Facebook Ads Campaigns Show N/A for the Campaign Name.
Data appears on the wrong date
Facebook Ads data is reported in Pacific Time, so if you're in a time zone far ahead of it (such as Australia or New Zealand), activity can land on the adjacent day. Use time series charts for date-by-date views, use specific date ranges rather than relative ones like "Last Month", and end month-end comparisons a few days early.
"Business Management Permissions Are Required to Access This Field"
Power My Analytics doesn't have the business permission it needs. In Facebook, go to Settings & Privacy > Settings > Business Integrations, find Power My Analytics, click View and Edit, enable Manage your Business, and save. Then reconnect your Facebook Ads source in your hub.
The Results field shows zeroes
The DEPRECATED - Results field is calculated from the campaign objective, not from each ad set's performance goal the way the Results column in Ads Manager is, so it can read 0 and doesn't match Ads Manager. Use the field for the result you're measuring instead, such as Leads, Website Leads, or a custom conversion: see Why Leads in Your Report Don't Match Results in Ads Manager.
Conversion scorecards show zero
When campaigns use different attribution settings, Meta doesn't return a total, so a conversions scorecard can show zero. Choose a specific Attribution Window so the total adds up. As an alternative, build a Google Sheets report with Conversions by Campaign Name using the PMA Sheets add-on, add that sheet to your Data Studio report with Google's Sheets connector, and use it as the scorecard's data source.
Custom events are not showing
Reconnect your Facebook Ads data source from within Data Studio. Custom event fields appear after reconnecting.
Qualified leads in Ads Manager don't match my report
The Qualified leads column in Ads Manager is a total Meta calculates from the lead statuses your CRM sends, grouped by the sales funnel stages you set up in Ads Manager. Your report has the same total in the Qualified Leads field, along with Cost per Qualified Lead and Conversion Lead Rate.
- Add Qualified Leads to your chart. In Data Studio, if an existing data source doesn't list it, click Refresh Fields in the data source (Resource > Manage added data sources > Edit).
- Check that your report's date range and attribution window match Ads Manager.
- If Qualified Leads reads 0 for older dates that show qualified leads in Ads Manager, backfill that date range.
For more detail, see How to Report Qualified Leads from Ads Manager.
Need More Help?
If you can't find the answer here, submit a support ticket and our team will help.