RetailPulse — E-commerce Analytics Dashboard

UK-based online retailer · Dec 2009 – Dec 2010 · Built by Vaibhav Viraj

Total Revenue
£8.83M
407,664 transactions
Unique Customers
4,312
Across 37 countries
Unique Products
4,017
Gift & home decor items
Champion Customers
1,288
29.9% of customer base

Monthly Revenue Trend

Revenue peaks in Q4 (Oct–Nov 2010), driven by seasonal gift purchasing. November 2010 was the strongest month at £1.17M — nearly double the January trough of £557K.

Customer Segments — RFM Analysis

29.9% of customers are Champions — high recency, frequency, and spend. 25% are Lost, representing a significant re-engagement opportunity.

Revenue by Country

The UK accounts for 83.95% of all revenue. Ireland and Netherlands are the strongest international markets.

Top 10 Products by Revenue

The White Hanging Heart T-Light Holder leads with £151K in revenue. The Regency Cakestand generates high revenue despite lower unit volume — indicating strong pricing power.

RFM Segment Details

Segment Customers Avg Days Since Purchase Avg Orders Avg Spend (£) Recommended Action
Champion 1,28818 days9.7£4,970 Reward & retain — loyalty programme
Loyal 60325 days2.3£586 Upsell — product bundles & recommendations
Potential Loyalist 78283 days3.8£1,488 Nurture — personalised email campaigns
New Customer 29930 days1.0£361 Onboard — welcome series, first repeat discount
At Risk 26484 days1.0£435 Re-engage — win-back offer
Lost 1,076240 days1.8£642 Last chance — deep discount reactivation