Weekly Offer Performance

Purpose

This report provides a drill-down view into the overall performance of offers in a selected week.  The offers, and their item details, are displayed within a “product universe” you select, and further differentiated by a  “groupby” level defined by an attribute of product that you select.  offrwkperf

Instance

  • Location – Standard Location selector(s).  As offers are kept not only by the week in which they run but also by the stores in which they are available, the offer scope of the report instance will be limited to those offers available in the stores you identify.
  • Product Universe – Using a Standard Product attribute selector you can limit the offers in the scope of the report to just those that have items in a product attribute node.
  • Group Offers By – Select a product dimension attribute from a standard dimension list of attribute names to create a grouping of offers by that attribute.
  • Promotion Week – The Standard Time selector limited to a list of Weeks.  The report will contain only offers that ran in the week you select.
  • Shopper Group – Standard Shopper Group selector.

Rows

Rows represent aggregated purchasing totals in the selected week for the shopper group selected and the remaining non-card identified purchasing.

  • The top level of the drill-down is the product universe level.  The data in this row is the purchase activity for all the items in that product node.  So if the selected node was a SuperDepartment of “Grocery” then the data represented is for all the items in “Grocery”.
  • The second level is the “groupby” level.  A groupby node is one of the values of the selected groupby attribute (like: Brand) where items in that node were included in an offer for the week.  So, if Brand A had offers running in the week there will be a row for Brand A containing all the activity for items in the product universe that are also Brand A.  If Brand X, also a member of the product universe, had no items in offers for the week then that brand would not be represented.
  • The third level is the offer level.  An offer will have a row when at least one item in the offer belongs to the product universe and to the parent groupby node.  Its data will be the purchase activity of the items in the offer, in the product universe, in the groupby parent node.  Recognize that if an offer contains items that have different groupby node parents then that offer will appear under each of those groupby parents, and the data will represent only those items belonging to that groupby parent.  Like: an offer contains items in both the Beer category and the Ale category, and the groupby attribute is Category, then that offer would appear twice in the report; once under Beer with all the beer item sales, and once under Ale with all the ale item sales.
  • The lowest level is the items in the offer.  These data are the purchase activity for those items, regardless of their being bought on deal or at full price.

Columns

Columns are the report Metrics, grouped by across headings.

  • $ Metrics – a group of metrics representing $ sales (list price less item discounts applied)
    • With Card – purchasing where the transaction was loyalty card identified.
    • Without Card – purchasing where the transaction was not connected to a loyalty card.
    • Total – arithmetic sum of the “with card” and “without card” metrics.
    • Card % Total $ –  “with card” metric divided by the sum of the “with card” and “without card” metrics expressed as a %.
  • Unit Metrics – same as the $ Metrics but representing unit sales.
  • Household Metric – a group of metrics based on householded loyalty card counts.
    • HH Buying – a count of the householded loyalty cards purchasing the row
    • $/HH Buying – “with card” $ divided by the count of the householded loyalty cards purchasing the row
    • Units / HH Buying – “with card” units divided by the count of the householded loyalty cards purchasing the row

 

  • $ Sales – $ are defined in this report as the list amount less any item markdown amount.
    • Current – $ in the selected timeframe.
    • Current % of Parent – $ sales expressed as a % of the item group’s immediate hierarchical parent for the selected timeframe.
    • Prior Period – $ in the comparison timeframe
    • Prior Period % of Parent – $ sales expressed as a % of the item group’s immediate hierarchical parent for the comparison timeframe.
    • $ Change – selected timeframe $ less comparison timeframe $
    • % Change – $ Change expressed as a %
  • Unit Sales
    • Current – unit sales in the selected timeframe.
    • Prior Period – unit sales in the comparison timeframe
    • % Change – Unit sales change (selected timeframe less comparison timeframe) expressed as a %
  • Average Item Price – calculated as the actual net sales dollars divided by the number of units sold
    • Current – in the selected timeframe.
    • Prior Period – in the comparison timeframe
    • % Change – Change (selected timeframe less comparison timeframe) expressed as a %
  • Households – the count of households represents the count of distinct household shopping IDs
    • Current – in the selected timeframe.
    • Prior Period – in the comparison timeframe
    • Shopped Prior Period not Current – This is the count of households in the list of households satisfying this specification.