using geo-demographic classifications for customer insight
DESCRIPTION
Andrew Rudd, Research Manager; Miranda Webb, Research OfficerWorcestershire County Council - Research and Intelligence UnitTRANSCRIPT
![Page 1: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/1.jpg)
www.worcestershire.gov.uk
Using geo-demographic classifications for Customer Insight
Andrew RuddResearch Manager
Miranda WebbResearch Officer
Worcestershire County CouncilResearch and Intelligence Unit
![Page 2: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/2.jpg)
www.worcestershire.gov.uk
Contents
• Research and Intelligence Unit• About Worcestershire• What is Customer Insight?• Worcestershire Hub• Key Findings and Results• Practical Applications• Conclusion
![Page 3: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/3.jpg)
www.worcestershire.gov.uk
Worcestershire's Research and Intelligence Unit• Market Research (inc Customer Insight)• Housing• Economy• Performance Monitoring• Supporting People• Community Safety • Population/Demographics• Partnership work e.g. JSNA
![Page 4: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/4.jpg)
www.worcestershire.gov.uk
About Worcestershire
4
Worcestershire:
•Population: 556,548 (ONS 2009)
•Ageing population: 19% of population 65+ years
•4% population claiming Job Seekers Allowance July 2010
•71% of the population live in large towns or cities
![Page 5: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/5.jpg)
www.worcestershire.gov.uk
About Worcestershire
5
Worcestershire:
Supergroup
Total Population
(2001 Census)
% of Worcestershire
Blue Collar Communities 84,251 15.5City Living 8,542 1.6Countryside 127,562 23.5Prospering Suburbs 165,838 30.6Constrained by Circumstance 50,178 9.3Typical Traits 100,207 18.5Multicultural 5,529 1.0Grand Total 542,107 100.0
0.0
5.0
10.0
15.0
20.0
25.0
30.0
35.0
Blue Collar Communities
City Living Countryside Prospering Suburbs
Constrained by
Circumstance
Typical Traits Multicultural%
of P
opul
ation
(Ce
nsus
200
1)
OAC Supergroup
Worcestershires Population by OAC %
0.0
5.0
10.0
15.0
20.0
25.0
30.0
35.0
Blue Collar Communities
City Living Countryside Prospering Suburbs
Constrained by
Circumstance
Typical Traits Multicultural
% o
f Pop
ulati
on (
Cens
us 2
001)
OAC Supergroup
Worcestershire Population by OAC %
![Page 6: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/6.jpg)
www.worcestershire.gov.uk
What is Customer Insight?• Improve outcomes and services based on understanding of
customers:• needs• wants• expectations• behaviours• experiences
• Starts with knowing and understanding what customers want
• Ends with improved satisfaction with your organisation, and services being delivered in a more efficient way
6
![Page 7: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/7.jpg)
www.worcestershire.gov.uk
Meet our customers
7[Slideshow Title - edit in Headers & Footers]
Person X Partner
2 little X’s
Person X:
•Skilled manual worker•Lives in a house with a mortgage•Sends children to local school•Makes use of the local library•Drives a family car
![Page 8: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/8.jpg)
www.worcestershire.gov.uk
Our customers needs
8
Person X Needs…•To pay Council Tax
•Refuse and waste collected
•Information about school term times
•Advice about claiming benefits
•Information about library renewals
•Roads in good condition
Person X Partner
2 little X’s
![Page 9: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/9.jpg)
www.worcestershire.gov.uk
Our customers preferences
9
Person X is likely to….
•Shop at Morrisons
•Read the Express or Mail
•Like to use email or phone channels
Person X Partner
2 little X’s
![Page 10: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/10.jpg)
www.worcestershire.gov.uk
What our customers think
10[Slideshow Title - edit in Headers & Footers]
Person X thinks that…..
Most important•Employment prospects•Low crime
Most needs improving•Activities for children•Refuse and waste collection
Satisfaction with Local Govt•Neither satisfied nor dissatisfied
Person X Partner
2 little X’s
![Page 11: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/11.jpg)
www.worcestershire.gov.uk
Meet our customers
11[Slideshow Title - edit in Headers & Footers]
Person Y Person Y:
•Retired
•Lives in the countryside
•Rents house from social landlord
•Does not drive
•Occasionally uses the local library
![Page 12: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/12.jpg)
www.worcestershire.gov.uk
Our customers needs
12
Person Y needs…
•Information about local services
•Timetables for public transport
•Council Tax relief
•Library access
•Application form for Concessionary Fares
•Advice about Blue Badges
Person Y
![Page 13: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/13.jpg)
www.worcestershire.gov.uk
Our customers preferences
13[Slideshow Title - edit in Headers & Footers]
Person Y is likely to…
•Shop in Co-op or Asda
•Attend social clubs
•Prefer ‘to talk to someone’ when contacting a service
Person Y
![Page 14: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/14.jpg)
www.worcestershire.gov.uk
What our customers think
14[Slideshow Title - edit in Headers & Footers]
Person Y thinks that…
Most important•Access to services•Low crime
Most needs improving•Local transport•Refuse and waste collection
Satisfaction with Local Govt•Fairly satisfied
Person Y
![Page 15: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/15.jpg)
www.worcestershire.gov.uk
Our services
15[Slideshow Title - edit in Headers & Footers]
Who uses our libraries?
![Page 16: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/16.jpg)
www.worcestershire.gov.uk
Configuring our service
• 600 calls about library opening times per quarter• Many library users would prefer electronic
communication• Make information available via website and
email• Promote through material in libraries and during
telephone and face-to-face contact• Reduces time spent by Customer Service
Assistants
16
![Page 17: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/17.jpg)
www.worcestershire.gov.uk
Savings
17
8.2
4.63.2
0.40123456789
Face to Face Post Phone Self Serve via website
App
roxi
mat
e Co
st (£
)
Channel
Cost to Serve by Channel
Costs from SOCITM and ESD toolkit
![Page 18: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/18.jpg)
www.worcestershire.gov.uk
We have lots of different customers
18
![Page 19: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/19.jpg)
www.worcestershire.gov.uk
...and provide lots of different services
19[Slideshow Title - edit in Headers & Footers]
Refuse and Waste
Highways
Benefits
Concessionary Fares
Blue Badge
Council Tax
Housing
Social Services
Environmental Health
Street Scene
Car Parking
Education
Registration Services
Parks and Open Spaces
Development Control
![Page 20: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/20.jpg)
www.worcestershire.gov.uk
Match service configuration...with customer needs...and preferences...to get improved satisfaction
20[Slideshow Title - edit in Headers & Footers]
![Page 21: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/21.jpg)
www.worcestershire.gov.uk
Why are we doing this?
• Economic situation• Reduced public-sector funding
• Do more with fewer resources• Make better use of data
• Improve service delivery/customer satisfaction
• Councillor engagement • Keep Elected Members informed about their local
communities
![Page 22: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/22.jpg)
www.worcestershire.gov.uk
Worcestershire Hub
• WCC Customer Relationship Management system (OneServe) • Partnership between WCC and Local Authorities
• Information about service use by individuals
• Information about method of contact
• Location given by customer postcode
• Allows analysis of service use using geo-demographic tools e.g. ACORN, OAC
• We use both in this presentation
22
![Page 23: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/23.jpg)
www.worcestershire.gov.uk
Key Findings, Quarter One, 2010
• After cleaning, files contained:
• 38,860 Unique Customers
• 53,238 Unique Incidents
• Average of 1.3 Incidents per Customer
• Approximately 20% more incidents than in Q4 2009
![Page 24: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/24.jpg)
www.worcestershire.gov.uk
Results, Q1 2010
![Page 25: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/25.jpg)
www.worcestershire.gov.uk
Service use, Q1 2010
25
![Page 26: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/26.jpg)
www.worcestershire.gov.uk
Service use, Q1 2010
26
![Page 27: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/27.jpg)
www.worcestershire.gov.uk
27
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
% o
f Con
tact
Acorn Category
Origin of Contact by Acorn
Internet
Letter
Personal Visit
Phone
![Page 28: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/28.jpg)
www.worcestershire.gov.uk
28
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
% o
f Con
tact
OAC Supergroup
Origin of Contact by OAC
Internet
Letter
Personal Visit
Phone
![Page 29: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/29.jpg)
www.worcestershire.gov.uk
Channel preferences
• Email/Website: Urban Prosperity, Wealthy Achievers, Comfortably Off
• Letter/Post: Hard Pressed, Moderate Means, Comfortably Off
• Personal Visit: Hard Pressed, Moderate Means• Phone: Hard Pressed and Comfortably Off, Moderate
Means• Text: Hard-Pressed, Moderate Means, Urban
Prosperity
29
![Page 30: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/30.jpg)
www.worcestershire.gov.uk
Application: Promoting self-service• Changing the ways people contact the council
• Use channels customers most receptive to
• e.g. Libraries• 4,500 telephone and face-to-face enquiries per month• Many customers would use electronic channels• Alternative channels promoted during contact and
promotional material
• Savings• Self serve is a lower cost channel – where appropriate• Will not be suitable for all services
30
![Page 31: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/31.jpg)
www.worcestershire.gov.uk
Application: Service Improvement• Missed Bins
• Identify where refuse collections are missed most often • Customers least likely to be satisfied with service
• Analysis:• Incidents mapped• Highlighted areas with recurring requests• Identified any special circumstances (i.e. snow)• Target focused areas for service improvement
• Savings• Fewer repeat journeys to collect ‘missed’ refuse• Fewer customers reporting missed bins
![Page 32: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/32.jpg)
www.worcestershire.gov.uk
![Page 33: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/33.jpg)
www.worcestershire.gov.uk
© Crown copyright. All rights reserved. Worcestershire County Council 100015914. For reference purposes only. No further copies may be made.
Selected Postcode:
![Page 34: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/34.jpg)
www.worcestershire.gov.uk
Application: Informing Councillors • Electoral Division information
• Inform Councillors about needs of their communities• Councillors able to represent communities more effectively• Updated quarterly
• Area Profiles
• Postcode maps
• Savings• Councillors more proactive in resolving community issues• Fewer contacts from customers
34
![Page 35: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/35.jpg)
www.worcestershire.gov.uk
35
![Page 36: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/36.jpg)
www.worcestershire.gov.uk
![Page 37: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/37.jpg)
www.worcestershire.gov.uk
![Page 38: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/38.jpg)
www.worcestershire.gov.uk
Conclusions• Understanding customers allows better targeting of
resources, thereby reducing costs of service delivery = efficiency savings
• Geo-demographic tools help develop this understanding
• Can lead to improved satisfaction amongst customers• Demonstrates effective use of existing data• Relies on good quality location data and effective
partnership working• Many potential applications
![Page 39: Using geo-demographic classifications for Customer Insight](https://reader033.vdocuments.us/reader033/viewer/2022050920/5487ed13b4795984178b519d/html5/thumbnails/39.jpg)
www.worcestershire.gov.uk
Contact details
Andrew RuddResearch Manager
Miranda WebbResearch Officer
[email protected] 822026