The Good, the bad and the ugly... what does your customer look like?

"ProCogia was approached by a financial institution to segment debit card customers based on their usage behavior." John Y. and Holly W.

Save PDF


Client had built up a large customer base in a short duration of time and did not clearly understand the overall variation in population. It had been previously observed that the segments did not differentiate on demographics and usage attributes and that was proving a challenge for the client as it was not able to determine the right product mix for effective marketing efforts.

Key Objectives

  • Improve ROI on marketing campaigns.
  • Identify the appropriate product mix for different segments.


ProCogia had following activities in mind when putting the BI Infrastructure in place:

  • Analyzed the Customer level and transaction level data. Three pre-requisites for the data were using non – repetitive, non – missing and non – derived data.
  • Selected the following key influencing attributes:
    1. Longevity
    2. Usage (no. of times/mo.)
    3. Spent ($/mo.)
    4. Transaction Behavior
  • Determined optimum number of customer segments based on profile differences & statistical benchmarks using cluster analysis.
  • Identified homogeneous segments with respect to the profitability drivers, and helped design specific products suited for different segments.


Revenue was increased by 54% as ProCogia helped institutionalize a new data driven segmentation of customers and it is being used to assign all the accounts to one of the segments. The model further helped increase revenue generation by designing appropriate product mix for each segment.

Additionally, the segmentation was leveraged for the new marketing campaigns to increase their effectiveness.