Financial Analytics Dashboard

Financial Analytics Dashboard

Overview

A financial analytics dashboard gives operators near-real-time visibility into the KPIs that matter most — revenue, gross margin, CAC, return rate — with drill-down, comparison baselines, and automated alerts when metrics breach thresholds. Unlike a static financial report, an analytics dashboard is designed for daily operational use: the finance team monitors it each morning, the marketing team checks ROAS after a campaign launch, and the CEO reviews the weekly summary before a board call.

This skill guides you through building a financial analytics dashboard using your platform's built-in tools, BI apps, and accounting integrations — without writing code.

When to Use This Skill

• When the finance team needs a daily operational dashboard showing current-month tracking
• When you want automated Slack or email alerts when KPIs breach thresholds
• When replacing manual weekly reporting emails with a live dashboard link
• When you need a self-service tool where non-finance stakeholders can explore metrics
• When building a board reporting dashboard that auto-refreshes with latest data
• When monitoring multiple revenue streams (DTC, marketplace, wholesale) on one screen

Core Instructions

Step 1: Choose your dashboard tool by platform

Step 2: Define your core KPI set

Keep the headline view to 8–10 metrics maximum. Dashboard fatigue is real — surfaces with 40+ metrics are ignored.

Recommended core KPIs for ecommerce operators:

Step 3: Set up the dashboard on your platform

Shopify

Shopify's built-in Analytics (no setup needed):

1. Go to Analytics → Overview — shows today's sales, sessions, conversion rate, and AOV with comparison to prior period
2. Go to Analytics → Dashboards — Shopify provides a customizable dashboard where you can add report tiles for revenue, traffic, products, customers
3. Go to Analytics → Reports for deeper drill-downs: sales by channel, by product, by location
4. Limitation: Shopify's built-in analytics does not include profit margin (unless cost per item is entered per product), ad spend, or CAC

Polar Analytics (recommended for financial KPI dashboards on Shopify):

1. Install Polar Analytics from the Shopify App Store
2. Connect your ad accounts (Meta, Google, TikTok) under Integrations
3. Go to Polar → Dashboard — pre-built KPI tiles for revenue, ROAS, CAC, MER (marketing efficiency ratio), and gross profit
4. Set up Alerts under Polar → Notifications: configure threshold alerts for CAC, ROAS, and revenue that send to email or Slack
5. Go to Polar → Reports for daily summary emails that can replace manual reporting

Triple Whale (Shopify DTC brands with $1M+ revenue):

1. Install Triple Whale from the Shopify App Store
2. Triple Whale's Summary Dashboard shows daily revenue, profit, ROAS, new customer CAC, and blended MER in a single view
3. Enable Daily Digest emails — sends a morning summary of yesterday's performance to the team
4. Set up Alerts in Triple Whale for threshold breaches (e.g., ROAS drops below 2.0x)

WooCommerce

Metorik (operational KPI dashboard):

1. Sign up at metorik.com and connect to your WooCommerce store
2. Metorik's Dashboard shows real-time revenue, orders, AOV, refund rate, and customer count with period comparisons
3. Go to Metorik → Reports → Summary for a daily/weekly KPI summary
4. Enable Metorik Digest emails — sends automated daily or weekly KPI summary emails to stakeholders
5. Use Metorik Alerts to receive email notifications when revenue, orders, or refunds breach thresholds

Google Looker Studio (free, flexible):

1. Go to lookerstudio.google.com
2. Add data sources: Google Analytics 4 (for traffic/conversion data) + Google Sheets (for manual P&L imports from WooCommerce)
3. Build a dashboard with KPI scorecards, trend lines, and channel comparison tables
4. Share the dashboard URL with stakeholders — auto-refreshes with latest data

BigCommerce

1. BigCommerce Analytics (built-in): Go to Analytics → Store Overview for revenue, orders, conversion rate, and customer metrics; available on all plans
2. Glew.io (BigCommerce App Marketplace): Install for advanced financial KPI dashboards with cohort analysis, margin tracking by product/channel, and automated weekly executive digest emails
3. Google Looker Studio: Connect BigCommerce to Looker Studio via Stitch (data pipeline) → BigQuery → Looker Studio for a fully custom financial analytics dashboard

Step 4: Configure variance explanations and drill-down

A dashboard that shows numbers without context is just wallpaper. Set up these comparison views:

Period-over-period comparisons:

• Every KPI tile should show the current value AND the % change vs. prior period (prior week, prior month, prior year same period)
• Configure this in Polar Analytics or Triple Whale under Dashboard Settings → Comparison period

Channel drill-down:

• In Shopify Analytics: Go to Reports → Sales by traffic source — shows revenue by UTM channel
• In Metorik: Go to Reports → UTM — shows orders and revenue by UTM source/medium
• In Polar Analytics: Go to Channel Mix — shows revenue, orders, and ROAS by acquisition channel with trend

Root cause workflow: When a metric drops significantly, follow this investigation chain:

1. Is total revenue down or is one channel down? → Check channel drill-down
2. Is order volume down or AOV down? → Check Orders vs. AOV trend
3. Is it a traffic problem or a conversion problem? → Check sessions vs. CVR in GA4
4. Is it affecting all products or specific SKUs? → Check product-level reports

Step 5: Set up automated alerts

Automated alerts ensure you find out about problems before customers do.

Shopify + Polar Analytics:

1. Go to Polar → Alerts → Create Alert
2. Set thresholds: e.g., "Alert me when ROAS drops below 1.5" or "Alert me when daily revenue is 30% below 7-day average"
3. Choose delivery: email, Slack, or in-app notification

Shopify + Triple Whale:

1. Go to Triple Whale → Alerts
2. Create alert rules for key metrics with absolute or percentage thresholds
3. Triple Whale's Moby AI can also proactively flag anomalies and explain them in natural language

Any platform using Google Looker Studio:

• Connect Looker Studio to Google Sheets with a trigger that runs a daily data pull
• Use Google Apps Script with sendEmail() to send alerts when cells exceed thresholds
• Alternatively, set up Data Studio alerts (Looker Studio has a basic alert feature)

For Slack-based alerting (all platforms):

• Connect your platform to Slack via Zapier — create a Zap that runs daily and sends a Slack message to #analytics with key metric values

Best Practices

• Keep the top-level view to 8 metrics or fewer — the headline view should surface only the most important metrics; depth should be accessible via drill-down, not displayed all at once
• Show both absolute and percentage changes — a 5% improvement from $1M to $1.05M matters more than a 5% improvement from $1K to $1.05K; show both
• Build a mobile-first KPI summary — DTC founders check key metrics from their phone every morning; ensure your dashboard is readable on mobile or use Triple Whale/Polar Analytics which are mobile-optimized
• Log all alert history — keep a record of every alert that fired with the metric value and timestamp; this audit trail is valuable for post-mortems
• Build a commentary layer — when a metric moves significantly, require the responsible team to add a one-line explanation in a shared Notion page or Slack channel; creates institutional memory of business events
• Calibrate alert thresholds based on historical volatility — for a metric that normally fluctuates ±8%, a warning threshold of ±5% generates noise; start with ±20% for warning and ±35% for critical

Common Pitfalls

Related Skills

• @financial-reporting-dashboard
• @sales-reporting-dashboard
• @marketing-spend-analysis
• @ecommerce-budgeting-forecasting
• @profit-margin-analysis