Section 1 : Introduction
Lecture 1 Download the Files
Lecture 2 Introduction to the case study 00:04:51 Duration

Section 2 : Web, Social Media, & Digital Advertising Analytics
Lecture 1 Web Analytics Traffic sources 00:04:15 Duration
Lecture 2 Web Analytics Time spent on site 00:03:01 Duration
Lecture 3 Web Analytics BounceAbandonment rate 00:04:33 Duration
Lecture 4 Introducing the case study data 00:03:02 Duration
Lecture 5 Social Media Analytics FollowersLikes 00:02:36 Duration
Lecture 6 Social Media Analytics Engagement 00:03:41 Duration
Lecture 7 Social Media Analytics Key takeaways
Lecture 8 Digital Ad Analytics Impressions and reach
Lecture 9 Digital Ad Analytics Click-through-rate (CTR) 00:02:18 Duration
Lecture 10 Digital Ad Analytics Cost-per-click (CPC) 00:03:06 Duration
Lecture 11 Digital Ad AnalyticsCost-per-lead & Key takeaways 00:05:39 Duration

Section 3 : Applying our Analytics
Lecture 1 Campaign Cost & # of Impressions 00:05:24 Duration
Lecture 2 Calculating CPC & Lead conversion 00:04:23 Duration
Lecture 3 Asking more questions of our data 00:05:17 Duration
Lecture 4 Analyzing our data by ad pt 00:06:11 Duration
Lecture 5 Analyzing our data by ad pt
Lecture 6 Calculating Cost-per-lead 00:08:59 Duration

Section 4 : Customer Analytics
Lecture 1 Customer Analytics Customer acquisition cost 00:03:51 Duration
Lecture 2 Customer Analytics Customer lifetime value 00:05:46 Duration
Lecture 3 Customer Analytics Customer lifetime value example 00:02:43 Duration
Lecture 4 Customer Analytics Net promoter score 00:04:57 Duration
Lecture 5 Customer Analytics Key takeaways 00:02:53 Duration

Section 5 : Applying our Analytics pt
Lecture 1 Introduction to our new data 00:06:19 Duration
Lecture 2 Calculating the # of new customers 00:05:54 Duration
Lecture 3 Calculating average customer age & Days to convert 00:08:09 Duration
Lecture 4 Calculating customer acquisition cost & Average purchases 00:03:58 Duration
Lecture 5 Adding fields to our data 00:07:01 Duration
Lecture 6 Calculating touch points & Lead conversion 00:03:47 Duration
Lecture 7 Building a PivotChart with Slicers 00:08:57 Duration
Lecture 8 Analyzing age demographics 00:07:26 Duration
Lecture 9 Creating a PivotTable with a calculated field 00:06:48 Duration
Lecture 10 Calculating net promoter score 00:04:21 Duration
Lecture 11 First contact with customer 00:08:51 Duration
Lecture 12 Customer satisfaction 00:06:21 Duration
Lecture 13 Understanding customer engagement 00:03:51 Duration
Lecture 14 Calculating customer lifetime value 00:06:06 Duration

Section 6 : Modeling Out a New Marketing Initiative
Lecture 1 Our Recommendation 00:04:57 Duration
Lecture 2 Introduction to modeling 00:04:19 Duration
Lecture 3 Evaluating new ad channels 00:05:21 Duration
Lecture 4 Calculating customer lifetime value 00:05:26 Duration
Lecture 5 Modeling tips and best practices 00:05:00 Duration
Lecture 6 Inputting our assumptions pt 00:04:45 Duration
Lecture 7 Inputting our assumptions pt 00:05:45 Duration
Lecture 8 Inputting our assumptions pt 00:05:00 Duration
Lecture 9 Projecting ad revenue pt 00:04:20 Duration
Lecture 10 Projecting ad revenue pt 00:08:07 Duration
Lecture 11 Projecting organic follower revenue 00:04:51 Duration
Lecture 12 Projecting expenses 00:05:46 Duration
Lecture 13 Calculating net profit and breakeven 00:02:27 Duration
Lecture 14 Understanding ROI
Lecture 15 Calculating our returns 00:04:39 Duration
Lecture 16 Creating a single-variable sensitivity table 00:05:11 Duration
Lecture 17 Creating a multi-variable sensitivity table 00:06:22 Duration

Section 7 : Introduction to Dynamic Dashboards
Lecture 1 Presenting key performance indicators (KPIs) 00:06:12 Duration
Lecture 2 Creating spin buttons
Lecture 3 Making our dashboard dynamic 00:05:36 Duration
Lecture 4 Creating various charts and graphs 00:05:40 Duration