WebsitePerformance_DCM_SQL

Google BigQuery SQL on DCM data

The purpose of this project was to understand how users that come from advertising channels interact with the website - leveraging DCM data.

Goal

This analysis aimed to breakdown efficieny of different media channels in driving desired CTA on the website and get further insight into user behavior on site to glean insights on consumer journey funnel.

Analysis Tools and Technology

Google BigQuery, MySQL ,Redshift used for the purposes of data analysis, visualized on Tableau.