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

# Conversion Event Metadata

## Description

* Contains metadata for all conversion events tracked in Rockerbox.
* Provides unique identifiers and human-readable names for conversion events.
* Reference table for filtering attribution data by specific conversion events.
* Includes event lifecycle flags (active/deleted status) and the first reporting date in Rockerbox for each conversion event.

***

## Schema Structure

* **`conversion_event_metadata`**: Single lookup table containing conversion event definitions and metadata.

***

## Usage Notes

* **Filtering Attribution Data**: Use `conversion_event_id` to filter `log_mta` and other attribution tables to specific conversion types (e.g., Purchase, Add to Cart).
* **Event Discovery**: Query this table to find available conversion events and their IDs before filtering attribution data.
* **Active Events**: Filter by `active = true` to see currently tracked conversion events.
* **Query Pattern**: Join with attribution tables using `conversion_event_id` to add human-readable event names to your results.

***

## Table Creation

This table is automatically created upon connecting Rockerbox with your supported warehouse provider.

***

## Logical Primary Key

* `conversion_event_id` — Unique identifier for each conversion event type

***

## Field Reference

### Table: `conversion_event_metadata`

Metadata for all conversion events tracked in Rockerbox.

| Name                    | Description                                                                              | Type |
| ----------------------- | ---------------------------------------------------------------------------------------- | ---- |
| conversion\_event\_id   | Unique identifier for the conversion event type                                          | str  |
| conversion\_event\_name | Human-readable name of the conversion event (e.g., "Purchase - Pixel", "Add to Cart")    | str  |
| first\_reporting\_date  | Date when this conversion event first started reporting data in Rockerbox                | date |
| active                  | `true` if the conversion event is currently being tracked, `false` if tracking is paused | bool |
| deleted                 | `true` if the conversion event has been deleted, `false` otherwise                       | bool |