Share via

SuperMCP (Preview)

SuperMCP by Supermetrics - An MCP (Model Context Protocol) server providing access to marketing data from connected platforms like Google Analytics, Facebook Ads, Google Ads, and more.

This API enables LLMs to query marketing data, discover data sources and accounts, explore available fields, and retrieve performance metrics.

This connector is available in the following products and regions:

Service Class Regions
Copilot Studio Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Supermetrics
URL https://supermetrics.com
Connector Metadata
Publisher Supermetrics
Website https://supermetrics.com
Privacy policy https://supermetrics.com/privacy
Categories Marketing

SuperMCP (Supermetrics) Custom Connector

This connector enables Microsoft Power Automate, Power Apps, and Azure Logic Apps to query marketing data through SuperMCP (Supermetrics’ MCP server).
Use it to discover data sources and accounts, explore available fields, and run marketing performance queries.

Publisher

Supermetrics

Connector type

Custom Connector (Swagger/OpenAPI 2.0)

Service / API

SuperMCP API (MCP server)

  • Host: mcp.supermetrics.com
  • Base path: /
  • Scheme: https

Prerequisites

You will need:

  • A Power Automate or Power Apps environment where you can create custom connectors
  • A Supermetrics account with at least one connected data source (e.g., Google Analytics, Google Ads, Facebook Ads, etc.). If you don't have a Supermetrics account, one with a 14-day trial will be created for you at first login.

Authentication

This connector uses OAuth 2.0.

Supported Operations

Discovery

  • Discover available Supermetrics data sources (POST /mcp/data_source_discovery)
  • Discover accounts for a data source (POST /mcp/accounts_discovery)
  • Discover available fields (POST /mcp/field_discovery)

Data Query

  • Run an async data query (POST /mcp/data_query)
    • Returns a schedule_id
  • Get async query results (POST /mcp/get_async_query_results)
    • Use the schedule_id until results are returned

Utilities / Resources (typically advanced visibility)

  • Get today (UTC) (POST /mcp/get_today)
  • Health check (GET /mcp/resources/health)

Support

License

Proprietary — © Supermetrics

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Discover available accounts for a specific data source

Discover available accounts for a specific data source Call this after data_source_discovery to get account IDs needed for data queries.
Discover available fields for data sources with schema information

Discover available fields for data sources with schema information Call this to see available metrics and dimensions for a data source before querying.
Discover available Supermetrics data sources

Discover available Supermetrics data sources This is typically the first step - call this to see what data sources are available before querying data.
Get current UTC date and time information

Get current UTC date and time information Call this first when user mentions relative dates like 'last month' or 'yesterday' to know the current date.
Health check

Get server health status and configuration information.
Query marketing data from Supermetrics data sources

Query marketing data from Supermetrics data sources This returns a schedule_id - you must then call get_async_query_results to get the actual data.
Retrieve authenticated user information from Supermetrics

Retrieve authenticated user information from Supermetrics
Retrieve results of data queries using schedule_id

Retrieve results of data queries using schedule_id Use this with the schedule_id from data_query to retrieve actual query results.

Discover available accounts for a specific data source

Operation ID:
accountsdiscovery

Discover available accounts for a specific data source Call this after data_source_discovery to get account IDs needed for data queries.

Parameters

Name Key Required Type Description
Data Source ID
 ds_id True string

Data source ID that can be retrieved using the data_source_discovery tool. Examples: 'FA' for Facebook Ads, 'AW' for Google Ads, 'GAWA' for Google Analytics.
Compress response
 compress boolean

Enable toon compression for the response

Returns

Body
AccountsdiscoveryResponse

Discover available fields for data sources with schema information

Operation ID:
fielddiscovery

Discover available fields for data sources with schema information Call this to see available metrics and dimensions for a data source before querying.

Parameters

Name Key Required Type Description
Data Source ID
 ds_id True string

Data source ID that can be retrieved using the data_source_discovery tool. Examples: 'FA' for Facebook Ads, 'AW' for Google Ads, 'GAWA' for Google Analytics.
Field type
 field_type string

Filter by field type (dimension or metric)
Compress response
 compress boolean

Enable toon compression for the response

Returns

Body
FielddiscoveryResponse

Discover available Supermetrics data sources

Operation ID:
datasourcediscovery

Discover available Supermetrics data sources This is typically the first step - call this to see what data sources are available before querying data.

Parameters

Name Key Required Type Description
Compress response
 compress boolean

Enable toon compression for the response

Returns

Body
DatasourcediscoveryResponse

Get current UTC date and time information

Operation ID:
gettoday

Get current UTC date and time information Call this first when user mentions relative dates like 'last month' or 'yesterday' to know the current date.

Parameters

Name Key Required Type Description
object

Returns

Body
GettodayResponse

Health check

Operation ID:
healthCheck

Get server health status and configuration information.

Returns

response
string

Query marketing data from Supermetrics data sources

Operation ID:
dataquery

Query marketing data from Supermetrics data sources This returns a schedule_id - you must then call get_async_query_results to get the actual data.

Parameters

Name Key Required Type Description
Data Source ID
 ds_id True string

Data source ID that can be retrieved using the data_source_discovery tool. Examples: 'FA' for Facebook Ads, 'AW' for Google Ads, 'GAWA' for Google Analytics.
ds_accounts
 ds_accounts True array of string
fields
 fields True array of string
Date Range Type
 date_range_type string

Choose one of two approaches:

  1. Use 'custom' and provide start_date and end_date.
  2. Use a relative range in the format 'last_X_Y' (e.g., 'last_7_days', 'last_3_months').
    • You can append '_inc' to include the current period (e.g., 'last_7_days_inc').

IMPORTANT: For any relative date mentioned by user, FIRST call get_today tool to know the current year and date! If there is any ambiguity about the time period (e.g., the meaning of 'today', 'this week', 'last August', or similar phrases), call the get_today tool to confirm the current year and date, then use that response to fill this parameter.
Start Date
 start_date string

Required if date_range_type='custom'. Accepts:

  • Exact date in YYYY-MM-DD format (e.g., '2024-01-01')
  • Natural language date (e.g., 'yesterday', 'next Monday')

IMPORTANT: For any relative date mentioned by user, FIRST call get_today tool to know the current year and date! If there is ambiguity about the time reference (e.g., relative phrases like 'today', 'this week', 'end of month'), call the get_today tool to confirm the current year and date, then use that response to fill this parameter.
End Date
 end_date string

Required if date_range_type='custom'. Accepts:

  • Exact date in YYYY-MM-DD format (e.g., '2024-01-31')
  • Natural language date (e.g., 'yesterday', 'last Friday')

IMPORTANT: For any relative date mentioned by user, FIRST call get_today tool to know the current year and date! If there is ambiguity about the time reference (e.g., relative phrases like 'today', 'this week', 'end of month'), call the get_today tool to confirm the current year and date, then use that response to fill this parameter.
Timezone
 timezone string

Optionally set the timezone for date calculations (e.g., 'America/New_York', 'Europe/London', 'Asia/Tokyo'). Uses IANA timezone names. If not specified, uses UTC.
Filters
 filters string

Filter expression string. Each condition has the form: [field_name] [operator] [value] Conditions can be combined with AND / OR.

Supported operators:

  • '==' → equals
  • '!=' → does not equal
  • '>' → greater than
  • '>=' → greater than or equal to
  • '<' → less than
  • '<=' → less than or equal to
  • '=@' → contains (case-insensitive, dimensions only)
  • '!@' → does not contain (case-insensitive, dimensions only)
  • '=~' → matches regular expression (dimensions only)
  • '!~' → does not match regular expression (dimensions only)

Examples:

  • "country == United States"
  • "country == United States OR country == Canada"
  • "sessions > 1000 AND deviceCategory == mobile"
  • "campaign_name =@ spring_sale"
  • "pagePath =~ ^/products/.*"
Settings
 settings object

Additional query configuration. Use a JSON object, for example: {"show_all_time_values": true}. Advanced feature for specific data source settings. Skip unless you have specific requirements.
Comparison Period Type
 compare_type string

Select how to compare results to an earlier period:

  • 'prev_range': previous period of the same length
  • 'prev_year': same period in the previous year
  • 'prev_year_weekday': same weekdays in the previous year
  • 'custom': user-defined period (requires compare_start_date and compare_end_date)
Comparison Value Type
 compare_show string

How to display the comparison:

  • 'perc_change': percentage change (default)
  • 'abs_change': absolute change
  • 'value': raw value from the comparison period
Comparison Period Start Date
 compare_start_date string

Required if compare_type='custom'. Start date of the custom comparison period, in YYYY-MM-DD format (e.g., '2024-01-01').
Comparison Period End Date
 compare_end_date string

Required if compare_type='custom'. End date of the custom comparison period, in YYYY-MM-DD format (e.g., '2024-01-31').

Returns

Body
DataqueryResponse

Retrieve authenticated user information from Supermetrics

Operation ID:
userinfo

Retrieve authenticated user information from Supermetrics

Parameters

Name Key Required Type Description
object

Returns

Body
UserinfoResponse

Retrieve results of data queries using schedule_id

Operation ID:
getasyncqueryresults

Retrieve results of data queries using schedule_id Use this with the schedule_id from data_query to retrieve actual query results.

Parameters

Name Key Required Type Description
Schedule ID
 schedule_id True string

The schedule ID returned from a data_query request. Schedule ID must be exactly the same as returned in the data_query response. Treat IDs as opaque. Copy verbatim. Do not abbreviate, format, or paraphrase.
Compress response
 compress boolean

Enable toon compression for the response

Returns

Body
GetasyncqueryresultsResponse

Definitions

AccountsdiscoveryResponse

Name Path Type Description
success
 success boolean
accounts
 data.accounts array of object
account_id
 data.accounts.account_id string
account_name
 data.accounts.account_name string

DataqueryResponse

Name Path Type Description
success
 success boolean
schedule_id
 data.schedule_id string

DatasourcediscoveryResponse

Name Path Type Description
success
 success boolean
data_sources
 data.data_sources array of object
id
 data.data_sources.id string
name
 data.data_sources.name string
category
 data.data_sources.category string

FielddiscoveryResponse

Name Path Type Description
success
 success boolean
data_source
 data.data_source string
total
 data.total integer
metrics
 data.metrics array of object
id
 data.metrics.id string
name
 data.metrics.name string
description
 data.metrics.description string
dimensions
 data.dimensions array of object
id
 data.dimensions.id string
name
 data.dimensions.name string
description
 data.dimensions.description string

GetasyncqueryresultsResponse

Name Path Type Description
success
 success boolean
data
 data.data array of object
items
 data.data object
status
 data.status string

GettodayResponse

Name Path Type Description
success
 success boolean
date
 data.date date
iso_string
 data.iso_string string
timestamp
 data.timestamp integer

UserinfoResponse

Name Path Type Description
success
 success boolean
user_id
 data.user_id string
email
 data.email string
name
 data.name string

string

This is the basic data type 'string'.