Email a colleague    

October 2012

Margin Analysis: Bolting Profit Assurance onto a Revenue Assurance Platform

Margin Analysis: Bolting Profit Assurance onto a Revenue Assurance Platform

Margin analysis is one of the hottest trends in business assurance and telecom analytics.

As a product manager for cVidya’s soon to be released margin assurance module for our MoneyMap platform, I’d like to share some perspective and explain what the excitement is all about.

To be honest, while margin analysis is hot, it’s not exactly new.  For years people have been performing margin analysis using Excel spreadsheets.  And in the early 90s, margin analysis was also a key benefit of owning a data warehouse.

So why are these approaches less than optimal?  I think the answer is they either take too much time or the results are not granular enough.  In a data warehouse approach it generally takes a good 15, 30 or 60 days to fully collect and analyze the data.  That’s pretty slow if your objective to manage your business in real-time.

Excel spreadsheets are great for producing periodic monthly, quarterly, and annual financial reports, especially where the inputs are aggregate (“coarse grain”) numbers.  But as soon as product categories are mixed and you need to segment results across “fine grain” customer groups and geographic regions, the Excel model becomes clumsy.

The Problem with Spreadsheets for Margin Analysis

I’d like to delve into the spreadsheet issue a little more to better explain why the Excel approach breaks down with added complexity.

Pretend you’re CFO at a mobile operator.  The overall costs of supplying an on-net service like SMS are very well known to you.  But a problem arises when you consider a bundled service where SMS is mixed, say, with the services you are buying from third party partners.

For example, let’s say I have a plan of 100 minutes of voice calls, 500 SMSs, 10 movies, and 20 ringtones.  The first two services are internal.  I know my SMS cost and the average cost of a voice call being dialed to various regions of the world.  But let’s suppose the subscriber makes a call to Russia and the call is routed through several international carriers who bill you for usage.  A case like that is much harder to model in a spreadsheet.

The same goes for content services like movies and ringtones that I buy from another provider.  First of all, the cost of a one particular movie could vary across different content providers.  Not only that, the way the movie is sold may vary.  One provider may charge $2 a movie; another provider charges you $500 for an unlimited number of downloads of the same movie.

So through this example, you begin to see how hard it is model such complexity in a spreadsheet.

But in our forthcoming margin analysis product in MoneyMap, we’ve taken into account the fact that many service providers want to enter costs derived from another system.  So we include places in the system where you can post external costs, say a computed average SMS cost.  That’s fine.

But in calculating the margin of service bundles that are mixture of on-net and off-net costs — that’s where the value add of a commercial software solution comes in.

Why is Margin Analysis Important?

Let’s step back and ask a more fundamental question: why are operators eager to implement this newer and better approach to margin analysis?  Well, here I would point you to two industry trends: increased competition and service complexity.  Consider these issues:

  • Multiple operators have been licensed to compete in any given geographic region, so tweaking services to achieve maximum profitability has never been more important;
  • Over the Top Players in mobile broadband are not only eating scarce bandwidth, but are offering profit killing alternatives to mobile voice and SMS, such as VoIP and proprietary text messaging.
  • Revenue per Subscriber is decreasing, so to remain profitable, protect the business, and exploit opportunities, every carrier needs to have a margin analysis capability.
  • Bundling of services has exploded.  Indeed, many operators have become triple- or quad-play providers, making it harder to gain a consolidated view of margins; and,
  • Finally, Interconnect and Content Partners have expanded, underscoring the need to monitor these partners from a service profitability view.  Even a cable or satellite company need margin analysis because they buy external carrier services and content and need to better understand what they are buying.

The Benefits of Margin Analysis

Many departments at a telco will find margin analysis useful, but marketing and finance probably get the most benefit because it’s all about analyzing the profitability of different products and services.

With usage data collected from the network plus invoices to subscribers and from third party partners, we can analyze each and every subscriber and service.

Here are the most important uses of margin analysis:

  • Pricing Plan Analysis — Marketing  can analyze whether a particular pricing plan has a high or a low margin.  They can also analyze the usage pattern of customers using a particular plan.  Incidentally, the popularity of flat rate billing makes margin analysis doubly important because the rates you charge for the service are less subject to change.  If the usage of certain elements in the pricing plan go up unexpectedly, the service could quickly become unprofitable or even turn into a loss.
  • Service Hierarchies — Margin analysis can reveal the margins on different hierarchies of a service.  For example, if the service is international calls to Germany, you can also examine the margins on a sub-service — such as international calls to mobile phones in Germany.
  • Market Segmentation — Margin analysis allows you to look at customer profitability in great detail.  You can see the margins for subscribers living in a specific region or business customers in a particular industry.  And tracking service over a full year permits comparing services in different times of the year.
  • LTE Service Monitoring — LTE  basically changes how we think of a service.  For instance, LTE services have hooks to allow you to base pricing on the quality of service or bandwidth consumed.  Services can be enhanced during an actual session.  All of these factors will make it harder to analyze the LTE service margins.
  • Friends and Family Plans in Mobile Data — Verizon’s Share Data Plan collects and combines usage from multiple family members across 10 devices -iPhones and iPads for example.  The idea is the customer pays a flat rate such as $200 for 10 devices.  Well, a service like that requires constant vigilance to ensure it remains profitable because there are many variables in the service that could spike up costs.
  • Experimentation and Testing — Finally, since the uptake of particular services is getting tougher and tougher to forecast, being able to assess the margins of a product 24 hours after launch becomes critical to making adjustments to the product, particularly as it’s been tested in a small market and full-market roll-out.
Margin Analysis

Sorting out Revenue, Direct Costs & Indirect Costs

The whole objective of margin analysis is to understand the financial profit or loss status of individual telecoms products, services, and packages.  To do that we subtract the total revenues of a particular product with its costs?

Sounds easy, right?  Well, it would be easier if we didn‘t have to deal with two entirely different kinds of costs.  There are the direct costs associated with the particular service you are trying to get the margin of.  Then, there are also hundreds of indirect costs such as the salaries of people, marketing costs, etc.

Luckily data on indirect costs is relatively easy to obtain.  That data lives in a telco’s financial system and is computed by adding up payroll, purchases and the like.  Now, there are many different ways to combine indirect costs with direct cost to arrive at a full-loaded margin analysis.

cVidya’s approach is to leave the method of combining direct and indirect costs up to the individual operator.  Instead, we focus on the hard part — sorting out the direct costs of the individual services, products, and bundles.

The difficulty here comes from the need to gather direct costs from data sources scattered across the telecom enterprise.  For instance, interconnect contracts are managed by the business.  Usage collection is done by engineering.  Pricing plans are done by marketing.  In short, many pieces of the organization jigsaw puzzle need to come together.

Merely collecting information from all these sources is challenging.  Then there’s the added task of managing the many algorithms or formulas used to calculate profitability.

Billing cycles add another huge level of complexity: since telecoms bill on many days of the month, so you have to figure out how to align those billing cycles to get an accurate margin.

Volume commitments to partners are yet another complicating factor.  For instance, in content settlement, the rate may be $100,000 per month for a certain level of subscriber purchases, but $150,000 per month if that volume commitment is not met.

So sorting out all these complexities — and fitting them in with the unique needs of individual telcos -- is where the real value of margin analysis software comes in.

Easy to Implement — Based on Revenue Assurance Data

As I mentioned at the outset, the great news for financial and revenue assurance professionals is that margin analysis isn‘t one of those costly applications that only large carriers can afford.  On the contrary, at cVidya, we are implementing it as a “bolt-on” solution to RA.

RA software essentially paves the way for margin analysis because every department who has an RA solution already has most of the source data already collected, normalized, and augmented with added data such as the demographic, regional, and network information associated with customers.

Adding margin analysis to RA brings some nice advantages.  The analytics information is online and users can interact with it dynamically to drill down to specific segments or even create new alerts.  And because the platform is based on xDR-level data as opposed to just aggregate numbers, you can view the various dimensions data in highly granular segmentations.

Here are some examples of the flexibility this new style of margin analysis solution delivers:

  • High segmentation — In most cases today, margin analysis today is per plan, but with a revenue assurance-based solution, you can drill down, say, to international calls made on a mobile phone from the financial district of Milan, Italy on the second week of November.
  • Alarm when Margins Deviate from Normal — The user can decide what types of margin changes trigger alarms.  For example, you can set an alarm threshold to go off when the margin on traffic with an international carrier goes down by 25%.
  • Dynamic segmentation — The data dimensions are fully under the user’s control, enabling highly customized analysis.  For instance, you can compare the margins of specific media vendors serving the youth market by youth category, time, and region.

Conclusion

Margin analysis, catalyzed by big data platforms and leveraged by revenue assurance systems already in place, brings some exciting new business-optimization power.

It will allow a telecom organization to deliver not just revenue assurance, but real-time and fine-grained “profit assurance” as well.

Copyright 2012 Black Swan Telecom Journal

 
Efrat Nissimov

Efrat Nissimov

Efrat is the Director of Product Management in the Marketing department in cVidya, responsible for the Revenue Assurance, Fraud Management and Risk Management products and solutions.  Efrat has 17 years of experience in the communications and telecom industry.  Prior to joining cVidya, Efrat worked 10 years in TTI Telecom (now part of TEOCO) as a Product Manager and Solution Engineer of the CDRs products.  Prior to this position, Efrat worked in the Engineering and Operations Departments in two leading Communication Service Providers in Israel.   Contact Efrat via

Black Swan Solution Guides & Papers

cSwans of a Feather

  • Atlanta-lytics: New Telecom Conference Features Revenue and Customer Analytics by Dan Baker — A new telecom conference on analytics in Atlanta (January 29 — 31) is shaping up to be a key event for people who want to stay abreast of this fast moving field.  Black Swan is hosting a half-day, pre-conference workshop entitled, “Financial and Revenue Analytics” featuring seven speakers, many of whom are contributors to this magazine.  Detailed program guide is enclosed.
  • Big Data Financial Analytics: Creating Business Value for Tier 1 Telecoms interview with John Devolites & Atul Jain — What exactly is an analytics company?  This interview with executives at TEOCO helps defines this new breed of telecom solution vendor — a cross between software, consulting, and assurance supplier.  Along with a few Tier 1 case studies, the interview discusses: big-data vs. sampling, analytics project management, and the importance of data access.
  • Margin Analysis: Bolting Profit Assurance onto a Revenue Assurance Platform by Efrat Nissimov — Margin analysis is one of the hottest trends in business assurance.  But what’s all the excitement about?  This article explains the benefits, the market forces driving its adoption, and its advantages over Excel and heritage data warehouse approaches in terms of flexibility, data granularity and quicker time to access.  The author also touts major cost savings if margin analysis is deployed as a module within an existing revenue assurance suite.
  • Is Offering Free International LD on Your Horizon?  Follow These Checkpoints by Hulya Altinsoy — Free is a magic word for consumers.  So how about adding free international long distance (LD) to your list of services?  While free international LD serivce is fraught with risk, the article presents a  5-point checklist to help get your bearings before you make the leap.  The article also presents an analysis of billions of minutes in international LD calls by U.S. wireless carriers.

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.