Loading
Contact Data in Marketing Cloud Engagement
Predictive Intelligence eCommerce Dimension Package Data Model

You are here:

  1. Salesforce Help
  2. Docs
  3. Engagement: Audience Builder and Contact Builder

Predictive Intelligence eCommerce Dimension Package Data Model

Review the data model for the data extensions used as part of the Predictive Intelligence eCommerce dimension package in Audience Builder.

IGO_PRODUCTS

FieldName Description Type and Length Required Primary Key
name Name of product text(1000) N N
regPrice Regular price float N N
salePrice Sale price float N N
Uuid UUID text(256) Y Y
sku Product SKU text(256) Y Y
type product or content text(50) Y Y

IGO_PRODUCTATTRIBS

FieldName Description and Comments Type and Length Required PK
AttribName Name of attribute of name and value pair text(1000) N N
AttribValue Value of attribute name and value pair text(1000) N N
sku Product Sku text(256) Y N

IGO_VIEWS

FieldName Description and Comments Type and Length Required PK
sku sku text(256) N N
user_id User Id text(256) Y Y
session_id User Id text(256) N N
Search Search Term text(1000) N N
Timestamp Timestamp text(datetime) Y Y

IGO_PURCHASES

FieldName Description and Comments Type and Length Required PK
Sku sku text(256) Y Y
Price price float N N
Quantity Quantity int N N
order_number Order Number text(256) N N
Discount Discount float N N
user_id User ID text(256) Y Y
Timestamp Timestamp text(datetime) Y Y

IGO_PROFILES

FieldName Description & Comments Type&Length Required PK
user_id User ID text(256) Y Y
subscriber_key Subscriber Key text(256) N N
Value_1 Tag 1 of top five text(256) N N
Value_2 Tag 2 of top five text(256) N N
Value_3 Tag 3 of top five text(256) N N
Value_4 Tag 4 of top five text(256) N N
Value_5 Tag 5 of top five text(256) N N
Attribute_1 Attribute 1 of top five text(256) N N
Attribute_2 Attribute 2 of top five text(256) N N
Attribute_3 Attribute 3 of top five text(256) N N
Attribute_4 Attribute 4 of top five text(256) N N
Attribute_5 Attribute 5 of top five text(256) N N
 
Laddar
Salesforce Help | Article