Live from the GoodDay BigQuery warehouse — no export lag
Season is by ship-window start date (ship_after_date): Spring 1/1–4/24, Summer 4/25–6/24, Fall 6/25–9/24, Holiday 9/25–12/31. Category/Department come from Shopify product data synced into GoodDay; a small share of legacy line items show as UNCLASSIFIED.
Loading…
Sales Rep is resolved from GoodDay's account-level assignment; a few reps may still show as a login email if no matching display name was found in order history. Buyer contact info, price code, and promotion fields from the original export aren't on this table and are omitted rather than guessed.
Loading…
One row per style, click to see which accounts bought it. Style is the parent item, so sizes are rolled up. Color is not shown because it is recorded on under 2% of order lines in GoodDay today; once it is being entered we can add it as a column.
Loading…
Each rep broken out by department, then by month of the ship window. P1 is the top number in each month cell, P2 underneath. Men's and Women's are kept separate.
Loading…
Preview, not final. Every figure here is live from the GoodDay warehouse, but this view is still being shaped.
Rows marked needs setup are pieces the warehouse cannot produce yet. See "Gaps to close" at the bottom.