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, 1:26 pm
#361
Join Date: Jan 2006
Programs: Delta DM (3 MM) ; Sky Club (Lifetime)
Posts: 327
Wired For Success
Thanks for the laugh, Delta.
I did not previously realize that I was either "wired" or "successful".
I only wish the same could be said of Delta.com
If they haven't fired the IT department for the complete fail of the website, perhaps this data breach (though now corrected) will tip the scales.
I did not previously realize that I was either "wired" or "successful".
I only wish the same could be said of Delta.com
If they haven't fired the IT department for the complete fail of the website, perhaps this data breach (though now corrected) will tip the scales.
Jan 25, 2013, 1:28 pm
#362
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
As a DM with a value of "0" this is very interesting...I'd love to know how long others have been flying with Delta (especially those with a value of 20+). I only joined SkyMiles in college (2001) and didn't start flying with them extensively until 2006. Since then, I went:
2006: General Member-->FO
2007: FO
2008: FO
2009: FO-->GM
2010: GM-->PM-->DM (which I've been since)
I suppose it is very possible that my Delta travel has not been extensive enough to warrant a rating. I know most on here will have many years on me.
My wife was also FO in 2006 and 2007 and hasn't had earned status since (though I've gifted her gold status twice). She also had a value of "0."
2006: General Member-->FO
2007: FO
2008: FO
2009: FO-->GM
2010: GM-->PM-->DM (which I've been since)
I suppose it is very possible that my Delta travel has not been extensive enough to warrant a rating. I know most on here will have many years on me.
My wife was also FO in 2006 and 2007 and hasn't had earned status since (though I've gifted her gold status twice). She also had a value of "0."
I was back to nada in 2010, FO for 2011, and then made DM last year. So I would say, not a huge difference from your history but a much higher rating. I do fly on high fares but rarely paid F and only a couple international coach fares.
Jan 25, 2013, 1:39 pm
#363
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
www.flyertalk.com just rocks - way to go!!
Jan 25, 2013, 1:47 pm
#365
Company Representative - Delta Air Lines
Join Date: Jul 2009
Location: Atlanta, GA
Programs: SkyMiles
Posts: 351
Update from Delta
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.
Jan 25, 2013, 1:50 pm
#366
Suspended
Join Date: Aug 2008
Location: SE US
Programs: Duke of Bombay, Delta Ham Sandwich tm, Delta's Glitch
Posts: 4,201
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.
Jan 25, 2013, 1:51 pm
#367
Join Date: Nov 2010
Location: Seattle, WA
Programs: Hilton, United, Gold DL
Posts: 993
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.
Jan 25, 2013, 1:52 pm
#368
Join Date: Jan 2002
Location: Orlando, FL
Programs: Delta GM/1.5MM ~ United Silver ~ Marriott Lifetime Titanium
Posts: 1,434
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.
Jan 25, 2013, 1:55 pm
#369
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
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.
What interests are you talking about-higher fares?
This is exactly why I use a GDS-it doesn't give me anything other than availability and they have no idea who the customer is that the TA is dealing with.
(Then again, it is kind of my job to analyze and use the stats to create a better experience, though I don't necessarily like what I am doing at all times.)
Jan 25, 2013, 1:58 pm
#371
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
I agree. I'm fascinated by the topic because I work in marketing/PR where audience segmentation is a key to success. I wonder how fluid the scores are? For example, after 3/1 when my status is gone, would other metrics change too? Makes sense that they would.
I don't take issue with a company knowing more about me that will help them market to me more effectively (other than the mosaic profile assuming I'm at retirement age even w my b-day correct
). But you're spot on that some folks seem to have taken this too seriously without knowing fully what it all means...and I agree it's most likely an ego thing. This thread wasn't needed to know that much! 
I don't take issue with a company knowing more about me that will help them market to me more effectively (other than the mosaic profile assuming I'm at retirement age even w my b-day correct
). But you're spot on that some folks seem to have taken this too seriously without knowing fully what it all means...and I agree it's most likely an ego thing. This thread wasn't needed to know that much! I wanted to view my stats again when I arrived but I can't check this anymore...
Jan 25, 2013, 1:59 pm
#373
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
Jan 25, 2013, 1:59 pm
#374
Join Date: Apr 2003
Location: Seattle, WA
Programs: DL DM/1MM, Natl Exec Elite, Bonvoy Plat, Hyatt Glob, Hilton Diam
Posts: 382
+1
Are you sure you're not from Louisiana instead of Ireland?
http://www.thefreedictionary.com/beaucoup
Are you sure you're not from Louisiana instead of Ireland?
http://www.thefreedictionary.com/beaucoup
Jan 25, 2013, 1:59 pm
#375
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
How could you have not saved them? Of course, once DL PTB knew there was access, the access would be gone. Good gosh, how could you have not saved them?