CMA Formatting and Functionality Updates
      Back to home
      1. InfoSource Knowledge Base
      2. Competitive Market Analysis
      3. CMA Formatting and Functionality Updates

      Beer CMA Updates August 2023

      We're making a few minor updates to the Beer CMA's core set of sixteen dashboards. These updates are scheduled to be published on Tuesday, August 15th.

      For greater consistency, the locations of several filters and parameters (on the right side of the dashboards) have changed in our core set of sixteen dashboards. On some dashboards, additional filters have been added, as well:

      Item Audit:

      • Add a Category filter and Vendor filter above the Brand Family filter

      Footprint:

      • Move Footprint dashboard next to the Item Audit dashboard, so it shows up between “Item Audit” and “Category/Segment Analysis” in the Tableau Buttons running across the top of the screen.

      Rankers:

      • Add a Brands & SKUs filter under the Brand Family filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Price per Case filter under the Alcohol by Volume filter
      • Move the Vendor filter under the Segment filter

      Dollar Rank Comp & Dollar Ranker with CWD:

      • Add a Brands & SKUs filter under the Brand Family filter
      • Add a Dollar Trend vs LY filter below the Brands & SKUs filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Price per Case filter under the Package Size filter
      • Move the Vendor filter under the Segment filter
      • On Dollar Rank Comp, change the name of the “Ranker 3rd Column” parameter to “3rd Column Measure”

      Sales per PT vs CWD

      • Move Package Type and Package Size Group filters below the Beer Style Level Value
      • Add Vendor filter under the Segment filter

      Dimensions Over Time :

      • Move the Vendor filter under the Segment filter
      • Move the Price per Case filter under the Alcohol by Volume filter

      Price Analysis:

      • Move Package Type and Package Size Group filters below the Alcohol by Volume filter
      • Add a Vendor filter under the Geography filter

      The Column & Row (C&R) dashboards:

      Please note that, in the interest of consistency across Beer, Wine, and Spirits, we're updating the naming structures of the header columns in C&R, C&R by SKU, and C&R Geogs. View a detailed list of those changes here.

      The following details describe changes in the locations of several filters and parameters, plus a few new measures which have been added, in the Beer column and row dashboards.

      C&R:

       The following measures have been added to C&R, just to the right of the Incremental Dollars merch condition measures:

      • CWD Display Only (MAX)
      • CWD Feature Only (MAX)
      • CWD Any Display (MAX)
      • CWD Any Feature (MAX)
      • CWD Feature and Display (MAX)
      • CWD Feature and or Display (MAX)
      • CWD Any Price Reduction (MAX)
      • CWD Price Reduction Only (MAX)

      Additional Changes to C&R:

      • Add a New or Existing Brand filter under the Dom vs Imp Value filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Vendor filter under the Segment filter
      • Move the Alcohol by Volume filter under the Package Size Group filter
      • Move the Rank Filter under the Alcohol by Volume filter
      • Remove the words "Brand Level" and "Brand Level Weekly" from the table for clarity

      C&R Geogs:

      • Add a New or Existing Brand filter under the Dom vs Imp Value filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Price per Case filter under the Alcohol by Volume filter
      • Move the Vendor filter under the Segment filter
      • Add a Rank column in the chart

      C&R by SKU:

      • Add a New or Existing Brand filter under the Dom vs Imp Value filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Price per Case filter under the Alcohol by Volume filter
      • Move the Vendor filter under the Segment filter
      • Remove the words "Brand Level" and "Brand Level Weekly" from the table for clarity

      C&R Brands Over Time:

      • Add a New or Existing Brand filter under the Dom vs Imp Value filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Vendor filter under the Segment filter
      • Move the Alcohol by Volume filter under the Price per Case filter

      C&R Geogs Over Time:

      • Add a New or Existing Brand filter under the Dom vs Imp Value filter
      • Move Package Type and Package Size Group filters below the Beer Style Level Value filter
      • Move the Price per Case filter under the Alcohol by Volume filter
      • Move the Vendor filter under the Segment filter