Email a colleague    

May 2014

Batting for More Churn Reduction and Revenue Assurance Home Runs

Batting for More Churn Reduction and Revenue Assurance Home Runs

The success of a Major League baseball franchise today is built around one or two multi-million dollar sluggers --a David Ortiz or Albert Pujols.

That’s a theory of mine.  But as a casual fan of baseball, what do I know?  The truth is that baseball has become yet another analytic science, and the data proves that “coach potato experts” like me are often way off the mark.

Fortunately I ran into Peter Mueller, a student of the “grand old game” and the CTO of ATS, a boutique analytics firm in New Jersey serving a few Tier 1 telcos in North America.

In my interview with Peter, he walks us through his own big data/cloud “epiphany” then lays out a couple of great examples of how the analytics technology benefits both the telco customer and the big data solution vendor.

Dan Baker: Peter, what’s your take on my baseball theory?

Peter Mueller: Dan, I learned a lot reading Moneyball by Michael Lewis, a book that has since become a movie.  That book shed light on new baseball strategies made possible by analytics.

Money Ball By Mark Lewis

People used to measure a ball player’s worth by simple measures like batting average, and RBIs (runs batted in).  But new statistics like on-base percentage and slugging percentage have proven a much greater predictor of a player or team’s success.

Actually, the money the players make is correlated more with the income their team makes from selling ballpark seats, television rights, and team merchandise.  And if you look back to 2003, the Florida Marlins beat the New York Yankees 4 games to 2 in the World Series.  And yet Marlins‘ player salaries were only one third of the Yankee payroll.

Very interesting.  So what about analytics in telecom?  As CTO at ATS you’ve been in an ideal position to see this big data and analytics evolve.  How do you see this trend breaking with the past?

Dan, I think it’s realizing you’re no longer limited to the Oracle database way of doing things.  The Oracle database was never that good at handling very large volumes of data in its native format.  To be successful in this area, you had to spend a lot of time converting and inserting your data into ever-costlier hardware and software configurations.

Once you got there, you were limited to a Structured Query Language (SQL) view of the world.  That’s fine when you need to manage transactions such as bank records where there are a lot of reads, writes, and locking of records.  When you take money out of an ATM machine, the new account balance needs to appear instantly on the ATM display.  But, the new era of analytics calls for a richer set of analytic tools.

There is a world of difference between banking transactions and telecom CDRs.  CDRs are a one way ticket: nobody is going back to the switch to rewrite something.  Not only that: CDRs come at you in huge volumes, like getting blasted with a firehose.

Yes, the rise of Teradata in the 1990s was in direct response to this dilemma.  Teradata was a database designed for analytics and reporting: a new concept at the time.

Yes, Teradata with its parallel processing was one of the first to crack the problem and eat away at the Oracle behemoth.  Today, we’re seeing Open Source and the public cloud pick up on that trend.

Another issue is that the data coming off the switches is usually not plain ASCII text.  The Bellcore AMA format, for instance, is very hard to read because it’s in binary format.  In GSM too, you also get binary encoded records.  So all these need to be translated and reformatted.

So it’s here where new tools and hardware have revolutionized everything.  With Hadoop and MapReduce, you can set up your own streaming jobs to run through these things.  Moore’s Law is still working, too: commodity processing boxes have allowed IT to take on mass processing jobs they could never afford to do before.

The IT groups at our operator customers have also became very clever at parsing their own records, and switch vendors have started outputting their records in a more useful way.  Together, that sets the table for more powerful analytics engines to come in and start making sense of all this “big data”.

How did your shop actually get started using big data?

Well, our first use of Hadoop was a duct tape and glue sort of thing.  We hijacked some old servers and were amazed to see Hadoop working in our own data center, running fairly large analyses on commodity hardware.  From there, we made the jump to public cloud providers and greatly lowered our costs.  Your readers should definitely explore that.

At ATS, we’ve kind of settled on Amazon and Google Cloud Compute.  We like the more durable storage you get on Amazon’s S3 platform, plus it’s nice to rent rather than own your computing resources.  If a medium-sized IT shop were to set up a 20-node Hadoop cluster in-house, they’d find it expensive and very tough to configure.  But with the cloud, you can expand that 20 node cluster to 200 nodes, say, once a month when you need it for 3 hours.

So there’s some truth to those rumors about the “death of the server”.  Computing power has become a utility: it no longer needs to be in an air conditioned room down the hall.

Weren‘t you reluctant to port your code to Hadoop, given you’ve developed in other formats for decades?

Actually, no.  Our code ports pretty well into Hadoop and that speaks highly for Hadoop rather than our code frankly.  The trick is to embrace the MapReduce framework, which isn‘t much more than a specific way of counting things.

For example, if you had twenty decks of shuffled cards and a room full of 20 people, what would be the best way to find and count all the aces?  Your programmer might come up with one way, but MapReduce forces you to split the job into manageable chunks and have each node report back what they found.

So, the task for any software engineer looking to retrofit their software for Hadoop is to split up the smaller tasks (“I found 3 aces in this pile, 6 in this one”) , from the final tabulation (“It turns out there are 80 aces in total.”).  Then, you let Hadoop manage the intricacies of setting up and babysitting all the jobs and tasks.  And you’re done.

Peter, how do you use big data in your projects with telecom clients?

Let me give you an example.  A wireless carrier came to us and said, “We’ve got a retention problem and we need you help identify who is likely to churn.  We’ll supply you with any data set you need to look at: CDRs, billing data, plus the anonymized list of customers who disconnected with us in the last 6 months.”

OK fine, with that clear mission we put out thinking hats on and came up with a series of questions to explore:

  1. How were the behaviors of the churners different from normal?
  2. Were the churner’s social connections to other people a predictor of churn?
  3. Were churners more likely to talk to people on other networks before they left?
  4. Did they experience more dropped calls than normal?

That last issue about “dropped calls” is a biggie.  Wireless operators wonder whether they should sign-off on multi-billion dollar CAPEX spends.  The engineers say that erecting more wireless towers will reduce dropped calls.  But in the big scheme of things, does it really matter?

So, Dan, let me put you on the spot and ask: what’s your gut feel?  In your opinion, is the number of dropped calls a reliable predictor of churn?

I would definitely say yes: Dropped calls should be a reliable predictor of churn.

You said, “yes”, and in fact the executives at the wireless carrier agreed with you.  But surprisingly, the answer is “no”.  By running the big data, we found dropped calls were not a predictor, at least for the carrier customer we worked with.

We’re still not sure why.  Maybe it says a lot about what we’ve come to expect from our wireless phones.  People don‘t expect the grass to be greener on the other side of the fence.

Now, conversely your intuition about things that cause churn may turn out to be correct.  For instance, “right-sizing” your customers turns out to be very important.

By right-sizing, I mean reaching out to customers who are on the wrong plan.  So if I have you on a 4 Gigabyte plan for $120 a month, that’s a problem if you are only using 1 Gigabyte a month, because you are far more likely to be persuaded by an ad from another carrier to switch.  The gap between what you are paying and what you are using is just too large.

But you need big data to prove that case, because CFOs don‘t like the idea of proactively reaching out to high profitable customers and offering them a cheaper plan when it’s too seductive to just view these customers as being ’pure profit‘.

You have to show them (again, with cold, hard data) that the lifetime value of a customer drops the more they are over-paying.  On the flipside, the same types of analysis can show you which customers are ripe for an upsell.

Peter, thanks for these great stories and perspective.  So to sum it all up, what’s the key virtue of becoming a big data shop?

To me, Dan, the biggest benefit of big data technology is that it reduces the cost of failure.

The truth is that most new ideas -- in revenue assurance or network performance or churn prediction -- start with a hunch.  And to go from a hunch to a proof of concept takes work because you need to test that concept and find an efficient way to test it.

In revenue assurance, you can float all kinds of ideas of how people are losing revenue, but most of those ideas don‘t pan out.  So it’s very much a game of numbers.  Yet, in baseball, even if you bat .300, you’re considered very good.

And customers love us for that virtue.  They bring us in on nothing more than a fuzzy idea and we can run with it at fairly low cost.  And we can come back and say, “You know what?  We looked at a billion of your records, and this idea you had about predicting churn seems to make sense in this area”, but not in 10 other areas.  Once we separate the wheat from the chaff, we can move quickly to implement.

NOTE: ATS is one of 41 vendors profiled in TRI's 574-page research report: The Telecom Analytics & Big Data Solutions Market.

Copyright 2014 Black Swan Telecom Journal

 
Peter Mueller

Peter Mueller

Peter is the Chief Technology Officer at ATS, and has over 17 years of industry experience designing and implementing solutions in telecom routing, charging, billing, storage, fraud and churn analytics.  A Psychology graduate of McGill University,  he’s drawn to any problem that merges the ‘human element’ with data analytics (though he admits the latter is easier to understand!).  Follow him on twitter @pmueller.   Contact Peter via

Black Swan Solution Guides & Papers

cSwans of a Feather

  • Telecom CVM: From Scattered Campaigns to Unified & Consistent Communication with Customers interview with Cretièn Brandsma — Despite the many failures Customer Value Management has faced in telecom, CVM’s future is very hopeful.  A carrier expert explains why telecoms have faltered, how customer experience programs can be revitalized, and where telecoms should invest in better tactics and technology.
  • The Key to Driving 4G Profit: Sell Value, Not Bandwidth by Miri Duenias — Are you struggling to earn a profit on your 4G investments?  Many operators are failing today on the marketing side.  But aligning 4G products with a customer’s personal preferences and desires provides the necessary sizzle to boost sales and earn a handsome ROI.
  • Batting for More Churn Reduction and Revenue Assurance Home Runs interview with Peter Mueller — What’s it like to transform an IT shop to big data and cloud?  In this interview, the CTO of a boutique revenue assurance explains how his firm made the leap.  He shows how project-oriented programs and working with carrier customers to explore RA and churn reduction “hunches” is where much of the action is.
  • Sharing Intelligence, Services, and Infrastructure across the Telecom Galaxy interview with Gary Zimmerman — The telecom industry is an industry of sharing.  In fact, the rise of mobile broadband is driving a greater reliance on real-time intelligence, services trading, and infrastructure exchange.  In this article, a leading info exchange provider explains the value of its services portfolio and points to other interoperability and sharing ideas under development.
  • Data Monetization: Why Selling Intelligence is a Hot New Revenue Stream for Mobile Carriers interview with Joe Levy — Data monetization is a revenue dream come true for mobile carriers: a highly profitable sideshow where the carrier analyzes and sells data it already collects for other purposes.  In this article you’ll learn how operators monetize their data through use cases in corporate advertising and media branding.
  • Back Office Streamlining to Enterprise Support: The Many Flavors of Wireline Analytics interview with Tom Nolting — Mobile analytics gets plenty of press coverage, but analytics is just as crucial for wireline operators.  In this article, a billing VP at a leading wireline operator discusses several diverse uses of analytics in billing, enterprise sales/retention, and network partner margin assurance.
  • Analytics Guru: Are Telecoms Ready for the Biz Intelligence Explosion? interview with John Meyers — Business intelligence is evolving from the creation of dashboards and reports to taking action based on a deep knowledge of the environmental context.  The article explores the implications of “big data” in terms of IPTV, storage requirements, hardware, event collection, and deep packet inspection.
  • Making the Strategic Leap From Billing to Merchandising interview with Humera Malik — Today billing/charging technology has progressed to the point where the usage intelligence, the charges, the user behaviors, and the analytics can all come together in near real-time.  This article discusses the organizational and marketing strategies that enable a operator to create a true “merchandising” system that can revolutionize a CSP’s business. 

Related Articles

  • Black Swan Guide: Araxxe’s Revenue Assurance Consulting, Testing, and High Definition Billing Analysis Service by Dan Baker — How Araxxe’s end-to-end revenue assurance complements switch-to-bill RA  through telescope RA (external and partner data) and microscope RA (high-definition analysis of complex services like bundling and digital services).
  • Subex’s IDcentral Monetizes Telco & Enterprise Data to Deliver Digital ID & Risk Metric Services for Financing, KYC & More interview with Shankar Roddam — A new digital intelligence service that monetizes the idle data of telecoms and enterprises while also earning a good return for the owner of the data.
  • Opportunities & Obstacles: Consultant Luke Taylor Muses on the State of the Telecom Risk Assurance Business interview with Luke Taylor — A rambling discussion on the state of the risk assurance business with Luke Taylor, independent consultant in telecom revenue/fraud assurance and solution requirements and marketing.
  • LATRO’s Tips for Launching a Successful Revenue & Fraud Assurance Program for Mobile Money Operations in Developing Countries interview with Don Reinhart — A company building mobile money RA/FM tools and  managed services gives a concise, but detailed tutorial on how the Mobile Money Ecosystem works.  Revenue assurance pros will get tips on  what to look for in analytics/assurance tools, controls, and professional services.
  • A WeDo Conference Talk: Consulting & Analytics: Improving your Business Today, Enhancing it Tomorrow interview with Carla Cardoso & Bernado Lucas & Thomas Steagall — Leading risk management consultants explain their mission and walk-through RA, subscription fraud, and collections cases.  They also explain how analytics and machine learning can supplement process optimization.
  • PrologMobile’s Simple and Brilliant Plan to Save US MNOs Billions a Year in Recovered Phones & Retained Customers interview with Seth Heine — An expert in the mobile phone reverse supply chain explains how MNOs — via a neutral third party information exchange — can recover their original phones on the used market and save huge sums in multi-year customer retention.
  • WeDo Explores the IoT Ecosystem in Search of Tomorrow’s Pivotal Fraud & Business Assurance Solutions interview with Carlos Marques — A veteran product manager scans the IoT terrain, discusses key fraud and assurance challenges, and explains the preparatory steps WeDo is taking to become a key player in this emerging market.
  • New Report: Telecom Fraud & Business Assurance Solutions, Services & Strategies by Dan Baker & Luke Taylor & Colin Yates — TRI publishes a new market research report, Telecom Fraud & Business Assurance Solutions, Services & Strategies.  Free executive summary available.
  • Subex Juggles a Wide Variety of Business Assurance and Big Data Analytics Use Cases interview with Rohit Maheshwari — A expert in business assurance solutions explains top use cases such as: IoT security, big data analytics/AI, network asset optimization, multi-player gaming assurance, onboarding mobile subs, and AI customer analytics.
  • MTN Agility: Mastering Exponential Technologies in Revenue/Fraud Assurance and Beyond interview with Danie Maritz & Tony Sani & Luke Taylor — An in-depth look at RAFM operations and innovation at the MTN Group.  Topics discussed include RA/fraud control challenges, strategies, and MTN’s journey to exploit exponential tech (AI, robotics, and ML) in its RAFM program and support of internal non-telco businesses.
  • From Byzantine Software Contracts to Simple & Flexible RA Managed Services interview with Philippe Orsini — Is the way B2B/enterprise software is sold and delivered today progressive — or is it Byzantine in the age of cloud?  An expert lays out the case for managed services in RA and billing verification.
  • Premiere Experts Set to Speak at Summer RAG Conference in London, July 7th and 8th by Dan Baker — The Risk and Assurance Group (RAG) has announced that its 2016 summer conference will expand into a two-day event and feature many premiere experts. 
  • WeDo Hosts Revenue Assurance & Fraud Management Conference in Washington DC by Dan Baker — Black Swan is pleased to announce what looks to be a first class revenue assurance and fraud management conference being put on by WeDo Technologies, on October 1st and 2nd in beautiful Washington DC.
  • Test Call Generators: An Essential Test & Debugging Tool in Mobile Billing Assurance interview with Steffen Öftring — An “active” test call generator (TCG) can see problems that a “passive” revenue assurance system is blind to.  Here’s a discussion on the test call RA  process, over-the-air calls versus core call injection, and test call networks in global roaming RA.
  • The Revenue Assurance Game: How the Rules Change in the Era of IoT & Mobile Broadband interview with Rene Felber & Gadi Solotorevsky — Revenue assurance is perhaps the hardest of telecom functions to define because the term is used in so many different senses.  This discussion on the evolving role of revenue assurance was catalyzed by a survey of experts in the profession.
  • Day in the Life of a Revenue Assurance Analyst interview with Michael Lazarou — Revenue assurance is much more than a software category.  It’s individual analysts struggling to help their larger organizations get a handle on system errors and coordination problems.  In this interview, an analyst reveals the many challenges of getting the revenue assurance job done at a small GSM operator in Europe.
  • Revenue Assurance: History and New Beginnings in RA Maturity interview with Daniela Giacomantonio & Gadi Solotorevsky — The Roman Forum was the center of commercial life in ancient Rome.  Now, two millennia later, the Forum lives on in the exchange of ideas across countless professions and  media.  In this interview, two Revenue Assurance experts discuss both the new RA Maturity initiative of the TM Forum and the value of telco/solution vendor collaboration.
  • Migrating systems or launching LTE next year?  Don‘t forget transformation assurance & optimisation by Efrat Nissimov — System transformations and network migrations are major  revenue impacting events and they should raise a big red flag.  Why?  Because data integrity issues are bound to crop up as CSPs move vital data from a legacy system to something new.  It’s time for transformation assurance.
  • How can Cable/DSL Internet Providers Meet the Usage-Based Billing Mandate? interview with Ryan Guthrie — The popularity of YouTube, Netflix, and Hulu other video outlets has turned the tables on service profitability for cable/DSL service providers.  Many are moving to usage-based billing, but that largely unprepared for the revenue assurance aspects of this move.  This interview explains the technical challenge and points to solutions in billing, speed caps, and traffic revenue monitoring.
  • CABS Revenue Assurance: How Rural LECs can Recover $284 Million in Revenue Shortfalls interview with Kelly Cannon & Darrell Merschak — Independent rural LECs in the U.S. still rely on the AMA/EMI billing formats for CABS billing, even as that format has proven to be highly inaccurate as a source of inter-carrier records.  This interview includes an analysis and discussion of revenue recovery techniques ILECs can use by leveraging SS7 probes.  Also discussed are billing strategies, traffic dumping threats, and the possible fallout from the FCC’s bill-and-keep mandate.
  • Make Business Assurance Progress Every Day: How to Set Goals, Automate, and Energize Your Team interview with Kathleen Romano — Business assurance (BA) skills have wide applicability outside the revenue assurance and fraud mangement domains.  In this article, a telecom executive explains how she’s applying her BA skills in the Payments area.  In addition to discussing the key operational challenges in Payments, the interview also provides keen insights on setting goals in business assurance, leading a team, and making critical decisions.
  • LTE Rollout: Make it a Smashing Success with Risk Assessment, Controls, and Marketing Offer Analytics by Gadi Solotorevsky — LTE brings splendid new capabilities to mobile users.  But like 2G and 3G deployments before, operators can only make money if they successfuly plan, coordinate, deploy fast, and pay attention to pricing plans and the customer experience.  This article lays out a 3-phase tactical guide on  how revenue analytics professionals can add value in LTE service risk assessment, controls, and marketing offer analytics.
  • RA Prevention: How to Manage Revenue Risks and Communicate RA’s Value to Senior Execs by Shaul Moav — The era of revenue assurance prevention and risk assessment is here.  Several of the mature operators of the world have developed their own methodologies and tools.  Using firefighting and fire prevention as a metaphor, the article details a new commercial software approach explaining the goals, method of risk evaluation, and senior executive dashboards developed for the process.
  • Precision Clockworks: How Revenue Assurance Synchronizes with the Business at Swisscom interview with Marco Pollinger — An expert revenue assurance department is one whose work dovetails well with the lines of businesses it supports.  In this interview you’ll learn how Swisscom manages its revenue assurance function for maximum effect.  The article discusses: the operator’s innovative RA organization, the screening and RA approval of new services, its pre-production bill audits, and its coordination with corporate risk management.
  • Versatile, Portable & Corrections-Savvy: Quest for the Swiss Army Knife of Revenue Assurance Software by Mark Yelland — Revenue assurance maturity models are not cast in stone.  Since  best practices will change over time, it’s healthy to explore moving maturity models forward.  For example, great gains have been made in leakage detection, but RA corrections has been harder to master.  The author dreams about seven functions that should ideally come together in a single all-purpose revenue assurance software tool.
  • Bringing Strategic Planning & Value Engineering to Revenue Assurance interview with Maged Fawzy — Engineering and architectural techniques have a role in revenue assurance.  This interview with a top Egyptian RA consultant explains how continuous risk assessment and long range — yet flexible — RA planning can sharpen a carrier’s RA program and lead to better use of revenue assurance software and integration services.
  • Forensic Fossils: Is Your Revenue Assurance Shop Fit for Display at a Natural History Museum? interview with Jim Marsh — Without the continuous guiding light of seasoned revenue assurance leaders, even the best teams of RA professionals, technology, and business processes can fossilize and lose their vitality.
  • Revenue Assurance: The Magical Market Cap Multiplier by Van Howard & Curtis Mills — Many operators today consider revenue assurance yesterday’s opportunity.  But this article shows why significant revenue and cost leakage can still go undetected, even in companies with dedicated RA departments.  Also discussed are the benefits of a broader or more “forensic” approach to revenue assurance, an approach that boosts the bottom line regardless of the automated tools already in place.
  • From Risk to Robust: Turning the Big Picture Into a Real Agenda for Change in Telecoms by Eric Priezkalns — Inspired by a Financial Times article written by Nassim Taleb, author of “The Black Swan”, here is an insightful and entertaining primer on telecom risk management.  The article takes ten risk management lessons from Taleb and applies them specifically to the communications industry.  You’ll learn about the value of small scale trials, organization accountability, cures for a blame culture, incentives that work, the power of simplicity, and more.
  • Synthesizing the Telecom Business Assurance Practice With the Analytics World by Dan Baker — Business assurance is a wrapper term that allows you to draw a circle around various telecom assurance, control, and optimization activities.  This article maps business assurance as a subset of telecom analytics, constrasting it with marketing analytics while a diagram shows where biz assurance fits in the larger B/OSS world.
  • CABS Revenue Assurance Disputes: May the Carrier With the Best Data Win by Cheryl Smith Rardin & David West — Revenue assurance innovation is far easier when partners cooperate to make it happen.  This articles shows how a U.S. operator, software vendor, and consultant teamed to develop a breakthrough in Carrier Access Billing (CABS) assurance.  Learn about: the dispute resolution data gap that needed to be filled, the partnering strategy, the implementation challenges, and payback results.
  • Revenue Assurance vs.  Business Assurance: Who’s the Rightful King of Controls Software? interview with Sergio Luis Silvestre — Business controls software, originally developed for RA, is finding application in other areas of the business such as internal audit, collections, security and risk management.  This article argues that “business assurance” is the best term to describe this broader set of  controls software that can find a home in numerous departments or functions of a CSP’s business.
  • PwC on the Business of Revenue Assurance Consulting & Mentoring interview with Tim Banks & Dan Stevens — Revenue assurance consulting firms offer a broad range of services to clients these days.  The article explains the practice of mentoring RA mangers and providing a CFO with visibility on the status of an operator’s business controls.  Perspective is also offered on the value of RA software and the opportunity to broaden the RA practice scope.
  • Robots for Hire: Verifying Accuracy In the Age of Complex Mobile Billing/Charging interview with Xavier Lesage — As real-time charging and complex lifestyle calling plans gain credence across the globe in wireless, billing quality issues will rise in importance.  This article discusses a unique managed services approach to invoice testing and roaming fraud protection that checks results against advertised or published source data for the utmost accuracy.
  • Ericsson: Revenue Assurance Consulting With an NGN Flavor interview with Thomas Steagall — Helping operators detect billing and provisioning problem is merely table stakes in the RA services business these days.  The article discuss why operators need to ramp up their RA function with service experience and group-wide financial health monitoring.  Advise is also offered on: key RA maturity questions, risk-and-reward contracts, and how to extract greater value from software investments.
  • Do-It-Yourself RA for Small Operators and MVNOs interview with Mark Yelland — Budget-minded small operators and MVNOs are no longer hamstrung in RA capability anymore.  This article offers high-leverage strategies for operators who cannot afford expensive RA software tools.  With  data access, brains, and a DIY philosophy, any small operator can map a  path to greater RA savings, maturity, and program growth.
  • Revenue Assurance Maturity: Report From the Arena interview with Eric Nelson — Revenue assurance maturity can‘t be easily computed.  How do you  compare the KPIs of Comcast billing with that of mobile money RA in Western Africa?  Even still, this article offers some universal RA wisdom from a straight-shooting veteran of carriers large and small.  Topics discussed include: dashboard or process, COTS vs. inhouse solutions, and tips on gaining internal support for the RA practice.