Revenue & Product Analytics Dashboard

Farm House Blends & Cigarbandz β€” built from current workbook data
Data last refreshed: Tuesday, May 19, 2026 at 11:01 PM (local time)
Total Revenue
$0
Orders
0
Average Order Value
$0
Across all sources
Top-Selling Product
β€”

Focus Insights

Daily Sales Summary

Today
$0
Yesterday
$0
Selected Range
$0
Daily Average
$0
Show daily table
DateOrdersRevenue

Monthly Revenue Trend

Revenue by Source

Top 12 Products by Revenue

Top 12 Products by Units

Revenue by Payment Processor

Top 15 Customers (by revenue)

CustomerOrdersRevenue

Customer Lifetime Value (2025 + 2026 combined)

Each customer is identified by email (or name when no email). Revenue and orders are summed across both years. Switch the business above to update.
Customers
0
Average LTV
$0
Revenue per customer
Median LTV
$0
Half above, half below
Repeat Rate
0%

LTV Distribution (count of customers)

Customer Segmentation

Top 20 Customers by LTV

CustomerOrders LTVAOV First β†’ Last OrderTop Product

Sales Team Performance

Initials parsed from invoice numbers (e.g., INV-12345 (NSP)). Edit sales_rep_names.json to map initials to full names.
Sales Rep Initials Business Invoices Revenue Avg Invoice $ Top product sold

Full Product Performance Table

Click a column header to sort. Product names lightly normalized (batch suffixes like "#1" stripped).
Product (SKU) Revenue Units Orders AOV Avg Unit $
Total Commission Owed
$0
Reps with Earnings
0
Invoices Closed
0
Gross Revenue (this month)
$0
From invoices with rep initials

Monthly Commission Payout

Per-invoice commission entry. Expand a rep row, then type the commission amount for each individual invoice into the Commission column. The rep total updates automatically as you type; the month total at the top updates as you go. Use the Approval column to approve or reject a rep's commission, and Status to mark as Paid once sent. Changes save to this browser only (per-device).
Sales Rep Initials Invoices Gross Revenue Commissionable Commission Approval Status

Sales Rep Performance Over Time

Monthly gross revenue from invoices closed by this rep.
Total Gross (all months)
$0
Active Months
0
Average Month
$0
Avg gross per active month
Best Month
β€”

Customer Insights β€” Internal Management Tool

Heuristic patterns from order history; review before acting on for B2B accounts.
⚠ Commission gating policy β€” invoices over 100 days old
Any invoice older than 100 days must be resolved before that sales rep's commission can be approved for payment. For each aged invoice the seller must either: Void β†— it in GHL (customer is not paying), or Mark Waiting ⏳ it (customer confirmed they will pay).
All unpaid GHL invoices (status: sent / draft / viewed / partially_paid) across both businesses, ranked by amount due. Click Void β†— on any row to void it directly in GHL.
Issued Customer Business Invoice # Description Amount Due Status Age Action