Prism Data Dictionary
Event Objects
Event objects are stored as they are received from journey stream with minimal transformation. Event objects include:
- metrics - All metric events for touchpoints tracked in the Strala system. Used to provide ROI.
- touchpoint_interactions - Every interaction with a touchpoint which has been posted to journeystream.
- conversions - All conversion events by who_id that have been posted to journeystream.
Metadata
Metadata objects are informational objects used for viewing slices of the event and analytics objects. Metadata objects include:
- touchpoints - A dump of all touchpoint dimensions from the Strala App.
Analytics
Analytics objects are transformed data structures that contain attribution models, funnel analysis, etc. Analytics objects include:
- fact_leads_accum_snapshot - An accumulating snapshot view that lets you view lead progression through the funnel.
- fact_mtl_conversions - A multi-touch linear attribution model that utilizes all stages in the funnel in combination with touchpoint interactions.
Metrics
event_uuid varchar(255) -- a unique uuid representing the event touchpoint_id varchar(255) -- the touchpoint id associated with the metric event event_date_time timestamp -- the timestamp associated with the metric event event_type varchar(255) -- the type of metric event captured captured_at timestamp -- the data that journeystream received the event integration -- the integration the metric event was received from cost numeric -- the cost of the metric event clicks integer -- if any, the clicks associated with the metric event impressions integer -- if any, the impressions associated with the metric event time_grain varchar -- determines how many days the cost spreads over inserted_at timestamp -- the date the event was loaded into prism updated_at timestamp -- the last date the event was updated in prism<br>
touchpoint_interactions
<em>event_uuid varchar -- a unique uuid representing the event touchpoint_id varchar -- the touchpoint id associated with the touchpoint event who_uuid varchar -- the uuid representing the user interacting with the touchpoint event_date_time timestamp -- the timestamp associated with the touchpoint interaction event event_type varchar -- the type of interaction event captured captured_at timestamp -- the data that journeystream received the event integration -- the integration the event was received from touchpoint_interaction integer -- a metric defaulting to 1, used for summing interactions page_url varchar -- the page_url associated with the event referrer_url varchar -- the referrer_url associated with the event user_agent varchar -- the user reported agent at the time of the event platform varchar -- the user reported platform at the time of the event vendor varchar -- the user reported vendor at the time of the event inserted_at timestamp -- the date the event was loaded into prism updated_at timestamp -- the last date the event was updated in prism<br></em>
conversions
<em>event_uuid varchar -- a unique uuid representing the event touchpoint_id varchar -- the touchpoint id associated with the touchpoint event (almost always NULL for conversion events) conversion_id varchar -- the id associated with the conversion (for SFDC conversion events it is the object ID) who_uuid varchar -- the Strala uuid representing the user converting event_date_time timestamp -- the timestamp associated with the conversion event event_type varchar -- the type of interaction event captured captured_at timestamp -- the data that journeystream received the event integration -- the integration the event was received from conversion integer -- a metric defaulting to 1, used for summming conversions conversion_event varchar -- the name of the conversion event conversion_object_type varchar -- the object type associated with the conversion revenue numeric -- the reported value of the conversion event time_grain varchar -- if reported, defines subscription length tied to revenue page_url varchar -- the page_url associated with the event referrer_url varchar -- the referrer_url associated with the event user_agent varchar -- the user reported agent at the time of the event platform varchar -- the user reported platform at the time of the event vendor varchar -- the user reported vendor at the time of the event inserted_at timestamp -- the date the event was loaded into prism updated_at timestamp -- the last date the event was updated in prism<br></em>