1. ActivTrak Help Center
  2. Integrations & Add-Ons
  3. ActivConnect

ActivConnect Quick Start Guide

Tyler Winn

Tyler Winn

 

ActivTrak will set up your instance of ActivTrak ActivConnect in a hosted Google Cloud Account.  This process usually takes less than 24 hours. We will then send your credentials to access your account for your use. 

Note: You can query up to 1TB of data per month (the equivalent of 3.2GB records) which is more than enough for most customers. 

Accessing ActivTrak ActivConnect

Once your Google Cloud account is setup, there are three ways you can access ActivConnect:

  1. Use one of ActivTrak ActivConnect Pre-Built Templates for PowerBI or Tableau to jumpstart your analysis.
  2. Use Google BigQuery Console to access your data via SQL queries.
  3. Use a BI / Data tool of your choice to access ActivConnect and create your reports from scratch.

Below are the instructions for each of the three approaches listed.

Use one of the ActivTrak ActivConnect Templates to jumpstart your analysis

Our analysis templates contain a robust set of reports in the areas of Activity & Application Usage, Productivity, Collaboration & Knowledge Management, and Compliance & Risk Management.  

  1. Download ActivTrak ActivConnect Tableau Setup Guide
  2. Download ActivTrak ActivConnect Power BI Setup Guide

 

Use Google BigQuery Console to access your data via SQL queries

Follow the instructions below to access ActivConnect via BigQuery Console:

  1. Once your Google Cloud account is set up, you can verify access to your data in the ActivTrak ActivConnect instance in BigQuery by clicking on the URL below:
    https://console.cloud.google.com/
  2. This will prompt you to log in using your Google Account credentials that end with "activtrak.us". 
  3. Once you are logged in, you will see your data instance on the left-hand side of the Google BigQuery Console (called ‘activtrak-us): 

Data_Connect_-_Quick_start_guide.png

4.  Query your activity data within the BigQuery console using SQL statements that access your account’s logs table within the activtrak-us. The prototypical SQL query statement should look like the select statement below. Note that youraccountnumber should be replaced with your six-digit ActivTrak account number. 

Use this sample query limited to 100 rows to test you can access your data.

Select * from `activtrak-us.youraccountnumber.logs`

limit 100;

Data_Connect_-_quick_start_guide_2.png

For reference as you start exploring your activity data, you can access a Data Dictionary describing the available fields and a Sample Data Output in the Appendix of this document.

 

Use a BI / Data Visualization tool of your choice to access ActivConnect and create your reports from scratch

Follow the instructions for each tool below to access ActivConnect using a BigQuery connection:

  1. Select the ‘activtrak-com’ project.
  2. Select the dataset with your six-digit account number. 
  3. Select the ‘logs’ table within your dataset.
  4. Query your activity data and start creating reports.
  5. For reference as you start exploring your activity data, you can access a Data Dictionary describing the available fields in the Appendix of this document.

Data Dictionary

The resources below describe each of the columns available in ActivConnect. 

 

Was this article helpful?

4 out of 6 found this helpful

Comments

No comments