| 📊 View Lecture Slides | Full-screen presentation with navigation |
Day 6: Analytics, Metrics & Actionable Insights
| Session Duration: 2 Hours | Phase: 3 — Data & Retention: The Feedback Loop |
Learning Objectives
By the end of this session, students will be able to:
- Distinguish vanity metrics from actionable (sanity) metrics
- Map a conversion funnel and calculate the drop-off rate at each stage
- Identify the 3 most common causes of funnel leaks for their business type
- Use AI to analyse a mock analytics dataset and surface conversion bottlenecks
- Write an executive analytics recommendation report based on data analysis
Hour 1: Strategy & Prompt Design (Instructor-Led — 60 minutes)
6.1 Data Literacy for Marketing Managers
(Note: You can deploy tracking codes on platforms like the Google Sites architecture discussed in Day 2.)
The average marketing dashboard contains 40–60 metrics. This is not information — it is noise. A marketing manager’s core analytical skill is not knowing how to read charts. It is knowing which metrics matter, why they matter, and what decision they should drive.
The first framework for developing this skill is the Vanity/Sanity distinction.
Vanity Metrics vs. Sanity Metrics
Vanity Metrics look impressive but do not directly correlate with business outcomes. They measure activity, not impact.
Sanity Metrics directly indicate whether the business is working. They measure outcomes that matter.
| Vanity Metric | The Lie It Tells | The Sanity Metric That Replaces It |
|---|---|---|
| Total page views | “We’re getting traffic” | Conversion rate from organic traffic |
| Social media follower count | “We have an audience” | Email subscriber growth rate |
| Total impressions | “People are seeing us” | Click-through rate (CTR) |
| Number of posts published | “We’re producing content” | Organic traffic per published post |
| Email subscribers added | “Our list is growing” | Email open rate + click rate |
| Ad spend | “We’re investing in marketing” | Customer Acquisition Cost (CAC) |
| Total revenue | “We’re selling” | Net Profit Margin / ROI per channel |
The Test for a Sanity Metric: Ask yourself, “If this number improved by 10%, would I make a different business decision?” If yes — it’s a sanity metric. If no — it’s vanity.
The Core KPI Stack for a Digital Business
Regardless of industry, every digital business should track these metrics weekly:
Acquisition Metrics
- Organic Traffic: Visitors from search engines (measures SEO effectiveness)
- Paid Traffic CAC: Cost per acquired customer from paid channels
- CTR (Click-Through Rate): % of ad/search impressions that result in a click
Engagement Metrics
- Bounce Rate: % of visitors who leave without taking any action (high = relevance mismatch)
- Average Session Duration: How long people spend on the site (higher = more engaged)
- Pages per Session: How many pages a visitor views (higher = better content architecture)
Conversion Metrics
- Conversion Rate (CVR): % of visitors who complete the desired action (purchase, sign-up, inquiry)
- Cart Abandonment Rate: % of sessions that add to cart but don’t complete checkout
- Lead-to-Customer Rate: % of leads who become paying customers
Retention Metrics
- Customer Lifetime Value (LTV): Total revenue generated per customer over their relationship with the brand
- Customer Acquisition Cost (CAC): Total marketing spend ÷ number of new customers acquired
- Repeat Purchase Rate: % of customers who make more than one purchase
6.2 The Funnel Leak Philosophy
Every digital business can be modelled as a series of stages through which potential customers flow. At each stage, some percentage of visitors proceed to the next stage and some drop off. These drop-off points are “leaks.”
The critical insight: A small improvement at an early funnel stage has a massive multiplier effect on final outcomes.
The Standard E-Commerce Funnel
| Stage | Example Numbers | Drop-Off Rate | Industry Average Drop-Off |
|---|---|---|---|
| Ad Impressions | 100,000 | — | — |
| Ad Clicks (CTR) | 2,000 | 98% don’t click | 1–3% CTR is average |
| Landing Page Visits | 2,000 | — | — |
| Product Page Views | 800 | 60% bounce | 40–60% bounce rate |
| Add to Cart | 160 | 80% don’t add | 5–15% add to cart |
| Checkout Started | 80 | 50% don’t start | — |
| Purchase Completed | 20 | 75% cart abandonment | 70% cart abandonment |
Revenue from this funnel: 20 sales
What if bounce rate improved by just 10%? (880 instead of 800 view product pages)
- 88 add to cart → 44 start checkout → 11 more sales = 55% revenue increase from a single 10% improvement
This is why Conversion Rate Optimisation has the highest ROI of any marketing activity.
The 5 Most Common Funnel Leak Locations
1. Bounce Rate on Landing Page Root cause: Intent mismatch between traffic source and page content Diagnosis question: “Does my page headline exactly match the promise made in the ad or search result that brought them here?”
2. High Exit Rate on Product/Service Page Root cause: Insufficient trust signals, unclear offer, or weak copy Diagnosis question: “Within 5 seconds, can a visitor understand what this product does, who it’s for, and why it’s worth the price?”
3. Cart Abandonment Root cause: Unexpected costs (shipping), checkout complexity, lack of trust, or not ready to buy Diagnosis question: “Have we eliminated every possible surprise or obstacle between ‘add to cart’ and ‘order confirmed’?”
4. Form Abandonment (Lead Generation) Root cause: Too many fields, lack of privacy assurance, weak value proposition Diagnosis question: “Is every field on this form essential? Does the form clearly state what they will receive in exchange for their details?”
5. Low Email Open Rate Root cause: Weak subject lines, wrong sending time, sender name not recognised, or audience trust deficit Diagnosis question: “Does our subject line create curiosity, urgency, or a clear value promise? Does our audience recognise who the email is from?”
6.3 Reading Google Analytics 4 (GA4) Like a Manager
GA4 is the industry-standard free analytics platform. Every marketing manager needs to be able to navigate it and extract the key reports that inform decisions.
Critical GA4 Reports to Bookmark:
| Report | Where to Find It | What to Look For |
|---|---|---|
| Traffic Acquisition | Reports → Acquisition → Traffic Acquisition | Which channels send the most users AND the most conversions |
| Landing Pages | Reports → Engagement → Landing Page | Which pages have the highest bounce rates |
| Events & Conversions | Reports → Engagement → Events | Are conversion events firing correctly? |
| User Retention | Reports → Retention | Day 1, Day 7, Day 30 retention curves |
| Funnel Exploration | Explore → Funnel Exploration | Build and visualise your custom conversion funnel |
| Path Exploration | Explore → Path Exploration | See what users do before and after any step |
| Session Default Channel Group | Traffic Acquisition report → breakdown | Compare organic vs paid vs social vs email |
6.4 Google Search Console: The SEO Source of Truth
While GA4 tracks what users do on your website, Google Search Console (GSC) tracks how users find your website on Google. For organic traffic, GSC is the absolute best free diagnostic tool available.
The Difference:
- GA4: “100 people visited from Google. They stayed for 2 minutes.”
- GSC: “Your website appeared 5,000 times for the search term ‘digital marketing agency Kathmandu’. 100 people clicked it (2% CTR). Your average ranking is position 4.”
Why GSC is Critical for Google Sites: Google Sites integrates seamlessly with GA4. Once your GA4 is connected to your Google Site, you can use that GA4 property to instantly verify your domain in Google Search Console without touching any HTML or DNS records.
The Most Important Tab: “Queries” The Performance > Search results report shows you exactly what people type into Google to find you. If you are ranking well for “cheap services” but you sell premium services, you have a mismatch that GA4 won’t tell you, but GSC will make obvious immediately.
Hour 2: Digital Sandbox Lab (Individual Execution — 60 minutes)
The AI Prompting Framework: The Data Analyst Persona Prompt
This prompt transforms AI into an analytical partner that can identify patterns, diagnose problems, and generate strategic recommendations from raw data.
The Mock Analytics Dataset
Download or copy this mock dataset for your lab exercise. It represents a fictional e-commerce business with a clearly leaking funnel.
MOCK ANALYTICS DATASET — "NepaliCraft" Handmade Home Decor
Period: Last 30 Days
TRAFFIC SOURCES
Source | Sessions | Users | Bounce Rate | Avg Session Duration | Conversions | Conv. Rate
--------------------|----------|--------|-------------|----------------------|-------------|------------
Google Organic | 3,200 | 2,800 | 42% | 3m 12s | 96 | 3.0%
Google Paid (CPC) | 1,800 | 1,750 | 71% | 1m 05s | 18 | 1.0%
Facebook Organic | 900 | 880 | 65% | 1m 45s | 9 | 1.0%
Facebook Paid | 2,200 | 2,150 | 68% | 1m 30s | 22 | 1.0%
Instagram Organic | 650 | 640 | 58% | 2m 10s | 13 | 2.0%
Email | 420 | 400 | 25% | 5m 30s | 42 | 10.0%
Direct | 380 | 310 | 38% | 4m 00s | 19 | 5.0%
TOTAL | 9,550 | 8,930 | 55% (avg) | 2m 24s (avg) | 219 | 2.3%
CHECKOUT FUNNEL
Step | Users | Drop-Off
-------------------------------|--------|----------
Product Page Views | 2,800 | —
Add to Cart | 560 | 80% drop
Checkout Started | 224 | 60% drop
Shipping Info Entered | 190 | 15% drop
Payment Page Reached | 170 | 10% drop
Order Confirmed | 119 | 30% drop (!!!)
Order Confirmed (incl. returns)| 219 | — (includes in-store)
TOP PAGES BY BOUNCE RATE
Page URL | Sessions | Bounce Rate | Avg Time
------------------------------|----------|-------------|----------
/google-ads-landing-page/ | 1,200 | 78% | 0m 45s
/facebook-discount-offer/ | 900 | 74% | 0m 52s
/homepage/ | 1,800 | 52% | 1m 30s
/product/handmade-dhaka-rug/ | 620 | 38% | 3m 45s
/product/ceramic-vase-set/ | 510 | 42% | 3m 20s
/blog/nepali-craft-history/ | 380 | 22% | 6m 10s
ADDITIONAL DATA
- Average Order Value (AOV): NPR 2,850
- Mobile traffic: 72% of total sessions
- Mobile conversion rate: 0.8% vs Desktop: 3.9%
- Cart abandonment emails sent: 44 / Opened: 18 / Recovered: 3
- Email list: 1,240 subscribers
- Email last sent: 9 days ago (last campaign)
The Full Prompt Template
You are a Senior Digital Analyst specialising in e-commerce
conversion optimisation. You have just been handed the following
30-day analytics report for NepaliCraft, a handmade home decor
e-commerce business:
[PASTE THE MOCK ANALYTICS DATASET ABOVE]
Please conduct a full conversion audit and produce:
1. EXECUTIVE SUMMARY (3–4 sentences)
What is the overall health of this business's digital
performance? What is the single most critical issue?
2. THE 3 PRIMARY CONVERSION BOTTLENECKS
For each bottleneck:
a) Name it clearly (e.g., "Paid Traffic Relevance Failure")
b) Cite the specific data point(s) that evidence this problem
c) Explain the business impact (calculate the revenue being
lost due to this specific issue)
d) Provide 2–3 specific, actionable recommendations to fix it
with expected impact on the metric
3. CHANNEL PERFORMANCE RANKING
Rank the 7 traffic sources by ROI efficiency (not just volume).
Explain which channels deserve more budget/attention and which
are underperforming relative to their investment.
4. MOBILE EXPERIENCE ALERT
The mobile vs desktop conversion gap is significant. Identify
what specific issues likely cause this gap and provide a
prioritised 5-point mobile optimisation checklist.
5. QUICK WIN OPPORTUNITIES
Identify 2 actions that could be implemented this week
with a high probability of improving conversion rate.
For each: describe the action, estimated effort (hours),
and projected impact.
Step-by-Step Lab Instructions
⚙️ Setup (5 minutes)
- Copy the mock dataset above into a new Google Doc or keep it visible
- Open your AI tool in a new conversation
- Create a new document:
[Your Business Name] — Analytics Report Template
🤖 Part 1: Run the Conversion Audit (25 minutes)
- Paste the Data Analyst Persona prompt with the mock dataset
- Read through the full output carefully
- Highlight the 3 bottlenecks the AI identifies
- For each bottleneck: do you agree with the diagnosis? What additional data would you want to confirm it?
📊 Part 2: Apply the Insights to Your Mock Business (15 minutes) Now translate this analysis to your own sandbox business:
- Using the Executive Report Template below, write a hypothetical version for YOUR business
- Invent plausible metrics for your business type and industry
- Use the same AI prompt but replace the NepaliCraft data with your hypothetical data
- Run the analysis and note the recommendations
✏️ Part 3: Build Your Analytics Dashboard Plan (15 minutes) Using the KPI Dashboard Template below:
- Decide the 8–10 metrics you would track for your business
- Define the target value for each metric
- Define the alert threshold (when would this metric trigger a review?)
- Identify the report in GA4 (or equivalent) that measures this
Templates & Worksheets
Template 1: Executive Analytics Report
MARKETING ANALYTICS EXECUTIVE REPORT
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Business: _______________________________
Reporting Period: _______________________
Analyst: ________________________________
Date: __________________________________
EXECUTIVE SUMMARY
(3–4 sentences — overall health + single most critical issue)
________________________________________
________________________________________
________________________________________
KEY METRICS OVERVIEW
Total Sessions: _________________________
Overall Conversion Rate: ________________
Revenue (if applicable): ________________
Customer Acquisition Cost: ______________
Top Performing Channel: ________________
Worst Performing Channel: ______________
CONVERSION BOTTLENECK #1
Name: __________________________________
Evidence: ______________________________
Business Impact: ________________________
Recommendations:
1. ___________________________________
2. ___________________________________
Expected impact: ______________________
CONVERSION BOTTLENECK #2
Name: __________________________________
Evidence: ______________________________
Business Impact: ________________________
Recommendations:
1. ___________________________________
2. ___________________________________
Expected impact: ______________________
CONVERSION BOTTLENECK #3
Name: __________________________________
Evidence: ______________________________
Business Impact: ________________________
Recommendations:
1. ___________________________________
2. ___________________________________
Expected impact: ______________________
CHANNEL PERFORMANCE RANKING
(Rank by ROI efficiency)
1st: __________________________________
2nd: __________________________________
3rd: __________________________________
Most underperforming: ___________________
THIS WEEK'S PRIORITY ACTIONS
Action 1: ______________________________
Who is responsible: ___________________
Deadline: ____________________________
Action 2: ______________________________
Who is responsible: ___________________
Deadline: ____________________________
NEXT REVIEW DATE: ______________________
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Template 2: KPI Dashboard Configuration
WEEKLY KPI DASHBOARD
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Business: _______________________________
Metric | Current | Target | Alert Threshold | Data Source
-------------------|---------|--------|-----------------|-------------
Conversion Rate | | | Below 2% | GA4
CAC | | | Above NPR X | Ads + Sales
Email Open Rate | | | Below 20% | Mailchimp
Bounce Rate | | | Above 60% | GA4
Avg Session Time | | | Below 1m 30s | GA4
New Users | | | 10% w/w drop | GA4
Organic Traffic | | | 15% drop | GA4/GSC
Cart Abandonment | | | Above 75% | GA4
Revenue/Session | | | Below NPR X | GA4
Return Customer % | | | Below 20% | CRM/GA4
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Resources & Further Reading
🛠️ Tools Required Today
| Tool | Purpose | Cost |
|---|---|---|
| Google Analytics 4 | Primary web analytics | Free |
| Google Search Console | SEO performance data | Free |
| Hotjar | Session recordings + heatmaps | Free (35 sessions/day) |
| Microsoft Clarity | Session recordings (no limit) | Free |
| Google Looker Studio | Custom dashboards | Free |
| ChatGPT / Claude | Data analysis + recommendations | Free |
📚 Reference Reading
- Avinash Kaushik — Web Analytics 2.0 — The authoritative book on analytics strategy for digital marketers
- Google Analytics Academy — analytics.google.com/analytics/academy — Free official GA4 courses
- CXL Blog — cxl.com/blog — Advanced conversion optimisation research and case studies
Key Takeaways
- Vanity Metrics Are Addictive and Dangerous — They look good in reports but drive wrong decisions.
- Fix the Funnel Before Buying More Traffic — A 2% conversion rate doubled to 4% doubles your revenue without spending an extra rupee on ads.
- The Mobile Gap is an Immediate Opportunity — Mobile traffic dominates; mobile conversion rates typically lag desktop by 3–5x. This is fixable.
- Email Converts 5–10x Better Than Social — When the mock data shows email at 10% conversion vs. Facebook at 1%, the implication is clear.
- Data Without a Decision is Just Noise — Every analytics review should end with 2–3 specific, owner-assigned action items with deadlines.
| _Previous: Day 5 – Social Media & Asset Pipelines ← | Next: Day 7 – Email Marketing & Retention Automation →_ |
