How to Export Data Using ActivConnect

Before deleting a user, you may want to export their data. This will allow you to retain the data outside ActivTrak after an employee resigns or is let go for performance reasons. One way to do this is with the ActivConnect Add-on, which leverages Google BigQuery to seamlessly access, export and connect your data to BI tools like Tableau and Microsoft Power BI.

How to export user data

Here’s how to get started with exporting data using ActivConnect:

• Go to console.cloud.google.com/bigquery and use your ActivConnect credentials to log in.
• Click the hamburger menu (three horizontal lines) in the upper left and select BigQuery.

• Under Select a Resource, select ActivTrak. 

• Search for your 6-digit account ID to pull up a list of pre-built tables.

• Select the three dots next to the table you want to use and select Query.

• In the query that appears, add an asterisk after SELECT to export everything available within the table.

• Click the Run button
• Click Save Results > CSV to export the data.

If you look at the columns available in the table, you can also use this information to drill down to a specific user. For example, in the events table, you can adjust the query to:

SELECT * FROM `us-activtrak-ac-prod.XXXXXX.events`

WHERE user = ‘[username]’

This will return all data for the specified employee only.

Recommended tables

We recommend focusing on three pre-built tables when exporting user data via ActivConnect:

• events: This table yields a granular, comprehensive play-by-play of user activity data, similar to the Activity Log. Columns include IP address information, computer name, domain, executable, application, duration on tools, status (ACTIVE vs PASSIVE), alarm information and time zone.

• daily_application_summary: This table focuses on tool usage data. Columns include executable, application, website, category, productivity (productive or unproductive), duration and passive time.

• daily_user_summary: This table focuses on averages (available in the Essentials Plus and Professional plan reports), productive time, unproductive time, active/passive time, collaboration time, break count and break duration, utilization levels, and focus time.

Additional resources

For additional help exporting data with ActivConnect, ActivTrak’s Signature Support connects you to solution architects who can customize Tableau, Microsoft Power BI or out-of-the-box templates. Contact your Customer Success Manager to learn more.

Learn more:

ActivConnect API (Add-on)

How to Export and Manage Data