
Learn the basics of LTV and CAC, and how to think about these important metrics strategically to grow your business. As an aspiring marketing leader, the more equipped you are to have these conversations with your CEO or investors, the more likely you'll get yourself a seat at the table.
This section will go over some basic excel formulas that can get you almost everything you need. Formulas we go over include:
Countifs
Sumifs
Vlookup
If function
Text
I added practice sheets for your try out at the end. The file that ends in "Answers" is filled in. The other one is the blank one for you to practice.
I will walk you through how to build out an LTV and CAC model, broken out by monthly cohorts and by channel.
At the end, I've attached two spreadsheets. The one ending in Practice Sheet is the one where you can go in and practice. The other file is the final answers with all the formulas filled in.
Good luck!
The survey is located on Google Forms here - https://forms.gle/c68DxwopEcr1PDUy8
Thank you again!
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.