Run a read-only analytics query for a project
Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
The public API version to use for this request.
2026-07-11 Query Parameters
Body
Run a read-only analytics query for a project.
Rules:
- Use SELECT or WITH queries only.
- Do not add project or namespace filters; project scoping is enforced server-side.
- Prefer daily rollup tables for date-range summaries and use events_computed for ad-hoc session-level questions.
- Maximum execution time: 60 seconds.
- Maximum result rows: 100000.
Queryable tables: Session-level computed analytics. Primary table for ad-hoc queries. Project scoped: yes.
events_computed (
subject UUID,
date DateTime64(3),
name LowCardinality(String),
path String,
domain String,
currencyCode String,
subjectPurchaseSum Float64,
subjectPurchaseCount Float64,
subjectPurchaseFraction Float64,
subjectPurchaseFractionalSum Float64,
title String
)Currency exchange rates for multi-currency reporting. Project scoped: no.
currency_exchange_rates (
date Date,
code String,
rate Float32
)Pre-aggregated daily page metrics by day, domain, path, and UTM source. Project scoped: yes.
daily_page_rollups (
day Date,
domain String,
path String,
utm_source String,
views_state AggregateFunction(count),
unique_sessions_state AggregateFunction(uniq, UUID),
converting_sessions_state AggregateFunction(uniq, UUID),
fractional_conversions_state AggregateFunction(sum, Float64),
fractional_revenue_usd_state AggregateFunction(sum, Float64),
session_conversions_state AggregateFunction(sum, UInt64),
session_revenue_usd_state AggregateFunction(sum, Float64)
)Pre-aggregated daily project traffic metrics by day and UTM source. Project scoped: yes.
daily_namespace_rollups (
day Date,
utm_source String,
views_state AggregateFunction(count),
unique_sessions_state AggregateFunction(uniq, UUID),
converting_sessions_state AggregateFunction(uniq, UUID)
)Pre-aggregated daily purchase metrics by day and UTM source. Project scoped: yes.
daily_namespace_purchase_rollups (
day Date,
utm_source String,
purchase_count_state AggregateFunction(count),
total_revenue_usd_state AggregateFunction(sum, Float64),
unique_purchasing_sessions_state AggregateFunction(uniq, UUID)
)1