=== Report 1: Top merchants: year-over-year holiday-quarter growth (written by Bea) === Engineer's note: Revenue uses orders.grand_total converted to EUR via exchange_rates (base_code='EUR', quote_code=order currency, matched by placed_at date); growth % is blank (NULL) when the prior-year base is zero, as requested. REPORT: Top merchants: year-over-year holiday-quarter growth QUESTION: For the biggest merchants, is Oct-Dec revenue really growing year over year, or is the recent growth just holiday seasonality? tenant_id | merchant_name | industry | revenue_eur_2025 | revenue_eur_2024 | revenue_yoy_growth_pct | orders_2025 | orders_2024 | order_yoy_growth_pct ----------+------------------------+---------------------------+--------------------+--------------------+------------------------+-------------+-------------+--------------------- 7 | Cragsley Outfitters | Apparel & Footwear | 305308.13477580674 | 254916.2183454923 | 19.8 | 1385 | 1250 | 10.8 2 | Marrowby & Vane | Apparel & Footwear | 115486.55393788879 | 99879.05831601824 | 15.6 | 632 | 536 | 17.9 14 | OfficeHub Nordic | Office Supplies (B2B) | 95374.2646994069 | 74566.95659110874 | 27.9 | 54 | 34 | 58.8 8 | Castell Fasteners | Industrial Supplies (B2B) | 89765.90754690344 | 82749.56637152552 | 8.5 | 40 | 33 | 21.2 67 | Deskline Supplies | Office Supplies (B2B) | 49519.31307200409 | 72832.46021243864 | -32.0 | 23 | 21 | 9.5 29 | Cinder Peak Sports Co. | Sports & Outdoor | 37423.0352890475 | 25086.90484593682 | 49.2 | 103 | 80 | 28.7 5 | Fennel & Flint | Home & Living | 30508.548393095047 | 20993.711669953103 | 45.3 | 172 | 114 | 50.9 40 | Petalcourt Beauty | Beauty | 20204.690585320448 | 21367.591359327926 | -5.4 | 243 | 220 | 10.5 32 | Oakhurst Tailoring | Apparel & Footwear | 13578.429230015927 | 6210.799071060735 | 118.6 | 80 | 44 | 81.8 26 | Velvet Ash | Apparel & Footwear | 11099.06167869471 | 8440.430393224973 | 31.5 | 50 | 47 | 6.4 38 | Coastline Interiors | Home & Living | 8889.546606660853 | 7109.994602993974 | 25.0 | 65 | 46 | 41.3 68 | Bytefield | Consumer Electronics | 8534.818988547484 | 855.2479167287883 | 897.9 | 11 | 1 | 1000.0 1 | Grind Collective | Food & Coffee | 8025.257959762262 | 7060.910689946055 | 13.7 | 346 | 231 | 49.8 39 | Kayak Corner | Sports & Outdoor | 7541.799332190187 | 14511.595443279439 | -48.0 | 21 | 36 | -41.7 79 | Kibblewick | Pet Supplies | 6937.270312135312 | 5524.927006049064 | 25.6 | 196 | 130 | 50.8 9 | Honeycomb Larder | Food & Coffee | 6774.995053655056 | 4486.233019954265 | 51.0 | 186 | 135 | 37.8 82 | Thistlecombe | Apparel & Footwear | 6586.155813760571 | 3157.631206782606 | 108.6 | 42 | 16 | 162.5 3 | Juniper Apothecary | Beauty | 6143.895316009281 | 4203.792296253382 | 46.2 | 55 | 35 | 57.1 33 | Fell & Fjell | Sports & Outdoor | 5888.326844261869 | 9062.857478957485 | -35.0 | 17 | 22 | -22.7 6 | Willow & Wren | Home & Living | 5656.5065044825815 | 9593.534345973987 | -41.0 | 33 | 55 | -40.0 58 | Nordic Bloom Cosmetics | Beauty | 5088.105628107569 | 5108.549229638149 | -0.4 | 44 | 33 | 33.3 41 | The Balm Room | Beauty | 3782.2293516296427 | 2633.9276053478325 | 43.6 | 38 | 23 | 65.2 61 | Saffron & Sage | Beauty | 3591.168799499806 | 2529.702061986444 | 42.0 | 43 | 30 | 43.3 36 | Fjordline Wear | Apparel & Footwear | 2861.0910292157914 | 2691.802771046791 | 6.3 | 22 | 22 | 0.0 47 | Tail Wag Supply | Pet Supplies | 2525.1108895814386 | 1393.3377865909927 | 81.2 | 29 | 18 | 61.1 46 | Feather & Fin | Pet Supplies | 2440.8140788065944 | 1716.283811574838 | 42.2 | 75 | 47 | 59.6 108 | Alpine Loft | Sports & Outdoor | 2430.368817325345 | 0.0 | NULL | 2 | 0 | NULL 89 | Circuit Harbor | Consumer Electronics | 2360.257771442038 | 1905.8059633327136 | 23.8 | 5 | 5 | 0.0 86 | Courtside Collective | Sports & Outdoor | 2359.677594562969 | 3318.4491605321 | -28.9 | 5 | 8 | -37.5 56 | Lamplight Living | Home & Living | 2343.3396257475624 | 1548.973525840177 | 51.3 | 19 | 10 | 90.0 94 | Greyfriars Supply | Apparel & Footwear | 2275.185355913487 | 0.0 | NULL | 8 | 0 | NULL 43 | Roast Republic | Food & Coffee | 1821.8625445112848 | 786.6456128756973 | 131.6 | 21 | 8 | 162.5 77 | Meadow Row | Apparel & Footwear | 1733.705254740237 | 2056.8528337600446 | -15.7 | 5 | 5 | 0.0 4 | Hus & Hem | Home & Living | 1720.5881410795268 | 3641.1678185491423 | -52.7 | 14 | 26 | -46.2 51 | Driftwood Home | Home & Living | 1551.6115265956932 | 23.481259408136467 | 6507.9 | 9 | 1 | 800.0 115 | Signalbox | Consumer Electronics | 1439.8531421743749 | 0.0 | NULL | 5 | 0 | NULL 100 | Rosehip Lab | Beauty | 1404.46589152984 | 0.0 | NULL | 16 | 0 | NULL 49 | Stoneware Studio | Home & Living | 1318.165175964863 | 768.7122099522219 | 71.5 | 12 | 3 | 300.0 54 | Tiny Atelier | Home & Living | 1283.8234387644463 | 3217.663973844508 | -60.1 | 8 | 17 | -52.9 64 | Brick & Bobbin | Apparel & Footwear | 1224.3079174304328 | 3584.6060003355587 | -65.8 | 10 | 14 | -28.6 107 | Glasshouse Grooming | Beauty | 1207.690922367792 | 0.0 | NULL | 8 | 0 | NULL 60 | Haven Linen | Home & Living | 1106.5250278681465 | 2611.2191223290147 | -57.6 | 6 | 16 | -62.5 75 | Silverthread | Jewelry & Accessories | 1029.6122237688733 | 882.7177925455117 | 16.6 | 6 | 3 | 100.0 85 | Little Larch Kids | Apparel & Footwear | 1020.6475252913605 | 514.9604547242062 | 98.2 | 7 | 4 | 75.0 62 | Folio & Fern | Books & Stationery | 1019.1773501235119 | 742.5124294157013 | 37.3 | 22 | 20 | 10.0 114 | Copper Lane | Apparel & Footwear | 1003.558542492167 | 0.0 | NULL | 6 | 0 | NULL 55 | Purrfect Pantry | Pet Supplies | 823.2211962547766 | 1965.1535658348416 | -58.1 | 17 | 22 | -22.7 34 | Paperplane Press | Books & Stationery | 684.2413219027004 | 1223.465162034375 | -44.1 | 15 | 18 | -16.7 73 | Barkley & Co. | Pet Supplies | 683.967507187761 | 687.1304316532863 | -0.5 | 8 | 12 | -33.3 101 | Kibble Crate | Pet Supplies | 415.0594406179933 | 0.0 | NULL | 6 | 0 | NULL (50 rows) === Report 2: Merchant risk signals: refunds, cancellations, unpaid invoices, shopper drop-off (written by Felix) === Engineer's note: Overdue invoice EUR conversion uses the most recent exchange rate on or before the reporting date 2026-01-05 (data only runs through 2025-12-31, so effectively 2025-12-31's rate is used); all other metrics use the FX rate on the transaction's own date as specified. REPORT: Merchant risk signals: refunds, cancellations, unpaid invoices, shopper drop-off QUESTION: Which merchants show warning signs right now: rising refunds or cancellations, unpaid invoices, or falling shopper activity? merchant_name | industry | refund_rate_last_90d_pct | refund_rate_prior_90d_pct | cancellation_rate_last_90d_pct | cancellation_rate_prior_90d_pct | overdue_invoice_amount_eur | web_sessions_last_90d | web_sessions_prior_90d | session_growth_pct ------------------------------+---------------------------+--------------------------+---------------------------+--------------------------------+---------------------------------+----------------------------+-----------------------+------------------------+------------------- Kontor24 Bürobedarf | Office Supplies (B2B) | 0.33 | 0.0 | 2.6 | 1.79 | 64191.09 | 58 | 63 | -7.94 Castell Fasteners | Industrial Supplies (B2B) | 0.88 | 0.0 | 0.0 | 2.7 | 5079.8 | 40 | 72 | -44.44 OfficeHub Nordic | Office Supplies (B2B) | 0.0 | 26.56 | 0.0 | 4.65 | 4767.95 | 67 | 59 | 13.56 Ballycorran Industrial Supply | Industrial Supplies (B2B) | 11.09 | 0.12 | 1.14 | 1.28 | 3346.98 | 80 | 96 | -16.67 Midland Safety Wear | Industrial Supplies (B2B) | 5.4 | 9.48 | 5.13 | 2.08 | 2348.21 | 39 | 32 | 21.88 Deskline Supplies | Office Supplies (B2B) | 0.0 | 0.0 | 0.0 | 0.0 | 399.32 | 14 | 11 | 27.27 Polder Packaging | Industrial Supplies (B2B) | 13.7 | 0.0 | 0.0 | 0.0 | 169.46 | 25 | 13 | 92.31 Brennquell Kaffee | Food & Coffee | 0.9 | 0.91 | 2.08 | 0.83 | 41.84 | 666 | 494 | 34.82 Brick & Bobbin | Apparel & Footwear | 291.17 | 26.86 | 0.0 | 0.0 | 0.0 | 33 | 18 | 83.33 Kiezkind | Apparel & Footwear | 159.75 | 0.0 | 0.0 | 0.0 | 0.0 | 25 | 13 | 92.31 Trailmark | Sports & Outdoor | 157.98 | 35.45 | 0.0 | 14.29 | 0.0 | 10 | 20 | -50.0 Bytefield | Consumer Electronics | 134.47 | 0.0 | 8.33 | 0.0 | 0.0 | 26 | 15 | 73.33 Little Larch Kids | Apparel & Footwear | 94.74 | 15.06 | 22.22 | 0.0 | 0.0 | 19 | 8 | 137.5 Fell & Fjell | Sports & Outdoor | 89.11 | 4.47 | 5.56 | 9.09 | 0.0 | 53 | 60 | -11.67 Ondine Botanicals | Beauty | 61.07 | 5.23 | 0.0 | 14.29 | 0.0 | 23 | 11 | 109.09 Northstar Watches | Jewelry & Accessories | 53.24 | 0.0 | 20.0 | 0.0 | 0.0 | 30 | 18 | 66.67 Fjordline Wear | Apparel & Footwear | 42.26 | 54.72 | 12.0 | 0.0 | 0.0 | 68 | 27 | 151.85 Lumen Collective | Apparel & Footwear | 40.79 | 35.36 | 4.55 | 0.0 | 0.0 | 36 | 27 | 33.33 Cragsley Outfitters | Apparel & Footwear | 38.34 | 44.45 | 3.93 | 4.59 | 0.0 | 2942 | 1858 | 58.34 Studio Vrij | Apparel & Footwear | 37.28 | 88.42 | 5.93 | 5.66 | 0.0 | 423 | 310 | 36.45 Atelier Nouveau | Apparel & Footwear | 36.65 | 40.59 | 3.13 | 5.88 | 0.0 | 73 | 23 | 217.39 Marrowby & Vane | Apparel & Footwear | 31.77 | 39.47 | 4.57 | 5.08 | 0.0 | 1299 | 826 | 57.26 Lamplight Living | Home & Living | 30.88 | 0.73 | 5.26 | 0.0 | 0.0 | 69 | 35 | 97.14 Copper Lane | Apparel & Footwear | 27.79 | 0.0 | 0.0 | 0.0 | 0.0 | 25 | 2 | 1150.0 Gratlinie Outdoor | Sports & Outdoor | 25.09 | 22.79 | 1.37 | 5.66 | 0.0 | 266 | 169 | 57.4 Cinder Peak Sports Co. | Sports & Outdoor | 24.1 | 10.31 | 2.83 | 5.56 | 0.0 | 264 | 206 | 28.16 Rue Lafayette Studio | Apparel & Footwear | 23.89 | 31.33 | 6.35 | 13.95 | 0.0 | 136 | 78 | 74.36 Velvet Ash | Apparel & Footwear | 23.54 | 53.65 | 3.85 | 3.57 | 0.0 | 78 | 62 | 25.81 Bijoux Lune | Jewelry & Accessories | 23.23 | 0.0 | 0.0 | 0.0 | 0.0 | 18 | 18 | 0.0 Ostwind Mode | Apparel & Footwear | 21.01 | 21.53 | 0.0 | 4.35 | 0.0 | 69 | 65 | 6.15 Thistlecombe | Apparel & Footwear | 20.79 | 29.15 | 4.55 | 8.33 | 0.0 | 133 | 63 | 111.11 Oakhurst Tailoring | Apparel & Footwear | 20.52 | 15.83 | 3.61 | 10.81 | 0.0 | 131 | 81 | 61.73 Willow & Wren | Home & Living | 20.41 | 7.71 | 3.03 | 0.0 | 0.0 | 91 | 60 | 51.67 Velours Paris | Beauty | 20.19 | 0.0 | 0.0 | 0.0 | 0.0 | 21 | 11 | 90.91 Strandgut | Apparel & Footwear | 16.08 | 74.04 | 0.0 | 0.0 | 0.0 | 41 | 21 | 95.24 Lumio Tech | Consumer Electronics | 14.74 | 0.0 | 0.0 | 0.0 | 0.0 | 23 | 5 | 360.0 Sorella Skin | Beauty | 14.62 | 2.41 | 6.67 | 4.17 | 0.0 | 43 | 23 | 86.96 Ampfeld Elektronik | Consumer Electronics | 14.5 | 2.52 | 4.17 | 3.8 | 0.0 | 683 | 292 | 133.9 Ridgeback Gear | Sports & Outdoor | 14.14 | 17.35 | 3.33 | 7.69 | 0.0 | 44 | 39 | 12.82 Hus & Hem | Home & Living | 13.87 | 12.11 | 7.14 | 22.22 | 0.0 | 71 | 26 | 173.08 Saffron & Sage | Beauty | 13.33 | 10.65 | 2.27 | 8.0 | 0.0 | 47 | 31 | 51.61 Noordzee Surfwear | Apparel & Footwear | 11.72 | 26.41 | 0.0 | 12.5 | 0.0 | 67 | 42 | 59.52 Kettle & Key | Home & Living | 11.71 | 0.0 | 0.0 | 0.0 | 0.0 | 47 | 31 | 51.61 Seilschaft | Sports & Outdoor | 11.51 | 0.0 | 22.22 | 0.0 | 0.0 | 35 | 10 | 250.0 Maison Clair | Apparel & Footwear | 11.13 | 12.44 | 7.41 | 0.0 | 0.0 | 44 | 21 | 109.52 Nordic Bloom Cosmetics | Beauty | 10.59 | 15.03 | 10.42 | 10.81 | 0.0 | 74 | 62 | 19.35 Basecamp Nord | Sports & Outdoor | 10.29 | 5.57 | 10.0 | 0.0 | 0.0 | 24 | 13 | 84.62 Wiesgrund Wohnen | Home & Living | 10.13 | 11.57 | 2.7 | 3.28 | 0.0 | 223 | 159 | 40.25 Feather & Fin | Pet Supplies | 9.93 | 4.61 | 3.95 | 2.0 | 0.0 | 58 | 47 | 23.4 Petalcourt Beauty | Beauty | 9.38 | 13.98 | 5.16 | 4.32 | 0.0 | 481 | 216 | 122.69 (50 rows) === Report 3: Merchant customer base health: repeat purchase rate (written by Bea) === Engineer's note: Used placed_at between 2025-01-01 and 2026-01-01 (calendar year 2025, the warehouse's last full 12 months) as the "last 12 months" window, excluding cancelled orders as specified; merchants with zero orders in the period are omitted since repeat/average rates would be undefined for them. REPORT: Merchant customer base health: repeat purchase rate QUESTION: For each merchant, how much of their customer base is repeat buyers versus one-and-done, over the last 12 months? tenant_id | merchant_name | industry | distinct_customers | repeat_customers | repeat_purchase_rate_pct | total_orders_last_12_months | avg_orders_per_customer ----------+-------------------------------+---------------------------+--------------------+------------------+--------------------------+-----------------------------+------------------------ 7 | Cragsley Outfitters | Apparel & Footwear | 1356 | 795 | 58.6 | 3486 | 2.57 2 | Marrowby & Vane | Apparel & Footwear | 641 | 374 | 58.3 | 1674 | 2.61 18 | Brennquell Kaffee | Food & Coffee | 444 | 382 | 86.0 | 4132 | 9.31 25 | Studio Vrij | Apparel & Footwear | 254 | 141 | 55.5 | 599 | 2.36 40 | Petalcourt Beauty | Beauty | 228 | 139 | 61.0 | 674 | 2.96 17 | Ampfeld Elektronik | Consumer Electronics | 209 | 94 | 45.0 | 432 | 2.07 5 | Fennel & Flint | Home & Living | 173 | 86 | 49.7 | 379 | 2.19 29 | Cinder Peak Sports Co. | Sports & Outdoor | 151 | 78 | 51.7 | 328 | 2.17 35 | Wiesgrund Wohnen | Home & Living | 121 | 65 | 53.7 | 285 | 2.36 42 | Gratlinie Outdoor | Sports & Outdoor | 114 | 52 | 45.6 | 226 | 1.98 30 | Linden & Loom | Home & Living | 112 | 59 | 52.7 | 251 | 2.24 1 | Grind Collective | Food & Coffee | 104 | 98 | 94.2 | 1094 | 10.52 79 | Kibblewick | Pet Supplies | 104 | 82 | 78.8 | 651 | 6.26 12 | Spice Route Box | Food & Coffee | 102 | 87 | 85.3 | 766 | 7.51 9 | Honeycomb Larder | Food & Coffee | 75 | 65 | 86.7 | 610 | 8.13 11 | Ballycorran Industrial Supply | Industrial Supplies (B2B) | 73 | 61 | 83.6 | 339 | 4.64 38 | Coastline Interiors | Home & Living | 68 | 35 | 51.5 | 149 | 2.19 20 | Sourdough Club | Food & Coffee | 66 | 50 | 75.8 | 303 | 4.59 10 | Wohnglück | Home & Living | 66 | 33 | 50.0 | 142 | 2.15 32 | Oakhurst Tailoring | Apparel & Footwear | 63 | 39 | 61.9 | 155 | 2.46 13 | Rue Lafayette Studio | Apparel & Footwear | 62 | 41 | 66.1 | 171 | 2.76 19 | Kontor24 Bürobedarf | Office Supplies (B2B) | 60 | 48 | 80.0 | 259 | 4.32 26 | Velvet Ash | Apparel & Footwear | 56 | 32 | 57.1 | 130 | 2.32 58 | Nordic Bloom Cosmetics | Beauty | 53 | 34 | 64.2 | 135 | 2.55 6 | Willow & Wren | Home & Living | 53 | 22 | 41.5 | 95 | 1.79 16 | Ostwind Mode | Apparel & Footwear | 43 | 23 | 53.5 | 119 | 2.77 39 | Kayak Corner | Sports & Outdoor | 43 | 19 | 44.2 | 101 | 2.35 3 | Juniper Apothecary | Beauty | 42 | 30 | 71.4 | 149 | 3.55 82 | Thistlecombe | Apparel & Footwear | 41 | 21 | 51.2 | 87 | 2.12 48 | Ridgeback Gear | Sports & Outdoor | 39 | 24 | 61.5 | 104 | 2.67 8 | Castell Fasteners | Industrial Supplies (B2B) | 35 | 31 | 88.6 | 156 | 4.46 14 | OfficeHub Nordic | Office Supplies (B2B) | 35 | 29 | 82.9 | 167 | 4.77 41 | The Balm Room | Beauty | 34 | 21 | 61.8 | 101 | 2.97 22 | Midland Safety Wear | Industrial Supplies (B2B) | 33 | 28 | 84.8 | 140 | 4.24 61 | Saffron & Sage | Beauty | 33 | 22 | 66.7 | 113 | 3.42 33 | Fell & Fjell | Sports & Outdoor | 32 | 21 | 65.6 | 79 | 2.47 74 | Sorella Skin | Beauty | 31 | 21 | 67.7 | 94 | 3.03 46 | Feather & Fin | Pet Supplies | 30 | 28 | 93.3 | 215 | 7.17 27 | Ampere & Co. | Consumer Electronics | 30 | 18 | 60.0 | 60 | 2.0 53 | Noordzee Surfwear | Apparel & Footwear | 30 | 15 | 50.0 | 61 | 2.03 28 | Atelier Nouveau | Apparel & Footwear | 28 | 15 | 53.6 | 60 | 2.14 21 | Kettle & Key | Home & Living | 23 | 13 | 56.5 | 60 | 2.61 44 | Whisker Works | Pet Supplies | 22 | 16 | 72.7 | 177 | 8.05 56 | Lamplight Living | Home & Living | 22 | 13 | 59.1 | 48 | 2.18 59 | Lumen Collective | Apparel & Footwear | 22 | 12 | 54.5 | 51 | 2.32 36 | Fjordline Wear | Apparel & Footwear | 21 | 14 | 66.7 | 54 | 2.57 52 | Hautnah | Beauty | 20 | 15 | 75.0 | 91 | 4.55 4 | Hus & Hem | Home & Living | 20 | 5 | 25.0 | 34 | 1.7 45 | Maison Clair | Apparel & Footwear | 19 | 12 | 63.2 | 51 | 2.68 24 | Fern & Fable | Home & Living | 18 | 8 | 44.4 | 40 | 2.22 (50 rows)