Views - Campaign Results

Views are out-of-the-box data queries on top of the base structure of the data, providing easy access to common use cases required datasets and additional data useful to exploit the data lakes product fully.

Using views, Data lakes evolve while providing you with data contracts that will be kept and enable stable integrations with your internal platforms.

This table presents a row for each campaign occurance, on each KPI tracked by Optimove, on each lifecyclestage. Viewing a certain campaign occurrence performance can be achieved by summing [INCREASE_IN] for a selected KPI, from all lifecycle stages involved.

Each row represents an action within an occurrence of a campaign.

This view provides a more organized view of campaign results data. It will be kept in this structure and can be used to integrate additional tools to it.

VW_CAMPAIGN_RESULTS (v1.1)

-- FOR V1.1
SELECT *
FROM [SHARED_DB].[BI].[VW_CAMPAIGN_RESULTS]

Table Description