Section 1 : Introduction

Lecture 1 Download the Files Text
Lecture 2 Introduction to the case study 4:51

Section 2 : Web, Social Media, & Digital Advertising Analytics

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

Section 3 : Applying our Analytics

Lecture 14 Campaign Cost & # of Impressions 5:24
Lecture 15 Calculating CPC & Lead conversion 4:23
Lecture 16 Asking more questions of our data 5:17
Lecture 17 Analyzing our data by ad pt 6:11
Lecture 18 Analyzing our data by ad pt
Lecture 19 Calculating Cost-per-lead 8:59

Section 4 : Customer Analytics

Lecture 20 Customer Analytics Customer acquisition cost 3:51
Lecture 21 Customer Analytics Customer lifetime value 5:46
Lecture 22 Customer Analytics Customer lifetime value example 2:43
Lecture 23 Customer Analytics Net promoter score 4:57
Lecture 24 Customer Analytics Key takeaways 2:53

Section 5 : Applying our Analytics pt

Lecture 25 Introduction to our new data 6:19
Lecture 26 Calculating the # of new customers 5:54
Lecture 27 Calculating average customer age & Days to convert 8:9
Lecture 28 Calculating customer acquisition cost & Average purchases 3:58
Lecture 29 Adding fields to our data 7:1
Lecture 30 Calculating touch points & Lead conversion 3:47
Lecture 31 Building a PivotChart with Slicers 8:57
Lecture 32 Analyzing age demographics 7:26
Lecture 33 Creating a PivotTable with a calculated field 6:48
Lecture 34 Calculating net promoter score 4:21
Lecture 35 First contact with customer 8:51
Lecture 36 Customer satisfaction 6:21
Lecture 37 Understanding customer engagement 3:51
Lecture 38 Calculating customer lifetime value 6:6

Section 6 : Modeling Out a New Marketing Initiative

Lecture 39 Our Recommendation 4:57
Lecture 40 Introduction to modeling 4:19
Lecture 41 Evaluating new ad channels 5:21
Lecture 42 Calculating customer lifetime value 5:26
Lecture 43 Modeling tips and best practices 5:0
Lecture 44 Inputting our assumptions pt 4:45
Lecture 45 Inputting our assumptions pt 5:45
Lecture 46 Inputting our assumptions pt 5:0
Lecture 47 Projecting ad revenue pt 4:20
Lecture 48 Projecting ad revenue pt 8:7
Lecture 49 Projecting organic follower revenue 4:51
Lecture 50 Projecting expenses 5:46
Lecture 51 Calculating net profit and breakeven 2:27
Lecture 52 Understanding ROI
Lecture 53 Calculating our returns 4:39
Lecture 54 Creating a single-variable sensitivity table 5:11
Lecture 55 Creating a multi-variable sensitivity table 6:22

Section 7 : Introduction to Dynamic Dashboards

Lecture 56 Presenting key performance indicators (KPIs) 6:12
Lecture 57 Creating spin buttons
Lecture 58 Making our dashboard dynamic 5:36
Lecture 59 Creating various charts and graphs 5:40