What Time Does My Data Refresh?
Last updated
After you create a report with PMA, your report's data will be updated automatically. This article explains when your data refreshes and how to choose the sync time for your data.
When Does My Report's Data Refresh?
Each data source refreshes once a day at its sync time. By default, the sync starts at 3 AM in the data source's time zone: the time zone of the platform account you connected, or UTC if the platform doesn't provide one. Each daily sync also updates the past 7 days of data.
- Facebook and Instagram sources sync at 3 AM Pacific Time by default (UTC-8:00, or UTC-7:00 during daylight saving time).
- Pinterest sources sync at 3 AM UTC by default.
- Instagram Stories are collected every hour, so the sync time doesn't apply to them.
You can change the sync time for any data source. The sync time is when data collection starts, so allow at least 2 hours for it to finish before a scheduled report refreshes.
Change Your Report's Sync Time
- Go to your hub and click Sources.
- Click the three-dot Action menu next to the data source and select Edit sync time.
- Choose a Timezone, an Hour, or both. If you leave Hour blank, the connector's default hour is used.
- Click Save, then click Save again to confirm.
Your data source now syncs at the hour and time zone you chose. You can change a data source's sync time once per 24-hour period, and Reset returns it to the default.
Pick an hour after the day has ended in your platform account's time zone, so each sync can include the previous day. For more detail, including how daylight saving time affects scheduled Google Sheets refreshes, see Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data.
How to Pull Live Data
Between scheduled refreshes, you may also want to update your report with the latest live data.
- When using a PPC (advertising) connector: Include today's date in the report and refresh the report to load live data.
- 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
- A date range that excludes today will trigger a cache request to PMA's data warehouse, retrieving the cached historical data.
- 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.
- 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.