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
Jan 25, 2013, 11:28 am
#331
Join Date: Apr 2003
Location: Seattle, WA
Programs: DL DM/1MM, Natl Exec Elite, Bonvoy Plat, Hyatt Glob, Hilton Diam
Posts: 382
Jan 25, 2013, 11:29 am
#332
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
BTW, those who are making the assumption that a "0" score is the lowest should know that Experian sometimes uses "0" to mean "cannot be rated." For example, on a credit report, "1" means paid as agreed upon, "2" means thirty days late, "3" means sixty days late, etc. "0" actually means Experian does not have enough information, and, in my industry, much caution is taken to NOT use a zero adversely. it's not negative.
It could be here that "0" simply means DL doesn't have enough data to rate the customer.
It could be here that "0" simply means DL doesn't have enough data to rate the customer.
Jan 25, 2013, 11:29 am
#333
Join Date: May 2006
Location: GA
Programs: VA-PLT, QF-GLD, DL-GM, UA-ex1K, AA-exPLT, HH-DM, IHG-PLT, MR-GLD
Posts: 8,242
For the record, my Mosiac seems pretty close. I rent but my home value is about right based on my address. Income is low but potentially what I stated on AMEX a few years back.
DM, custValSeg = 11, minsetSeg = SS
DM, custValSeg = 11, minsetSeg = SS
Jan 25, 2013, 11:32 am
#334
Join Date: May 2012
Location: MSP
Programs: Delta Skymile DM, Marriott Platinum, PC Gold, Avis Chairman's Club, National EE
Posts: 728
Jan 25, 2013, 11:33 am
#335
Join Date: Mar 2011
Posts: 647
Am I doing something wrong?
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
Jan 25, 2013, 11:34 am
#336
Join Date: Feb 2008
Location: JFK,ATL,LGA (the rest of the world follows)
Programs: DL KM/DM/2MM (NH Plat emeritus, CO Plat emeritus, and no place like home)
Posts: 3,190
Am I doing something wrong?
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
Jan 25, 2013, 11:34 am
#337
Join Date: May 2012
Location: MSP
Programs: Delta Skymile DM, Marriott Platinum, PC Gold, Avis Chairman's Club, National EE
Posts: 728
It may have been pulled off line. I am getting as well now.
Am I doing something wrong?
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
I am logged in, and then I click on the OP's link in another tab. It returns the file, which I open in a text editor, but there is very little data there. Most fields are blank (:""), but there are a few "N" values (including "skyPrtyInd":"N", which is odd since I am GM).
It is also showing: "isLoggedIn":"N", which is odd, since I am logged in....
Thanks.
Jan 25, 2013, 11:45 am
#340
Join Date: Jul 2006
Location: Inland Empire!
Programs: NW Plat (formerly), UA 1K, Hilton Silver, Hyatt Plat
Posts: 2,917
How is it that Experian doesn't know that I own an apartment in Manhattan?
Jan 25, 2013, 11:47 am
#341
Join Date: Jan 2007
Posts: 5,679
Jan 25, 2013, 11:52 am
#344
Join Date: May 2006
Location: GA
Programs: VA-PLT, QF-GLD, DL-GM, UA-ex1K, AA-exPLT, HH-DM, IHG-PLT, MR-GLD
Posts: 8,242
Just because it is in a text format doesn't mean it's public knowledge. If Delta took this down, it is only because of the information it contains that is NOT in our DL profile. Nobody can see it without your password
Jan 25, 2013, 11:56 am
#345
Join Date: Oct 2007
Programs: Now just a lowly DL PM/1MM. This industry needs some competition. It's just not enjoyable anymore.
Posts: 3,543