Products Solutions Templates Pricing Resources

Interactive dashboards and drill-down: exploring data without leaving the dashboard

Home / Everything About / Everything About Analytics / Interactive dashboards and drill-down: exploring data without leaving the dashboard

Static dashboard shows one view. Interactive dashboard lets user explore.

Static: revenue is five hundred thousand. That is all user sees.

Interactive: revenue is five hundred thousand (user sees). User clicks on revenue. Dashboard shows revenue by channel. Paid search: one hundred twenty thousand. Organic: one hundred eighty thousand. Email: two hundred thousand. Affiliate: zero thousand. User sees breakdown without loading new page.

Drill-down capability answers user's next question without leaving dashboard.

When to use drill-down

Good use case

Metric has natural breakdown. Revenue breaks down by channel, by product, by geography, by customer segment. User wants to investigate. Example: conversion rate is two percent (yellow, below target). User wants to know which pages are below target. Clicks conversion rate. Dashboard shows conversion rate by page. Landing page: four percent (good). Product page: two percent (good). Checkout page: one point five percent (bad). Problem is checkout.

Bad use case

Breakdown is not useful. Example: page views drill-down into browser type. Why would user care. Drill-down should reveal actionable breakdown.

How to implement drill-down

Click metric to expand

User clicks on revenue number. Dropdown appears showing channels. User selects channel. Revenue filter is applied. Rest of dashboard updates to show only selected channel.

Breadcrumb trail

User drills from revenue to paid search to Google Ads to specific keyword. Breadcrumb shows path. User can click on any breadcrumb to go back.

Multiple views

Dashboard has toggle: toggle between revenue total view and revenue by channel view. One button press switches views. No clicking individual metrics.

Persistent filters

User selects date range. All dashboard metrics update to date range. User selects customer segment. All metrics update to segment. Filters are persistent as user explores.

Real example: SaaS interactive dashboard

Headline metric

ARR (annual recurring revenue) five point one million.

User investigates

User looks at ARR. Thinks: is this healthy. Compares to goal (five point five million). Red indicator shows below goal. User wants to know why.

User clicks on ARR number. Dashboard expands to show ARR drivers: new customers (twenty per month), churn (two percent monthly), expansion revenue (one thousand per customer).

New customers is below target (twenty vs twenty-five). User clicks on new customers. Dashboard shows breakdown: sales channel (twelve customers), self-serve channel (eight customers). Sales channel is below target (twelve vs fifteen).

User clicks on sales channel. Dashboard shows breakdown by account type: enterprise (four deals at one hundred thousand each equals four hundred thousand), mid-market (five deals at thirty thousand each equals one hundred fifty thousand), self-serve (three deals at five thousand each equals fifteen thousand). Enterprise is on track. Mid-market is below target (five vs eight deals).

Insight gained

User now knows: revenue is below goal because new customer acquisition is below target because mid-market sales are below target. Action: focus on closing more mid-market deals.

All of this exploration happened in one dashboard through drill-down. Without drill-down, user would need to manually create new reports or visit multiple dashboards.

Real example: e-commerce interactive dashboard

Initial view

Headline metric: revenue five hundred thousand.

User investigates conversion rate

User scans supporting metrics. Conversion rate is two percent (yellow, below target of two point five percent).

User clicks on conversion rate. Dashboard expands to show conversion rate by page: Homepage: five percent (good). Product page: three point five percent (good). Checkout page: one point two percent (bad). Thank you page: ninety-eight percent (not relevant, everyone who reaches this page has bought).

Problem is checkout page. User clicks on checkout page. Dashboard shows conversion rate by device: Desktop: two percent. Mobile: zero point five percent (bad). Tablet: one point five percent.

Mobile checkout conversion is very low. User clicks on mobile. Dashboard shows checkout step breakdown: Cart review: ninety percent complete (proceed to shipping). Shipping selection: seventy percent complete (proceed to payment). Payment info: thirty percent complete (proceed to review). Order review: ninety percent complete (complete purchase).

Problem identified

Problem is shipping selection step (only seventy percent proceed to payment). Shipping selection is friction point on mobile.

Action taken

User now knows: revenue is below target because conversion is low because mobile checkout has high abandonment at shipping selection step. Action: simplify shipping selection on mobile.