Frido Sales Command
Data window —
Frido Sales Command
Loading live data…
Connecting to Google Sheet
Discount-Code Performance · Executive Review

Two codes, one question:
what changed before vs after 30 April?

Interactive review of the GAJENDER & BOOK1A discount codes across the full order book. Every card, chart and ranking below responds to the slicers.

Showing — order-lines
01

Executive KPIs

Headline totals for the current selection. Deltas compare the two halves of the period, split at 30 Apr 2026.

02

Month-on-Month trend

Revenue & volume trajectory with MoM growth. Partial months are flagged with ★.

Monthly trajectory
Revenue bars · AOV line overlay
MoM detail & growth
Monthly averages shown in the footer row.
03

Before vs After · 30 April 2026

The two halves run at different lengths (154 vs 80 days). Switch to “per day” for a fair, length-adjusted read.

Period comparison
Choose how to read the two halves
Before—
30 Apr
cut-off
After—
04

Top gainers & decliners after 30 April

Change in product revenue, After minus Before. Reflects the current filter selection.

▲ Top gainers
Biggest revenue uplift after the cut-off
▼ Top decliners
Biggest revenue fall after the cut-off
05

Discount code head-to-head

GAJENDER is the flagship code across the full window; BOOK1A launched mid-May.

Revenue contribution
Share of total revenue in the current selection
Metric-by-metric comparison
Normalised to 100% of the larger value per metric
06

Product & SKU rankings

Sort by revenue or quantity, ascending or descending.

07

Executive insights & actions

Computed live from the current sheet contents — refreshes with the data.

Live data & method. This dashboard reads a published Google Sheet (CSV) at load time and again whenever you press Refresh — every KPI, chart, ranking and insight recomputes from the current sheet contents. Cleaning is applied in-browser: headers are auto-detected, text fields trimmed & discount codes upper-cased, numbers and %/decimal discounts parsed, dates parsed across formats to a real calendar, exact duplicates and non-positive-revenue rows dropped, and AOV re-derived as Revenue ÷ Orders for integrity. Weighted discount is revenue-weighted across lines. The “before/after” split places 30 Apr 2026 in the Before half (After begins 1 May). The two halves usually differ in length, so the Per-day toggle gives the fair, length-adjusted comparison. The first/last calendar months are auto-flagged ★ when partial.