Marketing Analytics in Spreadsheets
Learn how to ensure clean data entry and build dynamic dashboards to display your marketing data.
Spreadsheets are an essential tool for any marketing professional, but how does one keep these spreadsheets clean and accurate – especially when multiple parties contribute data? Data validation and regular expressions are powerful tools for marketing analysts, but having clean data is only half the battle. After we learn how to clean the data, we will visualize it by building charts! Throughout the course, we will explore a dataset that includes the kind of information you will encounter in the world of digital marketing. We will spot errors in metrics using data validation, use regular expressions to aggregate campaign metrics, build charts to analyze campaign performance, and use everything we’ve learned to build a dynamic dashboard!
Instructor: Luke Pajer