Skip to content
Knowledge Base

How to Use Data Exports

Last updated

Note: Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, Snowflake, Amazon S3, and FTP. Data exports are available as a paid add-on on the Business, Grow, and Pro plans, and are included with the Custom plan when your negotiated agreement includes data exports. 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.

Important: Plan Eligibility: The Data Exports add-on is $85/month or $850/year on the Business, Grow, and Pro plans. On Grow and Pro, you can turn it on yourself: click your hub name (top right), select Billing, open the Add-ons tab, and turn on Data Exports. On the Business plan, contact our support team to add it. Data exports are included with the Custom plan when your agreement includes them, and aren't available on the Free plan.

Legacy plan subscribers: If you subscribed to an Exports add-on before 2026 under a legacy plan, your existing export configurations continue to work. You can keep your legacy add-on, or move to a current Grow or Pro plan and add the Data Exports add-on. Please contact our support team with any questions about your legacy add-on.

What Are PMA's Data Exports?

With data exports, you can send marketing data from your Data Builder reports directly into your preferred data destinations, including:

  • BigQuery
  • MySQL
  • Azure SQL Database
  • PostgreSQL
  • Snowflake
  • Amazon S3
  • FTP

With data exports, you can connect your BigQuery dataset, SQL database, Snowflake account, Amazon S3 bucket, or FTP server, and begin receiving regularly scheduled data exports from the reports you've created in PMA's Data Builder.

Note: When scheduling your export, you can choose a refresh period of on demand, monthly, weekly, daily, or hourly. For monthly, weekly, and daily exports, you also choose the Timezone in which your schedule runs. Hourly exports need the Hourly Refreshes add-on ($85/month or $850/year on the Business, Grow, and Pro plans), or a Custom plan that includes hourly refreshes.

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:

Need More Than the Add-on?

If you need more than the Data Exports add-on provides, the Custom plan may include the following, depending on the terms of your specific agreement:

  • Data exports and hourly data refreshes
  • Sovereign data warehousing options
  • Custom Power My Analytics API request and row quotas (API access itself is included with every plan)
  • 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.

Additional Resources

Still Have Questions?

No worries — we're happy to help!

🔗 Contact our Support Team

Related Articles