Steve SutantoProduct Design & Experience Strategy
About Résumé LinkedIn Email
06 / 06
Case study — Consumer goods

Smarter Marketing Investment: Modernizing a Marketing Mix Model

A global consumer goods company decides where its marketing money goes with a marketing mix modeling tool. The data was powerful, but the experience was slow, confusing and hard to use. I audited the workflows, prototyped new features with AI, and tested them with analysts across four markets.

Settled first

Analysts in four markets used the same tool four different ways. Rather than redesign every screen, the work started with the moments that slowed decisions most: editing a scenario cell by cell, reading what an optimization actually changed, and knowing what a metric meant.

4 markets

Tested in US, UK, Brazil, Turkey

Interviews and prototype sessions with analysts in every market the tool serves.

Under a minute

Bulk edits by rule

Cell by cell edits became rules like a set change against last year, spread across brands, channels and weeks.

1 source of truth

Review, build, design in one place

Working prototypes the client reviews, engineers build from and design iterates in.

client Global consumer goods companyNamed under NDA role UX DesignerAI practitioner partners Analysts and business executives · Product · Engineering · Partner consultancy timeframe 4+ months, 2026
scenario / summary
Guided summary view

scenario / summary

scenario / optimization summary
Optimization summary

scenario / optimization summary

The problem

Powerful data, buried under an experience people had learned to work around.

The tool helps a global marketing organization decide where to spend: which channels, which brands, which weeks. Analysts trusted the model. They did not trust the screens around it.

Edits were made one cell at a time across tables of hundreds of rows. Optimization results arrived as numbers with no story about what had moved or why. Metric names meant different things to different teams, and each of four markets had built its own workarounds.

Approach
  1. Audit the frictionReviewed the core workflows with analysts and SMEs, and turned what slowed them down into a prioritized list of UI improvements.
  2. Prototype with AIBuilt new features as working prototypes rather than mockups, so stakeholders could use an idea instead of imagining it.
  3. Test in four marketsRan stakeholder interviews and prototype sessions across the US, UK, Brazil and Turkey, and validated changes with SMEs before release.
  4. Keep one source of truthSet up a single space where the client reviews, engineers build and design iterates, with every requirement pinned to the work it describes.
Outcome

Rule based bulk editing replaced cell by cell changes, turning the biggest blocker to scenario planning into a task of under a minute. Optimization results now explain themselves: what moved, where the budget went and how return changed. In product help and term definitions clarify metrics where they appear, and the shared prototype space shortened the loop from idea to approved build. The longer term work explores agentic AI to tailor the experience to analysts and executives.

Guided walkthrough Open full screen ↗

The rethought planning flow, live: state an intent, set guardrails, optimize now or later, then read the result. Pick a step, or press Simulate to watch it play through. Data is illustrative.

The work 11 screens · open at full size

Tap any screen to open it at full size.

Quick edit, by rule4 steps · open at full size
01
Start from the table

Start from the table. A scenario in edit mode: weeks across, packs down, the editable range clear.

Start from the table
02
Open the assistant

Open the assistant. Bulk Edit opens beside the table, so the numbers stay in view.

Open the assistant
03
Write the rule

Write the rule. Adjust, this driver, these brands and customers, by 5%. The cell count shows before anything changes.

Write the rule
04
See what changed

See what changed. Applied to 99 cells at once, each showing its old value, with undo one click away.

See what changed
Optimization summary

Optimization that explains itself. Uplift, spend change and volume up front, then where the budget moved and how return changed by channel.

Optimization that explains itself.
Guided summary view

Reading guidance in place. A how to read this view banner and a notable callout sit with the numbers they explain.

Reading guidance in place.
One click comparison

One click comparison. Compare contribution and return by brand, pack or customer without rebuilding the chart.

One click comparison.
Saturation curves

Diminishing returns, made visible. The point where extra spend stops paying back, marked on the curve with a plain reading note.

Diminishing returns, made visible.
Driver comparison

Driver comparison. Pick drivers at any level and choose whether they combine or stand alone in the chart.

Driver comparison.
Allocation impact details

Allocation detail. Investment, impressions and volume per pound, grouped so totals read first and detail opens on demand.

Allocation detail.
Waterfall export

Export from where you are. Download the chart as an image or the data behind it, straight from the view.

Export from where you are.

Let's talk about the work.

Tell me what you're building and where it's stuck.I read everything and reply within a couple of days, even when it isn't a fit.

Steve SutantoKansas City, MO · U.S. remotestevesutanto@gmail.com
Email me→ Substack Résumé
© 2026 Steve Sutanto
Work About Substack LinkedIn Email
Kansas City, MO · U.S. remote
{{ lbTitle }}
Close ✕
←
{{ lbImg }}{{ lbEndCard }}
→

{{ lbCaption }}

{{ lbCounter }}
←
{{ lbCounter }}
→
−
{{ lbZoomLabel }}
+
Fit
{{ lbFsLabel }}
Walkthrough video
Close ✕
←
{{ vbVideo }}
→

{{ vbCaption }}

{{ vbCounter }}