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

end_date

upc

ulta_item_number

ulta_item_description

brand_partner_sku

brand_number

retail_item_rank

feature_code

season_code

purch_cost_avg

retail_price_current

sales_dollars

sales_dollars_ly

sales_units

sales_units_ly

comp_dollars

comp_dollars_ly

dotcom_dollars

dotcom_dollars_ly

dotcom_units

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

product_number

week_ending_date

units_sales

units_on_hand

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 4 months ago