Usage Analytics

Overview

As part of the AlphaSense product installation, we provide a usage analytics data stored in MySQL table

Accessing data

Data stored in MySQL database:

DB name : pc_usage_data
Table name : pc_user_usage_metrics

Table schema

{'name': 'login_name', 'type': String(255), 'nullable': False},
{'name': 'event_date', 'type': Date, 'nullable': False},
{'name': 'user_logins', 'type': String(10), 'nullable': True, 'default': 'No'},
{'name': 'page_read_internal_content_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'page_read_external_content_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'dashboard_created_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'search_queries_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'gensearches_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'internal_content_gensearches_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'annotation_created_count', 'type': Integer, 'nullable': True, 'default': 0},
{'name': 'inserted_timestamp', 'type': TIMESTAMP, 'nullable': False}

To fetch the data from the table use

SELECT * from pc_user_usage_metrics;