Integration Specifications

This page will help you learn about SPINS and provide technical specifications for Daasity's integration and data model.

SPINS is a syndicated data provider known for its extensive coverage of the Natural Channel and its leadership in natural/organic product attribution.

The Daasity x SPINS integration offers competitive category information at UPC and category levels, allowing brands to monitor market trends, analyze category performance, and benchmark competitive performance across retailers and regions. The Daasity extract works with all available SPINS data: weekly, quad-week, and aggregated time periods across geographies and product categories.

---

Availability

All Enterprise merchants

Refresh Cadence

SPINS 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 and practice for all of the syndicated data providers including Nielsen and Circana- although the frequency of data updates may vary by contract).

After the data has been exported from the SPINS 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 SPINS data release calendar.

---

Data Model

ERD

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

---

Source Tables

SPINS: Latest Period

• CSV File: SPINS Latest Period

• Update Method: UPSERT

• Table Name: [retail.spins_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 + ':' + Product Level + ':' + Product Universe)	__sync_key

SPINS: WXW

• CSV File: SPINS WXW

• Update Method: UPSERT

• Table Name: [retail.spins_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 + ':' + Product Level + ':' + Product Universe)	__sync_key

SPINS: Quad Week

• CSV File: Quad Week

• Update Method: UPSERT

• Table Name: [retail.spins_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
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 + ':' + Product Level + ':' + Product Universe)	__sync_key