The ActivConnect API (Add-on) 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 package(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 | Packages | Description |
|---|---|---|---|
| row_id | INT64 |
All packages |
Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 |
All packages |
The ActivTrak account number |
| activtrak_id | INT64 |
All packages |
Unique ID for the application user. These users can be viewed under Settings > Access > App Access |
| group_id | INT64 |
All packages |
Viewable Groups to which the application user has access; Admin/Configurator roles have access to all groups |
|
etl_insert _datetime |
TIMESTAMP |
All packages |
Date and time row was inserted in this table |
|
etl_last_ update_datetime |
TIMESTAMP |
All packages |
Date and time row was last updated in this table |
consumers
| column_name | data_type | Packages | Description |
|---|---|---|---|
| row_id | INT64 |
All packages |
Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 |
All packages |
The ActivTrak account number |
| activtrak_id | INT64 |
All packages |
Unique ID for the application user. These users can be viewed under Settings > Access > App Access |
| STRING |
All packages |
Email address used by application users to log in to the ActivTrak application | |
| roles | STRING |
All packages |
Role assigned to the application user: Admin, Configurator, Power User, Viewer |
|
etl_insert _datetime |
TIMESTAMP |
All packages |
Date and time row was inserted in this table |
|
etl_last_ update_datetime |
TIMESTAMP |
All packages |
Date and time row was last updated in this table |
daily_application_summary
| column_name | data_type | Packages | Description |
|---|---|---|---|
| accountid | INT64 | All packages | The ActivTrak account number |
| active_day_count | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Identifies if the activity is "Core" or "Non-Core" based on the user's primary group configuration for Activity Alignment. |
| activity_type | STRING | All packages | These are the main activity type classifications: 'Application', 'Site', 'Passive', 'Search', 'Offline Meeting' |
| activity_week | DATE | All packages | The first day of the week |
| application | STRING | All packages | The cleaned executable name |
| application_or_site | STRING | All packages |
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 | All packages | Applications with site or URL content ex: Google Chrome(slack.com) |
| category | STRING | All packages | The activity category is classified in the ActivTrak application. Ex: Business Tools, Social Media. Learn more about activity categories here. |
| computer_id | INT64 | All packages | Computer ID |
| day_of_week | STRING | All packages | Sunday - Saturday |
| day_type | STRING | All packages | Weekend / Weekday |
| duration_seconds | INT64 | All packages | The activity duration in seconds |
| executable | STRING | All packages | The name of the application running, usually in its raw format. Ex: Slack.exe |
|
first_activity_ datetime |
DATETIME | All packages | Start of Day per user based on the first reported computer activity |
| host | STRING | All packages | The extracted domain or domain with subdomain URL format. |
| local_date | DATE | All packages | Date only with Time Zone conversion |
| passive_type_id | INT64 | All packages | Identifies some subtypes of a passive status, like passive locked. Used to set a 0 duration second for activities that were deemed to be different from regular passive activities. |
| productivity | STRING | All packages | There are three productivity classifications: Productive, Unproductive, Undefined |
| time_off_day | Boolean | All packages | Day (partial or full) in which time off was approved for a user |
| user_id | INT64 | All packages | ActivTrak User ID |
| user_name | STRING | All packages | 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 | All packages | There are three activity type classifications: application, site, search |
|
app_or_site_ consolidated_name |
STRING | All packages | 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 | All packages | Number of times an application or website was used |
daily_group_benchmarks
| column_name | data_type | Packages | Description |
|---|---|---|---|
| active_day_count | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Number of user-days activated during a specific date |
| activity_date | DATE |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Date only with Time Zone conversion |
|
focused_user_ count_top25 |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Number of users in the top quartile based on their focused time during a specific date |
|
focused_seconds _all |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Total focused time duration in seconds during a specific date |
|
focused_seconds _top25 |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Total focused time duration in seconds for users in the top quartile during a specific date |
|
productive_seconds _all |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Total productive time duration in seconds during a specific date |
|
productive_seconds _top25 |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Total productive time duration in seconds for users in the top quartile during a specific date |
|
productive_user_ count_top25 |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Number of users in the top quartile based on their productive time during a specific date |
|
time_off_ day_count |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Number of user-days in which time off (partial day or full day) was approved during a specific date |
| total_user_count | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Number of monitored users in the account during a specific date |
daily_user_summary
| column_name | data_type | Packages | Description |
|---|---|---|---|
| accountid | INT64 | All packages | The ActivTrak account number |
|
active_day_ count |
INT64 |
Workforce Management Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | 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 | All packages | The first day of the week |
|
attention_shift_ activity_count |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
The break time (off-screen time) in seconds throughout the day |
|
collaboration_ activity_count |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
The number of collaboration activity occurrences per user per day |
|
collaboration_ duration_seconds |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | Sunday - Saturday |
| day_type | STRING | All packages | Weekend / Weekday |
|
first_activity_ datetime |
DATETIME | All packages | The start of the day per user based on the first reported computer activity |
|
first_activity_ minutes_in_day |
INT64 | All packages | The start of the day in INTEGER format per user based on the first reported computer activity |
|
focused_duration_ seconds |
INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | The end of day per user based on the last reported computer activity |
|
last_activity_ inutes_in_day |
INT64 | All packages | The end of day in INTEGER format per user based on the last reported computer activity. |
| local_date | DATE | All packages | Date only with Time Zone conversion |
| location | STRING |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | The number of occurrences per user per day of non-business activities (unproductive and undefined) |
|
non_business_activity_ duration_seconds |
INT64 | All packages | 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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Workforce Management Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | The amount of time in applications classified as Productive or sites excluding Passive Time |
|
productive_active_ duration_seconds_ in_schedule |
INT64 | All packages | The amount of time in applications classified as Productive or sites excluding Passive Time during the user work schedule |
|
productive_activity_ count |
INT64 | All packages | The number of productive activity occurrences per user per day |
|
productive_passive_ duration_seconds |
INT64 | All packages | The amount of time in applications classified as Productive or sites excluding Active Time |
|
productive_passive_ duration_seconds_ in_schedule |
INT64 | All packages | The amount of time in applications classified as Productive or sites excluding Active Time during the user work schedule |
|
productive_session_ count |
INT64 | All packages |
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 | All packages | 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 | All packages | Total approved time off in seconds for a user on a given day |
| time_off_type | STRING | All packages | Type of approved time off for a user on a given day (e.g., vacation, sick leave) |
| time_off_day | Boolean | All packages | Day (partial or full) in which time off was approved for a user |
| total_activity_count | INT64 | All packages | The total activity count per user per day across all productivity classifications |
|
total_duration_ seconds |
INT64 | All packages | The amount of time reported by the end user's computer (Active and Passive) (screen time). |
|
undefined_active_ duration_seconds |
INT64 | All packages | 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 | All packages | The number of undefined activity occurrences per user per day |
|
undefined_passive_ duration_seconds |
INT64 | All packages | 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 | All packages | The amount of time spent in Unproductive applications or sites, excluding Active Time |
|
unproductive_activity_ count |
INT64 | All packages | The number of unproductive activity occurrences per user per day |
|
unproductive_passive_ duration_seconds |
INT64 | All packages | The amount of time spent in Unproductive applications or sites, excluding Passive Time |
| user_focus_goal | NUMERIC |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | All packages | ActivTrak User ID |
| user_name | STRING | All packages | 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 |
Workforce Management Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | Packages | Description |
|---|---|---|---|
| accountid | INT64 | All packages | The ActivTrak account number |
| account_datetime | DATETIME | All packages | All activity timestamps converted to the account time zone. Always populated regardless of time zone configuration. |
| active_state | STRING | All packages |
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 | All packages | There are three main activity type classifications: Application, Site, Search |
| activity_week | DATE | All packages | The first day of the week |
| alarm_action | STRING | All packages |
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 | All packages | Activity with email triggered from configured alarm actions |
| alarm_name | STRING | All packages | Name of alarm triggered from configured alarm actions |
| alarm_popup_action | INT64 | All packages | Activity with pop triggered from configured alarm actions |
|
alarm_screenshot_ action |
INT64 | All packages | Activity with screenshot triggered from configured alarm actions |
|
alarm_terminate_ action |
INT64 | All packages | Activity with terminate action triggered from configured alarm actions |
|
alarm_webhook_ action |
INT64 | All packages |
Activity with webhook action triggered from
configured alarm actions Learn more about alarm actionshere. |
| alarms_triggered | INT64 | All packages | 1 or 0 value: Events associated with alarms will return a 1 |
|
app_site_ approval_status |
STRING | All packages |
Application / Site approval status based on its productivity
classification Unapproved = Uncategorized and/or Undefined Approved = Categorized and defined |
| application | STRING | All packages | The cleaned executable name |
| application_or_site | STRING | All packages | Note: Different from Application_Site, this column displays only the Site details for web applications |
| browser_site | STRING | All packages |
Applications with site or URL content Ex: Google Chrome(slack.com) |
| category | STRING | All packages |
The activity category classified in the ActivTrak application Ex: Business Tools, Social Media. Learn more about activity categories here. |
| clean_url | STRING | All packages | The URL strings after 'https://,' 'http://' and "www." |
| computer_id | INT64 | All packages | Computer ID |
| computer_name | STRING | All packages | The managed computer name |
| dataset_version | STRING | All packages | The version number of the table schema so you can easily track any new field changes |
| day_of_week | STRING | All packages | Day of week derived from converted time zone (account or user) |
| day_type | STRING | All packages | Day type derived from converted time zone (account or user) |
| device_ip | STRING | All packages | Managed device LAN IP |
| duration_sec | INT64 | All packages | Activity duration in seconds |
| executable | STRING | All packages | The name of the app running is usually in its raw format. Ex: Slack.exe |
| full_url | STRING | All packages | The full, unfiltered URL |
| local_date | DATE |
|
Date only with Time Zone conversion (account or user) |
| local_datetime | DATETIME | All packages | Time converted based on configured application Time Zone (account or user) |
| local_time | TIME | All packages | Time only with Time Zone conversion (account or user) |
| logon_domain | STRING | All packages | 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 | All packages | Period of day derived from converted time zone (account or user) |
|
potential_file_ transfer |
BOOL | All packages |
Flags activities involving the following objects: OneDrive, DropBox, FTP, SFTP, and USB file transfer activities |
| primary_domain | STRING | All packages | 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 | All packages |
There are 3 productivity classifications: Productive, Unproductive, Undefined |
| productivity_state | STRING | All packages |
A combination of 'productivity' and 'active_state': Productive Active Productive Passive Unproductive Active Unproductive Passive Undefined Active Undefined Passive |
| public_ip | STRING | All packages | Managed device WAN IP |
| search_term | STRING | All packages | Displays the search terms entered by a user during search-related activities |
| site | STRING | All packages | The extracted domain or domain with subdomain URL format |
| timezoneid | INT64 | All packages | Nullified when user time zone is selected to avoid breaking existing account-level reporting |
| timezonestring | STRING | All packages | The actual timezone string or user offset (e.g., "US/Central" or "UTC-5") |
| titlebar | STRING | All packages | The name of the title bar of the active window |
| user | STRING | All packages | Friendly username. E.g. First Last. Comes from the operating system. |
| user_alias | STRING | All packages |
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 | All packages | The ActivTrak User ID |
| user_name | STRING | All packages | Simple login name. Often first initial, last name. Comes from the operating system |
| username | STRING | All packages | Simple login name. Often first initial, last name. Comes from the operating system |
| utc_timestamp | TIMESTAMP | All packages | System activity DateTime in UTC time zone |
| week_of_year | INT64 | All packages | Week number in the year |
group_goals
| column_name | data_type | Packages | Description |
|---|---|---|---|
|
core_activity_ hrs_day |
NUMERIC |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 | Packages | Description |
|---|---|---|---|
| row_id | INT64 |
All packages |
Unique, system-generated, and permanent identifier for a specific row in this view |
| start_time | DATETIME |
All packages |
Start date and time when offline meeting time started being recorded |
|
duration_ seconds_ in_hour |
INT64 |
All packages |
The offline meeting duration in seconds |
| user_id | INT64 |
All packages |
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 |
All packages |
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 |
All packages |
Unique ID for the user's primary group within ActivTrak |
| group_name | STRING |
All packages |
Human-readable name of the user’s primary group (e.g., "NY Office", "Marketing Team") |
|
calendar_ meetings |
STRING |
All packages |
Meeting name identified in the user calendar contributing to offline meeting time |
premium_computer_groups
| column_name | data_type | Packages | Description |
|---|---|---|---|
| row_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Unique, system-generated, and permanent identifier for a specific row in this view |
| account_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
The ActivTrak account number |
| computer_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Computer ID |
| group_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Unique ID for the computer's group within ActivTrak |
| group_name | STRING |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Human-readable name of the computer’s group |
| computer_name | STRING |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
The managed computer name |
| computer_alias | STRING |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
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 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Date and time row was inserted in this table |
|
etl_last_update_ datetime |
TIMESTAMP |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Date and time row was last updated in this table |
premium_user_groups
| column_name | data_type | Packages | Description |
|---|---|---|---|
| account_id | INTEGER | All packages | The ActivTrak account number |
|
group_id |
INTEGER | All packages | Unique ID for each group within ActivTrak |
|
group_name |
STRING | All packages | Human-readable name of the group (e.g., "NY Office", "Marketing Team") |
|
is_primary_group |
BOOLEAN | All packages | Indicator of primary group |
|
system_user_name |
STRING | All packages | Assigned by the OS for the logged-in user |
|
type |
INTEGER | All packages |
Indicates the source of the group configuration: 0 – Active Directory 1 – ActivTrak In-App Configuration 2 – Azure Active Directory 3 – HRDC |
|
user_alias |
STRING | All packages |
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 | All packages | ActivTrak User ID |
|
user_name |
STRING | All packages |
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 | Packages | Description |
|---|---|---|---|
| account_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
The ActivTrak account number |
| activity_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Shows a list of all category_ids configured as 'Core' Categories per team |
| group_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Shows each group that has been configured with core categories |
| row_id | INT64 |
Productivity Optimization Workforce Management + Productivity Optimization Bundle |
Unique identifier for each row |
user_work_schedules
| column_name | data_type | Packages | Description |
|---|---|---|---|
| break_time_minutes | INT64 | All packages | The amount of break time in minutes designated in a user's work schedule. |
| schedule_name | STRING | All packages | The name of the work schedule assigned to a user. |
| schedule_type | STRING | All packages | 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 | All packages | 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 | All packages | 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 | All packages | The workdays selected in a user's work schedule. |
|
work_schedule.start_time work_schedule.end_time |
TIME | All packages | The start and end time selected in a user's work schedule (for non-flex users). |
users
| column_name | data_type | Packages | Description |
|---|---|---|---|
| agents.agent_id | INTEGER |
All packages |
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 |
All packages |
Logon domain portion of user's login to a device. |
| agents.user_name | STRING |
All packages |
Username portion of user's login to a device. |
| device_logins | STRING |
All packages |
Unique username + logon domain combinations detected from user across devices. |
| display_name | STRING |
All packages |
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. |
| emails | STRING |
All packages |
Detected via user activity (if Email auto-detection enabled), defined by the admin on the Users page, or provided via integration. |
| employee_ids | STRING |
All packages |
Optional identifier defined by the admin on the Users page, or provided via integration. |
| tracked | BOOLEAN |
All packages |
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). |
| uid | INTEGER |
All packages |
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 |
All packages |
UPNs are detected from email-formatted device logins, defined by the admin on the Users page, or provided via integration. |