Data Destinations Overview: Choosing the Right Way to Receive Your PMA Data
Last updated
Note: Power My Analytics offers several ways to receive the marketing data you've centralized in your hub: visualization reports, spreadsheets, database and file exports, the PMA API, and the PMA MCP Server. This article compares every supported destination, explains which plans include each one, and helps you choose the best fit for your reporting workflow.
What is a destination?
A destination is where your data goes after Power My Analytics collects and warehouses it. Every PMA plan automatically collects data from your sources into PMA's secure data warehouse; destinations are the ways you get that data back out. They fall into four categories:
- Reporting destinations: visualization tools and spreadsheets (Data Studio, Google Sheets, Microsoft Excel)
- Data exports: scheduled deliveries to databases, warehouses, and file storage (BigQuery, MySQL, PostgreSQL, Azure SQL Database, Amazon S3, FTP, Snowflake)
- PMA API: programmatic access for your own applications
- PMA MCP Server (Beta): conversational access through AI assistants
Destinations at a glance
| Destination | Best for | Plan availability |
|---|---|---|
| Data Studio | Shareable dashboards and client reports | All plans (unlimited reports) |
| Google Sheets | Spreadsheet-based reporting and custom calculations | Grow and Pro (included); Business (Spreadsheets add-on); Custom (optional) |
| Microsoft Excel | Spreadsheet-based reporting in Microsoft environments | Grow and Pro (included); Business (Spreadsheets add-on); Custom (optional) |
| BigQuery export | Cloud warehouse analytics at scale | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| MySQL export | Self-managed relational database | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| PostgreSQL export | PostgreSQL-compatible databases | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| Azure SQL Database export | Microsoft Azure environments | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| Amazon S3 export | File-based storage (CSV or JSON) | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| FTP/SFTP export | File delivery to your own servers (CSV or JSON) | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| Snowflake export | Snowflake data cloud analytics | Business, Grow, and Pro (Data Exports add-on); Custom (per agreement) |
| PMA API | Custom applications and programmatic pulls | All plans (per-plan limits; Custom quotas negotiated) |
| PMA MCP Server (Beta) | Ad-hoc questions through AI assistants | All plans during Beta |
For current pricing details on each plan, please see the pricing page.
Reporting destinations
Data Studio
Every PMA plan includes unlimited Data Studio reports. Point-and-click integration lets you build live dashboards from any of your connected sources, and it's the fastest way to share polished reports with clients or stakeholders.
Google Sheets and Microsoft Excel (Spreadsheets)
The Spreadsheets feature sends your PMA data directly into Google Sheets or Microsoft Excel, where you can build custom calculations, pivot tables, and formatted reports.
- Grow and Pro plans: Spreadsheets are included at no additional charge.
- Custom plan: Spreadsheets are optionally available depending on your agreement.
- Business plan: Spreadsheets are available as a paid add-on ($49.95/month or $499.50/year). Click your hub name (top right), select Billing, and turn on Spreadsheets on the Add-ons tab.
To get started, install the Google Sheets add-on from the Google Workspace Marketplace or the Microsoft Excel add-in from Microsoft AppSource.
Data exports
Data exports deliver your Data Builder reports to a database, data warehouse, or file destination on a schedule you control (on demand, monthly, weekly, daily, or hourly; hourly exports need the Hourly Refreshes add-on or a Custom plan that includes hourly refreshes). 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.
Supported export destinations:
- BigQuery: Google's cloud data warehouse, with date-partitioned tables
- MySQL: any reachable MySQL server, including Google Cloud SQL
- PostgreSQL: any reachable PostgreSQL server, including Google Cloud SQL, Amazon RDS, and Azure Database for PostgreSQL
- Azure SQL Database: Microsoft's managed SQL database service
- Amazon S3: file delivery (CSV or JSON) to an S3 bucket
- FTP/SFTP: file delivery (CSV or JSON) to your own server
- Snowflake: Snowflake's data cloud, connected via OAuth
Before setting up an export, create the report you want to deliver in Data Builder. Each export is then set up in a four-step wizard: Destination, Data, Schedule, and Review. For setup details, see How to Use Data Exports.
Note: Exports also unlock indirect destinations. Once your data lands in BigQuery or a SQL database, you can connect business intelligence tools such as Tableau or Power BI directly to that warehouse.
What about Supabase and other hosted databases?
Supabase is not a named PMA destination, but Supabase databases are built on PostgreSQL. With data exports on your plan, the PostgreSQL export can deliver data to PostgreSQL-compatible databases, which is how customers typically reach platforms like Supabase. If you're considering this route, contact our support team and we'll help you confirm the details for your setup.
PMA API: available on every plan
The Power My Analytics API provides programmatic access to your connected accounts' data using an API key generated in your hub (MCP & API > REST API). It's the right choice when you're building your own application or data pipeline and want to pull data on your own terms. API access is included with every PMA plan, subject to per-plan rate limits, request quotas, and row quotas; on the Custom plan, the rate limit is 60 requests per minute, and the request and row quotas are negotiated with your sales representative. See Get Started with Power My Analytics API for details.
PMA MCP Server (Beta): available on every plan
The PMA MCP Server connects AI assistants (Claude Desktop, Claude Code, Claude Web, ChatGPT, and other MCP-compatible clients) directly to your hub, so you can ask questions about your marketing data in plain language: headline numbers, cross-platform comparisons, trends, and anomaly checks. The MCP Server is for AI assistants that connect through sign-in and doesn't accept API keys; for programmatic access from your own code, use the PMA API.
Important: MCP usage is included with your PMA plan and draws from the same shared per-plan limit pool as the Power My Analytics API (each plan includes an API rate limit, a request quota, and a row quota per billing cycle; on the Custom plan the request and row quotas are negotiated with your sales representative). See Get Started with Power My Analytics API for the current per-plan limits.
The MCP Server complements your other destinations rather than replacing them: it's ideal for ad-hoc questions, while scheduled reports and exports remain the path for recurring, shareable reporting. See the PMA MCP Server FAQ to learn more.
A note for legacy add-on subscribers
Before 2026, Spreadsheets and Exports were available as monthly add-ons on legacy plans. If you subscribed to one of these add-ons before 2026, you keep your existing configuration. You can keep your legacy add-on, or move to a current plan: Grow and Pro include Spreadsheets, and the Business, Grow, and Pro plans can add the Data Exports add-on. If your add-on cost is a significant share of your subscription, it may be worth comparing your current setup against the Grow or Pro plan or a Custom plan agreement. Please contact our sales team and we'll help you find the most cost-effective option.
Choosing the right destination
- You want polished dashboards to share: Data Studio (all plans).
- You live in spreadsheets: Google Sheets or Microsoft Excel on the Grow or Pro plan, both of which include Spreadsheets at no extra charge, or on the Business plan with the Spreadsheets add-on.
- You need data in your own database or warehouse: BigQuery, MySQL, PostgreSQL, Azure SQL Database, Amazon S3, FTP, or Snowflake exports with the Data Exports add-on (Business, Grow, or Pro) or a Custom plan that includes them.
- You're building your own application: the PMA API, included with every plan (per-plan limits apply).
- You want quick answers without building a report: the PMA MCP Server (Beta) on any plan.