Streams Results

Overview

Monitor results of streams that are running and/or completed. Examine each stream results across all available KPIs, just like regular campaigns are.


How to use with other data parts

By crossing stream results with VW_STREAMS_METADATA additional properties of streams can be analyzed to examine which streams yield the best results.

Comparing KPI_ID / KPI_NAME with other campaigns can provide insights about the most effective marketing communications and methods.


SELECT * 
FROM VW_STREAM_RESULTS_V1_3 LIMIT 10;

🔑 Primary Keys

  • Primary Key - STREAM_ID, TREATMENT_ID, KPI_ID
  • Watermark - UPDATED_AT

Table Description

Field NameDescriptionData TypeFormat
STREAM_IDIdentifier of the streamNUMBER (38,0)
STREAM_NAMEName of the streamTEXT (200)
TREATMENT_IDIdentifier of the treatmentNUMBER (38,0)
TREATMENT_NAMEName of the treatmentTEXT (200)
KPI_IDIdentifier of the KPI measured in this recordNUMBER (38,0)
KPI_NAMEName of the KPI measured in this recordTEXT (510)
KPI_GROUP_SIZENumber of responders in this KPIFLOAT
KPI_AVG_VALUEPer customer average value of measured KPIFLOAT
IS_WINNING_TREANTMENTFlag if this isNUMBER (1,0)
UPDATED_ATTimestamp of last update on this recordTIMESTAMP_NTZ