Jun 12, 2013, 7:24 pm
Last edit by: Schmoops
Figured a highly collaborative effort like this needs a wikipost. As items and codes are confirmed, let's centralize them in one place rather than thumb through hundreds of discussion posts.
How to pull your information
Log into your SkyMiles account at Delta.com, then visit this link: https://www.delta.com/databroker/bcdata.action
What the items indicate
v01: Closest airport to home address (encoded using key 1)
v02: Country of residence
v03:
v04: Preferred departure airport/city (encoded using key 2)
v05: Language
v06: discSpndngAmt, in thousands
v07: Skymiles status level
v08: State/province (encoded using key 2)
v09: Pay with Miles eligible
v10: sunTrstInd
v11: prefDestCity
v12: MQS
v13: Hotel loyalty programs stored in DL.com profile (encoded using key 2, see post #829)
v14:
v15: Income, in thousands
v16: Current age + 99
v17: 1/2/3 MM Status
v18: Home value, in thousands
v19:
v20: SkyClub member
v21: SkyMiles account number
v22: Experian Mosaic segment (encoded using keys 1 and 3, see http://www.flyertalk.com/forum/delta...l#post20913445) Description here and Segment Details here
v23: Saved search destination airports (encoded using key 1)
v24: SkyClub renewal date (coded using key 3)
v25: Saved payment information (encoded using key 1) AND SPG status (encoded using key 1, see http://www.flyertalk.com/forum/delta...l#post20913463)
v26: Gender/prefix (1=male/Mr, 2=female/Ms/Mrs, 3=Dr/other) (to be confirmed)
v27:
v28: SkyMiles account number with 3 leading zeros (called "CustID" in previous data)
v29: Logged in (SM account)
v30: Customer Value Score (Questionable, and scale is unknown)
v31: RDM balance
v32: Dream trips from DL.com profile (encoded using key 2)
v33: MQM balance
v34: Activities & Interests from DL.com profile
v35:
v36:
v37:
v38:
v39: ?? Duplicate for Language ??
v40: ?? Duplicate for Country of Residence ??
Encoding
Three different coding keys are used for variables 01, 04, 08, 13, 22, 23, 24, 25, and 32. For full mappings, click here: Keys 1, 2, and 3
How to pull your information
Log into your SkyMiles account at Delta.com, then visit this link: https://www.delta.com/databroker/bcdata.action
What the items indicate
v01: Closest airport to home address (encoded using key 1)
v02: Country of residence
v03:
v04: Preferred departure airport/city (encoded using key 2)
v05: Language
v06: discSpndngAmt, in thousands
v07: Skymiles status level
v08: State/province (encoded using key 2)
v09: Pay with Miles eligible
v10: sunTrstInd
v11: prefDestCity
v12: MQS
v13: Hotel loyalty programs stored in DL.com profile (encoded using key 2, see post #829)
v14:
v15: Income, in thousands
v16: Current age + 99
v17: 1/2/3 MM Status
v18: Home value, in thousands
v19:
v20: SkyClub member
v21: SkyMiles account number
v22: Experian Mosaic segment (encoded using keys 1 and 3, see http://www.flyertalk.com/forum/delta...l#post20913445) Description here and Segment Details here
v23: Saved search destination airports (encoded using key 1)
v24: SkyClub renewal date (coded using key 3)
v25: Saved payment information (encoded using key 1) AND SPG status (encoded using key 1, see http://www.flyertalk.com/forum/delta...l#post20913463)
v26: Gender/prefix (1=male/Mr, 2=female/Ms/Mrs, 3=Dr/other) (to be confirmed)
v27:
v28: SkyMiles account number with 3 leading zeros (called "CustID" in previous data)
v29: Logged in (SM account)
v30: Customer Value Score (Questionable, and scale is unknown)
v31: RDM balance
v32: Dream trips from DL.com profile (encoded using key 2)
v33: MQM balance
v34: Activities & Interests from DL.com profile
v35:
v36:
v37:
v38:
v39: ?? Duplicate for Language ??
v40: ?? Duplicate for Country of Residence ??
Encoding
Three different coding keys are used for variables 01, 04, 08, 13, 22, 23, 24, 25, and 32. For full mappings, click here: Keys 1, 2, and 3
Delta and new DL.com Profiles A Lot About You
Jun 13, 2013, 3:29 pm
#976
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 13, 2013, 3:34 pm
#977
FlyerTalk Evangelist
Join Date: Jun 2008
Programs: Formaldehyde Medallion DL DieMiles
Posts: 12,646
Over 60K spend on a DL Reserve card
About 15K DL ticket spend (not including another $3000 on tickets purchased thru client's travel group)
Very few LUTs.
Minimal award travel.
If award travel is factored in, I guess the implication is that it would be as a decrement?
Should someone willing to pay 300K for a 60K ticket be given a increment in CSV?
Jun 13, 2013, 3:34 pm
#978
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Anyone else have discretionary spending be more than the annual income shown? For me both of the DL profiles I've checked, discretionary income (v06: discSpndngAmt, in thousands) is...sort of within the right range, but is higher than the field for total annual income (v15: Income, in thousands), which leads me to believe that the latter, v15, is not really that and is something else... but what?
Just quite clearly discretinary spending can't be higher than income (well unless one is retired, I guess).
Just quite clearly discretinary spending can't be higher than income (well unless one is retired, I guess).
Jun 13, 2013, 3:38 pm
#979
Join Date: Aug 2009
Location: HNL
Programs: UA Gold | Former: DL Diamond, HA Pualani Gold
Posts: 380
Made a big move in fall of 2012 from DC to Honolulu, so who knows what this considers. Changed address in Delta's system in October, maybe.
2012: probably about $6-8k on Delta on cheap and K fares mostly, travelling twice a month, mostly to ATL and LAX from DCA until my September move. Then like 2013 after the move.
2013: probably about $10k so far on all of the following: cheap, K, B, and FPA fares, travelling once a month, mostly to ATL, SEA, and SFO from HNL
Amex Reserve holder since late 2012, hit $60k in 2012, and I've just hit $60k in 2013.
Made Platinum in December 2012, ultimately based on Reserve spend.
Very little personal award travel, though I'll use miles for upgrades from Hawaii when available. I almost never fly coach to or from Hawaii, whether that's via upgrades or purchased FPA. I'll occasionally use miles to get tickets for my fiancée.
They call me G24. I'm an entrepreneur, so my income is wildly varied from year to year. I probably spend as if I have the income they suggest (low 6 figures).
Jun 13, 2013, 3:39 pm
#980
Join Date: Apr 2009
Location: RDU
Programs: AA, EXP. DL, DM 1MM. HHonors, Diamond. Hertz, PC. National, EE.
Posts: 259
V22 = B08. Babies and Bliss. Close, since there are 7 kids between my wife and I. However, my eldest "baby" is married and about to have a baby of her own and my youngest is already a preteen.
Customer value = 8 (Is that in ham slices?)
Customer value = 8 (Is that in ham slices?)
Jun 13, 2013, 3:48 pm
#983
A FlyerTalk Posting Legend
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 100,417
Could v15 be defined to include only salary and not other income sources such as various bonuses and stock options, investment income, etc.?
Jun 13, 2013, 4:28 pm
#986
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Jun 13, 2013, 4:31 pm
#987
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Would still be way way low for me.
Jun 13, 2013, 4:36 pm
#988
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
The other case of racial profiling is with Latinos-look at how many mosaic categories there are for them!
Some of them must be very pleased to be 'Ciudad Strivers'
Some of them must be very pleased to be 'Ciudad Strivers'
Jun 13, 2013, 4:41 pm
#989
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
okay, that's what I thought. But I couldn't figure out in what context. Is that a value that changes and is tied to, say, your most recent or upcoming trip? My last trip was Q outbound and U inbound, and my next upcoming is X outbound and U inbound.