> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cometly.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Raw conversions

> Every conversion as recorded — the unattributed counterpart to touchpoints.

## 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](/data-warehouse/datasets/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](/data-warehouse/datasets/contacts) the conversion belongs to.               |
| `company_id`      | Optional | The [company](/data-warehouse/datasets/companies) 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.                                                 |