Extended Data Feed

The Salesforce Data Management Platform (DMP) allows publishers and marketers to collect and organize consumer web data in one central "big-data" warehouse. Using the Salesforce DMP, it’s possible to consolidate and reconcile first party "web-behavior" data that is generated by consumers as they browse. Publishers and marketers can also integrate data from their user registration and subscription databases into the Salesforce DMP.

The "raw" consumer web data collected in the Salesforce DMP can be analyzed and combined into Audience Segments using Salesforce DMP’s Segment Builder. Salesforce DMP users can then use these audience segments to customize content and advertising, and commerce offers on their websites.

Extended Data Feeds detailed data that a client might want such as:

  • timestamp
  • geographic data (country, region, domain (IP address based),  zipcodes)
  • site (for attribute data)
  • browser
  • device

Note: Extended Data Feeds incur additional charges.

Extended Data Feed

The Extended Data Feed includes up to 7 files:

  1. User Audience Segment Map - Included and described in Standard Data Feed
  2. Segment Mapping - Included and described in Standard Data Feed
  3. Media User Data (daily upload of activity) 
  4. Paid Search User Data (daily upload of activity)
  5. Site User Data (daily upload of activity)  
  6. Event User Data (please note, additional charges apply)
  7. Transaction User Data (please note, additional charges apply)

Each extract is available as a Caret (^) Separated Value file (CSV) and can be shared with the client via Krux's Amazon S3 account.  The client can then pull files from their client-specific location.

Salesforce DMP will deliver one or more files to client specific S3 bucket. Delivery location will remain constant, though number and naming of files may vary due to back end processing.

The formats of the extracts included in the Extended Data Feed are listed below.  Please refer to the Standard Data Feed for User Audience Map & Segment Mapping information.

Media User Data

Marketer use-case. This feed has user data by KUID for all media impression and click pixels (based on site).

Sample Marketer use-case for Media User Data:

**Format**
Timestamp^Day^ConfigurationId^KruxUserId^IpAddress^Browser^DeviceType^OperatingSystem^kxbrand^AdvertiserID^CampaignId^PlacementId^SiteId^CreativeId^AdId^isClick^geoDataDisplay

**Data**
"435383416000"^"2015-06-27"^"KfvZM-fT"^"000431b418423dd568349645f0b748bc"^"122.161.23.16"^"Safari-7"^"Computer"^"Mac OS X"^"general_brand"^"54321"^"8334801"^"994734046"^"0956407"^"91858298"^"989981762"^"0"^"country=in&region=mp&domain=airntelbroadband.in&zipcodes=994043"

Paid Search User data

Marketer use-case. Similar to the Media User Data feed, this feed has user data by KUID for search clicks (based on site).

Sample Marketer use-case for Paid Search User Data:

**Format**
Timestamp^Day^KruxUserId^IpAddress^Browser^Device^OperatingSystem^CampaignId^AdId^CreativeId^searchEngine^SearchKeywords^geoDataDisplay

**Data**
"1448232083733"^"2015-11-22"^"10.196.54.181.1316994243919954"^"88.176.242.37"^"Firefox 4-42"^"Computer"^"Windows"^"9335139"^"399295001"^"3-14228814299-78827468946"^"google"^"-"^"country=us&region=az&dma=789&domain=cox.net&zipcodes=95614"
"1448161504844"^"2015-11-22"^"K2Jw_OBH"^"73.48.100.128"^"Firefox 4-42"^"Computer"^"Windows 7"^"0443801"^"299998487"^"291448487"^"yhoo"^"-"^"country=us&region=ma&dma=506&zipcodes=91536"
"1448214880756"^"2015-11-22"^"KxFJuPF7"^"81.119.109.16"^"Firefox 4-42"^"Computer"^"Windows XP"^"0445139"^"277795023"^"3-5551587906-77726718066"^"google"^"-"^"country=us&region=ri&dma=521&zipcodes=92813"

Site User Data

Publisher and Marketer use-case. This is a raw breakdown by KUID of what user and page attributes were collected.

Sample Publisher and Marketer use-case for Site User Data:

**Format**
Timestamp^Day^KruxUserId^IpAddress^Browser^Device^OperatingSystem^Url^SiteData^geoDataDisplay

**Data**
"1448187988000"^"2015-11-22"^"00314g54dpex441z5y1dec4243502912"^"96.16.68.120"^"Safari-9"^"Computer"^"Mac OS X"^"https://staredsx.dsxtxzs.com/home"^"keywords=investing, trading, stock, stocks, bonds, fixed income, mutual funds, etf, options, futures, IRAs, roll over 401k, retirement, Roth IRA, online trading, stock quotes, mobile trading, active trader, ztradesprox, managed investments, trade, SUPERTRADE&url_path_1=home&visitor_day_of_week=Sunday&visitor_time_of_day=Morning&visitor_date_of_month=22&logged_in=false&site=SUPERTRADE&section=home"^"country=us&region=ca&dma=825&domain=zxdeswu.com&zipcodes=94043"

Event User Data

Publisher and Marketer use-case. (Please note, additional charges apply). This feed contains a breakdown by KUID on data from event pixels fired onsite.

Sample Publisher and Marketer use-case for Event User Data:

**Format**
Timestamp^Day^KruxUserId^IpAddress^Browser^Device^OperatingSystem^EventID^EventData^geoDataDisplay

**Data**
"1447954838000"^"2015-11-19"^"0050cd89f52b874i99d4618351fb7600"^"129.115.195.21"^"Safari-9"^"Computer"^"Mac OS X"^"Lmjy9VyT"^"-"^"country=us&region=tx&dma=641&domain=ctsa.edu&zipcodes=98242"
"1447914570000"^"2015-11-19"^"006v10296a9e014i37dz805fb31a9ce4"^"60.181.180.178"^"Mobile Safari-9"^"Mobile"^"Mac OS X (iPhone)"^"LpcixQgS"^"-"^"country=us&region=ca&dma=807&domain=comcast.net&zipcodes=94150"
"1447914571000"^"2015-11-19"^"006v10296a9e014i37dz805fb31a9ce4"^"60.181.180.178"^"Mobile Safari-9"^"Mobile"^"Mac OS X (iPhone)"^"LrR9OprM"^"-"^"country=us&region=ca&dma=807&domain=comcast.net&zipcodes=94150"
"1447914647000"^"2015-11-19"^"006v10296a9e014i37dz805fb31a9ce4"^"60.181.180.178"^"Mobile Safari-9"^"Mobile"^"Mac OS X (iPhone)"^"LnDGl3zm"^"-"^"country=us&region=ca&dma=807&domain=comcast.net&zipcodes=94150"

Transaction User Data

Publisher and Marketer use-case. (Please note, additional charges apply).  This feed contains a breakdown by KUID of transaction pixel data fired onsite. It includes all transaction data passed to Salesforce DMP for a user.

Sample Publisher use-case for Transaction User Data:

**Format**
Timestamp^Day^KruxUserId^IpAddress^Browser^Device^OperatingSystem^TransactionData^geoDataDisplay
**Data**
"1468860693000"^"2016-07-18"^"0123456ef3da7d6e3bda69cceadc3f6f"^"221.16.120.247"^"Mobile Safari-9"^"Mobile"^"Mac OS X (iPhone)"^"productCategory=Shirts&productName=Origin Penguin Slim Shirt&pageType=Checkout&userType=memberdate=2016-07-18&price=50.0&quantity=1"^"country=us&region=nj&dma=501&domain=verizon.net&zipcodes=12233"

 
For additional info see: 
Extended Data Feed Technical Specification Sheet

Have more questions? Submit a request

0 Comments

Article is closed for comments.