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 processesAs 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 solutionIn 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.
Sign up for the Data for Subscriptions newsletter and receive new trends, latest podcast episodes with industry experts and exclusive insights.
AI is reshaping industries, and the Telco sector is no exception. In fact, the potential impact of...
In the fast-paced world of Software as a Service (SaaS), understanding and effectively managing...
Billing managers are like highly skilled conductors of an orchestra, seamlessly steering and...