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>

fact_leads_accum_snapshot

<em>conversion_event_uuid varchar -- a unique uuid representing the conversion event
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
distribution numeric -- the attribution multiplier used to apply attribution
rank integer -- the attribution rank used to identify the plac within all attributed events
spread integer -- the total number of items used for attribution
conversion_event_date timestamp  -- the timestamp associated with the conversion event
touchpoint_event_uuid varchar -- a unique uuid representing the touchpoint event
touchpoint_id varchar -- the touchpoint id associated with the touchpoint event
touchpoint_event_date -- the timestamp associated with the touchpoint interaction event
page_url varchar -- the page url associated with the touchpoint interaction event
referrer_url varchar -- the refering url associated with the touchpoint interaction event
user_agent varchar -- basic high level machine information associated with the touchpoint interaction event
platform varchar -- the type of high level platform associated with the touchpoint interaction event
vendor varchar -- the high level browser vendor associated with the touchpoint interaction event
conversion_event varchar -- the name of the conversion event (Leads, New Opportunity, etc.)
revenue numeric -- the revenue associated with the conversion event
leadsource varchar -- the lead source associated with the conversion event (where conversion_event = Lead)
newoppty_conversion_date timestamp -- the timestamp associated with the new opportunity conversion event (NULL if none)
sqooppty_conversion_date timestamp  -- the timestamp associated with the SQO conversion event (NULL if none)
evaloppty_conversion_date timestamp -- the timestamp associated with the evaluating opportunity conversion event (NULL if none)
shortoppty_conversion_date timestamp -- the timestamp associated with the shortlist opportunity conversion event (NULL if none)
wonoppty_conversion_date timestam -- the timestamp associated with the won opportunity conversion event (NULL if none)<br></em>

fact_mtl_conversions

conversion_event_uuid varchar -- a unique uuid representing the conversion event
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
distribution numeric -- the attribution multiplier used to apply attribution
rank integer -- the attribution rank used to identify the plac within all attributed events
spread integer -- the total number of items used for attribution
conversion_event_date timestamp  -- the timestamp associated with the conversion event
touchpoint_event_uuid varchar -- a unique uuid representing the touchpoint event
touchpoint_id varchar -- the touchpoint id associated with the touchpoint event
touchpoint_event_date timestamp -- the timestamp associated with the touchpoint interaction event
page_url varchar -- the page url associated with the touchpoint interaction event
referrer_url varchar - the refering url associated with the touchpoint interaction event
user_agent varchar - basic high level machine information associated with the touchpoint interaction event
platform varchar -- the type of high level platform associated with the touchpoint interaction event
vendor varchar -- the high level browser vendor associated with the touchpoint interaction event
conversion_event varchar -- the name of the conversion event (Leads, New Opportunity, etc.)
revenue numeric -- the revenue associated with the conversion event
leadsource varchar -- the lead source associated with the conversion event (where conversion_event = Lead)
next_conversion_date timestamp -- the timestamp of the next conversion event in the funnel
next_step varchar -- the name of the conversion event, wchich is the next step in the funnel<br>