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](https://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](https://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