Analytics Reports Overview

YeboLearn's reporting framework ensures stakeholders at all levels have timely, accurate, and actionable insights. Reports range from automated daily snapshots to comprehensive quarterly board presentations.

Reporting Philosophy

Our reporting approach is built on three principles:

1. Audience-Appropriate: Tailor content and detail to the recipient's needs
2. Action-Oriented: Every report should drive specific decisions or actions
3. Timely & Reliable: Deliver reports consistently and on schedule

Report Types

By Frequency

Daily Reports:

• Automated delivery
• Focus on operational metrics
• Real-time or near-real-time data
• Minimal analysis, mostly data presentation
• Recipients: Operations teams, executives (optional)

Weekly Reports:

• Semi-automated (template + manual insights)
• Focus on trends and week-over-week changes
• Include key wins and concerns
• Brief commentary and context
• Recipients: Department heads, managers, executives

Monthly Reports:

• Structured analysis and commentary
• Focus on month-over-month and year-over-year trends
• Deep-dive on specific areas
• Strategic recommendations
• Recipients: Executives, board observer, department heads

Quarterly Reports:

• Comprehensive strategic review
• Focus on quarterly and annual progress
• Market analysis and competitive landscape
• Forward-looking projections
• Recipients: Board of directors, investors, executive team

By Audience

Executive Reports:

• High-level summary (1-2 pages max)
• Focus on North Star metric and key KPIs
• Traffic light indicators (red/yellow/green)
• Exceptions and alerts
• Strategic decisions needed

Operational Reports:

• Detailed metrics and trends
• Focus on day-to-day performance
• Granular breakdowns by team, product, channel
• Tactical action items
• Performance against targets

Board Reports:

• Strategic overview (30-40 slide deck)
• Focus on quarterly progress and annual goals
• Market dynamics and competitive position
• Financial performance and projections
• Risk assessment and mitigation

Reporting Cadence

Daily Reporting Schedule

Morning Revenue Report (8:00 AM):

• Delivery: Email (automated)
• Recipients: CEO, CFO, CRO
• Content:
  • Yesterday's MRR change
  • New customers added (name, tier, MRR)
  • Churned customers (name, reason, MRR)
  • Pipeline movement (new opps, closed deals)
  • Critical alerts (downgrades, support escalations)

Evening Activity Summary (6:00 PM):

• Delivery: Email (automated)
• Recipients: Sales team, Sales leadership
• Content:
  • Today's sales activity (demos, proposals, closes)
  • Tomorrow's scheduled activities
  • Follow-ups needed
  • Pipeline updates

Platform Health Dashboard (Real-time):

• Delivery: Dashboard (always available)
• Recipients: Engineering, Operations, CEO
• Content:
  • Platform uptime and performance
  • Active users (current)
  • Error rates and incidents
  • System load and capacity

Weekly Reporting Schedule

Weekly Business Review (Every Monday, 9:00 AM):

• Delivery: Email summary + Dashboard link
• Recipients: Executive team, Department heads
• Sections:
  1. Executive Summary (key wins, concerns, priorities)
  2. Revenue Performance (MRR movement, new/expansion/churn)
  3. Sales Activity (pipeline, demos, closes, win/loss)
  4. Marketing Performance (leads, MQLs, campaign ROI)
  5. Product Usage (DAS, WAU, feature adoption)
  6. Customer Health (at-risk accounts, expansion opportunities)
  7. Week Ahead (goals, key activities)

Weekly Team Reports (Every Monday):

• Sales Team: Pipeline review, rep performance, quota tracking
• Marketing Team: Campaign performance, lead quality, channel metrics
• Product Team: Feature usage, user feedback, bugs/issues
• Customer Success: Account health, churn risk, expansion opportunities
• Engineering: Sprint progress, incidents, technical debt

Monthly Reporting Schedule

Monthly Business Review (MBR) (1st Thursday of month):

• Delivery: Slide deck presentation (60-90 min meeting)
• Recipients: Executive team, Board observer (optional), Department heads
• Sections:
  1. Executive Summary (1 slide: key metrics vs targets)
  2. Revenue Deep-Dive (3 slides: MRR movement, cohorts, tier/region)
  3. Sales Performance (3 slides: pipeline, win/loss, rep performance)
  4. Marketing Analytics (3 slides: channel ROI, campaigns, attribution)
  5. Product Metrics (2 slides: engagement, feature adoption)
  6. Financial Review (2 slides: P&L, unit economics, cash flow)
  7. Customer Success (2 slides: health scores, retention, expansion)
  8. Strategic Initiatives (2 slides: progress on key projects)
  9. Month Ahead (1 slide: goals, priorities, risks)

Total Deck: 19 slides, 90-minute meeting

Monthly Department Reports:

• Sales: Detailed pipeline analysis, quota attainment, forecast
• Marketing: Full funnel metrics, channel deep-dives, content performance
• Product: Feature analytics, user research insights, roadmap progress
• Customer Success: Retention analysis, NPS results, support metrics
• Finance: Full P&L, cash flow statement, budget vs actual

Quarterly Reporting Schedule

Quarterly Business Review (QBR) (Week after quarter close):

• Delivery: Slide deck presentation (3-hour board meeting)
• Recipients: Board of directors, Investors, Executive team
• Sections:
  1. Executive Summary (2 slides: quarter highlights, key metrics)
  2. Quarter Performance (4 slides: vs plan, vs prior quarter, trends)
  3. Annual Progress (3 slides: YTD performance, full-year projection)
  4. Revenue & Financial Deep-Dive (5 slides: cohorts, unit economics, P&L)
  5. Go-to-Market Performance (4 slides: sales + marketing effectiveness)
  6. Product & Platform (3 slides: usage, satisfaction, roadmap)
  7. Market Analysis (4 slides: TAM, competition, positioning)
  8. Strategic Initiatives (5 slides: progress, learnings, adjustments)
  9. Financial Forecast (4 slides: next 4 quarters, assumptions, scenarios)
  10. Risks & Mitigation (3 slides: identified risks, action plans)
  11. Next Quarter Priorities (3 slides: goals, resource allocation)

Total Deck: 40 slides, 3-hour meeting (includes Q&A)

Quarterly Investor Update (For external investors):

• Delivery: Email with PDF attachment
• Recipients: Investors, Advisors
• Content: Condensed version of QBR (15 slides), focus on financial and growth metrics

Report Distribution

Distribution Lists

Executive Distribution:

• CEO, CFO, CPO, CRO, CMO
• Receives: All reports (daily, weekly, monthly, quarterly)
• Access: Full dashboard access, all data

Department Head Distribution:

• VPs, Directors, Senior Managers
• Receives: Weekly business review, monthly department reports, relevant daily updates
• Access: Department dashboards, relevant company metrics

Manager Distribution:

• Team leads, Managers
• Receives: Weekly team reports, relevant monthly updates
• Access: Team dashboards, limited company metrics

Board Distribution:

• Board members, Board observers
• Receives: Monthly business review (summary), Quarterly business review (full)
• Access: Executive dashboards (view-only)

Investor Distribution:

• Lead investors, Angel investors
• Receives: Quarterly investor update
• Access: Limited financial dashboard

Delivery Methods

Email Delivery:

• Daily reports: Plain text email with key metrics
• Weekly reports: HTML email with summary + dashboard link
• Monthly reports: PDF attachment + calendar invite for meeting
• Quarterly reports: Slide deck attachment + board packet

Dashboard Access:

• Real-time dashboards: Always available at https://analytics.yebolearn.internal
• Mobile-responsive for phone/tablet access
• Role-based access control
• Export to PDF/Excel available

Slack Integration (For urgent alerts):

• Critical alerts: Posted to #exec-alerts channel
• Daily summaries: Posted to #general channel (optional)
• Sales wins: Posted to #wins channel
• System incidents: Posted to #incidents channel

Reporting Tools

Primary Tools

Metabase (Business Intelligence):

• Purpose: Interactive dashboards, SQL queries, report generation
• Users: All team members (role-based access)
• Cost: $800/month
• Features: 50+ dashboards, automated email delivery, embedding

Google Sheets (Collaborative Analysis):

• Purpose: Financial modeling, scenario planning, collaborative reports
• Users: Executive team, Finance team
• Cost: Included in Google Workspace
• Features: Real-time collaboration, formulas, charts

HubSpot (Sales/Marketing Reports):

• Purpose: CRM reports, pipeline dashboards, email campaign analytics
• Users: Sales team, Marketing team
• Cost: Included in HubSpot subscription
• Features: Pre-built reports, custom dashboards

Mixpanel (Product Analytics):

• Purpose: User behavior analysis, funnels, retention cohorts
• Users: Product team, Engineering team
• Cost: $500/month
• Features: Event tracking, segmentation, A/B test analysis

Google Slides (Presentations):

• Purpose: Monthly and quarterly presentation decks
• Users: Executive team
• Cost: Included in Google Workspace
• Features: Templates, collaboration, presenting mode

Reporting Automation

Automated Reports:

1. Daily Revenue Report: Python script → BigQuery → Email
2. Weekly Business Review: Metabase scheduled email
3. Platform Health Dashboard: Real-time data → Custom dashboard
4. Monthly Metrics: Metabase → Google Sheets → Slides (semi-automated)

Manual Reports:

1. Monthly Business Review: Compiled from multiple sources, narrative added
2. Quarterly Business Review: Strategic analysis, market research, future planning
3. Board Packet: Formatted presentation, supporting documents

Automation Roadmap:

• Q1 2026: Automate monthly MRR movement waterfall chart
• Q2 2026: Automated cohort retention visuals
• Q3 2026: AI-generated report summaries (experimental)

Report Quality Standards

Design Standards

Visual Consistency:

• Use YeboLearn brand colors (primary: blue, secondary: green)
• Consistent fonts (Headings: Montserrat, Body: Open Sans)
• Standard chart types (bar for comparisons, line for trends, pie for composition)
• Clear labeling (all axes, data points, legends)

Data Visualization Best Practices:

• Start Y-axis at zero (avoid misleading scales)
• Use color intentionally (green=good, red=bad, yellow=caution)
• Limit charts per page (1-2 for slides, 2-3 for documents)
• Include source and timestamp on all charts

Layout Standards:

• Executive summary always first
• Most important metrics at top/left
• Supporting details below/right
• Consistent header/footer on slides

Data Quality Standards

Accuracy Requirements:

• Revenue data: 100% accuracy (verified against Stripe)
• Product usage data: 99%+ accuracy (verified against database)
• Marketing data: 95%+ accuracy (best effort, multiple sources)
• Forecasts: Clearly labeled as projections, include confidence levels

Freshness Requirements:

• Daily reports: Data as of 6:00 AM same day
• Weekly reports: Data as of end of previous week
• Monthly reports: Data as of end of previous month (2-day close)
• Quarterly reports: Data as of end of quarter (7-day close)

Data Validation:

• All revenue numbers cross-checked against accounting
• Product metrics validated against multiple sources
• Outliers investigated before reporting
• Anomalies flagged and explained

Content Standards

Executive Summary Requirements:

• 1 page maximum (or 1 slide)
• 3-5 key takeaways (bullets)
• Traffic light status indicators
• 1-3 critical decisions needed

Narrative Standards:

• Lead with insight, not data ("Sales are up 10% because..." not "Sales: $X")
• Explain variances >5% (why did metric change?)
• Provide context (vs target, vs last period, vs expectation)
• Include "so what" (why this matters, what to do about it)

Action Items:

• Clearly stated (who, what, when)
• Realistic and achievable
• Tracked in next report
• Prioritized (critical, important, nice-to-have)

Report Review Process

Weekly Report Review

Monday Morning Process:

1. 8:00 AM: Automated reports delivered
2. 8:30 AM: Analytics team reviews for anomalies
3. 9:00 AM: Weekly business review email sent
4. 9:30 AM: Department heads review with teams
5. 2:00 PM: Executive team discusses (30 min weekly meeting)

Quality Checks:

• Data completeness (all sources updated)
• Calculation accuracy (spot-check formulas)
• Narrative clarity (proofread for typos)

Monthly Report Review

First Thursday Process:

1. Monday: Analytics team compiles data
2. Tuesday: CFO reviews financial sections
3. Wednesday: CEO reviews full deck, adds narrative
4. Thursday: MBR presentation to leadership team
5. Friday: Deck finalized and archived

Review Checklist:

• [ ] All data sources updated through month-end
• [ ] Revenue numbers match accounting records
• [ ] Charts and graphs render correctly
• [ ] Narrative explains key variances
• [ ] Action items are specific and assigned
• [ ] Deck timing fits 90-minute meeting

Quarterly Report Review

QBR Process (2-week timeline):

1. Week 1, Mon-Wed: Data collection and compilation
2. Week 1, Thu-Fri: CFO financial review, CEO strategic review
3. Week 2, Mon-Tue: Executive team review and refinement
4. Week 2, Wed: Final deck to board (3 days advance)
5. Week 2, Thu or Fri: Board meeting presentation
6. Following Mon: Investor update distribution

Board Packet Components:

• QBR slide deck (40 slides)
• Monthly financial statements (3 months)
• Sales pipeline report
• Product roadmap (next 2 quarters)
• Risk register
• Supporting appendices

Report Archive and Access

Archive Policy

Retention Periods:

• Daily reports: 90 days
• Weekly reports: 2 years
• Monthly reports: 5 years (or indefinitely)
• Quarterly reports: Indefinite (permanent record)

Storage Location:

• Google Drive: /YeboLearn/Analytics/Reports/[Year]/[Type]
• Metabase: Dashboards saved with snapshots
• Physical copies: Quarterly board decks only (CFO office)

Versioning:

• All reports timestamped
• Revisions tracked (v1, v2, final)
• Original never deleted (even if errors found)

Access Control

By Role:

• Executives: Access to all reports, all time periods
• Department Heads: Access to their department + company summaries
• Managers: Access to team reports + limited company metrics
• Individual Contributors: Access to relevant team metrics only
• Board Members: Access to monthly summaries + quarterly full decks

External Access:

• Investors: Quarterly updates only (no dashboard access)
• Advisors: Upon request, CEO approval required
• Press/Public: No access (public metrics TBD post-Series A)

Continuous Improvement

Report Feedback

Quarterly Report Survey:

• Send to all report recipients
• Questions: Usefulness (1-5), Timeliness (1-5), Accuracy (1-5), Suggestions (open)
• Target: 4+ average on all metrics
• Act on feedback within 30 days

Recent Improvements (Based on Feedback):

• Added traffic light indicators (easier to spot issues)
• Reduced slide count in monthly decks (20 → 19 slides)
• Added "so what" narrative (explain why metrics matter)
• Automated daily reports (was manual, error-prone)

Report Roadmap

Q1 2026 Improvements:

• Add customer cohort retention visuals
• Automate sales funnel waterfall chart
• Create role-specific weekly digests
• Launch mobile-friendly report emails

Q2 2026 Improvements:

• Implement predictive analytics in reports
• Add competitive benchmarking section
• Create customer-facing product usage reports
• Build natural language query interface

Next Steps

For specific report templates and examples:

• Executive Reports - Board-level and executive summaries
• Operational Reports - Daily, weekly, and team reports
• Business Analytics - Underlying data and analysis framework