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.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • 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 ...
      • How to Create a Report in Data Explorer

        Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your ...
      • Sample Data Guide

        Sample Data is an innovative offering from Power My Analytics. This guide will dive into the details of the Sample Data, its value, and how to use it. It covers two primary topics: The Value of Sample Data, and How to Use Sample Data. The Value of ...
      • Choose a Data Destination

        Not sure where to begin with making reports or having trouble deciding which reporting tool will be best for your business? Let us help! This article will tell you what you need to know about which reporting options are available with your plan and ...
      • Some Fields in My Report Say “No Data."

        This article will help to solve the following error in Looker Studio: Cause Looker Studio reports may display "No data" when there is data missing from the data warehouse. Resolution Check the date range specified on the report. Select a date range ...