Unified Schema Introduction

Overview

Currently there are seven (7) Unified Schemas (normalized data models) deployed:

• Unified Retail Sales (URS): consolidates your brand’s own retail POS, wholesale shipments, and inventory data into a unified structure, enabling consistent analysis of sell-in, sell-out, and on-hand stock across retailers and channels

• Unified Retail Market Sales (URMS): standardizes syndicated retail market data from sources like NielsenIQ, Circana/IRI, and SPINS, allowing you to analyze category performance, market share, distribution, and velocity in the context of competitors and the total marke

• Unified Order Schema (UOS): normalizes order and transaction data across all sales channels with order-level details—including eCommerce, marketplaces and POS/B2B —into a consistent structure that supports multi-item, multi-shipment, and multi-recipient orders.

• Unified Marketing Schema (UMS): consolidates paid marketing performance data from platforms like Facebook, Google, TikTok, and Amazon Ads into a unified view of spend, clicks, impressions, and attributed outcomes.

• Unified Notification Schema (UNS): centralizes customer messaging data from email, SMS, push, and in-app platforms, enabling cross-channel engagement and campaign performance analysis.

• Unified Traffic Schema (UTS): integrates digital and retail traffic data from sources like Google Analytics, Amazon, and in-store counters, providing a unified view of sessions, pageviews, and conversion across all channels.

• United Subscription (USS): unifies subscription program data—covering subscribers, active subscriptions, churn, shipments, and repurchase behavior—so brands can track retention, forecast recurring revenue, and optimize subscription health over time.

Deprecated

• Unified Wholesale Schema (UWS): Prior to Daasity's acquisition of Red Fox Analytics in 2025, Daasity used the UWS to normalize sell-in and sell-out data for Wholesale data. Since late 2025, the UWS has been phased out, and replaced with the Unified Retail Sales (URS) schema, but remains active for some customers with legacy custom projects involving the UWS.