Raw conversions - Cometly API Docs

What it is

The Raw conversions dataset is one row per conversion recorded for your space within the window. It is the raw record with no attribution applied — to join conversions to the touchpoints that earned credit, use Attributed conversions.

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

Selecting any Visit metadata column joins the conversion’s visit-context record; otherwise no join is performed.

Columns

Conversion fields

Column	Status	Description
`id`	Locked	Conversion ID — the row grain and dedup key.
`event_time_utc`	Locked	When the conversion occurred (UTC).
`event_name`	Optional	The raw event name as tracked.
`configured_name`	Optional	The event’s display name as configured for your space (falls back to the raw event name).
`amount`	Optional	Monetary value of the conversion.
`profile_id`	Optional	The contact the conversion belongs to.
`company_id`	Optional	The company the contact belongs to.
`is_upsell`	Optional	Whether the conversion is flagged as an upsell.

Visit metadata

The visit-context record for the conversion. All optional; selecting any one joins the metadata table.

Column	Status	Description
`order_id`	Optional	Order ID from the source event, if any.
`order_name`	Optional	Order name or number from the source event.
`idempotency_key`	Optional	Idempotency key of the source event.
`event_url`	Optional	Full event URL, assembled from host, path, and query string.
`referrer_url`	Optional	Full referrer URL, assembled from referrer host, path, and query.
`fbclid`	Optional	Facebook click ID captured on the visit.
`fbp`	Optional	Facebook browser ID (fbp).
`gclid`	Optional	Google click ID.
`ttclid`	Optional	TikTok click ID.
`lnclid`	Optional	LinkedIn click ID.
`msclkid`	Optional	Microsoft click ID.
`rdt_cid`	Optional	Reddit click ID.
`tblci`	Optional	Taboola click ID.
`device_type`	Optional	Device type of the visit.
`os`	Optional	Operating system.
`browser`	Optional	Browser.
`language`	Optional	Browser language.