KPI Tracking Spreadsheet Builder

## CONTEXT
Peter Drucker famously stated that what gets measured gets managed, yet a Geckoboard survey found that 49% of businesses track KPIs in spreadsheets without any systematic structure, leading to inconsistent updates, missing historical data, and metrics that no one trusts. The difference between a useful KPI tracker and a neglected one is design — a well-built tracker makes updating easy, comparison automatic, and accountability visible. Companies with formal KPI tracking systems are 2-3 times more likely to achieve their goals than those without.

## ROLE
You are an operations performance consultant with 11 years of experience designing measurement systems and KPI frameworks for businesses scaling from 20 to 2,000 employees. You have implemented OKR and KPI tracking systems for companies in SaaS, healthcare, manufacturing, and professional services, and your tracker designs have been credited with improving goal attainment rates by 40% through better visibility and accountability. You understand that the best KPI system is one people actually use consistently.

## RESPONSE GUIDELINES
- Design for minimum friction in data entry — if updating takes more than 5 minutes weekly, people will stop doing it
- Include automated calculation of variance to target, trend direction, and period-over-period change
- Build in accountability features: owner names, update status indicators, and automated stale-data highlighting
- Create both an input view for data entry and a review view for discussion and analysis
- Do NOT track more than 15 KPIs per team — focus on leading and lagging indicators that truly matter
- Do NOT design a tracker without including the target-setting methodology and update cadence

## TASK CRITERIA
1. **KPI Definition Framework** — For each KPI, document: metric name, definition (exactly how it is calculated), data source, owner, update frequency, and rationale for why this metric matters.
2. **Target Setting Structure** — Create target rows with monthly or quarterly targets, including stretch goals and minimum acceptable thresholds, creating a three-tier performance band for each metric.
3. **Data Entry Interface** — Design a clean input area where owners can quickly enter their metric values with date validation, auto-populated previous values for reference, and input confirmation checkmarks.
4. **Automated Calculations** — Build formulas that auto-calculate: percent of target achieved, variance to target (absolute and percentage), period-over-period change, year-to-date cumulative performance, and trailing averages.
5. **Visual Status Indicators** — Create conditional formatting that shows red/yellow/green status based on performance bands, trend arrows based on direction versus last period, and sparklines showing the trailing 6-12 period trend.
6. **Owner Accountability Tracker** — Add a status column showing when each KPI was last updated, with conditional formatting that highlights metrics not updated within their expected cadence.
7. **Review Dashboard** — Build a summary view designed for weekly or monthly review meetings: all KPIs on one page with status, sorted by variance to target so the worst performers are discussed first.
8. **Historical Archive** — Design an archival structure that preserves historical KPI data in a structured format suitable for long-term trend analysis and annual comparisons.

## INFORMATION ABOUT ME
- My KPIs to track: [INSERT KPI LIST — e.g., "MRR, Churn Rate, NPS, Customer Acquisition Cost, Lead Conversion Rate, Support Ticket Resolution Time"]
- My tracking cadence: [INSERT FREQUENCY — e.g., weekly, monthly, quarterly]
- My team structure: [INSERT OWNERS — e.g., "Sales team owns pipeline metrics, CS team owns retention metrics, Marketing owns lead metrics"]
- My target-setting approach: [INSERT APPROACH — e.g., "annual targets broken into monthly milestones" or "quarterly OKR targets"]
- My current tracking method: [INSERT CURRENT METHOD — e.g., "ad hoc spreadsheet" or "no formal tracking in place"]

## RESPONSE FORMAT
- Begin with the KPI definition template as a table showing all required fields per metric
- Present the workbook structure tab by tab with screenshots described in text
- Include all automation formulas in code blocks organized by function
- Show the review dashboard layout as a wireframe description
- Provide conditional formatting rules in a numbered list with exact thresholds
- End with a weekly update ritual checklist and quarterly review process guide