Building a Revenue Analytics Dashboard for Your Store

Why You Need a Revenue Dashboard

Your store generates data from multiple sources: Stripe for payments, Meta or TikTok for ads, Google Analytics for traffic, and your supplier for product costs. Without a centralized dashboard, you are constantly switching between tabs trying to piece together the full picture.

A revenue dashboard puts everything in one place. At a glance, you can see whether today was profitable, which campaigns are performing, and whether trends are moving in the right direction.

What Your Dashboard Should Track

Daily Metrics

Gross Revenue: Total sales for the day
Number of Orders: How many transactions completed
Average Order Value: Revenue divided by orders
Refunds: Money returned to customers
Net Revenue: Gross revenue minus refunds

Cost Metrics

Product Costs (COGS): What you paid suppliers for fulfilled orders
Ad Spend: Total advertising spend across all platforms
Payment Processing Fees: Stripe fees (typically 2.9% + $0.30 per transaction)
Platform Fees: Monthly subscription costs prorated daily

Profit Metrics

Gross Profit: Net revenue minus product costs
Net Profit: Gross profit minus ad spend, fees, and all other costs
Profit Margin: Net profit as a percentage of net revenue
ROAS: Revenue divided by ad spend

Trend Metrics

7-day rolling average revenue: Smooths out daily fluctuations
Week-over-week growth: Comparing this week to last week
Month-to-date totals: Running totals for the current month

Building Your Dashboard in Google Sheets

Google Sheets is the best starting point for most store owners. It is free, accessible from anywhere, and powerful enough for comprehensive analytics.

Tab 1: Daily Data Entry

Create columns for each daily metric. Each row is one day. Input data daily, ideally at the same time each morning for the previous day.

Columns:

Date
Gross Revenue
Number of Orders
Refunds
Product Costs
Ad Spend (Facebook)
Ad Spend (TikTok)
Ad Spend (Google)
Stripe Fees

Calculated columns (use formulas):

Net Revenue = Gross Revenue - Refunds
AOV = Net Revenue / Number of Orders
Gross Profit = Net Revenue - Product Costs
Total Ad Spend = Sum of all ad platform spend
Net Profit = Gross Profit - Total Ad Spend - Stripe Fees
Profit Margin = Net Profit / Net Revenue
ROAS = Net Revenue / Total Ad Spend

Tab 2: Weekly Summary

Use SUMIFS formulas to aggregate daily data into weekly summaries. This tab should auto-populate from Tab 1.

Tab 3: Monthly Summary

Same approach, aggregated by month. Include month-over-month growth calculations.

Tab 4: Charts

Create visual charts from your data:

Revenue trend line: Daily revenue over the past 30 days
Profit trend line: Daily profit over the past 30 days
ROAS trend line: How efficiently your ad spend converts to revenue
Revenue breakdown pie chart: Revenue by traffic source

Charts make patterns visible that numbers alone hide.

Data Sources and How to Extract Them

Stripe Dashboard

Stripe provides daily revenue, transaction count, refund data, and fees. You can export CSV files from the Stripe dashboard for any date range.

Automation tip: Stripe has an API and supports webhooks. For advanced users, you can automate daily data export into your spreadsheet using Google Apps Script.

Meta Ads Manager

Export daily ad spend, impressions, clicks, and conversions from Meta Ads Manager. Use the "Export" button on your campaigns view.

Key columns to export: Date, Amount Spent, Purchases, Purchase Value, Link Clicks, CTR

Google Analytics

Export session data, conversion rates, and traffic source breakdowns. GA4 allows scheduled email exports of custom reports.

Supplier Costs

Track product costs per order. For dropshipping, this is the amount you pay AliExpress per order. Keep a reference table of product costs and multiply by order quantities.

Interpreting Your Dashboard

Healthy Signs

ROAS consistently above 3.0x
Profit margin above 15%
Revenue trend line moving upward
Refund rate below 5%
AOV stable or increasing

Warning Signs

ROAS declining over time (ad fatigue or increasing competition)
Profit margin below 10% (costs growing faster than revenue)
Spike in refunds (product quality issue or expectation mismatch)
AOV declining (lower-value products converting more)
Revenue growth stalling while ad spend increases (diminishing returns)

Action Triggers

Set thresholds that trigger action:

ROAS drops below 2.5x for 3 consecutive days: pause underperforming ad sets
Refund rate exceeds 8% in a week: investigate product quality
Daily profit goes negative for 2 consecutive days: review all active campaigns
AOV drops below target: evaluate pricing and upsell strategy

Graduating to Advanced Tools

As your store grows beyond $10,000 per month in revenue, consider upgrading from spreadsheets:

Looker Studio (free): Connects directly to Google Analytics and Google Sheets for automated dashboards
Triple Whale: E-commerce analytics platform with Shopify integration ($100+/month)
Hyros: Advanced attribution tracking for high-spending advertisers ($200+/month)

For most stores under $10K/month, Google Sheets is more than sufficient.

Key Takeaways

A revenue dashboard centralizes data from multiple sources into one view
Track daily: revenue, orders, AOV, costs, and profit for complete visibility
Google Sheets is the best free starting point and sufficient for most stores
Update your dashboard daily at the same time for consistent tracking
Set action triggers at specific thresholds so you respond to problems quickly
Charts reveal trends that raw numbers obscure
Graduate to advanced tools when revenue exceeds $10K/month