Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Availability
  • Refresh Cadence
  • Data Model

Was this helpful?

  1. Extract
  2. All Integrations
  3. SPINS

Integration Specifications

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

PreviousIntegration SetupNextHow to Use

Last updated 9 months ago

Was this helpful?

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.


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

🔌
Click here to see the SPINS data release calendar.