Integration Specifications
This document will help you understand the ULTA Portal and ULTA EDI 852 data sources and provide technical specifications for Daasity's integration and data model.
Daasity provides two distinct integration offerings for your ULTA data:
Basic Setup (Portal-only): This setup includes data from the ULTA Portal, providing total-ULTA, product-level, weekly data granularity. It includes sales, inventory, and performance metrics across your portfolio of products.
Advanced Setup (Portal + EDI 852): This setup combines the ULTA Portal data with store-level, product-level data from ULTA's EDI 852 feeds. The EDI data includes metrics such as unit sales, units on hand, and units on order. In this model, the EDI data serves as the primary data table, with "Avg Retail Price" joined by product and by week to calculate projected dollar sales and related metrics at the store-level. This allows for reporting capabilities that are not possible to do without combining these two sources!
Availability
All Enterprise merchants.
Refresh Cadence
Basic Setup (Portal-only)
Data from the ULTA Portal is updated weekly, typically every Monday, reflecting the prior week’s data through Saturday.
Advanced Setup (Portal + EDI 852)
The EDI data is updated weekly, typically every Monday. The integration joins the EDI data with the "Avg Retail Price" from the portal data, providing enriched metrics that include projected dollar sales.
Where to Find This Data
Reports
Omnichannel Dashboard
ULTA Dashboard
Explores
ULTA Explore
Unified Retail Schema (URS) Explore
Data Model
ERD
(Click here to view the ERD for the Daasity ULTA integration illustrating the different tables and keys to join across tables.)
Source Tables
ULTA Portal Data
CSV File: ULTA Sales, Inventory, and Performance
Update Method: UPSERT
Table Name: [retail.ulta_sales_inv_perf_sales]
start_date
start_date
end_date
end_date
upc
upc
ulta_item_number
ulta_item_number
ulta_item_description
ulta_item_description
brand_partner_sku
brand_partner_sku
brand_number
brand_number
retail_item_rank
retail_item_rank
feature_code
feature_code
season_code
season_code
purch_cost_avg
purch_cost_avg
retail_price_current
retail_price_current
sales_dollars
sales_dollars
sales_dollars_ly
sales_dollars_ly
sales_units
sales_units
sales_units_ly
sales_units_ly
comp_dollars
comp_dollars
comp_dollars_ly
comp_dollars_ly
dotcom_dollars
dotcom_dollars
dotcom_dollars_ly
dotcom_dollars_ly
dotcom_units
dotcom_units
dotcom_units_ly
dotcom_units_ly
MD5(ulta_item_number + ':' + start_date + ':' + end_date)
__sync_key
ULTA EDI 852 Data
CSV File: ULTA EDI 852
Update Method: UPSERT
Table Name: [retail.ulta_edi_852]
store_number
store_number
product_number
product_number
week_ending_date
week_ending_date
units_sales
units_sales
units_on_hand
units_on_hand
units_on_order
units_on_order
MD5(store_number + ':' + product_number + ':' + week_ending_date)
__sync_key
Transform Configuration
(Placeholder for future updates.)
Workflow Configuration
(Placeholder for future updates.)
Additional Resources
For more information on how to set up the ULTA integration or how to use ULTA data, see the related articles and resources linked below:
How to set up the integration (Integration Setup)
Where to find dashboards and explores in Daasity (Report Library)
How to use ULTA data (link to URMS analysis guides + playbooks)
Data Catalog: Definitions of all ULTA and URMS fields and report dimensions
Metrics Glossary: How to understand ULTA metrics, and when to use certain measures
Last updated