Content of the TELEMETRY database

TELEMETRY is an internal dynamically generated database that holds daily statistics on user activity.

Each record in the database represents aggregated daily usage KPIs and user-level metrics for each account registered on the server.

Specifics and limitations

TELEMETRY is a database in DataTile that can be shared, used for calculations, and used to build dashboards and usage reports. However, there are several limitations to keep in mind:

Data is only stored for 180 days.
TELEMETRY is automatically regenerated daily, and all past data is fully reloaded.
It is not possible to manually reload TELEMETRY with an external dataset.
If variable or category labels are changed, they will be reverted to their default values during the next reload job.

This database aggregates content locally. It is for internal use and not transferred in any form outside the server itself.

Content of the TELEMETRY database

ID	Label	Description
ACCOUNT_EMAIL	Username	Email
ACCOUNT_FIRST_NAME	First name	First name of the user
ACCOUNT_LAST_NAME	Last name	Last name of the user
ACCOUNT_STATE	Account state	State of the account. It is not related to the actual activity of the account. Active: valid account Blocked: the account has been blocked by a Supervisor, user cannot log in to the system Invited: the user has been invited but not registered or admitted to the system yet Moderation: the account is pending approval by a Supervisor to access the server. Deleted: the account has been deleted by a Supervisor and is pending its complete removal from the server.
DATE	Date
YEAR	Year
QUARTER	Quarter
MONTH	Month
SESSION_DURATION	Session duration	The total duration of all user sessions during the day in minutes
SERVER_LOAD_TIME	Server load time	The total processing time of the user's requests during the day
IO_BYTES	query IO: read kB	The total IO in Kb related to the user's activity on the server during the day
PROJECT_SIZE	Database size	The sum of sizes of all databases owned by the user
COLLABORATOR_COUNT	Collaborator count	The number of collaborators attached to all user's entities
BROWSER_NAME	Browser: name	The browser that the user uses while working with the server (e.g. Chrome, Firefox, etc.)
BROWSER_ VERSION	Browser: version	The version of the user's browser
ACCOUNT_ DOMAIN	Domain	Domain of the user's email (everything that follows @)
SESSIONS_ COUNT	Sessions count	The number of user sessions during the day
USER_ROLES	User Roles	System roles that were possessed by the user during the day
ENTITY_COUNT_ DASHBOARD	Dashboard count	Number of dashboards owned by the user
ENTITY_COUNT_ REPORT	Report count	Number of reports owned by the user
ENTITY_COUNT_ ENCODER	Text refiner project count	Number of Text Refiner entities owned by the user
ENTITY_COUNT_ DICTIONARY	Text refiner dictionary count	Number of Text Refiner Dictionaries owned by the user
ENTITY_COUNT_ DATABASE	Database count	Number of Databases owned by the user
ENTITY_COUNT_ FOLDER	Folder count	Number of Folders owned by the user
ENTITY_COUNT_ ATTACHMENT	Attachment count	Number of various attachments and files owned by the user
ENTITY_COUNT_ POINTER	Pointer count	Legacy KPI, it will be removed in the future
ENTITY_COUNT_ CHART	Chart count	Number of Chart Entities owned by the user
GROUP_NAME	Team	The team that the user belongs to by the end of the day
ACTIVE_DURING_DAY	Active during the day	Whether the user interacted with the server during the day
QUERY_EXECUTED	Query executed, times	Number of calculation requests made by the user during the day
ENTITY_COUNT_ PORTAL	Portal count	Number of Portal entities owned by the user
ENTITY_COUNT_ EXECUTION	Execution count	Number of processing jobs initiated on behalf of the user via API
ENTITY_COUNT_ TRANSFORMER	Transformer count	Number of Transformer entities owned by the user
ENTITY_COUNT_ COSTTABLE	Cost table count	Number of Cost table entities owned by the user