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 12, 2013, 2:04 pm
#557
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Anyone else out there have anything for v17? Mine doesn't show my total DL miles, or a Y or N. It is simply blank.
Hahaha, if v15 were still income, I would be a very happy person right now...
As for v6, I'm not familiar with what a discretionary spending amount would be.
If I remember correctly, v15 is what delta had listed as my income previously - so it could be that. In recalling this discussion previously, this was largely erroneous.
I suspect (but have no means of validating) that v06 is the old discretionary spending number.... any thoughts?
I suspect (but have no means of validating) that v06 is the old discretionary spending number.... any thoughts?
As for v6, I'm not familiar with what a discretionary spending amount would be.
Jun 12, 2013, 2:06 pm
#558
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,413
I have three codes in v25 and three stored payment methods.
Jun 12, 2013, 2:07 pm
#559
Join Date: May 2011
Location: Alaska
Programs: DL, AS, 7H, KS
Posts: 101
Jun 12, 2013, 2:07 pm
#560
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,413
Anyone else out there have anything for v17? Mine doesn't show my total DL miles, or a Y or N. It is simply blank.
Hahaha, if v15 were still income, I would be a very happy person right now...
As for v6, I'm not familiar with what a discretionary spending amount would be.
Hahaha, if v15 were still income, I would be a very happy person right now...
As for v6, I'm not familiar with what a discretionary spending amount would be.
Jun 12, 2013, 2:10 pm
#561
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
V17: "1 Million Miler" ( correct ) so thats for MM status
v25: "NORI" i have an non-us credit stored with Delta
both V21 and V28 showing my SM number, the V28 value just had 3 zeros added up front would be interesting to hear if somebody DOES NOT have the 3 zeros shown there.
v25: "NORI" i have an non-us credit stored with Delta
both V21 and V28 showing my SM number, the V28 value just had 3 zeros added up front would be interesting to hear if somebody DOES NOT have the 3 zeros shown there.
Jun 12, 2013, 2:13 pm
#563
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Also, noting the MM. I guess it's either [x] Million Miler or it's blank.
Jun 12, 2013, 2:14 pm
#564
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
No question at all V12 is MQS - mine is 37 which is correct and the MQM very high because those MQS are TATLs because of personal circumstances.
V17 is blank for me because I am not a DL million miler -so again another data point.
Which one is the concensus for income?
V17 is blank for me because I am not a DL million miler -so again another data point.
Which one is the concensus for income?
Last edited by GRALISTAIR; Jun 12, 2013 at 2:42 pm
Jun 12, 2013, 2:18 pm
#565
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
There are lots of "yes" or "no" values....which might be very interesting info like "complaints often", "Flyertalk member" or "pays with a business credit card so dosen't really care about pricing"
Jun 12, 2013, 2:23 pm
#568
Join Date: Aug 2003
Location: Mesilla, NM
Programs: DL DM 4.7 MM MQM Marriott Ambassador Lifetime Titanium AA CK
Posts: 2,714