GET /v1/query

GET /v1/query — return raw events filtered by time range.

Return raw event rows matching a time range and optional filters. For debugging, ad-hoc inspection, and small reports.

Auth

Required scope	read
Key kinds	rk_*

Request

GET /v1/query?from=2026-05-01T00:00:00Z&to=2026-05-16T00:00:00Z&event=signup&limit=100
Authorization: Bearer rk_live_…

Query parameters

Name	Required	Notes
from	yes	ISO 8601 timestamp (inclusive).
to	yes	ISO 8601 timestamp (exclusive).
event	no	Filter to one event name (signup, $pageview, etc.).
source	no	Filter to one source (facebook, google, etc.).
medium	no	Filter to one medium (paid, social, etc.).
user_id	no	Filter to events tagged with this user_id.
limit	no	1–1000, default 100.

Response

{
  "rows": [
    {
      "timestamp": "2026-05-16T19:31:23.217Z",
      "event_name": "signup",
      "anonymous_id": "u_fbpaid_1",
      "user_id": "user_001",
      "source": "facebook",
      "medium": "paid",
      "campaign": "spring",
      "source_confidence": "high",
      "referrer": "https://l.facebook.com/",
      "url": "https://yoursite.com/?utm_source=facebook&utm_medium=cpc&fbclid=abc",
      "path": "/",
      "country": "GB",
      "device_type": "desktop",
      "properties": "{\"plan\":\"free\"}"
    }
  ]
}

properties is returned as a JSON string (because ClickHouse stores it as String). Parse client-side.

When NOT to use this

For aggregations (count, uniq, group by), use /v1/stats — it's an order of magnitude cheaper than fetching raw rows and aggregating in your code.

For top-source breakdowns specifically, use /v1/sources.

Example: last 20 events from a specific user

curl -G "https://api.millimetric.ai/v1/query" \
  -H "Authorization: Bearer $RK_KEY" \
  --data-urlencode "from=2026-05-01T00:00:00Z" \
  --data-urlencode "to=2026-05-17T00:00:00Z" \
  --data-urlencode "user_id=user_42" \
  --data-urlencode "limit=20"

Example: paid Facebook traffic this week

curl -G "https://api.millimetric.ai/v1/query" \
  -H "Authorization: Bearer $RK_KEY" \
  --data-urlencode "from=2026-05-10T00:00:00Z" \
  --data-urlencode "to=2026-05-17T00:00:00Z" \
  --data-urlencode "source=facebook" \
  --data-urlencode "medium=paid"