All Viewtracker data is stored in the Confluence database.
Viewtracker Data Structure
Table name: AO_05769A_VISIT_ENTITY
|
Column |
Data Type |
Description |
|---|---|---|
|
CONTENT_ID |
BIGINT |
The ID of the tracked page. |
|
ID |
INTEGER |
The individual ID of the view (Primary Key). |
|
PROTECTED_USER |
BOOLEAN |
TRUE = Extended Privacy Mode is enabled. The page viewer is a Confluence user (not anonymous access ). NULL = Extended Privacy Mode is disabled. |
|
USER_KEY |
VARCHAR(255) |
The tracked user's key and only filled if Extended Privacy Mode is disabled. In the Extended Privacy Mode, no user data is stored. |
|
VISIT_TIME |
DATETIME |
The timestamp of the view. |
|
DEVICE_TYPE |
INTEGER |
The device type ( source ) from which the view originated.
|
see also: Data collection and storage in Viewtracker
Attachment Tracking Data Structure
Table name: AO_F117EB_ATTACHMENT_VIEWS
|
Column |
Data Type |
Description |
|---|---|---|
|
ATTACHMENT_ID |
BIGINT |
ID of the attachment |
|
CONTENT_ID |
BIGINT |
ID of the content that the attachment is attached to. |
|
ID |
INTEGER |
The primary key of the table (auto-increment). |
|
PROTECTED_USER |
BOOLEAN |
A flag that indicates whether the user viewed the attachment in Extended Privacy Mode . TRUE = Extended Privacy Mode is enabled. The attachment viewer is a Confluence user (not anonymous access ). NULL = Extended Privacy Mode is disabled. |
|
USER_KEY |
VARCHAR(255) |
The tracked user's key. Only filled in if Extended Privacy Mode is disabled. |
|
VIEW_TIME |
TIMESTAMP |
The time when the attachment view was generated. |
Search Analytics Data Structure
Table name: AO_075EEE_SEARCH
|
Column |
Data Type |
Description |
|---|---|---|
|
ID |
INTEGER |
The primary key of the table (auto-increment). |
|
NUMBER_OF_RESULTS |
INTEGER |
The number of search results returned by the Confluence Search API. For an unsuccessful search, it’s 0. |
|
PROTECTED_USER |
BOOLEAN |
A flag that indicates whether the user performed a search in Extended Privacy Mode . TRUE = Extended Privacy Mode is enabled. The searcher is a Confluence user (not anonymous access ). NULL = Extended Privacy Mode is disabled. |
|
SEARCH_DATE |
TIMESTAMP |
The time when the search action was performed. |
|
SEARCH_PLACE |
INTEGER |
The place where the search was performed.
|
|
SEARCH_TERM |
VARCHAR(255) |
The input from the user that was used for search. |
|
USER |
VARCHAR(255) |
The tracked user's key. Only filled in if Extended Privacy Mode is disabled. |
Viewtracker also interacts with other tables. To see a complete list, visit this article: