Simplify your BI setup with Tenjin’s Calculated Metrics (Simple Query)

Overview

Learn how Tenjin calculates the reporting metrics available on the dashboard

With this training, you will receive an in-depth overview of Tenjin’s calculated metrics and also learn how to recreate these tables with your own reporting.

Important Note: All our Paid trainings include SQL/dashboard/script for which access is only provided to customers who have a paid subscription to the service. You can get in touch with us if you would like to subscribe.

Summary

What you will learn

As your apps grow and you start to build your own infrastructure, it’s important to understand how some of your reporting data on the Tenjin dashboard is calculated.

With this training, you will learn how to get access to the SQL that will help you replicate Tenjin’s calculated metrics from the following tables:

• Reporting_metrics -> which include all non-cohorted metrics that are synced with dashboard data
• Reporting_cohort_metrics -> which include all cohorted metrics that are synced with dashboard data

Tenjin DataVault schema has a description of all the metrics available in the two tables.

Setup

What you need

For this training, you will only need access to Tenjin’s DataVault and your internal BI tool to run queries.

No additional setup is required here.

How To

How you can get started

Please contact your Tenjin Account Manager for access to the SQL that will replicate Tenjin’s reporting_metrics and reporting_cohort_metrics.

Usually, a 15 minute call is sufficient to go through our ad revenue and spend allocation with you.

FAQ

Will this data match what I see on the Tenjin dashboard?

No. Tenjin’s dashboard production processes are complex and cannot be easily replicated with just one query.

What is the difference between daily and cohort metrics? 

Daily metrics are calculated using the absolute UTC time of the activity, but cohort metrics are calculated using both the UTC date of install and the day of life after install. This forum post has additional details.

 

Feedback

Do you have any feedback for us?

We at Growth FullStack are always happy to receive your valuable feedback. Whether it’s about requesting additional support on optimizing your workflows, building a customized dashboard, or anything else, feel free to reach out to us and let us know how we can support you further.

Iterate and Maintain

Iterate

This query can be edited on your end, to customize it for your reporting needs.

Maintain

If you’re joining multiple tables, you would need to make sure that the query is updated for any changes across Tenjin’s default tables.