Tales from the library of pain: How not to manage usage data

Chapter one: Prisoners of Excel
Our story begins in a fictional city which we’ll call Hammerburg. Though relatively small compared to other ports, Hammerburg has a busy harbor where more than a million shipping containers pass through each year.
When we met them, the Port of Hammerburg was getting busier and busier. That growth was supported by increased manufacturing in the area, which meant more inbound and outbound international shipments.
While some bigger ports have invested heavily in advanced systems for digitalization and automation, Hammerburg was still largely reliant on manual processes. In fact, their whole operation was built on paper and time stamps.
The port charges companies for the amount of time each shipping container spends in storage. This meant when a container came in, a paper was stamped. When the container went out, there was another stamp.
This manual process was causing serious pains on an operational level, because someone had to take all the papers, look at each stamp, and input all that data into a big Excel file. We refer to this poor soul as the Excel Guy.
The Port of Hammerburg was far from alone in this situation. We’ve found teams of Excel Guys toiling away at massive, publicly traded companies.
The growth in international trade meant that the port was generating more paper and more stamps every month. To keep up, they added more people to their “Prison of Excel”.

Chapter two: Trapped in a maze of manual processes
As the Excel files kept growing, so did the frequency of errors. That meant some transactions weren’t billed for, which we often refer to as revenue leakage. At the same time, customers were also double billed. Billing errors caused customer complaints, which increased cost related to customer service and resolution. That was also true when it came to partner settlement. Resolving disputes with third-party vendors required hours of grueling manual reconciliation. With unhappy customers and partners, pricing negotiations become harder. So, the port’s position to negotiate was weaker, which had a negative impact on growth. Manual processes also meant that their billing cycles were slow. Waiting to get paid meant a compromised cash flow. Ultimately, this meant that the port operator had less cash available to invest in growth. With a paper-driven process, it’s hard to change. Even rolling out a new form meant they had to run all over the place with papers. So, what they ended up doing was the opposite of being agile. They didn’t make changes even though they wanted to because it was just too expensive and too hard. They were stuck going round in a maze and needed a way out.Chapter three: A wrong turn in the search for a solution
In their effort to find a way out of their predicament, the port’s IT team saw replacing the billing system as a possible solution. This was because the billing system is where they saw the most obvious problems surface, while ignoring the inefficient manual processes that led to their “dirty data” in the first place. Again, this is a common pain for any type of organization that’s weighted down by manual processes. Businesses often start exploring a billing transformation without realizing that they actually have a service usage data management problem. The port’s IT team was simply not aware of the purpose-built data management solutions that can fix these problems. But after consulting with one of DigitalRoute’s billing platform partners, the IT team discovered that they needed to address the quality of data being fed into the billing platform.
Working happily ever after with the help of DigitalRoute
With DigitalRoute’s Usage Engine automatically structure and bind data, it was easier to bind to customer accounts, which meant billing cycles sped up. Less mistakes led to a massive decrease in complaints and time spent on reconciliation. Partner settlement was also streamlined. If any questions did occur, a strong audit trail meant any disputes could be resolved quickly. All this meant that the Excel Guy was free to work on projects that created more value for the port. Gradually, they were able to introduce more digital processes and systems, which further increased their efficiency and supported their continual growth. The morale of this story? By taking control of usage data management, businesses have an easier path to growth. Without that, your business may just find itself in the Library of Pain. Do you need to automate usage data management? Share your story with one of experts, and we’ll help you find a solution.Four servitization pricing models for manufacturers (and why they all depend on service usage data)
How do manufacturers monetize new XaaS offerings? Here’s a quick overview of four outcome-based...
The value of usage data management in manufacturing
Today, manufacturers are drowning in data generated by sensors, and data applied in support of...
Report: The state of usage-based pricing in 2023
Here’s an overview of OpenView’s annual report on usage-based pricing in the software industry....
How CSPs can use holistic data management to improve analytics and increase revenue
CSPs struggle with siloed data, but what if all network data was easily accessible to improve...
The SaaS recipe for usage-based billing and product led growth
How can usage-based billing models support product led growth? Here’s a simple recipe for SaaS...
5 signs your SaaS company needs to improve its usage data management
If your SaaS company offers usage-based pricing, there’s a good chance you’ve built an in-house...
Is your SaaS company’s billing problem actually a data problem?
Planning a billing platform upgrade? Usage Engine, our purpose-built usage data management...
One of the biggest roadblocks to billing transformation
Despite an uncertain economy, enterprises are investing heavily in digitally transforming their...
Why video streaming services need user data more than ever
It’s no news that video streaming service providers are facing increasing competition,...
The future of music streaming services – why data matters
The good news for music streaming services is that they’re experiencing record revenue growth. The...
SaaS pricing in uncertain times – 4 things to consider
With record inflation and rising labor costs, many SaaS vendors are raising prices for their...
What are the key data challenges for “everything as a service” (XaaS) business models?
XaaS models provide mouthwatering potential. They provide untapped revenue opportunities and...
Can the “anything as a service” model (XaaS) supercharge your business?
What is XaaS, and how can it increase your revenue and improve customer experiences? Here are 5...
NWDAF through a new lens
5G presents a new paradigm for communication networks and is expected to lead the...
5 industries growing with “anything as a service” (or XaaS)
Offering "anything as a service" (XaaS) is a major trend with cross-industry appeal. Learn which...
What Deloitte’s report tells us about the IT-as-a-service trend
Deloitte’s second Everything-as-a-Service (XaaS) Study shows that enterprise use of...
SaaS companies and usage-based pricing: The perfect match
SaaS companies once relied on flat-rate subscriptions, but they’re quickly turning to usage-based...
5 ways subscription businesses leak revenue
Subscriptions business models deliver predictable recurring revenue, and make it easier to attract...
How your top 10% of customers could account for 70% of revenue
Have you heard of the 70/10 rule? It means that 70% of your subscription revenue can come from 10%...
Netflix’s story reminds us that ignoring revenue leaks is more than just missed income
After their first-quarter report back in April, shares of the streaming giant Netflix fell more...
6 data challenges in usage-based services that every business must know
Usage or consumption-based services are becoming increasingly common, since they allow customers...
Subscription pricing models: the 6 most common explained
Looking for the right subscription model for your business? Learn about the pros and cons of the 6...
How will CSPs restructure telecoms monetization for 5G and beyond?
The telecoms game has changed from selling metered minutes and megabits to address new enterprise...
The race for B2B services: How CSPs can optimize their business with usage data
5G technologies have made B2B revenues a mouthwatering prospect for telcos. We examine usage...
What is usage data and how do businesses use it?
What exactly is usage data? How does it relate to subscriptions and billing? Why is processing...
The data challenges in usage-based subscriptions
Consumption-based subscriptions are a proven way to rapidly grow revenue, but in order to succeed...
Why processing data for your billing systems causes revenue leakage – and how to solve it
Why revenue leakage is a big problem, and how correctly processing data for your billing systems...
How to move to usage-based pricing with Salesforce Revenue Cloud
Understand the backend, IT challenges of shifting to usage-based billing, and how DigitalRoute and...
5G charging requirements haven’t killed your online charging system (just yet)
Do you need to deploy a new converged charging system for 5G? Learn how introducing a flexible...
How CSPs can partner with enterprises to monetize 5G services
To recover 5G investments, CSPs will need to partner with enterprises and offer new services....
Accelerate invoicing by 80% through automated data processing
Discover how invoicing can be sped up by 80% by automating how you collect and process data in...
Why dirty data can stop quote-to-cash processes in their tracks
Modern quote-to-cash processes must be based on a data-first approach. Get insights on the dirty...