Each of the previous four lessons in this course produces its own record, a baseline, a test setup, a result judgement, a funnel diagnosis, and kept apart, none of these records tells a new reviewer the full story of what has already been tried on a given page and why. A single connected worksheet lets anyone open one product's own row and see its whole digital history at a glance.
This lesson gives you the method a hybrid retailer uses to assemble all four earlier records into one complete worksheet. You will apply it to Fairway Stores' own online store, building the connected record for a Cedar & Co. domestic style sold through Fairway's hybrid channel mix, because a retailer managing many pages needs one place that shows a page's own baseline, its tests, and its outcome together, not four disconnected spreadsheets.
You need: the ideas from Lessons 2.1 to 2.4, reading a baseline, setting up a fair test, judging its result, and diagnosing a weak funnel stage, are useful background but not required; this lesson explains how each fits into the combined worksheet.
By the end of this lesson you can:
Not covered here: the detailed method for taking a baseline reading (Lesson 2.1), setting up a one-variable test (Lesson 2.2), judging a test's own result (Lesson 2.3), or diagnosing a weak funnel stage (Lesson 2.4); this lesson only teaches how to connect all four into one worksheet.
| Term | Meaning |
|---|---|
| Baseline reading | A page's own conversion figures for a fixed period, taken before any change, used as the point every later comparison is measured against. |
| One-variable test | A test in which exactly one element of a page changes between the control and the test variant, so any difference in result can be attributed to that element alone. |
| Meaningful gap | A difference between two variants' own results large enough to be trusted as real, not just noise. |
| Drop-off point | The specific funnel stage where the share of visitors continuing to the next stage falls furthest below what the same store's other pages typically show. |
| Linked sheet | A worksheet sheet whose rows connect to another sheet's rows for the same page, so the full record can be followed across them. |
| Tracker owner | The person or team responsible for keeping every sheet of the worksheet current and complete. |
| Handover | Passing a page's own record to a new reviewer or team, complete enough that they do not need to ask the previous owner what happened. |
A baseline reading recorded in one file, a test logged in another, and a diagnosis written in a third, each still accurate on their own, tell an incomplete story once separated, because no single document shows how they connect to the same page over time.
| What can differ | The shapes you meet | Why it matters to you |
|---|---|---|
| Business model | A hybrid retailer like Fairway Stores, selling both wholesale-sourced and its own directly-managed online styles, needs the worksheet to note which channel a given page's own figures came from, since a wholesale-sourced style's page may be managed differently than a directly-owned one. | The worksheet should record channel context, not just numbers, so a later reviewer reads each figure in its right context. |
| Market | A domestic style sold through one country's version of a page keeps its worksheet simple. An export style sold across several countries' pages needs either one row per country or a clear note that figures are combined, so no reviewer mistakes a blended figure for a single-country result. | The worksheet's own structure should match how many market variants a given page actually has. |
| Number of pages managed | A retailer with a small number of hero styles can review every linked row personally. A retailer managing hundreds of product pages needs a clear tracker owner and a routine for flagging record gaps, since no one person can hold every page's history from memory. | Scale changes how ownership and review routine are organized, not whether the four sheets should be linked. |
| Team turnover | A page whose original tester has since left the team is only safely handed over if the worksheet's own record is complete enough to stand alone, without needing that person's memory to fill in gaps. | A well-kept worksheet protects a page's own history against the loss of institutional memory when people move on. |
Fairway Stores, a department-store chain running a hybrid mix of wholesale-sourced styles and its own directly-managed online catalogue, sells a Cedar & Co. domestic T-shirt style online alongside its export-sourced Northline Apparel lines. Over several months, the digital team has taken a baseline reading of the page, run a one-variable test on the product description, checked whether the test's result was meaningful, and, once conversion still lagged, diagnosed the page's own funnel to find the weak stage.
Each of these four steps was recorded separately at the time it happened. Building the complete worksheet means pulling all four into one linked row for this single page, so the full sequence is visible without opening four different files.
The worked numberOne linked row shows the full sequence: a directional result that became meaningful once more traffic was collected, followed immediately by the next diagnosed weak stage, so the next reviewer starts from where the page's own history actually left off, rather than repeating work already done.
A team member who starts a fresh test on a page's checkout button colour, without first checking that a previous team member already ran, and never finished judging, a test on the exact same button the month before, wastes a full test period repeating work that was already partly done. The cost of this mistake is not just the wasted test period; it is the confusion of two overlapping, disconnected test records for the same page that now cannot be cleanly compared against each other.
Instead of keeping a page's baseline number, its test log, its result judgement, and its funnel diagnosis in four separate places, put them all under one row for that page. That way, anyone who opens the page's record sees exactly what has already been measured, tested, and found, in the order it happened. Make one person responsible for keeping that row current, and always hand the full row over when a page changes hands, so nothing has to be remembered instead of read.
A new digital team member, unfamiliar with the page's history, is asked to find a quick improvement for the Cedar & Co. T-shirt page this month. Before proposing anything, they open the worksheet's linked row for this page.
Should the new team member propose testing the product description again this month? Decide before opening the answer.
No. The worksheet's own linked row shows the description test is already complete and rolled out; the open item is the add-to-cart gap, which has not yet been tested.
1. Testing the description again would repeat work already finished and confirmed, wasting a test period on a question already answered. 2. The worksheet clearly flags an open, untested gap at add-to-cart, which is where new effort is actually needed. 3. Checking the linked row before proposing anything is exactly what the worksheet exists to make possible, avoiding the repeated-test trap this lesson warns against.
Order A's T-shirt carries a shop price of USD 19.90 per piece (docs/02 section 7), and Cedar & Co.'s comparable domestic style sells at a similar price point through Fairway's own online store. If the new team member had run a redundant four-week description test instead of addressing the flagged add-to-cart gap:
Four wasted weeks at this rate is not a rounding error; it is close to USD 1,750 in recoverable sales delayed purely because the page's own already-recorded history was not checked first.
Use the T23-C02 Digital analytics and testing worksheet, "Complete worksheet" sheet, which draws each page's own baseline, test setup, significance check, and funnel diagnosis into one linked row. Start with Fairway Stores' Cedar & Co. T-shirt example above, then link your own page's records.
[Download the Digital analytics and testing worksheet](../../templates/T23-C02-digital-analytics-and-testing-worksheet.xlsx)
Download the Digital analytics and testing worksheet (Excel)
1. Why does linking a page's baseline, test setup, significance check, and funnel diagnosis into one row help more than keeping four separate, accurate records?
2. A new team member almost re-tests a page element that a previous, unfinished test already covers. What does the worksheet's linked row prevent here?
3. Why should a page have one clear tracker owner responsible for keeping its worksheet row current?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Baseline reading | القراءة الأساسية | Relevé de référence | Referans okuma | A page's own conversion figures for a fixed period, taken before any change, used as the point every later comparison is measured against. |
| One-variable test | اختبار متغيّر واحد | Test à une seule variable | Tek değişkenli test | A test in which exactly one element of a page changes between the control and the test variant, so any difference in result can be attributed to that element alone. |
| Meaningful gap | فارق ذو دلالة | Écart significatif | Anlamlı fark | A difference between two variants' own results large enough to be trusted as real, not just noise. |
| Drop-off point | نقطة التسرب | Point de décrochage | Kopma noktası | The specific funnel stage where the share of visitors continuing to the next stage falls furthest below what the same store's other pages typically show. |
| Linked sheet | ورقة مرتبطة | Feuille liée | Bağlı sayfa | A worksheet sheet whose rows connect to another sheet's rows for the same page, so the full record can be followed across them. |
| Tracker owner | مالك المتتبع | Propriétaire du suivi | Takip listesi sahibi | The person or team responsible for keeping every sheet of the worksheet current and complete. |
| Handover | التسليم | Transmission | Devir | Passing a page's own record to a new reviewer or team, complete enough that they do not need to ask the previous owner what happened. |
This is the last lesson of Course 2. Continue to Course 3 of Track 23 when it is published, to keep building your e-commerce and digital merchandising skills beyond a single page's own analytics and testing. Back to the course map