> ## 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](https://docs.cometly.com/data-warehouse/datasets/attributed-conversions.md).

* **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](https://docs.cometly.com/data-warehouse/datasets/contacts.md) the conversion belongs to. |
| `company_id` | Optional | The [company](https://docs.cometly.com/data-warehouse/datasets/companies.md) the contact belongs to — joins to the Companies dataset's `id`. From there, join to your own account tables on `companies.external_id`, which is your `company_external_id` as stored: surrounding whitespace trimmed, case preserved, and integer values stored as their decimal string (`1234567`). The match is byte-exact and case-sensitive, so join on exact equality, not a case-insensitive one. |
| `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. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.