Raw hits - Cometly API Docs

What it is

The Raw hits dataset is the rawest dump: one row per tracking-pixel hit recorded for your space within the window, unfiltered across all event types (page views and everything else). It comes straight off the hits table with no joins.

Grain: one row per hit (id).
Windowed on: event_time_utc (UTC timestamp).
Path segment: raw_hits.

Two things differ from the other raw datasets:

Host, path, and query are separate columns (not combined into a single event_url), because path-level grouping is the primary use of page-view data.
event_name is locked on — an unfiltered, all-event-types dump would be ambiguous without it.

Columns

Hit fields

Column	Status	Description
`id`	Locked	Hit ID — the row grain and dedup key.
`event_time_utc`	Locked	When the hit fired (UTC).
`event_name`	Locked	The hit’s event type (for example `page_view`).
`source`	Optional	Traffic source of the hit.
`profile_id`	Optional	The contact the hit is currently attributed to.
`original_profile_id`	Optional	The contact the hit was first attributed to, before any later identity merges.

Page

Column	Status	Description
`host`	Optional	Host of the hit URL.
`path`	Optional	Path of the hit URL.
`query`	Optional	Query string of the hit URL.
`referrer_host`	Optional	Host of the referrer URL.

Device & location

Column	Status	Description
`country`	Optional	Country of the visit.
`device_type`	Optional	Device type.
`browser`	Optional	Browser.
`os`	Optional	Operating system.

Identifiers

These columns carry sensitive visitor identifiers. They default to off — select them only if your warehouse handling and retention policies allow it.

Column	Status	Description
`ip`	Optional	IP address of the visit.
`web_fingerprint`	Optional	Browser fingerprint.
`comet_token`	Optional	The Comet token (browser identifier) for the visit.