The ActivConnect API allows you to access your ActivTrak data in hundreds of external applications.
Click on a view type below to see an alphabetized list of the different data fields found within each ActivConnect view, including the data type, a short description and which subscription plan(s) include them.
Contents
- consumer_groups
- consumers
- daily_application_summary
- daily_group_benchmarks
- daily_user_summary
- events
- group_goals
- hourly_offline_meeting_summary
- premium_computer_groups
- premium_user_groups
- user_group_core_activity
- user_work_schedules
- users
consumer_groups
| column_name | data_type | Plans | Description |
|---|---|---|---|
| row_id | INT64 |
Essentials/Advanced |
Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 |
Essentials/Advanced |
The ActivTrak account number |
| activtrak_id | INT64 |
Essentials/Advanced |
Unique ID for the application user. These users can be viewed under Settings > Access > App Access |
| group_id | INT64 |
Essentials/Advanced |
Viewable Groups to which the application user has access; Admin/Configurator roles have access to all groups |
|
etl_insert _datetime |
TIMESTAMP |
Essentials/Advanced |
Date and time row was inserted in this table |
|
etl_last_ update_datetime |
TIMESTAMP |
Essentials/Advanced |
Date and time row was last updated in this table |
consumers
| column_name | data_type | Plans | Description |
|---|---|---|---|
| row_id | INT64 |
Essentials/Advanced |
Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 |
Essentials/Advanced |
The ActivTrak account number |
| activtrak_id | INT64 |
Essentials/Advanced |
Unique ID for the application user. These users can be viewed under Settings > Access > App Access |
| STRING |
Essentials/Advanced |
Email address used by application users to log in to the ActivTrak application | |
| roles | STRING |
Essentials/Advanced |
Role assigned to the application user: Admin, Configurator, Power User, Viewer |
|
etl_insert _datetime |
TIMESTAMP |
Essentials/Advanced |
Date and time row was inserted in this table |
|
etl_last_ update_datetime |
TIMESTAMP |
Essentials/Advanced |
Date and time row was last updated in this table |
daily_application_summary
| column_name | data_type | Plans | Description |
|---|---|---|---|
| accountid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
| active_day_count | INT64 | Professional/Premium | Active Days are days on which a user has met the minimum number of productive hours per day for it to be considered a work day. They are used to calculate averages, such as average productive hours per day, when a user's productive hours are divided by the number of Active Days in a given time period. |
|
activity_alignment_ type |
STRING | Professional/Premium | Identifies if the activity is "Core" or "Non-Core" based on the user's primary group configuration for Activity Alignment. |
| activity_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
These are the main activity type classifications: 'Application', 'Site', 'Passive', 'Search', 'Offline Meeting' |
| activity_week | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
The first day of the week |
| application | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The cleaned executable name |
| application_or_site | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
A combination of Application and Site objects Note: Different from Application_Site, this column displays only the Site details for web applications |
| browser_site | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Applications with site or URL content ex: Google Chrome(slack.com) |
| category | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The activity category is classified in the ActivTrak application. Ex: Business Tools, Social Media. Learn more about activity categories here. |
| computer_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Computer ID |
| day_of_week | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Sunday - Saturday |
| day_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Weekend / Weekday |
| duration_seconds | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The activity duration in seconds |
| executable | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The name of the application running, usually in its raw format. Ex: Slack.exe |
|
first_activity_ datetime |
DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
Start of Day per user based on the first reported computer activity |
| host | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The extracted domain or domain with subdomain URL format. |
| local_date | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
Date only with Time Zone conversion |
| passive_type_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Identifies some subtypes of a passive status, like passive locked. Used to set a 0 duration seconds for activities that were deemed to be different from regular passive activities. |
| productivity | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
There are three productivity classifications: Productive, Unproductive, Undefined |
| time_off_day | Boolean |
Essentials/Advanced Essentials Plus Professional/Premium |
Day (partial or full) in which time off was approved for a user |
| user_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
ActivTrak User ID |
| user_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
If a user alias was defined in ActivTrak, this field will populate the user alias record. If not, a user record will be shown, matching the behavior in the ActivTrak app. Learn more about user aliases here. |
| website | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
There are three activity type classifications: application, site, search |
| app_or_site_consolidated_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Standardized application or website name used for reporting. Consolidates multiple technical variations (e.g., "Zoom.exe", "zoom.us") into a single clean name (e.g., "Zoom") to prevent duplicate entries in reports and provide accurate activity metrics |
| activity_count | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Number of times an application or website was used |
daily_group_benchmarks
| column_name | data_type | Plans | Description |
|---|---|---|---|
| active_day_count | INT64 | Professional/Premium | Number of user-days activated during a specific date |
| activity_date | DATE | Professional/Premium | Date only with Time Zone conversion |
|
focused_user_ count_top25 |
INT64 | Professional/Premium | Number of users in the top quartile based on their focused time during a specific date |
|
focused_seconds _all |
INT64 | Professional/Premium | Total focused time duration in seconds during a specific date |
|
focused_seconds _top25 |
INT64 | Professional/Premium | Total focused time duration in seconds for users in the top quartile during a specific date |
|
productive_seconds _all |
INT64 | Professional/Premium | Total productive time duration in seconds during a specific date |
|
productive_seconds _top25 |
INT64 | Professional/Premium | Total productive time duration in seconds for users in the top quartile during a specific date |
|
productive_user_ count_top25 |
INT64 | Professional/Premium | Number of users in the top quartile based on their productive time during a specific date |
|
time_off_ day_count |
INT64 | Professional/Premium | Number of user-days in which time off (partial day or full day) was approved during a specific date |
| total_user_count | INT64 | Professional/Premium | Number of monitored users in the account during a specific date |
daily_user_summary
| column_name | data_type | Plans | Description |
|---|---|---|---|
| accountid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
|
active_day_ count |
INT64 |
Essentials Plus Professional/Premium |
Active Days are days on which a user has met the minimum number of productive hours per day for it to be considered a work day. They are used to calculate averages, such as average productive hours per day, when a user's productive hours are divided by the number of Active Days in a given time period. |
|
active_duration_ seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time reported by the end user's computer (screen time) excluding Passive Time. Learn more about passive time settings here. |
| activity_week | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
The first day of the week |
|
attention_shift_ activity_count |
INT64 | Professional/Premium |
An Attention Shift represents the number of occurrences in which
a user exceeds the maximum threshold set for switching between
productive
applications/sites or screens within a minute Note: Switching from a productive to an unproductive activity will also be an attention shift in the first occurrence. Example based on distinct application/site: Switching between Email, PowerPoint and Slack within one minute. Example based on distinct screens: Opening 4+ unique PowerPoint presentations or 5+ unique Word documents within 1 minute Default thresholds: Application / Sites = 2 Screen Views = 4 The thresholds are configurable in Analytics > Settings |
| break_count | INT64 | Professional/Premium | The number of breaks (off-screen time) a user takes throughout the day. This is calculated by counting the number of times a user's computer is inactive for more than 5 consecutive minutes |
|
break_duration_ seconds |
INT64 | Professional/Premium | The break time (off-screen time) in seconds throughout the day |
|
collaboration_ activity_count |
INT64 | Professional/Premium | The number of collaboration activity occurrences per user per day |
|
collaboration_ duration_seconds |
INT64 | Professional/Premium | Collaboration is considered the working time in which an employee is engaged with others to coach, assign, align, brainstorm, socialize, and problem-solve. These activities are usually performed through Chat & Messaging or Meeting Software |
|
core_duration_ seconds |
INT64 | Professional/Premium | Time spent in productive Core applications/sites based on the user's primary group configuration for Activity Alignment (includes active and passive time) |
| day_of_week | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Sunday - Saturday |
| day_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Weekend / Weekday |
|
first_activity_ datetime |
DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
The start of the day per user based on the first reported computer activity |
|
first_activity_ minutes_in_day |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The start of the day in INTEGER format per user based on the first reported computer activity |
|
focused_duration_ seconds |
INT64 | Professional/Premium | Working time in which an employee is engaged and working on a single task for an extended period of time without disruption or completing multi-tasking activities (also called attention shifts) |
|
focused_session_ count |
INT64 | Professional/Premium |
A count of uninterrupted, focused time sessions Note: An uninterrupted focus session is defined as any continuous series of logs on a single task that is not less than one minute |
|
focused_session_ duration_seconds |
INT64 | Professional/Premium | Focused Session Duration Seconds reflects the total amount of time employees operate without distractions or multitasking. It is calculated by adding up the time of each focused session |
|
last_activity_ datetime |
DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
The end of day per user based on the last reported computer activity |
|
last_activity_ inutes_in_day |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The end of day in INTEGER format per user based on the last reported computer activity. |
| local_date | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
Date only with Time Zone conversion |
| location | STRING | Professional/Premium |
Location is based on where a user spends the majority of their
time
each day by looking at the anonymized "network signature" (public
IP address + unique WiFi identifiers) where an activity takes
place
There are three location categories:
Remote, Office, Office/Remote Learn more about Location here. |
|
multitasking_ duration_seconds |
INT64 | Professional/Premium |
Multi-tasking activity performed within productive applications
consists
of general administrative business tasks while an attention shift
event is happening Note: Each Attention Shift event captures the time of these activities for the next 3 minutes (attention residue), capping the last activity to 60 seconds max. Excludes: Activities classified as Chat & Messaging or Meeting Software. See Attention Shifts for more details. |
|
non_business_ activity_count |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The number of occurrences per user per day of non-business activities (unproductive and undefined) |
|
non_business_activity_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Non-Business Hours/Day reflects the average hours in a day when an employee engages in unproductive or undefined activities. More about activity classification here. |
|
non_core_ duration_seconds |
INT64 | Professional/Premium | Time spent in productive Non-Core applications/sites based on the user's primary group configuration for Activity Alignment (includes active and passive time) |
|
offline_meeting_ duration_seconds |
INT64 |
Essentials Plus Professional/Premium |
Offline Meeting time
is when an employee is not online, qualifying activity from an
employee's
calendar is used as an additional data source to fill in the
"blank
spaces" in digital activity with time spent in meetings. Note: The calendar integration must be enabled. |
|
productive_active_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time in applications classified as Productive or sites excluding Passive Time |
|
productive_active_ duration_seconds_ in_schedule |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time in applications classified as Productive or sites excluding Passive Time during the user work schedule |
|
productive_activity_ count |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The number of productive activity occurrences per user per day |
|
productive_passive_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time in applications classified as Productive or sites excluding Active Time |
|
productive_passive_ duration_seconds_ in_schedule |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time in applications classified as Productive or sites excluding Active Time during the user work schedule |
|
productive_session_ count |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
A count of uninterrupted productive time sessions. Note: An uninterrupted productive session is defined as any continuous series of logs in Productive Applications or Sites that are not less than 1 minute |
|
productive_session_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Productivity Sessions Duration Seconds reflect the total amount of time users operate without unproductive disruption. This is calculated by adding up the time of each productive session |
|
time_off_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Total approved time off in seconds for a user on a given day |
| time_off_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Type of approved time off for a user on a given day (e.g., vacation, sick leave) |
| time_off_day | Boolean |
Essentials/Advanced Essentials Plus Professional/Premium |
Day (partial or full) in which time off was approved for a user |
| total_activity_count | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The total activity count per user per day across all productivity classifications |
|
total_duration_ seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time reported by the end user's computer (Active and Passive) (screen time). |
|
undefined_active_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Undefined is used for applications or sites that haven't been classified as Productive or Unproductive. This field displays the amount of time in unclassified activities, excluding Passive Time |
|
undefined_activity_ count |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The number of undefined activity occurrences per user per day |
|
undefined_passive_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Undefined is used for applications or sites that haven't been classified as Productive or Unproductive. This field displays the amount of time spent in unclassified activities, excluding Passive Time |
|
unproductive_active_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time spent in Unproductive applications or sites, excluding Active Time |
|
unproductive_activity_ count |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The number of unproductive activity occurrences per user per day |
|
unproductive_passive_ duration_seconds |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of time spent in Unproductive applications or sites, excluding Passive Time |
| user_focus_goal | NUMERIC | Professional/Premium |
The goal is set for focused hours per day.
Default value: 3.0 hrs The default value can be customized by team in Insights > Benchmarks and Goals. Learn more about benchmarks and goals here. |
| user_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
ActivTrak User ID |
| user_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
If a user alias was defined in ActivTrak, this field will populate the user alias record. Otherwise, a user record will be shown, matching the behavior in the ActivTrak app. Learn more about user aliases here. |
|
user_productivity_ goal |
NUMERIC |
Essentials Plus Professional/Premium |
The goal is set for productive hours per day.
Default value: 6.0 hrs The default value can be customized by team in Insights > Benchmarks and Goals Learn more about benchmarks and goals here |
| utilization_level | STRING | Professional/Premium |
A measure of employee engagement and well-being. Users are labeled
as Healthy, Overutilized or
Underutilized based on their average Productive
Hrs/Day relative to the Productive Hrs/Day Goal set for their
team: Healthy: Productive Hrs/Day are within 30% (+/-) of the Productive Hrs/Day Goal Overutilized: Productive Hrs/Day are at least 31% higher than the Productive Hrs/Day Goal Underutilized: Productive Hrs/Day are at least 31% lower than the Productive Hrs/Day Goal |
events
| column_name | data_type | Plans | Description |
|---|---|---|---|
| accountid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
| account_datetime | DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
All activity timestamps converted to the account time zone. Always populated regardless of time zone configuration. |
| active_state | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
A user's activity level: Active: Using keyboard/mouse Passive: Not using keyboard/mouse Passive Locked: The computer is locked/asleep; filtered by default Learn more about passive time settings here. |
| activity_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
There are three main activity type classifications: Application, Site, Search |
| activity_week | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
The first day of the week |
| alarm_action | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
An additional column to 'Alarms_Triggered,' it's categorized
with the type of alarm action configured Ex: 'Email,' 'Popup,' 'Screenshot,' 'Terminate,' 'Webhook' Learn more about alarm actionshere. |
| alarm_email_action | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with email triggered from configured alarm actions |
| alarm_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Name of alarm triggered from configured alarm actions |
| alarm_popup_action | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with pop triggered from configured alarm actions |
|
alarm_screenshot_ action |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with screenshot triggered from configured alarm actions |
|
alarm_terminate_ action |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with terminate action triggered from configured alarm actions |
|
alarm_webhook_ action |
INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with webhook action triggered from
configured alarm actions Learn more about alarm actionshere. |
| alarms_triggered | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
1 or 0 value: Events associated with alarms will return a 1 |
|
app_site_ approval_status |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Application / Site approval status based on its productivity
classification Unapproved = Uncategorized and/or Undefined Approved = Categorized and defined |
| application | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The cleaned executable name |
| application_or_site | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Note: Different from Application_Site, this column displays only the Site details for web applications |
| browser_site | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Applications with site or URL content Ex: Google Chrome(slack.com) |
| category | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The activity category classified in the ActivTrak application Ex: Business Tools, Social Media. Learn more about activity categorieshere. |
| clean_url | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The URL strings after 'https://,' 'http://' and "www." |
| computer_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Computer ID |
| computer_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The managed computer name |
| dataset_version | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The version number of the table schema so you can easily track any new field changes |
| day_of_week | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Day of week derived from converted time zone (account or user) |
| day_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Day type derived from converted time zone (account or user) |
| device_ip | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Managed device LAN IP |
| duration_sec | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity duration in seconds |
| executable | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The name of the app running is usually in its raw format. Ex: Slack.exe |
| full_url | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The full, unfiltered URL |
| local_date | DATE |
Essentials/Advanced Essentials Plus Professional/Premium |
Date only with Time Zone conversion (account or user) |
| local_datetime | DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
Time converted based on configured application Time Zone (account or user) |
| local_time | TIME |
Essentials/Advanced Essentials Plus Professional/Premium |
Time only with Time Zone conversion (account or user) |
| logon_domain | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Active Directory domain-attached computers will show the domain name here. If not attached to a domain, the computername will be shown based on the operating system. Mac devices usually show computername and Google Chrome will not show anything. |
| period_of_day | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Period of day derived from converted time zone (account or user) |
|
potential_file_ transfer |
BOOL |
Essentials/Advanced Essentials Plus Professional/Premium |
Flags activities involving the following objects: OneDrive, DropBox, FTP, SFTP, and USB file transfer activities |
| primary_domain | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
It is often the same as the local system name, though not always. If the computer is attached to an Active Directory domain, that domain name will show up here based on the operating system. If not, it's typical for Windows machines to use "WORKGROUPS", Chrome to use "Google". Mac devices typically don't show anything related to the primary domain. |
| productivity | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
There are 3 productivity classifications: Productive, Unproductive, Undefined |
| productivity_state | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
A combination of 'productivity' and 'active_state': Productive Active Productive Passive Unproductive Active Unproductive Passive Undefined Active Undefined Passive |
| public_ip | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Managed device WAN IP |
| search_term | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Displays the search terms entered by a user during search-related activities |
| site | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The extracted domain or domain with subdomain URL format |
| timezoneid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Nullified when user time zone is selected to avoid breaking existing account-level reporting |
| timezonestring | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The actual timezone string or user offset (e.g., "US/Central" or "UTC-5") |
| titlebar | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The name of the title bar of the active window |
| user | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Friendly user name. E.g. First Last. Comes from the operating system. |
| user_alias | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Comes from ActivTrak, not the operating system. User Aliases
are used to combine multiple user logins in ActivTrak graphs
and reports as well as provide a "friendly name" in case the
"userraw" and "user" fields are ambiguous Learn more about user aliases here. |
| user_id | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak User ID |
| user_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Simple login name. Often first initial, last name. Comes from the operating system |
| username | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Simple login name. Often first initial, last name. Comes from the operating system |
| utc_timestamp | TIMESTAMP |
Essentials/Advanced Essentials Plus Professional/Premium |
System activity DateTime in UTC time zone |
| week_of_year | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Week number in the year |
group_goals
| column_name | data_type | Plans | Description |
|---|---|---|---|
| core_activity_ hrs_day |
NUMERIC | Professional/Premium | Core Activity target in hours/day for configured groups. Calculated as percent of productive hrs/day goal × productive hrs_day goal. Only available for groups with core categories configured. |
hourly_offline_meeting_summary
| column_name | data_type | Plans | Description |
|---|---|---|---|
| row_id | INT64 |
Essentials/Advanced |
Unique, system-generated, and permanent identifier for a specific row in this view |
| start_time | DATETIME |
Essentials/Advanced |
Start date and time when offline meeting time started being recorded |
|
duration_ seconds_ in_hour |
INT64 |
Essentials/Advanced |
The offline meeting duration in seconds |
| user_id | INT64 |
Essentials/Advanced |
Unique, persistent User ID generated by ActivTrak. This is NOT the agent_id (or user_id in legacy tables), which refers to a specific user-device instance, but it is linked to each agent_id/user_id in this view. |
| user_name | STRING |
Essentials/Advanced |
If a user alias was defined in ActivTrak (or display name in the User page), this field will populate the user alias record. If not, a user record will be shown, matching the behavior in the ActivTrak app. Learn more about user aliases here. |
| group_id | INT64 |
Essentials/Advanced |
Unique ID for the user's primary group within ActivTrak |
| group_name | STRING |
Essentials/Advanced |
Human-readable name of the user’s primary group (e.g., "NY Office", "Marketing Team") |
|
calendar_ meetings |
STRING |
Essentials/Advanced |
Meeting name identified in the user calendar contributing to offline meeting time |
premium_computer_groups
| column_name | data_type | Plans | Description |
|---|---|---|---|
| row_id | INT64 | Professional/Premium | Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 | Professional/Premium | The ActivTrak account number |
| computer_id | INT64 | Professional/Premium | Computer ID |
| group_id | INT64 | Professional/Premium | Unique ID for the computer's group within ActivTrak |
| group_name | STRING | Professional/Premium | Human-readable name of the computer’s group |
| computer_name | STRING | Professional/Premium | The managed computer name |
| computer_alias | STRING | Professional/Premium | The name of the managed computer it appears in Activtrak reports when a different name is provided in the Computer Aliases page |
| etl_insert_datetime | TIMESTAMP | Professional/Premium | Date and time row was inserted in this table |
|
etl_last_update_ datetime |
TIMESTAMP | Professional/Premium | Date and time row was last updated in this table |
premium_user_groups
| column_name | data_type | Plans | Description |
|---|---|---|---|
| account_id | INTEGER |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
|
group_id |
INTEGER |
Essentials/Advanced Essentials Plus Professional/Premium |
Unique ID for each group within ActivTrak |
|
group_name |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Human-readable name of the group (e.g., "NY Office", "Marketing Team") |
|
is_primary_group |
BOOLEAN |
Essentials/Advanced Essentials Plus Professional/Premium |
Indicator of primary group |
|
system_user_name |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Assigned by the OS for the logged-in user |
|
type |
INTEGER |
Essentials/Advanced Essentials Plus Professional/Premium |
Indicates the source of the group configuration: 0 – Active Directory 1 – ActivTrak In-App Configuration 2 – Azure Active Directory 3 – HRDC |
|
user_alias |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Comes from ActivTrak, not the operating system. User Aliases
are used to combine multiple user logins in ActivTrak graphs
and reports as well as provide a "friendly name" in case the
"userraw" and "user" fields are ambiguous Learn more about user aliases here |
| user_id | INTEGER |
Essentials/Advanced Essentials Plus Professional/Premium |
ActivTrak User ID |
|
user_name |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
If a user alias was defined in ActivTrak, this field will populate
the user alias record. Otherwise, a user record will be shown,
matching the behavior in the ActivTrak app Learn more about user aliases here |
user_group_core_activity
| column_name | data_type | Plans | Description |
|---|---|---|---|
| account_id | INT64 | Professional/Premium | The ActivTrak account number |
| activity_id | INT64 | Professional/Premium | Shows a list of all category_ids configured as 'Core' Categories per team |
| group_id | INT64 | Professional/Premium | Shows each group that has been configured with core categories |
| row_id | INT64 | Professional/Premium | Unique identifier for each row |
user_work_schedules
| column_name | data_type | Plans | Description |
|---|---|---|---|
| break_time_minutes | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The amount of break time in minutes designated in a user's work schedule. |
| schedule_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The name of the work schedule assigned to a user. |
| schedule_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The type of work schedule assigned to a user. a) Flexible hours (no defined start or end time) or b) Non-Flexible hours (fixed start and end times). |
| uid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Unique, persistent User ID generated by ActivTrak. This is NOT the agent_id (or user_id in legacy tables), which refers to a specific user-device instance, but it is linked to each agent_id/user_id in this view. |
| user_name | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
If a user alias was defined in ActivTrak, this field will populate the user alias record. If not, a user record will be shown, matching the behavior in the ActivTrak app. Learn more about user aliases here. |
|
work_schedule.day_ of_week |
STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The workdays selected in a user's work schedule. |
|
work_schedule.start_time work_schedule.end_time |
TIME |
Essentials/Advanced Essentials Plus Professional/Premium |
The start and end time selected in a user's work schedule (for non-flex users). |
users
| column_name | data_type | Plans | Description |
|---|---|---|---|
| agents.agent_id | INTEGER |
Essentials/Advanced |
ActivTrak-assigned agent id (user_id in legacy reports). A user may have a different user agent for each login and/or device they use and may need to be aliased or merged to identify as belonging to the same user. |
| agents.logon_name | STRING |
Essentials/Advanced |
Logon domain portion of user's login to a device. |
| agents.user_name | STRING |
Essentials/Advanced |
Username portion of user's login to a device. |
| device_logins | STRING |
Essentials/Advanced |
Unique username + logon domain combinations detected from user across devices. |
| display_name | STRING |
Essentials/Advanced |
How the user will appear in reports. If blank, reports default to user's device login or other provided identifier. Admin can edit on either the Users page or User Alias page (legacy) or sync via integration. Learn more about Display Names & Aliases<.> |
| emails | STRING |
Essentials/Advanced |
Detected via user activity (if Email auto-detection enabled), defined by the admin on the Users page, or provided via integration. |
| employee_ids | STRING |
Essentials/Advanced |
Optional identifier defined by the admin on the Users page, or provided via integration. |
| tracked | BOOLEAN |
Essentials/Advanced |
Whether the user's activity is tracked (default) or blocked from uploading to our servers. Set tracking status on the Users page or Do Not Track page (legacy). Learn more about Tracking & DNT. |
| uid | INTEGER |
Essentials/Advanced |
Unique, persistent User ID generated by ActivTrak. This is NOT the agent_id (or user_id in legacy tables), which refers to a specific user-device instance, but it is linked to each agent_id/user_id in this view. |
| user_principal_names | STRING |
Essentials/Advanced |
UPNs are detected from email-formatted device logins, defined by the admin on the Users page, or provided via integration. |