---
title: "Segments behind a funnel drop-off, a KPI or churned MRR."
method: GET
path: "/api/v1/admin/metrics/drill"
tags: ["Metrics Admin"]
---

# Segments behind a funnel drop-off, a KPI or churned MRR.

`GET /api/v1/admin/metrics/drill`

## Request

- Base URL: `https://api.avatarfactory.io` (the document declares no server; this is the origin it was published from)
- URL: `https://api.avatarfactory.io/api/v1/admin/metrics/drill`
- Auth: one of:
  - API key in cookie `session`
  - HTTP bearer

## Query parameters

- `tz` string, nullable
- `include_internal` '0' | '1', nullable
- `from` string, date, nullable
- `to` string, date, nullable
- `filters` string, nullable
- `steps` string, nullable
- `window_days` integer
- `kind` 'funnel_dropoff' | 'metric' | 'churn', required
- `metric` 'signups' | 'trials' | 'new_paid', nullable
- `step_index` integer, nullable
- `by` 'country' | 'device' | 'source' | 'medium' | 'campaign' | 'plan' | 'billing' | 'reason', nullable

## Response `200`

OK

- DrillResponse
  - `base` integer, nullable, required
  - `by` 'country' | 'device' | 'source' | 'medium' | 'campaign' | 'plan' | 'billing' | 'reason', required
  - `env` 'production' | 'staging' | 'local' | 'test', required
  - `filters` FilterEcho[], required
    - `dimension` string, required
    - `op` 'is' | 'not', required
    - `values` string[], required
  - `from` string, date, required
  - `meta` ResponseMeta, required: The zone the answer's dates are in (ruling 11). tz_applied is false where the data is UTC by nature (/freshness, /exports).
    - `tz` string, required
    - `tz_applied` boolean
  - `mrr_cents` integer, nullable, required
  - `notes` string[]
  - `page_size` integer, required
  - `people_total` integer, required
  - `people_truncated` boolean, required
  - `rate_pct` number, nullable, required
  - `segments` DrillSegment[], required
    - `base` integer, nullable, required
    - `count` integer, required
    - `gap_pts` number, nullable, required
    - `mrr_cents` integer, nullable, required
    - `rate_pct` number, nullable, required
    - `share_pct` number, nullable, required
    - `value` string, required
  - `subject` DrillSubject, required
    - `kind` 'funnel_dropoff' | 'metric' | 'churn', required
    - `metric` 'signups' | 'trials' | 'new_paid', nullable, required
    - `next_step_id` string, nullable, required
    - `step_id` string, nullable, required
    - `step_index` integer, nullable, required
    - `window_days` integer, nullable, required
  - `to` string, date, required
  - `total` integer, required

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `422`: Unprocessable Entity
- `503`: Service Unavailable

---

[API](https://skmtc.dev/avatarfactory/apis/avatarfactory-api.md) · [All operations](https://skmtc.dev/avatarfactory/apis/avatarfactory-api/llms.txt) · [OpenAPI document](https://skmtc.dev/avatarfactory/apis/avatarfactory-api/revisions/66fc7aa3f296?raw)