=== Report 1: Image-Richness vs Sales Within Apparel & Footwear (written by Grace) === Engineer's note: Replicates the night-1 image-count-bucket methodology but restricted to products of tenants with industry = 'Apparel & Footwear'. Revenue converted to EUR using exchange_rates (EUR->order currency) as of the order's placed_at date; sales window is orders placed 2025-01-01 through 2025-12-31 with status not cancelled; avg_rating is the mean of each product's own average approved-review rating, computed only over products with at least one approved review, while zero-review products still contribute 0 to avg_reviews_per_product and to the sales averages. REPORT: Image-Richness vs Sales Within Apparel & Footwear QUESTION: Within a single vertical, removing the cross-vertical confound seen in the platform-wide bucket report, do products with more images actually sell better? image_count_bucket | product_count | pct_with_description | avg_variants_per_product | avg_reviews_per_product | avg_rating | avg_units_sold_per_product_last_12mo | avg_revenue_per_product_eur_last_12mo -------------------+---------------+----------------------+--------------------------+-------------------------+------------+--------------------------------------+-------------------------------------- 0 | 29 | 93.1 | 4.24 | 0.0 | NULL | 2.0 | 109.0 1 | 194 | 73.2 | 13.81 | 0.53 | 3.85 | 4.84 | 355.0 2-3 | 1004 | 69.92 | 12.92 | 0.66 | 3.62 | 5.74 | 382.0 4-6 | 768 | 69.79 | 13.05 | 0.65 | 3.75 | 5.49 | 326.0 7+ | 64 | 78.13 | 13.45 | 0.59 | 3.63 | 6.22 | 399.0 (5 rows) === Report 2: Review Engagement Relative to Order Volume (written by Bea) === Engineer's note: Built off calendar_days so every month 2023-01..2025-12 appears even with zero orders/reviews; reviews_per_100_orders is 0 when orders_count is 0 to avoid divide-by-zero, and avg_rating is 0 (not null) for months with no approved reviews. REPORT: Review Engagement Relative to Order Volume QUESTION: Is the month-over-month growth in review counts just tracking order volume growth, or is review-per-order engagement actually increasing? month | orders_count | review_count | reviews_per_100_orders | avg_rating --------+--------------+--------------+------------------------+----------- 2023-01 | 499 | 31 | 6.21 | 4.03 2023-02 | 522 | 90 | 17.24 | 3.82 2023-03 | 611 | 73 | 11.95 | 3.85 2023-04 | 653 | 107 | 16.39 | 3.97 2023-05 | 772 | 117 | 15.16 | 4.05 2023-06 | 713 | 113 | 15.85 | 3.92 2023-07 | 762 | 92 | 12.07 | 4.08 2023-08 | 813 | 130 | 15.99 | 4.07 2023-09 | 877 | 132 | 15.05 | 4.1 2023-10 | 1049 | 158 | 15.06 | 3.99 2023-11 | 1787 | 146 | 8.17 | 4.11 2023-12 | 1540 | 308 | 20.0 | 3.81 2024-01 | 1275 | 219 | 17.18 | 4.13 2024-02 | 1077 | 192 | 17.83 | 4.12 2024-03 | 1166 | 189 | 16.21 | 4.18 2024-04 | 1194 | 164 | 13.74 | 4.11 2024-05 | 1309 | 142 | 10.85 | 4.15 2024-06 | 1265 | 197 | 15.57 | 4.15 2024-07 | 1331 | 188 | 14.12 | 4.06 2024-08 | 1271 | 169 | 13.3 | 4.06 2024-09 | 1315 | 173 | 13.16 | 4.19 2024-10 | 1457 | 187 | 12.83 | 4.1 2024-11 | 2056 | 230 | 11.19 | 4.02 2024-12 | 2546 | 392 | 15.4 | 3.94 2025-01 | 1768 | 310 | 17.53 | 3.93 2025-02 | 1370 | 197 | 14.38 | 4.09 2025-03 | 1586 | 204 | 12.86 | 4.11 2025-04 | 1520 | 205 | 13.49 | 4.07 2025-05 | 1633 | 205 | 12.55 | 4.07 2025-06 | 1461 | 217 | 14.85 | 3.89 2025-07 | 1596 | 161 | 10.09 | 4.07 2025-08 | 1502 | 224 | 14.91 | 4.21 2025-09 | 1659 | 188 | 11.33 | 3.96 2025-10 | 1828 | 245 | 13.4 | 4.16 2025-11 | 2550 | 258 | 10.12 | 4.22 2025-12 | 2994 | 454 | 15.16 | 3.71 (36 rows) === Report 3: December Rating Dip by Vertical: 2024 vs 2025 (written by Omar) === Engineer's note: Grouped by tenants.industry (the vertical field); verticals with zero approved reviews in both Decembers are naturally excluded since they contribute no rows. rating_change_pts and the 1-2 star share are NULL/0 only if a vertical had no reviews in the relevant month. REPORT: December Rating Dip by Vertical: 2024 vs 2025 QUESTION: Which merchant vertical drove the platform-wide rating dip and spike in negative reviews seen in December 2025? industry | dec2024_review_count | dec2024_avg_rating | dec2025_review_count | dec2025_avg_rating | rating_change_pts | dec2025_pct_1_2_star --------------------------+----------------------+--------------------+----------------------+--------------------+-------------------+--------------------- Jewelry & Accessories | 2 | 5.00 | 1 | 3.00 | -2.00 | 0.0 Office Supplies (B2B) | 5 | 5.00 | 9 | 3.67 | -1.33 | 33.3 Pet Supplies | 10 | 4.50 | 18 | 3.61 | -0.89 | 33.3 Books & Stationery | 5 | 4.40 | 4 | 3.75 | -0.65 | 25.0 Consumer Electronics | 13 | 4.15 | 17 | 3.65 | -0.51 | 29.4 Home & Living | 42 | 3.86 | 59 | 3.36 | -0.50 | 35.6 Apparel & Footwear | 207 | 3.78 | 219 | 3.68 | -0.11 | 25.1 Beauty | 24 | 3.83 | 43 | 3.72 | -0.11 | 23.3 Food & Coffee | 65 | 4.29 | 61 | 4.20 | -0.10 | 16.4 Sports & Outdoor | 15 | 3.80 | 18 | 3.78 | -0.02 | 27.8 Industrial Supplies (B2B) | 4 | 4.00 | 5 | 4.00 | 0.00 | 20.0 (11 rows)