Query events (web_event)

Base event columns only, with no identity resolution. The cheapest tier, and the one to use for volume, scoping and trend work.

Bills the web_event meter. The route fixes both the price and the field set, so what a call costs is legible before you make it.

Selecting a field above this tier is rejected with a 400 naming the field and the tier that carries it, rather than being silently dropped or silently billed higher. Call this tier's /schema route to see exactly which fields it admits: the allowed set is derived from the event schema and the billing catalogue, so a field that becomes billable leaves the cheaper tiers automatically.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Query Params
string
enum
Defaults to pixel

Event source type: pixel or dsp. Defaults to pixel if omitted.

Allowed:
string

Pixel identifier. Use with source=pixel.

string

Project identifier. Queries all pixels in the project (source=pixel). Also required alongside campaign_id for Bearer token auth (source=dsp).

string

Campaign identifier. Use with source=dsp. Bearer token auth requires project_id alongside campaign_id.

int64
required

Inclusive start timestamp in milliseconds since epoch. Required: a request without start_ms and end_ms returns 400.

int64
required

Inclusive end timestamp in milliseconds since epoch. Must be after start_ms. The window is at most 25 hours, or 92 days with include_cold=true; a wider window returns 400.

integer
1 to 2000
Defaults to 300

Maximum number of rows to return. Defaults to 300. A value above 2000 is refused with 400, not clamped.

integer
≥ 0

Number of rows to skip before returning results.

string

Comma-separated column list to project specific fields.

string

Filter expression using <field>:<op>:<value> syntax.

string

A single field to deduplicate the result set on. Takes one field, not a comma-separated list.

boolean
Defaults to false

When true, also read date partitions older than the event store's local retention window from cold storage (S3), and allow a longer time window of up to 92 days instead of 25 hours. Works for any source (pixel or dsp). Off by default.

boolean
Defaults to false

When true, returns the meter and records_to_charge this query would bill, without running it or billing anything. records_to_charge is an upper bound: at most limit, lower when the window holds fewer events. Needs the same start_ms and end_ms as the real query.

Responses

400

Invalid query. A missing or invalid start_ms or end_ms, a window wider than allowed, a limit above 2000, a select naming a field above this tier, or a distinct naming more than one field.

401

Missing or invalid API key.

500

Query failed.

Language
Credentials
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json