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;