How to Use the Hourly Refreshes Add-On

How to Use the Hourly Refreshes Add-On

Info
Power My Analytics can perform scheduled data refreshes of reports using our Google Sheets add-on or data exports add-on. While these add-ons include the base options to schedule monthly, weekly, or daily refreshes of data, hourly refreshes are also available as a separate add-on for those who require the most recent data.

What Is PMA's Hourly Refreshes Add-On?

Power My Analytics' Google Sheets reports and data exports can be configured to schedule a regular refresh of data at monthly, weekly, or daily intervals. We've recently rolled out hourly refreshes as an add-on for customers who wish to access the most up-to-date data in their reports.
  1. If you are on an Enterprise plan, your reports and exports already include the option for hourly refreshes as part of your subscription.
  2. If you are on a Single, Business, or Pro plan, the hourly refreshes add-on is an optional feature available for an additional $49.95/month.

Step 1: Activate the Hourly Refreshes Add-On

Notes
Note: Before activating the hourly refreshes add-on, you must have already activated either the exports add-on or the spreadsheets add-on. If you have not, the option to activate the hourly refreshes add-on will be disabled.
  1. Go to your Power My Analytics hub.
  2. Click on Exports > BigQuery.



  3. Click the Exports Settings button in the upper right.



  4. Check the Enable Hourly Refreshes checkbox.



  5. Click the Confirm button to continue.



  6. The hourly refreshes add-on will appear as enabled in the export settings.


Step 2: Schedule Your Data Refresh

To configure a scheduled refresh for your Google Sheets spreadsheet or data exports, choose one of PMA's destinations and follow the instructions in the linked articles:
  1. Google Sheets Data Integration Guide
  2. How to Export to BigQuery
  3. How to Export to MySQL
  4. How to Export to Azure SQL Database
  5. How to Export to PostgreSQL
  6. How to Create an FTP Export

    • Related Articles

    • How to Use the Exports Add-On

      Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, and FTP. With our easy-to-use Exports Add-On, you can set up a report in PMA's Data Explorer and schedule ...

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

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

    • Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"

      When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter an error about too many time-based triggers. This guide explains the cause of this error and provides a simple solution to resolve it. Error "Exception: This ...