SPINS

SPINS is one of the major data providers for competitive market POS data, well-known for their leadership in Natural Channel coverage and natural/organic product attribution.

Overview

Unified Retail Market Schema (URMS):

SPINS, along with Circana and Nielsen, provide comprehensive retail and market insights, crucial for understanding sales trends, distribution metrics, and promotional effectiveness.

The Unified Retail Market Schema (URMS) in Daasity integrates these data sources, as well as any other competitive data sources available (Kroger 8451, Stackline, and more), to offer a unified view of market performance, enabling advanced competitive analysis across your retail markets.

Core Uses:

  • Use Case 1: Sales Performance Analysis - Analyze sales performance over different time periods to identify growth trends, seasonal variations, and the impact of marketing initiatives.

  • Use Case 2: Promotional Effectiveness - Evaluate the effectiveness of promotional activities by comparing baseline sales with incremental sales during promotional periods.

  • Use Case 3: Distribution and Velocity Metrics - Monitor distribution breadth and sales velocity to optimize product placement, anticipate swap-out or expansion opportunities, and fine-tune your pricing strategy by key account.


Integration

Getting Started

Setting up the SPINS Integration

Data Management / Refresh

SPINS Refresh / Data Management

SPINS QC Checklist


Data Model

Unified Models

  • Inclusion in Unified Models: This data source is automatically included in the Unified Retail Schema (URS) and Unified Retail Market Schema (URMS).

Data Customization / Mapping

  • Products

    • Standard Product Attributes

    • Custom Product Attributes (existing SKU Attributes)

    • Owned Brand

  • Markets

    • Standard Market-level

  • Calendars

    • Retailer Fiscal calendars

  • Currencies

  • D2C Customer location overlay


Reporting

Technical Specs

Required Report Filters: Product Level, Time Period

SPINS Reports

  • SPINS Dashboard

    • Parameterized metric and dimensions reflect the list of primary dimensions and metrics

  • SPINS Executive Summary

    • Key Metrics (Total)

    • Year-over-Year

    • Breakdown by

      • Market Ranking

    • Key Account Scorecards

      • Brand vs Category

      • Brand Ranking

      • Item Ranking

  • SPINS Ranking Reports

    • Each table reflects the Primary and Secondary Metrics, including year-over-year (YoY) and period-over-period (PoP) versions.

    • Brand Ranking

      • Product Ranking

    • Market Ranking

    • Week-by-Week

  • SPINS Explore

    • Quick Starts:

      • Product Ranking

      • Market Ranking

      • Week-by-Week

    • Required Filters:

      • Product Level = UPC

      • Time Period = 52 Weeks

Analysis reports (URMS)

Primary Metrics

These metrics are featured in our Dashboard and Scorecard report templates.

  • Dollar Sales: Total dollar sales.

  • Unit Sales: Total number of units sold.

  • TDP: Total distribution points.

  • Max ACV: Maximum % ACV for any given week during the selected time period.

    • ACV is a % of stores selling, weighted by each location’s β€œAll Commodity Volume” (how much stuff they sell at that location).

    • Alt Metric when ACV is unavailable:

      • Stores Selling: Number of stores selling the product.

  • Avg # Items: Average number of items sold per store.

  • $/S/W: Average weekly dollar sales per store per item.

  • U/S/W: Average weekly unit sales per store per item.

  • ARP: Average retail price per unit.

Primary Dimensions

These dimensions are featured in our Dashboard and Scorecard report templates.

  • Data Source: Source of the data.

  • Location Name: Geography / Warehouse / Store Name (depending on level (flag))

  • Product Name

  • Sales Date

  • Time Period

  • Max Date

All Metrics

  • % on Promo: Percentage of sales on promotion.

  • % Base: Percentage of baseline sales.

  • % Incremental: Percentage of incremental sales.

  • ARP: Average retail price per unit.

  • ARP YA (Year Ago): Average retail price per unit, same period last year.

  • ARP % Chg: Average retail price per unit, percent change vs year ago.

  • ARP Chg: Average retail price per unit, change vs year ago.

  • Avg # Items: Average number of items sold per store.

  • Avg # Items YA: Average number of items sold per store selling, same period last year.

  • Avg # Items % Chg: Average number of items sold per store selling, percent change vs year ago.

  • Base ARP: Average retail price for base volume.

  • Base ARP YA: Average retail price for base volume, same period last year.

  • Base ARP % Chg: Average retail price for base volume, percent change vs year ago.

  • Base ARP Chg: Average retail price for base volume, change vs year ago.

  • Base Dollars: Baseline sales projection.

  • Base Dollars YA: Baseline sales projection, same period last year.

  • Base Dollars % Chg: Baseline sales projection, percent change vs year ago.

  • Base Dollars, Promo: Baseline sales projection during promotions.

  • Base Dollars, Promo YA: Baseline sales projection during promotions, same period last year.

  • Base $/TDP: Average baseline dollar sales per point of distribution.

  • Base $/TDP YA: Average baseline dollar sales per point of distribution, same period last year.

  • Base $/TDP % Chg: Average baseline dollar sales per point of distribution, percent change vs year ago.

  • Base Units: Baseline unit sales projection.

  • Base Units YA: Baseline unit sales projection, same period last year.

  • Base Units % Chg: Baseline unit sales projection, percent change vs year ago.

  • Base Units, Promo: Baseline unit sales during promotions.

  • Base Units, Promo YA: Baseline unit sales during promotions, same period last year.

  • Base U/S/W/I: Average baseline unit sales per store, per week, per item.

  • Base U/S/W/I YA: Average baseline unit sales per store, per week, per item, same period last year.

  • Base U/S/W/I % Chg: Average baseline unit sales per store, per week, per item, percent change vs year ago.

  • Base $/S/W/I: Average baseline dollar sales per store, per week, per item.

  • Base $/S/W/I YA: Average baseline dollar sales per store, per week, per item, same period last year.

  • Base $/S/W/I % Chg: Average baseline dollar sales per store, per week, per item, percent change vs year ago.

  • Dollar Discount, Promo: Total dollar value of discounts during promotions.

  • Dollar Discount, Promo YA: Total dollar value of discounts during promotions, same period last year.

  • Dollar Discount, Promo % Chg: Total dollar value of discounts during promotions, percent change vs year ago.

  • Dollar Lift: Increase in dollars over baseline attributed to promotions.

  • Dollar Lift YA: Increase in dollars over baseline attributed to promotions, same period last year.

  • Dollar Lift Chg: Increase in dollars over baseline attributed to promotions, change vs year ago.

  • Dollars, Display: Total dollar sales from products displayed in stores.

  • Dollars, Display YA: Total dollar sales from products displayed in stores, same period last year.

  • Dollars, Display % Chg: Total dollar sales from products displayed in stores, percent change vs year ago.

  • Dollars, Feat & Disp: Total dollar sales from products featured and displayed.

  • Dollars, Feat & Disp YA: Total dollar sales from products featured and displayed, same period last year.

  • Dollars, Feat & Disp % Chg: Total dollar sales from products featured and displayed, percent change vs year ago.

  • Dollars, Feature: Total dollar sales from products featured.

  • Dollars, Feature YA: Total dollar sales from products featured, same period last year.

  • Dollars, Feature % Chg: Total dollar sales from products featured, percent change vs year ago.

  • Dollars, Non-Promo: Total dollar sales excluding promotions.

  • Dollars, Non-Promo YA: Total dollar sales excluding promotions, same period last year.

  • Dollars, Non-Promo % Chg: Total dollar sales excluding promotions, percent change vs year ago.

  • Dollars, Promo: Total dollar sales during promotions.

  • Dollars, Promo YA: Total dollar sales during promotions, same period last year.

  • Dollars, Promo % Chg: Total dollar sales during promotions, percent change vs year ago.

  • Dollars, TPR: Total dollar sales from temporary price reductions.

  • Dollars, TPR YA: Total dollar sales from temporary price reductions, same period last year.

  • Dollars, TPR % Chg: Total dollar sales from temporary price reductions, percent change vs year ago.

  • Dollar Share: Percentage of total market sales value attributed to a product.

  • Dollar Share YA: Percentage of total market sales value attributed to a product, same period last year.

  • Dollar Share Chg: Percentage of total market sales value attributed to a product, change vs year ago.

  • $/ACV: Average dollar sales per point of distribution.

  • $/ACV YA: Average dollar sales per point of distribution, same period last year.

  • $/ACV % Chg: Average dollar sales per point of distribution, percent change vs year ago.

  • $/Stores Selling: Average dollar sales per store selling the product.

  • $/Stores Selling YA: Average dollar sales per store selling the product, same period last year.

  • $/Stores Selling % Chg: Average dollar sales per store selling the product, percent change vs year ago.

  • $/S/W/I: Average weekly dollar sales per store, per item.

  • $/S/W/I YA: Average weekly dollar sales per store, per item, same period last year.

  • $/S/W/I % Chg: Average weekly dollar sales per store, per item, percent change vs year ago.

  • $/TDP: Average dollar sales per point of distribution.

  • $/TDP YA: Average dollar sales per point of distribution, same period last year.

  • $/TDP % Chg: Average dollar sales per point of distribution, percent change vs year ago.

  • Incremental Dollars: Sales on promotion exceeding the projected baseline.

  • Incremental Dollars YA: Sales on promotion exceeding the projected baseline, same period last year.

  • Incremental Dollars % Chg: Sales on promotion exceeding the projected baseline, percent change vs year ago.

  • Incremental Units: Units sold on promotion exceeding the projected baseline.

  • Incremental Units YA: Units sold on promotion exceeding the projected baseline, same period last year.

  • Incremental Units % Chg: Units sold on promotion exceeding the projected baseline, percent change vs year ago.

  • Max ACV: Measures the breadth of product distribution.

  • Max ACV YA: Measures the breadth of product distribution, same period last year.

  • Max ACV Chg: Measures the breadth of product distribution, change vs year ago.

  • Non-Promo ARP: Average retail price for units sold without promotions.

  • Non-Promo ARP YA: Average retail price for units sold without promotions, same period last year.

  • Non-Promo ARP % Chg: Average retail price for units sold without promotions, percent change vs year ago.

  • % Discount, Promo: Percentage discount during promotions.

  • % Discount, Promo YA: Percentage discount during promotions, same period last year.

  • % Dollars, Promo: Percentage of dollar volume from promotions.

  • % Dollars, Promo YA: Percentage of dollar volume from promotions, same period last year.

  • % Dollars, Promo Chg: Percentage of dollar volume from promotions, change vs year ago.

  • % Promo Incrementality ($): Percentage of incremental dollar sales from promotions.

  • % Promo Incrementality ($) YA: Percentage of incremental dollar sales from promotions, same period last year.

  • % Promo, Subsidized Base ($): Percentage of promo, subsidized baseline dollar sales.

  • % Ttl Dollars, Incremental: Percentage of total dollars, incremental.

  • % Units, Promo: Percentage of unit volume from promotions.

  • % Units, Promo YA: Percentage of unit volume from promotions, same period last year.

  • % Units, Promo Chg: Percentage of unit volume from promotions, change vs year ago.

  • Promo ARP: Average retail price during promotions.

  • Promo ARP YA: Average retail price during promotions, same period last year.

  • Promo ARP % Chg: Average retail price during promotions, percent change vs year ago.

  • Promo ARP Chg: Average retail price during promotions, change vs year ago.

  • Promo U/S/W/I: Average promotional unit sales per store, per week, per item.

  • Promo U/S/W/I YA: Average promotional unit sales per store, per week, per item, same period last year.

  • Promo U/S/W/I % Chg: Average promotional unit sales per store, per week, per item, percent change vs year ago.

  • Stores Selling YA: Number of stores with items selling, same period last year.

  • Stores Selling % Chg: Number of stores with items selling, percent change vs year ago.

  • TDP: Total distribution points, breadth (ACV) x depth (Avg # Items)

  • TDP YA: Total distribution points, same period last year.

  • TDP % Chg: Total distribution points, percent change vs year ago.

  • TDP Chg: Total distribution points, change vs year ago.

  • U/Stores Selling: Average units per store selling the product.

  • U/Stores Selling YA: Average units per store selling the product, same period last year.

  • U/Stores Selling % Chg: Average units per store selling the product, percent change vs year ago.

  • Unit Lift: Increase in units over baseline attributed to promotions.

  • Unit Lift YA: Increase in units over baseline attributed to promotions, same period last year.

  • Unit Lift Chg: Increase in units over baseline attributed to promotions, change vs year ago.

  • Unit Sales: Total number of units sold.

  • Units YA: Total number of units sold, same period last year.

  • Units % Chg: Total number of units sold, percent change vs year ago.

  • Units Chg: Total number of units sold, change vs year ago.

  • Units, Non-Promo: All unit sales, excluding units sold on promotion.

  • Units, Non-Promo YA: All unit sales, excluding units sold on promotion, same period last year.

  • Units, Promo: All unit sales sold on promotion.

  • Units, Promo YA: All unit sales sold on promotion, same period last year.

  • Units, Promo % Chg: All unit sales sold on promotion, percent change vs year ago.

  • Unit Share: Percentage of total units attributed to a product.

  • Unit Share YA: Percentage of total units attributed to a product, same period last year.

  • Unit Share Chg: Percentage of total units attributed to a product, change vs year ago.

  • U/ACV: Average units per point of distribution.

  • U/ACV YA: Average units per point of distribution, same period last year.

  • U/ACV % Chg: Average units per point of distribution, percent change vs year ago.

  • U/S/W: Average weekly unit sales per store, per item.

  • U/S/W/I YA: Average weekly unit sales per store, per item, same period last year.

  • U/S/W/I % Chg: Average weekly unit sales per store, per item, percent change vs year ago.

  • U/TDP: Average units per point of distribution.

  • U/TDP YA: Average units per point of distribution, same period last year.

  • U/TDP % Chg: Average units per point of distribution, percent change vs year ago.

  • Weeks Selling: Number of weeks selling.

  • Weeks Selling YA: Number of weeks selling, same period last year.

  • $ Chg Due to New Items: Sales attributed to new items.

  • $ Chg Due to Discontinued Items: Sales lost from discontinued items.

  • $ Chg Due to Distribution: Sales changes due to distribution variations.

  • $ Chg Due to Pricing: Sales changes due to pricing strategy adjustments.

  • $ Chg Due to Promotion: Sales changes due to promotions.

  • $ Chg Due to Velocity/AO: Sales changes due to overall sales rate.

  • ACV Gap: Gap in all commodity volume.

  • Dollar Opportunity: Potential dollar sales opportunity.

All Dimensions

  • Time

    • Time Period

    • Time Period End Date

    • Sales Date

  • Markets

    • Market Level: Level of the market.

      • Geography Name: Name of the geographic location.

  • Products

    • Brand Name: Name of the brand.

    • Product Name: Name of the product.

    • UPC: Universal Product Code.

    • Department: Department category.

    • Category: Product category.

    • Subcategory: Product subcategory.

    • Product Type: Type of product.

    • Class: Class of the product.

    • Product Size: Size of the product.

    • Unit of Measure: Unit of measurement.

    • Pack Count: Number of packs.

    • Case Pack Count: Number of packs per case.

    • Positioning Group: Group for product positioning.

    • Reporting Level: Level of reporting.

    • Master SKU: Master SKU identifier.

    • Listing SKU: SKU listed.


Additional Resources

Include links to additional resources, tutorials, or external documentation that can help users understand and utilize the data source more effectively.

Last updated