A digital marketing report generated for Codecademy, using a dataset provided by Codecademy. Data analysis, and visualizations were completed in Excel.
- Cleaned and analyzed ROI of over ~150 rows of digital marketing campaign data targeting Codecademy pro and basic subscribers across Google AdWords, Facebook Ads, and affiliate networks by looking at CPM, click-Through Rate, Cost per Click, Conversion Rate, and Cost per Conversion
- Used Excel Pivot Tables and Graphs to create simple visualizations of campaign channel ROI to drive decision making; suggested removal of underperforming channels and increased spend on high-conversion channels
Please fill out this form in order to gain access to project files.