Reports

New reports don’t appear immediately. And, that is a good thing!

The architecture of the Suite provides that all analytics are performed by a database engine.  The result of those transformations are stored in a concise output table in the database, and the browser asks the database for those results to then present them in graphical and/or tabular format.

When you first define a report instance by selecting a unique combination of choices from the dropdown selectors you will not see a report appear.  You must first confirm your selections by asking the report be run RunReport by clicking on the run icon.  At that time the report will be submitted to the execution queue.  This is a big difference between the Suite and most WYSIWYG query generator reporting products.

The Suite doesn’t constrain your analytics to what a WYSIWYG query generator can manage. So, it is not just generating a single query from your selections, executing that query and immediately displaying the results. This platform allows the report/analysis creator/programmer to go absolutely nutso and use any/all the capabilities of the database engine to accomplish even very complicated analytics.  So much so that

  • we found it necessary to provide a HELP page for each report as a place to explain what interesting things were done by that report programmer to achieve the specified analytic result, and
  • we now have the situation where you can ask for an analysis that is soooooo involved, and potentially that much more useful to you, that it takes longer to run that you are willing to sit there and wait for it.  So, feel free to ask for the report to run then navigate to some other place for a while.  When the report finishes it will pop up a notification on the screen for you.

Following is an inventory of reports grouped by general purpose.

 

Segmentations

 

Value Segmentation

assigns “Value” segment values to shoppers in the designated Quarter and reports metrics by segment.  This segmentation is based upon total purchasing in the store in the timescope of the report.

Meal Planning Segmentation

assigns shopping households to a segment based upon their preponderance of spending in one of many named product groups.

Price Sensitivity Segmentation

assigns “Price Sensitivity” segment values to shoppers in the designated Quarter and reports metrics by segment.  Price sensitivity is based upon the distribution of purchase of high/medium/low priced category items in the categories shopped by the household.

Segmentation by Discount Use

assigns segment values based on the percent of item purchases are made on deal.

Customer Flow Segmentation

assigns segment values based on purchasing performance comparing the first 30 days, middle 30 days and final 30 days of the selected quarter.

Custom Spend Segmentation

an “ad hoc” way of separating shoppers into groups to compare % performances across metrics.

Crosstab Segmentations

will cross tabulate 2 or 3 segementations showing the interactions among those segmented communities.

 

Trends

Trial and Repeat

gives you a feeling for the repeat purchase behavior of Households in a defined group of items over the timescope of the report.  Particularly interesting could be the cumulative data; Household counts and Household Penetration compared to all Households shopping in the defined product Universe of the report.

Customer Flow Trends

gives you a sense of the ebb-and-flow of shoppers in their recency/activity using groups like; New, Revived, Declining, Lapsed, as well as participation of the corporate standard segments (Diamond,Ruby,Pearl,Opal,Quartz). Trends are mapped over 4 week periods

Insights

 

Basket Composition by Offer

shows us what was purchased in the same baskets with items that were on promotion in a selected offer for the week.

Weekly Offer Performance

drills down from a selected Product universe through an Attribute based grouping to individual offers and even the items in the offers running in the selected week and store limitations.

Sales Change Decomposition

breaks down the influences that affect the change in sales across adjacent

Purchasing by Hour

presents purchasing by hour by day-of-week for your chosen scope of time,stores, products and shoppers.

Product Topline

provides a convenient overview of products, via a drilldown hierarchy, across metrics of $ spend, unit sales, price and count of households buying.

Store Topline

provides a convenient overview of stores, via a drilldown hierarchy, across metrics of $ spend, unit sales, price and count of households buying.

SKU Review

provides a multi metric review at the item level of items in a selected product hierarchy node.

 

Utilities

 

Completed Report Instances

presents information on completed report instances for your selected report.  Clicking on the report instance number in the report will take you to that completed report page.

Recently Run Reports

lets the logon user see which reports s/he has recently run. Lists the most recent N.