🛒 Module 9: Sales & Marketing Analytics
This module covers essential data analytics concepts and practical applications.
Intermediate Level
⏱️ 45-60 minutes
📚 Topics Covered
-
✓ Sales Funnel Analysis
-
✓ Customer Acquisition Cost (CAC) Optimization
-
✓ Marketing Attribution Modeling
-
✓ Campaign Performance Metrics
-
✓ Lead Scoring & Conversion Analysis
-
✓ Customer Segmentation
-
✓ A/B Testing for Marketing
-
✓ Marketing ROI & ROAS Measurement
🔑 Key Concepts
-
• Tracking the customer journey from awareness to purchase
-
• Measuring marketing effectiveness and ROI
-
• Optimizing conversion rates at each funnel stage
-
• Attributing revenue to marketing channels
-
• Using data to improve marketing spend efficiency
9.1 The Sales Funnel - Tracking the Customer Journey
The sales funnel visualizes how prospects move from awareness to purchase. Analyzing each stage reveals optimization opportunities.
Standard Sales Funnel Stages:
| Stage |
Description |
Key Metrics |
Example Actions |
| Awareness |
Prospect knows you exist |
Impressions, reach, traffic |
SEO, ads, social media |
| Interest |
Prospect engages with content |
Page views, time on site, downloads |
Blog posts, webinars, whitepapers |
| Consideration |
Prospect evaluates options |
Demo requests, product comparisons |
Free trials, case studies |
| Intent |
Prospect shows buying signals |
Cart adds, quotes requested |
Product demos, sales calls |
| Purchase |
Prospect becomes customer |
Conversion rate, revenue |
Checkout optimization, offers |
Simulation: Funnel Analysis Dashboard
┌─────────────────────────────────────────────┐
│ Sales Funnel Analysis - March 2025 │
├─────────────────────────────────────────────┤
│ │
│ Stage Volume Conv Rate Drop │
│ ──────────────────────────────────────────│
│ Awareness 50,000 100% - │
│ (Website) ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ │
│ ↓ │
│ Interest 12,500 25% 75% │
│ (Engaged) ▓▓▓▓▓ │
│ ↓ │
│ Consideration 3,750 30% 70% │
│ (Demo/Trial) ▓▓ │
│ ↓ │
│ Intent 1,500 40% 60% │
│ (Cart/Quote) ▓ │
│ ↓ │
│ Purchase 450 30% 70% │
│ (Customer) ▓ │
│ │
│ Overall Conversion: 0.9% (450/50,000) │
│ │
│ ⚠️ BOTTLENECK: Interest → Consideration │
│ Action: Improve content quality, targeting │
│ │
│ [Drill Down] [Compare Periods] [Export] │
└─────────────────────────────────────────────┘
E-commerce Example (USA):
An Austin-based online retailer analyzed their funnel and discovered 70% drop-off at cart stage.
Root cause: Unexpected shipping costs. Solution: Free shipping over $50 + progress bar showing how
close to free shipping. Cart abandonment dropped from 70% to 42%, increasing revenue by $85K/month.
9.2 Customer Acquisition Cost (CAC) Analysis
Understanding what it costs to acquire each customer is fundamental to profitable growth.
CAC Formula & Calculation:
CAC = Total Marketing & Sales Costs / New Customers Acquired
What to Include in CAC:
- Marketing Costs: Ad spend, content creation, marketing tools, agencies
- Sales Costs: Salaries, commissions, sales tools, training
- Technology: CRM, marketing automation, analytics platforms
- Overhead: Portion of rent, utilities for marketing/sales teams
CAC Calculation Example:
March 2025 Marketing & Sales Spend:
Ad Spend (Google, Facebook): $45,000
Marketing Salaries: $28,000
Sales Team Salaries: $52,000
Marketing Software: $8,000
Content Production: $12,000
─────────────────────────────────
Total: $145,000
New Customers Acquired: 450
CAC = $145,000 / 450 = $322.22 per customer
CAC by Marketing Channel:
| Channel |
Spend |
Customers |
CAC |
Status |
| Google Ads |
$25,000 |
120 |
$208 |
🟢 Efficient |
| Facebook Ads |
$20,000 |
85 |
$235 |
🟢 Good |
| Organic Search (SEO) |
$12,000 |
145 |
$83 |
🟢 Excellent |
| Email Marketing |
$8,000 |
75 |
$107 |
🟢 Excellent |
| Trade Shows |
$35,000 |
25 |
$1,400 |
🔴 Expensive |
Action Plan: Shift budget from trade shows to SEO and email marketing.
Double down on Google Ads (proven performer). Result: Projected CAC reduction from $322 to $245.
9.3 Marketing Attribution Modeling
Attribution determines which marketing touchpoints deserve credit for conversions.
Common Attribution Models:
| Model |
How Credit is Assigned |
Best For |
| First-Touch |
100% to first interaction |
Brand awareness campaigns |
| Last-Touch |
100% to final interaction |
Short sales cycles |
| Linear |
Equal credit to all touchpoints |
Customer relationship building |
| Time Decay |
More credit to recent interactions |
Long sales cycles |
| U-Shaped |
40% first, 40% last, 20% middle |
Lead generation + closing |
Attribution Example - Customer Journey:
Customer: Jane Smith
Purchase Value: $500
Touchpoint Journey:
1. Day 1: Google Search Ad (clicked)
2. Day 3: Email Newsletter (opened, clicked)
3. Day 7: Facebook Retargeting Ad (clicked)
4. Day 10: Direct visit → Purchase
Credit Distribution (Linear Model):
Google Ads: $125 (25%)
Email: $125 (25%)
Facebook Ads: $125 (25%)
Direct: $125 (25%)
Credit Distribution (U-Shaped Model):
Google Ads (first): $200 (40%)
Email: $50 (10%)
Facebook Ads: $50 (10%)
Direct (last): $200 (40%)
9.4 Campaign Performance Metrics
Track specific metrics to measure marketing campaign effectiveness.
Essential Campaign Metrics:
- Impressions: How many times ad was shown
- Reach: Unique people who saw ad
- Click-Through Rate (CTR) = Clicks / Impressions × 100%
- Cost Per Click (CPC) = Total Spend / Clicks
- Conversion Rate = Conversions / Clicks × 100%
- Cost Per Acquisition (CPA) = Total Spend / Conversions
- Return on Ad Spend (ROAS) = Revenue / Ad Spend
Simulation: Campaign Performance Dashboard
┌─────────────────────────────────────────────┐
│ Campaign: Spring Sale 2025 │
│ Duration: Mar 1-31 | Budget: $50,000 │
├─────────────────────────────────────────────┤
│ │
│ REACH & ENGAGEMENT: │
│ Impressions: 2,450,000 │
│ Reach: 1,200,000 unique │
│ Clicks: 36,750 │
│ CTR: 1.5% (industry avg: 2%) │
│ │
│ COSTS: │
│ Total Spend: $50,000 │
│ CPC: $1.36 │
│ CPA: $238 │
│ │
│ CONVERSIONS: │
│ Purchases: 210 │
│ Conversion Rate: 0.57% │
│ Revenue: $105,000 │
│ │
│ ROI METRICS: │
│ ROAS: 2.1x ($2.10 per $1) │
│ Profit: $55,000 │
│ ROI: 110% │
│ │
│ 🟢 VERDICT: Profitable campaign │
│ ⚠️ CTR below benchmark - test new creative │
│ │
│ [View Details] [Compare] [Export] │
└─────────────────────────────────────────────┘
9.5 Lead Scoring & Qualification
Not all leads are equal. Lead scoring prioritizes high-potential prospects.
Lead Scoring Framework:
| Category |
Criteria |
Points |
| Demographics |
Job title matches target (VP, Director) |
+20 |
|
Company size >100 employees |
+15 |
| Behavior |
Visited pricing page |
+25 |
|
Downloaded whitepaper |
+10 |
|
Requested demo |
+40 |
| Engagement |
Email open rate >50% |
+15 |
|
Multiple website visits (3+) |
+20 |
Lead Classification:
Score Ranges:
• 0-30: Cold Lead (nurture with automated content)
• 31-60: Warm Lead (assign to marketing for nurturing)
• 61-80: Hot Lead (assign to sales for outreach)
• 81-100: Very Hot Lead (immediate sales follow-up)
Example Lead:
Jane Smith, VP Marketing at 500-person company
• Job title match: +20
• Company size: +15
• Visited pricing page: +25
• Requested demo: +40
• Multiple visits: +20
Total Score: 120 → Very Hot Lead (Priority 1)
9.6 Customer Segmentation for Targeted Marketing
Group customers by shared characteristics to personalize marketing and improve results.
Common Segmentation Approaches:
- Demographic: Age, gender, income, education, occupation
- Geographic: Country, region, city, climate, urban/rural
- Behavioral: Purchase history, usage frequency, brand loyalty
- Psychographic: Lifestyle, values, interests, personality
- Firmographic (B2B): Industry, company size, revenue, location
RFM Segmentation (Recency, Frequency, Monetary):
Scoring System (1-5 scale):
• Recency: How recently did they purchase? (5 = last week, 1 = over 1 year)
• Frequency: How often do they purchase? (5 = weekly, 1 = once ever)
• Monetary: How much do they spend? (5 = high value, 1 = low value)
Segment Examples:
• RFM: 5-5-5 = Champions (best customers, reward & retain)
• RFM: 5-1-5 = New Big Spenders (nurture into loyalty)
• RFM: 1-5-5 = At Risk (re-engage with offers)
• RFM: 1-1-1 = Lost (low priority or win-back campaign)
Subscription Service Example (Canada):
A Toronto meal kit service segmented 50,000 customers using RFM. Identified 5,000 "At Risk" customers
(hadn't ordered in 60 days but high lifetime value). Sent personalized win-back offer: 40% off next order.
Result: 1,200 reactivations (24% response rate), $180K recovered revenue.
9.7 A/B Testing for Marketing Optimization
A/B testing compares two versions to determine which performs better.
What to A/B Test:
- Email Marketing: Subject lines, sender name, CTA buttons, content
- Landing Pages: Headlines, images, form fields, layout
- Ad Copy: Headlines, descriptions, CTAs, images/video
- Pricing: Price points, discount amounts, payment plans
- Product Pages: Photos, descriptions, social proof placement
A/B Test Example - Email Subject Line:
Hypothesis: Personalized subject lines increase open rates
Version A (Control):
Subject: "New Spring Collection Now Available"
Sent to: 5,000 subscribers
Opens: 850 (17% open rate)
Clicks: 102 (12% CTR)
Version B (Test):
Subject: "[First Name], Your Exclusive Spring Preview"
Sent to: 5,000 subscribers
Opens: 1,150 (23% open rate)
Clicks: 161 (14% CTR)
Results:
• Open rate improvement: +6 percentage points (35% relative increase)
• Click-through improvement: +2 percentage points (17% relative increase)
• Statistical significance: p = 0.001 (highly significant)
Decision: ✓ Implement Version B (personalized) for all future emails
Impact: If scaled to 100K list, expect 6,000 more opens and 2,000 more clicks monthly
9.8 Marketing ROI & ROAS Measurement
Prove marketing value by connecting spend to revenue.
Key Formulas:
Marketing ROI:
ROI = (Revenue from Marketing - Marketing Cost) / Marketing Cost × 100%
Example: $500K revenue, $100K cost
ROI = ($500K - $100K) / $100K × 100% = 400%
Return on Ad Spend (ROAS):
ROAS = Revenue from Ads / Ad Spend
Example: $500K revenue, $100K ad spend
ROAS = $500K / $100K = 5:1 (or 5x)
Meaning: For every $1 spent on ads, you get $5 back
ROAS Benchmarks by Industry:
| Industry |
Good ROAS |
Excellent ROAS |
| E-commerce |
4:1 |
8:1+ |
| SaaS |
3:1 |
5:1+ |
| Retail |
4:1 |
6:1+ |
| B2B Services |
2:1 |
4:1+ |
Important: Consider Customer Lifetime Value (CLV) in ROAS calculations.
First purchase ROAS might be 2:1 (breakeven after costs), but if customer stays for 3 years
with $5,000 lifetime value, the true ROAS is much higher. Don't judge channels solely on
first-purchase metrics.
✓ Module 9 Complete
You've learned:
- Sales funnel analysis and identifying bottlenecks
- Calculating and optimizing Customer Acquisition Cost (CAC)
- Marketing attribution models (first-touch, last-touch, linear, U-shaped)
- Campaign performance metrics (CTR, CPC, CPA, ROAS)
- Lead scoring frameworks and qualification criteria
- Customer segmentation strategies (RFM, demographic, behavioral)
- A/B testing methodology for marketing optimization
- Measuring marketing ROI and ROAS with industry benchmarks
- Real-world examples from e-commerce, SaaS, and subscription services
Next: Module 10 covers operational analytics and performance optimization.