Course Highlights
  • Learn the most important marketing metrics and how to apply them to your data
  • Analyze a company's PPC marketing campaign using key metrics
  • Know how to ask the right questions from your data
  • Build a marketing initiative forecast model from the ground up
  • Build a dynamic dashboard to summarize your analysis
Curriculum

2 Topics
Download the Files
Introduction to the case study

11 Topics
Web Analytics: Traffic sources
Web Analytics: Time spent on site
Web Analytics: Bounce/Abandonment rate
Introducing the case study data
Social Media Analytics: Followers/Likes
Social Media Analytics: Engagement
Social Media Analytics: Key takeaways
Digital Ad Analytics: Impressions and reach
Digital Ad Analytics: Click-through-rate (CTR)
Digital Ad Analytics: Cost-per-click (CPC)
Digital Ad Analytics:Cost-per-lead & Key takeaways

6 Topics
Campaign Cost & # of Impressions
Calculating CPC & Lead conversion
Asking more questions of our data
Analyzing our data by ad pt. I
Analyzing our data by ad pt. II
Calculating Cost-per-lead

5 Topics
Customer Analytics: Customer acquisition cost
Customer Analytics: Customer lifetime value
Customer Analytics: Customer lifetime value example
Customer Analytics: Net promoter score
Customer Analytics: Key takeaways

14 Topics
Introduction to our new data
Calculating the # of new customers
Calculating average customer age & Days to convert
Calculating customer acquisition cost & Average purchases
Adding fields to our data
Calculating touch points & Lead conversion
Building a PivotChart with Slicers
Analyzing age demographics
Creating a PivotTable with a calculated field
Calculating net promoter score
First contact with customer
Customer satisfaction
Understanding customer engagement
Calculating customer lifetime value

17 Topics
Our Recommendation
Introduction to modeling
Evaluating new ad channels
Calculating customer lifetime value
Modeling tips and best practices
Inputting our assumptions pt. I
Inputting our assumptions pt. II
Inputting our assumptions pt. III
Projecting ad revenue pt. I
Projecting ad revenue pt. II
Projecting organic follower revenue
Projecting expenses
Calculating net profit and breakeven
Understanding ROI
Calculating our returns
Creating a single-variable sensitivity table
Creating a multi-variable sensitivity table

4 Topics
Presenting key performance indicators (KPIs)
Creating spin buttons
Making our dashboard dynamic
Creating various charts and graphs

  Write a Review

Marketing Analytics: Stand Out by Becoming an Analytics Pro!

Go to Paid Course