Introduction
  • Download the Files
  • Introduction to the case study
Web, Social Media, & Digital Advertising Analytics
  • 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
Applying our Analytics
  • 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
Customer Analytics
  • 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
Applying our Analytics pt. II
  • 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
Modeling Out a New Marketing Initiative
  • 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
Introduction to Dynamic Dashboards
  • Presenting key performance indicators (KPIs)
  • Creating spin buttons
  • Making our dashboard dynamic
  • Creating various charts and graphs