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>