What Time Does My Data Refresh?

What Time Does My Data Refresh?

After you create a report with PMA, your report's data will be updated automatically. This article explains how to choose the sync time for your data to refresh.

When Does My Report's Data Refresh?

Most connectors default to refresh every day at midnight 00:00 UTC (Universal Time) and can be edited, with the following exceptions.
  1. All Pinterest connectors are fixed to refresh at midnight UTC and cannot be changed.
  2. All Facebook, Instagram and YouTube connectors are fixed to refresh at midnight Pacific Time (UTC -08:00) and cannot be changed.

Change Your Report's Sync Time

Go to your hub and click Sources. 



Click Sync Time and select a time zone.



Your report's sync time is now updated to midnight in the selected time zone.

How to Pull Live Data

Between scheduled refreshes, you may also want to update your report with the latest live data.
  1. When using a PPC (advertising) connector: Include today's date in the report and refresh the report to load live data.
  2. When using a non-PPC (non-advertising) connector: Do a manual backfill from your hub and refresh the report to load live data.

Understanding Cached and Live Data Requests

  1. A date range that excludes today will trigger a cache request to PMA's data warehouse, retrieving the cached historical data.
  2. A date range that includes only today will trigger a live request to the connector's API, bypassing PMA's data cache and retrieving the data directly.
  3. A date range that includes both today and historical dates (such as yesterday, last 30 days, and so on) will trigger a hybrid request, retrieving data using both a live request and a cache request and joining this data together.

    • Related Articles

    • How to Create an FTP Export

      FTP can be a valuable way for Custom plan users whose plan includes data exports to export their Data Builder reports. Data exports are not automatically included in all Custom plans; availability depends on the terms of your specific agreement. In ...

    • Understanding Sync Time and Data Settling with Facebook Ads

      Facebook Ads data does not become immediately available at the end of each calendar day. Instead, the data "settles" gradually over several hours after midnight in the ad account's configured time zone. Understanding this settling behavior is ...

    • Unable to Schedule Refresh in Google Sheets

      This article will address the following error: Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value." Cause Google Sheets requires you to set a Time Zone. Additionally, you must be a member of the report's hub in order to ...

    • Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data

      Keeping your marketing data up-to-date is crucial for accurate reporting and analysis. This guide will walk you through configuring your data source sync time and Google Sheets scheduled refresh to ensure you're always working with the most recent ...

    • Report Data in Power BI

      Power My Analytics offers a native Power BI connector that allows you to load your Data Builder datasets directly into Power BI Desktop for custom reports and dashboards. This guide walks you through connecting your PMA hub to Power BI, installing ...