HomeMy WebLinkAboutSBStat 2021 - Q3 Customer ServiceSBStat | Customer Service
2 0 2 1 Q u a r t e r 3 | S e p t e m b e r 2 9 , 2 0 2 1
C i t y o f S o u t h B e n d
SBStat 2021
Ground rules for SB Stat Meetings
1. No stupid questions
Use this space to ask and address difficult questions safely
2. Data-driven decision making
Strive to make decisions based on whatever most recent data is
available
3. Relentless follow-up
Identify clear action items and owners after each meeting
4. A bias towards action
Continuously seek to improve: our data, our ways of working, etc.
Customer Service Portfolio Summary
Status of SBStat projects in the queue for 2021
Project Brief Description Status
Utility Assistance Program
Redesign Revamp and improve the Utility Assistance Program (UAP)
311 Call Transfer Survey Understand residents’ experience when 311 call transfers
to another department
Service Level Agreements Revamp
A Service Level Agreement is a contract between a service
provider (311) and its customers (departments)establishing the expected amount of time it will take to deliver a service
Online Service Portal
Strategic Communications
Developing evergreen digital content to promote online
service portal usage
Customer Service Audit Auditing the accessibility of customer service interactions
residents have with the City
Bloomberg Innovation
Support -Economic Relief
from Utility Bills
South Bend was selected to participate in a national
city cohort where cities are tackling timely challenges,utilizing best practices from other cities, Bloomberg, and its partners.
Legend Project on schedule Project delayed Project cancelled Project under consideration
SBStat 2021
Today’s Agenda
I. Project updates from previous Stat meeting
II. Deep-dive analysis & discussion
-Solid Waste Program Deep-dive
-311 Call Transfer Survey
III. Taking action
-Identifying clear action items and owners
IV. Celebrating our values
SBStat 2021
Highlights from this past quarter
Project updates from previous Stat meetings
Project Update 1 -Build the Budget
•In total the City had
•807 resident engagements:
•140 online survey responses
•228 in-person budget game participants
•115 attendees of the Mayor’s Community Action Group Discussions
•324 voicemails collected by 311
SBStat 2021
Project Update 2 -Utility Assistance Program Redesign
•Process + System Go-Live in mid-December
•Done:
•Process maps/program design
•In progress:
•Automation
•Documentation and training
•Current Customer Outreach (data collection)
•Stakeholder Coordination
•Real Services
•SJCPL
Project Update 3 -Utility Data Update
•There are 7,798 total delinquent accounts
•3,885 are over 90 days delinquent
•Cost estimate for forgiving all 7,798 delinquent accounts of their bill that is 60+ Days past due: $1,808,251
•Cost estimate for forgiving all 7,798 delinquent accounts of their bill in the current pay period and 30+ days overdue: $3,300,303
Note: Data estimates are as of September 27
Project Update 4 -Service Level Agreement Update
•Public Works has worked with division directors to update SLA times for each team. Draft times are currently being reviewed by I&T for final questions, concerns, etc.
•Draft SLA times are available in the appendix section of this slide deck
Note: Data estimates are as of September 27
SBStat 2021
Deep-dive analysis & discussion
Diving deep into a few key initiatives being undertaken to improve city performance
•Solid Waste Program Deep-Dive
•311 Call Transfer Survey & Analysis
SBStat 2021
Solid Waste Data Deep Dive –
Trends, Hot Spots, & Insights
Background &
Best Practices
Available data &
Analysis
Insights and
discussion
https://www.mckinsey.com/industries/public-and-social-sector/our-insights/improving-the-customer-experience-to-achieve-government-agency-goals
Best Practice Synthesis
Solid Waste program objectives
1.Ensure residents are informed on their weekly collection schedules
2.Provide a high quality, timely, and predictable solid waste collection service
3.Maintain a financially sustainable program that ensures quality service delivery
+Tracks calls, service requests, and KBA interactions
+Provides deeper level metrics on customers, such as repeat callers, call resolution, and call notes
+Missed pick ups, historical analysis of equipment and staffing
+Target number of hours for a service request to be resolved.
CRM data Routeware data Service Level Agreements (SLAs)
01 02 03
Solid Waste Data
A breakdown of available data to inform Solid Waste performance management
Workload
Solid Waste Performance Measures
EffectivenessEfficiency
Performance Measures and Best Practices
Initial Metrics
1.Percent of residents not satisfied
with waste management services
2.Collection cost per ton of waste
generated
3.Tons per 1000 population
4.Cost per ton collected
5.Complaints per 1000 collection
points
6.Percent of service requests
completed on time
Units of analysis
•City-wide
•Council Districts
•Neighborhoods
•Key Gateways / Routes
Units of analysis
•City-wide
•Council Districts
•Neighborhoods
•Key Gateways / Routes
Potential applications
to South Bend
•Create dashboard that
tracks SW SLA times
by
•Council District
•Neighborhoods
•Key Routes
CleanStatDashboard
Baltimore, MD
CleanStat Dashboard
Baltimore, MD
•URL: https://www.baltopi.com/cleanstat#:~:text=CleanStat%20is%20a%20CitiStat%20initiative,and%20other%20illegal%20dumping%20issues.
Key Takeaways
•Random spot checks along
key corridors (“secret
shopper”)
•Identified city gateways
using traffic volume,
economic prominence, and
cleaning requests
Potential applications to
South Bend
•Identify key corridors for
beautification (would
involve PW and DCI)
•Conduct spot checks at
random intervals
SBStat 2021
Supplemental Routing Tool (working title)
Tool Overview
This tool is in development and not currently in use
SBStat 2021
Purpose
•A geographic supplemental
routing tool for non-standard
routing issues
•Currently only developed for
solid waste team
Potential applications to
South Bend
•Inform route optimization for
non-standardized routes
•Bin delivery
•Extra trash pick-up
•Accessible to 311 liaisons for
real-time communications with
residents
Supplemental Routing Tool (working title)
Tool Overview
SBStat 2021
Best Practices Summary
Opportunities for South Bend
Create dashboard that
tracks solid waste SLA
times by
•Council District
•Neighborhoods
•Key corriodors or routes
01
Identify key corridors
to receive extra care
attention
Conduct spot checks at random intervals
02
Improve route
optimization and
communications for non-standing routes (i.e.extra trash pick-ups, etc.)
03
SBStat 2021
Discussion questions before closing out the topic
1.What do you like about the existing use cases? Were there any that might not be a good fit for South Bend?
2.If the City were to pursue one of these best practices, where should we start?
SBStat 2021
Customer Satisfaction with Solid Waste
SBStat 2021
SBStat 2021
SBStat 2021
SBStat 2021
SBStat 2021
SBStat 2021
Operations Data Summary
SBStat 2021
Customer Service Dashboard Analysis
Past 30 Days This Year All Time
Total calls 8,559 97,122 412,930
Percent of calls that result in a service request 18%18%14%
Total Calls
(solid waste only)3,085 (36%)29,058 (30%)138,411 (34%)
Percent of calls that result in a service request
(solid waste only)
12%16%12%
Total Calls
(excl. solid waste)5,474 (64%)68,064 (70%)274,519 (66%)
Percent of calls that result
in a service request
(excl. solid waste)
22%19%15%
Calls & Service Requests (as of September 24, 2021)
SBStat 2021
All Solid Waste Service Requests
by Council District (2021)
SBStat 2021
Council District Percent of all Service Requests Percent of Solid Waste Service Requests Difference
1 16%16%-
2 23%15%(8%)
3 19%21%2%
4 13%16%3%
5 13%16%3%
6 13%14%1%
All Solid Waste Service Requests
by Council District (2021)
SBStat 2021
Utility Service RequestsPast Three Months Solid Waste Service RequestsPast Three Months
Service Requests –Hot Spot Analysis
SBStat 2021
Past 30 Days This Year All Time
Request an Extra Trash
Pick Up 1,490 (48%)11,130 (38%)36,162 (26%)
Return Trip Customer
Error 209 (7%)2,225 (8%)13,721 (10%)
Report Missed Trash Pick
Up 135 (4%)1,728 (6%)13,531 (10%)
Trash Pick up Holiday
Schedule 133 (4%)1,556 (5%)7,601 (5%)
Request a Yard Waste
Extra Pick Up 128 (4%)1,068 (4%)7,235 (5%)
Total Calls
(solid waste only)3,085 29,058 138,411
Solid Waste Call Topics
(as of September 24, 2021)
SBStat 2021
Request an Extra Trash Pick Up
Past 30 Days (as of 9/24/21)
SBStat 2021
Request an Extra Trash Pick Up
Past Year (as of 9/24/21)
SBStat 2021
All Reported Missed Trash Pick-Ups (2021)
*Note: Data as of 9/24/2021
SBStat 2021
All Solid Waste Complaints (2021)
*Note: Data as of 9/24/2021
SBStat 2021
All Yard Waste Container Requests (2021)
*Note: Data as of 9/24/2021
SBStat 2021
Weekly Yard Waste Service (2021)
*Note: Data as of 9/24/2021
SBStat 2021
Insights | Solid Waste Data Deep-Dive
1.There are three hot spots in the City for general Solid Waste service requests that could serve as candidates for pilots and/or human-centered design improvements
1.In between Lincoln Way West and N Bendix
2.In between Jefferson Blvd. and McKinley Ave, just north of River Park
3.E Ewing Ave, in between Michigan St and Miami S
2.Requests for Extra Trash Pick-ups has been decreasing slightly in 2021, with most of the requests occurring on Tuesdays in the past 30 days.
3.Generally speaking, the City’s west side request less yard waste containers and information on yard waste service
4.Though customer satisfaction is generally strong compared to peers, it has been static for the past three years, neither getting better or worse
SBStat 2021
Discussion questions before closing out the topic
1.What research questions does this data spark for you? Is there additional analysis you would like to see?
2.Does this data change your thinking on applying some of the national best practices shared earlier?
SBStat 2021
311 Call Transfer Survey & Analysis
BACKGROUND /
CONTEXT
AVAILABLE DATA &
ANALYSIS
OPTIONS TO IMPROVE
PERFORMANCE
https://www.mckinsey.com/industries/public-and-social-sector/our-insights/improving-the-customer-experience-to-achieve-government-agency-goals
SBStat 2021
Background
311 liaisons transfer calls for different reasons:
Per Agreement Departments request certain requests
are always transferred to them
•Cold transfers –311 liaisons ends call
after transferring resident
•Warm transfers –311 liaisons stay on
line until other department picks up
Additional
Information Required
311 liaisons don’t have the information
needed to complete the request
On Demand Residents request to be transferred
SBStat 2021
Goals
How can we help residents resolve their issue when their 311 call transfers to a different department?
How can we help 311 liaisons help residents with call transfers?
How can we help staff in other departments resolve residents’ issues when staff receive transfer calls from 311?
SBStat 2021
311 Call Transfer Survey & Analysis
Purpose of 311 call transfer survey & analysis
•Understand residents’ experience when 311 call transfers to another department
Methodology
•Called people based on randomized list of call transfers from August 2021 to September 2021
•5 minute phone call
•2 question survey
Questions
1.Did you have any problems with your call transfer?
2.Was your issue resolved after your call transfer?
SBStat 2021
Limitations
Small sample size
•19 phone surveys conducted out of 972 total calls in August 2021 and September 2021
•0 phone survey with non-English speakers
Unreliable narrators
•Didn’t fact check every resident’s story with our data
Unknown perspectives
•311 liaison and staff in other department’s experience in call transfers
SBStat 2021
Challenges
People involved Challenges
Residents •Waits indefinite amount of time for transfer call to connect
with other department
•Experience dropped call
•Hangs up call transfer
311 liaisons •Transfer calls to departments due to lack of available
information
•Can’t always track outcome of transferred call due to lack of
notes
Staff in other
departments
•Never interacts with resident if call drops or resident hangs up
19 phone surveys with residents
attempted calls
minutes in total
Phone survey results
50
95
Phone survey results
Number
of phone
surveys
Department call was
transferred to
Department response
12 Utilities •Did not pick up
•Picked up
3 Code Enforcement •Picked up
2 Engineering •Picked up
1 Common Council •Returned call from
voicemail
1 Recreation •Did not pick up
Phone survey results
Yes,
7
No, 12
Question: Did you have any problems
with your call transfer?
Question:Was your issue resolved after
your call transfer?
Observed theme: Repeat Caller
Yes,
14
No, 5
Yes,
6
No, 13
SBStat 2021
Phone survey themes
Can’t get connected •I can’t get connected to the other department when my
call is transferred.
What is the status?•I haven’t heard back from anyone, and I’m not sure what
the status of my issue is.
Repeat caller •I call 311 again because my issue wasn’t resolved, and I
want to know its status.
Other •I want to do the right thing.
•I don’t distinguish between 311 and other departments.
•It’s frustrating that I have to talk to multiple people and
repeat myself.
SBStat 2021
Phone survey themes
Department call was transferred to Did you have any problems with your call transfer? Yes
Utilities •I can rarely get an answer at water [after getting transferred] because
they won’t answer the call. I usually have to physically go into the
office.
•Getting hold of water is no good. It takes too long to get a live person.
•Call back didn’t work, so nobody ever called back. I waited around 4 hours.
Common Council •No one picked up the line in the council person’s office, so I left a
message.
Recreation •Nobody answered or maybe there was an automated phone tree that
didn’t have the option I needed.
I can’t get connected to the other department when my call is transferred.
SBStat 2021
Phone survey themes
Department call was transferred to Was your issue resolved after your call transfer? No
Code Enforcement •Code said someone would be out to deal with the issue, but there are
still trees hanging in the alley.
Common Council •She said she would send someone out to investigate, but I haven’t
heard back.
I haven’t heard back from anyone, and I’m not sure what the status of my issue is.
SBStat 2021
Phone survey themes
Department call was transferred to Repeat Caller Yes
Utilities •Utilities told me they couldn’t see that information. I had to call back.
•At least they have my story now, but I thought they had my story from
the first call.
I call 311 again because my issue wasn’t resolved, and I want to know its status.
SBStat 2021
Phone survey themes
Department call
was transferred to
Multiple questions
Utilities •I thought I was being a good citizen because the City wasn’t going to
get a payment and I called to let them know.
•It doesn’t say who called you besides “South Bend Utilities”, but it’s all the same to me. I don’t distinguish between the two [311 and Utilities].
•I had to give my information twice and talk to someone first who didn’t
have anything to do with what I was calling about.
I want to do the right thing.
I don’t distinguish between 311 and other departments.
It’s frustrating that I have to talk to multiple people and repeat myself.
SBStat 2021
Phone survey themes
Can’t get connected •I can’t get connected to the other department when my
call is transferred.
What is the status?•I haven’t heard back from anyone, and I’m not sure what
the status of my issue is.
Repeat caller •I call 311 again because my issue wasn’t resolved, and I
want to know its status.
Other •I want to do the right thing.
•I don’t distinguish between 311 and other departments.
•It’s frustrating that I have to talk to multiple people and
repeat myself.
SBStat 2021
Goals
How can we help residents resolve their issue when their 311 call transfers to a different department?
How can we help 311 liaisons help residents with call transfers?
How can we help staff in other departments resolve residents’ issues when staff receive transfer calls from 311?
Taking Action
•Process mapping support and improvements
•How can we make the process easier for all stakeholders? What can or cannot be changed?
•Are we tracking data correctly? Are we closing out work orders correctly in CRM and are we notifying residents?
•Explore more opportunities for email notifications
•Verify that calls coming from COSB business lines appear as ‘City of South Bend’ on cell phones
•Create cadence for secret shopper initiatives and/or future surveys
1.What option for next steps do you find most compelling or interesting?
2.Is there another option for future next steps to consider?
Options for Next Steps
Discussion questions
SBStat 2021
Celebrating our values
This section highlights exemplary work happening in the City to improve performance that may otherwise go unnoticed
SBStat 2021
Celebrating our Values
SBStat | Customer Service
2 0 2 1 Q u a r t e r 3 | S e p t e m b e r 2 9 , 2 0 2 1
C i t y o f S o u t h B e n d
SBStat 2021
Appendix
Active Knowledge Articles SLA Times Active Knowledge Articles SLA Times
Additional Trash Container Request 240 Report Missed Trash Pick-Up
Alley to Curbside Trash Pick-up Exception Request 240 Report Property Damage N/a
Assisted Trash Collection Request a Yard Waste Extra Pickup 360
Cancel My Extra Trash Pick-up Request 48 Request an Extra Trash Pickup 360
Christmas Tree Pickup Request 360 Request Yard Waste Container Repair 120
Crew Reminder n/a Return Trip Customer Error 48
Customer Compliments n/a Sanitizing My Trash Container n/a
Customer Disputes 48 Senior Trash Service Discount
Customer Return Call to Approve or Decline Extra
Pick-up Charge n/a Solid Waste Contamination Fee n/a
Dispute Trash Service Charge Stopping Trash Services
Downtown Sidewalk Trash Containers 48 Trash Complaints
Exchange Waste Container for a Different Size 120 Trash Container Placement During Construction n/a
General Concern n/a Trash Container Repair Request
Missed Yard Waste Pick-Up Request 48 Trash Container Replacement Request 120
New Trash and Yard Waste Service Information NA Trash Container Request for New Service n/a
No Article Found -Solid Waste n/a Trash Pickup Holiday Schedule n/a
Remove Trash Container 120 Trash Service Rates n/a
Remove Yard Waste Tote Verify Trash Service Location on Property n/a
Report a Missed Extra Trash Pick-Up 120 Weekly Trash Schedule n/a
Report a Missed Yard Waste Extra Pick-Up Weekly Yard Waste Service 120
Report an Abandoned Waste Container 48 Yard Waste Container Replacement Request 40
Report Lost Container Due to Flood 120 Yard Waste Container Request NA
Service Level Agreement Updates –Draft
Solid Waste
SBStat 2021
Active Knowledge Articles SLA Times Active Knowledge Articles SLA Times
Alley Maintenance Request 72 Basement Flooding 24
Dead Animal in the Street 48 Catch Basin Cave-in 240
Debris in the Street 48 Sewer Backup
Snow Bank -Sight Impeded n/a Report Sewer Smell 48
Mailbox Damage from Plow 48 Plugged Catch Basin 24
Lawn Damage from Plow 72 Sewer Misc (No Action)n/a
Damage to Curb 72 Sewer Complaints/Repeat Call n/a
General Snow Information n/a Missing Sewer Lid 24
Street Flooding 24
2021 Spring ReLeaf Program n/a
Street Cave-In 2
Damage From City Plow n/a
Missed Loose Leaf Pick Up 24
No Article Found -Streets
Street Paving n/a
Reporting a Pothole 48
Street Light Issue 72
Street Needs to be Plowed n/a
Street Sweeping 72
2020 Fall ReLeaf Program n/a
Service Level Agreement Updates –Draft
Streets, Sewers