Get Started with Power My Analytics API
Custom plan clients whose plan includes API access can use the Power My Analytics API for easy, flexible direct access to their report data. Learn how to use this powerful tool to design your custom solutions.
Who Can Use the Power My Analytics API?
Access to the API is available only to customers on a Custom plan (formerly Enterprise) whose plan includes API access. API access is not automatically included in all Custom plans; it depends on the terms of your specific agreement. Please discuss API access with your dedicated representative, or contact us at sales@powermyanalytics.com for assistance.
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 the our SwaggerHub.
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. ...How Do You Differ from Companies Like Supermetrics during API Outages?
Direct Connect vs. Warehousing Many Looker Studio connectors, like those offered by Supermetrics, provide a "direct API connect" service. This means that they connect directly to the Facebook Insights API and retrieve your data whenever you need it. ...