Cached Data Requests in Facebook Ads with Unique Metrics and Date Dimension
When creating reports with Facebook Ads that include unique metrics paired with date dimensions, Power My Analytics automatically uses cached data instead of live data. This article explains this behavior, what it means for your Facebook Ads reports, and best practices for working with these data combinations.
Understanding Cached vs. Live Data in Facebook Ads
When working with metrics in Power My Analytics, you'll encounter two types of data retrieval:
- Live Data: Data that's retrieved directly from the source platform in real-time
- Cached Data: Pre-collected data warehoused in our system for faster access
When Does PMA Use Cached Data in Facebook Ads?
When a unique metric is paired with the date dimension in a Facebook Ads report, 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.
What Are Unique Metrics?
Unique metrics in Power My Analytics typically refer to specialized data points that track distinct entities or actions, such as:
- Unique visitors
- Unique user IDs
- Unique conversion events
- Unique session counts
- Other metrics with "unique" qualifiers
Due to changes in Meta's Facebook Ads API, the following unique 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 |
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.
What This Means for Your Reports
When using unique metrics with date dimensions, the data in your reports will reflect the most recent cached data, not real-time information. This is important to consider when analyzing time-sensitive metrics.
For additional assistance, please contact our support team.
Related Articles
Facebook Ads Data Connector Limitations
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 ...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 ...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 ...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 ...