get_revenue_report
Generate a revenue report grouped by category, region, or month. Returns total revenue, order count, average order value, and estimated profit for each segment within a specified date range.
Instructions
Generate a revenue report grouped by a dimension within a date range.
Returns total revenue, order count, average order value, and estimated profit per segment.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group_by | No | Dimension to group by: 'category', 'region', 'tier', 'status', or 'month' | category |
| period_end | No | End date YYYY-MM-DD (default: 2025-06-30) | 2025-06-30 |
| period_start | No | Start date YYYY-MM-DD (default: 2024-01-01) | 2024-01-01 |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group_by | Yes | Dimension used for grouping | |
| segments | Yes | Revenue breakdown by group | |
| period_end | Yes | Report period end date | |
| grand_total | Yes | Total revenue across all groups | |
| period_start | Yes | Report period start date |