• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

CPG Data Tip Sheet

Transforming your syndicated data into business insight

  • Home
  • Glossary
  • About Robin Simon
  • About Sally Martin
  • Contact
Blog » Know Your Measures: Pricing and Promotion » Q. What’s your retail price? A. It depends!

Q. What’s your retail price? A. It depends!

May 13, 2014 By Robin Simon 6 Comments

Print Friendly, PDF & Email

price tag qmark

According to the dictionary, the price of something is “the sum or amount of money or its equivalent for which anything is bought, sold, or offered for sale.” Pricing is one of the “4 Ps” of marketing that we learned about in school (along with Product, Placement/Distribution and Promotion) and is often a key driver of how consumers perceive the quality of a brand or product. But…which measure would you use when answering the question: “What’s your retail price?” (Just to clarify, the retail price is what consumers pay for a product when they buy it at a store, not what retailers pay to buy the product from a manufacturer. The retail price is what IRI and Nielsen report.)

Your IRI/Nielsen database can have as many as 226 different facts relating to price! The number of facts increases quickly when you consider all the different merchandising conditions (talked about here) and the various change measures (absolute, %, vs. year ago, vs. previous period, etc.). If you are just getting started with this kind of data, the first thing to look at is average price, the most basic price measure. Average price is the best way to compare your overall pricing to the competition and to identify which brands are premium, mainstream or value positioned.

avgprc

Reminder: If you are looking at price per unit, make sure the items in your product totals are all similarly priced. Notice that in this example we are looking at 6-count muffins. Do not look at price per unit at the brand level unless all the items in that brand are the same size (or close enough to be priced together.

While average price is a general indication of pricing, NOBODY actually pays that! Shoppers either see the “everyday price” if the product is not on sale that week or the “sale price” if it is on sale. Take a look at the national data for two different Muffin brands below. Mollie’s has the higher average price ($2.84 v. $2.64), but looking at the different components of those average prices shows a more complete picture. Mary’s has a higher everyday price and even crosses the $3 threshold ($3.26 vs. $2.95), but it has a lower sale price than Mollie’s ($2.31 vs. $2.58).

prcg1

Note: Base price and Non-Promo (called No Merch in IRI) price are the measures used for “everyday” (not on sale) price. The most basic measure of “sale” price is Promoted price (called Any Promo in Nielsen, Any Merch in IRI). A future post will explain why it is important to further decompose Promoted price based on merchandising tactic.

A second way to understand what is really happening with pricing is to look below the national, all outlet level. Just as nobody pays the average price for anything, nobody pays the national price either. The national price is made up of dozens of different retailers in different markets around the country, charging different retail prices for the same product. The above example shows data for Total US xAOC, the largest geography available in Nielsen (read more about that here). Although this gives a general picture of pricing, it is very common (and recommended) to at least break down national pricing into Total US Food/Grocery vs. Walmart. Those two channels tend to have very different pricing strategies, with prices at Walmart significantly lower than those in the Food channel, like for Mollie’s Muffins 6-Count:

prcg2

Of course, if you’re presenting to a specific retail customer you would look at pricing for that retailer. Even within the Food/Grocery channel there is typically a wide variation in pricing between retailers. It is also useful to look at pricing across retailers when evaluating your pricing strategy and assessing in-market retail execution.

prcg3

Looking at the top 5 Food customers for Mollie’s Muffins, you can see that:

  • There’s a wide variation in average price, with two of the top five retailers significantly below $3, another two right around $3 and one above $3.
  • The everyday, or base, prices are much closer at the top five retailers, ranging between $2.85 and $3.22.
  • The sale, or promoted prices, show the widest variation between retailers.

If you look at base price per unit at a particular retailer in a specific market, that is probably as close you’ll get to seeing the regular price that shoppers actually pay in-store. (Promoted price, even for a specific retailer, is still a weighted average of the different merchandising tactics so not likely to be a real price that shoppers see.)

So…what have we learned from this?

  1. Average price is a good place to start when trying to understand retail pricing.
  2. When looking at price per unit, make sure it’s for a promoted product group – an aggregation of items that are priced together (and usually the same size).
  3. It is useful to understand the components of Average Price and not just rely on that one measure.
  4. Different channels and different retailers within channels have different pricing strategies. This should be considered when developing your pricing strategy and evaluating its execution and effectiveness in the marketplace.

Did you find this article useful? Subscribe to CPG Data Tip Sheet to get future posts delivered to your email in-box. We publish articles twice a month. We will not share your email address with anyone.

Share8
Tweet
Share

Filed Under: Know Your Measures: Pricing and Promotion Tagged With: average price, base price, everyday price, promoted price, retail price, sale price

Reader Interactions

Comments

  1. Charlotte says

    January 27, 2017 at 5:52 pm

    If a consumer buys something with a coupon, how does Nielsen record the price paid? Is it price less coupon? Or does the coupon discount not get reflected?

    Reply
    • Sally Martin says

      February 3, 2017 at 9:08 am

      Manufacturer coupons are not reflected in syndicated data prices. Retailer coupons should be reflected.

      Reply
      • Dana says

        May 18, 2017 at 5:05 pm

        Are retailer coupons reflected in base, promo, and avg prices?

        Reply
        • Robin Simon says

          May 18, 2017 at 6:35 pm

          Retailer coupons would be reflected in promoted price and also average price but not in base price. Remember that base price is the price if no retailer promotions were present.

          Reply
  2. Dylan says

    September 7, 2018 at 6:46 pm

    When calculating any promo price/unit, is the formula (any promo dollars/any promo units)? Does the formula (promo dollars/total units) make any sense?

    Reply
    • Robin Simon says

      September 9, 2018 at 5:55 pm

      The formula for Any Promo Price/Unit is Any Promo Dollars/Any Promo Units, your first point. I have never seen the 2nd formula you reference. Can you give me more information about when you might use that?

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Top Posts

  • The 2nd Most Important Measure: % ACV Distribution
  • Velocity: How Well Your Product REALLY Sells
  • Total Distribution Points: Master of All Distribution Measures
  • xAOC and MULO: Multi-Channel Markets in Nielsen & IRI
  • The Beginner’s Guide to Trade Merchandising Measurement

Search CPG Data Tip Sheet

Subscribe to New Posts

Get new posts delivered straight to your inbox. We won't share your email address with anyone.

Thank you for subscribing!

Subscribe

About CPG Data Tip Sheet

We (Sally Martin and Robin Simon) first met in business school and bonded over our interest in geeky marketing stuff. Eventually we both started independent consulting practices. Now we’ve reunited to share with you some of what we’ve learned in our decades of experience working with syndicated CPG data.

Categories

  • Glossary (79)
  • How To Answer Business Questions (42)
  • How To Communicate Insights (17)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (12)
  • Know Your Measures: Distribution (24)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)

Tags

ACV analysis examples analytic skills attributes average items base base weighted weeks career development category management channels characteristics coronavirus coverage factor covid-19 Database distribution due-to Excel tips Facts incremental markets Measures merchandising new items panel data periods pricing pricing strategy products promoted price quantify opportunity retailer direct data retailer markets shopper data store data Syndicated TDP the basics trade promotion trading areas velocity visualization visualizations volume bridge volume decomposition

Footer

Categories

  • Glossary (79)
  • How To Answer Business Questions (42)
  • How To Communicate Insights (17)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (12)
  • Know Your Measures: Distribution (24)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)

Search CPG Data Tip Sheet

Tags

ACV analysis examples analytic skills attributes average items base base weighted weeks career development category management channels characteristics coronavirus coverage factor covid-19 Database distribution due-to Excel tips Facts incremental markets Measures merchandising new items panel data periods pricing pricing strategy products promoted price quantify opportunity retailer direct data retailer markets shopper data store data Syndicated TDP the basics trade promotion trading areas velocity visualization visualizations volume bridge volume decomposition

Terms of Use | Copyright © 2025 CPG Data Insights · Log in