Skip to main content

​
MCP Tools

When you connect Detrics to Claude, the following tools become available. Claude calls these automatically based on your prompts, you do not need to invoke them manually.

​
Core

Query metrics and dimensions from any connected marketing platform.Parameters:
  • platform_api: The platform identifier (e.g., facebook_ads, google_ads, shopify)
  • account_id: The platform account to query
  • metrics: Metrics to retrieve (e.g., spend, impressions, revenue)
  • dimensions: Dimensions to group by (e.g., campaign_name, date)
  • date_range: Time period for the query
  • context_id: Optional AI Context ID to use pre-configured settings
Example prompt: “What was my Meta Ads ROAS last week?”
See all platforms connected to your workspace.Returns the platform name, connection status, and number of accounts available.Example prompt: “What platforms do I have connected?”
Discover available metrics and dimensions for a specific platform.Parameters:
  • platform_api: The platform identifier
Example prompt: “What metrics are available for Shopify?”
List all accounts (ad accounts, properties, stores) for a connected platform.Parameters:
  • platform_api: The platform identifier
Example prompt: “Show me my Google Ads accounts”
List all AI Contexts available in your workspace.Example prompt: “What AI Contexts are available?”
Get the full details of a specific AI Context, including its query configuration.Parameters:
  • context_id: The context identifier
Example prompt: “Show me the details of my weekly performance context”
Initiate an OAuth flow to connect a new marketing platform to your workspace. Returns a URL to complete the authorization.Parameters:
  • platform_api: The platform to connect
Example prompt: “Connect my Pinterest Ads account”
Check whether a platform OAuth connection flow has been completed.Parameters:
  • connection_id: The connection identifier from connect_platform
Example prompt: “Did my Pinterest connection go through?”

​
Data Warehouse

Beyond querying, Claude can manage your entire BigQuery warehouse. Create destinations, build table groups, schedule and run transfers, and query your data, all in natural language through the Detrics MCP server.
Read Data Warehouse state: destinations, transfers, runs, table groups, tables, audit log, shares, presets and schema previews. (read-only)Example prompt: “Show me the state of my BigQuery warehouse”
Create and manage BigQuery destinations: guided GCP setup, connection tests, image storage, sharing.Example prompt: “Create a BigQuery destination in my project acme-analytics”
Create and manage warehouse table groups and tables, including pre-built presets and safe schema updates.Example prompt: “Build a table group for my Meta Ads data using a preset”
Create and manage BigQuery transfers: create, update, pause/resume, trigger syncs, per-table sync settings, sharing.Example prompt: “Schedule a daily transfer of my Google Ads data to BigQuery”

​
Supported Platforms

Detrics connects to 30+ marketing, analytics, and e-commerce platforms. The Fields Catalog has the complete, always-current list of supported platforms and the fields available for each. For the best results:
  1. Start with list_contexts: check if there is a pre-built AI Context for what you need
  2. Use query_marketing_data with a context_id: this uses pre-configured settings, saving you from specifying every parameter
  3. If no context fits, use list_fields to discover available metrics and dimensions, then build your query manually