Comparing customer value by product entry point

Compare customer value by product entry point by assigning each customer to a group from their first qualifying order, then measuring each group's value at the same completed age. The entry product describes the group; it does not establish that the product caused later spending.

Assign each customer once

Use the first qualifying order, rather than the first product viewed. A first order may contain several items, so choose an assignment rule before reading the results: put multi-product first orders in their own group, or select a primary item under a stated line-item rule.

Choosing the highest-value line, for example, makes the grouping sensitive to product price.

If customers can appear in several product groups, label those groups as overlapping and do not add their entrant counts. For mutually exclusive rows, count each customer once. Preserve stable product or variant IDs and a dated mapping when catalogue names change.

Use first-order lines when that distinction matters.

Compare equal follow-up

For each group, report the entrant count, the count with a complete observation window, qualifying value for those complete-window entrants and value per entrant. Keep the order-status, currency, discount and adjustment rules consistent. Customers who do not buy again remain in the denominator.

Show entry-order value separately from value on later orders. A costly first item can lift short-window value even if later purchasing is similar. Keep multi-product and unassigned customers visible so a ranking does not hide assignment gaps.

A replenishable item and a durable item may also serve different buying occasions. Compare first-order price, offer, stock availability and customer mix before interpreting a value gap. If reliable costs exist, a separately labelled contribution view may support a different decision from sales value.