Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There is no image in this update.

Search Gear Option Glossary

Livesearch
spaceKeyPDP
labelsgearoptionglossary


Anchor
Top of Page
Top of Page
Each of the terms below, organized alphabetically, describes a metric option which can be found in the setting gear of our Insight Panels. Click one of the below links to jump to a letter in the alphabet. When on a metric option, clicking on the ">" icon next to any of the terms displays an expanded description and helpful photos.  Each metric option also comes with a convenient listing of each Insight Panel in which the metric is featured. 

Section
Column
width50%
Column
width50%
Section
Column
width50%
Column
width50%

Anchor
# Markets
# Markets

Panel
title# Markets
Section
bordertrue
Column
width50%

 Allows you to limit the number of market results returned within the insight panel.


Expand
titleMore Details

This option in the gear settings allows you to limit the number of results returned within the insight panel. For many retailers, there may be many markets/patches or other region types which can produce an insight panel with potentially hundreds of rows. By limiting to the top 10 or even 25, you can reduce the space consumed while usually retaining much of the detail you desire.

Column
width50%
Expand
titleFeatured in these Insight Panels

Market YOY Temp Diffs



Panel
title# of Regions
Section
bordertrue
Column
width50%

Allows you to limit the number of region results returned within the insight panel.


Expand
titleMore Details

This option in the gear settings allows you to limit the number of results returned within the insight panel. For many retailers, there may be many regions available to view which can produce an insight panel with potentially hundreds of rows. By limiting to the top 10 or even 25, you can reduce the space consumed while usually retaining much of the detail you desire.

Column
width50%
Expand
titleFeatured in these Insight Panels

Market Sales Overview



Panel
title# of Results
Section
bordertrue
Column
width50%

Allows you to limit the number of results returned within the insight panel


Expand
titleMore Details

This option in the gear settings allows you to limit the number of results returned within the insight panel. Depending on your data, there may be many results returned which can produce an insight panel with potentially hundreds of rows. By limiting to the top 10 or even 25, you can reduce the space consumed while usually retaining much of the detail you desire.

Column
width50%
Expand
titleFeatured in these Insight Panels

Sell Thru By Retail Region

Sell Thru By Category



Panel
title# of Visits
Section
bordertrue
Column
width50%

Allows you to limit the number of store visits returned within the insight panel.


Expand
titleMore Details

This option in the gear settings allows you to limit the number of store visits returned within the insight panel. In the store insight panel, for example, if you have many users creating store visits - the panel can produce potentially hundreds of rows of data. By limiting to the top 10 or even 25, you can reduce the space consumed while usually retaining much of the detail you desire about the most recent store visits.

Column
width50%
Expand
titleFeatured in these Insight Panels

Recent Store Visits



Panel
title% Chance Precipitation
Section
bordertrue
Column
width50%

The default value is set at 50%. Should you have a need for a more or less stringent value for determining precipitation you can adjust this value to your preference.


Expand
titleMore Details

This option applies to weather insight panels and controls whether a region on the map is considered "rainy" or not based on the underlying data values for percent chance of precipitation. Due to the nature of the weather forecast data, most values with a % of precipitation greater than 50-60% indicate that it is more likely than not to rain. The default value is therefore set at 50%. Should you have a need for a more stringent value for determining precipitation you can adjust this value to your preference.

Column
width50%
Expand
titleFeatured in these Insight Panels

Precipitation Map

Back to Top


Anchor
Avg Type
Avg Type

Panel
titleAvg Type
Section
bordertrue
Column
width50%

Allows you to customize whether you want to view the average hi temperature or low temperature when viewing the temperature values.


Expand
titleMore Details

The average type setting allows you to customize whether you want to view the average hi temperature or low temperature when viewing the temperature values.

Column
width50%
Expand
titleFeatured in these Insight Panels

Temperature Heat Map

YOY Temp Diff Heat Map

Back to Top


Anchor
Business Type
Business Type

Panel
titleBusiness Type
Section
bordertrue
Column
width50%

You can elect to have Avantalytics segregate your business from your competitors regionally. If this is the case, the value of "Active/Primary Business" will represent just your business, while "All Sales" will widen the net to return sales on the item regardless of the supplier.


Expand
titleMore Details

The business type is option is specific to certain retailers (Home Depot mostly) and suppliers where the supplier provides an item which is generic and could have many competitors supplying the same item regionally across the country. A good example is a lumber fir 2X4X8 stick. If you receive data from the retailer, its possible you receive data for your sales as well as other suppliers due to a situation known a "shared SKU". In this instance, you can elect to have Avantalytics segregate your business from your competitors regionally. If this is the case, the value of "Active/Primary Business" will represent just your business, while "All Sales" will widen the net to return sales on the item regardless of the supplier.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

4-4-5 Retail Sales Trend

Multi-Retailer Sales Comparison

Phantom Inventory Trend

Back to Top


Anchor
Cache for Speed
Cache for Speed

Panel
titleCache for Speed
Section
bordertrue
Column
width50%

Allows the data results of the panel to be cached when the underlying data does not change so that the insight panel will experience faster loading times on subsequent refreshes.


Expand
titleMore Details

This option should default to "Yes," and allows the data results of the panel to be cached when the underlying data does not change. As a result, the insight panel will experience faster loading times on subsequent refreshes.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

Market Share Trend $

Multi-Retailer Sales Comparison

Precipitation Map

YOY Daily Precip Map

Sell Thru Trend

Sell Thru By Retail Region

Sell Thru By Category

Sell Thru Retail $ Heat Map

Sell Thru Custom Region

Retailer Consumer Item Ratings



Panel
titleCalendar Month
Section
bordertrue
Column
width50%

Determines which calendar month is shown in the insight panel results.


Expand
titleMore Details

This option, specific to the rain calendar, determines which calendar month is shown in the insight panel results. You can choose any calendar month in the last year to view results of rain vs. prior year by each day of the month.

Column
width50%
Expand
titleFeatured in these Insight Panels

Rain Calendar



Panel
titleCategory
Section
bordertrue
Column
width50%

Allows you to limit results based on items matching one of 12 custom categories you are allowed to set up with Avantalytics in this option. Click here (link) to learn more about how to set up custom categories.


Expand
titleMore Details

In Avantalytics, you can store up to 12 standard attributes / grouping types for each of your items. When you do this, the values used will be reported here for a given retailer and category type (one of the 12). The option allows you to limit results based on items matching the particular category or categories you choose in this option. To select more than one value, hold down the "ctrl" or "shift" key while selecting values. This option is often seen along with the "Category Type" option to allow you to change between the 12 types and select one or more of the values to limit items returned in the insight panel.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

4-4-5 Retail Sales Trend

Market Share Trend Units

Market Share Trend $

Multi-Retailer Sales Comparison

Sell Thru Trend

Phantom Inventory Trend

Sell Thru Cost $ By Category

Sell Thru Units By Market

Sell Thru By Retail Region

Sell Thru By Category

Sell Thru Retail $ Heat Map

Sell Thru Custom Region

7 Day Price Changes

Retailer Consumer Item Ratings

Pricing Over Under

Brand Pricing Over / Under



Panel
titleCategory Type
Section
bordertrue
Column
width50%

Allows you to change the category values to select subsets of items based on any of the custom category types you set up with Avantalytics. Click here (link) to learn more about how to set up custom categories.


Expand
titleMore Details

The category type options utilizes the 12 possible category values for each item you set up in Avantalytics. This option allows you to change the category values to select subsets of items based on any of the category types. When you change the value here, the "Category" values typically seen directly below this option will update to reflect the choice so you can limit results appropriately.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

Multi-Retailer Sales Comparison

Sell Thru Trend

Phantom Inventory Trend

Sell Thru By Category

Sell Thru Retail $ Heat Map

7 Day Price Changes

Retailer Consumer Item Ratings

Pricing Over Under

Brand Pricing Over / Under



Panel
titleClient
Section
bordertrue
Column
width50%

Allows you to limit the results of the insight panel to data specific to a given client you maintain and serve using the system.


Expand
titleMore Details

This option is primarily utilized in the merchandising module and allows you to limit the results of the insight panel to data specific to a given client you maintain and serve using the system.

Column
width50%
Expand
titleFeatured in these Insight Panels

Field Team Hours

Merchandising Stats



Panel
titleCompeting Retailers
Section
bordertrue
Column
width50%

Allows you to limit the competitors evaluated in the results.


Expand
titleMore Details

This option is used primarily within the competitive monitoring service and allows you to limit the competitors evaluated in the results.

Column
width50%
Expand
titleFeatured in these Insight Panels

Pricing Over Under

Brand Pricing Over / Under



Panel
titleCountry
Section
bordertrue
Column
width50%

Allows you to limit results to a specific country.


Expand
titleMore Details

This option is optional, and it allows you to limit results to a specific country. For many suppliers who sell domestically within the United States, it is never necessary to limit on this as the entirety of your sales data comes from the United States, so "Any Country" is effectively the United States.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Weekly Retail Sales Trend

4-4-5 Retail Sales Trend

Market Share Trend $

Multi-Retailer Sales Comparison

Phantom Inventory Trend



Panel
titleCustom Item Group
Section
bordertrue
Column
width50%

Allows you to limit the results in the insight panel to a custom group of items of your determination. Click here (link) to learn more about how to set up custom item groups.


Expand
titleMore Details

This option allows you to limit the results in the insight panel to a custom group of items of your determination. You and your team members can create an manage custom groups of items to allow more granular analysis for monitoring things such as new items, promotional items, and much more.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

4-4-5 Retail Sales Trend

Phantom Inventory Trend

Sell Thru By Retail Region

Sell Thru By Category

OOS Trends

7 Day Price Changes

Retailer Consumer Item Ratings



Panel
titleCustom Sales Region
Section
bordertrue
Column
width50%

Allows you to limit the stores evaluated by the insight panel to a custom group of stores which you or a team member previously created. Click here (link) to learn more about how to set up custom regions.


Expand
titleMore Details

This option allows you to limit the stores evaluated by the insight panel to a custom group of stores which you or a team member previously created. Custom regions allow you to group stores by any means you see fit.


Column
width50%
Expand
titleFeatured in these Insight Panels

Region Sales Heat Map

Custom Region Heat Map (called "Custom Region(s))

Category Overview

Market Sales Overview

Custom Regions Overview (called "Custom Region(s))

Region Weekly Sales Trend (called "Custom Region(s))

Market YOY Temp Diffs

Rain Calendar (called "Custom Region")

Recent Store Visits (called "Custom Region")

Visit Time Allocations

Visit Time % Vs Store Volume

Task Completion Map (called "Custom Region")

Task Completion Percent (called "Custom Region")

Sell Thru Trend

Phantom Inventory Trend

Sell Thru Cost $ By Category

Sell Thru Units By Market

Sell Thru By Retail Region

Sell Thru By Category

OOS Trends

Sell Thru Retail $ Heat Map

Sell Thru Retail $ By Category

Sell Thru Custom Region

Pricing Over Under

Brand Pricing Over / Under



Panel
titleCustom Sub-Title
Section
bordertrue
Column
width50%

Allows you to override the sub-title displayed in the insight panel to provide a more meaningfully descriptive result for your viewer.


Expand
titleMore Details

This option is purely cosmetic and provides you the ability to override the sub-title displayed in the insight panel to provide a more meaningfully descriptive result for your viewer.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Category Overview

Market Sales Overview

Weekly Retail Sales Trend

Market Share Trend $

Multi-Retailer Sales Comparison

Sell Thru Trend

Retailer Consumer Item Ratings



Panel
titleCustom Title
Section
bordertrue
Column
width50%

Allows you to override the title displayed in the insight panel to provide a more meaningfully descriptive result for your viewer.


Expand
titleMore Details

This option is purely cosmetic and provides you the ability to override the title displayed in the insight panel to provide a more meaningfully descriptive result for your viewer.


Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Category Overview

Market Sales Overview

Weekly Retail Sales Trend

Market Share Trend $

Multi-Retailer Sales Comparison

Sell Thru Trend

Retailer Consumer Item Ratings

Back to Top


Anchor
Mature Stores
Mature Stores

Panel
titleMature Stores
Section
bordertrue
Column
width50%

Allows you to select whether to view all store sales or only mature stores.


Expand
titleMore Details

This option allows you to select whether to view all store sales or only mature stores. Mature stores is often referred to as "comp stores". There are two prevailing definitions of "comp stores" which you should be aware of. The first definition includes results for stores that were open for an entire year for every week during the time period requested. The second definition includes results for stores as soon as they become open for a year - in this case, a store's results may be included for some portion of the weeks during the period and not others, if the store become open for a year during the middle of the time period requested. The first definition is more stringent, the second definition is more commonly used.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

Multi-Retailer Sales Comparison



Panel
titleMerchandising Region
Section
bordertrue
Column
width50%

Allows you to limit the stores returned within the insight panel to focus on particular regions.


Expand
titleDescription

This option allows you to limit the stores returned within the insight panel to focus on particular regions. You can select more than one by holding the "ctrl" or "shift" key while selecting several options.


Column
width50%
Expand
titleFeatured in these Insight Panels

Field Team Hours

Merchandising Stats

Back to Top


Anchor
Retailer
Retailer

Panel
titleRetailer
Section
bordertrue
Column
width50%

Allows you to select the applicable retailer's data that you wish to view.


Expand
titleDescription

This option allows you to select the applicable retailer's data that you wish to view. Your choice here will override your "Default/Primary" retailer for this given insight panel and will also cause a number of options below in the gear settings to update to reflect the specific values for that retailer; for example: category, time periods, custom regions and more.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Region Weekly Sales Trend

Recent Store Visits

Merchandising Stats

Sell Thru Trend

Phantom Inventory Trend

Sell Thru Cost $ By Category

Sell Thru Units By Market

Sell Thru By Retail Region

Sell Thru By Category

Sell Thru Retail $ Heat Map

Sell Thru Retail $ By Category

Retailer Consumer Item Ratings

Pricing Over Under

Brand Pricing Over / Under



Panel
titleRetailers
Section
bordertrue
Column
width50%

Allows you to select one or more retailers to customize the results of the insight panel.


Expand
titleDescription

This option allows you to select one or more retailers to customize the results of the insight panel. You can select more than one by holding the "ctrl" or "shift" key while selecting several options.

Column
width50%
Expand
titleFeatured in these Insight Panels

Weekly Retail Sales Trend

4-4-5 Retail Sales Trend

Multi-Retailer Sales Comparison

Back to Top


Anchor
Sales Metric
Sales Metric

Panel
titleSales Metric
Section
bordertrue
Column
width50%

Allows you to customize the returned results of the panel to a number of different sales metrics.


Expand
titleMore Details

The sales metric allows you to customize the returned results of the panel to a number of different sales metrics. Most common options include units, sales at cost or sales at retail value.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

Multi-Retailer Sales Comparison



Panel
titleSales/Inventory Metric
Section
bordertrue
Column
width50%

Allows you to customize the inventory value metric reported in the insight panel.


Expand
titleMore Details

This option allows you to customize the inventory value metric reported in the insight panel. Depending on the retailer, this may be most usefully displayed as either Cost Sales $ or Retail Sales $.

Column
width50%
Expand
titleFeatured in these Insight Panels

Sell Thru Trend



Panel
titleSell Thru Metric
Section
bordertrue
Column
width50%

With a focus on sell thru analysis, this option allows you to choose metrics which dictate what the underlying value the percentage reported is based on.


Expand
titleMore Details

This option generally applies to insight panels focusing on sell thru analysis. In this case, choosing the metric here dictates what underlying value the percentage reported is based on. Suppliers often wish to view cost as the metric, but in many cases you may wish to utilize units.

Column
width50%
Expand
titleFeatured in these Insight Panels

Sell Thru By Retail Region

Sell Thru By Category

Sell Thru Retail $ Heat Map

Sell Thru Retail $ By Category

Sell Thru Custom Region



Panel
titleShow Growth %
Section
bordertrue
Column
width50%

Allows you to overlay information on top of time-based trend insight panels which displays the difference as a percentage between the current year and previous year data.


Expand
titleDescription

This option applies to time-based trend insight panels and allows you the option to display a third series indicating the difference as a percentage between the current year and previous year data to get a measure of growth of the underlying values.

Column
width50%
Expand
titleFeatured in these Insight Panels

Weekly Retail Sales Trend



Panel
titleSorting Metric
Section
bordertrue
Column
width50%

Provides a way to limit the results your insight panel displays based on certain available metrics within the panel.


Expand
titleMore Details

The sorting metric provides a way to limit the results your insight panel displays based on certain available metrics within the panel. Much like the "# of results" option, this allows you to prioritize important results before limiting the number returned. For example - you may be interested in regions or categories of items where you shipped the most inventory - choosing "Most Shipments" would provide you with those results prioritized by the largest amount of shipped product, which could then be limited using the "# of results" option to create an effective "Top 10 Shipments", for example.

Column
width50%
Expand
titleFeatured in these Insight Panels

Sell Thru By Retail Region

Sell Thru By Category



Panel
titleState
Section
bordertrue
Column
width50%

Limits results of data to stores present in a given United States state or Canadian province.


Expand
titleMore Details

This option is mainly used to limit results of data to stores present in a given United States state or Canadian province. It is mostly useful for multi-retailer insight panels where using a specific retailer geography is not useful across numerous retailers but a state can be a standardized region. In this way, it serves to limit geography in a common denomination across retailers.

Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Category Overview

Market Sales Overview

Weekly Retail Sales Trend

4-4-5 Retail Sales Trend

Market Share Trend Units

Market Share Trend $

Market YOY Temp Diffs

Rain Calendar

Temperature Heat Map

YOY Temp Diff Heat Map

Sell Thru Trend

Sell Thru Cost $ By Category

Sell Thru Units By Market

Sell Thru By Retail Region

Sell Thru By Category

OOS Trends

Sell Thru Retail $ By Category



Panel
titleStore Hierarchy
Section
bordertrue
Column
width50%

The store hierarchy option allows you to choose how you would like the results of the insight panel to be displayed by different geographic boundaries.


Expand
titleMore Details

The store hierarchy option allows you to choose how you would like the results of the insight panel to be displayed. Specifically, it allows you to switch between geographic hierarchies for the particular retailer you're interested in. Depending on the business need, you may want to look at a greater or lesser level or retailer detail in your analysis. This provides the option relating to the retailer's geography.

Column
width50%
Expand
titleFeatured in these Insight Panels

Region Sales Heat Map

Market Sales Overview

Sell Thru By Retail Region

Back to Top


Anchor
Task
Task

Panel
titleTask
Section
bordertrue
Column
width50%

Choosing a specific task will direct the insight panel to report specifically on the progress of the task chosen.


Expand
titleMore Details

This option relates to task-specific insight panels. Avantalytics has a task management module for your salesforce management and if you use this, you'll see a list of your created tasks populate in this option. Choosing a specific task will direct the insight panel to report specifically on the progress of the task chosen.

Column
width50%
Expand
titleFeatured in these Insight Panels

Task Completion Map

Task Completion Percent



Panel
titleTime Period
Section
bordertrue
Column
width50%

Depending on the insight panel, this option can allow you select any of dozens of pre-made and rolling time periods such as "Month To Date" or "Week". Additionally, it may also provide pre-made and fixed time periods - such as "Calendar Year X".


Expand
titleMore Details

Time Period is probably the most ubiquitous option seen across insight panels. The nature of customer's data and the underlying business makes the time period involved central to most analyses. Depending on the insight panel, this option can allow you select any of dozens of pre-made and rolling time periods such as "Month To Date" or "Week". Additionally, it may also provide pre-made and fixed time periods - such as "Calendar Year X". Avantalytics maintains these time periods for each retailer to allow you to utilize them without the hassle of dealing with different begin and ending periods for each retailer.


Column
width50%
Expand
titleFeatured in these Insight Panels

State Sales Heat Map

Region Sales Heat Map

Custom Region Heat Map

Category Overview

Market Sales Overview

Custom Regions Overview

Weekly Retail Sales Trend

Region Weekly Sales Trend

4-4-5 Retail Sales Trend

Market Share Trend Units

Market Share Trend $

Multi-Retailer Sales Comparison

Market YOY Temp Diffs

Temperature Heat Map

Precipitation Map

YOY Temp Diff Heat Map

YOY Daily Precip Map

Field Team Hours

Merchandising Stats

Visit Time Allocations

Visit Time % Vs Store Volume

Sell Thru Trend

Sell Thru Cost $ By Category

Sell Thru Units By Market

Sell Thru By Retail Region

Sell Thru By Category

OOS Trends

Sell Thru Retail $ Heat Map

Sell Thru Retail $ By Category

Sell Thru Custom Region



Panel
titleTiming
Section
bordertrue
Column
width50%

Allows you to choose what time of day you wish to use for evaluating the percent of precipitation.


Expand
titleMore Details

The timing setting allows you to choose what time of day you wish to use for evaluating the percent of precipitation. Your choices can be either in the Morning / Mid-Day (prior to noon) or in the evening (after 6pm) or the value for the likelihood at anytime during the day. The default is anytime.

Column
width50%
Expand
titleFeatured in these Insight Panels

Precipitation Map

YOY Daily Precip Map



Panel
titleTop X
Section
bordertrue
Column
width50%

Allows you to limit the number of results based on the greatest values for the metric you want to display in the insight.


Expand
titleMore Details

Top X allows you to limit the number of results based on the greatest values for the metric you want to display in the insight. For example - if you wish to see the top 5 markets with the most retail sales, you would choose a value of 5 in this and select Retail Sales $ in the sales metric as shown in the screen capture below.

Column
width50%
Expand
titleFeatured in these Insight Panels

Category Overview

Back to Top