> ## Documentation Index
> Fetch the complete documentation index at: https://docs.replo.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Analytics tables

> Tables, columns and external metric views the analytics query endpoint can read.

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.

```sql theme={null}
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.

```sql theme={null}
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.

```sql theme={null}
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.

```sql theme={null}
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.

```sql theme={null}
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.

```sql theme={null}
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` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.