retailer data management programcpgretailanalytics.com/wp-content/uploads/2019/01/... · •85...

Retailer Data Management Program

The materials herein include proprietary information from ATLAS Technology Group and may not be copied, reproduced, or disclosed externally (outside of Unilever) without prior written permission from ATLAS Technology Group. Copyright © ATLAS Technology Group 2018. All rights reserved. All corporate names, brand names and design marks herein are the sole property of their respective owners. Unilever brand images provided courtesy of Unilever.

Mike Freeman | [email protected] | 952-270-2135

| 2Mike Freeman | [email protected] | 952-270-2135

Agenda

• Visualization Tools

• OSA+

• TRACE

• AMP

• CANOPY

• Company Profile

• Key Differentiators

• ATLAS EnterpriseATLAS Recording Studio | ATLAS Essentials


By the Numbers

• 85 Member Team

• Custom Software Engineering

• Enterprise Solution

• All Channels, 15 Countries, 38 Retailers

• 145+ Customers

• 1450+ databasesSample Client List

| 4Mike Freeman | [email protected] | 952-270-2135 | 4

Data Agnostic

• Retailer/Supplier

• Third-Party Providers

• Services

• Data

• Multi-Platform


Client-Centric Culture

• Established, Robust Platform

• Intuitive Interface

• Powerful “Out of the Box” Solutions

• Best Customer Service

• Automated ETL and Validation Processes

• Flexible Deployment Models

REPORTING STUDIODashboards and Interactive Report Examples



Built-In Reporting

Complete suite of reports available immediately. Reports can be grouped & sliced thousands of ways.

• Sales

• Replenishment

• Retail

• Exception

• Category Management

• Advisor / Buyer

Reporting Studio


Dashboards


Intuitive User Interface

Reporting Studio


Email Schedules

• Automatically in Your Inbox Every Day

• Scorecard Automation

• Content “Smart” Emails• i.e. “Your sales are up +8% TY vs. LY”

• Conditional Emails• Only send when there is an exception


Ad-Hoc Reporting

VISUALIZATION TOOLS



Robust Reporting & Visualization

Excel-Based Dashboards

Visualization Tools


Export to Excel or PowerPoint | User Editable | GPS Accurate

Dynamic, Customizable Mapping


EXCEL REPORTINGEXAMPLES



Total TYTotal LY

State TY LY % State TY LY % State TY LY % State TY LY % Overall $946,663 $863,850 9.6% ID $4,263 $4,310 (1.1%) NC $40,012 $34,844 14.8% SC $19,772 $18,229 8.5%

AK $1,597 $1,274 25.4% IL $33,110 $32,812 0.9% ND $2,850 $2,957 (3.6%) SD $3,500 $3,587 (2.4%)AL $22,191 $20,888 6.2% IN $20,062 $18,853 6.4% NE $7,630 $6,566 16.2% TN $28,038 $26,603 5.4%AR $15,880 $15,041 5.6% KS $12,851 $10,656 20.6% NH $3,258 $3,626 (10.1%) TX $107,609 $87,526 22.9%AZ $28,813 $25,878 11.3% KY $14,620 $15,024 (2.7%) NJ $11,868 $10,133 17.1% UT $8,115 $7,448 9.0%CA $43,859 $35,753 22.7% LA $23,317 $21,823 6.8% NM $13,411 $11,098 20.8% VA $33,685 $28,195 19.5%CO $24,346 $20,283 20.0% MA $7,482 $6,771 10.5% NV $13,353 $12,163 9.8% VT $169 $128 32.6%CT $5,461 $4,338 25.9% MD $11,727 $9,973 17.6% NY $24,357 $25,302 (3.7%) WA $12,162 $12,699 (4.2%)DC $0 $0 0.0% ME $6,018 $6,475 (7.1%) OH $26,116 $24,274 7.6% WI $17,215 $18,954 (9.2%)DE $2,774 $2,627 5.6% MI $14,172 $15,089 (6.1%) OK $22,967 $19,347 18.7% WV $8,062 $7,993 0.9%FL $97,319 $86,551 12.4% MN $13,569 $13,815 (1.8%) OR $7,332 $6,705 9.3% WY $3,525 $3,276 7.6%GA $35,172 $30,614 14.9% MO $25,325 $24,232 4.5% PA $35,213 $36,397 (3.3%)HI $1,156 $1,025 12.7% MS $12,854 $12,942 (0.7%) PR $0 $0 0.0%IA $9,819 $10,252 (4.2%) MT $6,119 $5,841 4.8% RI $2,440 $2,551 (4.3%)

POS Sales Heat MapComparing 201344 - 201344 to 201244 - 201244

$820,000

$840,000

$860,000

$880,000

$900,000

$920,000

$940,000

$960,000

Total TY Total LY

Overall


OSA+

• Every item/every store/every day• Daily zero sales, out-of-stocks, ghost inventory• Complete OSA+ report suite Inside of ATLAS• Highly accurate & flexible algorithms• Daily dashboard of retail coverage• Accurate store-clustering and expected

velocity measures• Dynamic routing

ATLAS Retail Service Provider Retailer


Alerts1. Every item is analyzed on a per store / day time frame

2. Compared against the item’s historical performance and sister stores expected velocity

3. Consideration taken for other factors such as:1. historical field responses2. Inventory data available

4. Probability determined of the item having a true issue preventing sales

5. Available tasks further filtered to meet specific client criteria such as:

1. Only specific stores alerted2. Only specific items alerted3. Store level maximum number of tasks


• After tasks are generated they are grouped at a store level

• An estimated daily rate of lost sales (LSV) is calculated for each task• This calculation is simply the expected unit sales for the

zero sales period, divided by the days of zero sales and then multiplied by the unit retail

• ((Expected Units)/(Zero sales Days)) * (Unit Retail)

• Each task’s LSV is summed up at a store level

• Stores are then ranked based on their total LSV value with the highest LSV getting the highest rank

Store Prioritization Overview

Other information taken into consideration when

available: Other business priorities (non-data

related), receipt of Promotion quantities (need

shipments/promotion data)


TRACE

TRACE

Mobile Store Audits: Any Store, Any Time, Any Retailer


TRACE iPad Tool

• Audit Any Store, Any Time, Anywhere • Complete Integration into ATLAS• Latest Retail Link Information at Your Fingertips• Take Notes per Item, per Store• Store & Retrieve Pictures in Store• Sent to your Retail Service Company Automatically• Responses & Un-responded Tasks Visible


Features

Real-Time Results Sent on the Fly–Task / Responses / Projects / Pictures

Geo-Location Locking–Lock Certain Features to a Geo-Fence of a Store

Time Tracking & Management

Best-in-Industry Task Generation • Daily Task Creation• Phantom Inventory• Zero Sales• Any Other Retail Exception


Geo-Locate


Store Formats


Custom Regions/Broker Alignments


Store Dashboards


Retail Exceptions


Item Level Information


AMPAutomated Assortment Modular Planning

AMP


AMP blends Software Tools and an Engineering Team whose focus is to Automate and Customizethe Modular Relay Process.

The goal is to Reduce Time and bring more science to the Modular Process, yet allow the Customer Team to Retain the Human Element.

Increase Productivity and Accuracy Automating and Customizing the Modular Relay Process


AMP Competitive Advantages

• Completely Customized Software & ProcessEvery Category and/or Relay is different

• Full Transparency• Plug-in and Module-Based Platform• Immediate Response Time to Changes• Problem Solving with

Engineering and Programmers 15

ASSORTMENT

2DRAWING

3VALIDATION

4REPORTING

VIRTUALIZATION


Optimize Assortment DecisionsAMP provides the End User with the ability to adjust settings and variables on the fly to affect the assortment.

• Custom Rules

• Item Metric Weights (POS, Units, Nielsen/IRI)

• Days of Supply Tolerance Levels

• Core/Protect Lists

• Item/Store Assortments

• Completely Customized per

Relay/Category/Customer


Custom Rules Examples

• Plastic Bottle Rule– Merchandise products in plastic packaging for stores near bodies of water

• Segmentation Rule– Flex/keep segment space based on custom parameters

• Item Placement Conditions– If Item A exists, then Item B must go next to it (Shampoo & Conditioner)– If the Modular is > 98ft, then all items of supplier Y must go on 3rd shelf regardless of item flow


Assortment Decision Matrix


Merchandizing StepsOur Automated Process

1. Identify Delete Items 2. Adjust Facings 3. Identify ADD Items

4. Auto Merchandize Items 5. Completed Final Modular

Full transparency to easily understand how decisions influence the

modular layout.


Reporting

Completely Customized– Space to Sales– DC Matrix– OSA Scores– Before/After Performance


Planograms in 3D


3D Planograms with Product Info


Macro Data• Top/Low Performing Items• Chronic Out of Stocks• Predictive Out of Stocks• Brand Block Highlights• Planogram Differences

Live Daily Data Feeds• Current Store Conditions

• On Hands• Predictive Out of Stocks• POS$ Expectations• Markdowns

3D Heat Maps


On-Boarding


NEXT STEPS


retailer data management programcpgretailanalytics.com/wp-content/uploads/2019/01/... · •85...

Documents