WTD, CWW & Other CPG Data Acronyms

In CPG syndicated data, WTD almost never means week-to-date. It is the standard abbreviation for Weighted, as in % ACV Wtd Distribution, the measure that weights a brand's store coverage by how much each store actually sells. That single mix-up, week-to-date versus weighted, is the most common acronym error in retail-measurement reporting, and it is not the only one: CWW and BWW are merchandising measures, while YTD and L52W are genuine time windows, and analysts routinely blur the four together in the same deck. This guide defines the acronyms a CPG analyst really meets in a Nielsen, Circana, or SPINS report, WTD, CWW, BWW, YTD, MTD, L52W, L13, L4, and YA, and explains how each one changes the number it sits next to.

What does WTD mean in CPG data?

WTD is the abbreviation for Weighted. In a syndicated report it shows up attached to distribution and promotion measures, most often as % ACV Wtd Distribution: the share of category volume represented by the stores that carry your product. The weighting is by ACV (all-commodity volume), the total dollar sales a store rings across every product it sells, so a single supercenter counts for far more than a corner convenience store.

The reason the weighting matters is that store counts lie. Suppose your granola is stocked in 40% of the stores in a market, but those happen to be the largest 40%, the supercenters and big grocery banners. Your numeric (unweighted) distribution is 40%, yet your % ACV weighted distribution might be 70%, because the stores you are in account for 70 cents of every category dollar the market spends. The weighted number is the one a buyer cares about, because it tracks selling opportunity, not door count. For the full calculation, including the trap of double-counting ACV when you sum several retailers, see ACV-weighted distribution on Scout Learn and our guide to %ACV distribution.

So if you searched for WTD expecting week-to-date, here is the catch: that meaning belongs to general retail and finance dashboards, not to syndicated CPG data. Inside a Nielsen or Circana cut, Wtd is Weighted every time. Week-to-date lives in the next section, alongside the other to-date windows it gets confused with.

Week-to-date, MTD, and YTD: the to-date windows

The to-date acronyms measure everything that has accumulated from the start of a calendar period up to the latest closed week. Week-to-date (WTD on a general retail dashboard, never in syndicated data) is sales so far this week. Month-to-date (MTD) is everything since the first of the month, common in retailer portals and rare in syndicated cuts. Year-to-date (YTD) is the one that genuinely shows up in syndicated reporting: the cumulative total from the first selling week of the year through the latest week available.

A worked example keeps it concrete. If your brand sells about 12,000 units a week and the latest closed week is week 20 of the year, your YTD units are the sum of weeks 1 through 20, roughly 240,000 units, not an annualized or averaged figure. The number grows every week and resets to zero when the new calendar year starts, which is exactly why a YTD comparison in January is close to meaningless: two or three weeks of data carry enormous swing. YTD answers how the year is going so far. It does not, on its own, tell you whether the brand is healthier than it was twelve months ago. That is the job of the rolling windows further down.

CWW: cumulative weighted weeks

CWW, cumulative weighted weeks, is the most comprehensive measure of merchandising support, because it captures both the reach of a promotion (how much of the market saw it) and its frequency (how many weeks it ran). Nielsen calls it CWW; Circana, carrying the old IRI naming, calls the same thing Wtd Wks, or weighted weeks, which is one more place the Weighted abbreviation hides. See Circana data explained for the provider-naming history.

It is built by summing the % ACV on a given merchandising condition across each week of the period. Say your brand ran a feature in one market over four weeks, reaching stores that represented 55%, 45%, 30%, and 85% of category ACV in those weeks. Add them: 0.55 + 0.45 + 0.30 + 0.85 = 2.15 CWW. Read that as the equivalent of 2.15 weeks of feature support at full (100% ACV) distribution. The catch is that CWW is neither additive nor unique: 1.0 CWW could mean 100% ACV for one week or 50% ACV for two weeks, and you cannot sum a brand's CWW across two markets to get a national figure. It is a rate-shaped number wearing a count's clothing.

BWW: base weighted weeks

BWW, base weighted weeks, answers the same question as CWW, how much promotion support did a product really get, but weights each store differently. CWW weights every store by its total ACV, its overall size across all products. BWW weights each store by that specific product's own base volume in the store, the units it sells when nothing is on promotion. The distinction sounds academic until the two disagree.

Picture a hot-sauce brand that sells heavily in a regional grocery chain but barely registers in a national supercenter that is, in raw ACV terms, much larger. CWW credits a feature at the supercenter generously, because the store is big overall. BWW discounts it, because the brand has almost no base business there, so the feature reached the shelf but few of the brand's actual buyers. For judging whether promotion support landed where the product can convert it, BWW is the truer read, which is why it shows up in post-promotion lift analysis. CWW is the better read of raw market exposure.

L52W, L13, and the rolling windows

Rolling windows are the workhorse of syndicated reporting, and they are written as L (for latest) plus a week count. L52W, latest 52 weeks, is a trailing year that always ends at the most recent closed week and drops the oldest week as a new one lands. L13 is the latest 13 weeks (a rolling quarter), L26 the latest 26 (a rolling half), and L4 the latest 4 (a rolling month). Some reports write them R52 or 52 W/E (weeks ending); the meaning is identical.

The point of a rolling window is to neutralize seasonality. Comparing L52W this period against L52W a year ago, often labeled YA or year-ago, holds the season constant on both sides, so a swing reflects a real change in the business rather than the calendar turning. Shorter windows trade that stability for freshness: L4 catches a new launch or a price change fast but bounces around with every promotion and holiday. Most analysts read the long and short windows together, the L52W for the trend and the L4 or L13 for what just happened. Velocity, the units-per-store-per-week measure, is reported inside whichever window you pick, so it stays comparable across them. See CPG sales velocity and total distribution points for the metrics that ride on top of these windows.

How the time period changes the number

Choosing a window is not a formatting decision. It changes what the number is allowed to mean, and three traps catch people most often.

• Some metrics do not add up. Dollar and unit sales are additive: sum the weeks and you get the period total. But % ACV distribution, number of stores selling, and Max ACV are not. You cannot add a brand's weekly % ACV across 52 weeks to get an L52W figure; the data provider recomputes those over the whole window. Roll up a non-additive metric by hand and you will report a distribution number several times too high.
• Rolling and to-date answer different questions. An L52W view and a YTD view of the same brand in June will rarely match, because YTD covers about 24 weeks and resets in January while L52W always spans a full year. Neither is wrong; quoting one when the room expects the other is.
• Weeks do not end on the same day. Nielsen weeks end on Saturday, Circana weeks end on Sunday. Line up an L13 from each provider and the windows are offset by a day, so the totals will not tie out to the dollar. It is the first thing to check when two syndicated sources disagree by a hair.

None of these are exotic. They are the everyday reasons a number on one slide does not match the same metric on the next, and naming the window precisely (L52W ending 5/31, Circana) is what keeps a category review from turning into a debate about whose spreadsheet is right.

Quick-reference table: CPG data acronyms

One table for the acronyms a syndicated report throws at you, and the single thing to remember about each.

Where Scout fits

The acronyms only bite when you are reconciling more than one source, and that is the work Scout takes off the analyst's desk. Scout harmonizes Nielsen, Circana, SPINS, and retailer first-party feeds into one comparable view, which means it aligns the things this guide warns about: the Saturday-versus-Sunday week endings, the rolling-versus-to-date windows, and the non-additive measures that cannot simply be summed. Pick L52W or YTD once and every provider's data answers in the same window, weighted measures stay weighted, and the % ACV distribution number is recomputed correctly instead of added up by hand. The analyst stops arguing about whose week-ending is right and gets back to reading the business. To see it run on your own syndicated data, reach out at hello@cpgscout.ai.