Steps to fix Installed Base Data for Installed Base Selling – Part 1/4
Steps to fix Installed Base Data for Installed Base Selling

The world is full of obvious things which nobody by any chance ever observes. – Arthur Conan Doyle

Installed Base Selling is an important revenue stream for an industrial OEM. Without a comprehensive approach to do proactive Installed Base Selling, OEMs leave a lot of money, known as wallet share on the table. Our experience has shown that the aftermarket and service revenue expands multiple times if the problem is approached in a systematic way.But how to do effective Installed Base Selling?In the data-driven world, the answer lies in data, the Installed Base Data. How comprehensively can you lay your hands on the data? We will talk about data quality in a bit but the comprehensiveness of data is equally important. The more complete data you can lay your hands on, the better you will be able to weave the picture of your customer base and their behavior. Historical transaction data tells what has been purchased in the past. Combined with the warranties data and service interactions, it gives a powerful insight into the behavior of customers on a continuous basis. Studying the pattern can help in identifying the drifts both on the positive and negative sides. Unify the data with industry segments, geographies, product categories, and other segmentations and it can tell macro trends vis a vis your organization.In this blog, we will outline some simple steps to understand the extent of Installed Base Data. How the data can be cleaned and unified will be covered in a follow-on article. Knowing about all the obvious and non-obvious places where data resides is a good first step.

List out all the sources where data could be

A sample list could go as follows:

  • Oracle ERP
  • Mainframe 
  • Dynamics 365 CRM
  • Dynamics (on-premises version)
  • George’s aftermarket planning list
  • Warranty terms
  • Service contracts

Detail out the nature and volume of data for each source

SourceKind of DataData volumeExtraction mechanism
Oracle ERPCustomers, Order history from 2017Customers: 90K Orders: 1MQueries/API
MainframeCustomers, Order history before 2017Customers: Plug in your numbers hereCobol
George’s aftermarket planning listTop 40 customers in last 2 yearsCustomers with validated addresses: ~1000Excel

The step of tabulating every source system and the types of data included is important as it provides an extent of the data points that are available within the organization. As shown in the example, data sets may be residing in old legacy systems (legacy ERP/CRM systems, archives, etc) which were never migrated to the latest systems/platforms. This will also give a rough size of the Installed Base and the potential that can be unlocked in terms of aftermarket revenue growth. 

Draft relationship diagrams between different systems

Build a relationship diagram between different systems and outline the data flows (often manual) between systems. This exercise helps drive insight into how widespread is the problem of duplicate data. IT can also help in clustering similar systems in an organization. Overlaying product lines and business units provides a detailed picture of how the business function needs to align with the digital tools ecosystem.Steps to fix Installed Base Data for Installed Base SellingA comprehensive table of data sources, data models within that data source, and the volume of data residing in the system and interaction between different systems will provide a better sizing of the Installed Base data at hand. In the next blog, we will cover how to approach data quality.

Read Next Blog:

Found this interesting?

Sign up for more such content from Entytle- The Installed Base Company, delivered directly to your inbox

Ways to Get Started

Resources for your
Installed Base journey

Speak to an
Installed Base Expert

Explore our Installed
Base Platform


Join our next 30-min live demo!

Learn from our Installed Base experts how Entytle can help your organisation today.
Register Now

Explore Resources

Drive upsell within the Installed Base for global B2B manufacturers




Industrial Guides

Case Studies

White Papers


Tip Sheets