=== Report 1: Fennel & Flint and Wiesgrund Wohnen: Review Sentiment vs Delivery Performance, Monthly (written by Ines) === Engineer's note: pct_delivered_within_5_days excludes shipments with a null delivered_at from both numerator and denominator per the request; the count of such excluded shipments isn't shown as a column since it wasn't in the requested grain, but it equals shipments_count minus the implied delivered_known count for each row if you need to inspect it separately. REPORT: Fennel & Flint and Wiesgrund Wohnen: Review Sentiment vs Delivery Performance, Monthly QUESTION: Did delivery delays coincide with the rating dip at the two Home & Living merchants flagged last week, consistent with the platform-wide carrier breakdown? merchant_name | month | review_count | avg_rating | pct_1_2_star | shipments_count | pct_delivered_within_5_days | pct_shipped_via_albion_parcel -----------------+---------+--------------+------------+--------------+-----------------+-----------------------------+------------------------------ Fennel & Flint | 2025-07 | 1 | 5.00 | 0.0 | 24 | 87.5 | 45.8 Fennel & Flint | 2025-08 | 4 | 3.50 | 50.0 | 26 | 88.5 | 57.7 Fennel & Flint | 2025-09 | 4 | 3.00 | 50.0 | 23 | 82.6 | 39.1 Fennel & Flint | 2025-10 | 5 | 4.60 | 0.0 | 36 | 86.1 | 47.2 Fennel & Flint | 2025-11 | 2 | 4.00 | 0.0 | 54 | 53.7 | 55.6 Fennel & Flint | 2025-12 | 14 | 3.14 | 35.7 | 81 | 70.3 | 32.1 Wiesgrund Wohnen | 2025-07 | 2 | 4.00 | 0.0 | 12 | 100.0 | 0.0 Wiesgrund Wohnen | 2025-08 | 5 | 4.20 | 20.0 | 16 | 87.5 | 0.0 Wiesgrund Wohnen | 2025-09 | 1 | 4.00 | 0.0 | 31 | 87.1 | 0.0 Wiesgrund Wohnen | 2025-10 | 3 | 2.67 | 33.3 | 30 | 83.3 | 0.0 Wiesgrund Wohnen | 2025-11 | 3 | 4.33 | 0.0 | 33 | 90.9 | 0.0 Wiesgrund Wohnen | 2025-12 | 12 | 3.50 | 41.7 | 48 | 93.8 | 0.0 (12 rows) === Report 2: Image-Count Buckets: Product Age, Status, and Vertical Mix (written by Bea) === Engineer's note: tenants.industry is free text, not a fixed enum, so apparel/footwear and B2B (office+industrial) shares are matched via case-insensitive substring matching on keywords ('apparel'/'footwear', 'office'/'industrial') rather than exact category codes; this could miss or over-match if the stored labels differ from expectations. REPORT: Image-Count Buckets: Product Age, Status, and Vertical Mix QUESTION: Are zero-image product listings systematically different from one-plus-image listings (older, more likely draft/archived, or concentrated in certain verticals), rather than the image count itself being the driver? image_count_bucket | product_count | avg_days_since_created | pct_status_draft | pct_status_archived | pct_status_active | pct_apparel_footwear_industry | pct_b2b_industry | avg_variants_per_product -------------------+---------------+------------------------+------------------+---------------------+-------------------+-------------------------------+------------------+------------------------- 0 | 85 | 1136.1 | 0.0 | 0.0 | 100.0 | 34.1 | 0.0 | 3.4 1 | 1951 | 1039.9 | 3.0 | 56.0 | 41.0 | 26.7 | 7.8 | 5.5 2-3 | 10226 | 1048.1 | 2.8 | 58.2 | 39.0 | 26.5 | 7.7 | 5.4 4-6 | 8118 | 1042.6 | 3.0 | 57.8 | 39.2 | 26.9 | 7.7 | 5.5 7+ | 669 | 1032.0 | 3.3 | 58.0 | 38.7 | 27.5 | 8.5 | 5.5 (5 rows) === Report 3: Merchants Using Bundles: Raw Profile (written by Viktor) === Engineer's note: Assumed definitions consistent with the named earlier reports: active_product_count/avg_variants_per_product scoped to status='active' products (variants with is_active=true); "in a bundle" means the product's variant appears as a component (bundle_items.variant_id) of an active bundle; revenue and AOV use orders placed 2025-01-01..2025-12-31, status<>'cancelled', converted to EUR via exchange_rates(EUR->currency, same day). If those earlier reports used different scoping, figures may need reconciling. REPORT: Merchants Using Bundles: Raw Profile QUESTION: Among the handful of merchants that actually use product bundles, is there anything descriptively distinctive about them compared to the typical merchant? merchant_name | industry | active_bundle_count | pct_active_products_in_a_bundle | active_product_count | avg_variants_per_product | revenue_eur_last_12mo | avg_order_value_eur_last_12mo -----------------------+-----------------------+---------------------+---------------------------------+----------------------+--------------------------+-----------------------+------------------------------ Marginalia | Books & Stationery | 3 | 18.0 | 61 | 2.02 | NULL | NULL Maison Terre | Home & Living | 4 | 15.5 | 71 | 1.7 | NULL | NULL Olive & Oak Pantry | Food & Coffee | 4 | 13.5 | 74 | 1.22 | 118.55 | 118.55 Kaffeekontor Nord | Food & Coffee | 3 | 11.4 | 70 | 1.17 | NULL | NULL Petal & Pestle | Beauty | 3 | 11.1 | 18 | 2.0 | NULL | NULL Chocolaterie Mireille | Food & Coffee | 4 | 10.1 | 79 | 1.48 | NULL | NULL Pixelhaus | Consumer Electronics | 3 | 9.6 | 73 | 2.29 | NULL | NULL Glasshouse Grooming | Beauty | 2 | 9.2 | 76 | 2.33 | 1397.46 | 155.27 Goldkind | Jewelry & Accessories | 3 | 8.9 | 79 | 1.95 | NULL | NULL Roast Republic | Food & Coffee | 4 | 8.3 | 36 | 1.89 | 5488.11 | 107.61 Aurum & Ash | Jewelry & Accessories | 2 | 8.1 | 37 | 3.03 | NULL | NULL Dewdrop Studio | Beauty | 4 | 7.4 | 68 | 2.09 | 271.34 | 54.27 Signalbox | Consumer Electronics | 2 | 7.1 | 70 | 2.27 | 1439.85 | 287.97 Hautnah | Beauty | 4 | 6.8 | 44 | 2.34 | NULL | NULL Buchstabe | Books & Stationery | 4 | 6.7 | 45 | 2.13 | NULL | NULL Bytefield | Consumer Electronics | 4 | 6.5 | 46 | 2.33 | 12458.03 | 566.27 Northwire Audio | Consumer Electronics | 3 | 6.5 | 31 | 2.48 | NULL | NULL Velours Paris | Beauty | 4 | 6.5 | 46 | 2.65 | NULL | NULL Ondine Botanicals | Beauty | 3 | 6.3 | 63 | 2.3 | NULL | NULL Circuit Harbor | Consumer Electronics | 3 | 5.4 | 93 | 2.24 | 18806.68 | 1044.82 Rosehip Lab | Beauty | 2 | 4.9 | 82 | 2.26 | 2857.4 | 98.53 Brewline Coffee | Food & Coffee | 1 | 4.8 | 84 | 1.55 | NULL | NULL Tidepool Jewels | Jewelry & Accessories | 1 | 4.8 | 83 | 5.8 | NULL | NULL Teapot Society | Food & Coffee | 1 | 4.5 | 66 | 1.38 | 78.81 | 78.81 Lumio Tech | Consumer Electronics | 1 | 4.3 | 69 | 1.94 | NULL | NULL Honeycomb Larder | Food & Coffee | 3 | 3.9 | 77 | 1.0 | 17169.59 | 28.15 Driftwood Home | Home & Living | 3 | 3.9 | 51 | 2.08 | 4093.15 | 163.73 Klara Beauty | Beauty | 1 | 3.8 | 53 | 1.85 | NULL | NULL Coastline Interiors | Home & Living | 4 | 3.7 | 81 | 2.37 | 20669.23 | 138.72 Kabelwerk | Consumer Electronics | 1 | 3.7 | 81 | 2.46 | NULL | NULL Lamplight Living | Home & Living | 3 | 3.2 | 63 | 1.98 | 6630.61 | 138.14 Mirelle | Beauty | 4 | 3.1 | 32 | 1.84 | NULL | NULL Nordic Bloom Cosmetics | Beauty | 4 | 2.9 | 68 | 2.22 | 16425.2 | 121.67 Silverthread | Jewelry & Accessories | 2 | 2.9 | 70 | 3.96 | 3001.87 | 230.91 Sorella Skin | Beauty | 1 | 2.9 | 69 | 2.03 | NULL | NULL The Balm Room | Beauty | 2 | 2.8 | 36 | 2.28 | 12420.47 | 122.97 Paperplane Press | Books & Stationery | 4 | 2.8 | 36 | 2.14 | 2808.37 | 54.01 Inkwell & Quire | Books & Stationery | 1 | 2.5 | 81 | 2.02 | 646.82 | 43.12 The Pencil Case | Books & Stationery | 1 | 2.5 | 79 | 2.14 | 25.95 | 6.49 Stoneware Studio | Home & Living | 3 | 2.3 | 44 | 2.41 | 2952.89 | 118.12 Fern & Fable | Home & Living | 4 | 2.3 | 44 | 1.86 | NULL | NULL Oak & Ember | Home & Living | 1 | 2.2 | 90 | 2.17 | NULL | NULL Juniper Apothecary | Beauty | 2 | 1.9 | 53 | 1.96 | 17051.87 | 114.44 Saffron & Sage | Beauty | 4 | 1.9 | 53 | 1.75 | 6674.76 | 59.07 Folio & Fern | Books & Stationery | 2 | 1.9 | 54 | 2.15 | 1963.85 | 45.67 Grind Collective | Food & Coffee | 3 | 1.3 | 79 | 1.13 | 24732.45 | 22.61 Ampfeld Elektronik | Consumer Electronics | 3 | 1.1 | 178 | 2.3 | NULL | NULL Wiesgrund Wohnen | Home & Living | 3 | 0.9 | 106 | 2.2 | NULL | NULL Brennquell Kaffee | Food & Coffee | 3 | 0.6 | 175 | 1.33 | NULL | NULL Fennel & Flint | Home & Living | 1 | 0.0 | 93 | 2.62 | 64080.39 | 169.08 (50 rows)