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 now available to all PMA users; it was previously limited to the Custom plan. Learn how to put this powerful tool to work below.
It's free right now. In a few weeks we will begin charging based on usage. We will send out an update at that time.
Who Can Use the Power My Analytics API?
API access is available to all PMA users. It was previously limited to the Custom plan.
Available Data
Our API allows you to access data directly via our connectors. This means the same data that can be accessed through Looker Studio is also available through the our API.
API Limitations
- Data Builder: Our API cannot be used to access Data Builder reports. Instead, build a similar query using our API.
- 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
- Use the Organization endpoints to get a list of your accounts for your organization, and find a specific account.
- 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. - 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.
A note on legacy connectors: The LinkedIn Ads, LinkedIn Companies, and X Ads (formerly Twitter Ads) connectors have not yet been migrated to the new protocol. When making calls to these three connectors, structure your calls according to our legacy API documentation instead.
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.
Related Articles
Power My Analytics' Sovereign SQL Warehouse Solution
Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...How Can I Get Started with Embedded Analytics?
Access your Marketing Analytics from the Tools You Use Every Day At Power My Analytics, we integrate directly with the platforms you already use to put insights at your fingertips. Rather than constantly exporting data or toggling between tools, our ...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 ...Google Analytics (Universal Analytics) Sunset
As of July 1, 2024, Universal Analytics has been fully shut down and is no longer available as a data source or data destination. Google's Universal Analytics was sunset on July 1, 2024 and has been removed as a feature of Power My Analytics. ...Using Looker BI with Power My Analytics
Looker BI (Beta) is a premium add-on that turns your warehoused marketing data into interactive dashboards and automated alerts, powered by Google's Looker. Because each workspace is configured and managed by our team, onboarding is hands-on and ...