It is designed for analytics workloads, BI tools, reporting pipelines, and large-scale automation.
When to use the Query API
Use this API when you need:- Weekly or monthly reporting
- Brand presence, position, sentiment, and competitor metrics
- Aggregation by date, persona, tag, platform, or prompt
- Data for dashboards (Looker, PowerBI, Tableau)
- Large batch pulls of metrics (up to 50k records per call)
Example query
How aggregation works
Scrunch automatically aggregates metrics across the dimensions you specify in fields.For example:
fields=tag,brand_presence_percentage
Returns one row per tag with the average presence percentage.
Best practices
- Prefer date_week or date_month instead of daily reporting
- Query separate datasets and join them later for BI pipelines
- Use brand-scoped keys when integrating into client dashboards
- Keep field sets small to avoid large intermediate result sets
Run your first query
Go to the Query API Quickstart →