How to Pull the Actuals report from SPINS

Login to Satori and navigate to Extracts -> New Extract
Select Universe (TPL)
Select All categories and under brands, search for your Brand and select it
For time frame, select “Trended”, “Weeks”, “2 Years”, and “No” to Include Year Ago
For geographies, navigate to "Retail Accounts"
Select All Retail Outlets, and everything else will auto-select.
1. Remove all "CRMA"s in Retail Geography Level.
2. Under Retail-Account Level, Select Banner and Total Corporate.
3. Select all Banners/Retailers you want to pull into Confido in the far right section. Generally, total corporate is fine for most retailers, but for some (Albertsons, Ahold) you'll want banner-level data.
For measures, pull in the following:
1. Volume
  1. Units
  2. Dollars
2. Distribution
  1. TPD
3. Pricing
  1. ARP
4. Promo/Non-Promo Distribution
  1. TDP, Any Promo
5. Base Incremental Volume
  1. Base Dollars
  2. Base Units
  3. Incr Dollars
  4. Incr Units
6. Store Performance
  1. # of Stores Selling
7. Promotion Effectiveness
  1. Dollars % Lift
  2. Units % Lift
In Summary → Change file format to Excel
Save Extract, refresh until report is downloadable, then send to Confido! 😄