Consumer Insights Analytics That Drive Category Action

Consumer Insights Analytics That Drive Category Action

Walk into the average $5M-$10M FMCG brand on a Tuesday morning and the scene repeats. An analyst rebuilds a 12-tab Power BI workbook nobody outside their team has opened in three weeks. Sales argues with marketing about whether the new SKU is cannibalising the hero pack, on gut feel. Around 20% of promotional volume is genuinely incremental, according to RGM Academy research on source-of-volume. The rest is absorbed by cannibalisation and pantry-loading, a pattern the typical dashboard suite never surfaces in time to change next quarter's plan. The dashboard suite is not insights. It is reporting. And reporting in 2026 is a cost line, not a growth lever.

The Dashboard Graveyard: Why More Tabs Will Not Save You

There is a phrase I use with every FMCG founder who hires me to fix their consumer-insights function: "the dashboard graveyard." It describes the sprawl of Tableau, Power BI, Looker, Nielsen Discover, and Circana panel dashboards a brand accumulates after three years of someone saying "we need more visibility." Each dashboard was reasonable at the moment of birth. Together, they paralyse decision-making, because nobody knows which signal to act on first.

The Bain 2025 Consumer Products Report makes the structural case bluntly. CPG productivity is under pressure from input costs, retailer concentration, and Gen AI disruption all at once. The industry's traditional reporting overhead is no longer affordable. Bain CPG 2025 outlook frames the next two years as a forced reckoning between insights teams that produce reports and insights teams that route decisions.

Notice the gap between those two states. A dashboard suite is built for completeness of data. A decision-routing function is built for velocity of category action. Most brands reward the first and let the second wither, because building dashboards is visible work. The analyst can show their week's output. Routing a signal to the right decision-owner is invisible and uncomfortable. It requires telling the brand director that they own a decision they would rather defer.

This is the failure landmine that consumer insights analytics teams keep stepping on. They treat themselves as a reporting function rather than a decision-routing function. Reports get cut in a downturn. Decisions do not. If your insights team owns reports rather than decisions, you will lose the budget the moment the CFO needs to find 5%.

Bain on consumer-led growth puts a sharper edge on this. Their consumer-led growth model assumes the role of insights is to identify the four or five demand drivers in a category and route them into the brand's go-to-market choices. Not into a dashboard. Into a choice. Most brands run that flow in reverse. They collect every available data point, build a workbook that displays them all, then hope a decision falls out. It does not.

The cost of getting this wrong is hidden inside promotional ROI. When RGM Academy's source-of-volume research shows roughly 20% of promotional volume is truly incremental, it means 80% is being absorbed elsewhere. Pantry-loading, forward-buy, brand cannibalisation, and category cannibalisation each take a slice that the brand's dashboard never decomposed in time. The data was probably available. Nobody routed it.

There is a second cost most operators miss. Across the dozen-plus FMCG founders I have worked with in the $5M-$10M band, the insights team is the function with the lowest visibility into board-level decision making. Brand directors report on activations. Sales reports on retailer wins. Insights reports on dashboards built. Two of those three are decisions. One is busywork. The board notices.

The Consumer Signal Architecture

I call the replacement framework The Consumer Signal Architecture. It is built on a simple inversion. Instead of asking what your dashboards should show, you ask what four signals you route to which four decision-owners on what cadence. The Consumer Signal Architecture is not a piece of software. It is a routing protocol layered on top of whatever data infrastructure you already own.

The architecture has three components. First, four named signals, chosen because they map directly to the four most expensive decisions a brand of your size makes in a quarter. Second, four named decision-owners, each accountable for actioning their assigned signal. Third, a weekly routing cadence with a fixed agenda, where each signal-owner reports the action they took or are about to take, not the data they observed.

The four signals are deliberately narrow:

• Category-entry-point salience. Are buyers thinking of your brand at the entry points that drive your category? This signal owns brand and creative decisions.
• Repeat-purchase rate by cohort. Are first-time buyers becoming second-time buyers at the rate the model assumed? This signal owns CRM and retention investment.
• Household penetration trajectory. Is your buyer base growing or churning at the household level? This signal owns acquisition spend and channel mix.
• Retailer share-of-shelf vs share-of-sales. Are you over-distributed and under-velocity, or under-distributed and starving? This signal owns range reviews and trade investment.

Four signals, not seven. Not twelve. The discipline of four forces you to pick the decisions that matter and ignore the ones that do not. The moment you add a fifth signal, the architecture starts to drift back toward dashboard sprawl.

I have deployed The Consumer Signal Architecture across multiple challenger FMCG brands in the $5M-$50M revenue band. The pattern is consistent. Within ninety days of switching from dashboard reporting to signal routing, the brands materially increase the count of category actions taken per quarter. The underlying data infrastructure does not need to change at all.

The PepsiCo case is the canonical industry proof point. Stephan Gans, Chief Consumer and Marketing Insights Officer at PepsiCo, rebuilt the global insights function around a platform called Pepviz. The published before-and-after is the inversion above. The function moved from delivering reports to routing signals. Reimagining insights at PepsiCo documents how the team redesigned itself around democratised access to four core consumer signals, with explicit decision-owners attached to each. The cultural shift mattered more than the technology. Insights staff stopped writing decks and started writing decisions, because the platform routed signals rather than displayed them. The result was a clear redefinition of what the function was for in the first place.

The point is not that you copy PepsiCo. The point is that PepsiCo, with the deepest research budget in CPG, concluded that more dashboards were the wrong answer and that signal routing was the right one. If they could not dashboard their way to growth at $90 billion in revenue, you cannot dashboard your way there at $9 million either.

Phase 1: Name Four Signals, Assign Four Owners (Days 1-30)

The first thirty days are a naming exercise, not a tooling exercise. Do not buy software. Do not commission a new dashboard. The work is structural and political, and the deliverable is a one-page document signed by the founder or general manager.

Start by listing the four most expensive decisions your brand makes in a quarter. For most $1M-$10M FMCG operators in Australia, that list will look something like: media-mix shifts, promotional calendar approval, retailer range-review submissions, and new-SKU greenlights. Each of those decisions can be tied to exactly one of the four signals above. If a decision does not map to a signal, that decision is being made on gut feel and you have just identified a routing gap.

Next, assign one decision-owner per signal. This is the single most uncomfortable conversation in the entire process. The category-entry-point salience signal goes to the brand director. The repeat-purchase signal goes to the CRM lead. Household penetration goes to the head of growth or paid media. Retailer share-of-shelf goes to the national account manager. Each owner now carries a name attached to a number, every week, in front of their peers.

Resist the urge to assign all four signals to the head of insights. That is the failure mode every brand defaults to and it is wrong. The head of insights routes the signals. They do not own the decisions. The decisions belong to the people whose budget will move when the signal moves.

The third move is to identify the data feed for each signal and prove it can be pulled in under fifteen minutes. The Circana Complete Consumer panel is the typical foundation in Australia and the US for household penetration and repeat-purchase tracking, because it stitches together purchase data across retailers and channels at the household level. Most $5M-$10M brands already pay for partial Circana access and use less than 20% of what their subscription covers. The signal exists. It is not being routed.

For category-entry-point salience, the data feed is usually a quarterly category-entry-point survey via Kantar or YouGov. Supplement it with branded search-volume movement from Google Trends and review-sentiment from Amazon and Shopify. For retailer share-of-shelf, the feed is the retailer's own scan data plus your field-rep audit photos. Tooling does not need to change. Routing does.

The Day 1-30 deliverable is a single page, pinned on the wall of the marketing room, that names the four signals, the four owners, and the weekly cadence. If the page is longer than one side of A4, you have already over-engineered it.

Phase 2: Weekly Routing Ritual and the Three-for-One Rule (Month 2-6)

Phase 2 is where most brands fail, because the dashboard sprawl fights back. Every analyst on staff has a favourite workbook they want to keep alive. The discipline is to enforce what I call the three-for-one rule. For every new signal you add to the architecture, you retire three existing dashboards. This is not a cost-cutting exercise. It is a focus exercise. If you cannot retire three dashboards to make room for one signal, you do not believe the signal is the priority.

The weekly routing ritual is a 45-minute meeting with a fixed agenda. Each signal-owner gets eight minutes. They do not present the data. They present the action they took last week and the action they are taking this week, anchored in the signal's movement. If the signal did not move, the owner explains why a non-action is the correct response. The meeting ends with four explicit category actions written down for the week.

The cadence matters. Monthly is too slow because retailer windows close in two-week cycles. Daily is too fast because the underlying signals do not move that quickly. Weekly is the natural rhythm that matches FMCG decision-velocity in Australian retail, where Coles and Woolworths range-review windows operate on roughly four-to-eight-week clocks and trade-marketing slots are claimed week-by-week.

Industry leaders are now building tools that assume this routing model rather than the dashboard model. NielsenIQ's 2026 launch of NIQ Growth Pathways is an explicit decision-routing layer on top of their consumer-panel data, designed to surface the action a brand should take rather than the data the brand can see. The direction of the industry is clear. The dashboard suite is being commoditised. The premium is on the routing.

You will encounter resistance from your own analysts. They will ask why they are no longer building dashboards. The answer is that they are now writing the one-page decision memo that accompanies each signal each week. The job has not shrunk. It has shifted from production to routing. Some analysts adapt. The ones who do not, leave. Either outcome is acceptable. What is not acceptable is keeping the dashboard graveyard alive because nobody has the political will to retire it.

There is a small artefact that holds the ritual together. I call it the signal log. Every week, after the meeting, the head of insights writes one line per signal in a shared document: signal name, current value, week-on-week movement, decision taken, owner. Twelve months in, that log becomes the single most useful artefact in the business, because it is the audit trail of every category decision and the evidence that proves the insights function created value rather than reports.

By the end of Month 6, the test is simple. Count the category actions taken in the most recent quarter that can be traced back to a specific signal in the architecture. If the count exceeds the actions taken in the prior quarter, the architecture is working. If it does not, you have an owner-accountability problem, not a data problem.

The North Star: Category Actions Per Quarter

The new metric is category actions per quarter, and it replaces every vanity metric your insights team currently reports. Dashboards built per quarter. Reports delivered per quarter. Dashboard-tab views per analyst. Retire all of them. The only number that matters is how many category-level decisions your brand made and executed in the last 90 days, traceable to a named signal and a named owner.

A useful frame from Pepviz is what their team calls "signal-to-shelf time." Pepviz consumer shifts describes how PepsiCo measures the elapsed days from a consumer signal being detected to a category action appearing on shelf or in market. Path to Purchase Pepviz shows the same routing model applied at a more granular level. Each shift gets routed to a named category team within 48 hours of detection. Your version will be slower. That is fine. The point is that you are measuring the latency.

For a $5M-$10M Australian FMCG brand, a reasonable starting target is twelve traceable category actions per quarter, three per signal. Most brands I audit at this size are at three to five. The gap is your biggest strategic asset, because it is closeable without buying any new tooling. It is closeable purely by routing what you already collect.

The before-and-after is stark. Before the architecture, your insights team is a reporting service desk that produces dashboards on request and gets cut first when the CFO needs to find 5%. After the architecture, your insights team is the routing engine for every category decision the brand makes, and cutting it would mean cutting the decision-velocity of the entire business. One is a cost line. The other is a growth function.

The Consumer Signal Architecture does not require new software. It does not require a data scientist. It requires the political will to name four signals, name four owners, kill three dashboards for every signal added, and run a weekly routing ritual that ends in written category actions. Every brand I have deployed it with had every piece of data they needed before we started. The only thing missing was the architecture.

If your insights function still owns reports rather than decisions, you already know what next quarter's budget review will look like.