Query the data API to retrieve aggregated observation data across multiple dimensions and metrics. This endpoint dynamically generates SQL queries based on the requested fields, allowing flexible aggregation for analytics and reporting workflows.
The query endpoint returns pre-aggregated metrics grouped by the specified dimensions. Results are optimized for BI tools, reporting pipelines, and dashboards.
Documentation Index
Fetch the complete documentation index at: https://developers.scrunch.com/llms.txt
Use this file to discover all available pages before exploring further.
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Start date for the query range (inclusive). Format: YYYY-MM-DD. Defaults to 30 days ago. Empty or whitespace-only values are treated as missing and the default is applied. Malformed values (e.g. 2024-02-30) return HTTP 400.
End date for the query range (inclusive). Format: YYYY-MM-DD. Defaults to today. Empty or whitespace-only values are treated as missing and the default is applied. Malformed values (e.g. 2024-02-30) return HTTP 400.
Maximum number of rows to return. Use with offset for pagination.
1 <= x <= 90000Number of rows to skip for pagination.
x >= 0Comma-separated list of dimensions and/or metrics to include in the query results. If omitted, all dimensions are returned.
Supported Dimensions:
date - Daily timestamp (YYYYMMDD)date_week - ISO week (YYYYWW)date_month - Month (YYYYMM)date_quarter - Quarter (YYYYQ#)date_year - Year (YYYY)prompt_id - Prompt ID (Integer)prompt - Prompt text (String)persona_id - Persona ID (Integer)persona_name - Persona name (String)ai_platform - AI platform name (String, mapped)ai_platform_search_enabled - Search mode enabled (Boolean)tag - Prompt tag (String)source_url - Citation URL (String)source_type - Citation type (brand, competitor, other)competitor_id - Competitor ID (Integer)competitor_name - Competitor name (String)branded - Branded prompt (Boolean)stage - Journey stage (Display name)prompt_topic - Topic name (String)country - Geography (Country code)Supported Metrics:
responses - Total responses (COUNT of distinct observations)brand_presence_percentage - Brand mention rate (0-1 scale)brand_position_score - Brand positioning (0-100 scale: top=100, middle=50, bottom=0)brand_sentiment_score - Brand sentiment (0-100 scale: positive=100, mixed=50, negative=0)competitor_presence_percentage - Competitor mention rate (0-1 scale)competitor_position_score - Competitor positioning (0-100 scale)competitor_sentiment_score - Competitor sentiment (0-100 scale)Example: fields=date,ai_platform,brand_presence_percentage
Successful Response