A/B Testing Tracking Excel Template

This template helps you organize and manage all your digital marketing A/B tests in one location. A/B testing, or split testing, is an experiment where two or more versions of a variable are compared to determine which one performs better.

On the "Tests" sheet, click the "New Test" button in the top-right corner. In the "Create a Test" window, complete the required fields across the three sections: Details, Stakeholders, and Hypothesis & Results. Click "Confirm" to add the test to your list.

From the "Tests" sheet, click the "View" button on the test you wish to manage. On the test details page, click "Edit Test" to open a window, make your changes, and click "Save". To remove the test, click "Delete Test" and confirm your choice.

On the "Tests" sheet, use the filter panel to make your selections. To select multiple options in one filter, hold the CTRL key while clicking. Click "Apply Filters" to update the list. If the panel is not visible, click the "Hide/Show Filters" button.

Yes. Go to the "Settings" sheet to edit the labels for each of the five testing stages.

Navigate to the "Team Members" sheet and use the tabs to switch between the "Teams" and "Team Members" lists. In either list, use the "New", "Edit", and "Delete" buttons to manage entries. You can also reorder the Team Members list using the "Move Up" and "Move Down" buttons.

Go to the "KPIs" sheet. On this page, you can add a new KPI by clicking "New KPI", or select an existing one to "Edit" or "Delete". Use the "Move Up", "Move Down", and "Sorting" buttons to organize the list.