Data · 2026.10

Checking-account acquisition targeting

An individual timed project for NYU's Advanced Business Analytics, on a course case about a fictional regional bank: a funding model that predicts how much a new checking account will hold, combined with the bank's response score into an expected value per letter. Mailing the 8,000 highest-value prospects instead of the most likely responders raises expected first-year profit from about $17K to about $120K on the same budget.

Role
Individual project — NYU Advanced Business Analytics
Period
2026.10
Stack
SAS Viya (Visual Analytics) · Python · pandas · Excel
Scale
30,000 past prospects · 25,000 to score · 2 funding models: linear regression, random forest · 9 segments · 8,000-letter budget · ≈$120K vs ≈$17K expected profit

Exhibits

Individual timed project for Advanced Business Analytics at NYU, October 2026, on a course case about a fictional regional bank, shared with the instructor's permission. The segment table, the score check, the correlations and the hand-scored prospects are recomputed at build time from the two case files below; the model metrics come from the SAS Visual Analytics run submitted with the report.

Past prospects
30,0007.20% opened · 2,161 accounts
Openers below break-even
33.9%funded under $2,000 in 90 days
Funding model
0.74Spearman rank correlation · R² 0.52
Plan A · rank by value
$119.7Kexpected first-year profit, 8,000 letters
Plan B · rank by response
$16.8Klast year's rule, same budget

Case data

Two models, one number per letter

  1. Response score p_openprovided · top-decile lift 3.26
  2. Funding model: 90-day balance if openedlinear regression · 2,161 openers
  3. Value of an opened account0.025 × balance − $50
  4. Expected value of a letterp_open × value − $1
  5. Mail the top 8,000$8,000 budget
Exhibit 1. The bank already had a response score. The missing half was a funding model that predicts how much an account holds if it opens; Finance's rule turns the pair into the expected value of one letter, and the mail file is the top 8,000 by that value.

The response score ranks well and is honest about its odds

30,000 past prospects in ten equal groups by p_open · bars: actual open rate · dots: average p_open

Actual open rateAverage p_open

0%5%10%15%20%25%7.20%lift 3.26×12345678910Decile →
Exhibit 2. The top tenth opens at 23.5%, 3.26 times the 7.20% average, and the rate falls almost steadily to 0.97% in the bottom tenth. In every decile the average score sits within about 0.8 points of what actually happened, so the probabilities can go straight into the value formula without recalibration.

What predicts opening is not what predicts money

Pearson correlation · left: with opening, all 30,000 prospects · right: with the funded balance, 2,161 openers

with opening−0.50+0.50with funded balance−0.50+0.50Household income−0.04+0.48Age−0.15+0.48ZIP median income−0.03+0.28Years at residence−0.09+0.11Distance to branch−0.04+0.01Web visits, 30 days+0.12−0.00Mailings, 12 months−0.02−0.01Digital engagement+0.14−0.32
Exhibit 3. Younger, digitally active prospects are the ones who open; older, higher-income prospects are the ones who fund. Age and digital engagement flip sign between the two columns. Net-worth band, the strongest driver of balance in the model, is categorical and does not appear here.

The segments that open most hold the least

nine segments of last year's file · x: open rate · y: average 90-day balance of openers (log scale) · circle area: prospects in the new file · filled: mailed under Plan A

$2K$5K$10K$20K$50K2%4%6%8%10%12%$2,000 break-evenUnder 45 · <$50KUnder 45 · $50K–250KUnder 45 · $250K–1MUnder 45 · $1M+45+ · <$50K45+ · $50K–250K45+ · $250K–1M45+ · $1M+No third-party dataOpen rate →↑ Average balance
Exhibit 4. Young prospects with under $50K net worth open at 11.8%, the highest rate, but fund $1,958 on average, just under the $2,000 line where an account stops paying for its $100 bonus. Prospects aged 45+ with $1M+ open at 3.5% and fund $37,871: worth $30.40 per letter against −$1.13.

Same budget, about seven times the profit

8,000 letters allocated by segment · bar length: letters · label: expected profit

Plan A · highest value per letter first

$119,731expected profit

  1. 45+ · $1M+1,409 letters$42,834
  2. Under 45 · $250K–1M451 letters$11,221
  3. Under 45 · $1M+47 letters$940
  4. 45+ · $250K–1M3,504 letters$48,425
  5. Under 45 · $50K–250K2,589 letters$16,311

Plan B · highest open rate first (last year)

$16,825expected profit

  1. Under 45 · <$50K5,089 letters−$5,751
  2. Under 45 · $50K–250K2,683 letters$16,903
  3. Under 45 · $250K–1M228 letters$5,673
Exhibit 5. Plan B spends 5,089 of its 8,000 letters on the young, low-net-worth segment and loses about $5,750 there. Plan A mails older and wealthier segments first and expects $119,731 against $16,825. It opens fewer accounts, which the marketing team should expect and explain.

Three prospects, scored by hand

linear funding model applied coefficient by coefficient · negative predictions floored at $0

ProspectProfilep_openPredicted balanceEV per letterRank by p_openRank by EV
Aage 27 · income $48K · <$50K · digital 880.35−$593 → $0−$18.5013
Bage 46 · income $95K · $50K–250K · digital 600.04$9,484+$6.4822
Cage 66 · income $140K · $1M+ · digital 350.012$44,203+$11.6631
Exhibit 6. Prospect A is 29 times as likely to open as C, but the model predicts a negative balance for A (the linear terms simply add up past zero), so every opening loses money. C rarely opens and is worth the most per letter. Mail C, then B; do not mail A.

Problem

A bank mailed checking-account offers to 30,000 prospects last year and chose them with a response model: the people most likely to open. About 7% did. Finance then found that many of those accounts held almost nothing, and after the $100 opening bonus they lost money. With a fixed $8,000 budget for 8,000 letters and 25,000 new names, the marketing head asked a different question: who is worth the most to the bank, how much profit should she expect, and how does that compare with last year’s rule?

Decisions

Frame the decision as profit, not response. An opened account is worth 0.025 × its 90-day balance + $50 in fees − the $100 bonus, so it only pays above a $2,000 balance. In last year’s file a third of the accounts that opened (732 of 2,161) were below that line. The response score answers will they open; the missing half was how much will they bring. The two combine into the expected value of one letter (Exhibit 1), and the mail file is ranked by that value.

Check the score before trusting it. In ten equal groups the top tenth opens at 3.26 times the average rate, and each group’s average score is within about 0.8 points of its real open rate (Exhibit 2), so the probabilities could go straight into the formula.

Build the funding model on openers only, and keep the future out of it. The predicted balance is multiplied by the probability of opening, so it has to be the balance if the prospect opens: the model was fitted on the 2,161 accounts that opened, with a 70/30 holdout. Two fields were measured at the data extract date, after the campaign — the total deposit balance, which already contains the new account, and payroll direct deposit — and were left out as leakage. The 4,194 prospects without third-party data are blank on all nine vendor fields at once, so “no vendor match” was kept as its own level rather than imputed away; a 999 in days-since-contact means never contacted.

Choose the model the business can use. A random forest was 2.5% better on validation RMSE ($6,620 against $6,790). The linear regression was kept: it ranks almost identically, it can be scored by hand and explained to the marketing team, and it can be audited for fairness. Its known flaw, negative predictions for low-value profiles, is handled by flooring at $0 as Finance specified.

Turn the model into a plan without a scoring system. Nine segments — age group × net-worth band, plus the no-vendor-data group — were valued from last year’s results and counted in the new file (Exhibit 4), then mailed in order of value until the 8,000 letters ran out (Exhibit 5). Three new prospects were also scored by hand with the regression to show the logic at the level of one person (Exhibit 6).

Result

The balance drivers point the opposite way from the response drivers (Exhibit 3). Net worth matters most: $1M+ adds about $27,000 to the expected balance against under $50K; each $1K of household income adds $46 and each year of age $123, while each point of digital engagement takes away $48. The validation metrics say the model is better at ranking than at dollars: a typical error of about $3,600 (MAE), RMSE pulled up by a handful of six-figure accounts, and a Spearman rank correlation of 0.74 against an R² of 0.52 — enough to put the right people above the cutoff.

Ranking segments by value (Plan A) mails people aged 45+ with $250K or more, younger people with $250K or more, and part of the younger $50K–250K group, for an expected first-year profit of $119,731. Last year’s rule (Plan B) spends 5,089 letters on young prospects with under $50K, the only segment with a negative value, and expects $16,825. The value-first plan opens fewer accounts, which the memo told the marketing head to expect. Positive-value segments hold 19,911 new prospects, about 2.5 times the budget, so the memo also made a tested case for more letters into the next segments, stopping before the two break-even ones.

Limits

The balance predictions are rough: errors of several thousand dollars are typical, and the average of the smallest segment (under 45 with $1M+) rests on two past openers. Segment values are last year’s averages; last year’s prospects got a random $0, $100 or $200 bonus, while everyone now gets $100. The models cannot see assets held at other banks, and 14% of prospects have no vendor data at all. Targeting on age, net worth and ZIP-code income also carries fair-lending and reputational risk, so the memo asked for a pre-launch comparison of the mailed share by ZIP income tier and age band against the eligible pool, and a randomized control group mailed by last year’s rule to measure profit per letter at 90 days rather than response alone.

← Back to home