Standard 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 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.

Standard Data Feeds

The Standard Data Feed provides 2 file sets by default and an additional user match table upon request:

  1. User Audience Segment Map (full refresh) - Export of all users and the segments they are a part of.  
  2. Segment Mapping - Export of all segment IDs and mapping to segment name along with last computed date.
  3. First Party Usermatch Table (Upon request) - Export of all first party user ids mapped to a Krux User ID.

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 each extract are listed below:

User Audience Segment Map

The user audience segment map is available in 2 formats:

  1. De-normalized (all segments for a user are listed in one row):
    1. Krux User ID
    2. Publisher User ID (if publisher user-matching has been enabled)
    3. Segment List: comma-separated list of Segment IDs
  2. Normalized (each segment for a user is listed in a separate row):
    1. Krux User ID
    2. Publisher User ID (if publisher user-matching has been enabled)
    3. Segment ID

Sample De-normalized Audience Segment Map:

CLICK TO SCROLL and view entire sample

**Format**
KruxUserID^PublisherUserID^SegmentID_1,SegmentID_2

**Data**
H-BzegqK^-^KnfkKSYc,1b0_qwR,5XA_2BUt,5XAtRS,KgtK_2l9,KgtKkKE4,Kss_6Ciu,K5_UmfGe,K1eGkSX7,KE7d7WS8,Khs2HmA2,K9o8e4vw,K1910ueg
H-DNsgaE^-^KEhUTKLA,KIzIsBb6,KfYWnVIY,KIDInF9L
H01MOZfa^-^Khs1CKxP,KgsrHKRm,KgsreNBQ,KermxnBE,Kfb8bgPE,KgsxR3Oe,KIdHqzYg,Khs3HmA2,KIDInF9L
H12Thbgl^-^KvKR03uf,Kf0KqZ9L,KIDIrF9L

Sample Normalized Audience Segment Map:

CLICK TO SCROLL and view entire sample

**Format**
KruxUserID^PublisherUserID^SegmentID

**Data**
004326160e9994bd6f3f4e30270a5dc8^-^KzzFYzb1
00182006a6xbe3ibd4ledc2c0eb59z04^-^KyBA51Ud
00182006a6xbe3ibd4ledc2c0eb59z04^-^K3r1VWTE

Segment mapping file

Salesforce DMP also provides a mapping file that maps SegmentIDs to Segment Names. The mapping file has the following columns:

  • Category
  • Sub Category
  • Type
  • Name
  • Segment ID
  • Segment ID Long
  • Last Compute Day
  • Description

Sample Segment Mapping File:

CLICK TO SCROLL and view entire sample

**Format**
Category,SubCategory,Type,Name,SegmentId,SegmentIdLong,Last Compute Day,Description

**Data**
Category,SubCategory,Type,Name,SegmentId,SegmentIdLong,Last Compute Day,Description
,,TEST,TEST001_ Xeneto in Lia,B8Y6OuXS,qscm4r5es,2015-11-20,First segment to test DMP (MKT)
,,TEST,TEST002_ Torrier at Ferlin,B94VLqBk,qtnqle84m,2015-11-20,Second segment (Fab)
TEST,,TEST,Tut Suit - Test OD,B95rgPLR,qtodBnyv3,2015-09-16,Test On Demand on standard segment activation - DF

First Party Usermatch Table

Upon request, Salesforce DMP can also provide a User Match Table holding the mapping of Krux User IDs and the latest first party user ID associated with them.

  • Sample First Party Usermatch File:

CLICK TO SCROLL and view entire sample

**Format**
UserIDAttribute^FirstPartyUserID^KruxUserID^Timestamp

**Data**
login_id^1234567^K1Y4v5tg^1480087480
login_id^9876543^K6T1mqSD^1480088069
login_id^4567890^K6TV_3SG^1480088126
login_id^7654321^K54urHXH^1480099969
login_id^3452123^K6o2cUJq^1480100645

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.