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, 1:04 pm
#931
Join Date: Jan 2008
Location: KATL
Programs: DL DM/2MM
Posts: 2,034
True, but more importantly an FTer believes that everyone else should be at the very bottom rung, or if not the bottom, then a rung or two above.
Jun 13, 2013, 1:06 pm
#932
Join Date: Jan 2007
Posts: 5,679
Well, first, that would be illegal under the Fair Credit Reporting Act for them to access your credit report without express permission. It's highly unlikely that DL is going to make an illegal pull on your credit report and then publish it on an easy to query web service page. They might as well start writing out the checks for the class action now.
Jun 13, 2013, 1:08 pm
#933
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Could v30 be number of complaints? I'm at 6 which is about the number of emails I've sent Delta over the years, my mom is at 2, and my father who never complains via email is at 0. That makes more sense than customer value score because I know my father flys on Y fares, my mom will fly delta over anyone, and I used to be similar to my mom in my Delta flying habits.
Jun 13, 2013, 1:09 pm
#934
Join Date: Oct 2009
Location: IND
Programs: DL DM, SPG AMB, National EE
Posts: 1,301
Delta and new DL.com Profiles A Lot About You
A few thoughts after catching up on the last 15 pages:
My data seems to be pretty accurate, but experian has me as a "multi generational" family. It mostly fits our buying habits but as an early 30s with 2 young kids, we are not multi generational. However, this may explain why my 2 year old gets credit card offers, and I get letters from AARP : /
As to how they use this data, I'm sure there are some mktg gurus around here that know more about this, but it seems to me that this would be solely for DL.com advertising and promo offers. I do quite a bit of work in BI and firms of deltas size that have truly 360 degree views of a customer are few and far between. I would bet that the customer contact databases and marketing databases aren't well integrated, and therefore it would be unlikely (at this point anyway) that your #of complaints is integrated into marketing efforts (and vice-versa: does the medallion line care what your experian category is? I doubt it)
For advertising, though, the more info DL has about who is logged in, the higher rates they can charge hertz, or dollar, or whoever else wants to advertise on their site. Better targeting = more $$$
One last thought - what an ingenious way to distract the ft community. "Leak" some new codes and get everyone trying to figure out what each means whilst we all barely notice the burning sensation from the scoresby.
My data seems to be pretty accurate, but experian has me as a "multi generational" family. It mostly fits our buying habits but as an early 30s with 2 young kids, we are not multi generational. However, this may explain why my 2 year old gets credit card offers, and I get letters from AARP : /
As to how they use this data, I'm sure there are some mktg gurus around here that know more about this, but it seems to me that this would be solely for DL.com advertising and promo offers. I do quite a bit of work in BI and firms of deltas size that have truly 360 degree views of a customer are few and far between. I would bet that the customer contact databases and marketing databases aren't well integrated, and therefore it would be unlikely (at this point anyway) that your #of complaints is integrated into marketing efforts (and vice-versa: does the medallion line care what your experian category is? I doubt it)
For advertising, though, the more info DL has about who is logged in, the higher rates they can charge hertz, or dollar, or whoever else wants to advertise on their site. Better targeting = more $$$
One last thought - what an ingenious way to distract the ft community. "Leak" some new codes and get everyone trying to figure out what each means whilst we all barely notice the burning sensation from the scoresby.
Jun 13, 2013, 1:18 pm
#935
FlyerTalk Evangelist
Join Date: Feb 2010
Location: LHR
Programs: DL DM 2MM, BA Bronze, Various Hotels
Posts: 10,187
" " for income....I guess I make nothing... 
Too bad I cannot convince the IRS that's the case...
I have the same blank for the Mosaic...wonder if my being abroad makes it more difficult to track??
Too bad I cannot convince the IRS that's the case...I have the same blank for the Mosaic...wonder if my being abroad makes it more difficult to track??
Jun 13, 2013, 1:22 pm
#936
Join Date: Jul 2012
Posts: 1,079
Well, first, that would be illegal under the Fair Credit Reporting Act for them to access your credit report without express permission. It's highly unlikely that DL is going to make an illegal pull on your credit report and then publish it on an easy to query web service page. They might as well start writing out the checks for the class action now.
Jun 13, 2013, 1:35 pm
#937
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
Well, first, that would be illegal under the Fair Credit Reporting Act for them to access your credit report without express permission. It's highly unlikely that DL is going to make an illegal pull on your credit report and then publish it on an easy to query web service page. They might as well start writing out the checks for the class action now.
Jun 13, 2013, 1:52 pm
#938
Join Date: Jul 2010
Location: SUX
Programs: BA Silver; HHonors Gold; SPG Gold; Points but dirt with everyone else
Posts: 8,050
My income data is over 70% higher than the highest I've ever reported on a credit card application (which is also my current annual income). I have no idea where they're getting their data from, but it seems like it's not necessarily a reliable source.
Jun 13, 2013, 1:55 pm
#940
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 13, 2013, 1:58 pm
#941
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
30 seconds ago -- OK how soon before DL IT is informed? Place your bets
GRALISTAIR, 226ra, AdamDunn32, aisleseatbob, alrvd83, atl runner, AU Fan, BamaGirl, bdschobel, BER Flyer, BigD420, BigFlyer, blackbeard, brocklee9000, carnutga, Chalky White, CPMaverick, ctbjr1309, cuyp, danielonn, davew-krdm, DavidAL, davisew, DCA202, DeltaFan4Now, DLCorpGuy, DLdweeb, dliesse, ediemac1, enconline, eturowski, EWR-6785, ezron, FirstInFlight, FlyDeltaJets87, FlyingUnderTheRadar, gb88, GH83, GreyGhost, gt6373c, hazelrah, HikerT, hnewman, jackal, JaneStarr, JBJ2435, jermzturner, Jethead, Jetlagged Traveler, jkatzen, jsbh, juuceman, k2, KLflyerRalph, knoa_knows, kreneskyp, ktremor, lamont2718, LBJ, lgifkins, LibFlyer, LoganFlyer, lorenzopiccio, MannyMiles, michiganjd, micstatic, mikeef, mother-, MS02113, MSPeconomist, mtkeller, naples_flyer, NHFL9, NYCsoundguy, PDXNRTLHR, peachy_, readywhenyouare, RealHJ, remyontheroad, Sabai, satz, SCChris, SfoDtwFlr, shadesofgrey1x, steveg2112, swim711crazy, tartetatin2, The Truth Commission, thirtyfour, tom77346, Tomphot, traveller99, trek87, txaggie94, ULDB65, umbrella007, UserMark
GRALISTAIR, 226ra, AdamDunn32, aisleseatbob, alrvd83, atl runner, AU Fan, BamaGirl, bdschobel, BER Flyer, BigD420, BigFlyer, blackbeard, brocklee9000, carnutga, Chalky White, CPMaverick, ctbjr1309, cuyp, danielonn, davew-krdm, DavidAL, davisew, DCA202, DeltaFan4Now, DLCorpGuy, DLdweeb, dliesse, ediemac1, enconline, eturowski, EWR-6785, ezron, FirstInFlight, FlyDeltaJets87, FlyingUnderTheRadar, gb88, GH83, GreyGhost, gt6373c, hazelrah, HikerT, hnewman, jackal, JaneStarr, JBJ2435, jermzturner, Jethead, Jetlagged Traveler, jkatzen, jsbh, juuceman, k2, KLflyerRalph, knoa_knows, kreneskyp, ktremor, lamont2718, LBJ, lgifkins, LibFlyer, LoganFlyer, lorenzopiccio, MannyMiles, michiganjd, micstatic, mikeef, mother-, MS02113, MSPeconomist, mtkeller, naples_flyer, NHFL9, NYCsoundguy, PDXNRTLHR, peachy_, readywhenyouare, RealHJ, remyontheroad, Sabai, satz, SCChris, SfoDtwFlr, shadesofgrey1x, steveg2112, swim711crazy, tartetatin2, The Truth Commission, thirtyfour, tom77346, Tomphot, traveller99, trek87, txaggie94, ULDB65, umbrella007, UserMark
Jun 13, 2013, 2:01 pm
#943
Join Date: Jan 2000
Location: ATL - DL DM/3MM - HH Lifetime Diamond - Marriott Lifetime Plat
Posts: 3,117
Jun 13, 2013, 2:01 pm
#944
FlyerTalk Evangelist
Join Date: Feb 2000
Location: Winter Garden, FL
Programs: Delta DM-3MM United Gold-MM Marriott Lifetime Titanium Hertz President's Circle
Posts: 13,498
Bruce