Market basket — trailing 13 weeks

Audience: marketing & loyalty · AMG company ops · inside-store merchandise

Store Cohort

Sample data shown. Run market_basket_queries.sql in Snowflake and paste each result into the matching // === Q# === block below in this file (open it in a text editor).

Inside sales

—

trailing 13 wks

Baskets

—

avg ticket inside

Items per basket

—

lines / basket

Loyalty attach

—

basket-level swipe rate

Loyalty lift

—

loyal vs non-loyal ticket

Daily trend sales (bars) · loyalty attach % (line)

Department mix share of sales

Loyalty vs non-loyalty basket profile

Store performance trailing 13 wks

Source: PDI Snowflake replication · Filters baked in: Company Ops, AMG_COT_DESC ≠ Closed, inside_sales_flag = 1, Item_Type = 1.