Facebook Ads Data Connector Limitations

Facebook Ads Data Connector Limitations

Info
This article covers the limitations, considerations, and workarounds for working with Facebook Ads data in Power My Analytics. For instructions on connecting your Facebook Ads account and creating reports, see the Facebook Ads Data Connector User Guide.

General Limitations and Considerations

  • Backfilling: An initial backfill of 24 months of data will be performed when you first connect your Facebook Ads account as a data source.
  • Data Span: Lifetime metrics cover 37 months of data.
  • Live Metrics: Reach and metrics starting with "unique" are live metrics and cannot be used in daily sums.
  • Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For this reason, only cached data will appear in a report or chart that pairs a unique field with the date dimension. For more information, see Cached Data Requests in Facebook Ads with Unique Metrics and Date Dimension.
  • Campaign Daily Budget: Only current values for Campaign Daily Budget are available; historical data is not available for this field.
  • User Segment Key (Audience Segment Breakdown): The User Segment Key field is supported for Advantage+ Shopping and Advantage+ Sales campaigns. For other campaign types, this field will return "unknown." These segment values depend on Meta's internal audience classification and may not appear if insufficient data is available, and the availability and behavior of this breakdown may vary by account, campaign setup, and reporting level.
  • Advantage+ Campaign Types: As of May 19, 2026, Meta no longer allows creating, duplicating, or updating legacy Advantage+ shopping campaigns and Advantage+ app campaigns through its Marketing API. This change affects campaign management tools only; it does not affect Power My Analytics. PMA collects and reports your Facebook Ads data and does not create or modify campaigns, so reporting for your existing and new Advantage+ campaigns continues as normal.
  • New Account Delay: Wait 24 hours after adding a new account in Facebook before using it in PMA reports.
  • Time Zone: All data is reported in time zone UTC-8:00 (UTC-7:00 during Daylight Saving Time).
  • API and Authentication: Facebook and Instagram use the same underlying API. PMA's Facebook Ads, Facebook Insights, and Instagram Insights data connectors use the same authentication process.

Geographic (DMA) Breakdown: Meta's Move to Comscore Markets

Notes
As of June 2026, Meta retired the Nielsen DMA (Designated Market Area) geographic breakdown and replaced it with Comscore Markets. Power My Analytics handles this automatically: the connector requests the new breakdown from Meta and continues to deliver it under the same DMA field, so your field names, warehouse columns, and dashboards are unchanged and no action is needed. Because the underlying numeric market codes differ between the two systems, reporting that relies on the numeric market code (rather than the market name) may see different code values. For details, see Facebook Ads: DMA Breakdown Now Uses Meta's Comscore Markets.

Removed Configuration Options

The following configuration options have been removed from the Facebook Ads connector due to changes in Meta's API:

  • action_attribution_windows: This configuration option is no longer available. Attribution is now managed at the ad set level within Facebook Ads Manager.

Historical Data Limitations for Specific Fields

Due to changes in Meta's Facebook Ads API, the following fields have limitations on how far back historical data can be retrieved via API requests:

Field Historical Data Limitation
Fields starting with unique_actions 13 months
Fields starting with cost_per_unique_action_type 13 months
Hour of Day - Advertiser Time Zone 13 months
Frequency Value 6 months
Notes
These limitations apply to new API calls only. If the data has already been cached in Power My Analytics' database through previous data syncs, PMA can provide historical data beyond these limitations.

Reach Reporting Limitations

As of June 10, 2025, reports that combine the Reach metric with breakdowns will have this report data limited to the last 13 months (394 days). This is due to a change in Meta's API. Reach data will only be available for the most recent 13 months when used with the following breakdowns:

  • Action Target ID
  • Action types/Action type with custom labels
  • Age
  • Applink Treatment
  • Carousel Card ID
  • Carousel Card Name
  • Conversion Device
  • Country
  • Device Platform
  • DMA
  • DMA Code
  • Gender
  • Hour of Day - Advertiser Time Zone
  • Hour of Day - Audience Time Zone
  • Impression Device
  • Place Page ID
  • Placement
  • Platform Position
  • Publisher Platform
  • Region
  • Template URL

For more information, please see Meta's 2025 API Changelog.

Unavailable Data

The following data is not available through Meta's Facebook Ads API and cannot be reported through Power My Analytics:

  • 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 Data Studio, if your custom events have not appeared as available fields in your report, reconnect the Facebook Ads data source from within Data Studio. The custom events fields should appear after reconnecting.

Replicating Custom Metrics

Custom metrics can be replicated with formulas in your report:

Custom metrics formula example

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.

Breakdown by objective filter example

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.

Working with Ad Image Fields

Notes
Power My Analytics offers multiple image-related fields for Facebook Ads. Understanding their differences will help you choose the right field for your reports.

The Ad Creative Image field is recommended for most use cases. This field automatically displays the highest-quality image available:

  • Uses the high-resolution Ad Image URL when available
  • Falls back to the Thumbnail URL when Ad Image URL is not available
  • Ensures your reports display an image for each ad (for Advantage+ Catalog dynamic ads, this will be a generic placeholder image; see Carousel Images for Advantage+ Catalog Ads below)
  • For boosted Facebook Page posts, may repeat the same image (your Page's profile picture) across different ads; see Repeated Images for Boosted Page Posts below
Notes
To access this field, you may need to reconnect your Facebook Ads data source in Data Studio.

Individual Image Fields

Field Quality Availability Notes
Ad Image URL High Not always available Best quality; may not render for all ad types
Thumbnail URL Low Most ad types Lower resolution. For boosted Facebook Page posts, Meta returns the Page's profile picture instead of the post image, so this field can repeat the same image across ads (see Repeated Images for Boosted Page Posts below). For Advantage+ Catalog (dynamic product) ads, returns a generic placeholder image
Image Asset URL Medium Dynamic Creative only Live data; can only be used with Impressions, Clicks, Amount Spent, and Reach
Notes
If every carousel ad in your report shows the same generic image, your ads are most likely Advantage+ Catalog Ads. This is expected behavior caused by a limitation in Meta’s API.

Carousel ads created as Advantage+ Catalog Ads (also known as Dynamic Product Ads) do not return their carousel card images through Meta’s Marketing API. Meta builds these ads from your product catalog at the moment each ad is shown, selecting different products for different viewers. Because the images are chosen at display time, they are never stored as part of the ad creative, and the API provides only a generic placeholder thumbnail.

As a result, image fields such as Ad Creative Image, Ad Image URL, and Thumbnail URL will display the same placeholder image for these ads. This is a limitation of Meta’s API rather than a Power My Analytics issue, and it affects all marketing data connectors. Reconnecting your Facebook Ads data source will not change this behavior. Standard image ads and static carousel ads are not affected; their image fields work normally.

Because Meta chooses which products to show each viewer at the moment of impression, there is no way to match specific product images to specific ad creatives or performance metrics through the API. However, you can still get useful insight into these ads:

  • Use the Product ID dimension to report performance by individual product.
  • Reference product images directly from your own product catalog feed, which is the original source of the images in these ads.
  • Use the Is Dynamic Creative field to help identify dynamic ads in your reports.

If you have questions about reporting on Advantage+ Catalog Ads, please submit a ticket and our support team will be happy to help.

Repeated Images for Boosted Page Posts

Notes
If the same image (often your Page's profile picture) repeats across different boosted-post ads, this is expected behavior caused by a limitation in Meta's API. You can recover the correct per-ad images by blending in Facebook Insights data.
When you boost a Facebook Page post, Meta's Marketing API does not provide a separate image for each ad. Instead, it returns your Page's profile picture as the Thumbnail URL, and the Ad Creative Image field falls back to that same picture. As a result, many different boosted-post ads show the same image in your report, even though the Hub displays the correct images. Ads built as new creatives (rather than boosted posts) are not affected.

Switching to the Thumbnail URL field does not fix this, because for boosted posts that field is the Page's profile picture. Reconnecting the data source does not change it either. This is a limitation of Meta's Marketing API and affects all marketing data connectors, including Supermetrics, Fivetran, and Funnel.io.

The correct post image is available in the Facebook Insights connector's Posts table, in the Full Picture field. Blend it into your Facebook Ads report:
  1. In your Hub, make sure the relevant Page is selected as an active account in the Facebook Insights connector.
  2. In your Data Studio report, blend your Facebook Ads data source with the Facebook Insights Posts data source (left outer join, with Facebook Ads on the left).
  3. Set the join key to Effective Object Story ID (Facebook Ads) = Post ID (Facebook Insights). Both use the same {pageID}_{postID} format.
  4. Use Full Picture (from Facebook Insights) as your image field.
For step-by-step instructions, see Same Image Repeats in Facebook Ads Boosted Posts.

Video Ad Thumbnail Fields

For video advertisements, the following thumbnail-related fields are available:

  • Video Asset Thumbnail URL — Direct URL to the video thumbnail (Dynamic Creative breakdown)
  • Video Asset Thumbnail Hash — Internal identifier for the thumbnail image

Limitations:

  • Video thumbnail fields are part of the Dynamic Creative asset breakdowns and can only be used with the metrics Impressions, Clicks (All), Amount Spent, and Reach
  • An image will only be returned for ads that include image or video creatives; non-visual ad types will not return images
  • Meta's API does not provide a dedicated field to identify specific ad formats (Reels, Standard, Videos, etc.)

Troubleshooting

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

    • Related Articles

    • 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 ...
    • 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 ...
    • Instagram Insights Data Connector User Guide

      Instagram Insights provides valuable data about your Instagram business or creator account's performance, audience, and content. This guide will walk you through connecting Instagram Insights to Power My Analytics and creating reports with the data. ...
    • Troubleshooting Facebook Ads

      Meta's Facebook Ads API is complex and often difficult to work with due to continuous changes and little documentation or support. Here you will find the most up-to-date information we have to troubleshoot issues that arise while making Facebook Ads ...
    • Reddit Ads Data Connector User Guide

      Power My Analytics' Reddit Ads data connector allows you to automatically collect, store, and visualize your Reddit advertising data. This guide will walk you through connecting your Reddit Ads account and understanding key metrics to help you make ...