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
Jan 27, 2013, 9:38 pm
#496
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Thanks, I was too lazy to read all 500 posts... while I was trying to catch up on the Sky Miles update thread. 
"While the data displayed was only available to the specific user, we sincerely regret that this code displayed ...."
Yeah, I am confident that they sincerely regret this.
They want to amass great amounts of potentially unreliable data about us, but regret our knowing about it.
"While the data displayed was only available to the specific user, we sincerely regret that this code displayed ...."
Yeah, I am confident that they sincerely regret this.
They want to amass great amounts of potentially unreliable data about us, but regret our knowing about it.
Jan 27, 2013, 9:41 pm
#497
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
Jan 28, 2013, 3:01 pm
#498
Join Date: Mar 2011
Posts: 647
Jan 28, 2013, 5:04 pm
#499
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
Maybe your browser gets the info from Delta, and forwards it to the sites that generate the ads that dl.dumb shows you, so they can select which ad.
Jan 28, 2013, 9:37 pm
#501
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,423
Jan 29, 2013, 8:49 am
#503
Join Date: Jan 2013
Programs: DL PM; Hilton Gold; IHG Gold;
Posts: 5
Act Fast... I think you can still get to the data!
I used Firefox with the "Firebug" add-in. Once installed, go to the delta website. Click the new "Firebug" button on the top right to launch the add-in, go to the "net" tab, then click the "Persist" button (leave the other button on "All"). Now log in to your account. It will list all of the data exchanges that open up between your browser and the site.
Scan the list. You should see "[+] POST bcdata.action". Drop down this [+] box.
Scan the "Headers" section, and towards the bottom you'll see details of a cookie. Copy/Paste this into a document editor.
It appears to be coded as "%2C" = Question, and "%3D" = responses, with a few minor variations. The variable names themselves appears to be the same, once accounting for these parsing letters.
Interestingly, I made PM in late December 2012. Field "smMthdOfAtnmt" (method of skymiles attainment) shows me as "12GOLD"... SO I suppose this may not have been updated since then... although when I log in the website itself does reflect my PM. Maybe this is the old "cookie" format of what the JSON was transmitting.
Most other fields seem to be dead-on. It shows me as F22, which is fair. My "incomeAmt" is my annual salary (as typically reported to CC apps, etc. within past 12 months). Yet other fields were off. My house value was either an old rental from 2 years ago or my parents house from when I joined (back in '94). It also lists my education as Bachelors but I have a PhD.
Interestingly, I see a "prtnrRev" field. I am guessing this is Partner Revenue. I flew one AeroMexico flight last year, and the amount shown is in the ballpark of what I paid.
It shows my mindsetSeg as DW and my CustValSeg as 2. I have been an infrequent flyer and SM member since 1994, but have come on strong this past year due to a new job. I fly almost exclusively within the US and stick to the middle economy fare classes (rare YBM and rare LUT) most of the time. I also joined SkyClub and hold the Amex Delta Plat.
I agree with prior posters that figuring out the "mindset" coding would be interesting, if nothing more than better understanding how Delta's sees (and segments) it's customer base. If people can keep posting their mindset and value codes, along with a brief description of their travel history and pattern, I bet we could get a bit further on this.
Good luck to all!
Jan 29, 2013, 9:44 am
#504
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
I launched firebug and while I saw the cookie, there was nothing like the other info in mine, just the sort of stuff you'd expect to keep track of a logon.
In the "social-core-data" I did see my SkyMiles join date was in 1986 -- hadn't realized it was that early. I do remember somebody (UA?) canceled my SMF-LAX flight and booked me on DL so I signed up.
In the "social-core-data" I did see my SkyMiles join date was in 1986 -- hadn't realized it was that early. I do remember somebody (UA?) canceled my SMF-LAX flight and booked me on DL so I signed up.
Jan 29, 2013, 10:12 am
#505
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Act Fast... I think you can still get to the data!
I used Firefox with the "Firebug" add-in. Once installed, go to the delta website. Click the new "Firebug" button on the top right to launch the add-in, go to the "net" tab, then click the "Persist" button (leave the other button on "All"). Now log in to your account. It will list all of the data exchanges that open up between your browser and the site.
Scan the list. You should see "[+] POST bcdata.action". Drop down this [+] box.
Scan the "Headers" section, and towards the bottom you'll see details of a cookie. Copy/Paste this into a document editor.
It appears to be coded as "%2C" = Question, and "%3D" = responses, with a few minor variations. The variable names themselves appears to be the same, once accounting for these parsing letters.
Interestingly, I made PM in late December 2012. Field "smMthdOfAtnmt" (method of skymiles attainment) shows me as "12GOLD"... SO I suppose this may not have been updated since then... although when I log in the website itself does reflect my PM. Maybe this is the old "cookie" format of what the JSON was transmitting.
Most other fields seem to be dead-on. It shows me as F22, which is fair. My "incomeAmt" is my annual salary (as typically reported to CC apps, etc. within past 12 months). Yet other fields were off. My house value was either an old rental from 2 years ago or my parents house from when I joined (back in '94). It also lists my education as Bachelors but I have a PhD.
Interestingly, I see a "prtnrRev" field. I am guessing this is Partner Revenue. I flew one AeroMexico flight last year, and the amount shown is in the ballpark of what I paid.
It shows my mindsetSeg as DW and my CustValSeg as 2. I have been an infrequent flyer and SM member since 1994, but have come on strong this past year due to a new job. I fly almost exclusively within the US and stick to the middle economy fare classes (rare YBM and rare LUT) most of the time. I also joined SkyClub and hold the Amex Delta Plat.
I agree with prior posters that figuring out the "mindset" coding would be interesting, if nothing more than better understanding how Delta's sees (and segments) it's customer base. If people can keep posting their mindset and value codes, along with a brief description of their travel history and pattern, I bet we could get a bit further on this.
Good luck to all!
I used Firefox with the "Firebug" add-in. Once installed, go to the delta website. Click the new "Firebug" button on the top right to launch the add-in, go to the "net" tab, then click the "Persist" button (leave the other button on "All"). Now log in to your account. It will list all of the data exchanges that open up between your browser and the site.
Scan the list. You should see "[+] POST bcdata.action". Drop down this [+] box.
Scan the "Headers" section, and towards the bottom you'll see details of a cookie. Copy/Paste this into a document editor.
It appears to be coded as "%2C" = Question, and "%3D" = responses, with a few minor variations. The variable names themselves appears to be the same, once accounting for these parsing letters.
Interestingly, I made PM in late December 2012. Field "smMthdOfAtnmt" (method of skymiles attainment) shows me as "12GOLD"... SO I suppose this may not have been updated since then... although when I log in the website itself does reflect my PM. Maybe this is the old "cookie" format of what the JSON was transmitting.
Most other fields seem to be dead-on. It shows me as F22, which is fair. My "incomeAmt" is my annual salary (as typically reported to CC apps, etc. within past 12 months). Yet other fields were off. My house value was either an old rental from 2 years ago or my parents house from when I joined (back in '94). It also lists my education as Bachelors but I have a PhD.
Interestingly, I see a "prtnrRev" field. I am guessing this is Partner Revenue. I flew one AeroMexico flight last year, and the amount shown is in the ballpark of what I paid.
It shows my mindsetSeg as DW and my CustValSeg as 2. I have been an infrequent flyer and SM member since 1994, but have come on strong this past year due to a new job. I fly almost exclusively within the US and stick to the middle economy fare classes (rare YBM and rare LUT) most of the time. I also joined SkyClub and hold the Amex Delta Plat.
I agree with prior posters that figuring out the "mindset" coding would be interesting, if nothing more than better understanding how Delta's sees (and segments) it's customer base. If people can keep posting their mindset and value codes, along with a brief description of their travel history and pattern, I bet we could get a bit further on this.
Good luck to all!
Jan 29, 2013, 10:17 am
#506
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,413
Is there really a field here for education level? I don't remember noticing it or anyone having mentioned it before now.
Jan 29, 2013, 11:07 am
#508
Join Date: Jan 2013
Programs: DL PM; Hilton Gold; IHG Gold;
Posts: 5
Using the code from this source is not as obvious, you have to break it down\parse it. Here is what mine looked like (partial, with actual values replaced with "@")
... 3A%3DvisitorId%3D%7CPROFILEDATA%3A%3Dmp_country%3D US%2Cmp_lang%3Den%2CbirthDt%3D@@@@@@@@%2CcaInd%3DY %2CchldAgeRange%3D@@@@@%2CctryCd%3D@@%2CcustID%3D@ @@@@@@@@@@@@%2CcustItrstCd%3D%2CdiscSpndngAmt%3D@@ @@@%2CdrvdGndr%3D@%2CeducationCd%3D@@@%2ChomeOwner Ind%3D@%2ChomeValueAmt%3D@@@@@@%2CincomeAmt%3D@@%2 CmaritalSts%3D@ ...
If you break it down based on the %2C and the %3D, you start to see all of the codes and responses. Many/most of the fields match the JSON version.
Last edited by yelldawg; Jan 29, 2013 at 11:14 am
Jan 29, 2013, 11:53 am
#509
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
Jan 29, 2013, 12:36 pm
#510
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
I actually think this "cookie" version has more info. "Education" and "partnerRev" were not on the original list from JSON version.
Using the code from this source is not as obvious, you have to break it down\parse it. Here is what mine looked like (partial, with actual values replaced with "@")
... 3A%3DvisitorId%3D%7CPROFILEDATA%3A%3Dmp_country%3D US%2Cmp_lang%3Den%2CbirthDt%3D@@@@@@@@%2CcaInd%3DY %2CchldAgeRange%3D@@@@@%2CctryCd%3D@@%2CcustID%3D@ @@@@@@@@@@@@%2CcustItrstCd%3D%2CdiscSpndngAmt%3D@@ @@@%2CdrvdGndr%3D@%2CeducationCd%3D@@@%2ChomeOwner Ind%3D@%2ChomeValueAmt%3D@@@@@@%2CincomeAmt%3D@@%2 CmaritalSts%3D@ ...
If you break it down based on the %2C and the %3D, you start to see all of the codes and responses. Many/most of the fields match the JSON version.
Using the code from this source is not as obvious, you have to break it down\parse it. Here is what mine looked like (partial, with actual values replaced with "@")
... 3A%3DvisitorId%3D%7CPROFILEDATA%3A%3Dmp_country%3D US%2Cmp_lang%3Den%2CbirthDt%3D@@@@@@@@%2CcaInd%3DY %2CchldAgeRange%3D@@@@@%2CctryCd%3D@@%2CcustID%3D@ @@@@@@@@@@@@%2CcustItrstCd%3D%2CdiscSpndngAmt%3D@@ @@@%2CdrvdGndr%3D@%2CeducationCd%3D@@@%2ChomeOwner Ind%3D@%2ChomeValueAmt%3D@@@@@@%2CincomeAmt%3D@@%2 CmaritalSts%3D@ ...
If you break it down based on the %2C and the %3D, you start to see all of the codes and responses. Many/most of the fields match the JSON version.
BTW, Firebug will parse the text for you if you click on "Cookies" instead of "Headers".