Step 7 - Create Event Stream from the previous steps

Here we combine the three previously created tables from activity, impressions and clicks into one single table to explore the user journey

NOTE: Ensure you copy the #standardSQL a the top of the query so that it ensures the correct engine is used

 #standardSQL
SELECT
  *
FROM
  `mrkl-workshop-dev.[your-dataset-name].dcm_click_known_users` UNION ALL
SELECT
  *
FROM
  `mrkl-workshop-dev.[your-dataset-name].dcm_impressions_known_users` UNION ALL
SELECT
  *
FROM
  `mrkl-workshop-dev.[your-dataset-name].dcm_activities_known_users`

Resulting Table: Using the “Save as Table” button in the query results pane, create:

Dataset: [your-dataset-name]

Table ID: dcm_activity_history