metrics_daily_totals
Retrieves published metric totals by day, week, or month for a start/end date range, returning aligned dates and values plus provisional flags for reporting and validation.
Instructions
The published totals from start to end (ISO dates, both included) by grain: day, week (starting Monday) or month. It returns columns: dates holds the first day of each period that falls in the range, and values holds one list per metric, lined up with dates. metrics picks the metrics; leave it out for all of them. At week and month, counts and money are summed and aov, return_rate and conversion_rate are recomputed from the summed parts; a ratio is null when its denominator is 0. Ratios are fractions between 0 and 1, rounded to four places. The session metrics, named in approximate, are approximate above day, because a session that crosses midnight is counted on both days. A period is provisional when any of its days is on or after restated_from, so its numbers may still change. Call metrics_freshness for the dates the data covers and metrics_list for the metric names.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"start": "<start>",
"end": "<end>"
},
"name": "metrics_daily_totals"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | Yes | ||
| grain | No | day | |
| start | Yes | ||
| metrics | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dates | Yes | ||
| grain | Yes | ||
| values | Yes | ||
| approximate | Yes | ||
| provisional | Yes | ||
| restated_from | Yes |