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

Jan 25, 2013, 9:01 am

#241

DLdweeb

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

Quote:

Originally Posted by Ti22

But when I consider how this incorrect (insulting) information could possibly influence day-to-day treatment by DL and/or other businesses - 'leaves me with even more foul taste than the failed website/app, FCM, fewer UG's and recent MQ announcement....

+100

Jan 25, 2013, 9:02 am

#242

GRALISTAIR

FlyerTalk Evangelist

Join Date: May 2008

Location: CHA, MAN;

Programs: Delta DM 1 MM; Hz PC

Posts: 11,169

Thomas Hudson's would be
Peer of the Realm, royalty, really should be on private jets

Jan 25, 2013, 9:02 am

#243

motytrah

Join Date: Jan 2007

Posts: 5,679

custValSeg:"2"
smTierLvl:"FF" - NO STATUS and haven't for a couple years.
mindsetSeg:"DD"

I mostly fly paid Y/J, but no enough on DL for status. Nice to see I have higher value than a lot of GMs out there.

The birth date is dumb. It's a nice carrot for potential Identity theft thieves.

Jan 25, 2013, 9:03 am

#244

DaChief

Join Date: Jan 2008

Location: MLB

Programs: DL - KM DM, DL 1.57 MM, UA - 1P, AA - EXP HH - Diamond, PC - Platinum, SPG - Gold, Hertz 5*

Posts: 887

Interesting Thread!

custValSeg":"25"
"mindsetSeg":"GT"
"mosaicCd":"C11"

Fly mostly international. Mosaic not a bad match. Income low. Disc Spending fairly close to what I spent last year.

Jan 25, 2013, 9:04 am

#245

MR_MAMA

Join Date: Jul 2010

Location: MKE

Programs: DL-MM-Diamond HH-Diamond

Posts: 3,218

Quote:

Originally Posted by motytrah

The birth date is dumb. It's a nice carrot for potential Identity theft thieves.

no one can see this but you. you have to be in a secure login and really even we couldn't see if unless the OP posted about it. I am sure most companies pull this information in the background, I sure bet your bank does and amex

Jan 25, 2013, 9:05 am

#246

bowdenj

Join Date: Apr 2001

Location: Indianapolis, IN USA

Posts: 2,066

Quote:

Originally Posted by Astriker

{"actvtyPref":"DT,MT,AA,OP", - This intrigues me since many don't reference it

Good call - not many have had anything in this field - At first I thought perhaps it meant you were also preferred on AA but not sure MT/DT/OP.

Jan 25, 2013, 9:05 am

#247

USFFlyer

Join Date: Nov 2006

Location: LAX

Programs: UA 1K, AS MVP 75K, Marriott Gold, Hyatt Diamond

Posts: 241

Quote:

Originally Posted by Ti22

LOL.... Yeah, I got blue in the face!

I'm actually more concerned about "databroker" - google that and read recent news.

Ditto this...not sure I want these people collecting my identifying information.

http://www.nytimes.com/2012/12/19/te...kers.html?_r=0

As datapoints, im an FO:

DW mindset
G25 mosaic
'0" custValseg

House value is about right, income is wildly low (about 10% of my actual income). I'm in my early twenties and this doesn't correspond to the income I gave AMEX or put on any other surveys, so not sure where they are getting this info.

Jan 25, 2013, 9:06 am

#248

Ti22

Join Date: Sep 2011

Location: Wherever I happen to be....

Programs: DL EOS...

Posts: 1,111

Quote:

Originally Posted by motytrah

The birth date is dumb. It's a nice carrot for potential Identity theft thieves.

Along with the zip code and the fact we have an Amex. Man, this IT dept should just start over!

Jan 25, 2013, 9:06 am

#249

Vuelos

Join Date: Dec 2005

Location: Likely being followed...

Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]

Posts: 5,240

Quote:

Originally Posted by PRWeezer

Ha! Well, the 'expanded' version of our profile said 50-60+ on the verge of retirement. Definitely not in that age range & as much as we'd love to retire tomorrow it's not going to happen. (S3B?

)

^^^ c'mon you can get to places on a 3B!

Quote:

Originally Posted by Ti22

On one hand, they really don't have much accurate info about me and my households (bi-coastal). Good.

But when I consider how this incorrect (insulting) information could possibly influence day-to-day treatment by DL and/or other businesses - 'leaves me with even more foul taste than the failed website/app, FCM, fewer UG's and recent MQ announcement....

Did you read the detailed description of your segment or just the title?

Jan 25, 2013, 9:06 am

#250

cliburn

Join Date: Nov 2000

Location: Minnetonka, MN, USA

Programs: DL Diamond 2MM, AA ExPlt

Posts: 938

I am a DM who flies normally SLUT fares.
CustValSeg = 0
MindsetSeg = FL

Most of the stuff (except house value) seems off

Jan 25, 2013, 9:09 am

#251

northwest_buckeye

Join Date: Dec 2010

Programs: Delta FO, Marriott LT Titanium, HHonors Gold, Nat'l Exec, Amex Plat

Posts: 420

Everything was pretty accurate for me... Which is amazing and/or creepy.

I listed as mindsetseg SS from GM, custvalseg 6, and Mosaic of G24.

Jan 25, 2013, 9:09 am

#252

Ti22

Join Date: Sep 2011

Location: Wherever I happen to be....

Programs: DL EOS...

Posts: 1,111

Quote:

Originally Posted by Vuelos

Did you read the detailed description of your segment or just the title?

What segment, the Mosaic? If so, sure I read several pages and graphs, yuk, yuk, yuk....

Jan 25, 2013, 9:10 am

#253

dgxoxo

Join Date: Apr 2010

Location: NYC / Chelsea

Programs: Delta, Avios, Chase

Posts: 1,099

Quote:

Originally Posted by bubbashow

DL has me at a MUCH-lower income than I make. Like 80% less.

Me too, but 70% less than what I actually make... in fact I can't recall ever making the amount specified in my profile.

Jan 25, 2013, 9:11 am

#254

sethb

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

Quote:

Originally Posted by steex

FL - Fare L; customers who fly a lot, but typically purchase non-refundable fares well in advance, not meeting the "SS" criteria

Accurate for me.

Quote:

Originally Posted by doubleA

"cobrandCardCd":"AX,AXCG", (Have DL Gold AX and AX Platinum/Personal)
Not sure how to parse this one:
,"skyClubFtrCntrctInd":"N"
,"skyClubMbr":"Y"

I have "AX, AXCP" (DL Plat, AX Platinum/Personal)

skyClubMbr:Y due to DM.

Quote:

Originally Posted by mnredfox

Still can't crack these:
"actvtyPref":
"bcInd":
"mindsetSeg":

I have actvtyPref blank, bcInd:Y.

Mosaic is A06, not too bad.

Quote:

Originally Posted by goodandclassy

probably your income when you first applied for amex - mine is also a third of what it is now

gotta love student jobs haha

discSpndngAmt is a few hundred $ off what I spend on DL Amex card last year. (Or maybe what I spent; Amex's report shows net of credits.)

poCd is missing a digit 10065-650.

homeValueAmt: I wish. (I just moved, I'm selling it. I moved to a rental for now, so it isn't that.)

incomeAmt is laughably low for now, way high for when I first got an Amex card (decades ago). Otoh, times 100 it might not be a bad approximation of my actual spend on Delta last year.

"htlBrndPref" is blank.

skyClubRnwlDt might be the date I became Diamond.

smAmexCntrnInd:N I don't know what that is.

Jan 25, 2013, 9:12 am

#255

DaChief

Join Date: Jan 2008

Location: MLB

Programs: DL - KM DM, DL 1.57 MM, UA - 1P, AA - EXP HH - Diamond, PC - Platinum, SPG - Gold, Hertz 5*

Posts: 887

I just think DL planted this hoping you would post enough data from your profile on here so they could figure out who you really are on FT