ActivTrak For Tableau Setup Guide

ActivTrak Data Connect Overview

Data Connect provides customers direct access into user behavioral activity data to create personalized reports with business intelligence data visualization tools (e.g.Tableau, PowerBI, Looker, Google Data Studio) and data reporting tools (e.g. Google Sheets, Microsoft Excel).

ActivTrak’s Data Connect Tableau Template includes a combination of pre-built valuable metrics, reports, and dashboards to help you analyze how your organization works and jump-start the creation of your own customized reports.

 

Configuration

Prerequisites:

  • You will need the Google Cloud account you provided to ActivTrak support to access your ActivTrak Data Connect instance.
  • You need Tableau version 2020.2 and above to configure and edit ActivTrak’s Data Connect Tableau Analysis Template.

Follow the steps below to configure ActivTrak’s Data Connect Tableau Analysis Template.

  1. Download to your computer the “ActivTrak for Tableau.zip” file containing the Tableau Template workbook and supporting documentation from the Data Connect page within the ActivTrak application (Menu -> Data Connect).
  2. Open the workbook called “ActivTrak Tableau Template.twbx”
  3. You will be prompted to authenticate using your Google Cloud account. Please use the credentials sent from the Google Data Connect set up team [accountnumber@activtrak.us and temporary password] 

quick_start_guide_-_1.png

  1. A message will appear saying there was a problem connecting to the data source. This is because Tableau does not allow you to change the pre-built Data Source Connection before trying to log in.  Click “Yes” to edit the connection information.quick_start_guide_-_2.png
  2. Edit the ‘ActivTrak Data Source’ data source information within the Data Source Connection screen:quick_start_guide_-_3.png
    • Leave the billing project dropdown as is.
    • Select ‘your business name’ from the project dropdown. Select the dataset with your six-digit account number.
    • Select the ‘logs’ table within your dataset and drag and drop it on the right-hand side area on top of the existing ‘logs’ table to replace it.
    • Select the Connection on the top right as either “live” or “extract”. We suggest you use “extract” so you can save the data locally for faster performance.
  3. Click on the “Readme” tab at the bottom of the book so you can start accessing the pre-built dashboards
  4. Verify access to your data by looking at the “Activity Summary” report in the Readme tab. This should have a summary of data reflecting your organization.
  5. Configure the workbook parameters in the Readme tab. These parameters help you tailor the analysis to your organization's needs.
    • Time Zone: All activities in ActivTrak are recorded in UTC time. This parameter allows you to specify the time conversion to your organization’s primary time zone.
    • Inactive Agent Last Activity Threshold (Hours): specify the number of hours since the last reported activity on a ActivTrak agent before it is marked as non-reporting
    • Focused Time - Max Distinct Apps within minute: maximum number of distinct applications you can switch between within a minute before such minute is marked as ‘distracted’ time. The default value is 2 (user will be marked as distracted for that minute if switches between 3 different applications within a minute).
    • Focused Time - Max Distinct Screens within minute: maximum number of distinct screens you can switch between within a minute before such minute is marked as ‘distracted’ time. The default value is 4 (user will be marked as distracted for that minute if switches between 5 screens within a minute).
  6. Configure the "Reporting Group" Tableau group object to reflect which users belong to which teams. This will help you properly compare individuals to their peers
    • RightClick on “Reporting Group” dimension
    • Select Edit Group
    • Create new user groups and assign users to each user group
  7. (Optional) Configure the workbook global filters in the Readme tab. These filters help you tailor the analysis to your organization's needs.
    • Activity Type Filter: allows you to pick which activity types you want to analyze and which to exclude across all dashboards. The different activity types are: application, site, search and passive. By default, all activity types are selected as each dashboard can filter some types as needed.
    • Day Type Filter: allows you to include/exclude activities happening on weekdays and/or weekends. Default, both are selected.
    • Reporting Group Filter: allows you include/exclude activities for users that are part of certain groups. By default, all groups are included.
  8. Review the Analysis Overview and Data Dictionary sections of this document to familiarize yourself with the pre-built analysis.
  9. Use the pre-built dashboards/reports, customize existing reports and/or create your own reports.

 

Analysis Overview

This Tableau pre-built analysis template contains a set of predefined dimensions, measures, reports and dashboards making it easy to perform in-depth analysis of your organization's work patterns and jump-start the creation of your own customized reports. Each activity captured by ActivTrak has a rich set of associated fields and metrics that help provide content and additional information at the granular level or in aggregate. The pre-built dashboards and underlying reports are organized around four major analysis areas:

  • Activity & Application Usage
  • Productivity
  • Collaboration & Knowledge Management
  • Compliance & Risk Management

Key Definitions

  • Activity Type: captures major types of digital activity (application, site, search or passive).
  • Category: an app or site can be assigned a category (e.g. development, business application, etc. Categories denote the activity performed using an app or site.
  • Productivity: an app or site can be classified as productive, unproductive or undefined.
  • All Time or Duration: All time recorded.
  • Active Time: time where the computer is active (Total Time - Passive Time).
  • Productive Time: time spent on activities (apps and sites) marked as productive.
  • Focused Time: productive time where minimal distractions or context switches are observed (Productive Time - Distracted Time). By default, we identify a given minute as “distracted” when the user switches between three or more apps and five or more different screens. These thresholds are configurable through the "Focused Time" parameters on the right-hand pane.
  • Focus Score: Focused Time as a % of Active Time (Focused Time / Active Time).
  • Avg Hours / User / Day: normalizes the time captured by dividing the active hours analyzed by the number of users and days. This allows you to compare and trend changes without having to worry about skewed stats due to teams of different sizes, users on vacation, etc.

Using & Customizing the Dashboards

  • Each dashboard has a brief description and instructions on how to use the dashboard in the title.
  • Date Filters: This template uses relative date filters to analyze recent data and trends automatically. You can change these filters to fit your needs.
  • Trend Charts: All trend charts are configured to display week by week analysis to identify trends. However, you can customize these charts to perform analysis at other levels (e.g. daily, monthly, etc.)
  • Filtering Data: You can select one or more values on the filter controls within the right-hand pane of each dashboard to filter the analysis.

Data Dictionary

Type/Folder

Field Name

Type

Description

Source

Formula

Standard Metrics

% of Users

Measure

User count as a % of total users

Table Calculation

[Users]/TOTAL([Users])

Standard Metrics

Active Time

Measure

Active time expressed as hours, minutes and seconds

Calculation

STR(INT(SUM(IIF([Activity Type]<>'Passive',[Duration (sec)],NULL))/3600))

+ "h " +

IF INT(SUM(IIF([Activity Type]<>'Passive',[Duration (sec)],NULL))%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(SUM(IIF([Activity Type]<>'Unknown/Passive',[Duration (sec)],NULL))%3600/60))

+ "m " +

IF INT(SUM(IIF([Activity Type]<>'Passive',[Duration (sec)],NULL)) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(SUM(IIF([Activity Type]<>'Unknown/Passive',[Duration (sec)],NULL))%3600 %60))

+ "s"

Standard Metrics

Active Time (hr)

Measure

Time identified as active in hours

Calculation

SUM(

IF [Activity Type]<>'Passive' THEN

[Duration (hr)]

END

)

Standard Metrics

Active Time (min)

Measure

Time identified as active in minutes

Calculation

SUM(

IF [Activity Type]<>'Passive' THEN

[Duration (min)]

END

)

Standard Metrics

Active Time %

Measure

Active time as % of total time

Calculation

[Active Time (hr)]/[All Time (hr)]

Standard Dimensions

Activity Date

Dimension

Activity date in local time

Calculation

DATE([Activity Time])

Standard Dimensions

Activity Minute

Dimension

Activity minute in local time

Calculation

DATETRUNC('minute', [Activity Time])

Standard Dimensions

Activity Time

Dimension

Activity datetime in local time zone (configurable)

Calculation

DATEADD('hour',[UTC to Local Time Offset],[Activity Time (UTC)])

Standard Dimensions

Activity Time (UTC)

Dimension

System activity datetime

Data Source Field

time

Standard Dimensions

Activity Type

Dimension

Type of activity captured

Calculation

IF NOT [Is Passive Event?] THEN

IF ISNULL([Log Url]) THEN

'Application'

ELSE

IF CONTAINS(LOWER([Log Url]),[Search URL Term]) THEN

'Search'

ELSE

'Site'

END

END

ELSE

'Passive'

END

Global Filters

Activity Type Filter

Dimension

Type of activity captured. Field used for global filtering.

Calculation

[Activity Type]

Advanced Metrics

After Hours Time

Measure

Weekday after hours time

Calculation

IF ([Time of Day] = "Night" OR [Time of Day] = "Overnight") AND ([Day Type] = "Weekday") THEN

IFNULL([Duration (hr)],0)

ELSE

0

END

Standard Metrics

Alarms Triggered

Measure

Count of alarms fired

Calculation

IF [Email] = 1 OR [Popup] = 1 OR [Screenshot] = 1 OR [Terminate] = 1 THEN

1

ELSE

0

END

Standard Metrics

All Time (hr)

Measure

Total time in hours

Calculation

SUM([Duration (hr)])

Standard Dimensions

App/Site Status

Dimension

Logic to identify approved vs unapproved apps/sites. This logic should be modified to determine app/site status for your particular company.

Calculation

//This logic should be modified to determine app/site status for your particular company

IF (ISNULL([Category]) OR UPPER([Category]) = 'UNCATEGORIZED') AND (ISNULL([Productivity]) OR UPPER([Productivity]) = 'UNDEFINED') THEN

'Unapproved'

ELSE

'Approved'

END

Standard Dimensions

Application

Dimension

Application name

Calculation

IFNULL([Log Description],[Executable])

Standard Dimensions

Application/Site

Dimension

Display application name for applications or browser and site for sites

Calculation

IF ISNULL([Site]) THEN

[Application]

ELSE

[Application] + " (" + [Site] + ")"

END

Standard Metrics

Applications

Measure

Count of applications

Calculation

COUNT([Application])

Advanced Metrics

Avg Active Hours / Day

Measure

Avg active hours per user per day

Calculation

[Hours / User / Day]

Advanced Metrics

Avg Focused Hours / Day

Measure

Avg focused hours per user per day

Calculation

[Focused Time (hr)]/[Users]/[Days With Activity]

Advanced Metrics

Avg Productive Hours / Day

Measure

Avg productive hours per user per day

Calculation

[Productive Hours/User/Day]

Standard Dimensions

Category

Dimension

Activity category specified in the ActivTrak application.

Data Source Field

category

Advanced Dimensions

Clean Url

Dimension

Url without the protocol (http:// or https://)

Calculation

IF CONTAINS([Log Url],'http://') THEN

MID([Log Url],FIND([Log Url],'http://')+7)

ELSEIF CONTAINS([Log Url],'https://') THEN

MID([Log Url],FIND([Log Url],'https://')+8)

ELSE

[Log Url]

END

Advanced Dimensions

Burnout Risk Color Classification

Dimension

Classifies into 3 different colors (red, yellow and green) 

Red - High Risk

(High Activity/No Boundaries)

Yellow - Low Risk

(High Activity/Within Boundaries)

(Normal Activity/Without Boundaries)

Green - No Risk

(Normal Activity/Within Boundaries)

 Calculation

 

IF ([Suggested Active Hours Limit] < [Avg Active Hours / Day]) AND ([Suggested Days With After Hours Limit] < [Days With After Hours Activity / Week])

THEN 'RED'

ELSEIF ([Suggested Active Hours Limit] >= [Avg Active Hours / Day]) AND ([Suggested Days With After Hours Limit] >= [Days With After Hours Activity / Week])

THEN 'GREEN'

ELSE 'YELLOW'

END

Standard Dimensions

Computer

Dimension

Computer name. Comes from operating system.

Data Source Field

computer

Advanced Metrics

Context Switches

Measure

Identifies a context switches when a user views too many different applications or screens within one minute. The number of apps or screens is configurable.

Calculation

{ FIXED [User Name],[Activity Minute] : IF ([Distinct Applications] > [Context Swtich - Max Distinct Apps within minute] OR [Distinct Screens] > [Context Swtich - Max Distinct Screens within minute]) THEN 1 END }

Advanced Metrics

Context Switches Per Hour

Measure

Number of context switches per hour monitored

Calculation

SUM([Context Switches])/SUM([Duration (hr)])

Standard Dimensions

Day of Week

Dimension

Day of the week from the Activity Date

Calculation

DATENAME("weekday",[Activity Date])

Standard Dimensions

Day Type

Dimension

Weekday vs weekend

Calculation

IF ISOWEEKDAY([Activity Time]) > 5 THEN

'Weekend'

ELSE

'Weekday'

END

Global Filters

Day Type Filter

Dimension

Weekday vs weekend. Field used for global filtering.

Calculation

[Day Type]

Standard Metrics

Days Monitored

Measure

Distinct number of days monitored

Calculation

COUNTD([Activity Date])

Advanced Metrics

Days Per User

Measure

Distinct number of days monitored per user

Calculation

{FIXED [User Name],[Productivity] : COUNTD(DATEPART('day',[Activity Date]))}

Advanced Metrics

Days Since Last Activity

Measure

Days since last activity compared to today

Calculation

DATEDIFF('day',[Last Activity],NOW())

Advanced Metrics

Days with Activity

Measure

Distinct days with activity reported

Calculation

COUNTD([Activity Date])

Standard Metrics

Distinct Applications

Measure

Distinct number of applications

Calculation

COUNTD([Application])

Standard Metrics

Distinct Screens

Measure

Distinct number of screens

Calculation

COUNTD([Title Bar])

Standard Metrics

Distinct Sites

Measure

Distinct number of websites

Calculation

COUNTD([Site])

Advanced Metrics

Distracted Time (min)

Measure

Number of minutes marked as distracted time

Calculation

SUM([Context Switches])

Standard Metrics

Duration (hh:mm:ss)

Measure

Activity duration in standard time format.

Calculation

STR(INT(SUM([Duration (sec)])/3600))

+ ":" +

IF INT(SUM([Duration (sec)])%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(SUM([Duration (sec)])%3600/60))

+ ":" +

IF INT(SUM([Duration (sec)]) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(SUM([Duration (sec)])%3600 %60))

Standard Metrics

Duration (hr)

Measure

Activity duration in hours.

Calculation

[Duration (min)]/60

Standard Metrics

Duration (min)

Measure

Activity duration in minutes.

Calculation

[Duration (sec)]/60

Standard Metrics

Duration (sec)

Measure

Activity duration in seconds.

Data Source Field

duration

Global Filters

Duration (sec) Filter

Measure

Activity duration in seconds. Field used for global filtering.

Calculation

[Duration (sec)]

Standard Metrics

Duration as % of Total Week

Measure

Duration as a % of total time in the week

Calculation

[Duration (hr)] / [Total Week Duration]

Standard Metrics

Duration Per User

Measure

Duration per user

Calculation

{FIXED [User Name] : SUM([Duration (sec)])}

Standard Metrics

Email

Measure

Flag to denote if the log entry is associated with an alarm that triggered an email (0 = no email notification was sent, 1 = email notification was sent)

Data Source Field

email

Standard Dimensions

Executable

Dimension

Name of the app running, usually in it's raw format. E.g. Slack.exe

Data Source Field

executable

Advanced Metrics

First Activity

Measure

First activity (at the minute level of granularity)

Calculation

MIN([Activity Minute])

Advanced Metrics

First Activity Date Range

Measure

First activity (at the minute level of granularity) for filtering

Calculation

MIN([Activity Minute])

Advanced Metrics

Focus Score

Measure

Focused time % was expressed as a score (1-100)

Calculation

([Focused Time % ]*100)

Advanced Metrics

Focused Time (hr)

Measure

Focused time expressed as hours

Calculation

[Focused Time (min)]/60

Advanced Metrics

Focused Time (min)

Measure

Time where minimal distractions or context switches are observed (Active Time - Distracted Time). We identify a minute as “distracted” when the user switches between three or more apps and five or more different screens. These thresholds are configurable.

Calculation

IF ([Active Time (min)] - SUM([Context Switches])) >= 0 THEN

[Active Time (min)] - SUM([Context Switches])

ELSE

0

END

Advanced Metrics

Focused Time %

Measure

Focused time as % of all Active Time

Calculation

[Focused Time (min)]/[Active Time (min)]

Advanced Metrics

Hours Since Last Activity

Measure

Hours since last activity compared to now

Calculation

DATEDIFF('hour',[Last Activity],NOW())

Advanced Metrics

Hours/User

Measure

Number of hours per user

Calculation

SUM([Duration (hr)])/[Users]

Advanced Metrics

Hours/User/Day

Measure

Number of hours per user per day

Calculation

SUM([Duration (hr)])/[Users]/[Days Monitored]

Standard Dimensions

IP Address

Dimension

Private IP address

Data Source Field

ip

Standard Dimensions

Is Passive Event?

Dimension

Flag to denote if an event is Passive or not

Calculation

ISNULL([Log Description])

Advanced Metrics

Last Activity

Measure

Last activity (at the minute level of granularity)

Calculation

MAX([Activity Minute])

Advanced Metrics

Last Reported Activity

Measure

Last reported activity expressed in bins (e.g. < 24 hours)

Calculation

IF [Hours Since Last Activity] < 24 THEN

'< 24 hours'

ELSEIF [Hours Since Last Activity] >= 24 AND [Hours Since Last Activity] < 48 THEN

'24-48 hours'

ELSEIF [Hours Since Last Activity] >= 48 AND [Hours Since Last Activity] < 72 THEN

'48-72 hours'

ELSE

'> 72 hours'

END

Standard Dimensions

Log Description

Dimension

Friendly name of the app or site running. Almost always the same as "executable" but in Proper Case.

Data Source Field

log_description

Standard Dimensions

Log Url

Dimension

Url for website related activity, otherwise it will be null.

Data Source Field

log_url

Standard Dimensions

Logon Domain

Dimension

Active Directory domain attached computers will show the domain name here. If not attached to a domain, the computername will be shown. Macs almost always show computername and Google Chrome agents will not show anything. Comes from operating system.

Data Source Field

logondomain

Advanced Metrics

Off Hours Time (hr)

Measure

Aggregate of off hours activity = Weekday after hours time + Weekend time

Calculation

IFNULL([After Hours Time],0) + IFNULL([Weekend Time],0)

Advanced Metrics

Passive Time (hr)

Measure

Time marked as passive

Calculation

SUM(

IF [Activity Type]='Passive' THEN

[Duration (hr)]

END

)

Advanced Metrics

Passive Time %

Measure

Passive time as a % of all time

Calculation

[Passive Time (hr) ]/[All Time (hr)]

Standard Metrics

Popup

Measure

Flag to denote if the log entry is associated with an alarm that triggered a popup in the user's screen (0 = popup notification didn't fire, 1 = popup notification fired)

Data Source Field

popup

Advanced Dimensions

Potential File Transfer

Dimension

Combines all the file tranfer keyword logic into one calculation

Calculation

IF [Potential File Transfer 1] OR

[Potential File Transfer 2] OR

[Potential File Transfer 3] OR

[Potential File Transfer 4] OR

[Potential File Transfer 5]

THEN

TRUE

ELSE

FALSE

END

Advanced Dimensions

Potential File Transfer 1

Dimension

Returns true if an activity entry matches the File Transfer Keyword 1

 

IF [File Transfer Keyword 1] <> "" THEN

IF CONTAINS(UPPER([Log Description]),UPPER([File Transfer Keyword 1])) THEN

TRUE

ELSE

FALSE

END

ELSE

FALSE

END

Advanced Dimensions

Potential File Transfer 2

Dimension

Returns true if an activity entry matches the File Transfer Keyword 2

 

IF [File Transfer Keyword 2] <> "" THEN

IF CONTAINS(UPPER([Log Description]),UPPER([File Transfer Keyword 2])) THEN

TRUE

ELSE

FALSE

END

ELSE

FALSE

END

Advanced Dimensions

Potential File Transfer 3

Dimension

Returns true if an activity entry matches the File Transfer Keyword 3

 

IF [File Transfer Keyword 3] <> "" THEN

IF CONTAINS(UPPER([Log Description]),UPPER([File Transfer Keyword 3])) THEN

TRUE

ELSE

FALSE

END

ELSE

FALSE

END

Advanced Dimensions

Potential File Transfer 4

Dimension

Returns true if an activity entry matches the File Transfer Keyword 4

 

IF [File Transfer Keyword 4] <> "" THEN

IF CONTAINS(UPPER([Log Description]),UPPER([File Transfer Keyword 4])) THEN

TRUE

ELSE

FALSE

END

ELSE

FALSE

END

Advanced Dimensions

Potential File Transfer 5

Dimension

Returns true if an activity entry matches the File Transfer Keyword 5

 

IF [File Transfer Keyword 5] <> "" THEN

IF CONTAINS(UPPER([Log Description]),UPPER([File Transfer Keyword 5])) THEN

TRUE

ELSE

FALSE

END

ELSE

FALSE

END

Standard Dimensions

Primary Domain

Dimension

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. If not, it's typical for Windows machines to use "WORKGROUPS", Chrome agents to use "Google". Macs typically don't show anything related to primary domain. Comes from operating system.

Data Source Field

primarydomain

Advanced Metrics

Productive Applications

Measure

Count of distinct applications classified as productive

Calculation

COUNTD(

IF [Productivity] = 'PRODUCTIVE' THEN

[Application]

END

)

Advanced Metrics

Productive Hours/User/Day

Measure

Avg productive hours per user per day

Calculation

[Productive Time (hr)]/[Users]/[Days With Activity]

Advanced Metrics

Productive Screens

Measure

Count of screens (title bars) classified as productive

Calculation

COUNT(

IF [Productivity] = 'PRODUCTIVE' THEN

[Title Bar]

END

)

Advanced Metrics

Productive Screens %

Measure

Productive screens as a % of total

Calculation

[Productive Screens]/[Screens]

Advanced Metrics

Productive Time

Measure

Productive time expressed in hours, minutes, seconds format

Calculation

STR(INT(SUM(IIF([Productivity]='PRODUCTIVE',[Duration (sec)],NULL))/3600))

+ "h " +

IF INT(SUM(IIF([Productivity]='PRODUCTIVE',[Duration (sec)],NULL))%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(SUM(IIF([Productivity]='PRODUCTIVE',[Duration (sec)],NULL))%3600/60))

+ "m " +

IF INT(SUM(IIF([Productivity]='PRODUCTIVE',[Duration (sec)],NULL)) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(SUM(IIF([Productivity]='PRODUCTIVE',[Duration (sec)],NULL))%3600 %60))

+ "s"

Advanced Metrics

Productive Time (hr)

Measure

Time classified as productive

Calculation

SUM(

IF [Productivity] = 'PRODUCTIVE' THEN

[Duration (hr)]

END

)

Advanced Metrics

Productive Time %

Measure

Productive time as a % of total

Calculation

[Productive Time (hr)]/[All Time]

Standard Dimensions

Productivity

Dimension

Productivity. Available values are Undefined, Productive, Unproductive. Passive time is defined in Title bar field.

Data Source Field

productivity

Standard Dimensions

Public IP Address

Dimension

Public IP address is the IP address that can be accessed over the Internet

Data Source Field

publicip

Users & Groups

Reporting Group

Dimension

Adhoc organization of users into groups (e.g. Sales, Marketing, etc.)

Calculation

Manual classification

Global Filters

Reporting Group Filter

Dimension

Reporting group. Field used for global filtering.

Calculation

[Reporting Group]

Advanced Metrics

Reporting Group Hours/User/Day

Measure

Avg hours per user per day by group

Calculation

{ EXCLUDE [User Name] : SUM([Duration (hr)])/[Days With Activity]/[Users] }

Advanced Metrics

Reporting Status

Measure

ActivTrak agent reporting status based on the threshold of inactivity

Calculation

IF [Hours Since Last Activity] < [Inactive Agent Last Activity Threshold (Hours)] THEN

'Recent'

ELSE

'Dated'

END

Standard Metrics

Screens

Measure

Count of screens (title bars)

Calculation

COUNT([Title Bar])

Standard Metrics

Screenshot

Measure

Flag to denote if the log entry is associated with an alarm that triggered a screenshot capture (0 = screenshot was not captured, 1 = screenshot was captured)

Data Source Field

screenshot

Advanced Dimensions

Search Term

Dimension

Extracts the search term from the raw query string in the url

Calculation

IF [Activity Type] = 'Search' THEN

MID([Search Term Raw],1,[Search Term Length])

END

Advanced Dimensions

Search Term Clean

Dimension

Cleans up the search term by removing delimters

Calculation

IF [Activity Type] = 'Search' THEN

REPLACE([Search Term],'+',' ')

END

Advanced Dimensions

Search Term Length

Dimension

Obtains the length of the search term

Calculation

IF CONTAINS([Search Term Raw],[Search URL Suffix]) THEN

FIND([Search Term Raw],[Search URL Suffix])-1

ELSEIF CONTAINS([Search Term Raw],[Search Titlebar Suffix]) THEN

FIND([Search Term Raw],[Search Titlebar Suffix])-2

ELSE

LEN([Search Term Raw])

END

Advanced Dimensions

Search Term Prefix

Dimension

Identifies the search term prefix used in a particular URL

Calculation

IF [Activity Type] = 'Search' THEN

IF CONTAINS(LOWER([Log Url]),[Search Prefix 1]) THEN

[Search Prefix 1]

ELSEIF CONTAINS(LOWER([Log Url]),[Search Prefix 2]) THEN

[Search Prefix 2]

ELSEIF CONTAINS(LOWER([Log Url]),[Search Prefix 3]) THEN

[Search Prefix 3]

ELSEIF CONTAINS(LOWER([Log Url]),[Search Prefix 4]) THEN

[Search Prefix 4]

ELSEIF CONTAINS(LOWER([Log Url]),[Search Prefix 5]) THEN

[Search Prefix 5]

END

END

Advanced Dimensions

Search Term Prefix Position

Dimension

Get the position of the search term prefix within the url

Calculation

IF [Activity Type] = 'Search' THEN

IF NOT ISNULL([Search Term Prefix]) THEN

FIND([Log Url],[Search Term Prefix])

END

END

Advanced Dimensions

Search Term Raw

Dimension

Extracts the search term raw from the url or title bar

Calculation

IF [Activity Type] = 'Search' THEN

IF NOT ISNULL([Search Term Prefix]) THEN

MID([Log Url],[Search Term Prefix Position]+2)

ELSEIF CONTAINS([Title Bar],[Search Titlebar Term]) THEN

[Title Bar]

ELSE

'Undefined'

END

END

Advanced Metrics

Searches

Measure

Count of search activities

Calculation

COUNT(

IF [Activity Type] = 'Search' THEN

[Title Bar]

END)

Advanced Metrics

Searches Per Day

Measure

Count of searches per monitored day

Calculation

[Searches]/[Days With Activity]

Standard Dimensions

Site

Dimension

Website without protocol (e.g. http://) nor paths/parameters

Calculation

LEFT([Clean Url],FIND([Clean Url],'/')-1)

Standard Metrics

Terminate

Measure

Flag to denote if the log entry is associated with an alarm that triggered an application termination (0 = no application termination occurred, 1 = originating application was terminated)

Data Source Field

terminate

Standard Dimensions

Time of Day

Dimension

Part of the day for activity time.

- Morning: 6am-12pm

- Afternoon: 12pm-6pm

- Night: 6pm-12am

- Overnight: 12am-6am

Calculation

IF DATEPART('hour',[Activity Time]) >=6 AND DATEPART('hour',[Activity Time]) <12 THEN

"Morning"

ELSEIF DATEPART('hour',[Activity Time]) >=12 AND DATEPART('hour',[Activity Time]) <18 THEN

"Afternoon"

ELSEIF DATEPART('hour',[Activity Time]) >=18 AND DATEPART('hour',[Activity Time]) <24 THEN

"Night"

ELSE

"Overnight"

END

Standard Dimensions

Title Bar

Dimension

Name of title bar of the active window.

Data Source Field

titlebar

Standard Metrics

Total Time

Measure

Total time expressed in hours, minutes, seconds format

Calculation

STR(INT(SUM([Duration (sec)])/3600))

+ "h " +

IF INT(SUM([Duration (sec)])%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(SUM([Duration (sec)])%3600/60))

+ "m " +

IF INT(SUM([Duration (sec)]) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(SUM([Duration (sec)])%3600 %60))

+ "s"

Advanced Metrics

Total Week Duration

Measure

Total time reported in a week

Calculation

{ FIXED Week([Activity Date]),[Day Type] : SUM([Duration (hr)]) }

Advanced Metrics

Unproductive Applications

Measure

Count of distinct applications classified as unproductive

Calculation

COUNTD(

IF [Productivity] = 'UNPRODUCTIVE' THEN

[Application]

END

)

Advanced Metrics

Unproductive Screens

Measure

Count of distinct screens (title bars) classified as unproductive

Calculation

COUNT(

IF [Productivity] = 'UNPRODUCTIVE' THEN

[Title Bar]

END

)

Advanced Metrics

Unproductive Screens %

Measure

Unproductive screens as a % of total

Calculation

[Unproductive Screens]/[Screens]

Advanced Metrics

Unproductive Screens Per Hour

Measure

Number of screens classified as unproductive per hour

Calculation

[Unproductive Screens]/SUM([Duration (hr)])

Advanced Metrics

Unproductive Time (hr)

Measure

Time classified as productive

Calculation

SUM(

IF [Productivity] = 'UNPRODUCTIVE' THEN

[Duration (hr)]

END

)

Advanced Metrics

Unproductive Time %

Measure

Unproductive time as a % of total

Calculation

[Unproductive Time (hr)]/[All Time]

Users & Groups

User

Dimension

Friendly user name. E.g. First Last. Comes from operating system.

Data Source Field

user

Users & Groups

User (Raw)

Dimension

Simple login name. Often first initial, last name. Comes from operating system.

Data Source Field

userraw

Users & Groups

User Alias

Dimension

Comes from ActivTrak, and not the operating system. User Aliases are used to combine multiple user logins in our graphs and reports as well as provide a "friendly name" in case the "userraw" and "user" fields are ambiguous.

Data Source Field

useralias

Users & Groups

User Name

Dimension

Displays user alias if specified, otherwise, it displays user

Calculation

IFNULL([User Alias],[User])

Standard Metrics

Users

Measure

Distinct count of users (using user name as the field for user).

Calculation

COUNTD([User Name])

Standard Metrics

Webhook

Measure

Flag to denote if the log entry is associated with an alarm that triggered a webhook sent (0 = no webook sent, 1 = webhook was sent)

Data Source Field

webhook

Advanced Metrics

Weekend Time

Measure

Time recorded during weekend

Calculation

IF [Day Type] = "Weekend" THEN

IFNULL([Duration (hr)],0)

ELSE

0

END

Advanced Metrics

Days With Weekend Activity  Measure Distinct days with activity reported over the weekend  Calculation COUNTD(IF [Weekend Time] > 0 THEN [Activity Date] END)

Advanced Metrics

Weeks with Activity  Measure Distinct weeks with activity reported  Calculation  COUNTD(WEEK([Activity Date]))

Advanced Metrics

Days Working Off-hours  Measure Distinct number of weekdays with off hours activity and weekend activity  Calculation  [Days With Weekend Activity]+[Days With After Hours Activity]

Advanced Metrics

Days With After Hours Activity / Week  Measure Distinct number of days with off hours activity by weeks with activity reported  Calculation  [Days With After Hours Activity]/[Weeks With Activity]

Advanced Metrics

Days With After Hours Activity

 Measure

Distinct number of days with off hours activity

 Calculation

 COUNTD(IF [After Hours Time] > 0 THEN [Activity Date] END)

Parameters

Daylights Savings

Parameter

Flag to denote daylight savings conversion from UTC time.

Boolean

False

Parameters

File Transfer Keyword 1

Parameter

Keyword to match activities to potential file transfers. Can be changed.

String

onedrive

Parameters

File Transfer Keyword 2

Parameter

Keyword to match activities to potential file transfers. Can be changed.

String

dropbox

Parameters

File Transfer Keyword 3

Parameter

Keyword to match activities to potential file transfers. Can be changed.

String

ftp

Parameters

File Transfer Keyword 4

Parameter

Keyword to match activities to potential file transfers. Can be changed.

String

usb

Parameters

File Transfer Keyword 5

Parameter

Keyword to match activities to potential file transfers. Can be changed.

String

disk

Parameters

Focused Time - Max Distinct Apps within minute

Parameter

Max number of different applications you can switch within one minute before such minute will be marked as distracted.

Integer

2

Parameters

Focused Time - Max Distinct Screens within minute

Parameter

Max number of different screens you can switch within one minute before such minute will be marked as distracted.

Integer

4

Parameters

Inactive Agent Last Activity Threshold (Hours)

Parameter

Number of hours since last agent activity before it is marked as non-reporting

Integer

72

Parameters

Search Prefix 1

Parameter

Keyword used to identify a search prefix in a url query

String

q=

Parameters

Search Prefix 2

Parameter

Keyword used to identify a search prefix in a url query

String

text=

Parameters

Search Prefix 3

Parameter

Keyword used to identify a search prefix in a url query

String

term=

Parameters

Search Prefix 4

Parameter

Keyword used to identify a search prefix in a url query

String

desc=

Parameters

Search Prefix 5

Parameter

Keyword used to identify a search prefix in a url query

String

query=

Parameters

Search Titlebar Suffix

Parameter

Search Titlebar Suffix

String

-

Parameters

Search Titlebar Term

Parameter

Search Titlebar Term

String

Search

Parameters

Search URL Suffix

Parameter

Search URL Suffix

String

&

Parameters

Search URL Term

Parameter

Search URL Term

String

search?

Parameters

Time Zone

Parameter

Time to convert from UTC time.

Integer

-6 (Central Time)

Parameters

Suggested Active Hours Limit

Parameters

Suggested Active Hours threshold for Burnout Risk Dashboard

Float

-

Parameters Suggested Days With After Hours Limit Parameters Suggested Days With After Hours threshold for Burnout Risk Dashboard Float -

Was this article helpful?

0 out of 1 found this helpful

Comments

No comments