Conversion Event Metadata - Rockerbox Data Foundation Docs

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.

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

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.

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

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