Integration Specifications
This document will help you understand the Circana data source and provide technical specifications for Daasity's integration and data model.
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.)
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]
Circana: WXW
CSV File: Circana WXW
Update Method: UPSERT
Table Name: [retail.circana_wxw]
Circana: Quad Week
CSV File: Circana Quad Week
Update Method: UPSERT
Table Name: [retail.circana_quad]
Last updated