---
title: "Get Team Daily Activity Aggregated"
method: GET
path: "/team/daily/activity/aggregated"
tags: ["team management"]
---

# Get Team Daily Activity Aggregated

`GET /team/daily/activity/aggregated`

## Request

- Base URL: `https://api.sea-lion.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.sea-lion.ai/team/daily/activity/aggregated`
- Auth: API key in header `x-litellm-api-key`

Aggregated daily activity for teams without pagination, including per-team breakdown.

One SQL GROUPING SETS pass returns every day in the range regardless of row
volume, so callers never reassemble pages. Same response shape as the
paginated endpoint with page metadata pinned to a single page.

Args:
    team_ids (Optional[str]): Comma-separated list of team IDs to filter by. If not provided, returns data for all teams.
    start_date (Optional[str]): Start date for the activity period (YYYY-MM-DD).
    end_date (Optional[str]): End date for the activity period (YYYY-MM-DD).
    model (Optional[str]): Filter by model name.
    api_key (Optional[str]): Filter by API key.
    exclude_team_ids (Optional[str]): Comma-separated list of team IDs to exclude.
    timezone (Optional[int]): Timezone offset in minutes from UTC, matching JavaScript's Date.getTimezoneOffset() convention.
Returns:
    SpendAnalyticsPaginatedResponse: Response containing all daily activity data for the range.

## Query parameters

- `api_key_limit` integer
- `team_ids` string, nullable
- `start_date` string, nullable
- `end_date` string, nullable
- `model` string, nullable
- `api_key` string, nullable
- `exclude_team_ids` string, nullable
- `timezone` integer, nullable

## Response `200`

Successful Response

- SpendAnalyticsPaginatedResponse
  - `results` DailySpendData[], required
    - `date` string, date, required
    - `metrics` SpendMetrics, required
      - `spend` number
      - `flat_cost` number
      - `prompt_tokens` integer
      - `completion_tokens` integer
      - `cache_read_input_tokens` integer
      - `cache_creation_input_tokens` integer
      - `compression_saved_tokens` integer
      - `compression_savings_spend` number
      - `prompt_caching_savings_spend` number
      - `gateway_injected_caching_savings_spend` number
      - `autorouter_savings_spend` number
      - `total_tokens` integer
      - `successful_requests` integer
      - `failed_requests` integer
      - `api_requests` integer
      - `total_response_time_ms` integer
      - `timed_requests` integer
    - `breakdown` BreakdownMetrics: Breakdown of spend by different dimensions
      - `mcp_servers` object
      - `models` object
      - `model_groups` object
      - `providers` object
      - `endpoints` object
      - `api_keys` object
      - `entities` object
  - `metadata` DailySpendMetadata
    - `total_spend` number
    - `total_flat_cost` number
    - `total_prompt_tokens` integer
    - `total_completion_tokens` integer
    - `total_tokens` integer
    - `total_api_requests` integer
    - `total_successful_requests` integer
    - `total_failed_requests` integer
    - `total_cache_read_input_tokens` integer
    - `total_cache_creation_input_tokens` integer
    - `total_compression_saved_tokens` integer
    - `total_compression_savings_spend` number
    - `total_prompt_caching_savings_spend` number
    - `total_gateway_injected_caching_savings_spend` number
    - `total_autorouter_savings_spend` number
    - `total_response_time_ms` integer
    - `total_timed_requests` integer
    - `page` integer
    - `total_pages` integer
    - `has_more` boolean
    - `api_key_limit` integer, nullable: When set, api_keys and every api_key_breakdown list at most this many keys, ranked by spend. Totals and the model, provider, mcp and endpoint rollups still cover every key.
    - `total_api_keys` integer, nullable: Distinct API keys matching the filters. When this exceeds api_key_limit, the per-key lists are truncated to the highest-spend keys.
    - `entity_total_api_keys` object, nullable: Distinct API keys per entity over the requested range, set when the entity breakdown is included. When an entity's count exceeds api_key_limit, its api_key_breakdown lists only its keys among the top api_key_limit keys overall.

## Other responses

- `422`: Validation Error

## Changes

- **2026-10-21** `f2fb14eab3f5`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/sea-lion/apis/litellm-api/changes/team/daily/activity/aggregated/get.md)

---

[API](https://skmtc.dev/sea-lion/apis/litellm-api.md) · [All operations](https://skmtc.dev/sea-lion/apis/litellm-api/llms.txt) · [OpenAPI document](https://skmtc.dev/sea-lion/apis/litellm-api/revisions/1ba9123c189a?raw)
