How to Use Hourly Refreshes

How to Use Hourly Refreshes

Info
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).
Alert
Plan Eligibility: Hourly refreshes are available on any paid plan. On Business and Pro plans, hourly refreshes are an optional add-on for $49.95/month; on Custom plans, they are included when your plan agreement covers them. Hourly refreshes are added by our team on request (not a self-serve purchase in the hub), so to get started, contact our sales team or submit a ticket. Hourly refreshes are not available on the Free plan, which uses sample data only.

Legacy plan subscribers: If you subscribed to a Hourly Refreshes add-on prior to 2026 under a legacy plan, your existing hourly refresh configurations will continue to function. Please contact our support team with any questions about your legacy add-on.

What Are Hourly Refreshes?

Power My Analytics' Google Sheets reports and data exports can be configured to refresh on a scheduled basis: monthly, weekly, daily, or hourly. Hourly refreshes are available on any paid plan (as an add-on on Business and Pro, and included on Custom when your agreement covers it), ensuring that reports always reflect the most current data available from your connected sources.
Hourly refreshes can be configured for the following destinations:
  • Google Sheets reports
  • Data exports (BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP)
Notes
Note: Hourly refreshes can only be performed for reports that contain at least one live data field. Live fields can be identified in the Schema Explorer by the yellow lightning bolt icon next to the field label.

Schedule Your Hourly Refresh

To configure an hourly refresh for your Google Sheets report or data export, choose your destination from the list below and follow the instructions in the linked article. When selecting a refresh schedule during setup, choose Hourly as your refresh frequency.

Google Sheets

Data Exports

How to Add Hourly Refreshes

Hourly refreshes are available on any paid plan. On Business and Pro plans, they are an optional add-on for $49.95/month; on Custom plans, they are included when your agreement covers them. Because hourly refreshes are enabled by our team rather than self-serve, just contact our sales team or submit a ticket to add them to your plan.
If you need even more from Power My Analytics, the Custom plan may also optionally include the following, depending on the terms of your specific agreement:
  • Data exports to BigQuery, SQL databases, Amazon S3, FTP, and more
  • Sovereign data warehousing options
  • Access to the Power My Analytics API
  • A dedicated account representative and end-to-end onboarding
  • SLAs, NDAs, and custom contracts
Custom plans are tailored to each customer's needs. Please contact our sales team to discuss your requirements, or learn more in the Custom Plan Guide.

Still Have Questions?

No worries, we're happy to help!

    • Related Articles

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

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

    • 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 to Use Sample Data

      Sample Data allows you to showcase templates and reports to potential clients without sharing sensitive information. Read this article to learn how to use Sample Data in Data Studio. Can I Use Sample Data? Currently, Sample Data is only available to ...

    • How to Use Schema Explorer

      The PMA Schema Explorer is an easy way to find metrics and dimensions that are available for your connectors and identify any possible conflicts or errors. Schema Explorer can find additional fields that are compatible with your selected fields and ...

    • Add and Remove Accounts from Data Sources

      Within a connected data source, accounts are subsets of data within data sources that can be selected individually to sync with PMA's data warehouse and use in reports. Accounts correspond to divisions within the data connector's platform, such as ...