If you want more direct access to the raw analytics data that Treefort collects, one way to get it is to set up an integration with Google BigQuery. In this way, we can sync your analytics directly to your BigQuery project, where you can run custom queries.
👉 This guide assumes that you already have a BigQuery project set up. If you don't, please first follow the instructions found here.
🚧 This integration will incur charges from Google based on the amount of data being transferred into and stored by BigQuery, and the cost will vary based on your users' usage. If you are concerned about the amount of data to be transferred, reach out to Treefort support and we can provide an estimate of roughly how much data will be sent per day.
Setup Instructions
Enable API access to your BigQuery project (if it isn't already enabled).
Ensure that billing is enabled for your BigQuery project.
Note your BigQuery project ID.
Create a new Google Cloud Storage (GCS) bucket (or provide an existing one). This is used to store files before loading the data into your BigQuery instance.
Ensure this bucket is in the same region as your BigQuery project.
Create a service account with the necessary permissions for Treefort to send data to your BigQuery project:
Create a new service account by going to IAM & Admin > Service Accounts.
Add the following service account roles to the account:
Storage Object CreatorStorage Object ViewerBigQuery Job UserBigQuery Data Owner
Create a new key for the service account with JSON as the type and download it.
Send Treefort the following information using a one-time password sharing service such as Onetime Secret:
The BigQuery project ID
The GCP region your dataset is in
The GCP Storage bucket name
(Optional) A prefix to use when storing data in your bucket (if specified, a folder will be created in your bucket and all data will be pushed there)
(Optional) A schema name where all tables should be created
The JSON private key for the service account that you created above
Your desired sync frequency (how often Treefort will send data to BigQuery): 30 minutes, 1 hour, 3 hours, 6 hours, 12 hours, or 24 hours
Once we receive the above information, we'll configure things on the Treefort side and start sending analytics data to you!