Case Study

Dealer Lifetime Value Model for Automobile Industry

Enabling an Automobile IT service provider to evaluate the $ Lifetime value of its Dealers.

About the Customer

The customer is a partnership organization between two automobile dealerships and one of the leading US automobile manufacturing companies. The company focuses on using the data collected from past enrollents to provide  analytics-driven value add for the parent organization.

Business Challenge

The customer reached out to Brillio to reap the benefits of our experience in analytics and the digitization space to execute dealer’s lifetime value estimation exercise. This aided in classifying high lifetime value and successfully strategized steps to shift dealers from low value to high value segments.

The objectivewas to develop a machine-learning based solution to identify the $ lifetime value for every dealer and to strategize how to move dealers from low value segments to high value bucket.

In assignments of this nature, the key challenge lies in gathering the right data and deciding on a precise method to compute the objective metrics, in this case, dealer lifetime value.

There were ~2000 dealers and yearly enrolment data was taken for a history of ~20 years. Another challenge was to sift through an overwhelming mass of data and information to find a practical answer to a hitherto intractable problem.

Solution Approach

 

Step 1 Calculation of Adoption Rate

From the legacy enrolments data available we calculated net enrolment over the years , then estimated adoption rate for each dealer.

Step 2 Forecasting & Extrapolating

From the data available we extrapolated the data for next 5 years and projected to find the incremental value for each dealer.

Step 3 Bucketing

Using the diffusion of innovation theory we created three adoption buckets (Low, Medium, High) on the basis of declining average adoption rates per dealer over the years in the ratio of (30%-40%-30%) respectively, then to find the $ lifetime value we completed revenue extrapolation.

Business Insights

  • Strong positive correlation exists between number of enrolments done per year and dealer lifespan (years of association with company).
  • 13% of dealers falling in the high LTV segment have an average expected $ value that is double than the medium segment and four times more than that of the low segment.
  • High LTV segments have a higher $ range ($1,400,000) with a minimum of $480,000 and a maximum of $1,850,000. This range is much lower than the medium ($200,000) and low ($250,000) segment.

A significant amount of time has passed since my last article on this topic. One of the exceptional qualities of […]

@Fahim Khan • Nov Tue 20

The workplace’s infrastructure and design are a crucial part of any business’s key decisions and are important for its growth. […]

@Siva Perubotla • Nov Tue 20
Latest Case Study
LinkedIn Instagram Facebook Twitter