Review the data model for the Marketing Cloud Engagement data extensions used in the Predictive Intelligence Content dimension package.
PI_CONTENT
| Field Name | Description | Type and Length | Required | Primary Key |
|---|---|---|---|---|
| content_id | Content ID | text(256) | Y | N |
| availability | Indicates live content | bool | N | N |
| title | Title | text(1000) | N | N |
| uuid | UUID | text(256) | Y | Y |
PI_CONTENTATTRIBS
| Field Name | Description | Type and Length | Required | Primary Key |
|---|---|---|---|---|
| content_id | Content ID | text(256) | Y | N |
| AttribName | Name of attribute in name and value pair | text(1000) | N | N |
| AttribValue | Value of attribute in name and value pair | text(1000) | N | N |
PI_CONTENTVIEWS
| Field Name | Description and Comments | Type and Length | Required | Primary Key |
|---|---|---|---|---|
| content_id | Content ID | text(256) | N | N |
| user_id | User ID | text(256) | Y | Y |
| session_id | Session ID | text(256) | N | N |
| search | Search Term | text(1000) | N | N |
| timestamp | Timestamp | text(date/time) | Y | Y |