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
- daily_application_summary
- daily_user_summary
- user_group_core_activity
- premium_user_groups
- group_goals
- events
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 |
There are three main activity type classifications ''Application', 'Site', and 'Search' |
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 |
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 |
There are three activity type classifications: application, site, search |
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_minutes_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_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_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 |
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 wellbeing. 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 |
user_group_core_activity
column_name | data_type | Plans | Description |
row_id | INT64 | Professional/Premium | Unique identifier for each row |
account_id | INT64 | Professional/Premium | The ActivTrak account number |
group_id | INT64 | Professional/Premium | Shows each group that has been configured with core categories |
activity_id | INT64 | Professional/Premium | Shows a list of all category_ids configured as 'Core' Categories per team |
premium_user_groups
column_name | data_type | Plans | Description |
account_id | INTEGER |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
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 |
system_user_name |
STRING | Essentials/Advanced Essentials Plus Professional/Premium |
Assigned by the OS for the logged-in user |
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 |
is_primary_group |
BOOLEAN | Essentials/Advanced Essentials Plus Professional/Premium |
Indicator of primary group |
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”) |
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 |
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. |
events
column_name | data_type | Plans | Description |
accountid | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
The ActivTrak account number |
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 actions here. |
alarm_email_action | INT64 |
Essentials/Advanced Essentials Plus Professional/Premium |
Activity with email 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 actions here. |
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 categories here. |
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 |
Sunday - Saturday |
day_type | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
Weekend / Weekday |
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 |
local_datetime | DATETIME |
Essentials/Advanced Essentials Plus Professional/Premium |
Time converted based on configured application Time Zone |
local_time | TIME |
Essentials/Advanced Essentials Plus Professional/Premium |
Time only with Time Zone conversion |
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 |
Day period classification: Morning, Afternoon, Night & Overnight values |
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 |
Internal ID representing a timezone |
timezonestring | STRING |
Essentials/Advanced Essentials Plus Professional/Premium |
The actual timezone string, Ex: “US/Central” |
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 |
For additional assistance with ActivConnect, please reach out to ActivTrak Support.