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_PROFILES_REAL_FIELD_NAMES

This view provides a more organized, easy to read view of CUSTOMER_PROFILES. This adheres to the same conditions specified here.

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_PROFILES_REAL_FIELD_NAMES.

SELECT *
FROM [SHARED_DB].BI.CUSTOMERPROFILEFIELDSMAPPING

VW_CUSTOMER_PROFILE_FIELDS

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.

-- FOR V1.6
SELECT *
FROM [SHARED_DB].BI.VW_CUSTOMER_PROFILE_FIELDS_V1_6

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 with a version suffix.

-- For V1
SELECT * FROM [SHARED_DB].BI.LIFECYCLE_STAGES
-- For V1.5
SELECT * FROM [SHARED_DB].BI.LIFECYCLE_STAGES_V1_5

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;