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, 4:36 pm
#421
Join Date: Oct 2002
Location: LAS
Programs: PA FT, TW Gold, NW/CO PE, VK Eagleflyer
Posts: 7,173
Like many companies, Delta uses demographic and other data to help provide a personalized experience for our customers, improve how we communicate with them and design offers customized to their interests. While the data displayed was only available to the specific user, we sincerely regret that this code displayed and the confusion it may have caused for our customers. We worked to resolve the issue promptly upon discovering it.
How about customizing that to my interests so I don't have to use the telephone to book award travel?
Pathetic...
Jan 25, 2013, 4:42 pm
#422
Join Date: Dec 2009
Location: MSP
Programs: DL GM, AMEX Business Platinum, AMEX Delta Reserve, DL SkyClub Member, Choice PM
Posts: 2,218
In the SkyClub and on the Plane?
Yeah!
They are tracking everything and estimating what it costs Delta to continue having you (and me and everyone else) as DMs!
Last edited by dd1612; Jan 25, 2013 at 4:47 pm
Jan 25, 2013, 4:42 pm
#423
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
I got to see mine, but there is no way I would publish the info here on a public and archived ("forever") forum. Especially the codes that are not clear what they mean. It could be your felony arrest record for all you know. 
This is a very informative episode for most of us who never get to look into the data that is being stored and tracked and analyzed by the 1000's of entities we come in contact with. Next time anyone says "Big Data" to you, you now know what they mean.
This is a very informative episode for most of us who never get to look into the data that is being stored and tracked and analyzed by the 1000's of entities we come in contact with. Next time anyone says "Big Data" to you, you now know what they mean.
Jan 25, 2013, 5:03 pm
#424
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
One of the documents linked in this thread reminded cs employees to keep using the codes, which is what leads me to believe they were using the codes. The woman who wrote the article was a DL bigwig who was also an attorney. The link is towards the start of this thread.
Jan 25, 2013, 5:37 pm
#426
Join Date: Apr 2007
Location: SFO
Programs: UA Silver
Posts: 1,155
- It is perfectly fine not to fix the award calendar and other stuff. Because cheating, lying, and empty promises are completely legal. Yes, it may hurt our feelings, and it is not a good way to treat people. But, as several wise posters have pointed out, Delta is a business. We should not have any personal emotion towards a business. As long as it has the most convenient and economic flights, we should fly Delta. So let's keep climbing.
Jan 25, 2013, 5:50 pm
#427
Join Date: Jun 2002
Location: Kingdom of the Sun
Programs: DL GM/MM
Posts: 3,708
{
"actvtyPref":"",
"bcInd":"Y",
"birthDt":"********", /*I've redacted all really personal info */
"chldAgeRange":"",
"cobrandCardCd":"AX",
"ctryCd":"US",
"custID":"**********",
"custValSeg":"7",
"dgtlLangPref":"en",
"discSpndngAmt":"35530",
"drvdGndr":"M",
"drvdHmArptCd":"NYC",
"hmArptPref":"NYC",
"homeValueAmt":"255000",
"htlBrndPref":"",
"incomeAmt":"78",
"isLoggedIn":"N",
"isPwmElig":"Y",
"isSmCust":"Y",
"mindsetSeg":"GT",
"mosaicCd":"Q64",
"poCd":"*****-****",
"prefDestCity":"",
"prefDestCtry":"",
"savedSrchDest":"",
"skyClubFtrCntrctInd":"N",
"skyClubMMSts":"",
"skyClubMbr":"N",
"skyClubRnwlDt":"",
"skyPrtyInd":"Y",
"smAmexCntrnInd":"N",
"smAmexInd":"Y",
"smBalance":"******",
"smMqmBal":"****",
"smMqsBal":"*",
"smNbr":"************",
"smSunTrstInd":"N",
"smTierLvl":"GM",
"stProvCd":"NY"}
You're welcome.
Jan 25, 2013, 5:50 pm
#428
Join Date: Aug 2002
Location: MSP (Mahtomedi, MN, USA) - Delta hub captive, Marriott Gold, US Mint Silver, CVS Red
Programs: "We've been starving, and sitting on a ham sandwich the whole time."
Posts: 1,482
Reminds me of the "THX account is 6% over budget" thing...
Last edited by wbl-mn-flyer; Jan 25, 2013 at 5:58 pm
Jan 25, 2013, 6:07 pm
#430
Join Date: Feb 2009
Location: BER, SAT, AUS
Programs: Feels like FO (AA EXP)
Posts: 1,611
Jan 25, 2013, 6:38 pm
#432
Join Date: Jun 2010
Location: Coralville, IA
Programs: DL:Diamond, HH:Diamond
Posts: 331
me too!
wah! I missed seeing mine too because Iwas on a flight. Mrs Jennifer M Parks of Manassas VA.
I was able to whip in there and pull yours. I just hope I pulled the right Hudson/Thomas.
{
"actvtyPref":"",
"bcInd":"Y",
"birthDt":"********", /*I've redacted all really personal info */
"chldAgeRange":"",
"cobrandCardCd":"AX",
"ctryCd":"US",
"custID":"**********",
"custValSeg":"7",
"dgtlLangPref":"en",
"discSpndngAmt":"35530",
"drvdGndr":"M",
"drvdHmArptCd":"NYC",
"hmArptPref":"NYC",
"homeValueAmt":"255000",
"htlBrndPref":"",
"incomeAmt":"78",
"isLoggedIn":"N",
"isPwmElig":"Y",
"isSmCust":"Y",
"mindsetSeg":"GT",
"mosaicCd":"Q64",
"poCd":"*****-****",
"prefDestCity":"",
"prefDestCtry":"",
"savedSrchDest":"",
"skyClubFtrCntrctInd":"N",
"skyClubMMSts":"",
"skyClubMbr":"N",
"skyClubRnwlDt":"",
"skyPrtyInd":"Y",
"smAmexCntrnInd":"N",
"smAmexInd":"Y",
"smBalance":"******",
"smMqmBal":"****",
"smMqsBal":"*",
"smNbr":"************",
"smSunTrstInd":"N",
"smTierLvl":"GM",
"stProvCd":"NY"}
You're welcome.
{
"actvtyPref":"",
"bcInd":"Y",
"birthDt":"********", /*I've redacted all really personal info */
"chldAgeRange":"",
"cobrandCardCd":"AX",
"ctryCd":"US",
"custID":"**********",
"custValSeg":"7",
"dgtlLangPref":"en",
"discSpndngAmt":"35530",
"drvdGndr":"M",
"drvdHmArptCd":"NYC",
"hmArptPref":"NYC",
"homeValueAmt":"255000",
"htlBrndPref":"",
"incomeAmt":"78",
"isLoggedIn":"N",
"isPwmElig":"Y",
"isSmCust":"Y",
"mindsetSeg":"GT",
"mosaicCd":"Q64",
"poCd":"*****-****",
"prefDestCity":"",
"prefDestCtry":"",
"savedSrchDest":"",
"skyClubFtrCntrctInd":"N",
"skyClubMMSts":"",
"skyClubMbr":"N",
"skyClubRnwlDt":"",
"skyPrtyInd":"Y",
"smAmexCntrnInd":"N",
"smAmexInd":"Y",
"smBalance":"******",
"smMqmBal":"****",
"smMqsBal":"*",
"smNbr":"************",
"smSunTrstInd":"N",
"smTierLvl":"GM",
"stProvCd":"NY"}
You're welcome.
Jan 25, 2013, 7:11 pm
#433
Join Date: Jan 2001
Posts: 1,877
DL employees would be foolish to access this board from any DL controlled Internet connection; be it from home (via VPN), or from work.
Jan 25, 2013, 7:18 pm
#435
Join Date: Feb 2005
Location: Almost equidistant between DTW & FNT
Programs: DL PM, Multi-year NW PE, CO SE, Former F9 Ascent
Posts: 154
For anyone still looking to "catch" their own traffic on this issue, I recommend using Fiddler which is a very simple HTTP traffic monitoring tool. When I have some free time, I'm interested to see what my info is like from DL.
Has anyone had success using Fiddler? I have been playing around with it this evening, but am not finding any profile info.