Get Started with Power My Analytics API

Get Started with Power My Analytics API

The Power My Analytics API gives you easy, flexible, direct access to your report data, so you can design your own custom solutions. API access is included with every PMA plan, subject to per-plan rate limits, request quotas, and row quotas. Learn how to put this powerful tool to work below.

Who Can Use the Power My Analytics API?

API access is included with every PMA plan. Each plan includes an API rate limit (requests per minute), a request quota (requests per billing cycle), and a row quota (rows retrieved per billing cycle). These limits are shared with the PMA MCP server: your API and MCP usage draw from the same per-plan pool, so the rate limit, request quota, and row quota below all describe your combined API + MCP usage:

Plan
API rate limit (requests per minute)
Requests per billing cycle
Row quota (rows per billing cycle)
Free
15
100
1,000
Business
30
5,000
250,000
Grow
45
15,000
500,000
Pro
45
25,000
1,000,000
Custom (formerly Enterprise)
60
Negotiated with your sales representative
Negotiated with your sales representative

If you need higher limits than your plan includes, a Custom plan can be tailored to your needs. Please discuss API limits with your dedicated representative, or contact us at sales@powermyanalytics.com for assistance.

Notes
Can't find the API page? It lives under MCP & API > REST API in the left navigation of your Hub. It moved there from Tools, so older guides and bookmarks may point to the wrong place — you can also go straight to hub.powermyanalytics.com/resources/api. API access is included with every plan, so if the page still doesn't load after signing out and back in, submit a ticket and we'll take a look.

Available Data

Our API allows you to access data directly via our connectors. This means the same data that can be accessed through Data Studio is also available through the our API. 

API Limitations

  1. Data Builder: Our API cannot be used to access Data Builder reports. Instead, build a similar query using our API.
  2. Exports: Our API cannot provide exports to BigQuery or FTP.

Start Using Our API

Our API requires a few simple steps to get started.

Find Your Organization ID for the API Endpoint

Go to your Hub at hub.powermyanalytics.com. Your organization ID will be included in the URL at https://hub.powermyanalytics.com/organizations/[organization ID]/overview.

Use this organization ID to access the our API endpoint at: /http-organizations/[organization ID]/accounts/[provider type]

"Provider type" is a string such as "facebook_ads" or "facebook_instagram". A full list of available connector strings is available via the /http-connectors endpoint.

Retrieve Report Data from the API

  1. Use the Organization endpoints to get a list of your accounts for your organization, and find a specific account.
  2. Use the first two Connector endpoints to get the required configuration and specify the fields you want to retrieve. You can also use the Schema endpoint to return a list of all the schema fields you can use.

    The configuration endpoint will return a list of configuration fields and their options. Note that every connector will have different names for the configuration parameters to specify. These may be used to select an account, a currency, an attribution setting, or other options.
  3. Use the third Connector endpoint, the report endpoint, to retrieve the report data according to the configuration and fields specified. The report endpoint expects to receive the configuration in a URI-encoded JSON stringify format.

Learn with Our API Manual

Complete documentation of the Power My Analytics API is available at our SwaggerHub manual. The SwaggerHub manual is the best place to start; please consult it before connecting to the API.
You can create a support ticket if you have any questions about using our API.

Basic Troubleshooting

How to use your API key to authenticate

Your API key must be included in the authorization header when authenticating. Make sure your authorization header is in the format: 'authorization: Bearer API_KEY_HERE'

Find your account ID

To find your account ID for use with our API, use Data Builder to create a dataset and data table containing each data source you want to use, such as Facebook Ads, Instagram Insights, or Shopify. Choose the Account ID field to report. Run the report to display the account ID.