Retail Store Performance

Retail Store Performance brings together all available retail POS and wholesale data at the native market granularity provided by each source—store/door, DC/warehouse, region/DMA, banner/retailer, or corporate total. The explore preserves each source’s grain and enables blended roll-ups for consistent analysis.

Examples of source granularity

• ULTA

  • ULTA Portal: Total-corporate–level POS with full history for long-horizon trends.

  • ULTA EDI: Store-level POS beginning on the data-setup start date. Use this for door-level analysis that does not require full historical coverage; long-horizon trend completeness accrues as the pipeline runs (e.g., 2+ years). EDI store-level weekly sales also supports downstream weeks-of-supply calculations.

• Sephora

  • Mixed granularity depending on feed: some corporate/region aggregates and some store-level by door.

---

What’s Included

1) POS Sales Performance

Retailer-provided sales by door (e.g., Walmart, Target, Sephora, Ulta, Kroger) at a weekly cadence, including:

• Dollar Sales

• Unit Sales

• Stores Selling

• Avg Weekly $ per Store Selling per Item ($/S/W/I)

• Avg Retail Price (ARP)

• Baseline / Incremental / Promo / Non-Promo Sales Volume * (calculated)

2) Wholesale Performance

Internal shipment (“sell-in”) and distributor/partner sales or depletions (“sell-through,” when provided) are integrated alongside POS to complete the picture at the door, DC, region, and account levels. This supports operational alignment between what was shipped, where it landed (DC/Warehouse or store allocation), and how quickly it is selling through. Key metrics include:

• Wholesale Dollars – revenue booked on wholesale shipments

• Wholesale Units – units shipped to wholesale partners

• Wholesale Cases – case-level volume (computed from item master case packs where available)

3) Store & Geography Dimensions

• Store ID / Store Name

• Retailer

• City, State, ZIP

• Region / DMA

• DC/Warehouse (Wholesale / Distributor data-specific)

Key Metrics & Dimensions

Name	Definition	Type
Sales Dollars	POS revenue by store and week	Metric
Sales Units	POS units by store and week	Metric
Wholesale Dollars	Revenue on wholesale shipments	Metric
Wholesale Units	Units shipped to wholesale partners	Metric
Wholesale Cases	Cases shipped (units ÷ case pack) to wholesale partners	Metric
Store ID / Name	Retailer door identifier and label	Dimension
Retailer	Retail banner/account	Dimension
City/State/ZIP	Store location attributes	Dimension
Region / RMA	Regional grouping for roll-ups; Retailer Marketing Area	Dimension
DC/Warehouse	Receiving DC/warehouse for routing and allocation	Dimension

Time series supports week, month, quarter, and year, including prior-year comparisons when history is available.

Core Use Cases

• Top/Bottom Store Analysis: Rank doors by sales and growth; spotlight best practices and target laggards.

• Regional Trend Tracking: Roll up by state/region/DMA to guide field marketing and distribution strategy.

• New Store Launch & Expansion: Measure ramp-up after new placements and confirm distribution execution.

• Coverage & Opportunity: Compare current selling doors vs. target doors to size upside.

• Sell-In vs. Sell-Through Alignment: Compare Wholesale Units/Cases/Dollars to store-level Sales Units/Dollars to detect slow-moving regions, pipeline fill events, and re-order needs.

• Operational Alerts: Flag doors with sudden sales drops or persistent zero sales to investigate OOS, scan issues, or discontinued items.

Note: Inventory data is not included in this explore.

Inventory is not included in this explore: all inventory is modeled in Omnichannel Inventory, which provides store-level Quantity on Hand and combines the latest inventory levels with a adjustable rolling sales metric across URS and UOS channels for weeks-of-supply calculations (latest week inventory divided by average weekly sales for that product + location over the last 4–12 weeks).

Data & Modeling Details

• Sources: Retailer portals/EDI “sales by door” feeds for POS; internal ERP/order data for shipments; distributor/partner depletions where available.

• Grain: Date and Market granularity will vary by source (typically Daily or Weekly, and Store-level or Corp and/or Region-level), depending on the data source; wholesale shipments aligned at DC/Warehouse, account, region, and store (when all allocations are provided).

• Alignment: Shipments without store-level allocations are reported at DC/Warehouse or account level and remain analyzable alongside store POS via regional and account roll-ups.