=== Report 1: Poorly-Rated Product Concentration by Merchant (written by Ines) === Engineer's note: Top-50 set is independently re-derived here using the same revenue definition (orders placed 2025-01-01..2025-12-31, non-cancelled, converted to EUR via exchange_rates as of placed_at) rather than joining to a stored Merchant Catalog Profile output, so results should match that report's top-50 as long as its revenue logic is identical. Returns at most 50 rows (one per top-50 merchant); merchants with zero products having 5+ approved reviews show pct_poor_rated_products as blank/NULL. REPORT: Poorly-Rated Product Concentration by Merchant QUESTION: Which merchants have the largest share of their reviewed catalog sitting at genuinely poor ratings, rather than a few isolated bad products? merchant_name | industry | products_with_5plus_reviews | poor_rated_product_count | pct_poor_rated_products | revenue_eur_last_12mo ------------------------------+---------------------------+-----------------------------+--------------------------+-------------------------+---------------------- Cragsley Outfitters | Apparel & Footwear | 105 | 23 | 21.9 | 695715.59 Brennquell Kaffee | Food & Coffee | 61 | 8 | 13.1 | 110605.14 Marrowby & Vane | Apparel & Footwear | 28 | 5 | 17.9 | 275390.8 Studio Vrij | Apparel & Footwear | 10 | 4 | 40.0 | 107895.83 Honeycomb Larder | Food & Coffee | 4 | 2 | 50.0 | 17169.59 Spice Route Box | Food & Coffee | 5 | 2 | 40.0 | 16621.02 Grind Collective | Food & Coffee | 10 | 2 | 20.0 | 24732.45 Sourdough Club | Food & Coffee | 4 | 1 | 25.0 | 29078.06 Petalcourt Beauty | Beauty | 7 | 1 | 14.3 | 60927.41 Ampfeld Elektronik | Consumer Electronics | 6 | 0 | 0.0 | 488140.14 Ballycorran Industrial Supply | Industrial Supplies (B2B) | 4 | 0 | 0.0 | 530869.92 Castell Fasteners | Industrial Supplies (B2B) | 1 | 0 | 0.0 | 376053.99 Cinder Peak Sports Co. | Sports & Outdoor | 1 | 0 | 0.0 | 122664.88 Fennel & Flint | Home & Living | 1 | 0 | 0.0 | 64080.39 Gratlinie Outdoor | Sports & Outdoor | 4 | 0 | 0.0 | 93270.92 Kayak Corner | Sports & Outdoor | 1 | 0 | 0.0 | 39065.09 Kibblewick | Pet Supplies | 1 | 0 | 0.0 | 22531.09 Kontor24 Bürobedarf | Office Supplies (B2B) | 5 | 0 | 0.0 | 837423.2 Linden & Loom | Home & Living | 3 | 0 | 0.0 | 36505.73 Midland Safety Wear | Industrial Supplies (B2B) | 2 | 0 | 0.0 | 300676.75 OfficeHub Nordic | Office Supplies (B2B) | 3 | 0 | 0.0 | 399338.22 Rue Lafayette Studio | Apparel & Footwear | 2 | 0 | 0.0 | 27219.69 Wiesgrund Wohnen | Home & Living | 2 | 0 | 0.0 | 36991.03 Ampere & Co. | Consumer Electronics | 0 | 0 | NULL | 28717.13 Basecamp Nord | Sports & Outdoor | 0 | 0 | NULL | 9674.26 Bytefield | Consumer Electronics | 0 | 0 | NULL | 12458.03 Circuit Harbor | Consumer Electronics | 0 | 0 | NULL | 18806.68 Coastline Interiors | Home & Living | 0 | 0 | NULL | 20669.23 Deskline Supplies | Office Supplies (B2B) | 0 | 0 | NULL | 285178.35 Fell & Fjell | Sports & Outdoor | 0 | 0 | NULL | 35677.12 Hanse Industriebedarf | Industrial Supplies (B2B) | 0 | 0 | NULL | 113320.38 Hautnah | Beauty | 0 | 0 | NULL | 9170.72 Juniper Apothecary | Beauty | 0 | 0 | NULL | 17051.87 Meadow Row | Apparel & Footwear | 0 | 0 | NULL | 9825.26 Noordzee Surfwear | Apparel & Footwear | 0 | 0 | NULL | 10540.22 Nordic Bloom Cosmetics | Beauty | 0 | 0 | NULL | 16425.2 Oakhurst Tailoring | Apparel & Footwear | 0 | 0 | NULL | 24024.22 Ostwind Mode | Apparel & Footwear | 0 | 0 | NULL | 20838.76 Papeterie Grossiste | Office Supplies (B2B) | 0 | 0 | NULL | 40038.04 Pixelhaus | Consumer Electronics | 0 | 0 | NULL | 17011.55 Polder Packaging | Industrial Supplies (B2B) | 0 | 0 | NULL | 95255.14 Ridgeback Gear | Sports & Outdoor | 0 | 0 | NULL | 26906.57 Sorella Skin | Beauty | 0 | 0 | NULL | 9556.98 Strandgut | Apparel & Footwear | 0 | 0 | NULL | 12612.16 The Balm Room | Beauty | 0 | 0 | NULL | 12420.47 Thistlecombe | Apparel & Footwear | 0 | 0 | NULL | 11735.12 Velo Noord | Sports & Outdoor | 0 | 0 | NULL | 9650.03 Velvet Ash | Apparel & Footwear | 0 | 0 | NULL | 23591.19 Willow & Wren | Home & Living | 0 | 0 | NULL | 18796.06 Wohnglück | Home & Living | 0 | 0 | NULL | 20892.89 (50 rows) === Report 2: High-Selling Products With Few or No Reviews (written by Grace) === Engineer's note: Revenue uses order_items.line_total (post-discount, pre-tax) converted to EUR via the day's EUR exchange rate; "last 12mo" is read as calendar year 2025 (placed_at 2025-01-01 to 2025-12-31) per the stated filter. Review count/rating are all-time across approved reviews, as specified. Results are capped at 50 rows per house standard; the report will note the total number of qualifying products. REPORT: High-Selling Products With Few or No Reviews QUESTION: Which products sell well but have surprisingly little customer review feedback, suggesting a listing or follow-up gap rather than a demand problem? product_name | merchant_name | industry | units_sold_last_12mo | revenue_eur_last_12mo | review_count | avg_rating ------------------------------------+---------------------+---------------------------+----------------------+-----------------------+--------------+----------- Lungo Coffee Pods (Office) | OfficeHub Nordic | Office Supplies (B2B) | 482 | 13450.0 | 0 | NULL 4x40 Pozi Wood Screws | Castell Fasteners | Industrial Supplies (B2B) | 428 | 23941.0 | 2 | 3.00 Cast 400mm x 250m Pallet Wrap | Castell Fasteners | Industrial Supplies (B2B) | 375 | 12393.0 | 1 | 1.00 Sensitive 1L Hand Soap Refill | OfficeHub Nordic | Office Supplies (B2B) | 270 | 1230.0 | 0 | NULL 12V Compact Cordless Drill | Castell Fasteners | Industrial Supplies (B2B) | 248 | 61953.0 | 0 | NULL 115mm Steel Cutting Discs | Castell Fasteners | Industrial Supplies (B2B) | 234 | 5548.0 | 1 | 5.00 Brushless 18V Kit Cordless Drill | Castell Fasteners | Industrial Supplies (B2B) | 230 | 20667.0 | 0 | NULL A4 75mm Lever Arch File | Deskline Supplies | Office Supplies (B2B) | 226 | 7784.0 | 0 | NULL Thermal Safety Gloves | Castell Fasteners | Industrial Supplies (B2B) | 216 | 518.0 | 0 | NULL 1600x800 Dual Motor Sit-Stand Desk | OfficeHub Nordic | Office Supplies (B2B) | 189 | 83874.0 | 2 | 2.00 Magenta Toner Cartridge | Deskline Supplies | Office Supplies (B2B) | 185 | 8772.0 | 0 | NULL A4 50mm Lever Arch File | Deskline Supplies | Office Supplies (B2B) | 177 | 1447.0 | 1 | 3.00 M8x30 Zinc Hex Bolts | Castell Fasteners | Industrial Supplies (B2B) | 161 | 2389.0 | 1 | 5.00 Chemical Resistant Safety Gloves | Castell Fasteners | Industrial Supplies (B2B) | 155 | 1132.0 | 0 | NULL 115mm Steel Cutting Discs | Castell Fasteners | Industrial Supplies (B2B) | 137 | 2825.0 | 1 | 5.00 Lungo Coffee Pods (Office) | OfficeHub Nordic | Office Supplies (B2B) | 124 | 2274.0 | 2 | 4.50 Raspberry White Chocolate Bar | Grind Collective | Food & Coffee | 123 | 240.0 | 2 | 5.00 2L Foam Hand Soap Refill | OfficeHub Nordic | Office Supplies (B2B) | 108 | 1750.0 | 0 | NULL 230mm Angle Grinder | Castell Fasteners | Industrial Supplies (B2B) | 104 | 21972.0 | 0 | NULL Oversized Merino Scarf | Cragsley Outfitters | Apparel & Footwear | 102 | 3115.0 | 2 | 5.00 115mm Angle Grinder | Castell Fasteners | Industrial Supplies (B2B) | 98 | 15853.0 | 0 | NULL Blown 500mm x 300m Pallet Wrap | Castell Fasteners | Industrial Supplies (B2B) | 96 | 1810.0 | 1 | 5.00 115mm Angle Grinder | Castell Fasteners | Industrial Supplies (B2B) | 93 | 6167.0 | 1 | 3.00 Espresso Coffee Pods (Office) | OfficeHub Nordic | Office Supplies (B2B) | 92 | 3213.0 | 0 | NULL Blown 500mm x 300m Pallet Wrap | Castell Fasteners | Industrial Supplies (B2B) | 88 | 2855.0 | 0 | NULL A4 80gsm White Copy Paper | OfficeHub Nordic | Office Supplies (B2B) | 88 | 856.0 | 1 | 2.00 5x60 Torx Wood Screws | Castell Fasteners | Industrial Supplies (B2B) | 84 | 2492.0 | 0 | NULL Wrap Linen Dress | Cragsley Outfitters | Apparel & Footwear | 82 | 5557.0 | 2 | 5.00 A4 100gsm Premium Copy Paper | OfficeHub Nordic | Office Supplies (B2B) | 80 | 519.0 | 0 | NULL Everyday Organic Cotton Socks | Marrowby & Vane | Apparel & Footwear | 76 | 719.0 | 1 | 5.00 Corduroy Cotton Shirt | Cragsley Outfitters | Apparel & Footwear | 74 | 3833.0 | 1 | 2.00 Blue Medium Ballpoint Pens | OfficeHub Nordic | Office Supplies (B2B) | 74 | 1489.0 | 0 | NULL Cyan Toner Cartridge | OfficeHub Nordic | Office Supplies (B2B) | 73 | 3711.0 | 0 | NULL Cyan Toner Cartridge | Deskline Supplies | Office Supplies (B2B) | 72 | 6964.0 | 0 | NULL A4 80gsm White Copy Paper | OfficeHub Nordic | Office Supplies (B2B) | 71 | 1029.0 | 0 | NULL Pullover Loopback Cotton Hoodie | Cragsley Outfitters | Apparel & Footwear | 70 | 5000.0 | 1 | 5.00 Christmas Hamper Gift Box | Honeycomb Larder | Food & Coffee | 69 | 1462.0 | 2 | 1.50 Magenta Toner Cartridge | OfficeHub Nordic | Office Supplies (B2B) | 66 | 5429.0 | 0 | NULL Magenta Toner Cartridge | OfficeHub Nordic | Office Supplies (B2B) | 66 | 3868.0 | 1 | 5.00 A3 80gsm Copy Paper | OfficeHub Nordic | Office Supplies (B2B) | 65 | 1102.0 | 0 | NULL Espresso Coffee Pods (Office) | Deskline Supplies | Office Supplies (B2B) | 62 | 3523.0 | 1 | 5.00 2L Foam Hand Soap Refill | OfficeHub Nordic | Office Supplies (B2B) | 61 | 544.0 | 1 | 3.00 A4 80gsm White Copy Paper | Deskline Supplies | Office Supplies (B2B) | 59 | 39235.0 | 1 | 3.00 Blue Medium Ballpoint Pens | OfficeHub Nordic | Office Supplies (B2B) | 58 | 2970.0 | 0 | NULL Striped Organic Cotton Kids T-Shirt | Cragsley Outfitters | Apparel & Footwear | 58 | 758.0 | 2 | 3.00 Salted Caramel Hot Chocolate | Honeycomb Larder | Food & Coffee | 58 | 443.0 | 1 | 5.00 Cropped Chinos | Cragsley Outfitters | Apparel & Footwear | 54 | 3713.0 | 1 | 5.00 Checked Scarf | Cragsley Outfitters | Apparel & Footwear | 54 | 1509.0 | 0 | NULL Sensitive 1L Hand Soap Refill | OfficeHub Nordic | Office Supplies (B2B) | 54 | 1001.0 | 0 | NULL 125mm Brushless Angle Grinder | Castell Fasteners | Industrial Supplies (B2B) | 53 | 10771.0 | 0 | NULL (50 rows) === Report 3: Catalog Structure: Top Merchants vs Long Tail (written by Omar) === Engineer's note: Revenue ranking uses orders placed 2025-01-01..2025-12-31, status<>'cancelled', converted to EUR via exchange_rates(base=EUR, quote=order currency, as_of=placed_at date), matching the Merchant Catalog Profile definition. Product-level metrics (variants, categories, media, collection membership) are pooled across all active/non-deleted products within each tier rather than averaged merchant-by-merchant, since the request specifies them as "per product" measures. REPORT: Catalog Structure: Top Merchants vs Long Tail QUESTION: Do our top-revenue merchants' catalogs look structurally different from the long tail in size, categorization, and media richness? tier | merchant_count | avg_active_products_per_merchant | avg_variants_per_product | avg_categories_per_product | pct_products_with_primary_image | avg_media_count_per_product | pct_active_products_in_a_collection | revenue_share_pct --------+----------------+----------------------------------+--------------------------+----------------------------+---------------------------------+-----------------------------+-------------------------------------+------------------ Top 10 | 10 | 110.3 | 8.21 | 1.96 | 99.4 | 3.49 | 88.6 | 87.0 Next 20 | 20 | 73.3 | 4.89 | 1.93 | 98.8 | 3.39 | 87.9 | 10.7 Rest | 81 | 66.17 | 4.79 | 1.91 | 99.0 | 3.48 | 91.1 | 2.2 (3 rows)