---
title: "Return aggregated tabular usage rows"
method: GET
path: "/api/trpc/usageAnalytics.getTable"
tags: ["Usage Analytics"]
---

# Return aggregated tabular usage rows

`GET /api/trpc/usageAnalytics.getTable`

Returns aggregated tabular usage rows grouped by time bucket and optional dimensions. Use this for the detailed breakdown table and CSV export view.

## Response `200`

Successful tRPC response

- object
  - `result` object, required
    - `data` object, required
      - `rows` object[], required
        - `datetime` string, required
        - `dimensions` object, required
        - `costMicrodollars` number, required
        - `requestCount` number, required
        - `inputTokens` number, required
        - `outputTokens` number, required
        - `cacheWriteTokens` number, required
        - `cacheHitTokens` number, required
        - `errorCount` number, required
      - `effectiveGranularity` 'hour' | 'day' | 'week' | 'month', required

## Other responses

- `400` — Invalid request
- `401` — Authentication required
- `403` — Access denied
- `500` — Unexpected server error

---

[API](https://skmtc.dev/kilo/apis/kilo-code-api.md) · [All operations](https://skmtc.dev/kilo/apis/kilo-code-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/kilo/kilo-code-api/revisions/f0b9556c39ea/schema)