Jun 12, 2013, 7:24 pm

FlyerTalk Forums Expert How-Tos and Guides

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

Delta and new DL.com Profiles A Lot About You

Reply Subscribe

Thread Tools

Search this Thread

Jun 12, 2013, 3:16 pm

#601

javabytes

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

Quote:

Originally Posted by MSPeconomist

Check your stored credit cards. It should be one code per card.

I have far more stored payment options than codes in v25.

Jun 12, 2013, 3:16 pm

#602

ShopAround

Join Date: Jun 2006

Location: NYC

Programs: DL PM MM SC; GE; Bonvoy Titanium; IHG Diamond

Posts: 2,310

Quote:

Originally Posted by Geogirl1234

I own and mine says EPK

I own and mine says IBR - but that doesn't mean DL doesn't have my info wrong. And I have nothing in V18, which could be home value.

Jun 12, 2013, 3:16 pm

#603

MSPeconomist

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,417

Could v16 be that marketing/consulting demographic classification code? There was a link in this thread for the company's website.

Jun 12, 2013, 3:16 pm

#604

GRALISTAIR

FlyerTalk Evangelist

Join Date: May 2008

Location: CHA, MAN;

Programs: Delta DM 1 MM; Hz PC

Posts: 11,169

Quote:

Originally Posted by flyerwma

For v22, I have seen "IBR" for someone who rents, but "IBE" for someone who owns (and this value carries across the household).

Mine says MNB

Jun 12, 2013, 3:17 pm

#605

twohundredfifty

Join Date: Jan 2010

Programs: DL PM, UA Gold

Posts: 363

Quote:

Originally Posted by flyerwma

Agree. (In 000s)

Not so sure, unless my house has doubled in value.

Jun 12, 2013, 3:17 pm

#606

dean1121

Join Date: Jan 2009

Location: ATL/LAX

Programs: Delta Diamond 2MM, AA EXP

Posts: 703

I wonder if MQD is in there yet??

Jun 12, 2013, 3:18 pm

#607

MSPeconomist

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,417

Quote:

Originally Posted by GRALISTAIR

Mine says MNB

Mellon National Bank?

Jun 12, 2013, 3:19 pm

#608

javabytes

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 believe v15 is incomeAmt and v18 is homeValueAmt. I am trying to figure out if v06 is discSpndngAmt but now in thousands.

Jun 12, 2013, 3:20 pm

#609

twohundredfifty

Join Date: Jan 2010

Programs: DL PM, UA Gold

Posts: 363

Quote:

Originally Posted by GRALISTAIR

Mine says MNB

Quote:

Originally Posted by Geogirl1234

I own and mine says EPK

Mine says FEX; wife's says ZHP

Jun 12, 2013, 3:21 pm

#610

some dude

Join Date: Mar 2011

Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent

Posts: 705

Agree v18 is probably home value * 1000.

Jun 12, 2013, 3:21 pm

#611

some dude

Join Date: Mar 2011

Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent

Posts: 705

For the currently unknown strings:

"v01" : "CHH",
"v08" : "FP",
"v25" : "IK,BBQ,NORZ",
"v22" : "MKV",

Jun 12, 2013, 3:23 pm

#612

StayingHomeIsBetter

FlyerTalk Evangelist

Join Date: Jun 2008

Programs: Formaldehyde Medallion DL DieMiles

Posts: 12,646

[Moving this...]

Last edited by StayingHomeIsBetter; Jun 14, 2013 at 1:24 pm Reason: OT here

Jun 12, 2013, 3:24 pm

#613

Geogirl1234

Join Date: Jan 2008

Location: SAN

Programs: Delta Silver; 0.75MM: AA; Alaska; Southwest

Posts: 1,155

Quote:

Originally Posted by MR_MAMA

Mosaic is mosaic marketing puts you in a category to market to
http://www.experian.com/assets/marke...c-brochure.pdf

Go to page 6 of this list and look for your code

I haven't been able to determine if the Mosaic is still one of the entries. None of my remaining ones seem to match the codes. Any one?

Jun 12, 2013, 3:27 pm

#614

javabytes

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

Quote:

Originally Posted by MSPeconomist

Could v16 be that marketing/consulting demographic classification code? There was a link in this thread for the company's website.

You mean the Experian Mosaic code? I'm trying to figure out which one that is, because those are numbered A01 through S71. Mine is B07 (Generational Soup) but I don't see anything that correlates.

Jun 12, 2013, 3:28 pm

#615

brocklee9000

Join Date: Mar 2013

Location: PVU, SLC

Programs: DL Pork Medallion, PP, GE

Posts: 1,657

Okay here is what I have so far. Anything that multiple people have suggested and potentially confirmed has a question mark. Anything without a description is either unconfirmed or in dispute.

{
"v01":"NHB",
"v02":"US", country of residence
"v03":"Y",
"v04":"CPJ",
"v05":"en", language
"v06":"32", discretionary spending
"v07":"FO", elite status level
"v08":"VR",
"v09":"N",
"v10":"N",
"v11":"",
"v12":"6", segments
"v13":"",
"v14":"N",
"v15":"133", income
"v16":"121",
"v17":"", MM status
"v18":"261", home value in 1,000s???
"v19":"N",
"v20":"N",
"v21":"XXXXXXXXXX", SM number
"v22":"EPE",
"v23":"IBB",
"v24":"",
"v25":"", stored payment? IKBL=AMex PL?
"v26":"1",
"v27":"Y",
"v28":"000XXXXXXXXXX", SM number w/ 3 zeros
"v29":"Y",
"v30":"0", customer value
"v31":"XXXXX", RDM balance
"v32":"",
"v33":"XXXXX", MQM balance
"v34":"",
"v35":"N",
"v36":"N",
"v37":""}

Corrections and suggestions welcome. I tried to alter any personal identifiers.