Summary
A final dataset will now be created, which will be used later for data visualization and analysis in Tableau. This dataset will merge the activities from DCM with activities from Pardot, where activity attributes are aligned. The resulting dataset table name will be program_activity_history. The resulting dataset schema will contain:
| Colum | Data Type |
|---|---|
| Prospect_ID | INTEGER |
| Activity_Date | TIMESTAMP |
| Activity_Type | STRING |
| Activity_Sub_Type | STRING |
| Program | STRING |
| Campaign | STRING |
All work should be performed in the BigQuery web-based console.