ActivConnect Overview


ActivConnect is a set of API connectors and tools to enable access to your ActivTrak data in hundreds of external applications. ActivConnect includes a cloud-based SQL query interface, API compatibility with business and analytic software, BI starter templates for Microsoft Power BI, Tableau, Google Data Studio, and more. 

ActivConnect is available as an add-on to customers on a paid plan (contact Sales for a quote) and ships with a whole host of pre-built BI starter templates for Microsoft Teams, Power BI, Tableau and Google Data Studio, which you can customize. Quickly generate detailed reports for your platform of choice in the areas of application usage, productivity and collaboration trends, employee burnout risk and much more.

What Is Included

  • Your own cloud-based private database
  • Secure access via Google Cloud account
  • Automatic data refresh every 12 hours
  • Query your data via SQL or BI Tools
  • BI starter templates for Microsoft Teams, Tableau, Power BI and Google Data Studio
  • Quick Start guides & optional onboard session with ActivTrak to get the most out of ActivConnect

How Does It Work?

  1. ActivTrak configures your data instance and links to a hosted Google Cloud account to enable access
  2. Initial data load and turnaround time is within 24 hours
  3. ActivTrak notifies you with your access credentials when the account is ready for use
  4. Refer to the Quick Start Guide & Data Dictionary to connect and get started
  5. Use ActivTrak pre-built templates for Microsoft Teams, Tableau, Power BI and Google Data Studio, or build your own with your platform of choice

Frequently Asked Questions

What data is available in ActivConnect? ActivTrak ActivConnect gives you full access to every action, every log, every value, every user that ActivTrak collects - all in one table.
Why do I need ActivConnect?

ActivConnect is a great solution for data-savvy companies with Analytics / Data teams that want to do bulk queries, custom analysis and combine data sets with activity and productivity data into powerful business insights.

You can import ActivTrak data to one of a multitude of data warehouses, BI visualization tools, and developer tools. You can create personalized reports, push behavior data to your existing data infrastructure, and perform any query from a simple query interface.

How do I purchase ActivConnect? ActivConnect is available as an add-on to customers on a paid plan. Contact Sales for a quote.
How is it billed? It can be billed monthly or annually; you will see it reflected in your invoice alongside your ActivTrak subscription.

Where is my data stored?

Your data will be stored in your assigned data center (United States, Canada, United Kingdom, European Union, or Australia).

Can I use BI tools to access my data?

Yes, you can access ActivConnect using any BI tool through a BigQuery connection.

I don’t have staff experienced with BI tools, do you have pre-built reports?

We have pre-built dashboards and reports for Microsoft Teams, Tableau, Power BI &/or Google Data Studio which automate many of the data outputs you will need and help get you started.

Do you offer implementation assistance?

After you purchase ActivConnect, we can schedule an onboarding session where a customer support agent will walk you through the process of connecting your data source to your preferred BI platform.

Why do I need Google BigQuery to access my data?

ActivTrak is a SaaS solution hosted in the Google Cloud and leverages BigQuery for secure and fast access to your data.

I’m not familiar with how to use Google BigQuery, how does it work?

Google BigQuery is a pretty intuitive cloud data warehouse platform, you can learn more about it and how to use it here. You can query up to 1TB of data per month (the equivalent of 3.2GB records) which is more than enough for the majority of customers.

Why do I need a Google Cloud account to access my data?

ActivTrak will provision and set up a Google Cloud account on your behalf. You will need this to authenticate securely into your private BigQuery instance.

Can I use another data warehouse to run my queries?

You will need Google Big Query to access/query your ActivTrak data. You can export your outputs to other sources of your choosing after that.

Was this article helpful?

5 out of 10 found this helpful


No comments