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

Platform	Recommended Tool	Why
Shopify	Shopify Analytics + Polar Analytics or Triple Whale	Shopify's built-in analytics covers revenue, orders, and AOV; Polar/Triple Whale add profit margin, CAC, and multi-channel KPIs
Shopify (advanced)	Glew.io or Daasity	Pre-built ecommerce KPI dashboards with alerting and board-ready reporting
WooCommerce	Metorik + GA4	Metorik provides operational KPI dashboards; GA4 provides conversion funnel and traffic metrics
BigCommerce	Glew.io	Pre-built BigCommerce analytics with cohort analysis, margin tracking, and channel drill-down
All platforms	Google Looker Studio (free) connected to your data	Free; connects to Google Analytics, Google Sheets, BigQuery, and 1,000+ data sources; fully customizable
All platforms (BI teams)	Metabase (self-hosted, free) or Tableau	SQL-based; best when you have a data warehouse and a technical analyst

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:

KPI	Good Benchmark	Alert Threshold
Gross Revenue (MTD vs. prior month)	Varies by business	Alert if >20% below plan
Net Revenue (after discounts + refunds)	Gross revenue × 85–92%	Alert if discount rate > 15%
Gross Margin %	40–65% for branded DTC	Alert if drops >3pp below target
Orders (daily/weekly trend)	Varies	Alert if >20% below 7-day average
AOV (Average Order Value)	Varies	Alert if >10% below 30-day average
Customer Acquisition Cost (CAC)	Varies by channel	Alert if >20% above target CAC
Return/Refund Rate	<8% for most categories	Alert if >10% or trending up
Blended ROAS (total revenue / total ad spend)	3–6x for DTC	Alert if below break-even ROAS

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

Problem	Solution
Too many metrics at launch	Start with 8–10 core KPIs; expand only after the team trusts and uses the initial set
Different dashboards show different revenue numbers	Establish one tool as the single source of truth for each metric; document which tool to use for which question
Alert fatigue from too many notifications	Calibrate thresholds based on normal volatility; if alerts fire more than 3x per week, widen the thresholds
Missing data freshness indicator	Always show the "last updated" timestamp on dashboards; stale data mistaken for current data leads to wrong decisions
Dashboard loads too slowly	Pre-aggregate daily snapshot tables in your data warehouse; serve dashboards from snapshots, not live transaction queries

Related Skills

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