customer journey, design thinking, designer, customer journey, customer journey, customer journey, customer journey, customer journey
Photo by Pexels on Pixabay

Funnel Analysis

Part of Ecommerce customer value analysis

Rules for grouping customer value by product entry point

Assign customers from their first-order products and compare observed value at the same age without hiding multi-item orders.

This is an editorial pen name used by the publication, not a claim of an independently verified personal identity. Original editorial credit: Desk Customer Analytics.

undefined

Group customers by product entry point by assigning each customer to one group from their first qualifying order, then measuring each group's value at the same completed age. Apply the same order-status, currency, discount and adjustment rules to every group so entrant counts and value figures are like-for-like. The entry product describes the group; it does not establish that the product caused later spending.

Assign each customer to a product entry point group

Use the first order that meets your stated order-status rule, rather than the first product viewed, to set each customer's entry point group. 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.

Write down the grouping rules before running the comparison and keep them unchanged when the figures arrive. Changing the assignment rule after seeing the results makes a favourable ranking easy to find and hard to trust. If a rule must change, rerun every group under the new rule and report both versions.

Key Metrics for Product Entry Point Grouping

Stable Variant IDs Preserved
Yes
Currency Used
AUD

Measure each entry point group at equal follow-up

For each entry point 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.

More from Funnel Analysis

Funnel Analysis

Analysing conversion by product variant

Define a variant conversion denominator using identified, available options and matched orders, with clear treatment of later purchases.