# Integration Specifications

Circana is a syndicated data provider with extensive coverage across retail markets and categories. The Daasity x Circana integration pulls in data for weekly, quad-week, and aggregated time periods across all available geographies and product categories.

***

### **Availability**

This integration is available for all Enterprise merchants.

***

### **Refresh Cadence**

Circana data updates every four weeks, typically on the Monday of that week, for a total of 13 data updates per year. This is a standard cadence for syndicated data providers, including Nielsen and SPINS, although the frequency of data updates may vary by contract. After the data has been exported from the Circana platform or API and uploaded into Daasity, it typically takes less than an hour for the new data to be reflected in your data warehouse and reports.

[(Click here to see the Circana data release calendar.)](https://help.daasity.com/core-concepts/data-integrations/setup-guides/retail-integrations/syndicated-data-integrations/circana/data-release-calendar)

***

### **Where to Find This Data**

**Reports**

* **Omnichannel Dashboard**
* **Circana Dashboard**
* **Circana Scorecard**
* **Category Analysis Reports (URMS)**
  * Brand and Category Performance
  * Key Drivers Analysis
  * Distribution Opportunities
  * Pricing Analysis
  * Promotional Evaluation

**Explores**

* **Circana Explore**
* **Unified Retail Category Analysis (URMS) Explore**

***

### **Data Model**

#### **ERD**

*(Click here to view the ERD for the Daasity Circana integration illustrating the different tables and keys to join across tables.)*

***

#### **Source Tables**

**Circana: Latest Period**

* **CSV File:** Circana Latest Period
* **Update Method:** UPSERT
* **Table Name:** \[retail.circana\_lp]

| CSV Column                                     | Database Column                      |
| ---------------------------------------------- | ------------------------------------ |
| Geography                                      | geography                            |
| Time Period                                    | time\_period                         |
| Time Period End Date                           | time\_period\_end\_date              |
| Product Universe                               | product\_universe                    |
| Product Level                                  | product\_level                       |
| Category                                       | category                             |
| Subcategory                                    | subcategory                          |
| Department                                     | department                           |
| Positioning Group                              | positioning\_group                   |
| Brand                                          | brand                                |
| UPC                                            | upc                                  |
| Description                                    | description                          |
| SIZE                                           | size                                 |
| PRODUCT TYPE                                   | product\_type                        |
| PACK COUNT                                     | pack\_count                          |
| Dollars                                        | dollars                              |
| Dollars, Yago                                  | dollars\_yago                        |
| Units                                          | units                                |
| Units, Yago                                    | units\_yago                          |
| Max % ACV                                      | max\_pct\_acv                        |
| Max % ACV, Yago                                | max\_pct\_acv\_yago                  |
| TDP                                            | tdp                                  |
| TDP, Yago                                      | tdp\_yago                            |
| Number of Weeks Selling                        | number\_of\_weeks\_selling           |
| Number of Weeks Selling, Yago                  | number\_of\_weeks\_selling\_yago     |
| Dollars, Promo                                 | dollars\_promo                       |
| Dollars, Promo, Yago                           | dollars\_promo\_yago                 |
| Units, Promo                                   | units\_promo                         |
| Units, Promo, Yago                             | units\_promo\_yago                   |
| Base Dollars                                   | base\_dollars                        |
| Base Dollars, Yago                             | base\_dollars\_yago                  |
| Base Units                                     | base\_units                          |
| Base Units, Yago                               | base\_units\_yago                    |
| # of Stores Selling                            | no\_of\_stores\_selling              |
| # of Stores Selling, Yago                      | no\_of\_stores\_selling\_yago        |
| Dollars, Display Only                          | dollars\_display\_only               |
| Dollars, Display Only, Yago                    | dollars\_display\_only\_yago         |
| Dollars, Feature Only                          | dollars\_feature\_only               |
| Dollars, Feature Only, Yago                    | dollars\_feature\_only\_yago         |
| Dollars, Feature & Display                     | dollars\_feature\_and\_display       |
| Dollars, Feature & Display, Yago               | dollars\_feature\_and\_display\_yago |
| Dollars, TPR                                   | dollars\_tpr                         |
| Dollars, TPR, Yago                             | dollars\_tpr\_yago                   |
| Base Dollars, Promo                            | base\_dollars\_promo                 |
| Base Dollars, Promo, Yago                      | base\_dollars\_promo\_yago           |
| Base Units, Promo                              | base\_units\_promo                   |
| Base Units, Promo, Yago                        | base\_units\_promo\_yago             |
| MD5(Geography + ':' + Time Period + ':' + UPC) | \_\_sync\_key                        |

***

**Circana: WXW**

* **CSV File:** Circana WXW
* **Update Method:** UPSERT
* **Table Name:** \[retail.circana\_wxw]

| CSV Column                                     | Database Column                      |
| ---------------------------------------------- | ------------------------------------ |
| Geography                                      | geography                            |
| Time Period                                    | time\_period                         |
| Time Period End Date                           | time\_period\_end\_date              |
| Product Universe                               | product\_universe                    |
| Product Level                                  | product\_level                       |
| Category                                       | category                             |
| Subcategory                                    | subcategory                          |
| Department                                     | department                           |
| Positioning Group                              | positioning\_group                   |
| Brand                                          | brand                                |
| UPC                                            | upc                                  |
| Description                                    | description                          |
| SIZE                                           | size                                 |
| PRODUCT TYPE                                   | product\_type                        |
| PACK COUNT                                     | pack\_count                          |
| Dollars                                        | dollars                              |
| Dollars, Yago                                  | dollars\_yago                        |
| Units                                          | units                                |
| Units, Yago                                    | units\_yago                          |
| Max % ACV                                      | max\_pct\_acv                        |
| Max % ACV, Yago                                | max\_pct\_acv\_yago                  |
| TDP                                            | tdp                                  |
| TDP, Yago                                      | tdp\_yago                            |
| Number of Weeks Selling                        | number\_of\_weeks\_selling           |
| Number of Weeks Selling, Yago                  | number\_of\_weeks\_selling\_yago     |
| Dollars, Promo                                 | dollars\_promo                       |
| Dollars, Promo, Yago                           | dollars\_promo\_yago                 |
| Units, Promo                                   | units\_promo                         |
| Units, Promo, Yago                             | units\_promo\_yago                   |
| Base Dollars                                   | base\_dollars                        |
| Base Dollars, Yago                             | base\_dollars\_yago                  |
| Base Units                                     | base\_units                          |
| Base Units, Yago                               | base\_units\_yago                    |
| # of Stores Selling                            | no\_of\_stores\_selling              |
| # of Stores Selling, Yago                      | no\_of\_stores\_selling\_yago        |
| Dollars, Display Only                          | dollars\_display\_only               |
| Dollars, Display Only, Yago                    | dollars\_display\_only\_yago         |
| Dollars, Feature Only                          | dollars\_feature\_only               |
| Dollars, Feature Only, Yago                    | dollars\_feature\_only\_yago         |
| Dollars, Feature & Display                     | dollars\_feature\_and\_display       |
| Dollars, Feature & Display, Yago               | dollars\_feature\_and\_display\_yago |
| Dollars, TPR                                   | dollars\_tpr                         |
| Dollars, TPR, Yago                             | dollars\_tpr\_yago                   |
| Base Dollars, Promo                            | base\_dollars\_promo                 |
| Base Dollars, Promo, Yago                      | base\_dollars\_promo\_yago           |
| Base Units, Promo                              | base\_units\_promo                   |
| Base Units, Promo, Yago                        | base\_units\_promo\_yago             |
| MD5(Geography + ':' + Time Period + ':' + UPC) | \_\_sync\_key                        |

***

**Circana: Quad Week**

* **CSV File:** Circana Quad Week
* **Update Method:** UPSERT
* **Table Name:** \[retail.circana\_quad]

| CSV Column                    | Database Column                  |
| ----------------------------- | -------------------------------- |
| Geography                     | geography                        |
| Time Period                   | time\_period                     |
| Time Period End Date          | time\_period\_end\_date          |
| Product Universe              | product\_universe                |
| Product Level                 | product\_level                   |
| Category                      | category                         |
| Subcategory                   | subcategory                      |
| Department                    | department                       |
| Positioning Group             | positioning\_group               |
| Brand                         | brand                            |
| UPC                           | upc                              |
| Description                   | description                      |
| SIZE                          | size                             |
| PRODUCT TYPE                  | product\_type                    |
| PACK COUNT                    | pack\_count                      |
| Dollars                       | dollars                          |
| Dollars, Yago                 | dollars\_yago                    |
| Units                         | units                            |
| Units, Yago                   | units\_yago                      |
| Max % ACV                     | max\_pct\_acv                    |
| Max % ACV, Yago               | max\_pct\_acv\_yago              |
| TDP                           | tdp                              |
| TDP, Yago                     | tdp\_yago                        |
| Number of Weeks Selling       | number\_of\_weeks\_selling       |
| Number of Weeks Selling, Yago | number\_of\_weeks\_selling\_yago |
| Dollars, Promo                | dollars\_promo                   |
| Dollars, Promo, Yago          | dollars\_promo\_yago             |
| Units, Promo                  | units\_promo                     |
| Units, Promo, Yago            | units\_promo\_yago               |