# Revenue Leakage Diagnostic Report — HavenHome Living **Business:** HavenHome Living (fictional Shopify store, home accessories) **Report type:** Preliminary diagnostic — business analysis, not an audited financial finding, and not individualized legal or tax advice **Evidence standard:** Only the figures supplied are treated as facts. No losses, conversion rates, churn rates, or benchmarks have been invented. Where data is missing, this report provides formulas and data requests instead of numbers. --- ## 🏢 1. BUSINESS REVENUE OVERVIEW | Element | Detail | |---|---| | **Business model** | Direct-to-consumer e-commerce on Shopify | | **Main products** | Home accessories (category/SKU detail not supplied) | | **Revenue streams** | One-time online purchases only (no subscriptions, no renewals) | | **Pricing structure** | List prices plus frequent promotional discounts (discount types, depth, and codes not supplied) | | **Sales channels** | Single storefront; traffic from social media, email marketing, organic search | | **Customer segments** | Not defined or supplied | | **Operational constraints** | $150/month tooling budget; ~5 hours/week of analysis and implementation time; small team | ### Known financial metrics (as supplied) | Metric | Value | Check | |---|---|---| | Average monthly sales revenue | $28,000 | — | | Completed orders per month | ~400 | — | | Average order value (AOV) | $70 | 400 × $70 = $28,000 ✔ internally consistent | > **Definition note:** It is not stated whether the $28,000 is gross sales, net of discounts, or net of refunds. This must be confirmed first (see Missing Information), because every later calculation depends on it. ### Primary revenue concerns (as reported) 1. Promotional discounts used often, profitability never analyzed 2. Promotion tracking is inconsistent 3. Low visibility into repeat purchases 4. Abandoned checkouts recorded but not reviewed 5. Occasional refund requests, not analyzed 6. No verified financial loss estimates exist ### Missing information requiring verification | # | Missing item | Why it matters | |---|---|---| | 1 | Whether $28,000 is gross, net of discounts, or net of refunds | Defines the revenue baseline | | 2 | Monthly discount dollars and % of orders using a discount | Core of the discount analysis | | 3 | Gross margin / COGS by product | Needed to judge whether discounts are profitable | | 4 | Sessions, add-to-cart, checkout-started counts | Needed for funnel rates | | 5 | Abandoned checkout count and value; recovery-email status | Sizing checkout exposure | | 6 | Refund count, value, and reasons | Separates avoidable from ordinary refunds | | 7 | New vs. returning customer split | Repeat purchase visibility | | 8 | Payment gateway fees, chargebacks, failed payments | Reconciliation | | 9 | Stock-out / out-of-stock data | Lost-sale exposure | | 10 | Shipping charge collection vs. shipping cost | Possible shipping margin gap (cost issue, not revenue leakage) | --- ## 🔍 2. REVENUE LEAKAGE DIAGNOSTIC SUMMARY **Status key:** **Confirmed** = evidence supports it exists. **Suspected** = plausible, indirect evidence. **Insufficient Data** = cannot be assessed yet. > **Important:** Nothing below is a *confirmed financial loss*. The only confirmed items are **process and visibility gaps** the business itself reported. Whether those gaps are causing quantifiable losses is unverified. | Category | Potential issue | Supporting evidence | Status | Possible business impact | Required validation | Initial recommendation | |---|---|---|---|---|---|---| | **Pricing & discounts** | Discounts given without profitability review; inconsistent tracking | Owner states discounts are "frequently used," unanalyzed, inconsistently tracked | **Confirmed** (tracking gap) / **Suspected** (margin erosion) | Possible margin erosion; discounts given to customers who would have bought at full price | Discount report by code; margin by order; compare discounted vs. non-discounted AOV | Build a discount ledger in Shopify reports + spreadsheet | | **Sales conversion** | Checkout abandonment unreviewed | Abandoned checkouts recorded but not reviewed | **Confirmed** (not reviewed) / **Insufficient Data** (size) | Potential unrealized revenue (opportunity, not realized loss) | Abandoned checkout count/value; recovery email settings | Audit abandoned-checkout recovery setup; sample reasons | | **Lead follow-up** | No sales team; "leads" = email subscribers and carts | N/A for one-time e-commerce beyond abandoned cart/email flows | **Insufficient Data** | Unknown | Review automated flows (welcome, cart, browse) | Verify flows exist and fire | | **Customer retention** | Repeat purchase behavior not visible | Owner reports low repeat-purchase visibility | **Confirmed** (visibility gap) | Unknown repeat revenue potential | Repeat purchase rate from Shopify customer data | Run first-pass cohort report | | **Billing & invoicing** | Not applicable in the usual sense (card payments at checkout) | Checkout-based model | **Insufficient Data** | Low unless draft/manual orders are used | Confirm no manual/draft orders or wholesale invoices | Confirm and close out | | **Payment collection** | Failed payments, chargebacks, payout shortfalls | None supplied | **Insufficient Data** | Possible small cash/reconciliation differences | Compare Shopify orders to gateway payouts | Monthly payout reconciliation | | **Refunds & returns** | Refund drivers unknown | "Occasional refund requests" | **Insufficient Data** (rate) | Possible preventable refunds (wrong item, damage, description mismatch) | Refund log with reason codes | Start reason-coded refund log | | **Subscription / renewal** | Not applicable | Business is one-time purchase only | **Not applicable** | — | — | Not applicable; see repeat-purchase section instead | | **Upsell / cross-sell** | Bundles, add-ons, thresholds possibly unused | None supplied | **Insufficient Data** | Growth opportunity (not leakage) | Product-pair data from orders | Treat as growth experiment, not leakage | | **Operational handoffs** | Order/fulfillment errors, inventory sync | None supplied | **Insufficient Data** | Possible lost sales, refunds, reshipments | Error log, stock-out dates | Light error log | | **Reporting & reconciliation** | Revenue figures not defined or reconciled; promo tracking inconsistent | Inconsistent promotion tracking; no verified loss estimates | **Confirmed** (control gap) | Cannot measure leakage without it | Define "revenue" once; monthly reconcile Shopify ↔ gateway ↔ accounting | **Highest-priority foundation fix** | --- ## 💰 3. PRICING AND DISCOUNT ANALYSIS ### Evaluation | Area | Assessment | Evidence status | |---|---|---| | **Pricing consistency** | Cannot assess; no price list or change history supplied | Insufficient Data | | **Unapproved discounts** | Possible, given inconsistent promo tracking (e.g., stray codes, stacked codes, expired codes still active) | Suspected | | **Promotional effectiveness** | Unknown; no incrementality data. Cannot tell whether discounts drive *new* orders or subsidize orders that would have happened anyway | Insufficient Data | | **Margin implications** | Unknown; COGS, shipping, and fees not supplied | Insufficient Data | | **Underpricing indicators** | **No evidence** that prices are too low; do not conclude this without margin and elasticity data | Insufficient Data | | **Package structure** | Unknown; bundles/free-shipping thresholds not described | Insufficient Data | | **Pricing communication** | Unknown; check consistency between ads, emails, product pages, and checkout | Insufficient Data | | **Contractual pricing differences** | Not applicable (B2C, one-time purchases) unless wholesale exists | Not applicable | | **Manual pricing errors** | Possible in manual edits, imports, or sale-price scheduling | Suspected | ### Discount investigation steps | Step | Action | Output | |---|---|---| | 1 | Export all orders for the last 3 months with discount code, discount amount, subtotal, shipping, refund status | Order-level dataset | | 2 | Group by discount code and discount type (percent, fixed, free shipping, automatic) | Discount ledger | | 3 | Compare AOV, units per order, and new vs. returning mix: discounted vs. non-discounted | Preliminary effectiveness view | | 4 | Add unit costs for top products; compute margin after discount, shipping, and fees | Contribution margin per order | | 5 | Flag: stacked discounts, codes with no owner/purpose, codes still active after campaign end, discounts on already-reduced items | Exceptions list | | 6 | Classify each code: **Acquisition**, **Re-engagement**, **Clearance**, **Recovery**, or **Unknown** | Purpose tagging | ### Improvement options (to evaluate, not to assume) - Define a small standard promotion calendar with owners, start/end dates, and goals - Set a **minimum margin floor** below which no promotion is approved - Prefer structures that protect margin (e.g., spend thresholds, bundles) *only after* testing against current approach - Keep discount terms **transparent**; no hidden fees, fake "was" prices, or misleading urgency --- ## 🛒 4. SALES FUNNEL AND CONVERSION REVIEW HavenHome has no sales team, so the funnel is: **Traffic → Product view → Add to cart → Checkout started → Payment completed**. | Stage | Where customers may disengage | Evidence that would confirm | Status | |---|---|---|---| | **Lead capture** | Email signup friction or weak offer; no capture on social traffic | Signup rate by source; popup/form placement | Insufficient Data | | **Lead qualification** | Not relevant as a manual process; segmentation by source/interest may be missing | List segmentation in email tool | Insufficient Data | | **Response time** | Slow answers to pre-purchase questions (sizing, shipping, availability) | Support inbox response times; pre-sale question volume | Insufficient Data | | **Follow-up consistency** | Cart-recovery and browse-abandonment emails absent, delayed, or untested | Flow list, send times, open/click/recovery numbers | Insufficient Data | | **Quote/proposal delivery** | Not applicable | — | Not applicable | | **Checkout completion** | Unexpected shipping costs, limited payment methods, forced account creation, discount-code friction, errors | Checkout-step drop-off; reasons from sampled abandoned checkouts; shipping-cost reveal timing | **Confirmed** (abandonment recorded but unreviewed); size unknown | | **Sales handoffs** | Not applicable beyond order → fulfillment | — | Not applicable | | **Customer objections** | Shipping time/cost, return policy clarity, trust, product details | Support tickets, reviews, exit survey, social comments | Insufficient Data | | **Lost opportunity tracking** | No systematic review of abandoned checkouts; stock-outs possibly not tracked | Abandoned checkout log; "back in stock" requests | **Confirmed** (not tracked); size unknown | > **Important distinction:** Abandoned checkouts are **unrealized opportunities**, not lost revenue. Many abandoners were never going to buy (price checking, browsing, accidental starts). Do not treat total abandoned cart value as leakage. --- ## 🔄 5. CUSTOMER RETENTION AND REPEAT REVENUE | Area | Observation | Preventable vs. customer decision | Status | |---|---|---|---| | **Onboarding** (post-purchase experience) | Unknown: order confirmation, shipping updates, care/usage content | Preventable process gap if missing | Insufficient Data | | **Service delivery consistency** | Unknown: late shipments, damage, wrong items | Largely preventable | Insufficient Data | | **Repeat purchase behavior** | Not visible to the team | Visibility gap is preventable; repeat rate itself depends on product type (home accessories may be naturally low-frequency) | **Confirmed** (visibility); rate unknown | | **Renewal/subscription** | Not applicable | — | Not applicable | | **Complaints** | Not tracked or not reported | Mixed | Insufficient Data | | **Support responsiveness** | Unknown | Preventable | Insufficient Data | | **Re-engagement** | Unknown whether post-purchase or win-back emails exist | Preventable gap if absent | Insufficient Data | | **Customer feedback** | No review/survey process described | Preventable gap | Insufficient Data | | **Loyalty** | None mentioned | Optional; evaluate only after baseline repeat rate is known | Insufficient Data | **Caution:** Not all non-repeat customers represent leakage. Gifts, one-off decor purchases, and moving/seasonal buyers may be unlikely to return regardless of service quality. The goal is **visibility first**, then targeted improvement. --- ## 🧾 6. BILLING, INVOICING, AND COLLECTIONS REVIEW Because payment is collected at checkout, classic billing leakage (unbilled work, unpaid invoices) is mostly **not applicable**. Remaining relevant items concern **payment reconciliation**. | Area | Relevance | Status | Validation | |---|---|---|---| | Invoice accuracy | Low (order confirmations only) | Insufficient Data | Spot-check 20 orders: items, tax, shipping, discount | | Invoice timing | Not applicable | — | — | | Unbilled completed work | Not applicable | — | — | | Missing invoice follow-ups | Not applicable unless B2B/draft orders exist | Insufficient Data | Confirm no draft/manual orders | | Failed payments | Failed or declined checkout payments may overlap with checkout abandonment | Insufficient Data | Review payment-failure/decline data in Shopify and gateway | | Payment reconciliation | Shopify orders vs. gateway payouts vs. bank/accounting | Insufficient Data | Monthly three-way reconciliation | | Billing disputes / chargebacks | Possible; reduces collected cash | Insufficient Data | Chargeback count and value | | Subscription failures | Not applicable | — | — | | Contract-to-invoice consistency | Not applicable | — | — | **Separate clearly:** | Concept | Treatment | |---|---| | **Cash timing delays** (payout schedules, holds) | Cash flow issue, not lost revenue | | **Gateway/processing fees** | Cost, not revenue leakage | | **Chargebacks and fraud** | Real revenue loss when lost, tracked separately | | **Refunds** | Revenue reduction; judge avoidable vs. ordinary (Section 7) | --- ## ⚙️ 7. OPERATIONAL REVENUE LEAKAGE | Operational issue | Link to potential revenue impact | Status | Note | |---|---|---|---| | **Manual data entry errors** (prices, promo setup, inventory counts) | Wrong prices or unintended discounts reduce realized revenue | Suspected | Most relevant to promo configuration | | **Missed handoffs** (order → fulfillment → shipping notice) | Delays raise refund/cancellation rates | Insufficient Data | — | | **Untracked additional work** | Not applicable | — | — | | **Inconsistent service delivery** | Complaints, refunds, lower repeat rate | Insufficient Data | — | | **Order processing errors** (wrong item, address errors) | Reshipment cost (**cost**, not revenue leakage) plus possible refund (**revenue reduction**) | Insufficient Data | Do not double-count | | **Inventory availability** | Stock-outs on popular items can prevent sales (**unrealized opportunity**) | Insufficient Data | Overselling can cause cancellations/refunds | | **Customer support delays** | Pre-sale unanswered questions → lost sales; post-sale delays → refunds/disputes | Insufficient Data | — | | **Duplicate work** | Staff time cost (**cost inefficiency**), not revenue leakage | Insufficient Data | Relevant to the 5-hour weekly constraint | | **Missing reporting controls** | No ability to detect leakage | **Confirmed** | Root enabler of other issues | ### Refund analysis note - Refund requests are described as "occasional." No rate is known. - Split refunds into **avoidable** (wrong item, damaged in transit, misleading description, late delivery) and **ordinary** (change of mind, within-policy returns). Only the first group is a process-improvement target. - Refunds are **revenue reductions** and should be reported separately from discounts and from shipping/reshipment costs to avoid double-counting. --- ## 📊 8. REVENUE LEAKAGE PRIORITY SCORECARD ### Scoring framework Each issue is scored **1–5** on five criteria. Higher is always better for prioritization. | Criterion | Weight | Scale meaning | |---|---|---| | **Potential financial materiality** | 30% | 1 = likely very small; 5 = likely large relative to $28,000/month *(judgment only, not a loss estimate)* | | **Evidence strength** | 20% | 1 = no evidence; 3 = indirect; 5 = verified data | | **Implementation feasibility** | 20% | 1 = hard with current budget/team; 5 = easy with existing tools | | **Time to investigate/address** | 15% | 1 = months; 5 = days | | **Operational and customer risk (low risk = high score)** | 15% | 1 = high risk to customers or operations; 5 = very low risk | **Weighted score = (M × 0.30) + (E × 0.20) + (F × 0.20) + (T × 0.15) + (R × 0.15)** > ⚠️ **All scores below are preliminary judgments based on limited information. A priority score is not a financial loss estimate.** ### Ranked issues | Rank | ID | Issue | Materiality | Evidence | Feasibility | Time | Risk (low=high) | **Weighted score** | |---|---|---|---|---|---|---|---|---| | 1 | I5 | Inconsistent promotion tracking and no revenue reconciliation | 3 | 4 | 5 | 5 | 5 | **4.20** | | 2 | I2 | Unreviewed checkout abandonment | 4 | 2 | 4 | 4 | 5 | **3.75** | | 3 | I1 | Unanalyzed discount profitability | 4 | 2 | 4 | 4 | 4 | **3.60** | | 4 | I3 | Low repeat-purchase visibility | 3 | 2 | 4 | 4 | 5 | **3.45** | | 5 | I4 | Refund causes unanalyzed | 2 | 2 | 4 | 4 | 4 | **3.00** | | 6 | I8 | Payment/payout reconciliation unverified | 2 | 1 | 4 | 4 | 4 | **2.80** | | 7 | I6 | Post-purchase email / cross-sell not assessed | 3 | 1 | 3 | 3 | 4 | **2.75** | | 8 | I7 | Inventory availability not assessed | 2 | 1 | 3 | 3 | 4 | **2.45** | **Calculation example (I5):** (3×0.30) + (4×0.20) + (5×0.20) + (5×0.15) + (5×0.15) = 0.90 + 0.80 + 1.00 + 0.75 + 0.75 = **4.20** **Note on overlap:** I1 and I5 are closely linked (you cannot judge discount profitability without consistent tracking). Treat I5 as the enabling foundation for I1. --- ## 🧮 9. FINANCIAL IMPACT ESTIMATION **No actual leakage amounts can be responsibly calculated from the data supplied.** The only computable baseline is: | Baseline | Formula | Result | |---|---|---| | Monthly revenue (as supplied) | Given | $28,000 | | Orders per month | Given | ~400 | | AOV | $28,000 ÷ 400 | $70 ✔ | Below are **calculation templates**. Fill in with real data; do not use the illustrative numbers as HavenHome results. ### Template A — Discount exposure (I1) | Input | Symbol | Source | |---|---|---| | Orders using a discount (monthly) | N_d | Shopify discount report | | Average discount amount per order | D | Shopify | | **Total discounts given** | = N_d × D | | | Share of discounted orders that would likely have occurred without discount | s | **Unknown. Requires a test (Section 14); do not assume** | | **Gross discount exposure at risk** | = N_d × D × s | | | Adjustment: incremental margin from discount-driven orders | = (N_d × (1 − s)) × margin per order | Cost data needed | | **Net effect** | = incremental margin − (N_d × D × s) | | *Illustrative example only — NOT HavenHome data:* If 100 orders used a code worth $8 each, total discounts given = $800. Whether any of that is "leakage" depends on `s`, which is unknown. **Confidence:** Low until `s` and margin are measured. ### Template B — Checkout abandonment exposure (I2) | Input | Symbol | Source | |---|---|---| | Checkouts started (monthly) | C | Shopify analytics | | Checkouts completed | O | = 400 (given, if equal to completed orders) | | Abandoned checkouts | A = C − O | Shopify abandoned checkout report | | Average abandoned cart value | V | Shopify | | **Gross abandoned value** | = A × V | | | Share that are non-recoverable (browsing, accidental, price-checking, fraud, duplicates, later purchased) | n | Sample review | | Share addressable by process fixes | r | Sample review | | Estimated recovery rate from improvements | p | **Unknown; only measurable via test** | | **Realistic recoverable revenue (hypothesis)** | = A × V × (1 − n) × r × p | | Required adjustment: remove abandoned checkouts where the customer **later completed a purchase** to avoid double-counting with realized revenue. **Confidence:** Low. Gross abandoned value ≠ recoverable revenue. ### Template C — Refund exposure (I4) | Input | Symbol | |---|---| | Refunded orders per month | R_n | | Average refund value | R_v | | **Total refunds** | = R_n × R_v | | Share with avoidable cause | a | | **Avoidable refund value** | = R_n × R_v × a | | Refund rate | = R_n ÷ 400 | Overlap: If a refunded order included a discount, record the refund net of discount once; do not add the discount exposure again. ### Template D — Repeat purchase opportunity (I3) | Input | Symbol | |---|---| | Customers in period | K | | Customers with ≥2 orders | K₂ | | **Repeat purchase rate** | = K₂ ÷ K | | Average repeat order value | V_r | | Hypothetical uplift scenario (clearly labeled) | Δ (e.g., +1 point of repeat rate) × K × V_r | This is a **growth opportunity**, not leakage. ### Template E — Payout reconciliation gap (I8) **Gap = (Shopify net sales − refunds) − (gateway payouts + fees + chargebacks + holds)** Any nonzero unexplained gap is a reconciliation discrepancy to investigate; it is not automatically a loss. ### Overlap map (to prevent double-counting) | Overlap | Rule | |---|---| | Discounts ↔ Refunds | Count refunds net of discounts once | | Abandonment ↔ Failed payments | Failed payments are a subset of abandoned checkouts if the customer did not retry | | Abandonment ↔ Recovery discounts | Discount used in recovery emails belongs in discount analysis; net it from recovered revenue | | Refunds ↔ Order errors | Reshipment cost is a cost, not a revenue loss | | Repeat purchase ↔ Email promos | Promo-driven repeat orders appear in both; report once | --- ## ⚡ 10. QUICK-WIN REVENUE IMPROVEMENTS | # | Issue | Proposed action | Why relevant | Resources | Complexity | Validation | Risks | Success metric | |---|---|---|---|---|---|---|---|---| | **1** | I5 / I1: Inconsistent promo tracking | Create a **Promotion Register** (spreadsheet): code, purpose, owner, dates, discount type/value, margin floor, channel. Deactivate unowned or expired codes. | Foundation for every discount decision | ~2 hrs; Google Sheets (free); Shopify admin | Low | Cross-check register vs. Shopify discount list; zero unregistered active codes | May interrupt active campaigns if codes disabled carelessly; review before deactivating | 100% of active codes registered with owner and end date | | **2** | I1: Discount profitability unknown | Pull 3-month discount report; calculate margin after discount for top 10 products and top codes | Reveals whether current promos clear a margin floor | ~3 hrs; Shopify reports; cost data | Low-Med | Reconcile discount totals to Shopify's own totals | COGS data may be incomplete; label estimates | Margin-after-discount known for top products and codes | | **3** | I2: Unreviewed abandoned checkouts | Weekly 30-minute review of abandoned checkouts: count, value, stage; confirm a recovery email sequence is on; sample 20 for reasons (shipping cost, payment failure, out of stock) | Converts a recorded-but-ignored data source into insight | ~30 min/week; Shopify built-in | Low | Compare reasons found vs. checkout settings; track recovery-email-attributed orders | Over-emailing; respect consent/unsubscribe rules and applicable email regulations | Reasons categorized; recovery flow active and tested | | **4** | I4: Refund causes unknown | Add a **reason code** (wrong item, damaged, not as described, late, changed mind, other) to every refund | Separates avoidable from ordinary | ~1 hr setup; spreadsheet or Shopify refund note | Low | Check 100% of new refunds coded for 4 weeks | Staff inconsistency in coding; define codes clearly | Refund reason coverage ≥ 95% (target) | | **5** | I3: Repeat purchase invisible | Run first cohort report: customers by first-order month and repeat orders | Establishes baseline before any retention spend | ~1–2 hrs; Shopify customer reports or export | Low | Compare to total customers; sanity check | Small samples; interpret cautiously | Baseline repeat purchase rate recorded | **Budget fit:** All five can be done with Shopify's built-in reports, a spreadsheet, and Google Analytics (free), staying well inside the $150/month tooling budget and ~5 hrs/week. Before purchasing any app, verify its current pricing and whether Shopify's native features already cover the need. --- ## 🛠️ 11. DETAILED CORRECTIVE ACTION PLANS ### Plan 1 — Promotion Tracking and Revenue Reconciliation (I5, with I1) | Element | Detail | |---|---| | **Problem definition** | Promotions are used frequently but tracked inconsistently; revenue baseline (gross vs. net) is not formally defined; discount profitability cannot be assessed. | | **Current process** | Discounts created ad hoc; no central record; no reporting on cost or results; no routine reconciliation. | | **Proposed process** | (1) Define revenue terms; (2) register every promotion before launch; (3) require margin check and end date; (4) review results after each campaign; (5) monthly reconciliation. | | **Required information** | Shopify order/discount exports; product costs; list of historical codes; gateway payout reports | | **Responsible role** | Owner/operations lead (accountable); marketing lead (promo registration); bookkeeper/accountant if available (reconciliation) | | **Tools or systems** | Shopify discount and sales reports, Google Sheets (free), optional accounting tool | **Implementation steps** 1. Agree on one definition set: *Gross sales, Discounts, Returns/refunds, Net sales, Shipping, Taxes, Collected cash.* 2. Export last 90 days of orders and discount data. 3. Build the **Promotion Register** (code, owner, purpose, start/end, type, depth, margin floor, channel, status). 4. Match every discount code used in the export to the register; list unmatched codes. 5. Deactivate or end-date codes without a clear purpose (after checking no live campaign depends on them). 6. Add a pre-launch checklist: purpose, audience, margin check, end date, stacking rules, approver. 7. After each campaign, record orders, discount dollars, AOV, and margin after discount. 8. Monthly: reconcile Shopify net sales to gateway payouts and accounting records; log differences. | Item | Detail | |---|---| | **Internal controls** | Single-owner approval for new codes; no code without register entry; monthly exception review | | **Customer considerations** | Keep promo terms clear and honest; honor published offers; do not retroactively cancel advertised promotions | | **Validation criteria** | All active codes registered; Shopify discount totals tie to register; reconciliation differences explained | | **Monitoring requirements** | Monthly: unregistered code count, total discount dollars, discount rate, margin after discount, reconciliation variance | ### Plan 2 — Checkout Abandonment Review and Recovery (I2) | Element | Detail | |---|---| | **Problem definition** | Abandoned checkouts are recorded but never analyzed; size and causes of avoidable abandonment are unknown. | | **Current process** | Data accumulates in Shopify; no review cadence; recovery-email status unknown. | | **Proposed process** | Weekly review → categorize causes → fix addressable causes → test recovery messaging → measure. | | **Required information** | Weekly abandoned checkout list; checkout settings (shipping, payments, account requirement); recovery-email status; stock levels | | **Responsible role** | Operations lead (review); marketing lead (email); owner (approval of checkout/shipping changes) | | **Tools or systems** | Shopify abandoned checkout report, Shopify Email or existing email tool, GA4 (free) | **Implementation steps** 1. Pull 4–8 weeks of abandoned checkout data: count, value, stage reached, contact info present or not. 2. Check whether an abandoned checkout email is enabled; review timing and copy. 3. Test-purchase the checkout on mobile and desktop: note any friction (shipping reveal, payment options, errors, forced account). 4. Sample ~20 abandoned checkouts; tag likely cause where observable (shipping cost shown late, payment error, out of stock, no cause visible). 5. Remove non-recoverable cases (duplicates, test orders, customers who later bought). 6. Fix clear technical or clarity issues first (errors, unclear shipping, missing payment methods). 7. Run a controlled recovery-email test (Section 14) rather than rolling out discounts to everyone. 8. Record recovered orders and net of any incentive. | Item | Detail | |---|---| | **Internal controls** | Recovery emails sent only to customers who gave marketing/transactional consent per applicable rules; no recovery discount unless approved in the Promotion Register | | **Customer considerations** | Limit frequency; make opt-out easy; no deceptive urgency or fake scarcity | | **Validation criteria** | Causes categorized for sample; recovery flow active and tested; recovered orders attributable | | **Monitoring requirements** | Weekly: abandoned checkout count/value, checkout completion rate, recovery-email-attributed orders | ### Plan 3 — Discount Profitability Review (I1) | Element | Detail | |---|---| | **Problem definition** | Discounts are used frequently, but whether they are profitable or incremental is unknown. | | **Current process** | Discounts launched without margin check or post-campaign review. | | **Proposed process** | Measure → classify → set margin guardrails → test alternatives. | | **Required information** | Order-level discount data, unit costs, shipping and fee estimates, customer type (new/returning) | | **Responsible role** | Owner (decision); operations/analyst (analysis) | | **Tools or systems** | Shopify exports, Google Sheets | **Implementation steps** 1. Complete Plan 1 steps 1–4 (dependency). 2. For each major code/promo, compute: orders, discount dollars, average discount %, AOV vs. non-discounted AOV. 3. Estimate contribution margin per order after discount, product cost, shipping cost, and payment fees (label assumptions). 4. Segment by new vs. returning customers; flag discounts given mostly to returning customers (possible subsidy of existing demand, *unproven until tested*). 5. Set a minimum margin floor per product or category. 6. Identify the 2–3 promotions with the weakest margin and test alternatives (Section 14). 7. Document the approved promotion policy. | Item | Detail | |---|---| | **Internal controls** | Margin floor check before launch; stacking rules set in Shopify; monthly review | | **Customer considerations** | Avoid abrupt removal of long-standing promotions without notice; keep pricing transparent; avoid fake reference prices | | **Validation criteria** | Margin-after-discount known for top promos; policy documented; at least one alternative tested | | **Monitoring requirements** | Monthly: discount rate, margin after discount, share of orders discounted | --- ## 📈 12. REVENUE PERFORMANCE KPI DASHBOARD **No KPI values are provided; formulas only, except the three supplied baselines (revenue, orders, AOV).** | KPI | Definition | Formula | Required data | Frequency | Interpretation guidance | |---|---|---|---|---|---| | **Net sales** | Sales after discounts and refunds | Gross sales − discounts − refunds | Shopify sales report | Monthly | Always label gross vs. net | | **Orders** | Completed orders | Count | Shopify | Weekly | Baseline ~400/month (given) | | **Average order value** | Average revenue per order | Revenue ÷ orders | Shopify | Weekly | Baseline $70 (given); watch changes after promotions | | **Conversion rate** | Sessions that complete an order | Orders ÷ sessions | Shopify/GA4 | Weekly | Segment by channel and device; compare to *own* history | | **Add-to-cart rate** | Sessions with an add to cart | Add-to-cart sessions ÷ sessions | Shopify/GA4 | Weekly | Low rate suggests product page issues | | **Checkout completion rate** | Started checkouts that complete | Completed ÷ checkouts started | Shopify | Weekly | Primary abandonment indicator | | **Abandoned checkout value** | Value of unfinished checkouts | Sum of abandoned checkout totals | Shopify | Weekly | Gross exposure only; not lost revenue | | **Recovery rate** | Abandoned checkouts later purchased due to follow-up | Recovered orders ÷ abandoned checkouts emailed | Email tool, Shopify | Weekly | Net of incentives; avoid counting organic returns | | **Discount rate** | Discounts as share of gross sales | Discount $ ÷ gross sales | Shopify | Weekly/Monthly | Rising rate without rising margin is a warning | | **Share of orders discounted** | Orders using any discount | Discounted orders ÷ orders | Shopify | Monthly | High share may signal discount dependence (verify) | | **Margin after discount** | Contribution margin on discounted orders | (Net revenue − COGS − shipping − fees) ÷ net revenue | Cost data | Monthly | Compare to margin floor | | **Refund rate** | Orders refunded | Refunded orders ÷ orders | Shopify | Monthly | Track avoidable share separately | | **Refund value rate** | Refund dollars share | Refund $ ÷ gross sales | Shopify | Monthly | — | | **Repeat purchase rate** | Customers with 2+ orders | Repeat customers ÷ total customers (per cohort) | Shopify customers | Monthly/Quarterly | Interpret by product category; slow cycles are normal for durable goods | | **Revenue per customer** | Value per customer over a period | Revenue ÷ customers | Shopify | Quarterly | Use cohorts | | **Time between orders** | Typical repurchase interval | Median days between first and second order | Shopify | Quarterly | Informs email timing | | **Payment failure rate** | Failed payment attempts | Failed ÷ attempts | Gateway | Monthly | Investigate spikes | | **Chargeback rate** | Disputes as share of orders | Chargebacks ÷ orders | Gateway | Monthly | — | | **Reconciliation variance** | Unexplained difference | See Template E | Shopify, gateway, accounting | Monthly | Should trend to zero or be fully explained | | **Stock-out incidents** | Times key items unavailable | Count and duration | Inventory data | Monthly | Pair with sales history of those items | | **Unregistered promo codes** | Active codes not in the register | Count | Register, Shopify | Monthly | Target: zero | --- ## 📅 13. 30-DAY REVENUE LEAKAGE ACTION ROADMAP **Capacity assumption:** ~5 hours/week (~20 hours total), $150/month tool budget. ### WEEK 1 — DATA COLLECTION AND DIAGNOSIS (~5 hrs) | Item | Detail | |---|---| | **Objectives** | Define revenue terms; collect core data; set up tracking structures | | **Key activities** | ☐ Confirm whether $28,000 is gross or net (1 hr) ☐ Export 90 days of orders, discounts, refunds, abandoned checkouts (1 hr) ☐ Build Promotion Register (1.5 hrs) ☐ Create refund reason-code log (0.5 hr) ☐ Check Shopify abandoned checkout email status (0.5 hr) ☐ Gather product costs for top products (0.5 hr) | | **Responsible roles** | Owner/ops lead (primary) | | **Resources** | Shopify reports, Google Sheets, GA4 | | **Deliverables** | Revenue definitions; Promotion Register v1; refund log live; data exports | | **Success criteria** | All active codes listed; baseline data in one workbook | | **Potential blockers** | Missing cost data; unclear code history; export limits | ### WEEK 2 — ROOT CAUSE VALIDATION (~5 hrs) | Item | Detail | |---|---| | **Objectives** | Test which suspected issues are real and material | | **Key activities** | ☐ Compute discount metrics by code (1.5 hrs) ☐ Estimate margin after discount for top products (1 hr) ☐ Review and tag ~20 abandoned checkouts (1 hr) ☐ Test-purchase the checkout on mobile and desktop (0.5 hr) ☐ Run first repeat purchase cohort report (1 hr) | | **Responsible roles** | Ops lead; marketing lead for email flow review | | **Resources** | Same as Week 1 | | **Deliverables** | Discount analysis v1; abandonment cause tally; repeat purchase baseline | | **Success criteria** | Each of I1–I4 re-scored with evidence; Confirmed/Suspected statuses updated | | **Potential blockers** | Small sample sizes; tags are subjective; cost estimates imprecise (label them) | ### WEEK 3 — CONTROLLED PROCESS IMPROVEMENTS (~5 hrs) | Item | Detail | |---|---| | **Objectives** | Implement low-risk fixes and start one controlled test | | **Key activities** | ☐ Deactivate/end-date unowned codes after review (0.5 hr) ☐ Set margin floor and promo approval checklist (1 hr) ☐ Fix clear checkout friction items identified (1–2 hrs) ☐ Launch one recovery-email or discount-alternative test (1 hr) ☐ Begin payout reconciliation for last month (1 hr) | | **Responsible roles** | Owner (approvals); ops/marketing leads | | **Resources** | Shopify settings, email tool within budget | | **Deliverables** | Promo policy v1; test live; first reconciliation | | **Success criteria** | No unregistered active codes; test has a defined hypothesis and metric | | **Potential blockers** | Time constraints; hesitancy to alter promotions; app costs creeping past budget | ### WEEK 4 — PERFORMANCE REVIEW AND NEXT STEPS (~5 hrs) | Item | Detail | |---|---| | **Objectives** | Review early results; decide next priorities; institutionalize routines | | **Key activities** | ☐ Build simple KPI sheet (Section 12) (1.5 hrs) ☐ Review test status; do not conclude with insufficient sample (1 hr) ☐ Re-run priority scorecard with new evidence (1 hr) ☐ Quantify exposures where data now allows using Section 9 templates (1 hr) ☐ Set 60–90 day plan and recurring review calendar (0.5 hr) | | **Responsible roles** | Owner and ops lead | | **Resources** | KPI workbook | | **Deliverables** | KPI baseline; updated scorecard; next-quarter plan | | **Success criteria** | At least three issues moved from Insufficient Data to Confirmed/Suspected/Not material with evidence | | **Potential blockers** | Test too short for conclusions; seasonal effects distort comparisons | --- ## 🧪 14. REVENUE IMPROVEMENT EXPERIMENTS > **Statistical caution:** With ~400 orders/month, small tests will often be inconclusive. Treat results as directional evidence unless differences are large and consistent over several cycles. Do not claim statistical significance without a proper calculation. | # | Hypothesis | Proposed change | Target segment | Baseline data needed | Success metric | Duration | Risks | Evaluation | Decision criteria | |---|---|---|---|---|---|---|---|---|---| | **E1** | A well-timed, clear abandoned-checkout reminder recovers some orders **without** a discount | Enable/adjust reminder email (no incentive) | Abandoners with email + marketing consent | Current recovery count; abandoned count | Recovered orders ÷ emails sent | 4–8 weeks (cover multiple weekly cycles) | Email fatigue; consent compliance | Compare to prior-period recovery; track unsubscribes | Keep if recovery is positive and unsubscribe/complaint rate acceptable | | **E2** | Offering a recovery incentive adds recovered orders beyond no-incentive reminders, net of discount cost | Add small incentive to **second** reminder only for a randomized half | Same as E1, split | E1 results | Net recovered revenue after incentive | 4–8 weeks | Trains customers to abandon for codes | Compare split groups on net revenue and margin | Adopt only if net margin positive and no obvious abandonment spike | | **E3** | Some site-wide discounts could be replaced by spend-threshold offers without hurting orders | Replace one low-performing promo with a threshold offer (e.g., value-based free shipping or bundle) | Single promo/campaign | Last comparable promo results | Orders, AOV, margin after discount | One campaign cycle, repeated if possible | Revenue dip; confusion | Compare to previous equivalent period, adjusting for seasonality | Keep if margin per order improves without material drop in orders | | **E4** | Clearer shipping-cost and delivery-time messaging reduces checkout drop-off | Show shipping estimate earlier (product page/cart) | All visitors (before/after) | Checkout completion rate; sampled abandonment reasons | Checkout completion rate | 4–6 weeks | Seasonality confounds before/after | Before/after with note on promos and traffic mix | Keep if completion improves and no negative side effects | | **E5** | A post-purchase email (care tips, related items) generates repeat orders | Add one post-purchase email 14–30 days after delivery | New customers | Baseline repeat purchase rate | Repeat orders within window | 60–90 days (long cycle) | Low sample; slow signal | Compare to prior cohorts | Continue if directionally positive; reassess after 90 days | | **E6** | Reason-coded refunds will reveal a small number of fixable causes | Implement refund reason log and product page / packaging fixes for top cause | All refunds | Refund count by reason | Avoidable refund rate | 6–8 weeks | Too few refunds for patterns | Pareto of reasons | Act if one cause clearly dominates | --- ## 🛡️ 15. FINANCIAL CONTROLS AND PREVENTION Controls are sized for a small team (~5 hrs/week of analysis capacity). | Control area | Proportionate control | Owner | Frequency | |---|---|---|---| | **Pricing approvals** | Price changes logged (what/when/why) and approved by one designated person | Owner | Per change | | **Discount tracking** | Promotion Register; no code live without entry; stacking rules set; automatic end dates where possible | Marketing lead | Per promo; monthly audit | | **Invoice reconciliation** | Not core; confirm any draft/manual orders are reconciled to payments | Ops | Monthly | | **Payment monitoring** | Review failed payments, chargebacks, and payout holds | Ops | Weekly/Monthly | | **Revenue reporting** | Single revenue definition set; one monthly report with gross, discounts, refunds, net | Owner/bookkeeper | Monthly | | **Contract and scope verification** | Not applicable, except supplier/wholesale agreements and platform terms (review any pricing commitments before changing them) | Owner | As needed | | **Customer account accuracy** | Periodic check for duplicate customer records and email mismatches affecting repeat-purchase measurement | Ops | Quarterly | | **Refund authorization** | Refund approval threshold (e.g., above a set amount requires owner approval); mandatory reason code | Ops/Owner | Per refund | | **Process documentation** | One-page SOPs: promo launch, refund handling, month-end reconciliation | Ops | Update quarterly | | **Exception handling** | Exceptions log: unusual discounts, manual price overrides, gifted orders, high refunds | Ops | Reviewed monthly | ### Example SOP skeleton: Promotion Launch Checklist - ☐ Purpose defined (acquisition / re-engagement / clearance / recovery) - ☐ Target audience and channel set - ☐ Margin check against the floor completed - ☐ Start and end dates entered - ☐ Stacking and exclusions configured and tested - ☐ Entry created in Promotion Register - ☐ Approver sign-off - ☐ Post-campaign review scheduled (orders, discount $, AOV, margin after discount) --- ## ⚠️ 16. RISKS, ASSUMPTIONS, AND DATA GAPS | Area | Item | Effect on confidence | |---|---|---| | **Unverified assumptions** | Revenue is assumed to be a single definition (gross vs. net unknown) | All figures could shift; lowers confidence in every estimate | | | Assumes one storefront and no wholesale, subscriptions, or marketplace sales | If wrong, additional leakage categories apply | | | Assumes abandoned checkouts are recorded accurately | Abandonment sizing may be off | | **Missing financial information** | COGS, shipping cost, payment fees, marketing cost | Profitability conclusions impossible until supplied | | | Discount dollars and refund totals | Cannot size exposure | | **Incomplete customer data** | Repeat purchases not visible; guest checkouts and varying emails can undercount repeat customers | Repeat rate may be understated | | **Possible reporting inconsistencies** | Inconsistent promo tracking; possible mismatches between Shopify, gateway, and accounting | Reduces trust in baseline numbers | | **Implementation risks** | Limited hours; changes to promotions can reduce orders; app costs may exceed $150/month | Prioritize low-cost process fixes first | | **Customer experience concerns** | Aggressive recovery emails or sudden promo changes can erode trust | Keep communications transparent, limited, and consent-based | | **Legal/contractual review needs** | Email marketing consent rules, consumer pricing/promotion rules, refund policy obligations, privacy, and tax treatment may vary by location and sales regions | Have a qualified advisor review before changing refund/return terms, pricing display practices, or data-collection methods | | **Overlapping estimates** | Discounts, refunds, abandonment, and repeat purchase overlap (see Section 9 overlap map) | Summing exposures would overstate impact; analyze separately and adjust | | **Seasonality** | Home accessories sales may vary seasonally | Before/after comparisons may be misleading without seasonal adjustment | | **Small sample size** | ~400 orders/month limits test sensitivity | Treat results as directional | --- ## 📋 17. FINAL REVENUE LEAKAGE ACTION PLAN ### Five most important findings 1. **No leakage is quantified yet.** There are no verified financial loss estimates, and this report doesn't create any; it provides the method to measure them. 2. **The core confirmed problem is a control and visibility gap:** inconsistent promo tracking, no reviewed abandonment data, no repeat-purchase visibility, no defined revenue baseline. 3. **Discount profitability is the most plausible area of margin erosion**, but it is *suspected*, not proven. Frequency of use alone does not prove leakage. 4. **Checkout abandonment is an unrealized opportunity**, and only a fraction is realistically recoverable. Gross abandoned value is not lost revenue. 5. **Billing/invoicing and subscription categories are largely not applicable.** Payment reconciliation and refund analysis are the relevant remaining checks. ### Confirmed vs. suspected vs. insufficient data | Status | Items | |---|---| | **Confirmed (process/control gaps, not dollar losses)** | Inconsistent promotion tracking; abandoned checkouts not reviewed; low repeat-purchase visibility; no verified loss estimates; no systematic reporting/reconciliation | | **Suspected** | Discount margin erosion or subsidizing existing demand; unapproved/stale codes; manual promo setup errors; avoidable checkout friction | | **Insufficient Data** | Refund causes and rate; payment failures/chargebacks; payout reconciliation gaps; inventory stock-outs; pricing too low (no evidence); post-purchase email performance | | **Not applicable** | Subscription renewals, invoicing for unbilled work, contract pricing | ### Highest-priority investigation **Discount and promotion analysis (I5 → I1):** build the Promotion Register, then measure margin after discount by code and product. ### Best initial corrective action Create the **Promotion Register and revenue definitions** (Quick Win #1). It is low-cost, low-risk, quick, and a prerequisite for the other analyses. ### Required data to collect - ☐ Gross vs. net definition of the $28,000 - ☐ 90-day order export with discount codes, amounts, refunds - ☐ Product costs (at least the top sellers), shipping costs, payment fees - ☐ Sessions, add-to-cart, checkout-started, abandoned checkout data - ☐ Refunds with reasons - ☐ Customer list with order counts (new vs. returning) - ☐ Gateway payout and chargeback reports - ☐ Stock-out history for key products ### Recommended KPI tracking (start with these 8) Net sales · AOV · Checkout completion rate · Discount rate · Margin after discount · Refund rate · Repeat purchase rate · Reconciliation variance ### Main implementation risks - Limited weekly capacity → keep scope narrow, finish Week 1 foundations before tests - Removing or changing promotions could reduce sales → change incrementally, test first - Over-interpreting small samples → treat results as directional - Customer trust and consent/privacy compliance in recovery emails - Tool cost creep beyond $150/month → use native tools first ### Next five practical steps 1. ☐ Confirm whether the $28,000 is gross or net; write the revenue definitions 2. ☐ Export 90 days of orders, discounts, refunds, and abandoned checkouts 3. ☐ Build the Promotion Register and reconcile it to active Shopify codes 4. ☐ Start the refund reason-code log and the weekly 30-minute abandoned checkout review 5. ☐ Calculate margin after discount for top products and top codes (label all assumptions) ### Longer-term improvement opportunities *(growth, not leakage)* - Repeat-purchase programs (post-purchase emails, loyalty) after a baseline is known - Bundles and cross-sell tests - Customer segmentation by source and purchase behavior - Back-in-stock notifications for popular items - Review/UGC collection to improve conversion - Quarterly pricing and margin review once cost data is reliable --- *This report is a preliminary business diagnostic based solely on the limited information provided about a fictional business. It contains no audited findings, guaranteed outcomes, or verified benchmarks. Illustrative numbers are labeled as such and are not HavenHome data. Legal, tax, and compliance questions should be reviewed by a qualified professional.*