Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 5 hours on-demand video
  • 1 article
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Marketing Marketing Analytics & Automation Marketing Strategy

Marketing Analytics: Stand Out by Becoming an Analytics Pro!

Marketing requires a new, analytical breed of professionals. Be at the forefront of your profession.
Bestseller
Rating: 4.4 out of 54.4 (1,968 ratings)
8,762 students
Created by Nate @ Wisdify
Last updated 4/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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
Curated for the Udemy for Business collection

Requirements

  • You should have a beginner/intermediate knowledge of Excel including SUMIFS and COUNTIFS
  • NO background in statistics required

Description

In this big data age, knowing how to organize, synthesize, and analyze large quantities of marketing data is no longer an "good-to-have" skill. It is absolutely essential! Are you a student looking to set yourself apart from your peers? Are you looking to break into social media marketing? Do you want to become an expert in marketing analytics? If so, then this course is for you! 

In this course, we'll teach you everything you need to know to become an expert in marketing analytics. No prior experience in social media marketing, statistics, or marketing required!

Our course is based on the hands-on, case-study method to learning. In other words, we'll learn by analyzing the data in a real-life scenario. The course begins with an introduction to big data, data analytics, and marketing analytics. This will allow you to feel comfortable with these terms.

Afterwards, we move on to learning the most important web, social media, digital advertising, customer, and revenue metrics in marketing. As we learn each new metric, we'll immediately apply it to the real-life case study.

We cap off the course by teaching you how to properly model out a new marketing initiative. This model will project out a campaign's revenue and expenses for 2 years and will be complete with scenario and sensitivity analyses. We then conclude by summarizing our data in a beautiful, dynamic dashboard.

We are excited to have you join us on this journey and look forward to seeing you in the course!

Who this course is for:

  • Social media professionals
  • Marketing students
  • Digital advertisers
  • Marketing professsionals

Course content

7 sections • 59 lectures • 4h 56m total length

  • Download the Files
    00:11
  • Preview04:50

  • Preview04:15
  • Web Analytics: Time spent on site
    03:00
  • Web Analytics: Bounce/Abandonment rate
    04:33
  • Introducing the case study data
    03:02
  • Preview02:36
  • Social Media Analytics: Engagement
    03:41
  • Social Media Analytics: Key takeaways
    03:15
  • Digital Ad Analytics: Impressions and reach
    04:22
  • Digital Ad Analytics: Click-through-rate (CTR)
    02:18
  • Digital Ad Analytics: Cost-per-click (CPC)
    03:06
  • Digital Ad Analytics:Cost-per-lead & Key takeaways
    05:39

  • Campaign Cost & # of Impressions
    05:23
  • Calculating CPC & Lead conversion
    04:23
  • Asking more questions of our data
    05:17
  • Analyzing our data by ad pt. I
    06:11
  • Analyzing our data by ad pt. II
    03:03
  • Calculating Cost-per-lead
    08:58

  • Customer Analytics: Customer acquisition cost
    03:50
  • Customer Analytics: Customer lifetime value
    05:46
  • Customer Analytics: Customer lifetime value example
    02:43
  • Customer Analytics: Net promoter score
    04:57
  • Customer Analytics: Key takeaways
    02:53

  • Introduction to our new data
    06:19
  • Calculating the # of new customers
    05:54
  • Calculating average customer age & Days to convert
    08:09
  • Calculating customer acquisition cost & Average purchases
    03:57
  • Adding fields to our data
    07:01
  • Calculating touch points & Lead conversion
    03:47
  • Building a PivotChart with Slicers
    08:57
  • Analyzing age demographics
    07:26
  • Creating a PivotTable with a calculated field
    06:47
  • Calculating net promoter score
    04:21
  • First contact with customer
    08:50
  • Customer satisfaction
    06:21
  • Understanding customer engagement
    03:51
  • Calculating customer lifetime value
    06:06

  • Our Recommendation
    04:57
  • Introduction to modeling
    04:18
  • Evaluating new ad channels
    05:21
  • Calculating customer lifetime value
    05:25
  • Modeling tips and best practices
    05:00
  • Inputting our assumptions pt. I
    04:44
  • Inputting our assumptions pt. II
    05:44
  • Inputting our assumptions pt. III
    05:00
  • Projecting ad revenue pt. I
    04:19
  • Projecting ad revenue pt. II
    08:07
  • Projecting organic follower revenue
    04:51
  • Projecting expenses
    05:46
  • Calculating net profit and breakeven
    02:26
  • Understanding ROI
    04:51
  • Calculating our returns
    04:38
  • Creating a single-variable sensitivity table
    05:11
  • Creating a multi-variable sensitivity table
    06:22

  • Presenting key performance indicators (KPIs)
    06:12
  • Creating spin buttons
    06:15
  • Making our dashboard dynamic
    05:35
  • Creating various charts and graphs
    05:39

Instructor

Nate @ Wisdify
Co-Founder & Lead Instructor @ Wisdify
Nate @ Wisdify
  • 4.5 Instructor Rating
  • 3,109 Reviews
  • 12,640 Students
  • 11 Courses

Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally.

Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable.

Our courses include: SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more!

To receive CPE credit, you must complete the final exam on our website.


About the instructor:

Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate.

Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) .

Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young.

Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.