# Integration Specifications

Daasity provides two distinct integration offerings for your ULTA data:

1. **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.
2. **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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/ulta/integration-specifications.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.