Streams Results

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 the Streams Metadata view (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.

Query

-- FOR V1.6
SELECT *
FROM [SHARED_DB].BI.VW_STREAM_RESULTS_V1_6
LIMIT 10

-- FOR V1.5
SELECT *
FROM [SHARED_DB].BI.VW_STREAM_RESULTS_V1_5
LIMIT 10

-- FOR V1.3
SELECT *
FROM [SHARED_DB].BI.VW_STREAM_RESULTS_V1_3
LIMIT 10

🔑 Primary Keys

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

Table Description