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


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