Ltv To Cac For Marketers

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