FURNITURE CUSTOMER VALUE WORKSHEET Furn | Reviewed October 21, 2026 Guide: https://furncmo.com/blog/furniture-customer-lifetime-value DEFINE THE MEASURE Owner / reviewer / as-of date: Measure: observed net revenue / observed contribution / forecast CLV First-purchase cohort period / customer identity rule: Qualifying order and refund/cancellation/exchange/replacement treatment: Observation horizon / each customer fully observed? / incomplete records: Original eligible customers (retain non-repeat buyers in denominator): Currency / tax / shipping revenue / discounts / refunds treatment: OBSERVED COHORT Unique repeat buyers / original cohort customers = repeat-buyer rate: First orders / repeat orders / total orders: Net sales after discounts and refunds: Product costs / fulfillment / payment fees / service costs: Retention marketing / acquisition costs / overhead or other costs: Cost allocation and double-count checks: Contribution before acquisition / per original cohort customer: Contribution after acquisition / per original cohort customer: Excluded costs / missing data / reconciled source: FICTIONAL EXAMPLE — NOT CUSTOMER RESULTS 100 fully observed customers; 100 first orders; 25 repeat orders by 20 buyers. 20 / 100 = 20% repeat-buyer rate, not 25%. 125 / 100 = 1.25 orders per original cohort customer. Net sales USD 120,000, excluding tax. Costs: product 70,000 + fulfillment 10,000 + fees 3,000 + service 2,000 + retention marketing 5,000 = USD 90,000. Contribution before acquisition: USD 30,000 / 100 = USD 300 per customer. Less acquisition USD 10,000: USD 20,000 / 100 = USD 200 per customer. Overhead and other unlisted costs excluded. Not net profit or forecast CLV. This does not establish that retention marketing caused the repeat orders. RETENTION DECISION Actual customer milestone / unresolved service needs: Relevant product relationship and evidence: Channel eligibility / preferences / exclusions / exit condition: Proposed optional intervention / comparison / allocation method: Necessary service preserved for all groups: Costs / attribution window / outcome coverage / complaints and returns: Observed result / uncertainty / continue, change or stop: FORECAST (ONLY IF SUPPORTED) Valuation date / remaining-value or total-value definition / horizon: Training period / holdout period / model and purchase assumptions: Future costs / discount rate / uncertainty / excluded factors: Later predicted-vs-observed checks and recalibration: Keep forecast values separate from historical contribution. References: https://www.brucehardie.com/talks/cba_tut_art_16_HO.pdf https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/customers-reports https://www.ftc.gov/business-guidance/resources/can-spam-act-compliance-guide-business