Data Structure of the Viewtracker app

 


All Viewtracker data is stored in the Confluence database.

Viewtracker Data Structure

Table name: AO_05769A_VISIT_ENTITY

Column

Data Type

Description

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. 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.

SOURCE

INTEGER

The device type the view was coming from.

  • 0 = Desktop

  • 1 = Mobile

  • 2 = Confluence Mobile App

  • 3 = Linchpin Mobile App

  • 4 = Jira Service Management (JSM)


see also: Data collection and storage in Viewtracker


 

Attachment Tracking Data Structure




Search Analytics Data Structure