=== Report 1: Home & Living December 2025 Rating Dip: Merchant Breakdown (written by Felix) === Engineer's note: Both dec2025_avg_rating and jan_to_nov_2025_avg_rating are rounded to 2 decimals before computing rating_change_pts, since the report is meant to show the rounded values a reader would compare on the page; merchants with 0 reviews in Jan-Nov 2025 are excluded via the inner join since no baseline exists for them. REPORT: Home & Living December 2025 Rating Dip: Merchant Breakdown QUESTION: Within Home & Living, is the December 2025 rating decline concentrated in a few merchants or spread across the vertical? merchant_name | dec2025_review_count | dec2025_avg_rating | dec2025_pct_1_2_star | jan_to_nov_2025_avg_rating | rating_change_pts --------------------+----------------------+--------------------+----------------------+----------------------------+------------------ Willow & Wren | 4 | 1.5 | 75.0 | 3.54 | -2.04 Haven Linen | 1 | 2.0 | 100.0 | 4.0 | -2.0 Wohnglück | 3 | 3.0 | 33.3 | 4.57 | -1.57 Fern & Fable | 1 | 3.0 | 0.0 | 4.14 | -1.14 Driftwood Home | 1 | 2.0 | 100.0 | 3.0 | -1.0 Fennel & Flint | 14 | 3.14 | 35.7 | 4.11 | -0.97 Coastline Interiors | 6 | 3.67 | 33.3 | 4.29 | -0.62 Wiesgrund Wohnen | 12 | 3.5 | 41.7 | 4.1 | -0.6 Hus & Hem | 1 | 3.0 | 0.0 | 3.4 | -0.4 Linden & Loom | 8 | 3.88 | 25.0 | 4.18 | -0.3 Lamplight Living | 1 | 4.0 | 0.0 | 4.2 | -0.2 Kettle & Key | 3 | 3.67 | 33.3 | 3.67 | 0.0 Tiny Atelier | 1 | 5.0 | 0.0 | 4.25 | 0.75 (13 rows) === Report 2: Lowest-Rated Products Platform-Wide With Sufficient Review Volume (written by Omar) === Engineer's note: Report is capped at 50 rows as requested (worst avg_rating first, ties broken by review_count desc then product id); the printed report footer will show how many products in total met the review_count >= 5 threshold. REPORT: Lowest-Rated Products Platform-Wide With Sufficient Review Volume QUESTION: Which specific products are getting the worst customer feedback, among those with enough reviews for the rating to be meaningful? product_name | merchant_name | industry | review_count | avg_rating | pct_1_2_star | units_sold_last_12mo -----------------------------------------+---------------------+--------------------+--------------+------------+--------------+--------------------- Aeropress Go Pour-Over Kit | Honeycomb Larder | Food & Coffee | 6 | 1.67 | 83.3 | 18 Poplin Cotton Shirt | Cragsley Outfitters | Apparel & Footwear | 9 | 2.0 | 77.8 | 2 Zip-Through Organic Cotton Fleece Hoodie | Cragsley Outfitters | Apparel & Footwear | 6 | 2.0 | 66.7 | 2 Milk Hazelnut Chocolate Bar | Brennquell Kaffee | Food & Coffee | 6 | 2.0 | 83.3 | 37 Flannel Cotton Shirt | Studio Vrij | Apparel & Footwear | 5 | 2.0 | 60.0 | 2 Waxed Wool Blend Jacket | Cragsley Outfitters | Apparel & Footwear | 7 | 2.14 | 71.4 | 0 Regular Cotton Twill Chinos | Marrowby & Vane | Apparel & Footwear | 5 | 2.2 | 60.0 | 5 Tiered Dress | Cragsley Outfitters | Apparel & Footwear | 5 | 2.2 | 60.0 | 21 Poplin Linen Shirt | Studio Vrij | Apparel & Footwear | 5 | 2.2 | 60.0 | 31 Oversized Lambswool Scarf | Studio Vrij | Apparel & Footwear | 5 | 2.2 | 80.0 | 58 Overshirt Linen Shirt | Marrowby & Vane | Apparel & Footwear | 9 | 2.22 | 55.6 | 44 Desert Waterproof Leather Boots | Marrowby & Vane | Apparel & Footwear | 7 | 2.29 | 57.1 | 14 Bomber Recycled Nylon Jacket | Cragsley Outfitters | Apparel & Footwear | 7 | 2.29 | 57.1 | 7 Poplin Linen Shirt | Cragsley Outfitters | Apparel & Footwear | 7 | 2.29 | 57.1 | 22 Ribbed Socks | Cragsley Outfitters | Apparel & Footwear | 7 | 2.29 | 42.9 | 44 Rwanda Nyamasheke Coffee Beans | Sourdough Club | Food & Coffee | 7 | 2.29 | 57.1 | 18 Garment Dyed Organic Cotton Fleece Hoodi | Cragsley Outfitters | Apparel & Footwear | 7 | 2.29 | 42.9 | 45 Overcoat Wool Coat | Marrowby & Vane | Apparel & Footwear | 9 | 2.33 | 55.6 | 16 Peacoat Coat | Cragsley Outfitters | Apparel & Footwear | 6 | 2.33 | 66.7 | 45 Brazil Cerrado Coffee Beans | Brennquell Kaffee | Food & Coffee | 26 | 2.38 | 57.7 | 36 Canvas Recycled Canvas Sneakers | Marrowby & Vane | Apparel & Footwear | 13 | 2.38 | 53.8 | 47 Oversized Hoodie | Cragsley Outfitters | Apparel & Footwear | 8 | 2.38 | 50.0 | 0 Electric Conical Coffee Grinder | Brennquell Kaffee | Food & Coffee | 8 | 2.38 | 50.0 | 9 Rain Waxed Cotton Jacket | Cragsley Outfitters | Apparel & Footwear | 5 | 2.4 | 60.0 | 22 Footbed Sandals | Cragsley Outfitters | Apparel & Footwear | 10 | 2.6 | 40.0 | 34 Aeropress Go Pour-Over Kit | Grind Collective | Food & Coffee | 5 | 2.6 | 40.0 | 7 Flannel Linen Shirt | Cragsley Outfitters | Apparel & Footwear | 5 | 2.6 | 40.0 | 20 Striped Organic Cotton Kids T-Shirt | Cragsley Outfitters | Apparel & Footwear | 5 | 2.6 | 60.0 | 26 Tea Explorer Gift Box | Spice Route Box | Food & Coffee | 5 | 2.6 | 40.0 | 13 House Espresso Blend Coffee Beans | Grind Collective | Food & Coffee | 8 | 2.63 | 37.5 | 90 Brightening Serum | Petalcourt Beauty | Beauty | 8 | 2.63 | 37.5 | 39 Milk Hot Chocolate | Brennquell Kaffee | Food & Coffee | 14 | 2.64 | 35.7 | 48 Zip-Through Loopback Cotton Hoodie | Cragsley Outfitters | Apparel & Footwear | 6 | 2.67 | 66.7 | 1 Sencha Loose Leaf Tea | Brennquell Kaffee | Food & Coffee | 6 | 2.67 | 33.3 | 0 Bootcut Jeans | Cragsley Outfitters | Apparel & Footwear | 10 | 2.7 | 50.0 | 25 Low-Top Sneakers | Cragsley Outfitters | Apparel & Footwear | 8 | 2.75 | 37.5 | 10 Slub Cotton Jersey T-Shirt | Cragsley Outfitters | Apparel & Footwear | 8 | 2.75 | 62.5 | 39 Milk Hot Chocolate | Spice Route Box | Food & Coffee | 5 | 2.8 | 40.0 | 3 Low-Top Sneakers | Studio Vrij | Apparel & Footwear | 5 | 2.8 | 40.0 | 11 Christmas Hamper Gift Box | Brennquell Kaffee | Food & Coffee | 5 | 2.8 | 20.0 | 0 Court Recycled Canvas Sneakers | Cragsley Outfitters | Apparel & Footwear | 6 | 2.83 | 33.3 | 4 Flat Burr Coffee Grinder | Honeycomb Larder | Food & Coffee | 6 | 2.83 | 33.3 | 2 Variety Pack (40) Coffee Capsules | Brennquell Kaffee | Food & Coffee | 6 | 2.83 | 16.7 | 31 Aeropress Go Pour-Over Kit | Brennquell Kaffee | Food & Coffee | 6 | 2.83 | 16.7 | 128 Straight Leg Jeans | Cragsley Outfitters | Apparel & Footwear | 6 | 2.83 | 50.0 | 38 Straight Leg Jeans | Cragsley Outfitters | Apparel & Footwear | 7 | 2.86 | 28.6 | 43 Oversized Scarf | Cragsley Outfitters | Apparel & Footwear | 7 | 2.86 | 28.6 | 49 Corduroy Linen Shirt | Cragsley Outfitters | Apparel & Footwear | 7 | 2.86 | 42.9 | 110 Aeropress Go Pour-Over Kit | Brennquell Kaffee | Food & Coffee | 10 | 3.0 | 10.0 | 39 Graphic Kids T-Shirt | Studio Vrij | Apparel & Footwear | 9 | 3.0 | 22.2 | 29 (50 rows) === Report 3: Collections and Bundles Adoption by Merchant (written by Viktor) === Engineer's note: Revenue window and EUR conversion mirror the Merchant Catalog Profile report (orders placed 2025-01-01 to 2025-12-31, status <> cancelled, EUR rate as of placed_at date). Percentages are null (shown as blank) for any tenant with zero active products, since the denominator is undefined; the report prints the top 50 by revenue and will note the total row count returned. REPORT: Collections and Bundles Adoption by Merchant QUESTION: How much are merchants leaning on curated collections and bundles rather than flat product listings, and does that line up with stronger sales? merchant_name | industry | active_collection_count | pct_active_products_in_a_collection | active_bundle_count | pct_active_products_in_a_bundle | revenue_eur_last_12mo | avg_order_value_eur_last_12mo -----------------------+---------------------------+-------------------------+-------------------------------------+---------------------+---------------------------------+-----------------------+------------------------------ Cragsley Outfitters | Apparel & Footwear | 8 | 92.7 | 0 | 0.0 | 695716.0 | 200.0 OfficeHub Nordic | Office Supplies (B2B) | 8 | 81.4 | 0 | 0.0 | 399338.0 | 2391.0 Castell Fasteners | Industrial Supplies (B2B) | 8 | 84.2 | 0 | 0.0 | 376054.0 | 2411.0 Deskline Supplies | Office Supplies (B2B) | 7 | 100.0 | 0 | 0.0 | 285178.0 | 3802.0 Marrowby & Vane | Apparel & Footwear | 8 | 93.3 | 0 | 0.0 | 275391.0 | 165.0 Cinder Peak Sports Co. | Sports & Outdoor | 8 | 87.3 | 0 | 0.0 | 122665.0 | 374.0 Fennel & Flint | Home & Living | 8 | 81.7 | 1 | 0.0 | 64080.0 | 169.0 Petalcourt Beauty | Beauty | 8 | 75.8 | 2 | 0.0 | 60927.0 | 90.0 Kayak Corner | Sports & Outdoor | 8 | 91.1 | 0 | 0.0 | 39065.0 | 387.0 Fell & Fjell | Sports & Outdoor | 8 | 86.5 | 0 | 0.0 | 35677.0 | 452.0 Grind Collective | Food & Coffee | 8 | 84.8 | 3 | 1.3 | 24732.0 | 23.0 Oakhurst Tailoring | Apparel & Footwear | 8 | 83.3 | 0 | 0.0 | 24024.0 | 155.0 Velvet Ash | Apparel & Footwear | 8 | 88.2 | 0 | 0.0 | 23591.0 | 181.0 Kibblewick | Pet Supplies | 6 | 100.0 | 0 | 0.0 | 22531.0 | 35.0 Coastline Interiors | Home & Living | 8 | 75.3 | 4 | 3.7 | 20669.0 | 139.0 Circuit Harbor | Consumer Electronics | 5 | 100.0 | 3 | 5.4 | 18807.0 | 1045.0 Willow & Wren | Home & Living | 8 | 81.3 | 2 | 0.0 | 18796.0 | 198.0 Honeycomb Larder | Food & Coffee | 8 | 81.8 | 3 | 3.9 | 17170.0 | 28.0 Juniper Apothecary | Beauty | 8 | 81.1 | 2 | 1.9 | 17052.0 | 114.0 Nordic Bloom Cosmetics | Beauty | 8 | 80.9 | 4 | 2.9 | 16425.0 | 122.0 Bytefield | Consumer Electronics | 7 | 100.0 | 4 | 6.5 | 12458.0 | 566.0 The Balm Room | Beauty | 8 | 80.6 | 2 | 2.8 | 12420.0 | 123.0 Thistlecombe | Apparel & Footwear | 5 | 99.4 | 0 | 0.0 | 11735.0 | 135.0 Meadow Row | Apparel & Footwear | 6 | 98.5 | 0 | 0.0 | 9825.0 | 409.0 Fjordline Wear | Apparel & Footwear | 8 | 70.5 | 0 | 0.0 | 7915.0 | 147.0 Feather & Fin | Pet Supplies | 8 | 81.5 | 0 | 0.0 | 6696.0 | 31.0 Saffron & Sage | Beauty | 8 | 83.0 | 4 | 1.9 | 6675.0 | 59.0 Courtside Collective | Sports & Outdoor | 5 | 98.8 | 0 | 0.0 | 6640.0 | 349.0 Lamplight Living | Home & Living | 8 | 66.7 | 3 | 3.2 | 6631.0 | 138.0 Tail Wag Supply | Pet Supplies | 8 | 65.1 | 0 | 0.0 | 5728.0 | 64.0 Roast Republic | Food & Coffee | 8 | 86.1 | 4 | 8.3 | 5488.0 | 108.0 Hus & Hem | Home & Living | 8 | 78.0 | 3 | 0.0 | 5173.0 | 152.0 Driftwood Home | Home & Living | 8 | 78.4 | 3 | 3.9 | 4093.0 | 164.0 Haven Linen | Home & Living | 8 | 90.9 | 2 | 0.0 | 3994.0 | 166.0 Tiny Atelier | Home & Living | 8 | 81.3 | 1 | 0.0 | 3750.0 | 117.0 Brick & Bobbin | Apparel & Footwear | 8 | 97.5 | 0 | 0.0 | 3589.0 | 144.0 Purrfect Pantry | Pet Supplies | 8 | 55.3 | 0 | 0.0 | 3544.0 | 49.0 Greyfriars Supply | Apparel & Footwear | 4 | 98.8 | 0 | 0.0 | 3149.0 | 225.0 Silverthread | Jewelry & Accessories | 6 | 98.6 | 2 | 2.9 | 3002.0 | 231.0 Stoneware Studio | Home & Living | 8 | 75.0 | 3 | 2.3 | 2953.0 | 118.0 Rosehip Lab | Beauty | 3 | 98.8 | 2 | 4.9 | 2857.0 | 99.0 Paperplane Press | Books & Stationery | 8 | 72.2 | 4 | 2.8 | 2808.0 | 54.0 Barkley & Co. | Pet Supplies | 7 | 100.0 | 0 | 0.0 | 2740.0 | 76.0 Little Larch Kids | Apparel & Footwear | 5 | 98.6 | 0 | 0.0 | 2583.0 | 117.0 Alpine Loft | Sports & Outdoor | 3 | 98.8 | 0 | 0.0 | 2430.0 | 1215.0 Halden Boots | Apparel & Footwear | 4 | 98.4 | 0 | 0.0 | 2280.0 | 207.0 Folio & Fern | Books & Stationery | 8 | 98.1 | 2 | 1.9 | 1964.0 | 46.0 Signalbox | Consumer Electronics | 3 | 100.0 | 2 | 7.1 | 1440.0 | 288.0 Glasshouse Grooming | Beauty | 3 | 98.7 | 2 | 9.2 | 1397.0 | 155.0 Copper Lane | Apparel & Footwear | 3 | 98.5 | 0 | 0.0 | 1004.0 | 167.0 (50 rows)