Toucan 3.0
YouPrep documentationHelp centerGet a demo
  • Welcome
    • 👋Welcome to Toucan
    • ⚙️Technical resources
      • ⚙️Toucan stack
      • Setup mode
        • Toucan SaaS mode
      • ⚙️Security
        • Application Security
        • Source Code Quality
        • Global Security Practices
        • Security of Docker Images
  • TUTORIALS
    • 📊Getting Started : Embedded Analytics
    • 🤓Advanced tutorials
      • Embedding a story with user attributes
        • Dynamic filter with user attributes
        • Dynamic Tables
        • Dynamic Database
        • Dynamic Host
      • Using the HTTP API connector in advanced use cases
      • Using advanced syntax for SQL queries
      • Merging filters with our tool
      • Deep customization chart (CSS)
        • Homepage customization
        • Chart customization
        • Dashboard customization
  • Data Management
    • 🧮Overview of Data In Toucan
    • 📡Datasources in Toucan
      • 🔌Managing Connectors
        • 🔌Creating, editing and deleting a connector
        • 🔌Set up OAuth2 credentials for your platform
        • 🔌Setting up a connector
          • 🔌Generic Connectors
            • 🔌Setting up an HTTP API connector
            • 🔌Setting up an ODBC Connector
          • 🔌Database and data warehouse Connectors
            • 🔌Setting up an AWS Redshift Connector
            • 🔌Setting up a Snowflake Connector
            • 🔌Setting up a PostgreSQL Connector
            • 🔌Setting up a Google Big Query Connector
            • 🔌Setting up an AWS Athena connector
            • 🔌Setting up a MySQL connector
            • 🔌Setting up a MongoDB connector
            • 🔌Setting up a Microsoft SQL Server connector
            • 🔌Setting up an Azure SQL connector
            • 🔌Setting a Databricks Connector
            • 🔌Setting up a ElasticSearch Connector
            • 🔌Setting up a Clickhouse Connector
          • 🔌Online services connectors
            • 🔌Setting up a Sharepoint Connector
            • 🔌Setting up a Google Sheets Connector
            • 🔌Setting up a Salesforce Connector
            • 🔌Setting up a Hubspot Connector
          • 🔌Setting up an AWS S3 connector
      • 🗄️Managing remote file storages
        • 🗂️Setting up a file storage
          • SFTP
        • 📄Create a dataset from a file
      • 📁Managing Files
        • 📁Adding, editing and deleting local files
        • 📂Using advanced file settings
        • 📁Adding and combining remote files in Toucan
    • 🔢Datasets in Toucan
      • 🔢Stored and Live Datasets
      • 💿Managing datasets
        • 🔢Creating datasets
        • 🔢Editing, Duplicating and Deleting a dataset
        • 🔢Refreshing and Publishing Datasets
        • 📈Optimize data performance
        • 🗂️Adding indexes to stored datasets
        • 👩‍💻Code mode and single mode
      • 🛑Setting permissions on dataset
      • 🗃️Maintaining Data
        • 🗃️Tagging datasets
        • 🗃️Identifying datasets dependencies
        • 🗃️Set validation rules
    • 🧑‍🍳Preparing data
      • Overview of YouPrep™
        • 🎹Column header
          • Rename column
          • Duplicate column
          • Fill null values
          • Replace values
          • Sort values
          • Convert columns data types
        • Add
          • Add text column
          • Add formula column
          • Add conditional column
        • Filter
          • Delete columns
          • Keep columns
          • Filter rows
          • Top N rows
          • ArgMax
          • ArgMin
        • Aggregate
          • Group by
          • Add total rows
          • Hierarchical rollup
          • Get unique groups/values
        • Compute
          • Compute evolution
          • Cumulated sum
          • Percentage of total
          • Rank
          • Moving average
          • Compute statistics
          • Absolute value
        • Text
          • Concatenate
          • Split column
          • Extract substring
          • To lowercase
          • To uppercase
          • Compare text columns
          • Trim spaces
          • Replace text
        • Date
          • Convert text to date
          • Convert date to text
          • Extract date information
          • Add missing dates
          • Compute duration
          • Normalize date granularity
        • Reshape
          • Pivot
          • Unpivot
          • Waterfall
        • Combine
          • Append datasets
          • Join datasets
        • Geo
          • Geographic dissolve
          • Geographic hierarchy
          • Geographic simplify
          • Prepare geo data (with basemap)
      • YouPrep™ Native SQL
      • Hybrid pipeline
    • ➿Managing variables in Toucan
      • ➿Variables hub
      • ♈Use variables in YouPrep™
      • ➿Easy reference to variables
    • 🧞Using advanced data concepts
      • 🧞Data personnalisation with user attributes
        • Connector setup with a user attribute
        • Database selection with a user attribute
        • YouPrep data filtering with a user attribute
        • Filter data in SQL with a user attribute
      • 🧞Advanced syntax for variables
      • 🧞Data cache
  • Visualizations and Layouts
    • 📺Apps
      • 📺Managing Apps
        • ➕Creating Apps
        • 📄Duplicating Apps
        • 🖨️Publishing Apps
        • 🚮Deleting Apps
        • ✍️Editing within an App
      • 🖌️Customizing Apps
        • Customizing chart color elements
        • Customizing the app's font
        • Adding Assets
        • Adding Glossary
        • Setting up, Managing and testing custom visibilities
        • Customizing the "no data error" message
        • Creating a dynamic background based on an Filter's column
      • 🏠Home
        • Creating the Home
        • Creating Tiles
          • Tile Dynamic Value
          • Tile Leaderboard
          • Tile Line
          • Tile Scorecard
          • Tile Bullet
          • Tile Heatmap
          • Tile PDF
          • Tile Video
          • Tile Image
          • Tile Text
          • Tile HTML
          • Tile Separator
      • ✨Stories
        • Creating a Story
        • KPIs
        • Narrative
        • Crossfilter
      • 📽️Filters
        • Managing Filters
          • Creating, reusing and editing Filters
          • Applying Filters
          • Unpinning and deleting Filters
        • Type of Filters
          • Dropdown
          • Checkboxes
          • Buttons
          • Date Range
          • Hierarchical
          • Slider
        • Templating from Filters' values
        • Dependant Filters
      • 📈PDF Report
      • 🎡Datawall
      • 🏗️Dashboard Builder
        • Create a Dashboard Builder
        • Embed a Dashboard Builder
        • Dashboard export options
      • 🌟MyFavorites
    • 📊Creating Visualizations
      • 🤩Viz Gallery
        • Barchart
        • Barlinechart
        • Bubblechart
        • Bulletchart
        • Circularchart
        • Funnelchart
        • Gantt chart
        • Heatmap
        • HTML
        • Leaderboard
        • Leaderboard Centered Average
        • Linechart
        • Mapchart
          • Configure a drill
        • Mediachart
        • Radarchart
        • Tablechart
        • Timeline
        • Versuschart
        • Waterfallchart
        • Score Card
        • Stacked Barchart
      • 🧠Common Chart Configuration
      • 💅Customizing chart colors
      • 🧞‍♂️Advanced chart configuration
        • Templating from chart's dataset
        • Add units, precisions and sentiments
        • Adding Tutorials
        • Add sparklines
        • Navigate with stories
        • Group informations in your stories
        • Multiple charts in one story
        • Manage dates
        • Customize tiles' sources
        • Add stars to tiles' title
        • Manage data order in your tiles
        • Navigate with tiles
    • 👩‍💻Embedding
      • 🔐Authentication
      • 🖇️Integration
        • Generate and manage embeds
        • Customize embeds
        • Embedding a Toucan App Using iFrames
        • Passing Extra Variables to Your Toucan Embed
      • ⚙️Embed SDK
        • Embed SDK Authentication
      • ❓FAQ
    • 🙋Self-Service
      • Self-Service Dashboard
      • Self-service PDF Report
  • Collaboration
    • ⏰Creating alerts
    • 📧Managing notifications
    • ➕Enriching a story with descriptions
    • 💌Sharing content
    • 💬Adding comments to stories
  • Administration
    • ⚙️Instance Management
      • ⚙️Managing operations in SaaS
      • ⚙️Customizing your instance (whitelabel)
    • 👥Managing Users
      • 👥Users
      • 👥Managing user groups
      • 👥Managing user properties
      • 👥Setting up permissions and visibilities
    • 🌐Managing languages in Toucan (internationalisation)
    • 📈Monitoring Engagement with User Analytics
      • 🎛️How to Filter your User Analytics?
      • 🖥️Understanding your User Analytics Dashboards
  • Additional Ressources
    • 📚External documentation
    • 🚁Support for App-builders
    • 🆕Latest releases
      • 🎁2025 Releases
      • 🎁2024 Releases
      • 🎁2023 Releases
    • 🔧Troubleshooting
      • Troubleshoot:: DataHub
      • Cross-Site Cookies
      • How to :: read the inspector error
      • How to :: troubleshoot the toucan way
Powered by GitBook
On this page

Was this helpful?

Last updated 6 months ago

Was this helpful?

🎯KPIs Definition

Active User

This section measures how many users are actively interacting with an app over a specified time period. An active user is defined as a user who has performed at least one interaction within the selected application and time period.

Engagement

This section measures user involvement by segmenting users based on their activity levels:

  • Power Users: The top 10% of users, representing the most engaged individuals. These are the highly active users who contribute significantly to the platform's success.

  • Core Users: User above the median level of activity, consisting of the moderately engaged users. This group represents the majority of your user base, who regularly use the platform but may not be as active as power users.

  • Casual Users: Users below the median, with lower engagement. These users engage less frequently and may represent an opportunity for re-engagement or improvement.

Retention

This section measures user activity over time by categorizing users into cohorts based on their previous behavior. These cohorts have been created using the Mixpanel guidelines for user segmentation, which helps you understand how users are returning, staying, or disengaging from your applications.

The four cohorts are:

  • Resurrected Users: These users were active in the period before the last one, became inactive in the last period, but have become active again in the current period. This group represents users who have re-engaged with the platform after a break.

  • Dormant Users: Users who were active in the previous period, but are not active in the current period. These users have disengaged recently and may need reactivation strategies.

  • Retained Users: These are users who were active in the previous period and have continued to be active in the current period. This group reflects consistent engagement over time.

  • New Active Users: These users were not active in the previous period or in period prior, but have become active in the current period. This represents completely new users or returning users who are engaging with the platform after a long absence.

🖥️ Dashboards

👤 Active user

Overview

The Active User Dashboard focuses on monitoring user activity levels over time. It tracks the total number of active users on a per-period basis. Additionally, leaderboards provide insights into top-performing app interactions.

KPIs:

  • Active Users: Total number of unique users who have had at least one interaction with the app during the selected period (daily, weekly, monthly).

  • Average Active Users per Period: The average number of active users calculated across different time frames, such as the last 30 days (for daily), 12 weeks (for weekly), or 12 months (for monthly).

Visualizations:

  • Barchart of Active Users by Period:

    • Displays the total number of active users for each period (daily, weekly, monthly).

    • The chart helps visualize activity trends, highlighting periods of high or low user activity. The number of bars in the chart depends on the period the user applies. Generally, it shows the last 12 months or weeks or the last 30 days.

  • Two Leaderboards:

    • Active Users by App:

      • Shows the number of active users per app.

      • Helps identify the applications that are the most used.

    • Active Users by Interactions:

      • Displays the number of active users per interaction type.

      • This leaderboard allows you to see which interactions are actively used and how your users consume data.

🔗 Engagement

Overview:

The engagement dashboard displays user cohort data based on the applied filters (see Filters section for details). It provides a breakdown of user activity levels (Power, Core, Casual) across different periods and labels. The dashboard is divided into two main sections: Number of Interactions and Average Engagement.

Data Interactions Section:

KPIs:

  • Data interactions: Number of interactions coming from all users

  • Power Users: Number of interactions coming from highly active users who engage with the app regularly (Top 10%).

  • Core Users: Number of interactions coming from users with moderate interaction (above median).

  • Casual Users: Number of interactions coming from users who engage with the app sporadically (below median).

Visualization:

  • Barchart of number of interactions over the time:

    • This chart displays the distribution of Power, Core, Casual, or All users across the selected time periods. You can adjust the distribution of users directly within the chart using the filter available.

    • The number of bars adjusts according to the period selected—whether it's the last 12 months, last 12 weeks, or last 30 days. Each bar represents the cohort count within that specific timeframe, offering a clear visualization of user engagement and activity over time.

Average Engagement Section:

KPIs:

  • Average Engagement: Average number of interactions per user within the period coming from all users

  • Power Users: Average number of interactions per user within the period coming from power users

  • Core Users: Average number of interactions per user within the period coming from core users

  • Casual Users: Average number of interactions per user within the period coming from casual users

Visualization:

  • Barchart of average engagement over the time: Similar to the cohort count chart but focused on average engagement. It shows how frequently users from each cohort engage with the app during the selected periods. This is particularly useful for tracking app usage. To increase usage (the number of interactions), you can either increase the number of users or increase the number of interactions per user.

🔄 Retention

Overview:

The Retention Dashboard focuses on understanding how well the app retains its users over time. It tracks key user cohorts such as new users, retained users, resurrected users, and dormant users. By analyzing these cohorts over different periods, this dashboard provides a clear view of user retention dynamics.

KPIs:

  • New Users: The number of users who signed up, started using after a while or used the app for the first time during the selected period.

  • Retained Users: Users who continue to use the app after their initial interaction.

  • Resurrected Users: Users who had previously become inactive but returned to the app during the selected period.

  • Dormant Users: Users who were once active but have not interacted with the app for a significant period.

Visualization:

  • Barchart of number of active users over the time:

    • Displays the breakdown of the four user cohorts (New, Retained, Resurrected, Dormant) over different time periods (daily, weekly, monthly). You can adjust the user categories directly within the chart using the available filter to select a cohort to analyze.

    • Each bar represents the number of users in each cohort for the selected period, plus you can specify the applications and the interactions you want to see (use the filter).

    • This chart allows you to compare how cohorts perform over time and identify patterns in user retention, churn, and re-engagement.

  1. Administration
  2. 📈Monitoring Engagement with User Analytics

🖥️Understanding your User Analytics Dashboards

  • 🎯KPIs Definition
  • 🖥️ Dashboards