How to Use the Exports Add-On

How to Use the Exports Add-On

Info
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 exports to your preferred destination.

What Is PMA's Exports Add-On?

Power My Analytics includes destinations for raw data exports, including BigQuery, MySQL, Azure SQL Database, FTP, and more.
  1. If you are on an Enterprise plan, you already have access to data exports as part of your subscription.
  2. The Exports Add-On is also an optional feature available on Single, Business, and Pro plans for an additional $49.95/month.
With the Exports Add-On, you can connect your BigQuery dataset, SQL database, or FTP server, and begin receiving regularly scheduled data exports from the reports you've created in PMA.

Step 1: Create Your Data Explorer Report

Before you can export your data, you need to choose:
  1. The data source you want to use
  2. The fields you want to report
  3. The date range of data you want to include, and other options
Follow the instructions in How to Create a Report in Data Explorer to begin setting up your report.

Step 2: Activate the Exports Add-On

  1. Go to your Power My Analytics hub.
  2. Click on Exports > BigQuery.



  3. Click the Enable Exports button.



  4. Under Add Exports to Your Current Plan, toggle Enable Exports Addon.



  5. Click Confirm to enable the add-on.



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


Step 3: Set Up Your Export

Now you're ready to set up your data exports. To begin scheduling your exports, choose one of PMA's export destinations and follow the instructions in the linked articles:
  1. How to Export to BigQuery
  2. How to Export to MySQL
  3. How to Export to Azure SQL Database
  4. 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 Hourly Refreshes Add-On

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

      • 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 Export to BigQuery

        Once you have a report ready in Data Explorer, you are able to export it to BigQuery. This export option is included in the Enterprise plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...

      • How to Export to Azure SQL Database

        Exporting your marketing data to Azure SQL allows you to integrate it with various applications and run complex data queries. This guide will walk you through the process of setting up and managing your Azure SQL exports using Power My Analytics. An ...

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