Innovative data warehousing solution for improved marketing decisions

An innovative data warehousing solution for improved marketing decision making and enhanced offer composition divisions

In the pursuit to increase overall revenues
In the pursuit to increase overall revenues, telecom companies need to understand their profitability – both across customers and products.

Resolve Tech helped the client, an American telecommunications conglomerate, streamline its profitability reporting process using a data warehousing and analytics solution. The solution enabled the client to make data-oriented decisions about marketing campaigns. Due to single version of truth shared by all departments: Marketing, Operations, and Finance, the telecom major was able to overcome inherent delays & inaccuracies in the profitability reporting. The client thus achieved faster management reporting, improved marketing decision making, and better data synergy across various departments.

200+
Business rules migrated with over hundred cost attributes factored
45 to 3 days
Reduction in processing time for generation of RCM report
Over 99%
Matching of business rules with those of the legacy system

Context

In recent years, telecom companies have become increasingly focused on simultaneously maximizing revenue yields & profitability and meeting the evolving product preferences of their more profitable customers.

Our client, an American telecommunications giant, wanted to keep track of their profitability margins with Revenue per Customer per Month (RCM) and RCM Accretion over time- as target metrics for measuring the success of their past marketing campaigns

However, lack of relevant data, low accuracy & timeliness of RCM reporting process was causing delays in decision making. Also, limited flexibility of their legacy system on providing support for visual rendering of reports and resistance to business changes was leading to a large and unfinished backlog.

Context
Solutions

Solutions

The client decided to empower management with data-driven strategic decision-making through advanced analytical capabilities. With Resolve Tech as a technical partner, the client implemented a new Enterprise Data Warehouse with billing details that uniquely identify every customer to compute revenue data across customers or segments in aggregate.

Additionally, Resolve Tech also addressed reporting and data needs of other departments, namely Operations and Finance, along with the RCM reporting needs of the Marketing team. To achieve the above, Resolve Tech worked with various teams, specifically the BODS team to understand the existing functionality of data mappings and RCM computation.

The solution included the following capabilities:

  • Customer Tracking by segment based on RCM sensitivity to price-ups, roll offs, etc. for tailored marketing decisions.
  • Computation of cost of service based on mapping of billing details to the product master data for automated cost & margin calculations.
  • Computation of prior 4 months cost & margin to enable customer to promote offers to consumers based on past trend.
DATA STRATEGY

DATA STRATEGY

Data extraction from legacy systems and definition of business rules and KPIs to be pre-built into the data warehouse
ETL & DATA WAREHOUSE

ETL & DATA WAREHOUSE

Teradata based Data Warehouse that integrates with product and billing systems (including legacy accounts)
REPORTS & ANALYTICS

REPORTS & ANALYTICS

Advanced reporting and analytics engine with a daily refresh of data and self-service features for power users
DATA AND INSIGHTS VISUALIZATION

DATA AND INSIGHTS VISUALIZATION

Self-service capability for users to analyze profitability data across customer segments, products, and geographies
CUSTOMER TRACKING

CUSTOMER TRACKING

Segment based monitoring to help understand the sensitivity of RCM to specific events such as price-ups, roll offs, etc. for tailored marketing decisions
COST & MARGIN CALCULATIONS

COST & MARGIN CALCULATIONS

Automated computation of cost of service of individual customers, and across all customers, eliminating manual process
Benefits

Benefits

The new data warehouse and analytics system simplified reporting of RCM, cost, and margin data across the organization. This led to sale of more profitable products to consumers by leveraging the RCM reports based on recent data. The solution also promoted:
  • Improved Profitability with focus on selling more profitable products as demonstrated by the RCM data
  • Enhanced Synergy across Marketing, Operations, and Finance as all departments now receive reports based on the same data
  • Targeted Marketing through segment-specific promotions that relied on actual consumption patterns