👥 Customer Activity Report

Customer Reports

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

👥
1,247

892 returning, 355 new this year

↗ +18.3% vs last year

New Customers

🆕
355

47 acquired this month

↗ +23.8% vs last year

Returning Customers

🔄
892

71.5% retention rate

↗ +5.2% vs last year

At-Risk Customers

⚠️
184

No activity >6 months

↗ +12.8% needs attention

Customer Segments by Value & Frequency

VIP Customers
8.5%
106 customers | £500+ avg spend
Regular Customers
42.3%
527 customers | 4+ visits/year
Occasional Customers
34.6%
432 customers | 2-3 visits/year
New Customers
14.6%
182 customers | <1 year history

Customer Activity Details

Detailed customer engagement and service history analysis

Customer Name Email 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
Excellent
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
Excellent
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
Excellent
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
Good
Service, MOT
James Wilson james.wilson@outlook.com 07923 567890 Regular 9 2025-06-28 £1,234.50 £137.17 2016 Volkswagen Golf
Good
Service, Repairs
Lisa Garcia l.garcia@email.co.uk 07934 678901 Regular 11 2025-07-01 £1,567.80 £142.53 2018 Nissan Qashqai
Good
Service, MOT, Tyres
Robert Lee robert.lee@gmail.com 07945 789012 Regular 8 2025-07-10 £1,089.40 £136.18 2015 Toyota Corolla
Good
Service, Diagnostics
Jennifer Taylor jen.taylor@yahoo.com 07956 890123 Occasional 5 2025-06-15 £567.90 £113.58 2014 Honda Civic
Average
MOT, Basic Service
Andrew Davis a.davis@btinternet.com 07967 901234 Occasional 6 2025-05-22 £678.45 £113.08 2013 Vauxhall Astra
Average
Service, MOT
Catherine Miller cat.miller@live.com 07978 012345 Occasional 4 2025-06-08 £445.80 £111.45 2012 Peugeot 207
Average
MOT, Repairs
Thomas Anderson thomas.anderson@gmail.com 07989 123456 New 3 2025-07-07 £456.75 £152.25 2021 Tesla Model 3
New
Diagnostics, Service
Maria Rodriguez maria.rodriguez@hotmail.co.uk 07990 234567 New 2 2025-07-03 £287.50 £143.75 2019 Hyundai i30
New
Service, Parts
Kevin Thompson kevin.thompson@outlook.com 07901 345678 New 1 2025-06-29 £125.00 £125.00 2020 Kia Sportage
New
MOT Test
Nancy Jackson nancy.jackson@email.com 07912 456789 Inactive 7 2024-12-15 £967.35 £138.19 2016 Ford Fiesta
At Risk
Service, MOT
Daniel White dan.white@virgin.net 07923 567890 Inactive 5 2024-11-28 £543.80 £108.76 2015 Renault Clio
At Risk
Basic Service
Amanda Harris amanda.harris@gmail.com 07934 678901 Regular 10 2025-07-06 £1,345.90 £134.59 2017 Skoda Octavia
Good
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
Good
Service, Tyres, MOT
Michelle Garcia michelle.garcia@live.co.uk 07956 890123 Occasional 6 2025-05-18 £734.60 £122.43 2014 Seat Ibiza
Average
MOT, Service
Patricia Moore pat.moore@btconnect.com 07967 901234 Regular 9 2025-07-04 £1,189.45 £132.16 2016 Volvo XC60
Good
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
Excellent
Premium Service, MOT, Repairs

📊 Customer Behavior Insights

Average Customer Value

£892.45

Annual spend per customer, up 12.3% from last year. VIP customers spend 3.2x more than average.

Customer Retention Rate

71.5%

Customers returning within 12 months. Industry average is 65%. Strong loyalty program impact.

Service Frequency

2.8x

Average visits per year. Regular customers visit 4.2x annually, occasionals 2.1x per year.

Customer Acquisition Cost

£45.60

Average cost to acquire new customer. ROI achieved within 3.2 visits on average.

Churn Risk Indicators

14.8%

Customers at risk of churning (>6 months no contact). Proactive outreach campaigns needed.

Upselling Success Rate

34.6%

Success rate for additional services. Highest with diagnostics leading to repair work.

🔧 Most Popular Services

Annual Service
68%
MOT Test
62%
Brake Service
34%
Tyre Replacement
28%
Diagnostics
19%

📞 Contact Preferences

78%
Prefer Email Updates
22%
SMS Alerts
45%
Phone Calls
56%
Service Reminders
31%
Online Booking

🗺️ Customer Locations

Local (0-5 miles) 523 (42%)
Regional (5-15 miles) 461 (37%)
Extended (15-30 miles) 213 (17%)
Distant (30+ miles) 50 (4%)