Welcome back! In our previous lesson, we defined the essential language of marketing analytics by introducing six Key Performance Indicators (KPIs). We established that these metrics are the vital signs for any digital marketing campaign.
Today, we're moving from theory to practice. You'll learn how to calculate the three most critical KPIs for measuring profitability and business health: Return on Ad Spend (ROAS), Customer Acquisition Cost (CAC), and Customer Lifetime Value (LTV). This is a hands-on session where you'll work with sample data in a spreadsheet, a core skill for any entry-level digital marketer. By the end of this lesson, you will be able to take raw business numbers and transform them into the actionable insights that drive strategic decisions.
Your Marketing Math Toolkit
To get started, we'll use a fantastic article from Podia that not only explains the formulas but also provides a free Google Sheets template. This will be our primary tool for today's lesson.
4 must-have marketing math formulas for small businesses - Podia
This article will be our guide. Before we dive in, please open the article and download the spreadsheet template it provides.
Read the short introduction and find the link to download the template. Please make a copy for yourself in your own Google Drive. Having this open will allow you to follow the calculations practically.
1. Calculating Return on Ad Spend (ROAS)
Let's begin with the most direct measure of an advertising campaign's success: ROAS. It answers a simple, vital question: "For every dollar we put into ads, how many dollars in revenue did we get back?"
The formula is straightforward:
Now, let's see how this works in practice using the Podia guide and the spreadsheet you just opened.
4 must-have marketing math formulas for small businesses - Podia
This section of the Podia article provides a clear definition and a practical example for calculating ROAS.
Navigate to the section on ROI and ROAS. Focus on the ROAS definition and the example provided: spending $20 on a Facebook ad campaign that generates $1800 in revenue. Follow along and input these numbers into the 'ROAS' tab of your spreadsheet to see the 9000% (or 90x) ROAS calculated for you.
A ROAS of 90x is exceptionally high. In the real world, what's considered "good" depends heavily on a company's profit margins. A useful concept here is the break-even ROAS, which is the point where you're making back exactly what you spent on the ads plus the cost of the product or service itself. The formula is:
For example, if a company has a 40% profit margin on its products, its break-even ROAS is . This means they need to generate at least $2.50 in revenue for every $1 spent on ads just to cover costs and break even. Anything above that is profit.
2. Calculating Customer Acquisition Cost (CAC)
While ROAS is excellent for judging a specific ad campaign, CAC gives you a more holistic view. It calculates the total average cost to acquire a brand new customer, factoring in all your marketing and sales efforts, not just ad spend.
The formula is:
\text{CAC} = \frac{\text{Total Sales & Marketing Costs}}{\text{Number of New Customers Acquired}}"Total Sales & Marketing Costs" can include ad spend, salaries of the marketing team, software subscriptions (e.g., for email marketing), and agency fees.
Let's use our guide to calculate this.
4 must-have marketing math formulas for small businesses - Podia
This next section of the Podia article explains CAC and distinguishes it from campaign-specific costs.
Please read the section on calculating CAC. Follow the example of spending $2,000 to get 30 new community members. Find the 'CAC' tab in your spreadsheet and enter these numbers to see the CAC of ~$67 calculated.
Understanding your CAC is fundamental. If it costs you $67 to get a new customer, you need to be sure that customer will eventually spend more than $67 with your business. This brings us to our next, and most important, metric.
3. Calculating Customer Lifetime Value (LTV)
Customer Lifetime Value (LTV or CLV) is a projection of the total profit your business can expect to earn from a single customer over the entire duration of their relationship with you. It’s arguably the most important metric for long-term, sustainable growth.
Calculating LTV can get complex, but we can use a simple, powerful model.
4 must-have marketing math formulas for small businesses - Podia
The Podia guide breaks down the LTV calculation into manageable parts.
Now, read the section on calculating LTV. Pay close attention to the components needed: Average purchase value Average purchase frequency Average customer lifespan Follow the membership example in the article and use the 'LTV' tab in your spreadsheet to see how these inputs result in an LTV of $720.
To help you visualize how a customer's value accumulates over time, let's watch a video that breaks this down. The first part explains the formula, and the second part shows a month-by-month "cohort" analysis, which makes the concept very clear.
How to Calculate Customer Lifetime Value | The #1 Most Important Metric for Startups
This video by Eric Andrews gives an excellent visual breakdown of the LTV calculation in a spreadsheet.
First, watch the section that walks through the simplified formula for LTV. Then, watch the next section which provides a visual breakdown showing how a customer's value accumulates over their lifetime as churn is accounted for. This will help you understand why the formula works.
The Golden Ratio: LTV to CAC
Knowing LTV and CAC individually is important, but the magic happens when you compare them. The LTV:CAC ratio is the ultimate indicator of a healthy, sustainable business model.
A common benchmark suggests an ideal LTV:CAC ratio is 3:1 or higher.
- 1:1 Ratio: You're losing money, because you're only making back the money you spent to acquire the customer, with no room for other business costs or profit.
- 3:1 Ratio: This is considered a healthy target. For every dollar you spend to acquire a customer, you're getting three dollars back in lifetime profit. This signals efficient marketing and a profitable business.
- 5:1+ Ratio: While this looks great, it might actually mean you're not investing enough in marketing and could be growing even faster.
The Podia article and spreadsheet you've been using automatically calculate this ratio for you based on your LTV and CAC inputs. In a real-world company, these calculations can become quite detailed, incorporating many more variables.
Conclusion
Congratulations! You've gone from defining KPIs to calculating them—a major step toward becoming a data-driven marketer. You now have the practical ability to measure the profitability of campaigns and the long-term health of a business.
Key Takeaways:
- ROAS (
Revenue / Ad Spend) gives you a quick read on the profitability of a specific ad campaign. - CAC (
Total Spend / New Customers) provides a holistic view of what it costs to acquire a customer across all your efforts. - LTV predicts the total profit a customer will generate over their lifetime, guiding your acquisition spending.
- The LTV:CAC ratio is the "golden ratio" that indicates the sustainability of your marketing efforts and business model, with a 3:1 ratio being a healthy benchmark.
In our next lesson, we will put all the foundational pieces from this module together. You will draft a one-page digital marketing strategy, defining your goals, audience, channels, budget, and—most importantly—the KPIs you just learned to calculate.