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 |