Analytics tables

The analytics query endpoint runs read-only ClickHouse SQL over these tables and views. Project-scoped tables are restricted to the requested project server-side.

Tables

Parameterized view: session_attribution(since=‘YYYY-MM-DD’, until=‘YYYY-MM-DD’), inclusive UTC dates. Computes USD purchase, session, and equal-pageview attributed revenue across authorized sibling projects within that window, before domain filters. Cart/checkout views receive no attribution. Deduplicate sessionRevenueUsd by subject before summing. Inherits source row policies. Project scoped: yes.

session_attribution (
  subject UUID,
  date DateTime64(3),
  name LowCardinality(String),
  domain String,
  path String,
  title String,
  purchaseRevenueUsd Float64,
  sessionRevenueUsd Float64,
  sessionPurchaseCount UInt64,
  attributedRevenueUsd Float64
)

Raw events with project-local computed session metrics. Use session_attribution for revenue across linked projects. 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. Revenue/conversion attribution is project-local; use session_attribution across linked projects. 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)
)

External metric views

Each connected integration below exposes parameterized views. Call them with named since and until dates (YYYY-MM-DD, inclusive). Views ending in _metrics_daily return date, metric, value, _metrics_totals return metric, current, previous, and _metrics_list return metric. The Google Analytics, Search Console and ROI report views also take settings JSON, and Intelligems experience views take experience_id. Credentials and project scope are injected server-side.

Integration	Key	Views
Triple Whale	`triple-whale`	`triplewhale_metrics_daily`, `triplewhale_metrics_totals`, `triplewhale_metrics_list`
Contentsquare	`contentsquare`	`contentsquare_metrics_daily`, `contentsquare_metrics_totals`, `contentsquare_metrics_list`
Mixpanel	`mixpanel`	`mixpanel_metrics_daily`, `mixpanel_metrics_totals`, `mixpanel_metrics_list`
Lifetimely	`lifetimely`	`lifetimely_metrics_daily`, `lifetimely_metrics_totals`, `lifetimely_metrics_list`
Intelligems	`intelligems`	`intelligems_metrics_daily`, `intelligems_metrics_totals`, `intelligems_metrics_list`, `intelligems_experience_metrics_daily`, `intelligems_experience_metrics_totals`, `intelligems_experience_metrics_list`
SEO ROI	`roi`	`replo_roi_monthly`
Shopify	`shopify`	`shopify_sales_monthly`
Google Analytics	`google-analytics`	`google_analytics_report`
Search Console	`google-search-console`	`google_search_console_report`

Overview

Endpoints

Changelog

Analytics tables

Tables

External metric views

​Tables

​External metric views

Tables

External metric views