Which seller-funded promotions earn

Every seller-funded promotion that touched an order created in the window, one row per promotion and kind, product rows first and then shipping rows, each ranked by line_gmv: orders, units (gift lines excluded), the GMV of the lines that carried it, the mean whole-order GMV of those orders against the same kind's no-promotion baseline, the seller discount it cost and GMV per discount dollar, orders it shared with another promotion of the same kind, and refunded orders. product and shipping promotions are separate rows and must never be summed or ranked together. low_sample marks rows under 20 orders. Numbers cover settled orders only, about a week behind: compare only days before coverage.incomplete_after. A shop the daily price-breakdown sync does not cover reads coverage.state=not_collected with empty rows. Rows total the whole window, so to rank on complete days only, call again with end_date the day before coverage.incomplete_after. Titles, types and windows come from TikTok for the top 20 by line_gmv, cached up to an hour; metadata_status says whether they came back.