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.