Retail Analytics Segmentation
These Scores and Segments will be stored in a new Fact Table. The inputs for this model will come from the following tables:
- Location
- Credit Rating
- Currency
- Geography
- Industry
- Product
- Age
- Income
- Gender
Similar Product Types which are used in Price Creation and Discovery are being referred to as CARDS for Credit Cards and Term Deposits.
When Price Creation and Discovery is integrated and is installed with IPA, the user is required to update column V_PRODUCT_TYPE in the FSI_SEG_REP_LINE_MAP table accordingly to match the Product Type used in the Price Creation and Discovery Application.
Table 2-1 FCT_ACCOUNT_SEGMENT_SCORE
| Column Name | Logical Name |
|---|---|
| N_ACCT_SKEY | Account Key |
| D_ACCT_START_DATE | Account Start Date |
| N_ACCT_SEGMENT | Account Segment |
| N_ACCT_SEGMENT_SCORE | Account Segment Score |
| N_RUN_SKEY | Run Key |
| N_MIS_DATE_SKEY | Date Key |
The above table acts as the input for another table that stores facts of Account Profitability (Movement, Average Balance, and so on) at the level of Month on Book, Account Segment, Run, and Reporting Line. Following is the structure of this table:
Table 2-2 FCT_ACCT_SEGMENT_MOB_SUMMARY
| Column Name | Logical Name |
|---|---|
| AVG_BAL_RCY | AccountAverageBalanceReportingCurrency |
| N_END_BAL | AccountEndingBalance |
| AVG_BAL | AccountAverageBalance |
| END_BAL_RC | AccountEndingBalanceReportingCurrency |
| MOVEMENT | Movement |
| MOVEMENT_RCY | MovementReportingCurrency |
| REP_LINE_CD | ReportingLineCode |
| RUN_SKEY | Run Key |
| MONTH_ON_BOOK | Month on Book |
| ACCT_SEGMENT | Account Segment |
DIM_SEGMENT_TABLE is populated using SCD Process (Map reference number 267) and the source would be a view DIM_SEGMENT_V for which data would be from DIM_SEGMENT_B/TL and FSI_SEGMENT_TYPE_CD/MLS tables. FSI_SEGMENT_TYPE_CD/MLS table stores a list of Segment Types used in IPA. For example, Corporate Tracker, Behavioral, Profitability segments, and so on.
The Segment score is not updated. The Rule updates only the n_segment.
The Segmentation models within CI are also used to provide an output to OFS Price Creation and Discovery Application (OFS PCD). The Segments within CI calculate the average values of Profitability components which are then used in PCD to analyze the future behavior of an Account belonging to that Segment and predict its Profitability.