1 / 18

Market Optimization Phase VI

Maximize Profit(A)=. i = 1, …, M customers j = 1, …, N offers A = (a ij ) is a matrix where a ij = 1, if offer j is to be targeted to prospect i and 0 otherwise. A ij *( profit,cost,score ) ij. Market Optimization Phase VI. May 2012. Optimization & Market Expansion.

haamid
Download Presentation

Market Optimization Phase VI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Maximize Profit(A)= i = 1, …, M customers j = 1, …, N offers A = (aij) is a matrix where aij = 1, if offer j is to be targeted to prospect i and 0 otherwise Aij*(profit,cost,score)ij Market OptimizationPhase VI May 2012

  2. Optimization & Market Expansion • Optimize current screen criteria to local market conditions • Include all zip codes in current markets • Integrated Data Warehouse “Buckets” across all sources - ITA, PA, Trigger, Vertical, TBD • Optimizing target selections via individual screens • Relevant Messages • Model Scores • Performance Scores by Branch, Channel, Branch, Proprietary Targeting Cells

  3. Extreme Situation: Too tight of Screens and 91.% of Homeowners were screened out of Target base

  4. INCOME TU has only individual level of Income, this is aggregated income per household Even though we aggregated income per household, TU income is lower than Census Info. Prospects with less than TU Defined $30K individual Income, eliminated over 15% of the market opportunity

  5. HOME EQUITY New Intellidyn Home Value – Maximum of TU home value, Mortgage 1 balance or Mortgage 2 balance About 5% homeowners have a loan which has higher mortgage balance than home value 01 - 02

  6. Scored individual records from multiple master files Selects based on deciles from multiple buckets All phone numbers Verified/corrected for Telemarketing Pre-determined mix of ITA/PA/Vertical Same Select based on model score from one aggregate bucket Solicitations by telemarketing and/or email based on model score and optimization No pre-determined mix of sources. Optimization chooses records most likely to respond and convert Optimization Vs. Current Production Current Production Intelli-Optimization

  7. Maximize Profit(A)= i = 1, …, M customers j = 1, …, N offers A = (aij) is a matrix where aij = 1, if offer j is to be targeted to prospect i and 0 otherwise Aij*(profit,cost,score)ij Mathematical Function for Optimization The multidimensional optimization technique requires the exact mathematical solution to the maximization or minimization of multi variable functions (i.e. business goal of a campaign such as profit, budget or sales). The final objective of the analysis is to exactly determine which specific offers (aij) to target to each individual prospect simultaneously optimizing business goals while satisfying business rules/constraints and local market conditions.

  8. Required Input for Market Optimization -Business Goals (Maximum Profit, Minimum Budget, Maximum Number of Sales) -Dimensions (Offers by channels, etc. ): Campaign typically consists of several offers for targeting to a large set of prospects*. Each channel is associated with the following attributes necessary to calculate the business goal to be optimized: Response Model score for calculating probability of a prospect to respond to the offer Conversion Model score for calculating probability of a prospect to be funded. Profitability model score for calculating the profitability of a prospect for the offer Eligibility condition for determining eligible prospects for the offer Economics such as the delivery costs and selling costs of the offer -Constraints: Campaigns have several associated constraints such as budget limitations, minimum profit requirements and maximum number of offers that can be targeted to a prospect. * Prospects for this example were a 10% sample of three buckets, ITA, PA, Vertical

  9. How Market Optimization Works • Calculates Net Present Value (NPV), expected profit, number of sales, etc. across multiple campaign parameters • Applies Constraints to determine eligibility of each prospect to each campaign (i.e.need a phone number for telemarketing) • Applies Business Rules (I.e. 1 offer per Household, Budget constraints, etc.) to determine the optimal offer for each prospect

  10. Performance*, Score & Cost Metrics *All performance metrics are based on MIS report as of 4/4/2012

  11. Score Function Business Goal: Find most appropriate objective function Probability to respond =( Response model score + Historical Performance by channel )/2 Probability to Convert =( Conversion model score + Historical Performance by channel )/2 Cost = Source cost + Cost by channel Budget vs. Branch Budget Exercise: Optimize Budget allocation Probability to respond = Response model score Probability to Convert =( Conversion model score + Historical Performance by branch )/2 Cost = Source cost + average Cost for all channel

  12. Overall Scenario Results Scenario 2 has lowest CPL but no other higher results Scenario 3 has most responders but Resp. Rate and Fund Rates are low Scenario 4 has highest fund rate but also a higher CPL Red Highlighted numbers represent max/min for each column

  13. Business Goal : Max Loans

  14. Business Goal : Minimum Cost Per Loan

  15. Business Goal : Minimum Budget

  16. Business Goal : Minimum Budget

  17. Budget: Overall Vs. Branch

  18. Market Optimization Next Steps • Use to Determine or test market Screens • Development of channel specific models will increase performance of Optimization Software

More Related