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 12, 2013, 7:21 pm
#691
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Jun 12, 2013, 7:23 pm
#692
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Jun 12, 2013, 7:25 pm
#693
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,277
I have started a Wikipost for this highly collaborative effort. As items and codes are confirmed, let's centralize them in one place rather than thumb through hundreds of discussion posts. I've started to populate based on previous posts.
Jun 12, 2013, 7:29 pm
#694
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Jun 12, 2013, 7:40 pm
#697
Join Date: Oct 2009
Location: IND
Programs: DL DM, SPG AMB, National EE
Posts: 1,301
For V06: folks have been saying that is discretionary spending...
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Jun 12, 2013, 7:51 pm
#698
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,277
Jun 12, 2013, 7:56 pm
#699
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
For V06: folks have been saying that is discretionary spending...
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
For me, not a chance.
On another topic, my fear with a wikipost is that all of it will be deleted when DL figures out that we've cracked their clever code.
Jun 12, 2013, 7:57 pm
#700
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
For V06: folks have been saying that is discretionary spending...
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Jun 12, 2013, 7:58 pm
#701
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
For V06: folks have been saying that is discretionary spending...
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Any thought to this being the amount you spent with DL last year? For me, I have a 27 there and when I added up all the spend I could find for 2012 I came up with 25k - but I didn't think about tickets purchased in 2011 for travel in 2012, so it's possible that it would be right on the dollar in my case. Just a thought.
Jun 12, 2013, 8:00 pm
#702
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,277
What's far more likely is that the hide the data on the website again.
Jun 12, 2013, 8:04 pm
#703
Join Date: Jan 2010
Programs: DL PM, UA Gold
Posts: 363
Yeah, for me V01=NWH and I'm in the STL.
Unless NWH refers to Newport, NH
:
http://www.gcmap.com/mapui?P=nwh
Unless NWH refers to Newport, NH
:http://www.gcmap.com/mapui?P=nwh
Jun 12, 2013, 8:05 pm
#704
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
The person I am investigating also has 7.
(I don't fly DL myself, so I have permission to use a WA PM account for investigative purposes. They want to know, I want to do the work.)
Jun 12, 2013, 8:05 pm
#705
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
For some reason, I don't see an edit button. I only have the option to minimize/maximize the post, or click on the name of the last editor.
Anyway, I guess I'll just let others edit it. I agree with the general notion that v06 is discretionary spending. It's not quite spot on for me, but it's kinda close. Also, have we been able to conclude that v01 is home airport?
Anyway, I guess I'll just let others edit it. I agree with the general notion that v06 is discretionary spending. It's not quite spot on for me, but it's kinda close. Also, have we been able to conclude that v01 is home airport?