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, 8:29 pm
#721
Join Date: Apr 2009
Location: RDU
Programs: AA, EXP. DL, DM 1MM. HHonors, Diamond. Hertz, PC. National, EE.
Posts: 259
LOL at #21 on the master list. Please don't change it!
EDIT: Damn it! You had to change it from "Slymiles" to Skymiles and ruin my post...
EDIT: Damn it! You had to change it from "Slymiles" to Skymiles and ruin my post...
Last edited by mcmitchell; Jun 12, 2013 at 9:46 pm
Jun 12, 2013, 8:31 pm
#722
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Examples:
IKBL->AXCP = DL Platinum Amex
IKBZ->AXCG = DL Gold Amex
IK->AX = non-DL Amex
Last edited by lamont2718; Jun 12, 2013 at 8:50 pm Reason: Clarity
Jun 12, 2013, 8:33 pm
#723
FlyerTalk Evangelist
Join Date: Nov 2004
Location: 45° North
Programs: DL DM MM, HH Diamond
Posts: 10,196
Well that might make sense - I have a Delta Amex blue card which might be the AXCC code.
Jun 12, 2013, 8:35 pm
#725
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
However, I'm surprised that DL doesn't track who has the regular AmEx Plat and Centurion charge cards because these give lounge access.
Jun 12, 2013, 8:45 pm
#727
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
I'm guessing that NORL = Reserve card and something like NORZ is DL AmEx Plat card. Or maybe IKBD = Reserve card and IKsomethingsimilar is DL AmEx Plat card.
However, I'm surprised that DL doesn't track who has the regular AmEx Plat and Centurion charge cards because these give lounge access.
However, I'm surprised that DL doesn't track who has the regular AmEx Plat and Centurion charge cards because these give lounge access.
Jun 12, 2013, 8:48 pm
#728
Join Date: May 1999
Posts: 1,627
It seems someone profiles a lot about Delta too.
Found the following when I logged onto the Delta SkyMiles forum on FlyerTalk:
{
"companyIntegrity":"none",
"programClaim":"best in class",
"programEval":"worst in class",
"gateShenanigans":"high"
"avgAwardPrice":"high",
"awardChangesAllowed":"limited",
"programValue":"low",
"milesDieWhenYouDo":"yes",
"fuelSurchargeRipoffEmployed":"yes",
"advanceChangeNotice":"no",
"hideBehindFalseLegalClaims":"when possible"
}
Found the following when I logged onto the Delta SkyMiles forum on FlyerTalk:
{
"companyIntegrity":"none",
"programClaim":"best in class",
"programEval":"worst in class",
"gateShenanigans":"high"
"avgAwardPrice":"high",
"awardChangesAllowed":"limited",
"programValue":"low",
"milesDieWhenYouDo":"yes",
"fuelSurchargeRipoffEmployed":"yes",
"advanceChangeNotice":"no",
"hideBehindFalseLegalClaims":"when possible"
}
Jun 12, 2013, 8:58 pm
#729
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
As var as V25 goes, there is more to it. I have only my DL Plat Amex as a stored payment, but before I got that I used a regular Amex Plat -- which was since downgraded to just a Amex Green.
I have IK (=AX) which could be the green card but also IKTL, which I haven't seen mentioned here and is different from what others have reported with Dl Plat Amex.
OK, I checked my January "dump" and I had AX,AX BP -- which according to the key is IK,IKTL so that is a match. No idea what "AX BP" is though.
Added: Just figured it out: My DL Amex Plat is "Personal" Business card so TL=BP = Business, Personal
I have IK (=AX) which could be the green card but also IKTL, which I haven't seen mentioned here and is different from what others have reported with Dl Plat Amex.
OK, I checked my January "dump" and I had AX,AX BP -- which according to the key is IK,IKTL so that is a match. No idea what "AX BP" is though.
Added: Just figured it out: My DL Amex Plat is "Personal" Business card so TL=BP = Business, Personal
Last edited by TheMadBrewer; Jun 12, 2013 at 9:04 pm
Jun 12, 2013, 8:59 pm
#731
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
Jun 12, 2013, 9:01 pm
#732
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
Jun 12, 2013, 9:05 pm
#734
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Holy shitake mushrooms... delta reallydoes love me!
HVC, American Royalty, always upgraded, Customer Value Score 100, home airport -private helicopter pad from back yard straight to home airport, Skyclub access NO, Special private club access yes,
HVC, American Royalty, always upgraded, Customer Value Score 100, home airport -private helicopter pad from back yard straight to home airport, Skyclub access NO, Special private club access yes,
Jun 12, 2013, 9:06 pm
#735
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
I've figured out v22 -- it is an encoding of your three-character Mosaic. For example, EPE->O51="Digital Dependents". I will post the full explanation and key soon.