top of page
Search

OnboardIQ: Funnel Analytics Dashboard

  • Blessing Okakwu
  • Apr 26
  • 6 min read

Overview

OnboardIQ is a funnel analytics dashboard built to give product and growth teams complete visibility into their user onboarding journey, from the moment a user starts, to every step they take, down to whether they complete or abandon the process entirely. It tracks events at each stage of the funnel, shows the drop-off rates, time-between-steps, channel performance, and individual user journeys. It also translates all of these into clear, actionable insight. The goal is simple: to give teams the full picture, not just the headline number.

The Problem

Most organisations measure outcomes. They know how many users signed up this month. They know how many activated. They know their headline conversion rate. What many do not know, with any precision, is what happened in between. This is more common than it sounds. Some teams rely entirely on third-party analytics tools that capture surface-level events but do not give them the granular, step-by-step visibility they need. Others track only the users who complete onboarding, the successes, and have little to no data on the users who dropped off, where exactly they left, or why. In some organisations, the data exists in different systems and nobody has connected the dots into a single coherent view.


The result is that decisions about onboarding, one of the highest-leverage areas in any product, are sometimes made with incomplete information. Teams know something is wrong. They can see it in their activation numbers. But without knowing where the problem lives, fixes are applied broadly and results are inconsistent. This is the gap OnboardIQ is built to close.


Why Event Tracking is the Foundation

Before any funnel dashboard can exist, there needs to be a consistent, deliberate approach to event tracking. Event tracking is the practice of recording specific user actions as they happen, account created, verification started, document uploaded, approval completed. Each of these is an event. When tracked properly, these events paint a precise picture of user behaviour across the entire journey. The keyword is properly. Many organisations track some events but not all. They might capture when a user completes onboarding but not when they abandon it. They might track desktop behaviour but miss mobile. They might record that a user reached a step but not when, which makes time-based analysis impossible.


Incomplete event tracking produces incomplete insight. If you only know that 40% of users completed onboarding, you know you have a problem. You do not know where the problem is concentrated, which users are most affected, or what to do about it. You are optimising blind. When event tracking is done well, every step, every channel, every user, with timestamps, it becomes one of the most powerful data assets a product team has. It turns conversion from a lagging indicator into something you can actually diagnose and improve in real time. OnboardIQ is built on top of that kind of tracking. Every event in the funnel is captured: when a user starts, when they move between steps, when they complete, and when they drop off. That data is what makes everything else possible.


What the Dashboard Does

The dashboard tracks users through a defined onboarding funnel, in this case, a bank account opening flow, and shows four layers of insight:


Step Analysis

This is the core view. It shows how many users enter each step of the funnel, how many move on, and how many drop off, with the exact number of users lost and the percentage that represents. Each step is classified as Healthy, Watch, or High Risk, so the team does not have to do mental arithmetic to know where to focus. A simple drop-off percentage tells you that users are leaving. Step analysis tells you exactly where they are leaving and how severe it is. That distinction is the difference between knowing you have a problem and knowing where to fix it.

Time Analysis

Drop-off rate is important. Time-to-complete is equally important and far less commonly tracked. If users are taking an average of 12 minutes to move from identity verification to document upload, that is a signal. It might mean the instructions between those steps are unclear. It might mean users need to retrieve a document they did not have ready and some do not come back. It might mean the form itself is too complex and users are pausing out of frustration. Time analysis shows these patterns. It shows the average, minimum, and maximum time users spend between each pair of steps, and flags the slowest transition in the funnel. This is the kind of detail that moves a team from "users are dropping off at document upload" to "users are stalling before document upload, let us look at what is happening in that transition."

Channel Breakdown

Not all users behave the same way. A user coming through the web has a different experience from a user on mobile. A user acquired through email behaves differently from one who came through a referral. The channel breakdown separates funnel performance by acquisition source. If web converts at 59% and mobile converts at 43%, that is not a funnel problem, it is a mobile experience problem. The fix for a poorly designed mobile document upload screen is completely different from the fix for a confusing approval step. Seeing performance by channel ensures the team is solving the right problem for the right audience.

User Drill-Down

Aggregate data tells you what is happening. Individual user data tells you who it is happening to and when. The user drill-down allows a team to filter users by status, completed, dropped mid-funnel, or dropped early, and see each user's journey: which channel they came from, which step they reached, how long the entire process took, and when they first appeared. This is where pattern recognition happens. When you can see that the users dropping at document upload are predominantly mobile users who started in the evening, you have a hypothesis worth testing. That hypothesis becomes an experiment. That experiment becomes an improvement.

How This Helps Teams

The value of a dashboard like OnboardIQ is not just in the data it shows, it is in the decisions it enables.

  • It tells teams where to spend their optimisation budget. Instead of running broad experiments across the entire funnel, teams can identify the single step with the highest drop-off and the highest opportunity, and focus there first. That focus compounds over time.

  • It separates symptoms from causes. A low overall conversion rate is a symptom. A 31% drop-off at the approval step among mobile users who take more than 15 minutes to reach that point, that is a cause, and it points directly at a solution.

  • It makes the cost of inaction visible. When you can see that 47 out of 100 users are not completing onboarding, and you can attribute a revenue value to each completed user, the business case for fixing the funnel becomes concrete rather than theoretical. That is a conversation that moves faster in any organisation.

  • It closes the feedback loop between product changes and user behaviour. When a team ships a change to the document upload step, they need to know within days, not months, whether it worked. Event-driven dashboards like this one make that feedback loop tight and reliable.


Why This Matters for Growth

Onboarding is the highest-leverage funnel in any product. It is the moment that determines whether an acquired user becomes an active user, and whether an active user becomes a retained one. Every improvement you make here has a ripple effect: as more users complete onboarding, more of them stay, more of them generate revenue, and fewer of them churn.


The data needed to make those improvements is almost always already there. It sits in event logs that nobody has pulled together into one clear view. What is usually missing is the skills to make that data readable and the analytical thinking to know what questions to ask of it. That is what this project is built around, not just displaying data, but making it easy for a team to see what is wrong, understand why, and know what to do next.

Demo Video

Tools used: FastAPI, PostgreSQL (Neon), Chart.js, Vercel Data: Simulated onboarding events across 100 users, web and mobile channels


 
 
 

Comments

bottom of page