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 included with the Custom plan. This article will show you how to set up a report in PMA's Data Builder and schedule regular data exports to your preferred destination.
Legacy plan subscribers: If you subscribed to an Exports add-on prior to 2026 under a legacy plan, your existing export configurations will continue to function. However, new export destinations 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 PMA's Data Exports?
Power My Analytics allows Custom plan subscribers to export marketing data from their reports directly into their preferred data destinations, including:
- BigQuery
- MySQL
- Azure SQL Database
- PostgreSQL
- Amazon S3
- FTP
With data exports, you can connect your BigQuery dataset, SQL database, Amazon S3 bucket, or FTP server, and begin receiving regularly scheduled data exports from the reports you've created in PMA's Data Builder.
Step 1: Create Your Data Builder Report
Before you can export your data, you'll need to set up a report in PMA's Data Builder. You will need to choose:
- The data source you want to use
- The fields you want to report
- The date range of data you want to include, and any other options
Follow the instructions in the Data Builder Guide to set up your report before proceeding to Step 2.
Step 2: Set Up Your Export
Once your Data Builder report is ready, you can set up your data export. Choose one of PMA's supported export destinations below and follow the instructions in the linked article to connect your destination and schedule your export:
- 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?
Data exports are exclusively available to Custom plan subscribers. If you're on a Free, Business, or Pro plan and are interested in exporting your marketing data, upgrading to the Custom plan is the best path forward. Our Custom plan also includes:
- Hourly data refreshes
- 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
Learn more about the Custom plan in the Custom Plan Guide, or reach out to our sales team to discuss your needs.
Still Have Questions?
No worries — we're happy to help!
Related Articles
Power My Analytics Data Connector User Guide
The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and ...Etsy Data Connector User Guide
Power My Analytics' Etsy data connector allows you to automatically collect, store, and visualize your Etsy shop data without relying on manual exports. This guide will walk you through connecting your Etsy account and understanding key metrics to ...Manage and Configure Data Sources
Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...How to Export to Snowflake
Exporting your marketing data to Snowflake 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 Snowflake exports using Power My Analytics. A ...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 included with the Custom plan for subscribers who require the most up-to-date data ...