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
#451
Join Date: Sep 2011
Location: Wherever I happen to be....
Programs: DL EOS...
Posts: 1,111
I don't have much problem with a business collecting data of what I'm browsing and/or doing on their website. I've clicked windows agreeing to that and 'don't have much issue if they use that information to "tailor" the shopping experience.
Trouble is, what operational decisions have and will be made when interacting with Delta CSR's based on "this" wildly inaccurate information?
Plus, identity theft is a REAL concern. Witnessing my zip code and DOB tossed around like candy to whoever DL wants to share it with? Amazon and most any other business don't need my DOB for transactions however air travel is a different animal - TSA requires it but does that give DL explicit rights to use it for "marketing" purposes? Not sure, but it seems WRONG to violate trust in that manner.
Yes, I've gone a bit over the top in this and other threads but when I step back and look at the assault(s) big D is making towards the Medallion program, I become agitated and distrustful of what's likely coming next?
This was fun though, in a weird way, thanks to OP for the experience!
Trouble is, what operational decisions have and will be made when interacting with Delta CSR's based on "this" wildly inaccurate information?
Plus, identity theft is a REAL concern. Witnessing my zip code and DOB tossed around like candy to whoever DL wants to share it with? Amazon and most any other business don't need my DOB for transactions however air travel is a different animal - TSA requires it but does that give DL explicit rights to use it for "marketing" purposes? Not sure, but it seems WRONG to violate trust in that manner.
Yes, I've gone a bit over the top in this and other threads but when I step back and look at the assault(s) big D is making towards the Medallion program, I become agitated and distrustful of what's likely coming next?
This was fun though, in a weird way, thanks to OP for the experience!
#452
Join Date: Jan 2010
Programs: AA Plat 2MM/UA G MM/DL MM DM 2015/BA Silver/Hyatt Diamond
Posts: 3,103
I don't have much problem with a business collecting data of what I'm browsing and/or doing on their website. I've clicked windows agreeing to that and 'don't have much issue if they use that information to "tailor" the shopping experience.
Trouble is, what operational decisions have and will be made when interacting with Delta CSR's based on "this" wildly inaccurate information?
Plus, identity theft is a REAL concern. Witnessing my zip code and DOB tossed around like candy to whoever DL wants to share it with? Amazon and most any other business don't need my DOB for transactions however air travel is a different animal - TSA requires it but does that give DL explicit rights to use it for "marketing" purposes? Not sure, but it seems WRONG to violate trust in that manner.
Yes, I've gone a bit over the top in this and other threads but when I step back and look at the assault(s) big D is making towards the Medallion program, I become agitated and distrustful of what's likely coming next?
This was fun though, in a weird way, thanks to OP for the experience!
Trouble is, what operational decisions have and will be made when interacting with Delta CSR's based on "this" wildly inaccurate information?
Plus, identity theft is a REAL concern. Witnessing my zip code and DOB tossed around like candy to whoever DL wants to share it with? Amazon and most any other business don't need my DOB for transactions however air travel is a different animal - TSA requires it but does that give DL explicit rights to use it for "marketing" purposes? Not sure, but it seems WRONG to violate trust in that manner.
Yes, I've gone a bit over the top in this and other threads but when I step back and look at the assault(s) big D is making towards the Medallion program, I become agitated and distrustful of what's likely coming next?
This was fun though, in a weird way, thanks to OP for the experience!
I am not concerned that they have data, I am concerned they have the wrong data and given the whole idea behind assigning customer value scores, I for one want them them to have the right answer to DYKWIA.
#453
Join Date: Nov 2007
Location: halfway between JFK and LGA
Posts: 976
#455
Join Date: Oct 2007
Programs: Now just a lowly DL PM/1MM. This industry needs some competition. It's just not enjoyable anymore.
Posts: 3,543
I agree. If the treatment I get is based on some calculated value, I would like the inputs to that value to be accurate. I don't think that is unreasonable.
#456
Join Date: Feb 2010
Location: US
Programs: (PM)AA SPG (Marriott), Hilton
Posts: 1,040
read more about it
All Delta did was break cover accidentally and show their record layout. That they had the data is nothing shocking. Or at least shouldn't be. Others have far more.
Maybe this is too serious for this thread, but if you want more information how companies get this data and use it, here's a few resources. If you're hear for the fun, just skip ahead to the next post.
The Target story mentioned upthread is a chapter in the book "Habit" by Charles Duhigg. The NYTimes article covered that chapter as a book review/book promotion.
Martin Lindstrom works in this field and has several books out. He leans towards field research. He (or his team) would stalk you in a grocery store and collect data from that.
Lindstrom covers data collection as well: Chapter 9 in "Brandwashed" is titled "Every Breath you Take, They'll be Watching you. The End of Privacy". Companies use your CC data both individually to target you and in aggregate, one example given was Walmart finding out that Beer, not Batteries, is the #1 item sold before a hurricane and so knows what to stock their stores with. Big database Walmart has.
Both Major US (and UK) political parties do it too. For US, VoterVault for the Republicans and Vote Builder for the Democrats.
Privacy policies can be ineffective even when then company means well and has the best intent.
In the early days, a dot.com with a strong privacy policy which did not allow them to sell their customer list, went bankrupt. In the bankruptcy, the creditors attempted to block the destruction of the list, saying it was an asset with value and should be sold off. In other cases, law enforcement gets the entire list, not just what they need, sometimes sloppiness, sometimes something else. Anything that winds up in court may be one stop closer to being public. How again did Bernie Madoff's January 08 Amex statement wind up on the web?
"No Place to Hide" by Robert O'Harrow focuses on some big gorilla's in the business of your information. They've been selling your information for years. As noted in the Target story about pregnancy (up-thread, and Duhigg) they may know more about you than you. Or at least think they do.
Click over to infousa and you can have a mailing list in a few minutes. You don't need to create an account or log in to do queries and get back the number of records you'd be purchasing. You can't access the data they are storing, but you can see field names. One is the number of credit cards you have. InfoUSA has been in business since the 70's.
Already pointed out upthread, there are a lot of issues about the reliability of the data too. Best of luck to you if you happen to get data worse than you deserve. For better or worse the accuracy will probably improve over time, and the volume will too.
None of the above even gets into what may be happening to your medical data.
Welcome to the new Millennium. (We have cookies....and we know your FICO score.)
Maybe this is too serious for this thread, but if you want more information how companies get this data and use it, here's a few resources. If you're hear for the fun, just skip ahead to the next post.
The Target story mentioned upthread is a chapter in the book "Habit" by Charles Duhigg. The NYTimes article covered that chapter as a book review/book promotion.
Martin Lindstrom works in this field and has several books out. He leans towards field research. He (or his team) would stalk you in a grocery store and collect data from that.
Lindstrom covers data collection as well: Chapter 9 in "Brandwashed" is titled "Every Breath you Take, They'll be Watching you. The End of Privacy". Companies use your CC data both individually to target you and in aggregate, one example given was Walmart finding out that Beer, not Batteries, is the #1 item sold before a hurricane and so knows what to stock their stores with. Big database Walmart has.
Both Major US (and UK) political parties do it too. For US, VoterVault for the Republicans and Vote Builder for the Democrats.
Privacy policies can be ineffective even when then company means well and has the best intent.
In the early days, a dot.com with a strong privacy policy which did not allow them to sell their customer list, went bankrupt. In the bankruptcy, the creditors attempted to block the destruction of the list, saying it was an asset with value and should be sold off. In other cases, law enforcement gets the entire list, not just what they need, sometimes sloppiness, sometimes something else. Anything that winds up in court may be one stop closer to being public. How again did Bernie Madoff's January 08 Amex statement wind up on the web?
"No Place to Hide" by Robert O'Harrow focuses on some big gorilla's in the business of your information. They've been selling your information for years. As noted in the Target story about pregnancy (up-thread, and Duhigg) they may know more about you than you. Or at least think they do.
Click over to infousa and you can have a mailing list in a few minutes. You don't need to create an account or log in to do queries and get back the number of records you'd be purchasing. You can't access the data they are storing, but you can see field names. One is the number of credit cards you have. InfoUSA has been in business since the 70's.
Already pointed out upthread, there are a lot of issues about the reliability of the data too. Best of luck to you if you happen to get data worse than you deserve. For better or worse the accuracy will probably improve over time, and the volume will too.
None of the above even gets into what may be happening to your medical data.
Welcome to the new Millennium. (We have cookies....and we know your FICO score.)
#457
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
Well said but that seems mostly an US problem. Here in europe most ( if not all ) countries have much stricter privacy laws then the US. In Germany for example hell would freeze over when an airine would use my yearly total income figure ( when not submmitted by me of course ) for marketing purposes.
The much more interesting question if DL is selling your data to "interested" other parties as the most profit in these databases is made beselling customized data sets.
The much more interesting question if DL is selling your data to "interested" other parties as the most profit in these databases is made beselling customized data sets.
#459
Join Date: Jun 2010
Location: Austin, TX
Programs: DL DM; DL AMEX Reserve; HHonors Gold
Posts: 1,984
I can provide a little insight on that. Many companies will use this type of data to generate ads within their pages. There are companies that specialize in marketing and providing targeted ads. To leverage this you must have a secure data transfer to provide this link.
#460
Senior Moderator; Moderator, Eco-Conscious Travel, United and Flyertalk Cares
Join Date: Jun 1999
Location: Fulltime travel/mostly Europe
Programs: UA 1.7 MM;; Accor & Marriott Pt; Hyatt Globalist
Posts: 17,831
There are numerous zips within San Francisco. I'm outside the city in a small community (13k people) that regularly makes those lists of priciest places to live. If I google the demographics of my zip, I pretty much see what DL has. As for SF, likely lots of A01s on Nob Hilll; not many in the Tenderloin.
#461
Senior Moderator; Moderator, Eco-Conscious Travel, United and Flyertalk Cares
Join Date: Jun 1999
Location: Fulltime travel/mostly Europe
Programs: UA 1.7 MM;; Accor & Marriott Pt; Hyatt Globalist
Posts: 17,831
I guess I'm saying it fits, but they only know me in a broad sense.
Whole Foods knows specific things about me, almost down to my calorie intake.
#462
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,407
http://www.linkedin.com/in/smitapremkumar
Here's Big Brother's Linked-In profile.
".... right offer to the right customer at the right time ..."
Here's Big Brother's Linked-In profile.
".... right offer to the right customer at the right time ..."
#463
Join Date: Jan 2010
Programs: AA Plat 2MM/UA G MM/DL MM DM 2015/BA Silver/Hyatt Diamond
Posts: 3,103
Clearly they developed a model about who lives in a specific community, but I don't think it's rocket science. On our own each of us could probably pick a community and come up with some spot-on observations. People in high-wealth communities read news, vote, participate in the arts, value education, travel more, buy european cars, etc. Package it pretty and - viola!
I guess I'm saying it fits, but they only know me in a broad sense.
Whole Foods knows specific things about me, almost down to my calorie intake.
I guess I'm saying it fits, but they only know me in a broad sense.
Whole Foods knows specific things about me, almost down to my calorie intake.
#464
FlyerTalk Evangelist & Ambassador: China
Join Date: Aug 2005
Location: DEN
Programs: DL DM/MM, UA 1K, AA Exp, HH Dia, WOH Glob, IHG Plat, Marriott Gold, NA EE, Hertz PC
Posts: 17,421
There are numerous zips within San Francisco. I'm outside the city in a small community (13k people) that regularly makes those lists of priciest places to live. If I google the demographics of my zip, I pretty much see what DL has. As for SF, likely lots of A01s on Nob Hilll; not many in the Tenderloin.
#465
Join Date: Apr 2012
Location: The SkyClub at F/G in MSP
Programs: Delta Diamond, Marriott Platinum
Posts: 92
You can see what google thinks of you here: http://www.google.com/ads/preferences/view