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

# Variation conversion rate

> Variation conversion rate calculated from the saved Experiment OS result inputs.

| Contract           | Value                            |
| ------------------ | -------------------------------- |
| Metric key         | `experiment_os.variation_cvr`    |
| Source             | Experiment OS                    |
| Status             | active                           |
| Type               | application                      |
| Semantic version   | Application calculation          |
| Catalog visibility | Supporting or fixed-surface only |

## How it's calculated

```sql theme={null}
variation_conversions / NULLIF(variation_users, 0)
```

### Built from

* `Manual inputs or approved Intelligems projection`

## Known caveats

* NULLIF guards make unavailable or zero-denominator calculations return null rather than a fabricated zero.
* When populated from Intelligems, the legacy conversions columns contain orders, so this is orders divided by visitors and the UI labels it as an order rate.

## Where this appears

* Experiment detail Results tab
* Experiment OS ROI summaries where applicable

<AccordionGroup>
  <Accordion title="Grain and identity" icon="ruler">
    One Aloftly experiment record.

    **Join and identity keys**

    * org\_id
    * store\_id
    * experiment id
  </Accordion>

  <Accordion title="Filters and boundaries" icon="filter">
    * Tenant scope is enforced by the experiment row.
    * No cross-experiment aggregation is implied by this field.
  </Accordion>

  <Accordion title="Timezone, currency, and freshness" icon="clock">
    **Timezone.** Runtime uses end\_date - start\_date as calendar dates.

    **Currency.** Not applicable.

    **Freshness.** Recomputed by PostgreSQL whenever the saved inputs change.
  </Accordion>

  <Accordion title="Version history" icon="clock-rotate-left">
    | Date       | Change                                               |
    | ---------- | ---------------------------------------------------- |
    | 2026-07-02 | Established generated Experiment OS result formulas. |
  </Accordion>
</AccordionGroup>