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 the exports 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: Set Up a Scheduled Refresh for a Report
  2. How to Export to BigQuery: Set Up Your Initial Backfill and Rolling Updates
  3. How to Export to MySQL: Set Up Your Initial Backfill and Rolling Updates
  4. How to Export to Azure SQL Database: Set Up Rolling Updates
  5. How to Create an FTP Export


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

      • 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, and FTP. With our easy-to-use Exports Add-On, you can set up a report in PMA's Data Explorer and schedule regular data ...

      • Use the GA4 Exports Template in Data Explorer

        Power My Analytics offers pre-made report templates in our Data Explorer for use with your Google Analytics 4 data. By using our GA4 report templates, you can configure your reports in just a few minutes and prepare your data for export to ...

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

      • Required Google Account Permissions for Spreadsheets Add-on

        When using Power My Analytics' Spreadsheets Add-on with Google Sheets, you'll be asked to grant certain permissions to your Google account. We understand that granting these permissions may raise concerns about data security and privacy. This guide ...