ClickHouse

Clickhouse Org Analytics

Per-org visitor + intent analytics from ch3.

The database name is always derived from the authenticated user's organization.id (lower-cased) — the request body never carries an org_id. The agent cannot reach another org's data even if it tries.

post/clickhouse/org-analytics

Request

  • Base URL: https://be.graph8.com/api/v1
  • URL: https://be.graph8.com/api/v1/clickhouse/org-analytics
  • Auth: HTTP bearer

Headers

Authorizationstring nullable
X-Target-Org-Idstring nullable

Request body

dataset'people_visitors' | 'company_visitors' | '5x5_visitors' | 'intent_resolved' required

Which per-org table to read.

sincestring required

ISO date or datetime (inclusive lower bound).

untilstring nullable

ISO date or datetime (exclusive upper bound). Defaults to now.

filtersobject

Optional equality filters. Keys must match dataset columns; unknown columns are silently dropped so an LLM guess can't produce a SQL error.

aggregation'raw' | 'daily_counts' | 'top_n'

'raw' returns the matching rows (capped). 'daily_counts' returns {day, count}. 'top_n' returns {value, count} grouped by the dataset's primary group key (contact_id, company_id, keyword_id).

limitinteger

Response

Successful Response

Changes

No recorded changes to this operation across all 2 revisions of this API.