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
#796
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Delta and new DL.com Profiles A Lot About You
I love the codecracking in this thread. It's like the process of figuring out where the mystery video was shot in "The Good Shepherd."
LOL that DL though a basic substitution cypher would keep us from figuring this stuff out.
LOL that DL though a basic substitution cypher would keep us from figuring this stuff out.
#797
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
I have 7 blanks and 10 Y or N. That's almost half for me. And my customer value is nothing; I'm bound to DL for several reasons, and I fly/spend enough to stay FO. They know they've got me, and they laugh about it. At least they would laugh, if they knew I existed.
#798
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
I'm going to guess one of the Y/N is Suntrust. I have Suntrust and the following are Y
v03, v10, v27, v29, v35
If anyone else who has Suntrust can post what things are showing a Y designator for them we can likely easily identify which aspect is indicating this.
v03, v10, v27, v29, v35
If anyone else who has Suntrust can post what things are showing a Y designator for them we can likely easily identify which aspect is indicating this.
#799
Join Date: Mar 2011
Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent
Posts: 705
Does the custvalue have any meaning as far as how delta treats you, upgrades you, or offers you pricing/offers?
Curious why they have this in a JSON for their website.
Curious why they have this in a JSON for their website.
#803
Join Date: Jun 2004
Location: San Diego
Programs: IHG Spire Amb, HH Diamond, DL Diamond and 1MM
Posts: 3,610
Not Offended but LMAO at Delta
Total income and home value is accurate.
Discretionary spending seems low with my house paid off.
Mosaic category is C11 "Aging of Aquarius". Here's a link to an Experian marketing pdf discussing Mosaic and its application to travel industry marketing:
http://www.experian.com/assets/marke...ers-071912.pdf
Customer value is zero. That can't be right. I probably spent almost $5,000 earning Diamond status last year.
A characteristic of us "Aging of Aquarius" peeps is that we are affluent yet very price conscious.
HongKonger is right about the blinding stupidity of whoever thinks this is hiding anything. The whole thing gives me two images: an IT group too dumb to tie their shoes and a bunch of marketing suits too self-absorbed to see past their .......
Discretionary spending seems low with my house paid off.
Mosaic category is C11 "Aging of Aquarius". Here's a link to an Experian marketing pdf discussing Mosaic and its application to travel industry marketing:
http://www.experian.com/assets/marke...ers-071912.pdf
Customer value is zero. That can't be right. I probably spent almost $5,000 earning Diamond status last year.
A characteristic of us "Aging of Aquarius" peeps is that we are affluent yet very price conscious.
HongKonger is right about the blinding stupidity of whoever thinks this is hiding anything. The whole thing gives me two images: an IT group too dumb to tie their shoes and a bunch of marketing suits too self-absorbed to see past their .......
Last edited by Bowgie; Jun 13, 2013 at 1:27 am Reason: Apparently FT forbids a word that sounds like "wah anchor"
#804
Join Date: Mar 2011
Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent
Posts: 705
#805
Join Date: Jun 2004
Location: San Diego
Programs: IHG Spire Amb, HH Diamond, DL Diamond and 1MM
Posts: 3,610
Second question: Delta is blindingly stupid.
#806
Join Date: Mar 2009
Location: Los Angeles
Programs: Hhonors Diamond, IHG Silver, BW Diamond
Posts: 452
Wow, this is creepy! They got our income and house values close, but then have our home, favorite, and searched airports completely wrong. As in, I live in LA and they show some air force base in Hawaii as my closest airport. The Mosaic category of "Cul-De-Sac Diversity" is interesting. Described as "Ethnically diverse, middle aged
families settled in new suburban neighborhoods". They are pretty off there, considering we're not ethnically diverse at all and we live in a neighborhood built in the 50s, lol!
families settled in new suburban neighborhoods". They are pretty off there, considering we're not ethnically diverse at all and we live in a neighborhood built in the 50s, lol!
#807
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Wow, this is creepy! They got our income and house values close, but then have our home, favorite, and searched airports completely wrong. As in, I live in LA and they show some air force base in Hawaii as my closest airport. The Mosaic category of "Cul-De-Sac Diversity" is interesting. Described as "Ethnically diverse, middle aged
families settled in new suburban neighborhoods". They are pretty off there, considering we're not ethnically diverse at all and we live in a neighborhood built in the 50s, lol!
families settled in new suburban neighborhoods". They are pretty off there, considering we're not ethnically diverse at all and we live in a neighborhood built in the 50s, lol!
#808
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Not for UGs as far as we know, but for how they respond to your complaints, how they handle you in IROPs, whether they'll make exceptions, basically any customer service interactions not already governed by a publisher set of rules (and may e sometimes even for those).
#809
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
For V32, does anyone have saved "Dream Trips"? My dream trip entered on DL.com is the maldives, my v32 is DL coded through key 2 becomes MV (country abbreviation for the Maldives).
#810
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298