Version V1_2

As part of Data Share product development Optimove releases updates to the existing shared views, making them more usable and understandable

Release Version: V1.2

Changelog:

1. VW_TARGETED_AND_EXCLUDED_CUSTOMERS_V1_2
   • A new column, CLIENT_CUSTOMER_ID, has been added.
   • A new column, CAMPAIGN_ACTION_ID, has been added.
   • A new column, LIFECYCLE_STAGE_ID, has been added.
   • The column LIFECYCLE_STAGE has been renamed to LIFECYCLE_STAGE_NAME.
   • The column ACTION_NAME has been renamed to CAMPAIGN_ACTION_NAME.
2. VW_ENGAGED_CUSTOMERS_V1_2
   • A new column, CLIENT_CUSTOMER_ID, has been added.
   • A new column, CAMPAIGN_ACTION_NAME, has been added.
   • A new column, TEMPLATE_NAME, has been added.
   • The column ACTIONSERIAL has been renamed to CAMPAIGN_ACTION_ID.
   • The following column name changes have been applied:
     • CUSTOMERID has been renamed to CUSTOMER_ID
     • ENGAGEDDATE has been renamed to ENGAGED_DATE
     • CAMPAIGNDETAILID has been renamed to CAMPAIGN_DETAIL_ID
     • ISVISITOR has been renamed to IS_VISITOR
     • OPTIMOVEID has been renamed to OPTIMOVE_ID
     • TEMPLATEID has been renamed to TEMPLATE_ID
3. VW_CUSTOMER_PROFILE_FIELDS_V1_2
   • The CUSTOMERPROFILEFIELDSMAPPING view has been enriched with the Alias column from the source table, matches attributes name you see in Optimove.
4. VW_SCHEDULED_CAMPAIGNS_V1_2
   • A new column, CHANNEL_NAME, has been added immediately after CHANNEL_ID.
   • Two new columns, TEMPLATE_ID and TEMPLATE_NAME, have been added
   • A new column, CAMPAIGN_TYPE, has been added
   • A new column, CAMPAIGN_ACTION_ID, has been added.
   • The column EXECUTION_METHOD_ID has been renamed to CHANNEL_ID.
   • immediately before the CAMPAIGN_TYPE_NAME column.
   • The column ACTION_NAME has been renamed to CAMPAIGN_ACTION_NAME.
   • The column IS_ACTION_GROUP has been renamed to IS_CAMPAIGN_ACTION_GROUP.
   • The column ACTION_TYPE has been renamed to CAMPAIGN_ACTION_TYPE.
   • A new column, TARGET_GROUP_ID (same as TARGET_GROUP_SERIAL), has been added before TARGET_GROUP_NAME, positioned as the 3rd column.
   • Tags in this view are now translated into their real values and presented in double quotes, separated by commas (e.g., "Tag1","Tag2","Tag3").
5. VW_CAMPAIGN_RESULTS_V1_2
   • A new column, CAMPAIGN_TYPE_NAME, has been added
   • A new column, LIFECYCLE_STAGE_ID, has been added
   • The column LIFECYCLE_STAGE has been renamed to LIFECYCLE_STAGE_NAME.
   • A new column, TARGET_GROUP_ID (same as TARGET_GROUP_SERIAL), has been added.
6. VW_TRIGGERED_CAMPAIGNS_V1_2
   • A new column, CAMPAIGN_ACTION_NAME, has been added.
   • A new column, TARGET_GROUP_NAME, has been added
   • The column ACTION_ID has been renamed to CAMPAIGN_ACTION_ID.
   • The column TARGET_GROUP_SERIAL has been renamed to TARGET_GROUP_ID.
7. VW_TRIGGERED_CAMPAIGN_RESULTS_V1_2 (formerly VW_ENGAGEDACTIONTOTALS)
   • A new column, CAMPAIGN_ACTION_NAME, has been added.
   • The column ACTIONSERIAL has been renamed to CAMPAIGN_ACTION_ID.