Release date: September 17, 2025
Summary
We are launching our first unified retail data explores, designed for cross-channel analysis including syndicated and retailer portal sales data. Our mission is to make it easier than ever to do complex analysis across your retail data sources with streamlined category/brand performance analysis, promotional effectiveness, and week‑over‑week tracking.
Ensured alignment with Omni V2 conventions (naming, metrics parity, date handling) to reduce context switching.
---
Explores Included
1.
dm_retailer_brand_cat_perf__agg.explore.lkml
Aggregate view for brand & category performance across retailers; ideal for executive summaries and high‑level trend views.
- dm_retailer_brand_cat_perf__weekly.explore.lkml
Weekly‑grain view to analyze velocity, distribution, and pricing shifts over time; supports week‑over‑week ops and cohort drill‑downs.
- dm_retailer_promo_analysis.explore.lkml
Promotion‑focused view for lift, incrementality, and ROI questions; designed for trade optimization and post‑event readouts.
---
Why It Matters: Improves our retail analytics offering
- Provides a single data model where you can run complex competitive analysis, or promotional analysis optimizations across all available retail markets, from your retailer portals and syndicated data sets and custom retail sales data inputs: no more data silos!
- Standardizes promo analysispatterns and modeling across retailer POS and syndicated data sources (lift, incrementality, ROI), ensuring your data is as smart as it can be (we make your basic sales data more sophisticated, to match the structure of syndicated data and the analysis these pricing/promotional and distribution/velocity metrics can unlock.
- Keeps Retail aligned with Omni V2 so cross‑channel narratives are consistent.
Who is affected
: This is a net-new feature, so none of your current dashboards or explores will be interrupted. All merchants using Retail explores will have these new explores available for analysis. Dashboards are launching over the next two weeks so we have Templates for quick analysis on top of these analysis dashboardsWhat's next?
New dashboards are being built for these unified explores and are set to release over the next 1-2 weeks (Sep 2025); We will be rolling out dashboards built on top of these unified data models, so that retail analysis can be unleashed from the source-specific explores and dashboards we were limited to prior to this update.