A small group contributes a large share of revenue
High-value repeat customers represented 660 customers, or 8.0% of the customer base, but generated $740K, approximately 27.0% of total revenue.
A customer-behavior analysis using a U.S. transaction dataset to identify differences in value, purchasing frequency and recent activity.
BUSINESS SITUATION
A business had a growing customer base and a large transaction history, but customer value and activity varied considerably. Management wanted a clearer way to distinguish repeat, new, occasional and less-active customers using consistent customer-level measures.
DATASET
Customer and transaction records covering 8,240 customers and 38,460 transactions.
DATA PREPARATION
Validated customer identifiers, transaction dates and transaction values before customer-level aggregation.
Aggregated transaction history to one analytical record per customer while preserving transaction counts and total historical value.
Calculated recency from the end of the analysis period, purchase frequency from transaction counts and monetary value from transaction totals.
Created mutually exclusive behavioral segments so every customer is represented once in the segment summaries.
METHOD
Aggregated transactions to the customer level.
Calculated recency, purchase frequency and customer monetary value.
Grouped customers into business-friendly behavioral segments.
Compared customer counts and revenue contribution across segments.
Reviewed the distribution of value and activity to identify materially different customer groups.
KEY METRICS
VISUAL ANALYSIS
KEY FINDINGS
High-value repeat customers represented 660 customers, or 8.0% of the customer base, but generated $740K, approximately 27.0% of total revenue.
The Regular segment generated $760K from 1,920 customers, slightly exceeding the revenue contribution of the High-value repeat segment.
The analysis separates recent and repeat behavior from customers with lower frequency or longer gaps since their last purchase, making the customer base easier to prioritize for further analysis.
The At-risk segment contains 1,080 customers and $340K in historical revenue, making it materially different from the Inactive segment and useful for retention-focused analysis.
SUPPORTING TABLES
| Segment | Customers | Revenue | Average Revenue / Customer |
|---|---|---|---|
| High-value repeat | 660 | $740K | $1,121 |
| Regular | 1,920 | $760K | $396 |
| New | 1,720 | $320K | $186 |
| Occasional | 2,130 | $390K | $183 |
| At-risk | 1,080 | $340K | $315 |
| Inactive | 730 | $190K | $260 |
BUSINESS INTERPRETATION
The segmentation shows why customer count alone is not enough to understand the customer base. Revenue contribution, frequency and recency create materially different groups that can be analyzed separately for retention, CRM and customer-value planning.
VALIDATION
DECISION USE
Use the High-value repeat group as a priority population for deeper retention and product-mix analysis because 8.0% of customers account for about 27.0% of historical revenue.
Test retention questions on the 1,080 At-risk customers separately from the Inactive group rather than treating all less-recent customers as one population.
For recurring analysis, measure how customers move between New, Regular, At-risk and other states over time instead of treating the segmentation as a one-time label.
LIMITATIONS
DELIVERABLE
BUSINESS VALUE
The output gives management a clearer customer-level view and a structured basis for deciding which groups warrant deeper retention, acquisition or lifecycle analysis.
NEXT