Webtrends Event Types for Universal Behaviors and Relational Tables

To map database columns, you need to know the Webtrends event types and their columns and data types.

Map to Database: DBID=19988

Match Columns:
Email --> Email
Custom --> Account ID
Custom --> Customer ID
Custom --> Loyalty ID

top | Webtrends Abandoned Item - Event Type Code: 1

Indexed Attributes
Stream Name
Product Category
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Product Name Text
Product Category Text
Mobile Visit Text
Device Type Text
Device OS Text
Screen Size Text
Geo City Text
Geo Country Text
Geo Zip Text
Date Timestamp

top | Webtrends Abandoned Cart - Event Type Code: 25

Indexed Attributes
Stream Name
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Cart ID Text
Cart Name Text
Date Timestamp

top | Webtrends Purchase - Event Type Code: 2

Indexed Attributes
Stream Name
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Cart ID Text
Cart Name Text
Date Timestamp

top | Webtrends Visited Site - Event Type Code: 3

Indexed Attributes
Stream Name
Content Group
Content Subgroup
Page Title
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Landing URL Text
Mobile Visit Text
Social Visit Text
Social Network Text
Device Type Text (for example, tablet or smartphone)
Device OS Text (for example, iOS, Android, or RIM)
Screen Size Text (for example, 720x450)
Content Group Text
Content Sub Group Text
Time on the Site Numeric
Page Title Text
Page URL Text
Geo City Text
Geo Country Text
Geo Zip Text

top | Webtrends Searched Site - Event Type Code: 4

Indexed Attributes
Stream Name
Search Terms
Site Name
Onsite Search Terms
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Mobile Visit Text
Device Type Text (for example, tablet or smartphone)
Device OS Text (for example, iOS, Android, or RIM)
Screen Size Text (for example, 720x450)
Search Type Text (for example, onsite or search engine)
Search Engine Text (for example, Google, Yahoo, or Bing)
Search Terms Text (comma-delimited list)
Onsite Search Terms Text
Site Name Text
Geo City Text
Geo Country Text
Geo Zip Text

top | Webtrends Abandoned Goal - Event Type Code: 5

Indexed Attributes
Stream Name
Goal Name
Category
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Goal Name Text
Category Text
Goal ID Text
Mobile Visit Text
Device Type Text (for example, tablet or smartphone)
Device OS Text (for example, iOS, Android, or RIM)
Screen Size Text (for example, 720x450)
Geo City Text
Geo Country Text
Geo Zip Text

top | Webtrends Completed Goal - Event Type Code: 6

Indexed Attributes
Stream Name
Goal Name
Category
Column Data Type
Email Text
Social Id Text
Visitor Id Text
Custom Id 1 Text
Custom Id 2 Text
Custom Id 3 Text
Stream Name Text
Goal Name Text
Category Text
Goal ID Text
Mobile Visit Text
Device Type Text (for example, tablet or smartphone)
Device OS Text (for example, iOS, Android, or RIM)
Screen Size Text (for example, 720x450)
Geo City Text
Geo Country Text
Geo Zip Text