How Often Your Data Refreshes (and How to Add Hourly Refreshes)

How Often Your Data Refreshes (and How to Add Hourly Refreshes)

Info
Power My Analytics keeps your marketing data current with an automatic daily Data Sync. If you need updates more often than once a day, the Hourly Refreshes add-on lets your reports and data exports refresh as frequently as every hour. This article explains the default refresh schedule, what the Hourly Refreshes add-on does, who can get it, and how to request it.

How Power My Analytics Refreshes Your Data by Default

Every data source you connect is kept up to date by Data Sync, an automatic daily refresh. Here is what to expect out of the box:
  • When it runs: Once per day, at midnight in your selected time zone.
  • What it collects: The most recent 7 days of data from the source, so recent changes and late-reported conversions are captured.
  • Where to check it: Sync status is shown at both the data source level and the account level.
You can set the time your sources sync under Actions > Set sync time. (For Facebook, Instagram, Pinterest, and YouTube, the sync time is fixed and cannot be changed.)

For most reporting needs, a daily Data Sync keeps your dashboards and exports current. If your workflow needs fresher data during the day, read on.

What the Hourly Refreshes Add-On Does

The Hourly Refreshes add-on lets you schedule how often your destinations update, all the way down to once per hour. When you set up a supported destination, you can choose a refresh frequency of monthly, weekly, daily, or Hourly.
Hourly Refreshes can be configured for these destinations:
  • Google Sheets reports
  • Data exports (BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP)
Notes
Live data required: An hourly schedule only makes sense for reports that include at least one live data field. Live fields are queried in real time, so they can update within the hour; other fields follow the daily Data Sync. You can spot live fields by the yellow lightning bolt icon next to the field label in the Schema Explorer.

Who Can Add Hourly Refreshes

Hourly Refreshes is available on any paid plan (Business, Pro, or Custom):
  • Business and Pro: Available as an add-on for $49.95/month.
  • Custom: Included when your plan agreement covers it.
Adding Hourly Refreshes is not a self-serve purchase in the hub, so you will not find it as a checkout option on your billing page. Instead, our team enables it on your account once you request it (see below).
Notes
The Free plan uses sample data only and does not connect live data sources, so Hourly Refreshes does not apply to Free accounts.

How to Request Hourly Refreshes

Because Hourly Refreshes is enabled by our team rather than self-serve, here is how to get started:
  1. Submit a ticket to our support team via the Submit a Ticket article, or email sales@powermyanalytics.com.
  2. Let us know you would like to add Hourly Refreshes and which destination(s) you would like to refresh hourly.
  3. We will confirm pricing for your plan, enable the add-on, and let you know when it is active.
Once the add-on is active on your account, you can select Hourly as the refresh frequency when configuring a supported Google Sheets report or data export. (Hourly Refreshes works with the Google Sheets and Exports destinations, so you will also need the matching Spreadsheets or Exports add-on on your plan.) For step-by-step setup instructions, see the How to Use Hourly Refreshes guide.
Alert
Pricing: Hourly Refreshes is included on Custom plans and available on Business and Pro plans for $49.95/month.

Still Have Questions?

No worries, we are happy to help!

    • Related Articles

    • How to Use Hourly Refreshes

      Power My Analytics can perform scheduled data refreshes for Google Sheets reports and data exports on a monthly, weekly, daily, or hourly basis. Hourly refreshes are available as an add-on on any paid plan (Business, Pro, or Custom). Plan ...

    • How to Use Data Exports

      Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP. Data exports are available on the Custom plan if your negotiated agreement includes this ...

    • How Data Sources Work with Power My Analytics

      We understand that getting started with a new tool can be a bit overwhelming. This article will explain how Power My Analytics connectors, data sources, and other core features work together to provide fast and reliable data for your reports. ...

    • Salesforce Data Connector User Guide

      Get valuable insights into your CRM performance by connecting your Salesforce account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations. Prerequisites Before connecting Salesforce to ...

    • 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 ...