Start free
POST /v1/api/query/count/{tenantId}

{
  "event": "page_viewed",
  "after": "2025-10-01",
  "before": "2025-10-22",
  "filterSet": [{
    "property": "page_path",
    "comparison": "equals",
    "value": "/pricing"
  }]
}

→ Returns: { "count": 4821 }

What it does.

Fast Queries

ClickHouse-powered backend with millisecond response times.

Flexible Queries

Query, count, and list events with multi-operator filtering.

Advanced Filters

Filter by any property with AND/OR logic and date ranges.

Enterprise Security

API key authentication with rate limiting and audit logs.

Pagination

Cursor-based pagination for efficient large dataset handling.

Time Filtering

Precise date range queries with before/after parameters.

Why it is different.

No SQL Required

Simple REST API with JSON. Start querying in minutes.

Powerful Filtering

Multiple comparison operators and chained filter conditions.

Analytics-Optimized

Built for aggregations with count endpoint optimization.

Everything included.

Query events with flexible filtering
Count events matching criteria
Filter by properties and user attributes
Date range filtering (after/before)
Pagination for large result sets
List distinct event names
Multiple comparison operators
API key authentication

Who uses it.

Custom Dashboards

Build internal dashboards with your tools. Fetch and visualize data in real-time.

Product, Engineering

Data Warehousing

Export to BigQuery, Snowflake, or your database for deep analysis.

Data Engineering, BI

Automated Reports

Generate and distribute reports automatically without manual work.

Marketing, Operations

Embedded Analytics

Power customer-facing analytics in your SaaS application.

SaaS, B2B

Questions.

No. The Query API uses simple REST endpoints with JSON payloads. You specify event names, date ranges, and filters as structured objects — no SQL syntax required. Most integrations can be built in minutes.