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, 2:10 pm
#378
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 wanted to view the stats again later to see if they would change.
I still have my stats from last night (25 Jan)
Jan 25, 2013, 2:18 pm
#380
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
Jan 25, 2013, 2:20 pm
#381
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, 2:32 pm
#382
Join Date: Sep 2011
Location: Wherever I happen to be....
Programs: DL EOS...
Posts: 1,111
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.
I wonder what my elected representatives, governing bodies and/or news outlets will think about what your company got caught doing?
You're the ones attacking medallion members using FCM, MQD's, eliminating routes and window UG's, etc. You will reap what you sow....
Jan 25, 2013, 2:39 pm
#383
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
Excuse me? Obviously, SOMEBODY other than myself views and uses this information on a regular basis. Maybe not casual visitors to a discussion forum but people in your organization pass around and view my personal info as if it were candy.
I wonder what my elected representatives, governing bodies and/or news outlets will think about what your company got caught doing?
You're the ones doing FCM, MQD's, eliminating routes and window UG's, etc. You will reap what you sow....
I wonder what my elected representatives, governing bodies and/or news outlets will think about what your company got caught doing?
You're the ones doing FCM, MQD's, eliminating routes and window UG's, etc. You will reap what you sow....
And while you might be surprised to hear about this, it is done by many companies, it is legal, and your representatives won't do squat about it (besides many stump a little about how it's wrong)
Jan 25, 2013, 2:39 pm
#384
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
Excuse me? Obviously, SOMEBODY other than myself views and uses this information on a regular basis. Maybe not casual visitors to a discussion forum but people in your organization pass around and view my personal info as if it were candy.
I wonder what my elected representatives, governing bodies and/or news outlets will think about what your company got caught doing?
You're the ones attacking medallion members using FCM, MQD's, eliminating routes and window UG's, etc. You will reap what you sow....
I wonder what my elected representatives, governing bodies and/or news outlets will think about what your company got caught doing?
You're the ones attacking medallion members using FCM, MQD's, eliminating routes and window UG's, etc. You will reap what you sow....
Jan 25, 2013, 2:49 pm
#385
Join Date: Dec 2011
Programs: DL DM PM
Posts: 2,034
I don't mind them using my info for marketing, but I'm pretty upset I came across as a Baby Boomer with conservative political views. :-( I hope it's just a zipcode thing.
Anyway, this was a ton of fun while it lasted! Thanks to the OP, and onto the next puzzle.
Anyway, this was a ton of fun while it lasted! Thanks to the OP, and onto the next puzzle.
Jan 25, 2013, 2:51 pm
#386
FlyerTalk Evangelist
Join Date: Jun 2004
Location: MSP
Programs: DL PM, MM, NR; HH Diamond, Bonvoy LT Gold, Hyatt Explorist, IHG Diamond, others
Posts: 12,159
I suspect that the data is still available, just not by going to the URL. It would be a major change to all Delta's pages to access it some other way, and a fairly trivial change to block direct access.
Jan 25, 2013, 2:52 pm
#387
Join Date: Sep 2004
Location: FLL
Programs: DL DM
Posts: 167
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.
Can you offer assurances that it was ABSOLUTELY only available to the specific user. If it is only available to the specific user then why is it there?
I have huge privacy concerns.
Jan 25, 2013, 3:00 pm
#388
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
I am assuming there is an opt out facility and I would like to use it. Could you let us know how we do that.
Can you offer assurances that it was ABSOLUTELY only available to the specific user. If it is only available to the specific user then why is it there?
I have huge privacy concerns.
Can you offer assurances that it was ABSOLUTELY only available to the specific user. If it is only available to the specific user then why is it there?
I have huge privacy concerns.
Might I ask, what exactly are you concerned about? It's not as though there is any information there that can be used to open or access accounts.
It seems everyone on this board wants DL to track every activity so they can get perks. How can we then bemoan DL for tracking us?
Jan 25, 2013, 3:02 pm
#389
Join Date: Dec 2012
Location: ATL F-Terminal
Programs: Hilton C, Marriott Pt, Delta Pt
Posts: 249
I am assuming there is an opt out facility and I would like to use it. Could you let us know how we do that.
Can you offer assurances that it was ABSOLUTELY only available to the specific user. If it is only available to the specific user then why is it there?
I have huge privacy concerns.
Can you offer assurances that it was ABSOLUTELY only available to the specific user. If it is only available to the specific user then why is it there?
I have huge privacy concerns.
Jan 25, 2013, 3:07 pm
#390
Join Date: Oct 2007
Location: Atlanta, GA (Or on a plane going far away)
Programs: DL: DM / Royal Ambassador /PC:Plat / Hertz:5*
Posts: 617
There is a way to opt out; don't do business with DL. The other airlines do this, too, so you'll have to avoid them. Heck, even the big stores are tracking you when you use your credit or debit card, so you'll want to avoid that. Cancel all newspaper, magazine and Internet subscriptions, because they're doing this, too. Don't get a mortgage, use a credit card or purchase anything at a small store where they might know your name. Don't get mail, as companies purchase lists based on zip codes.
Might I ask, what exactly are you concerned about? It's not as though there is any information there that can be used to open or access accounts.
It seems everyone on this board wants DL to track every activity so they can get perks. How can we then bemoan DL for tracking us?
Might I ask, what exactly are you concerned about? It's not as though there is any information there that can be used to open or access accounts.
It seems everyone on this board wants DL to track every activity so they can get perks. How can we then bemoan DL for tracking us?