Populate the Tutorial Events Table | Vantage Customer Experience - Populate the Events Table - Vantage Customer Experience

Vantage Customer Experience Path Analysis Tutorial

Product
Vantage Customer Experience
Release Number
1.5
Published
June 2022
Language
English (United States)
Last Update
2022-07-07
dita:mapPath
vkt1594411615815.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
vkt1594411615815
Product Category
Teradata Applications

This tutorial uses an Events (TUTORIAL_CUSTOMER_EVENTS) from three datasets. You've already downloaded the sample data and added the tables to your database.

In this section, Vantage CX combines the data from the different sources into a single Events table. This is useful when your customer data comes from multiple sources.

If coding this by hand, you would need the following INSERT statements to map the correct columns from each of the source tables and manually build the Events table:
-- Insert Web event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT web_cust_id as entity_id, page_ts as datestamp, web_page as event
FROM TUTORIAL_WEB;

-- Insert Transaction event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT account_id as entity_id, tran_ds as datestamp, tran_cd as event
FROM TUTORIAL_TRANS;

-- Insert Support event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT customer_id as entity_id, ticket_ds as datestamp, issue_cd as event
FROM TUTORIAL_SUPPORT;
You previously created these tables as part of Creating the Tables.

With Vantage CX customer lists and data sources, you can accomplish this without coding, and then automate the process to make sure you always have current data from each source.