How we Measure

Ensure that you can track each important metric

1. Goal - Setting up tracking systems

How we Measure Template

What You've Already Built

In the What we Measure lesson, you defined the metrics that matter for your customer journey–specific, actionable metrics for each funnel stage (ToFu, MoFu, BoFu, GroFu). Now it's time to set up systems that actually capture this data so you can measure what's happening.

What You're Deciding Here

This lesson helps you make a critical strategic decision: Which tracking approach should you use? There are four main approaches, each with different strengths:

Spreadsheets (Manual Tracking)
Best for: Getting started quickly, tracking difficult metrics, small businesses, metrics that don't auto-track. Simple, flexible, and you control everything. Perfect when you need to track things like "calls booked" or "partnerships formed" that don't automatically flow into tools.

Tracking Tools (Automated Web Tracking)
Best for: Website metrics, ad performance, content engagement, scale. Tools like Google Analytics automatically capture visitor behavior, page views, conversions, and more. Set it up once, and it tracks continuously.

CRM Events (Customer Journey Tracking)
Best for: Tracking the complete customer journey, connecting marketing to sales, understanding lead quality. Your CRM becomes the single source of truth, tracking every interaction from first touchpoint to loyal customer.

Product Database (Direct Database Tracking)
Best for: Developers and vibe coders who want to work with the ultimate source of truth–user activity in your product database. No external systems needed. Track user behavior, feature usage, conversions, and product metrics directly where your data lives. Perfect when you want full control and don't want to depend on external tracking tools.

What Should You Focus On First?

Your starting point depends on your current situation:

If You're Just Getting Started
Start with spreadsheets. They're free, flexible, and help you understand what metrics matter before investing in tools. Track your most important 5-7 metrics manually for 1-2 months. Once you see the value, add automated tracking.

If You Have a Website and Run Ads
Add tracking tools (Google Analytics, Meta Pixel, etc.) immediately. These capture data automatically and give you insights you can't get manually. Set up basic tracking first, then add more advanced features.

If You Have a CRM
Set up CRM events to track your complete customer journey. Connect your marketing touchpoints (website, emails, ads) to your CRM so you can see how leads move through your funnel. This is especially powerful for high-touch funnels.

Most Businesses Use Multiple Approaches
Use spreadsheets for metrics that don't auto-track, tracking tools for website/ad data, CRM events for the complete customer journey, and product database tracking for user behavior in your product. They work together to give you a complete picture.

Your Decision

By the end of this lesson, you'll have set up the right tracking approach for your business–whether that's simple spreadsheets to get started, automated tools for scale, or CRM integration for comprehensive tracking.

Determine your tracking approach and tools
I'm working through the How we Measure lesson and need to decide which tracking approach to use.
You have access to my Strategy document, Story Framework document, Funnel Overview document, and Metrics document in this project.
Before making any recommendations, please ask me these questions and wait for my answers:
1.**What's your current tracking setup?**
- Do you use any tracking tools? (Google Analytics, CRM, spreadsheets, etc.)
- What's working? What's missing or difficult?
- How much time do you spend tracking metrics manually?
2.**What's your business situation?**
- Do you have a website? Do you run ads?
- Do you have a CRM? Which one?
- How many leads/customers do you handle per month?
- What's your team size? (solo, small team, larger team)
3.**What metrics are hardest to track?**
- Which metrics from our Metrics document are difficult to measure?
- Which ones require manual work?
- Which ones don't have obvious tracking solutions?
Ask these questions one at a time and wait for my responses.
Once you have my answers, provide a clear recommendation:
**Recommend a tracking approach:**
- Start with spreadsheets? (if just getting started)
- Add tracking tools? (if you have a website/ads)
- Set up CRM events? (if you have a CRM)
- Set up product database tracking? (if you're a developer/vibe coder and want to track directly in your database)
- Or a combination of these approaches?
**For each recommended approach, explain:**
- Why it makes sense for my situation
- Which metrics it will track
- What tools to use (specific recommendations)
- How to set it up (high-level steps)
- How much time/effort it requires
**Prioritize the setup:**
- What should I set up first?
- What can wait?
- What's the quickest win?
Keep this in the project for reference.
Decide on your tracking approach and tools

2. Spreadsheets - Manual tracking with spreadsheets

Spreadsheets are your foundation for tracking metrics that don't automatically flow into tools. They're perfect for getting started, tracking difficult metrics, and maintaining flexibility as your needs evolve.

Why Spreadsheets Matter

Flexibility: Track anything–metrics that don't have automated solutions, custom calculations, business-specific KPIs. You're not limited by what tools can track automatically.

Understanding: Manual tracking forces you to understand your metrics. You see the data entry process, notice patterns, and develop intuition about what numbers mean.

Cost-Effective: Free (Google Sheets) or low-cost (Excel), no subscriptions, no setup complexity. Perfect for bootstrapped businesses.

When to Use Spreadsheets

  • Getting started: Track your first 5-7 key metrics manually to understand what matters
  • Difficult metrics: Track things like "calls booked," "partnerships formed," "content pieces published" that don't auto-track
  • Custom calculations: Create your own formulas and dashboards
  • Small scale: When you don't have enough volume to justify tool setup

Essential Spreadsheet Structure

Create a simple tracking sheet with:

  • Date column: Track metrics over time
  • Metric columns: One column per metric (visitors, leads, customers, revenue, etc.)
  • Source columns: Where did this come from? (organic, ads, referrals, etc.)
  • Notes column: Context for unusual numbers or changes

Best Practices

  • Update regularly: Daily or weekly, not monthly (too hard to remember)
  • Keep it simple: Start with 5-7 metrics, add more as needed
  • Use formulas: Calculate rates, percentages, and trends automatically
  • Visualize: Create simple charts to see trends over time
Set up your spreadsheet tracking system
I'm setting up spreadsheet tracking for my metrics.
You have access to my Metrics document which shows all the metrics I need to track for each funnel stage (ToFu, MoFu, BoFu, GroFu).
**First, ask me which spreadsheet tool I prefer to use:**
- Google Sheets (cloud-based, free, easy sharing)
- Microsoft Excel (desktop or online)
- Apple Numbers
- Other spreadsheet tool
Wait for my answer before proceeding.
Based on my spreadsheet tool choice and my metrics, help me create a tracking system:
**Create a spreadsheet template structure:**
1.**Overview Sheet**: Summary dashboard showing key metrics and trends
- Current month totals
- Month-over-month changes
- Key rates (conversion rates, etc.)
- Simple charts/graphs
2.**Daily/Weekly Tracking Sheet**: Where I'll enter data regularly
- Date column
- Columns for each metric I need to track
- Source columns (where did this come from?)
- Notes column (context for unusual numbers)
3.**Monthly Summary Sheet**: Aggregated monthly data
- Monthly totals for each metric
- Monthly rates and percentages
- Trends over time
**For each metric from my Metrics document:**
- Include it in the appropriate sheet
- Add a brief description/definition
- Show how to calculate rates/percentages if applicable (using formulas specific to my spreadsheet tool)
- Include a target/benchmark if we have one
**Provide setup instructions specific to my spreadsheet tool:**
- How to create the sheets in [my chosen tool]
- What formulas to use (syntax for my specific tool)
- How to update it regularly
- How to interpret the data
**Focus on the metrics I prioritized** (the 5-7 most important ones), but include structure for all metrics so I can add them later.
Keep this in the project–we'll build on it in the next sections.

Outcome: You have a spreadsheet tracking system set up with the right structure for your metrics.

Set up your spreadsheet tracking system

3. Tracking Tools - Automated tracking tools

Tracking tools automatically capture data from your website, ads, and online activities. Once set up, they track continuously without manual work–giving you insights you can't get from spreadsheets alone.

Why Tracking Tools Matter

Automation: Set it up once, track forever. No manual data entry, no forgetting to update. Data flows automatically from your website, ads, and tools.

Scale: Handle thousands of visitors, millions of data points. Spreadsheets can't scale to this level, but tracking tools are built for it.

Insights: See behavior patterns, conversion paths, audience segments. Tools analyze data and reveal insights you'd never notice manually.

When to Use Tracking Tools

  • You have a website: Track visitor behavior, page views, conversions automatically
  • You run ads: Track ad performance, costs, conversions, ROI
  • You publish content: Track content performance, engagement, traffic sources
  • You want scale: Handle high volume without manual work

Essential Tracking Tools

Google Analytics (Free)
Tracks: Website visitors, page views, traffic sources, conversions, user behavior. Essential for any website. Set up basic tracking first, then add goals and events.

Meta Pixel (Free)
Tracks: Facebook/Instagram ad performance, website conversions from ads, audience behavior. Essential if you run Facebook/Instagram ads.

Google Tag Manager (Free)
Manages: All your tracking codes in one place. Makes it easy to add/update tracking without touching website code. Use this to manage Google Analytics, Meta Pixel, and other tools.

Other Tools (As Needed)

  • Hotjar/Microsoft Clarity: See how visitors use your site (heatmaps, recordings)
  • Search Console: Track search performance and SEO
  • Email platform analytics: Track email performance (opens, clicks, conversions)

Best Practices

  • Start simple: Set up Google Analytics first, add more tools as needed
  • Set up goals: Define what "conversion" means (form submissions, purchases, etc.)
  • Use Tag Manager: Manage all tracking codes in one place
  • Review regularly: Check data weekly, but don't obsess over daily fluctuations
Set up your automated tracking tools
I'm setting up automated tracking tools for my website and marketing activities.
You have access to my Metrics document which shows what I need to track, and my Funnel Overview document which shows my customer journey structure.
Based on my metrics and funnel, help me set up tracking:
**1. Google Analytics Setup:**
- How to create an account and install tracking code
- How to set up goals/conversions for each funnel stage (ToFu → MoFu → BoFu → GroFu)
- How to track key events (lead magnet downloads, email signups, purchases, etc.)
- How to set up custom reports for my specific metrics
**2. Meta Pixel Setup** (if I run Facebook/Instagram ads):
- How to create and install the pixel
- How to track conversions from ads
- How to set up custom events for my funnel stages
**3. Google Tag Manager Setup** (recommended):
- How to set up Tag Manager
- How to use it to manage Google Analytics and Meta Pixel
- How to add new tracking tools without touching website code
**For each tool, provide:**
- Step-by-step setup instructions
- How to verify it's working
- How to track my specific metrics from the Metrics document
- How to set up goals/events for my funnel stages
**Prioritize:**
- What to set up first (Google Analytics is essential)
- What can wait
- Quick wins vs. advanced features
Focus on tracking the metrics I prioritized, but set up structure for all metrics.

Outcome: You have automated tracking tools set up that capture data from your website and marketing activities.

Set up your automated tracking tools

4. CRM Events - Tracking in CRM

Your CRM becomes the single source of truth for your complete customer journey. By tracking events in your CRM, you can see how leads move through your funnel from first touchpoint to loyal customer–connecting marketing activities to sales outcomes.

Why CRM Events Matter

Complete Journey: Track the entire customer journey in one place–from first website visit to purchase to renewal. See how marketing activities connect to sales results.

Lead Quality: Understand which marketing activities generate the best leads. See which sources, campaigns, and content produce customers (not just leads).

Sales Integration: Connect marketing metrics to sales outcomes. See conversion rates, sales cycle length, deal sizes–the metrics that matter for revenue.

When to Use CRM Events

  • You have a CRM: Essential if you use a CRM (HubSpot, Salesforce, Pipedrive, etc.)
  • High-touch funnel: Critical for sales-assisted funnels where leads become opportunities
  • Multi-touch journey: Track complex journeys with multiple touchpoints
  • Team collaboration: Share data across marketing and sales teams

Essential CRM Event Tracking

Marketing Events:

  • Website visits, page views, content downloads
  • Email opens, clicks, engagement
  • Ad clicks, form submissions, lead magnet downloads
  • Social media engagement, webinar attendance

Sales Events:

  • Lead created, qualified, assigned
  • Demo scheduled, completed
  • Proposal sent, deal won/lost
  • Customer onboarded, upsold, renewed

Customer Events:

  • Purchase completed, subscription started
  • Feature usage, support tickets
  • Upsell opportunities, renewal dates
  • Referrals, reviews, advocacy

Best Practices

  • Connect everything: Link website, email, ads, and sales activities to CRM
  • Use automation: Set up workflows to track events automatically
  • Track sources: Always capture where leads come from (source, campaign, content)
  • Update regularly: Keep CRM data current so metrics are accurate
Set up CRM event tracking
I'm setting up CRM event tracking to track my complete customer journey.
You have access to my Funnel Overview document (which shows my CRM structure from Funnel Building), my Metrics document (which shows what to track), and my CRM Workflows document (if available).
Based on my CRM and funnel structure, help me set up event tracking:
**1. Marketing Event Tracking:**
- How to connect my website to CRM (form submissions, page views, content downloads)
- How to track email engagement (opens, clicks) in CRM
- How to track ad performance (clicks, conversions) in CRM
- How to capture lead sources and campaigns
**2. Sales Event Tracking:**
- How to track lead progression (created → qualified → assigned → demo → proposal → won/lost)
- How to track sales activities (calls, emails, meetings)
- How to measure sales cycle length and conversion rates
**3. Customer Event Tracking:**
- How to track customer activities (purchases, renewals, upsells)
- How to measure customer health and retention
- How to track advocacy (referrals, reviews)
**For each event type, provide:**
- How to set it up in my CRM (specific steps for my CRM if known)
- How to automate it (workflows, integrations)
- How it connects to my funnel stages (ToFu → MoFu → BoFu → GroFu)
- How to measure it (reports, dashboards)
**Focus on:**
- Events that track my prioritized metrics
- Events that connect marketing to sales
- Events that show complete customer journey
If you don't know my specific CRM, provide general guidance that works for most CRMs (HubSpot, Salesforce, Pipedrive, etc.).

Outcome: You have CRM event tracking set up that captures your complete customer journey from marketing to sales to customer success.

Set up your CRM event tracking

5. Product Database - Tracking directly in your product database

For developers and vibe coders, your product database is the ultimate source of truth. Instead of relying on external tracking tools, you can track user behavior, feature usage, conversions, and product metrics directly where your data lives.

Why Product Database Tracking Matters

Single Source of Truth: Your product database already contains user activity, feature usage, conversions, and behavior. No need to sync data between external tools–it's all in one place.

Full Control: You control the schema, queries, and analysis. No limitations from external tool APIs or data export restrictions.

Developer-Friendly: If you're building the product, you can instrument tracking directly in your code. Track exactly what matters without relying on third-party tools. Use Claude Code in the Claude Desktop app to add the tracking to your codebase and write the queries for you.

Cost-Effective: No per-user pricing or API limits. Your database is your tracking system.

When to Use Product Database Tracking

  • You're a developer/vibe coder: You're comfortable working with databases and SQL
  • You want full control: You don't want to depend on external tracking tools
  • You have a product with user activity: Users log in, use features, convert–all tracked in your database
  • You want to track product usage: Feature adoption, user engagement, product metrics

What You Can Track

User Activity:

  • User signups, logins, sessions
  • Feature usage and adoption
  • User engagement and activity patterns
  • Product-specific events (actions, conversions, milestones)

Product Metrics:

  • Feature usage rates
  • User retention and churn (based on activity)
  • Conversion funnels (signup → activation → conversion)
  • Product engagement scores

Business Metrics:

  • User-to-customer conversion rates
  • Feature-to-revenue connections
  • Product usage patterns that predict churn
  • Expansion opportunities based on usage

Best Practices

  • Instrument key events: Track the actions that matter (signups, feature usage, conversions)
  • Use event tables: Create event logs for user actions, not just user records
  • Query regularly: Set up queries or views for common metrics
  • Document your schema: Keep track of what you're tracking and why
Set up product database tracking
I'm setting up product database tracking for my metrics.
You have access to my Metrics document which shows all the metrics I need to track, and my Funnel Overview document which shows my customer journey structure.
**First, ask me about my product database:**
- What database system am I using? (PostgreSQL, MySQL, MongoDB, Supabase, etc.)
- What's my current database schema? (Do I have user tables, event tables, activity logs?)
- What product events/actions do I already track? (signups, logins, feature usage, conversions, etc.)
- What metrics from my Metrics document can I track directly in my database?
Wait for my answers before proceeding.
Based on my database system and metrics, help me set up product database tracking:
**1. Database Schema Design:**
- What tables/collections do I need to track the metrics from my Metrics document?
- Should I create event tables for user actions? Activity logs?
- How should I structure the data for easy querying?
**2. Instrumentation Plan:**
- What events/actions should I track in my product code?
- Where in my codebase should I add tracking?
- How to ensure tracking doesn't slow down the product?
**3. Query Strategy:**
- What queries/views should I create for common metrics?
- How to calculate conversion rates, retention, engagement from my database?
- How to connect product usage to business metrics (revenue, churn, etc.)?
**4. For each metric from my Metrics document that can be tracked in the database:**
- How to track it (what events/actions to log)
- How to query it (SQL queries or database-specific queries)
- How to calculate rates/percentages
- What tables/collections are involved
**Focus on:**
- Metrics that relate to product usage and user behavior
- Events that connect to my funnel stages (ToFu → MoFu → BoFu → GroFu)
- Queries that are efficient and don't slow down the database
Provide specific instructions for my database system (PostgreSQL, MySQL, MongoDB, etc.) with correct syntax and best practices.
Keep this in the project–we'll build on it in the next sections.

Outcome: You have product database tracking set up that captures user activity and product metrics directly in your database.

Set up your product database tracking

6. Your Tracking Setup Overview

Creating Your Tracking Setup Overview

Throughout this lesson, you've set up tracking systems: spreadsheets for manual tracking, automated tools for website/ad data, CRM events for the complete customer journey, and product database tracking for user behavior in your product. Now it's time to create a single overview document that shows all your tracking systems and how they work.

The Goal: Complete Overview of All Your Tracking Systems

This tracking setup overview will serve as your reference for:

  • Remembering how each tracking system works
  • Onboarding team members to your tracking setup
  • Troubleshooting tracking issues
  • Adding new metrics or tools in the future

Having all your tracking configurations in one place means you can quickly reference setup steps, tool configurations, and measurement methods–without searching through multiple conversations or documents.

Create your tracking setup overview
I've set up tracking systems throughout this lesson: spreadsheets, tracking tools, CRM events, and product database tracking.
You have access to all my tracking setup documents from the previous sections in this project.
Now I need you to extract and organize all these tracking configurations into a single, comprehensive document: "[Business Name] - Tracking Setup.md"
**Structure the document as follows:**
# [Business Name] - Tracking Setup
## Overview
- Summary of our tracking approach (spreadsheets + tools + CRM + product database)
- Why we use each approach
- How tracking systems work together
## Spreadsheet Tracking
- Link to or description of our spreadsheet template
- Which metrics we track manually
- How to update the spreadsheet
- Formulas and calculations we use
- How to interpret the data
## Automated Tracking Tools
- Google Analytics setup and configuration
- Goals/conversions we've set up
- Custom events we track
- How to access and use reports
- Other tools we use (Meta Pixel, Tag Manager, etc.)
## CRM Event Tracking
- Which CRM we use
- Marketing events we track (website, email, ads)
- Sales events we track (lead progression, activities)
- Customer events we track (purchases, renewals, upsells)
- How to set up workflows and automation
- How to access CRM reports
## Product Database Tracking
- Which database system we use
- Database schema for tracking (tables, event logs)
- What events/actions we track in the product
- Key queries/views for common metrics
- How to calculate rates and percentages from database
- How product usage connects to business metrics
## Integration Guide
- How tracking systems connect to each other
- How to ensure data consistency
- How to troubleshoot common issues
- How to add new metrics or tools
**Extract all the tracking setup information from our previous conversations and organize it into this structure. Make sure nothing is missing and everything is clearly explained.**
Save this as "[Business Name] - Tracking Setup.md" in the project.

Outcome: You have a complete tracking setup overview that shows all your tracking systems and how they work together.

Download and upload your Tracking Setup Overview to your Claude project