Page Comparison

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.

Image Added

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.

Image Modified

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.

Image Modified

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.

Image Modified

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.

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified

/ Under

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.

Image Modified

Image Modified

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.

Image Modified

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

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

Image Modified

; for example

: category, time periods, custom regions and more.

Image Modified

Image Modified

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.

Image Modified

Image Modified

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 $.

Image Modified

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.

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified

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.

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified

Image Modified

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.

Image Modified

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.

Image Modified

Image Modified