In competitive sales environments, understanding the balance between acquiring new customers and retaining existing ones is fundamental to sustainable growth. New customer acquisition drives market expansion, while customer retention signals satisfaction, loyalty, and long-term revenue stability. This project examined transactional sales data to assess how well the organisation is performing on both fronts and to determine which sales representatives and product categories are driving those outcomes.
The analysis aimed to answer four interconnected questions: how customer volume is distributed across sales representatives, how each representative balances acquisition versus retention, which product categories attract new versus returning customers, and how individual sales representatives perform across each product category. Together, these questions reveal where commercial energy is being directed, and whether that direction is producing the right results.
The dataset comprised 1,000 sales transactions across four product categories; Clothing, Electronics, Food, and Furniture handled by five sales representatives: David, Eve, Bob, Alice, and Charlie. Each record captured the sales representative, product category, customer type (New or Returning), region, sales amount, discount, payment method, and sales channel. The data provides a comprehensive cross-section of sales activity across the organisation.
The analysis was conducted in Power BI, using interactive visuals including donut charts, grouped bar charts, and tabular breakdowns to compare acquisition and retention performance across multiple dimensions. Customer counts and percentage distributions were calculated for each sales representative and product category. All figures are derived directly from the transactional dataset without external benchmarking or forecasting.
Across 1,000 total customer interactions, the split between new and returning customers is strikingly balanced: 504 new customers (50.4%) against 496 returning customers (49.6%). At the portfolio level, this near-perfect equilibrium suggests the organisation is neither over-relying on acquisition at the expense of loyalty, nor coasting on retention while neglecting growth. But when that aggregate is disaggregated by sales representative and product category, more nuanced, and actionable, patterns emerge.
Customer volume is not shared equally across the sales team and the distribution reflects meaningful differences in workload, territory size, or individual effectiveness.
David leads the team with 22.2% of all customers (222 transactions), followed closely by Eve at 20.9% (209) and Bob at 20.8% (208). These three representatives collectively handle nearly two-thirds of all customer interactions, 64% of the total portfolio.
Alice (19.2%, 192 customers) sits just below the midpoint, while Charlie trails the team at 16.9% (169 customers) , a gap of over 50 customers compared to David. Whether this reflects territory allocation, product specialisation, or individual performance, the disparity warrants attention.
Bottom line: David, Eve, and Bob are the highest-volume representatives. Charlie’s lower share should be investigated whether the cause is structural (smaller territory) or performance-related, the finding should not be left unexamined.
Volume tells us how much each representative is doing. The acquisition-retention split tells us what kind of business they are building.
David and Eve are the team’s strongest acquisition performers, maintaining new customer rates of 23.21% and 21.83% respectively. They are the primary drivers for expanding the customer base a function critical for long-term growth, though often more resource-intensive. Bob presents the most striking contrast: while his acquisition rate is lower at 19.25%, he leads the team in retention with a 22.38% returning customer rate. This signals that his existing customers have high trust in his management, which provides immense value through lower acquisition costs and higher lifetime value.
Alice maintains a highly balanced profile, with nearly identical performance across both acquisition (19.05%) and retention (19.35%). Charlie follows a similar balanced pattern, though his rates are the lowest on the team at 16.67% and 17.14%, suggesting his overall volume in both pools is smaller in absolute terms.
Bottom line: David and Eve act as the team's acquisition engines, while Bob serves as the retention anchor. A well-structured strategy would pair Bob’s relationship-building strengths with the acquisition momentum of David and Eve, rather than measuring all representatives against a single, uniform standard.
Product categories are not equal in their ability to attract new customers or sustain returning ones, and the data reveals a clear divide.
Clothing is the strongest acquisition category, drawing 143 new customers against 125 returning, a new-customer majority of 53.4%. Similarly, Electronics skews toward acquisition with 136 new versus 110 returning customers (55.3% new). These two categories appear to attract first-time buyers, possibly driven by promotional activity, seasonal demand, or broader market appeal.
Furniture tells the opposite story. With 146 returning customers against only 114 new ones, it has the highest retention count of any category, and is the only category where returning customers outnumber new ones by a notable margin (56.2% returning). Furniture purchases tend to be high-consideration, high-value decisions, which naturally fosters repeat engagement with trusted sellers.
Food is the most balanced category, with 111 new and 115 returning customers, a near-equal split that suggests consistent, habitual purchasing behaviour with a steady pipeline of new entrants.
Bottom line: Clothing and Electronics are acquisition-led categories that benefit from visibility and promotional investment. Furniture is the organisation’s loyalty stronghold and should be nurtured with relationship-focused strategies. Food offers the most stable, predictable demand base.
When performance is broken down by product category, each representative’s strengths and gaps come into sharper focus.
David is the highest performer in Clothing (62 customers) and Furniture (60), making him the most versatile representative on the team across high-value categories. His consistent performance across all four categories supports his position as the team’s top contributor by volume.
Eve leads in Electronics (53 customers) and Clothing (63), the two highest-acquisition categories. Her strength in these areas aligns with her overall acquisition-first profile, suggesting she is particularly effective at converting first-time buyers in product lines with broad appeal.
Bob stands out in Food (55) and Furniture (57), both categories with strong retention characteristics. This reinforces the pattern seen in Q2: Bob excels in categories where repeat purchases and customer relationships matter most.
Alice shows the most even distribution across categories, with no single standout area. Her performance ranges from 44 (Food) to 52 (Electronics), reflecting a generalist profile. Charlie records the lowest numbers across all four categories, with Food being his weakest at just 36 customers, a gap that is particularly visible compared to Bob’s 55 in the same category.
Bottom line: Specialisation is emerging naturally within the team. Aligning David and Eve more deliberately to Clothing and Electronics, and Bob to Furniture and Food, could sharpen overall performance. Charlie needs targeted category support or coaching to close the gap.
The near-perfect 50/50 split between new and returning customers is a headline figure that masks a far more interesting story underneath. The organisation has five sales representatives with clearly differentiated acquisition and retention profiles, four product categories with distinct customer loyalty dynamics, and a performance spread that suggests untapped potential in how the team is structured and deployed.
The opportunity here is not simply to improve the lowest performers, it is to intentionally design a team strategy that plays to each representative’s natural strengths. Acquisition-oriented representatives should be pointed at high-potential new markets. Retention-oriented representatives should own the most loyal customer segments. And category alignment should follow the data, not convention.
Done well, this kind of targeted deployment could improve both acquisition yield and retention rates simultaneously without adding headcount or increasing the marketing budget.