Skip to main content
Skip table of contents

How does the Viewtracker app store page view data?

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. 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 (source) the view was coming from.

  • 0 = Desktop

  • 1 = Mobile

  • 2 = Confluence Mobile App

  • 3 = Linchpin Mobile App

  • 4 = Jira Service Management (JSM)

  • 5 = Scroll Viewport


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.

  • 0 = Confluence UI

  • 1 = unknown

  • 2 = Jira Service Management (JSM)

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.