Tealeaf publishes a set of views in the Visitor Reporting database to facilitate custom reports and queries against the data. These views will be maintained in future releases regardless of underlying schema changes.
Important: It is strongly recommended that any custom reports or queries reference the views and avoid directly referencing the underlying tables.
View Name | Description |
---|---|
VW_DATASET |
Lists the current segments in the database along with their sessions and a count of how many times each session matched the search terms. |
VW_EVENT |
Returns the list of all regular event occurrences for sessions currently in the database. |
VW_NUMERIC_EVENT |
Returns the list of all numeric event occurrences for sessions currently in the database. |
VW_REPORTS |
Returns the list of defined visitor report types. Any report added using the steps for creating a custom report should appear in this view. |
VW_SESSION |
Returns the list of sessions currently contained in the Visitor database. |
VW_SESSION_ATTRIBUTE |
Returns session attribute data. |
VW_SESSION_EVENT |
Returns the same list of sessions as VW_SESSION with the addition of a comma separated list of event UNIQUE_ID values. This view is less efficient than VW_SESSION and should only be used when the event list is required. |
VW_VISITOR |
Returns data on the list of visitors in the database. |
VW_VISITOR_STATISTICS |
Returns database wide statistics grouped in hour intervals. |