Performance Measurement Frameworks & Templates Collection

Artifact

Performance Measurement Frameworks & Templates Collection

Core frameworks and templates for KPI alignment, analytics setup, and performance tracking.

Essential frameworks, templates, and tools for performance tracking, analytics, and data-driven marketing.

KPI Framework Templates

KPI Alignment Worksheet

A structured template to map KPIs to business objectives:

Columns:

  1. Business Objective
  2. Marketing KPI
  3. Target Value
  4. Current Value
  5. Owner
  6. Reporting Frequency
  7. Data Source

Use this to ensure every metric ties to a strategic goal.

SMART Goals Template for Metrics

Define each KPI using SMART criteria:

  • Specific: What exactly are you measuring?
  • Measurable: How will you quantify it?
  • Achievable: Is the target realistic?
  • Relevant: Does it align with business goals?
  • Time-bound: What's the deadline?

Example:

"Increase Marketing Qualified Leads (MQLs) from 200 to 300 per month (+50%) by end of Q2 to support the company's $2M ARR goal."

Dashboard Templates

Marketing Channel ROI Dashboard

Purpose: Compare all marketing channels in one view

Key Components:

  • Spend by channel (bar chart)
  • Leads generated by channel (bar chart)
  • Cost per lead by channel (table)
  • ROI % by channel (sorted table)
  • Pipeline created by channel (stacked area chart)

Tools: Google Data Studio, Tableau, Power BI

Executive Marketing Dashboard

Purpose: High-level snapshot for leadership

Key Components:

  • North Star Metric (big number)
  • Revenue/Pipeline vs. Target (gauge)
  • Lead volume trend (line chart)
  • Conversion funnel (funnel visual)
  • Top 3 performing campaigns (table)
  • Month-over-month comparison (summary)

Refresh: Weekly or monthly

Product Engagement Dashboard

Purpose: Track user behavior and retention

Key Components:

  • Daily/Weekly/Monthly Active Users (line chart)
  • Cohort retention curve (line chart by cohort)
  • Feature adoption rate (bar chart)
  • User journey funnel (funnel visual)
  • Activation rate (gauge)

Tools: Amplitude, Mixpanel, custom SQL + BI tool

Campaign Performance Dashboard

Purpose: Deep dive into specific campaign results

Key Components:

  • Spend vs. Budget (gauge)
  • Impressions/Clicks/Conversions over time (line chart)
  • CTR and Conversion Rate trends (dual-axis line chart)
  • Geographic performance (map)
  • Device/Platform breakdown (pie chart)
  • Cost per acquisition by segment (table)

Analytics Frameworks

AARRR (Pirate Metrics) Framework

Dave McClure's framework for tracking the customer lifecycle:

  1. Acquisition: How users find you (traffic, impressions, visitors)
  2. Activation: First positive experience (signups, activated users, "aha moment")
  3. Retention: Users coming back (DAU/MAU ratio, cohort retention)
  4. Referral: Users bringing others (viral coefficient, NPS)
  5. Revenue: Monetization (MRR, ARPU, LTV)

Use this to organize your metrics by funnel stage.

North Star Metric Framework

Identify the ONE metric that best captures the core value your product delivers:

Examples:

  • Slack: "Messages sent by team"
  • Airbnb: "Nights booked"
  • Spotify: "Time spent listening"

Your North Star should:

  • Reflect customer value
  • Predict revenue growth
  • Be measurable daily/weekly
  • Unite the team around one goal

Attribution Model Decision Framework

Choose based on your sales cycle:

Sales Cycle Recommended Model Why
Short (<1 week) Time Decay or Last Touch Recent actions matter most
Medium (1-3 months) U-Shaped or Linear Balance first and last touch
Long (3-6+ months) W-Shaped or Full Path Credit key milestone stages
Complex B2B Custom / Algorithmic Account for multiple influencers

Analysis Templates

Experiment Tracker Spreadsheet

Purpose: Log all A/B tests and experiments

Columns:

  1. Experiment Name
  2. Hypothesis
  3. Start Date / End Date
  4. Test Group vs. Control
  5. Sample Size
  6. Primary Metric
  7. Result (Win/Loss/Neutral)
  8. Confidence Level
  9. Decision (Ship/Kill/Iterate)
  10. Learnings

Keep a running log to build institutional knowledge.

Cohort Analysis Excel Template

Pre-formatted spreadsheet with:

  • Cohort data input table
  • Automatic retention % calculations
  • Retention curve chart
  • Churn rate by month
  • LTV projection based on retention

Available as Google Sheets template (free)

Weekly Growth Meeting Agenda Template

Structure for efficient data reviews:

  1. Metrics Review (10 min)
    • North Star Metric: Current vs. Target
    • Key funnel metrics
    • Week-over-week changes
  2. Channel Performance (10 min)
    • What's working?
    • What's not?
    • Budget adjustments needed?
  3. Experiments Update (10 min)
    • Tests completed this week
    • Results and learnings
    • Next tests to launch
  4. Action Items (5 min)
    • Decisions made
    • Owners assigned
    • Follow-up dates

Tools & Software

Dashboard & BI Tools

Free/Freemium:

  • Google Data Studio / Looker Studio
  • Metabase (open source)
  • Apache Superset (open source)

Paid:

  • Tableau ($70/user/month)
  • Power BI ($10/user/month)
  • Looker (custom pricing)
  • Mode Analytics (custom pricing)

Product Analytics Tools

  • Amplitude - Event-based product analytics
  • Mixpanel - User behavior tracking
  • Heap - Auto-capture analytics
  • PostHog - Open source product analytics

Attribution Tools

  • HubSpot Attribution - Built into Marketing Hub
  • Bizible - Enterprise attribution by Marketo
  • Dreamdata - B2B revenue attribution
  • Google Analytics 4 - Basic attribution models

Data Integration

  • Segment - Customer data platform
  • Fivetran - Automated data pipelines
  • Stitch - ETL for data warehouses
  • Zapier - No-code automation

Best Practice Checklists

Dashboard Design Checklist

  • Clear title describing dashboard purpose
  • Date of last update visible
  • Target or benchmark included for context
  • Filters for date range, channel, or segment
  • Color coding (green = good, red = bad)
  • Annotations for major events or anomalies
  • Mobile-responsive (if accessed on phone)
  • Load time under 5 seconds
  • Single page view (no scrolling if possible)
  • Export or share functionality

Data Quality Checklist

  • UTM parameters on all campaign URLs
  • CRM fields required for key data points
  • Regular data audits (quarterly)
  • Duplicate prevention rules in place
  • Naming conventions documented
  • Data dictionary available to team
  • Backup and recovery process established

Weekly Analytics Review Checklist

  • Review North Star Metric
  • Check top 5 KPIs vs. targets
  • Identify anomalies or outliers
  • Review experiment results
  • Update stakeholders on key findings
  • Document action items with owners
  • Schedule follow-ups for next week

Additional Resources

Books

  • "Lean Analytics" by Alistair Croll & Benjamin Yoskovitz
  • "Data Science for Business" by Foster Provost & Tom Fawcett
  • "Storytelling with Data" by Cole Nussbaumer Knaflic

Online Courses

  • Google Analytics Academy (free)
  • Tableau Training (free tier available)
  • Amplitude Scholarship (free product analytics certification)

Communities

How to Use These Resources

  1. Start with frameworks - Use AARRR and North Star to organize your thinking before building dashboards
  2. Pick 1-2 templates - Don't try to implement everything at once. Choose what solves your biggest pain point.
  3. Customize for your context - Adapt templates to your business model, tools, and team size.
  4. Build habits - Use the weekly meeting template to establish a rhythm of data review and action.
  5. Iterate - Your first dashboard won't be perfect. Gather feedback and refine monthly.

These templates accelerate your analytics implementation and help you avoid common pitfalls in data-driven marketing.