Excel Training for Marketers - Building an LTV to CAC model and understanding marketing ROAS and CAC by channel.
What you'll learn
How to build an LTV to CAC model and cohort analysis in excel
Everything you need to know about Customer Lifetime Value and Customer Acquisition Cost
Get a seat at the table - Learn how to talk to investors, your board, and your CEO about the things they care more about
All the excel formulas you need to know to build your LTV to CAC model and CAC by channel
Requirements
Basic excel skills and an intermediate understanding of business and marketing terminology
Description
This course is designed for aspiring marketing leaders who want a seat at the leadership table. The most important skill I've developed over my 15 year career is data analysis and excel. You obviously need creativity and problem solving ability to become a CMO and lead a marketing organization, but not having the analytical chops and skillset will hold you back. This skill has helped me climb to CMO and SVP roles at growing startups and has given me credibility in speaking with board members and our CEO. This course will walk you through how to build your own LTV and CAC model and how to think strategically about these KPIs for driving business strategy.Building an LTV to CAC model requires you have a deep understanding of business. You'll need to understand how to think about LTV and CAC, but also cohort analysis. Once you understand these fundamental concepts, you will need to know how to build a model that you can use for your business. If you work in startups, you'll likely need to be able to build this on your own. As companies grow, you'll have analysts and financial resources, but it's important that you understand these fundamentals yourself and not simply rely on other resources.
Overview
Section 1: Introduction
Lecture 1 LTV & CAC Overview
Lecture 2 Q&A from other marketers
Section 2: Excel formulas you need to know
Lecture 3 Excel formulas
Section 3: Building the LTV to CAC model
Lecture 4 Building your LTV to CAC in excel
Section 4: Thank You!
Lecture 5 Thank you
Marketing managers, directors, or hungry associates looking to advance in their marketing careers
Screenshots