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.
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. |