👥 Customer Activity Report
Service frequency and customer engagement analysis
Report Generated: 2025-07-10 22:45:48 UTC | User: Dad-Link | Period: Last 12 Months
Total Active Customers
892 returning, 355 new this year
New Customers
47 acquired this month
Returning Customers
71.5% retention rate
At-Risk Customers
No activity >6 months
Customer Segments by Value & Frequency
Customer Activity Details
Detailed customer engagement and service history analysis
Customer Name | Phone | Segment | Total Visits | Last Visit | Total Spent | Avg Visit Value | Primary Vehicle | Activity Level | Preferred Services | |
---|---|---|---|---|---|---|---|---|---|---|
Sarah Johnson | sarah.johnson@email.com | 07789 123456 | VIP | 18 | 2025-07-08 | £2,847.50 | £158.19 | 2019 BMW 3 Series |
|
Service, MOT, Repairs |
Michael Thompson | m.thompson@company.co.uk | 07890 234567 | VIP | 22 | 2025-07-05 | £3,245.80 | £147.54 | 2020 Audi A4 |
|
Premium Service, Diagnostics |
David Clark | david.clark@gmail.com | 07901 345678 | VIP | 15 | 2025-07-02 | £2,156.75 | £143.78 | 2018 Mercedes C-Class |
|
Service, MOT, Body Work |
Emma Wilson | emma.wilson@hotmail.com | 07912 456789 | Regular | 12 | 2025-07-09 | £1,456.20 | £121.35 | 2017 Ford Focus |
|
Service, MOT |
James Wilson | james.wilson@outlook.com | 07923 567890 | Regular | 9 | 2025-06-28 | £1,234.50 | £137.17 | 2016 Volkswagen Golf |
|
Service, Repairs |
Lisa Garcia | l.garcia@email.co.uk | 07934 678901 | Regular | 11 | 2025-07-01 | £1,567.80 | £142.53 | 2018 Nissan Qashqai |
|
Service, MOT, Tyres |
Robert Lee | robert.lee@gmail.com | 07945 789012 | Regular | 8 | 2025-07-10 | £1,089.40 | £136.18 | 2015 Toyota Corolla |
|
Service, Diagnostics |
Jennifer Taylor | jen.taylor@yahoo.com | 07956 890123 | Occasional | 5 | 2025-06-15 | £567.90 | £113.58 | 2014 Honda Civic |
|
MOT, Basic Service |
Andrew Davis | a.davis@btinternet.com | 07967 901234 | Occasional | 6 | 2025-05-22 | £678.45 | £113.08 | 2013 Vauxhall Astra |
|
Service, MOT |
Catherine Miller | cat.miller@live.com | 07978 012345 | Occasional | 4 | 2025-06-08 | £445.80 | £111.45 | 2012 Peugeot 207 |
|
MOT, Repairs |
Thomas Anderson | thomas.anderson@gmail.com | 07989 123456 | New | 3 | 2025-07-07 | £456.75 | £152.25 | 2021 Tesla Model 3 |
|
Diagnostics, Service |
Maria Rodriguez | maria.rodriguez@hotmail.co.uk | 07990 234567 | New | 2 | 2025-07-03 | £287.50 | £143.75 | 2019 Hyundai i30 |
|
Service, Parts |
Kevin Thompson | kevin.thompson@outlook.com | 07901 345678 | New | 1 | 2025-06-29 | £125.00 | £125.00 | 2020 Kia Sportage |
|
MOT Test |
Nancy Jackson | nancy.jackson@email.com | 07912 456789 | Inactive | 7 | 2024-12-15 | £967.35 | £138.19 | 2016 Ford Fiesta |
|
Service, MOT |
Daniel White | dan.white@virgin.net | 07923 567890 | Inactive | 5 | 2024-11-28 | £543.80 | £108.76 | 2015 Renault Clio |
|
Basic Service |
Amanda Harris | amanda.harris@gmail.com | 07934 678901 | Regular | 10 | 2025-07-06 | £1,345.90 | £134.59 | 2017 Skoda Octavia |
|
Service, MOT, Brakes |
Christopher Martin | chris.martin@company.com | 07945 789012 | Regular | 13 | 2025-06-24 | £1,678.25 | £129.02 | 2018 Mazda CX-5 |
|
Service, Tyres, MOT |
Michelle Garcia | michelle.garcia@live.co.uk | 07956 890123 | Occasional | 6 | 2025-05-18 | £734.60 | £122.43 | 2014 Seat Ibiza |
|
MOT, Service |
Patricia Moore | pat.moore@btconnect.com | 07967 901234 | Regular | 9 | 2025-07-04 | £1,189.45 | £132.16 | 2016 Volvo XC60 |
|
Premium Service, Diagnostics |
John Smith | john.smith@email.co.uk | 07978 012345 | VIP | 24 | 2025-07-09 | £4,156.80 | £173.20 | 2020 Range Rover Sport |
|
Premium Service, MOT, Repairs |
📊 Customer Behavior Insights
Average Customer Value
Annual spend per customer, up 12.3% from last year. VIP customers spend 3.2x more than average.
Customer Retention Rate
Customers returning within 12 months. Industry average is 65%. Strong loyalty program impact.
Service Frequency
Average visits per year. Regular customers visit 4.2x annually, occasionals 2.1x per year.
Customer Acquisition Cost
Average cost to acquire new customer. ROI achieved within 3.2 visits on average.
Churn Risk Indicators
Customers at risk of churning (>6 months no contact). Proactive outreach campaigns needed.
Upselling Success Rate
Success rate for additional services. Highest with diagnostics leading to repair work.