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, 9:38 am
#886
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
No, it looks to me like someone decided that it would be enough to encrypt it in this simple way. It might have been easier to prevent outside access than to shuffle the fields around and encrypt some entries. Maybe the person that made the decision needs to be fired, but it's not like someone failed to do some assigned duty, namely stopping access by the link when logged in.
Jun 13, 2013, 9:40 am
#887
Join Date: Aug 2003
Location: Mesilla, NM
Programs: DL DM 4.7 MM MQM Marriott Ambassador Lifetime Titanium AA CK
Posts: 2,714
No, it looks to me like someone decided that it would be enough to encrypt it in this simple way. It might have been easier to prevent outside access than to shuffle the fields around and encrypt some entries. Maybe the person that made the decision needs to be fired, but it's not like someone failed to do some assigned duty, namely preventing access by the link when logged in.
Jun 13, 2013, 9:44 am
#888
Join Date: Mar 2011
Posts: 647
Would not make sense for "isSM member" as that is visible 2 x in the fields with your SM number which would be blank otherwise. "is loggedin"? Maybe.
As we have reports from the past that DL.com returns different results/prices for the same search for logged in/not logged members the system must take note of that feature and it might be displayed in the data string here.
As we have reports from the past that DL.com returns different results/prices for the same search for logged in/not logged members the system must take note of that feature and it might be displayed in the data string here.
Jun 13, 2013, 10:09 am
#890
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Does anyone have data for V32?
I have one point and have messed around with my DL.com profile to see if my suspicions are correct - but I'd love to validate with someone else (as the data on DL.com does not update instantly)
I have one point and have messed around with my DL.com profile to see if my suspicions are correct - but I'd love to validate with someone else (as the data on DL.com does not update instantly)
Jun 13, 2013, 10:13 am
#892
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 13, 2013, 10:16 am
#893
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
Jun 13, 2013, 10:36 am
#896
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 13, 2013, 10:39 am
#897
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
No, it looks to me like someone decided that it would be enough to encrypt it in this simple way. It might have been easier to prevent outside access than to shuffle the fields around and encrypt some entries. Maybe the person that made the decision needs to be fired, but it's not like someone failed to do some assigned duty, namely stopping access by the link when logged in.
Jun 13, 2013, 10:43 am
#898
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
As I pointed out about 200 posts back, there really needs to be at least 1 [null] because there needs to be space for a true MQD later in the year when it starts showing in our profiles.
Jun 13, 2013, 10:50 am
#899
Join Date: Jul 2010
Location: SUX
Programs: BA Silver; HHonors Gold; SPG Gold; Points but dirt with everyone else
Posts: 8,050
Jun 13, 2013, 10:50 am
#900
FlyerTalk Evangelist
Join Date: Jun 2008
Programs: Formaldehyde Medallion DL DieMiles
Posts: 12,646
Interesting.
My income is close... within +/- 30%.
But, as a self-employed consultant with multiple clients, there is no way they have access to any sort of salary info.
I would love to learn that my house has the value they estimated. Clearly not at all related to the original mortgage or sale price.
The did get "Thriving Boomer, Full pockets, Empty nest" correct though.
And the closest air port is correct... just that it is a municipal airport with no commercial service (although DL did try it for a while with a commuter flight that fizzled out)
Why has DL kept this info available? Be honest folks, most of you are fixated on the customer value score, and they want to keep you fixated on this.
My income is close... within +/- 30%.
But, as a self-employed consultant with multiple clients, there is no way they have access to any sort of salary info.
I would love to learn that my house has the value they estimated. Clearly not at all related to the original mortgage or sale price.
The did get "Thriving Boomer, Full pockets, Empty nest" correct though.
And the closest air port is correct... just that it is a municipal airport with no commercial service (although DL did try it for a while with a commuter flight that fizzled out)
Why has DL kept this info available? Be honest folks, most of you are fixated on the customer value score, and they want to keep you fixated on this.