This report helps you understand pricing changes and how they impact your business, so you can optimize your pricing strategy to boost sales and margins.

Item Overview page

This page allows you to see how your products are priced and review this alongside sales to understand how pricing impacts your business.

Visualizations

Item details table

This table provides your average retail price and sales data by product, so you can investigate the relationship between pricing and sales.

You can right-click a product in this table and select Drill through > Price Point Map to see a state by state view of the price point per store for the selected product. For more on how to use this page, see Price Point Map page

Price point table

This table displays your prices (sorted ascending) to help you see where your prices are highest and lowest and how many stores are selling at each price.

Store Count by Retail

This plot provides the store count on the y-axis and the retail price on the x-axis to help you quickly spot outliers in terms of price and see the corresponding store counts to help you gauge the prevalence of that price point. 

Average Retail Price by Product Category

This chart displays your average retail price by category to help you get an overall sense of your pricing by category. You can also right click a bar in this chart and drill-down see retail pricing distribution by subcategory, fineline, or product.

 

Price Point Map page

This page is hidden by default and you can only access it via the Item Overview page. To access this page, just right-click a product from the price point table, then select Drill through > Price Point Map.

You can use this page to help you see the geographic regions where a price point is in use and pinpoint the specific stores that use a price point. You can then use that store list to address price points that are high or low compared to your expectations.

To investigate a specific price point, select it from the price point table at the top left of the screen or the legend in the map, then you can see where that price point is in use in the map and review a list of stores that use that price point in the table at the bottom of the screen.

Price Change Velocity Tracker page

This page allows you to quickly see pricing actions that have taken place and gauge their impact. 

Visualizations

Overview tiles

  • Items with Price Change- Displays the total number of items with a retail price change.
  • Avg Weeks with New Price- Displays the average number of Walmart weeks where there was a new price.
  • Items with Cost Change- Displays the total number of items where the purchase cost has changed.
  • Sales Amount Average YOY %- Displays the percent change in average sales dollars year over year.
  • Sales Quantity Average YOY %- DIsplays the percent change in average sales quantity year over year.
  • Next 4 Weeks Sales Projection- Displays the dollars you are projected to sell in the next four weeks.

Graphs

  • Sales Quantity vs PY- Displays your sales quantities over time for the current and prior year.
  • Sales Amount vs PY- Displays your sales amount over time for the current and prior year.
  • Average Retail Price Current and Velocity Sales (Stores w/ Sales) Current by Walmart Year and Walmart Week- Displays your current average retail price as well as your sales velocity (for stores with sales) over time to help you understand the relationship between price and sales and find an optimal pricing strategy. 

Pre vs Post Price Change table

This table helps you track price change impact by product. You can see the weeks since the last price change and pre and post-price change average sales dollars, to help you see if a price change had a positive impact on sales.