2026-04-27 · v2 · Tier 1+2+3 LIVE

Knowledge Graph

Co-purchase · directional · time-series · clusters · gifts · refunds · recommendations · cohort retention
523
Gift orders
17.5% of all orders
R5,087
Gift buyer LTV
vs R4,020 non-gift
315
Refunded orders
R765k total
7
Whales
R31,798 avg LTV · 14.7 products avg
v2 correction worth noting Earlier insight said "gifters churn" based on the inferred target_buyer attribute. With actual order data (billing ≠ shipping address), gift order BUYERS have HIGHER LTV than non-gift buyers (R5087 vs R4020). The gifters who DO buy are engaged customers buying for partners across multiple occasions. Different signal than what the inferred attribute suggested.

Visual graph — top 35 products

Node = product · size = buyer count · edge = high-confidence co-purchase
Lingerie Sets Bridal Bodysuits Corsets Silk Nightwear Pajamas Stockings Other

Bundle vs Cross-sell — same-order rate

High same-order = bundle / Low same-order = email cross-sell

🎁 Bundle candidates (same-order ≥ 50%)

PairCo-buyersSame-order
KAAL Gift Box ⇄ Red Floral Set24100%
Premium Silky Stocking ⇄ KAAL Gift Box14100%
The Push-Up Chain Set ⇄ KAAL Gift Box11100%
Silky Nighty ⇄ Comfy Pajamas10100%
Luna Lace Lingerie Set ⇄ Hibiscus Lace Lingerie7100%
KAAL Gift Box ⇄ Rose Lace Lingerie Set7100%
Cherry Bodysuit ⇄ KAAL Gift Box6100%
KAAL Gift Box ⇄ Love at First Sight Se6100%

📧 Cross-sell flow opportunities (mostly sequential)

From → ToCo-buyersSequential
Fetish Set → Roses are Red Bodysuit888%
Fetish Set → Pink Candy Corset683%
Fetish Set → KAAL. Gift Cards580%
Fetish Set → The Bardot Corset Set580%
Comfy Pajamas → Cloud Lace Lingerie Se580%
The Bardot Corset Set → French Lingerie875%
Fetish Set → Black Pearl771%
Red Pearl → Lace Bodysuit771%

Time to 2nd order — Klaviyo flow timing

Median days from first paid order to second · informs flow trigger timing
Entry productAcquiredReturnedReturn %Median daysP25 days
KAAL. Gift Cards1011111%21d4d
Floral Fantasy Lingerie Set44614%26d15d
Black Pearl208199%33d23d
Amalfi Lace Lingerie Set63711%34d14d
Lace Bodysuit77912%38d34d
Lace Thong G-String’s8356%47d30d
The Bardot Corset Set941314%49d26d
French Lingerie2022713%57d18d
Nude Leopard8167%58d15d
Silky Nighty95910%59d55d
Roses are Red Bodysuit62610%59d28d
Raven Pearl38821%61d44d

Trending pairs · 90d vs all-time

High/medium confidence · rising = emerging combo · fading = dying combo
PairLift all-timeLift 90dCo-buyersConfidenceTrend
Fierce Feline Lingerie ⇄ Halter Neck Bandage Su5.6x8.2x8→1medium↑ rising
Fetish Set ⇄ Halter Neck Bandage Su2.6x3.4x15→4high↑ rising
French Lingerie ⇄ Radiant Pearl Set3.4x1.1x11→1medium↓ fading
Black Pearl ⇄ Midnight Chain3.6x1.5x9→1medium↓ fading
Lace Thong G-String’s ⇄ Cloud Lace Lingerie Se4.1x2.5x8→4medium↓ fading
Silky Nighty ⇄ Comfy Pajamas3.4x2.0x10→2medium↓ fading
Nude Leopard ⇄ Black Pearl2.2x1.0x17→2high↓ fading
KAAL Gift Box ⇄ Comfy Pajamas2.1x1.5x30→11high↓ stable
KAAL Gift Box ⇄ Hibiscus Lace Lingerie2.3x1.8x17→8high↓ stable
Black Pearl ⇄ Red Pearl2.1x1.7x18→6high↓ stable

Customer clusters · 10 cohorts

Heuristic clustering by LTV × frequency × engagement
ClusterCustomersAvg LTVTotal spendAvg ordersUnique products
Single premium order772R3,572R2,758k (33%)1.22.3
High-spend casual306R6,587R2,016k (24%)1.33.7
One-and-done mid1,108R1,757R1,946k (23%)1.01.2
High-spend single-shot66R13,745R907k (11%)2.26.8
Loyal regular35R7,061R247k (3%)3.14.1
Whale7R31,798R223k (3%)3.714.7
Hero (high LTV, high frequency)9R16,149R145k (2%)5.38.8
Frequent low-spend17R3,454R59k (1%)7.47.9
Trial/light buyer73R639R47k (1%)1.01.0
No spend23R0R0k (0%)1.12.0

Item-item recommendations · "next product" model

Jaccard similarity over customer purchase history · top recommendations per anchor
Anchor productRecommended nextCo-buyersSimilarity
Hibiscus Lace Lingerie SetLuna Lace Lingerie Set70.104
Luna Lace Lingerie SetHibiscus Lace Lingerie Set70.104
Premium Silky StockingsPeacock Stockings70.097
Peacock StockingsPremium Silky Stockings70.097
Black PearlKAAL Gift Box590.096
KAAL Gift BoxBlack Pearl590.096
Luna Lace Lingerie SetPush Up Lace Lingerie Set50.093
Push Up Lace Lingerie SetLuna Lace Lingerie Set50.093
French LingerieBlack Pearl340.090
Black PearlFrench Lingerie340.090
Hibiscus Lace Lingerie SetCloud Lace Lingerie Set70.087
Cloud Lace Lingerie SetHibiscus Lace Lingerie Set70.087
Classic floral lace setKAAL Gift Box490.079
KAAL Gift BoxClassic floral lace set490.079
French LingerieKAAL Gift Box470.075
KAAL Gift BoxFrench Lingerie470.075
Cloud Lace Lingerie SetPush Up Lace Lingerie Set50.075
Push Up Lace Lingerie SetCloud Lace Lingerie Set50.075
Halter Neck Bandage SuitFierce Feline Lingerie Set80.073
Fierce Feline Lingerie SetHalter Neck Bandage Suit80.073

Cohort retention · acquisition month × channel

Cohorts ≥ 15 customers, sorted by 90d retention
CohortChannelN30d90d365d
2026-03meta-organic1717.6%23.5%23.5%
2026-02meta-paid6613.6%19.7%19.7%
2025-08meta-organic175.9%17.6%29.4%
2024-12meta-organic2412.5%16.7%33.3%
2025-07meta-organic1811.1%16.7%22.2%
2025-11meta-paid2512.0%16.0%16.0%
2025-12meta-organic449.1%15.9%18.2%
2024-12meta-paid2615.4%15.4%23.1%
2025-11google4710.6%14.9%17.0%
2025-02google989.2%14.3%23.5%
2025-05direct229.1%13.6%27.3%
2025-06google150.0%13.3%20.0%
2025-10meta-paid150.0%13.3%20.0%
2025-12meta-paid3010.0%13.3%16.7%
2025-05meta-organic244.2%12.5%16.7%

Refund cohort

315 of 2990 orders (10.5%) · R765k value
Customer clusterCustomers w/ refundRefundsRefund value
High-spend casual104108R276k
Single premium order107107R189k
High-spend single-shot3643R155k
One-and-done mid1111R23k
Frequent low-spend311R3k
Hero (high LTV, high frequency)46R13k
Whale36R34k
Loyal regular55R7k
No spend22R0k
Trial/light buyer11R0k

Directional pairs · A → B sequence

Customers who bought from then to · for "next product" email recommendations
FromToTransitionsReverseMedian days between
KAAL Gift BoxBlack Pearl45140d
KAAL Gift BoxFrench Lingerie4340d
KAAL Gift BoxClassic floral lace set38110d
KAAL Gift BoxThe Bridal Lingerie Set3240d
KAAL Gift BoxComfy Pajamas2820d
KAAL Gift BoxFetish Set2570d
KAAL Gift BoxSilky Nighty2420d
KAAL Gift BoxRed Pearl2390d
KAAL Gift BoxRed Floral Set2130d
KAAL Gift BoxFlower Lace2040d
KAAL Gift BoxThe Bardot Corset Set1960d
KAAL Gift BoxLace Thong G-String’s1960d
French LingerieBlack Pearl18160d
KAAL Gift BoxKinky Strap Set1870d
KAAL Gift BoxNude Leopard1640d
KAAL · Knowledge Graph v2 · Tier 1+2+3 · Refresh via scripts/refresh_intel.sh