customer_360, product_360, ad_360 — each row a complete picture. Every customer's: gender, channel, LTV, cluster, hero product, top-5 SKUs, attribute prefs, predicted next 3, gift behavior, refunds, email engagement. Every product's: full attribution, demographics, visual + text attrs, top co-purchases, recommendations. Every campaign's: spend, ROAS, attributed orders. Use these to build segments, briefs, recommendations.
| G | Tier | LTV | Orders | Hero product | Pref mood/occasion | Predicted next | Gift? | Last seen | |
|---|---|---|---|---|---|---|---|---|---|
| jkyle.felix@gmail.com | F | DIAMOND | R37,369 | 4 | Luxury Pure Silk Lingeri | sleep_comfor/gifting | Nude Leopard, Red Pearl, French Lingerie | 3 | 102d |
| mkgare49@gmail.com | F | DIAMOND | R36,098 | 4 | Iconic Silk Lingerie | sleep_comfor/gifting | 4 | 166d | |
| crslegal.collections@gmail.c | M | DIAMOND | R33,676 | 1 | The Petite Everyday Luxe | sleep_comfor/gifting | 0 | 151d | |
| juanpierregraham@gmail.com | M | DIAMOND | R32,685 | 4 | KAAL. Gift Cards | sleep_comfor/gifting | Fetish Set, Classic floral lac | 0 | 232d |
| mark@mirage760.com | M | DIAMOND | R31,582 | 3 | Lace Thong G-String’s | sleep_comfor/gifting | Cloud Lace Lingeri, Luna Lace Lingerie, Black Pearl | 2 | 9d |
| philip@crsconstruction.co.za | M | DIAMOND | R25,991 | 9 | Radiant Pearl Set | edgy/gifting | French Lingerie, Lace Thong G-Strin, Black Pearl | 0 | 41d |
| ian@quatroholdings.co.za | M | DIAMOND | R25,188 | 1 | Hibiscus Lace Lingerie S | sleep_comfor/gifting | Cloud Lace Lingeri, Comfy Pajamas, French Lingerie | 1 | 76d |
| cvanheerden2@oldmutual.com | F | GOLD | R22,611 | 1 | The Coffee Secret Garden | sexy/gifting | 1 | 5d | |
| bendanb@hotmail.com | F | GOLD | R21,965 | 5 | Cloud Lace Lingerie Set | sleep_comfor/gifting | Push Up Lace Linge, Lace Thong G-Strin, Raven Pearl | 0 | 32d |
| riaanlprivate@gmail.com | M | GOLD | R21,734 | 2 | Locker Corset | sleep_comfor/gifting | Classic floral lac, KAAL Gift Box | 0 | 417d |
| arnold@onlineintelligence.co | M | GOLD | R21,210 | 7 | Push Up Lace Lingerie Se | romantic/gifting | Luna Lace Lingerie, Flower Lace | 3 | 28d |
| calliecarlson1@gmail.com | M | GOLD | R20,387 | 2 | Radiant Pearl Set | sleep_comfor/gifting | Lace Thong G-Strin, Red Pearl, Black Pearl | 0 | 145d |
| calpad84@gmail.com | F | GOLD | R18,984 | 4 | Radiant Pearl Set | sleep_comfor/gifting | Lace Thong G-Strin | 4 | 73d |
| darren@specialisedfireproofi | M | GOLD | R18,906 | 5 | French Lingerie | sleep_comfor/gifting | Black Pearl, KAAL Gift Box, Classic floral lac | 0 | 29d |
| nklsmattsson@gmail.com | M | GOLD | R18,667 | 1 | Coastal Crochet Set | edgy/gifting | 0 | 52d | |
| kstore@randmail.co.za | M | GOLD | R18,484 | 2 | Black Pearl | sleep_comfor/gifting | KAAL Gift Box, French Lingerie, Red Pearl | 0 | 347d |
| trudievdmerwe@live.co.za | F | GOLD | R18,410 | 2 | Starry Night Set | romantic/gifting | 0 | 363d | |
| miketerreblanche@gmail.com | F | GOLD | R18,386 | 6 | Strapped Tiger Lingerie | edgy/gifting | 0 | 34d | |
| charlycinko@yahoo.co.uk | F | GOLD | R17,589 | 1 | Silver Lining | edgy/gifting | 1 | 54d | |
| marlise@augustcollective.co. | F | GOLD | R17,202 | 3 | Silk Lace Lingerie | romantic/gifting | 0 | 15d | |
| evelinehamman@icloud.com | F | GOLD | R17,089 | 1 | Luxury Pure Silk Lingeri | sleep_comfor/gifting | Nude Leopard, Black Pearl, KAAL Gift Box | 0 | 232d |
| christoff7.e@gmail.com | F | GOLD | R16,980 | 1 | Luna Lace Lingerie Set | romantic/gifting | Lace Thong G-Strin | 0 | 145d |
| tony@beeandmore.co.za | M | GOLD | R16,789 | 2 | Kinky Strap Set | sleep_comfor/gifting | Halter Neck Bandag, Amalfi Lace Linger, Fetish Set | 0 | 58d |
| carl.neethling@ascendishealt | M | GOLD | R16,688 | 1 | Red Blossom Lingerie Set | edgy/gifting | 0 | 73d | |
| liezelbrits@live.com | F | GOLD | R16,390 | 2 | Seamless Lace Lingerie S | edgy/gifting | French Lingerie | 0 | 99d |
| Cluster | Customers | Avg LTV | Total revenue | Male/Female | Gift orders | Klaviyo orders |
|---|---|---|---|---|---|---|
| Single premium order | 772 | R3,572 | R2,758k | 54%/46% | 150 | 19 |
| High-spend casual | 306 | R6,587 | R2,016k | 55%/45% | 72 | 11 |
| One-and-done mid | 1,108 | R1,757 | R1,946k | 55%/45% | 199 | 9 |
| High-spend single-shot | 66 | R13,745 | R907k | 56%/44% | 37 | 14 |
| Loyal regular | 35 | R7,061 | R247k | 51%/49% | 20 | 6 |
| Whale | 7 | R31,798 | R223k | 71%/29% | 10 | 1 |
| Hero (high LTV, high frequency) | 9 | R16,149 | R145k | 33%/67% | 17 | 1 |
| Frequent low-spend | 17 | R3,454 | R59k | 53%/47% | 8 | 0 |
| Trial/light buyer | 73 | R639 | R47k | 41%/52% | 8 | 2 |
| No spend | 23 | R0 | R0k | 9%/57% | 1 | 0 |
| Product | Cat | Buyers | LTV | % Repeat | % Male | % Gift | Visual signature | Top recommendation |
|---|---|---|---|---|---|---|---|---|
| Black Pearl | Lingerie Sets | 208 | R5,483 | 46% | 61% | 40% | art-nouveau-fan-embroidery,scalloped | KAAL Gift Box |
| Classic floral lace set | Lingerie Sets | 197 | R4,365 | 32% | 48% | 24% | heavy-floral-embroidery,scalloped-trim | KAAL Gift Box |
| French Lingerie | Lingerie Sets | 202 | R5,511 | 60% | 58% | 30% | pinstripe-mesh,art-deco-rays,gold-medall | Black Pearl |
| The Bridal Lingerie Set | Bridal | 165 | R3,959 | 31% | 48% | 18% | eyelash-lace-trim,bow-detail,gold-hardwa | KAAL Gift Box |
| Fetish Set | Lingerie Sets | 163 | R4,009 | 36% | 45% | 17% | multi-strap-cage,gold-ring | Halter Neck Bandage Suit |
| Kinky Strap Set | Lingerie Sets | 130 | R3,940 | 41% | 50% | 18% | gold-ring-hardware | Halter Neck Bandage Suit |
| KAAL. Gift Cards | Gift Cards | 101 | R3,752 | 26% | 68% | 2% | kaal-monogram | KAAL Gift Box |
| Flower Lace | Lingerie Sets | 131 | R4,226 | 47% | 35% | 10% | leaf-floral-embroidery,scalloped-edge | The Bridal Lingerie Set |
| KAAL Gift Box | Gift Box | 469 | R5,189 | 23% | 72% | 20% | kaal-monogram-gold,black-satin-ribbon | Black Pearl |
| Red Pearl | Lingerie Sets | 92 | R7,157 | 56% | 67% | 43% | art-nouveau-fan-embroidery,scalloped | Black Pearl |
| Lace Bodysuit | Bodysuits | 77 | R6,053 | 48% | 36% | 30% | lace-appliqué-center,plunge-v | Cloud Lace Lingerie Set |
| Strapped up lingerie suit | Lingerie Sets | 92 | R4,436 | 39% | 43% | 19% | leopard-print-mesh,cage-strap-frame | Fetish Set |
| The Bardot Corset Set | Corsets | 94 | R4,894 | 33% | 52% | 10% | boned-structure,sheer-mesh-panels | KAAL Gift Box |
| Silky Nighty | Silk Nightwear | 95 | R5,710 | 30% | 79% | 17% | lace-bodice-trim,sweetheart-line | Comfy Pajamas |
| Nude Leopard | Lingerie Sets | 81 | R6,151 | 35% | 63% | 17% | leopard-print-pattern | Black Pearl |
| Luxury Pure Silk Lingerie | Lingerie Sets | 41 | R8,950 | 78% | 52% | 30% | lace-inset-panty-front,silk-finish | Nude Leopard |
| Halter Neck Bandage Suit | Lingerie Sets | 78 | R4,725 | 23% | 42% | 13% | cutout-cleavage,criss-cross-waist,glossy | Fierce Feline Lingerie Se |
| Lace Thong G-String’s | Lingerie Sets | 83 | R5,902 | 29% | 70% | 29% | gold-medallion,multipack-presentation | Cloud Lace Lingerie Set |
| Cloud Lace Lingerie Set | Lingerie Sets | 52 | R9,546 | 36% | 50% | 29% | vibrant-magenta-scalloped-lace | Hibiscus Lace Lingerie Se |
| Amalfi Lace Lingerie Set | Lingerie Sets | 63 | R5,623 | 30% | 45% | 17% | (text-derived) | Locker Corset |
| Red Floral Set | Lingerie Sets | 67 | R5,885 | 24% | 63% | 16% | red-base-with-black-floral-applique | KAAL Gift Box |
| Comfy Pajamas | Pajamas | 67 | R7,230 | 33% | 67% | 22% | lace-trim-edges,bow-detail | Silky Nighty |
| Roses are Red Bodysuit | Bodysuits | 62 | R5,454 | 44% | 59% | 21% | red-rose-embroidery,boned-grommet-front | Crotchless Stockings |
| Bodysuit and Glove Lingerie Set | Lingerie Sets | 56 | R4,656 | 23% | 58% | 23% | matching-opera-length-gloves | Black Widow Lingerie Set |
| Luna Lace Lingerie Set | Lingerie Sets | 39 | R8,660 | 41% | 30% | 35% | dusty-blue-scalloped-lace,gold-coin | Hibiscus Lace Lingerie Se |
| Radiant Pearl Set | Lingerie Sets | 35 | R9,458 | 49% | 68% | 39% | pleated-mesh-detail,bow | French Lingerie |
| The Push-Up Chain Set | Lingerie Sets | 45 | R4,448 | 27% | 52% | 22% | gold-chain-cleavage-pendant | Classic floral lace set |
| Bad Bunny Lingerie Set | Lingerie Sets | 44 | R4,794 | 39% | 46% | 16% | (text-derived) | Premium Silky Stockings |
| Floral Fantasy Lingerie Set | Lingerie Sets | 44 | R6,744 | 30% | 52% | 18% | pastel-floral-embroidery,mint-strap-cont | Cloud Lace Lingerie Set |
| Hibiscus Lace Lingerie Set | Lingerie Sets | 35 | R9,144 | 37% | 60% | 34% | tonal-white-floral-lace,gold-coin | Luna Lace Lingerie Set |
| Campaign | Source | Spend | Orders | Revenue | ROAS | Status |
|---|---|---|---|---|---|---|
| 2 Nov | 5 Oct | 23 Sep + New Ads | R148,021 | 242 | R649,497 | 4.39x | paused | |
| 2 Feb | Evergreen | R137,390 | 222 | R580,461 | 4.22x | active | |
| 27 Jan | V Day 2026 - copy | R46,727 | 100 | R256,038 | 5.48x | paused | |
| 29 March | Wining Formula Statics + Intimate Night | R18,996 | 21 | R68,478 | 3.60x | paused | |
| Email #1 | klaviyo | R0 | 18 | R54,438 | 0.00x | attributed |
| Soft Pearl Launch | klaviyo | R0 | 4 | R29,104 | 0.00x | attributed |
| KAAL — April 2026 — Bridal Collection | klaviyo | R0 | 6 | R24,005 | 0.00x | attributed |
| Email #2 | klaviyo | R0 | 7 | R23,202 | 0.00x | attributed |
| Afrika Burn | klaviyo | R0 | 7 | R21,060 | 0.00x | attributed |
| Welcome Series, Email #1 | klaviyo | R0 | 6 | R17,039 | 0.00x | attributed |
| Abandoned Cart, Email #3 | klaviyo | R0 | 4 | R14,101 | 0.00x | attributed |
| Vday Reactivation - Email 2 | klaviyo | R0 | 4 | R13,061 | 0.00x | attributed |
| Abandoned Cart, Email #1 | klaviyo | R0 | 3 | R12,873 | 0.00x | attributed |
| 2 April | Comfort / Women | R7,514 | 5 | R12,598 | 1.68x | paused | |
| 6 Feb | Mens Boxers V Day | R4,471 | 5 | R12,192 | 2.73x | paused | |
| Vday Reactivation - Email 1 | klaviyo | R0 | 3 | R8,594 | 0.00x | attributed |
| 25 Apr Mothers Day (27 Jan | V Day 2026 - copy - C | R1,163 | 6 | R8,335 | 7.17x | active | |
| 2 April | Comfort + Gifting (Men/Women) | R2,769 | 2 | R7,225 | 2.61x | paused | |
| 2 April | Gifting / Men | R3,468 | 4 | R7,123 | 2.05x | paused | |
| Vday Reactivation - Email 3 | klaviyo | R0 | 2 | R6,046 | 0.00x | attributed |
| V Day 2026 | R176 | 2 | R4,335 | 24.68x | paused | |
| 7 April | 29 March/2 April Winners + New Vids | R4,908 | 2 | R3,798 | 0.77x | paused | |
| 15 April | 7 April | 29 March/2 April Winners + Ne | R1,045 | 1 | R2,918 | 2.79x | paused | |
| Post Purchase Flow Email 1 | klaviyo | R0 | 1 | R2,523 | 0.00x | attributed |
| 21 April | 29 March | Wining Formula Statics + Int | R2,044 | 1 | R0 | 0.00x | paused |
| Customer | Tier | LTV | Last hero | Predicted next 3 | Days since last |
|---|---|---|---|---|---|
| jkyle.felix@gmail.com | DIAMOND | R37,369 | Luxury Pure Silk Lingeri | Nude Leopard · Red Pearl · French Lingerie | 102d |
| mkgare49@gmail.com | DIAMOND | R36,098 | Iconic Silk Lingerie | 166d | |
| crslegal.collections@gmail.com | DIAMOND | R33,676 | The Petite Everyday Luxe | 151d | |
| juanpierregraham@gmail.com | DIAMOND | R32,685 | KAAL. Gift Cards | Fetish Set · Classic floral lace set | 232d |
| mark@mirage760.com | DIAMOND | R31,582 | Lace Thong G-String’s | Cloud Lace Lingerie Set · Luna Lace Lingerie Set · Black Pearl | 9d |
| philip@crsconstruction.co.za | DIAMOND | R25,991 | Radiant Pearl Set | French Lingerie · Lace Thong G-String’s · Black Pearl | 41d |
| ian@quatroholdings.co.za | DIAMOND | R25,188 | Hibiscus Lace Lingerie S | Cloud Lace Lingerie Set · Comfy Pajamas · French Lingerie | 76d |
| cvanheerden2@oldmutual.com | GOLD | R22,611 | The Coffee Secret Garden | 5d | |
| bendanb@hotmail.com | GOLD | R21,965 | Cloud Lace Lingerie Set | Push Up Lace Lingerie Set · Lace Thong G-String’s · Raven Pearl | 32d |
| riaanlprivate@gmail.com | GOLD | R21,734 | Locker Corset | Classic floral lace set · KAAL Gift Box | 417d |
| arnold@onlineintelligence.co.z | GOLD | R21,210 | Push Up Lace Lingerie Se | Luna Lace Lingerie Set · Flower Lace | 28d |
| calliecarlson1@gmail.com | GOLD | R20,387 | Radiant Pearl Set | Lace Thong G-String’s · Red Pearl · Black Pearl | 145d |
| calpad84@gmail.com | GOLD | R18,984 | Radiant Pearl Set | Lace Thong G-String’s | 73d |
| darren@specialisedfireproofing | GOLD | R18,906 | French Lingerie | Black Pearl · KAAL Gift Box · Classic floral lace set | 29d |
| nklsmattsson@gmail.com | GOLD | R18,667 | Coastal Crochet Set | 52d | |
| kstore@randmail.co.za | GOLD | R18,484 | Black Pearl | KAAL Gift Box · French Lingerie · Red Pearl | 347d |
| trudievdmerwe@live.co.za | GOLD | R18,410 | Starry Night Set | 363d | |
| miketerreblanche@gmail.com | GOLD | R18,386 | Strapped Tiger Lingerie | 34d | |
| charlycinko@yahoo.co.uk | GOLD | R17,589 | Silver Lining | 54d | |
| marlise@augustcollective.co.za | GOLD | R17,202 | Silk Lace Lingerie | 15d | |
| evelinehamman@icloud.com | GOLD | R17,089 | Luxury Pure Silk Lingeri | Nude Leopard · Black Pearl · KAAL Gift Box | 232d |
| christoff7.e@gmail.com | GOLD | R16,980 | Luna Lace Lingerie Set | Lace Thong G-String’s | 145d |
| tony@beeandmore.co.za | GOLD | R16,789 | Kinky Strap Set | Halter Neck Bandage Suit · Amalfi Lace Lingerie Set · Fetish Set | 58d |
| carl.neethling@ascendishealth. | GOLD | R16,688 | Red Blossom Lingerie Set | 73d | |
| liezelbrits@live.com | GOLD | R16,390 | Seamless Lace Lingerie S | French Lingerie | 99d |
| asheeqahganey@gmail.com | GOLD | R16,011 | Black and White Knit Set | 89d | |
| abilio@frazzitta.co.za | GOLD | R15,972 | Luxurious Pure Silk Sexy | 92d | |
| grosche@hotmail.co.za | GOLD | R15,916 | The Green Vine Lace Set | KAAL Gift Box | 0d |
| macblack3@gmail.com | GOLD | R15,793 | Luxurious Pure Silk Paja | 90d | |
| jd.landbou@gmail.com | GOLD | R15,670 | Cloud Lace Lingerie Set | Hibiscus Lace Lingerie Set · Push Up Lace Lingerie Set · Raven Pearl | 147d |