Prism Output

Prism Output File Details

Prism files are delivered to an s3 bucket on a daily basis for end user consumption. The files are sharded into evenly sized compressed files and they are broken into the following categories:

  • Lookback files
  • Lookforward files

Prism files follow these conventions:

  • Pipe delimited .csv files
  • gZip compressed
  • UTF-8 encoded


Lookback Files

Lookback files take each conversion event and look back for touchpoint interaction events that happened prior to the conversion event. 

Details

  • If a touchpoint interaction event did not lead to a conversion event, the touchpoint interaction event will not show up in the Lookback file. Instead the touchpoint interaction event in this scenario will be part of the Lookforward file. 

Lookback files have the following structure:

Field Data Type Description
INTERACTION_CAPTURED_AT TIMESTAMPNTZ The UTC datetime the interaction event was captured
INTERACTION_EVENT_DATE_TIME TIMESTAMPNTZ The UTC datetime the interaction event happened
INTERACTION_EVENT_TYPE VARCHAR The type of interaction event
INTERACTION_EVENT_UUID VARCHAR The unique identifier of the interaction event
INTERACTION_INTEGRATION VARCHAR The integration that produced the interaction event
INTERACTION_ORGANIZATION_UUID VARCHAR The organization UUID of the customer that generated the interaction event
INTERACTION_TOUCHPOINT_ID VARCHAR The Touchpoint ID associated with the interaction event
INTERACTION_ID VARCHAR The ID designated by the sender for the interaction event (sent as conversion_id but relabeled interaction_id here to eliminate confusion)
INTERACTION_CUSTOM_DIMENSION_1 VARCHAR The first custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_2 VARCHAR The second custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_3 VARCHAR The third custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_4 VARCHAR The fourth custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_5 VARCHAR The fifth custom dimension attribute sent with the interaction event
INTERACTION_EVENT VARCHAR The name of the interaction event (sent as conversion_event bu relabeled interaction_event here to eliminate confusion)
INTERACTION_OBJECT_TYPE VARCHAR The high level object type of the interaction event (sent as conversion_object_type but relabeled interaction_object_type here to avoid confusion)
INTERACTION_METRIC_EVENTS DOUBLE The quantity associated with the interaction event (almost always 1)
INTERACTION_CUSTOM_METRIC_1 VARCHAR The first custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_2 VARCHAR The second custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_3 VARCHAR The third custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_4 VARCHAR The fourth custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_5 VARCHAR The fifth custom metric attribute sent with the interaction event
INTERACTION_PAGE_URL VARCHAR The page url associated with the interaction event (used for online only)
INTERACTION_REFERRER_URL VARCHAR The referrer url associated with the interaction event (used for online only)
INTERACTION_PLATFORM VARCHAR The platform associated with the interaction event (used for online only)
INTERACTION_USER_AGENT VARCHAR The user agent associated with the interaction event (used for online only)
INTERACTION_VENDOR VARCHAR The vendor of the browser associated with the interaction event (used for online only)
INTERACTION_KEYWORD VARCHAR The keyword run-time attribute associated with the interaction event (used for online only)
INTERACTION_MATCH_TYPE VARCHAR The match type run-time attribute associated with the interaction event (used for online only)
INTERACTION_AD_POSITION VARCHAR The ad position run-time attribute associated with the interaction event (used for online only)
INTERACTION_DEVICE VARCHAR The device run-time attribute associated with the interaction event (used for online only)
WHO_UUID VARCHAR The anonymous identifier of the person associated with the interaction and conversion events
WHO_TYPE VARCHAR The type of anonymous identifier (examples: Strala; Internal; etc.)
CONVERSION_CAPTURED_AT TIMESTAMPNTZ The UTC datetime the conversion event was captured
CONVERSION_EVENT_DATE_TIME TIMESTAMPNTZ The UTC datetime the conversion event happened
CONVERSION_EVENT_TYPE VARCHAR The type of conversion event
CONVERSION_EVENT_UUID VARCHAR The unique identifier of the conversion event
CONVERSION_INTEGRATION VARCHAR The integration that produced the conversion event
CONVERSION_ORGANIZATION_UUID VARCHAR The organization UUID of the customer that generated the conversion event
CONVERSION_TOUCHPOINT_ID VARCHAR The Touchpoint ID associated with the conversion event (always empty except for specific, custom circumstances)
CONVERSION_ID VARCHAR The ID designated by the sender for the conversion event
CONVERSION_CUSTOM_DIMENSION_1 VARCHAR The first custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_2 VARCHAR The second custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_3 VARCHAR The third custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_4 VARCHAR The fourth custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_5 VARCHAR The fifth custom dimension attribute sent with the conversion event
CONVERSION_EVENT VARCHAR The name of the conversion event
CONVERSION_OBJECT_TYPE VARCHAR The high level object type of the conversion event
CONVERSION_METRIC_EVENTS DOUBLE The quantity associated with the conversion event (almost always 1)
CONVERSION_CUSTOM_METRIC_1 VARCHAR The first custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_2 VARCHAR The second custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_3 VARCHAR The third custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_4 VARCHAR The fourth custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_5 VARCHAR The fifth custom metric attribute sent with the conversion event
CONVERSION_METRIC_REVENUE VARCHAR The conversion amount in USD associated with the conversion event
CONVERSION_PAGE_URL VARCHAR The page url associated with the conversion event (used for online only)
CONVERSION_REFERRER_URL VARCHAR The referrer url associated with the conversion event (used for online only)
CONVERSION_DISTRIBUTION DOUBLE The base distribution for the conversion event across all interaction events. Also calld the MTL (multi-touch linear) distribution
CONVERSION_RANK DOUBLE The ordinal position of the attributed conversion event across all interaction events
CONVERSION_SPREAD DOUBLE The total number of times the conversion event is attributed to interaction events
MTTD_DISTRIBUTION DOUBLE The multi-touch time decay attribution distribution for the conversion event across all interaction events (attribution credit goes down as you move further away from the conversion event)
MTU_DISTRIBUTION DOUBLE The multi-touch u-shaped attribution distribution for the conversion event across all interaction events (the first and last interaction events get 40% and everything in between shares the remaining 20%)
STF_DISTRIBUTION DOUBLE The single-touch first attribution distribution for the conversion event across all interaction events (the first interaction event gets 100%) 
STL_DISTRIBUTION DOUBLE The single-touch last attribution distribution for the conversion event across all interaction events (the last interaction event gets 100%)


Lookforward Files 

Lookforward files take each touchpoint interaction event and look forward for any conversion events that happened following the touchpoint interaction event. 

Details

  • If multiple conversion events are in the path of a touchpoint interaction event, the touchpoint interaction event will appear independently for each conversion journey. 
  • If a conversion event was not preceded by any touchpoint interaction events, the conversion event will not show up in the Lookforward file. Instead, the conversion event in this scenario will be part of the Lookback file. 

Lookforward files have the following structure:

INTERACTION_CAPTURED_AT TIMESTAMPNTZ The UTC datetime the interaction event was captured
INTERACTION_EVENT_DATE_TIME TIMESTAMPNTZ The UTC datetime the interaction event happened
INTERACTION_EVENT_TYPE VARCHAR The type of interaction event
INTERACTION_EVENT_UUID VARCHAR The unique identifier of the interaction event
INTERACTION_INTEGRATION VARCHAR The integration that produced the interaction event
INTERACTION_ORGANIZATION_UUID VARCHAR The organization UUID of the customer that generated the interaction event
INTERACTION_TOUCHPOINT_ID VARCHAR The Touchpoint ID associated with the interaction event
INTERACTION_ID VARCHAR The ID designated by the sender for the interaction event (sent as conversion_id but relabeled interaction_id here to eliminate confusion)
INTERACTION_CUSTOM_DIMENSION_1 VARCHAR The first custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_2 VARCHAR The second custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_3 VARCHAR The third custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_4 VARCHAR The fourth custom dimension attribute sent with the interaction event
INTERACTION_CUSTOM_DIMENSION_5 VARCHAR The fifth custom dimension attribute sent with the interaction event
INTERACTION_EVENT VARCHAR The name of the interaction event (sent as conversion_event bu relabeled interaction_event here to eliminate confusion)
INTERACTION_OBJECT_TYPE VARCHAR The high level object type of the interaction event (sent as conversion_object_type but relabeled interaction_object_type here to avoid confusion)
INTERACTION_METRIC_EVENTS DOUBLE The quantity associated with the interaction event (almost always 1)
INTERACTION_CUSTOM_METRIC_1 VARCHAR The first custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_2 VARCHAR The second custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_3 VARCHAR The third custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_4 VARCHAR The fourth custom metric attribute sent with the interaction event
INTERACTION_CUSTOM_METRIC_5 VARCHAR The fifth custom metric attribute sent with the interaction event
INTERACTION_PAGE_URL VARCHAR The page url associated with the interaction event (used for online only)
INTERACTION_REFERRER_URL VARCHAR The referrer url associated with the interaction event (used for online only)
INTERACTION_PLATFORM VARCHAR The platform associated with the interaction event (used for online only)
INTERACTION_USER_AGENT VARCHAR The user agent associated with the interaction event (used for online only)
INTERACTION_VENDOR VARCHAR The vendor of the browser associated with the interaction event (used for online only)
INTERACTION_KEYWORD VARCHAR The keyword run-time attribute associated with the interaction event (used for online only)
INTERACTION_MATCH_TYPE VARCHAR The match type run-time attribute associated with the interaction event (used for online only)
INTERACTION_AD_POSITION VARCHAR The ad position run-time attribute associated with the interaction event (used for online only)
INTERACTION_DEVICE VARCHAR The device run-time attribute associated with the interaction event (used for online only)
WHO_UUID VARCHAR The anonymous identifier of the person associated with the interaction and conversion events
WHO_TYPE VARCHAR The type of anonymous identifier (examples: Strala; Internal; etc.)
CONVERSION_CAPTURED_AT TIMESTAMPNTZ The UTC datetime the conversion event was captured
CONVERSION_EVENT_DATE_TIME TIMESTAMPNTZ The UTC datetime the conversion event happened
CONVERSION_EVENT_TYPE VARCHAR The type of conversion event
CONVERSION_EVENT_UUID VARCHAR The unique identifier of the conversion event
CONVERSION_INTEGRATION VARCHAR The integration that produced the conversion event
CONVERSION_ORGANIZATION_UUID VARCHAR The organization UUID of the customer that generated the conversion event
CONVERSION_TOUCHPOINT_ID VARCHAR The Touchpoint ID associated with the conversion event (always empty except for specific, custom circumstances)
CONVERSION_ID VARCHAR The ID designated by the sender for the conversion event
CONVERSION_CUSTOM_DIMENSION_1 VARCHAR The first custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_2 VARCHAR The second custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_3 VARCHAR The third custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_4 VARCHAR The fourth custom dimension attribute sent with the conversion event
CONVERSION_CUSTOM_DIMENSION_5 VARCHAR The fifth custom dimension attribute sent with the conversion event
CONVERSION_EVENT VARCHAR The name of the conversion event
CONVERSION_OBJECT_TYPE VARCHAR The high level object type of the conversion event
CONVERSION_METRIC_EVENTS DOUBLE The quantity associated with the conversion event (almost always 1)
CONVERSION_CUSTOM_METRIC_1 VARCHAR The first custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_2 VARCHAR The second custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_3 VARCHAR The third custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_4 VARCHAR The fourth custom metric attribute sent with the conversion event
CONVERSION_CUSTOM_METRIC_5 VARCHAR The fifth custom metric attribute sent with the conversion event
CONVERSION_METRIC_REVENUE VARCHAR The conversion amount in USD associated with the conversion event
CONVERSION_PAGE_URL VARCHAR The page url associated with the conversion event (used for online only)
CONVERSION_REFERRER_URL VARCHAR The referrer url associated with the conversion event (used for online only)
CONVERSION_DISTRIBUTION DOUBLE The base distribution for the conversion event across all interaction events. Also calld the MTL (multi-touch linear) distribution
CONVERSION_RANK DOUBLE The ordinal position of the attributed conversion event across all interaction events
CONVERSION_SPREAD DOUBLE The total number of times the conversion event is attributed to interaction events
MTTD_DISTRIBUTION DOUBLE The multi-touch time decay attribution distribution for the conversion event across all interaction events (attribution credit goes down as you move further away from the conversion event)
MTU_DISTRIBUTION DOUBLE The multi-touch u-shaped attribution distribution for the conversion event across all interaction events (the first and last interaction events get 40% and everything in between shares the remaining 20%)
STF_DISTRIBUTION DOUBLE The single-touch first attribution distribution for the conversion event across all interaction events (the first interaction event gets 100%) 
STL_DISTRIBUTION DOUBLE The single-touch last attribution distribution for the conversion event across all interaction events (the last interaction event gets 100%)
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.