A/B Test Tracker Template

A free A/B test and ad creative testing template to plan experiments, log variants, and record results — capture your hypothesis, metrics, sample size, winner, and learning so testing compounds instead of getting forgotten.

15-20 minutesIntermediateCSV Spreadsheet
A/B test tracker template for planning and logging marketing experiments
Prefer to build it interactively?Try the A/B Test Significance Calculator — allocate live, then export.

Overview

Run disciplined experiments across ads, landing pages, and email — one row per test, capturing the hypothesis, what changed, the primary metric, sample size, result, and the decision so every test produces a documented learning.

What's Inside

  • Test ID, channel/surface (Meta, Google, landing page, email), and start/end dates.
  • Hypothesis and the single variable changed (the “what” and the “why”).
  • Control vs. variant: the primary metric (CTR, CVR, CPA, ROAS), sample size, and confidence.
  • Result, winner, % lift, and statistical-significance check.
  • Decision and learning: ship / iterate / kill, plus the insight to carry into the next test.

How to use this template

How to use the A/B test tracker template:

  1. Make a copy. Import the CSV into Google Sheets (File → Import) or open it in Excel, then save your own copy.
  2. Write the hypothesis. State what you believe and why, e.g. “A benefit-led headline will beat the feature-led control on CTR because it speaks to outcome.”
  3. Change one variable. Log the single element under test (headline, hook, thumbnail, CTA, audience). One variable per test keeps results attributable.
  4. Define success up front. Set the primary metric and the minimum sample size / duration before you launch — not after you peek at results.
  5. Run and record. Enter control vs. variant numbers, then check significance before declaring a winner (use the linked significance calculator).
  6. Decide and document. Mark ship / iterate / kill, the % lift, and the one-line learning.
  7. Compound it. Feed each winner into the next test so your creative and funnel improve continuously instead of resetting.

Pro tips

  • One variable at a time: Test a single element per experiment so a win is actually attributable to the change.
  • Decide significance first: Set your sample size and confidence threshold before launch to avoid calling winners on noise.
  • Log the losers: A “no difference” or losing test is still a documented learning — record it so the team doesn’t re-run it.
  • Prioritise by impact: Test the highest-leverage elements first (hook, offer, audience) before polishing minor details.

Example uses

Meta creative test

Three hook variations against one control, judged on 3-second view rate and CTR, with the winner promoted to the next round.

Landing page CVR test

Benefit-led vs. feature-led hero, measured on conversion rate with a pre-set sample size and significance check before shipping.

Works with

Google SheetsMicrosoft ExcelApple Numbers

Frequently asked questions