What you'll be able to do by the end of this guide: Understand exactly where your money is going, how long customers stick around, and whether your business is actually healthy—without hiring a data analyst. You'll build a simple no-code metrics dashboard that gives you the three numbers that matter most for any early-stage business: Customer Acquisition Cost (CAC), Lifetime Value (LTV), and Churn Rate.

What you need to get started:

  • A Google account (Google Sheets is free)
  • Your ad spend data (export from Facebook Ads or Google Ads)
  • Your payment records (export from Stripe or PayPal)
  • A customer list (even a simple spreadsheet of who signed up and who left)

No coding skills required. I'll show you exactly which buttons to click and what formulas to paste.

Why Vanity Metrics Are Stealing Your Focus

Every founder I talk to under $2M in revenue is obsessed with a number that looks impressive but tells them almost nothing. It might be website traffic, social media followers, or even total revenue. These are vanity metrics vs real metrics—they feel good but don't predict survival.

Consider this concrete example: A friend of mine runs a subscription box for pet owners. She spent three months celebrating 10,000 Instagram followers and a 50% increase in monthly visitors. But when she finally looked at her bank account, she was bleeding cash. Why? Her Customer Acquisition Cost was $80, but her average customer only paid $25 total before canceling. She was losing $55 on every new signup.

That's the danger of vanity metrics: revenue can go up while your business slowly drowns. The metrics that actually matter for sustainable growth are CAC, LTV, and Churn Rate. Together they tell you:

  • Are you spending too much to get each customer?
  • Do those customers stick around long enough to pay back your investment?
  • How fast are you losing the customers you worked so hard to get?

And the best part? You don't need a data team. You just need a spreadsheet and three formulas. Let's build them.

Metric #1: Customer Acquisition Cost (CAC)

CAC answers the question: "How much does it cost me to convince someone to become a paying customer?" The formula is dead simple:

CAC = Total sales & marketing spend ÷ New customers acquired

Let's make it real. Imagine you spent $2,000 on Facebook ads last month. You also pay a part-time VA $500 to manage the ads. That's $2,500 total spend. In that same month, you gained 20 new customers. Your CAC is $125.

Here's how you calculate customer acquisition cost step by step in Google Sheets:

  1. Open a new sheet and label column A "Month", column B "Marketing Spend", column C "New Customers".
  2. Enter your data for each month (e.g., January: $2,500 spend, 20 customers).
  3. In column D, enter the formula: =B2/C2 and drag it down.
  4. That's it. You now have CAC for each month.

Where most people get stuck: They include salaries of people who don't actually do sales or marketing. Be honest. Only include costs directly tied to acquiring customers—ads, tools (like HubSpot or Mailchimp), and dedicated sales people. For a small founder, your own time counts if you're the one doing the selling.

As you grow, manually entering ad spend each month becomes a pain. That's where no-code automation comes in. Tools like Zapier or Make can connect your ad platforms (Google Ads, Facebook) directly to your Google Sheet. Every time a new lead comes in or an ad spend report updates, the sheet refreshes automatically. No copy-pasting required. If you want to go deeper on building a full metrics pipeline, check out my guide on how to centralize your startup metrics.

Metric #2: Lifetime Value (LTV)

LTV answers: "How much total revenue will the average customer generate over their entire relationship with my business?" The simplest calculation for a subscription business is:

LTV = Average monthly revenue per customer × Average number of months a customer stays

Let's use the same pet subscription example. The average customer pays $25/month. On average, they stay for 6 months before canceling. That means LTV = $150.

Now compare that to the CAC of $125. In this case, LTV ($150) is only slightly higher than CAC ($125). That's a red flag—you're barely breaking even on each customer. A healthy ratio is usually 3:1 or higher (LTV at least 3× CAC).

To calculate customer lifetime value manually in Google Sheets:

  1. Export your payment data from Stripe or PayPal as a CSV.
  2. Create a new tab called "LTV".
  3. List each customer and their total payments to date (if you're early stage, assume the past equals the future).
  4. Use the =AVERAGE() formula on the total payments column to get your current average LTV.

If you want a more dynamic view, use Airtable—it's like a smarter spreadsheet. You can link your Stripe subscription data to Airtable and let it automatically compute LTV as payments come in. For a step-by-step on building a full no-code dashboard for this, see my tutorial on building an AI-powered BI dashboard. It's all about connecting the right tools without writing a single line of code.

Pro tip: Don't guess the average lifetime. If you've only been in business a few months, use your early churn data to estimate. More on that next.

Metric #3: Churn Rate

Churn Rate is the percentage of customers you lose in a given period. It's the single most dangerous metric for a subscription business because it erodes everything you build.

Churn Rate = Customers lost in a period ÷ Customers at the start of that period

Example: You start the month with 100 customers. During the month, 5 customers cancel. Your monthly churn is 5%.

Here's how to calculate churn rate in Google Sheets:

  1. Create a tab called "Churn".
  2. Column A: Month, Column B: Customers at Start, Column C: Customers Lost.
  3. In column D, enter =C2/B2 and format as percentage.
  4. Track this every single month.

Why this matters more than revenue: A high churn means you're on a treadmill—running faster just to stay in place. If your monthly churn is 10%, you lose more than half your customers every 7 months. No amount of customer acquisition can fix a leaky bucket.

You can automate churn tracking using n8n (a free no-code workflow tool). Set up a workflow that watches Stripe for cancellation events, then updates your churn sheet and sends you a Slack alert. That way you never miss a trend. For more ways to automate these workflows, read about 3 no-code human-in-the-loop workflows.

Putting It All Together: A Simple No-Code Dashboard

Now you have three separate sheets. Let's combine them into a single no-code metrics dashboard.

  1. Create a master Google Sheet with three tabs: CAC, LTV, Churn.
  2. On each tab, enter your monthly data following the formulas above.
  3. Add a fourth tab called Dashboard.
  4. Use simple formulas to pull the latest numbers from each tab. For example: =CAC!D2 will grab the most recent CAC.
  5. Create charts: a line chart for CAC over time, another line chart for LTV, and a bar chart for churn.
  6. Set your sheet to auto-update by connecting it to Google Data Studio (now Looker Studio, still free). Data Studio can link directly to your sheet and give you a live, shareable dashboard.

That's it. In under an hour, you have a real business dashboard that tells you exactly what's working and what's not—no code, no expensive tools.

Scaling with Automation: How Nova Pixel Can Help

Manual tracking works beautifully when you're under $2M. But as you cross that threshold, the data sources multiply—email campaigns, CRM touches, affiliate payouts, support tickets. Your spreadsheet becomes a second job.

That's where dedicated automation comes in. Nova Pixel builds custom no-code systems that do the data collection for you. Instead of exporting Stripe, HubSpot, and Google Analytics into separate tabs, we connect them all into a single live dashboard using tools like Make or n8n—without any code.

Here's what that looks like in practice:

  • A workflow that pulls new Stripe charges into your LTV sheet automatically.
  • Another workflow that monitors your ad platforms and updates CAC every time a campaign ends.
  • An alert that pings you in Slack whenever churn spikes above 8% in a week.

You can even set up a human-in-the-loop flow: when a high-value customer cancels, the system notifies you instantly so you can intervene personally. No coding needed—just configuration.

If you're ready to move beyond spreadsheets, check out how Nova Pixel's services can automate business metrics for your exact stack. We also have a guide on top AI productivity tools for founders that includes more automation ideas tailored for lean teams.

Common Pitfalls and Next Steps

Even with the right metrics, founders make mistakes. Here are common metrics mistakes early stage that can derail you:

  1. Mixing time periods. Don't compare weekly CAC to monthly churn. Keep everything on the same calendar (monthly is best for early stage).
  2. Ignoring cohort analysis. A single churn rate hides the truth. New customers might churn at 20% while old ones churn at 2%. Track groups by acquisition month or channel.
  3. Over-optimizing too early. Don't try to fix CAC, LTV, and churn simultaneously. Pick the one that hurts most (usually churn) and focus on that for 90 days.

Your immediate next steps:

  • Spend 30 minutes this week setting up the three-tab Google Sheet I described.
  • Populate it with the last three months of data (even rough estimates).
  • Schedule a 15-minute weekly review to look at trends, not absolute numbers.
  • Pick one automation to try—maybe connecting your ad spend to the sheet via Zapier.

You don't need a data team. You just need three numbers, a spreadsheet, and the discipline to look at them every week. Once you have that foundation, you can scale with confidence—and without guesswork.

Cover photo by Pachon in Motion on Pexels.