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 on the Custom plan if your negotiated agreement includes this feature.
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. However, new hourly refresh schedules cannot be added to legacy plans that are not Custom. 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 to Custom plan subscribers whose plan includes this feature, 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, FTP)
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 Export to BigQuery
- How to Export to MySQL
- How to Export to Azure SQL Database
- How to Export to PostgreSQL
- How to Export to Amazon S3
- How to Create an FTP Export
Not on the Custom Plan?
Hourly refreshes are exclusively available on the Custom plan. If you're on a Free, Business, or Pro plan and need access to more frequent data updates, upgrading to the Custom plan is the best path forward. The Custom plan may also optionally include the following features, 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 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 Looker Studio. Can I Use Sample Data? Currently, Sample Data is only available ...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 ...How to Use the SQL Connector
Power My Analytics now offers an SQL connector in addition to our Hosted SQL solution. This article will help you get started with using our SQL connector and set up a MSSQL or MySQL query. Connect to your server in the Hub Select Sources in the left ...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 ...