Skip to content
Open navigation
OpenOpen workspace

Worked exampleE-commerce and retail

Did sessions near a special shopping day end in a purchase more often?

Sessions with recorded revenue, by special-day proximity: Near a special day (score above zero): 77 of 1,251 (6.2%). Not near a special day (score zero): 1,831 of 11,079 (16.5%). The share was 10.4 percentage points lower for Near a special day (score above zero).

The table

Sessions with and without recorded revenue by special-day proximity. Percentages use each proximity column as the base.
Purchase in session \ Special-day proximityNear a special day (score above zero)Not near a special day (score zero)Total
Revenue recorded776.2%1,83116.5%1,908
No revenue recorded1,17493.8%9,24883.5%10,422
Total1,25111,07912,330

Count / Column %. Each column total is the base for that column’s percentages.

Shaded cells are the two shares the answer compares.

Use this result

  1. Reproduce it

    Open these exact counts in the chi-square calculator. It loads the same table, with the same category order, and computes the percentages, χ² and Cramér’s V in your browser. Change a cell to see how the result moves.

  2. Cite it

    Copy this reference. The data credit and licence below travel with it.

    Did sessions near a special shopping day end in a purchase more often? — Crosstabs. https://www.crosstabs.com/examples/rq26-purchasing-near-special-shopping-days

    Source

    Scope
    E-commerce website; country unspecified
    Period
    One-year sampling period; dataset released 2018. Calendar dates unspecified.
    One record is
    one recorded website session

    Data: C. Sakar, Yomi Kastro. Online Shoppers Purchasing Intention Dataset. UCI Machine Learning Repository.. Licensed under CC BY 4.0. Crosstabs selected, recoded and aggregated the records into this table.

    Download these counts: CSVJSON

  3. Run it on your file

    Open a CSV, Excel or SPSS file to build the same kind of table. The file is read in this browser tab: nothing is uploaded and no account is needed.

    Run a crosstab on your own data

Why ask this

Marketing calendars are built around special days. If sessions close to them convert better, the run-up deserves more spend; if not, traffic may rise without a matching rise in purchases.

How to read it

The source gives a continuous proximity score; here any score above zero counts as near a special day. Only 1,251 sessions are in that column, against 11,079 with a score of zero, so the near column rests on far fewer records.

Column percentages answer “within each column, how often does each row occur?”. Switch to row percentages and the question turns around: “of the records in this row, how were they split across the columns?”. Both are correct; they answer different questions, so say which one you used.

What it means

Sessions near a special day ended in a purchase less often, by a moderate margin. The proximity score is tied to particular times of year, so month and other calendar differences can sit behind the gap. It is an association in these sessions, not a sign that special days put shoppers off.

Cramér’s V = 0.087. It summarizes the whole table, all 2 × 2 categories, on a scale from 0 (no association) to 1. It does not say which cells differ, and it is not a measure of impact.

Comparing only Near a special day (score above zero) and Not near a special day (score zero), and only Revenue recorded against every other row, Cramér’s V = 0.087. That number describes this one contrast, not the whole table.

Limits

These are selected sessions from one website over one year. A recorded purchase is only yes or no: the file gives no order amount and no experimental assignment, so nothing here says what a change to the site would do. Turning the proximity score into a yes/no flag is a choice made for this lesson.

Keep exploring