Views - Customer Profiles
CUSTOMER_PROFILES views contains fields that you might want to use as text or by their ID. Here you will find some useful views to make all the different data points accessible with ease.
VW_CUSTOMER_PROFILE_REAL_FIELD_NAME
This view provides a more organized, easy to read view of CUSTOMER_PROFILES. This adheres to the same conditions specified here.
-- FOR V1.1
SELECT *
FROM [SHARED_DB].BI.VW_CUSTOMER_PROFILES_REAL_FIELD_NAMES
CUSTOMERPROFILEFIELDSMAPPING
Using this view enables translation of CUSTOMER_PROFILES column names. This step is redundant if you used VW_CUSTOMER_PROFILE_REAL_FIELD_NAME.
SELECT *
FROM [SHARED_DB].BI.CUSTOMERPROFILEFIELDSMAPPING
VW_CUSTOMER_PROFILE_FIELDS_V1_2
In this view you will find CUSTOMER_PROFILE_FIELD_NAME, REAL_FIELD_NAME and ALIAS_FIELD_NAME. The latter represents a customer attribute name as it appears in Optimove and might be more comprehensive when collaborating with different teams.
SELECT *
FROM [SHARED_DB].BI.VW_CUSTOMER_PROFILE_FIELDS_V1_2
LIFECYCLE_STAGES
This view provides a dictionary for Optimoves internal ID for lifecycle stages, which are the cornerstone of Optimove's out-of-the-box segmentation. This view might appear as LIFECYCLE_STAGES or LIFECYCLE_STAGES_V1_2
-- For V1
SELECT * FROM [SHARED_DB].BI.LIFECYCLE_STAGES
-- For V1.2
SELECT * FROM [SHARED_DB].BI.LIFECYCLE_STAGES_V1_2
COMPANIES
Legacy of view LIFECYCLE_STAGES and contains the same information. Please consider using the alternative view instead.
-- For V1
SELECT * FROM [SHARED_DB].BI.COMPANIES;
-- For V1.2
SELECT * FROM [SHARED_DB].BI.COMPANIES_V1_2;
Updated 11 days ago