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]
CSV Column | Database Column |
---|---|
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]
CSV Column | Database Column |
---|---|
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