Back to Templates
GOOGLE SHEETS / EXCEL
A/B Testing Roadmap & Tracker
A structured framework to log, prioritize, and track your pricing experiments.
LIVE PREVIEW
| Test ID | Hypothesis | Status | Start Date | Metric | Control (A) | Variant (B) | Confidence | Winner |
|---|---|---|---|---|---|---|---|---|
| PR-001 | Ending price in .99 vs .00 increases conversion | Complete | 2023-10-01 | Conv Rate | 2.1% | 2.4% | 96% | Variant (.99) |
| PR-002 | Free Shipping threshold $50 vs $75 increases AOV | Running | 2023-10-15 | AOV | $62 | $78 | Pending | - |
| PR-003 | Displaying 'Best Value' badge on yearly plan | Planned | - | Take Rate | - | - | - | - |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Hypothesis First: Never run a test without writing down what you expect to happen.
- 2Sample Size: Use the 'Target Sample' column to record how many visitors you need before peeking at results.
- 3Winner Declaration: Only mark a 'Winner' if Statistical Significance > 95%.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Running pricing tests without a rigorous tracking system is a recipe for disaster.
Key Features
Hypothesis Builder: Dedicated columns.
Sample Size Calculator: Pre-built formulas.
Common Use Cases
Ecommerce Price Testing: Track impact.
SaaS Plan Structuring: Document tiers.
Frequently Asked Questions
Why use a spreadsheet?
Vendor-agnostic archive.