Luke Woods
next→

Pattern · Product Design Internship

Custom Reports in Predict

Redesigning the reporting tool everyone tried once — so brand managers could build, edit, and share multi-metric client reports without falling back to Excel.

Role
Product Design Intern
Timeline
Jan – Oct 2025 · 9-week project
Team
Julie Broadbent (Design Manager) +1
Impact
0+50+discovery interviews surfaced the problem
020daily users validated the redesign in live testing
05metrics on one chart — the old cap was two
09weeks from a one-line ticket to full handoff

Validated through usability testing and shipped by the team after my internship — the post-launch numbers belong to them, so this study claims only what testing showed.

beforeafter

Drag across the frame: the old text list on the left, the redesigned home — templates plus a tile grid that shows each report before you open it — on the right.

Pattern’s Predict platform tracks billions of ecommerce data points, and its Custom Reports tool was built to end the export-to-Excel reporting grind. A year in, almost nobody used it — not because nobody wanted it, but because the experience failed the people who tried. I found the problem through discovery interviews, made the case to rebuild it, redesigned the core report-building experience in nine weeks, and validated the redesign with twenty of the people who’d abandoned the original. The team built and shipped it after my internship ended.

The origin

My first project was a one-line ticket.

When I joined the Predict team, I was handed a small ClickUp ticket: let users duplicate a widget so they don’t rebuild the same configuration over and over. Estimate: one to two days.

Working the flow, I realized duplication treated a symptom. People cloned widgets because building and editing reports was slow, confusing, and inflexible. Instead of stopping at the ticket, I started pulling on the thread behind it.

The ticket that became the redesign. T-shirt size: X Small, one to two days.
The evidence

Everyone tried it. Nobody stayed.

Our team was reading Continuous Discovery Habits in book club, and I was running weekly discovery interviews with Predict users. Reporting workarounds kept surfacing in otherwise unrelated conversations — over 50 interviews across the internship, plus a focused session with four UK brand managers who had tried the original tool and walked away.

Pendo told the other half of the story. Roughly 60% of eligible users had created at least one Custom Report in the feature’s first year — strong demand. Only about 15% ever came back, against enterprise retention benchmarks around 28–35%. This wasn’t a discovery problem or a demand problem. It was a usability problem.

  • Charts capped at two metrics — comparing ad spend against sales lift in one view was impossible
  • Filters were locked at creation, and their effect on what you could build was opaque — so editing often meant rebuilding
  • Separate view and edit modes hid basic actions like add, duplicate, and rearrange
  • Assembling one client-ready report took 30–60 minutes across Predict, Excel, and slides — and still looked unpolished
Where the old tool lived: a sub-tab behind System Reports — a tab most users never touched — and every report a line of text with no preview.
The old report in preview mode: charts visible, editing controls hidden, an Exit Report button in the corner
The same old report in edit mode: Add Widget bars and Edit buttons appear, with a Done button in the corner

Preview mode: where you present — but touch nothing. Editing hides behind a separate mode.

The audit board — every screen of the old flow, annotated with what users said about it.
The users

Two jobs, one broken tool.

Custom Reports had to serve two internal roles with different jobs and the same workaround. I built a persona for each from the interviews:

Ad Strategist

Will

Oversees ad spend across multiple client accounts

  • —One KPI per chart made comparing ad spend against sales lift impossible
  • —Exported Predict data to Excel and blended it with ad data by hand
  • —Found reports so rigid he avoided using them at all

Goal: Connect ad performance with sales data in one report — and trust Predict as the one-stop tool.

Brand Manager

Trista

Manages six mid-size consumer brands, client-facing every week

  • —Stitched one-metric dashboards together to tell one story
  • —Spent 30–60 minutes per brand assembling each report
  • —Screenshots and raw Excel exports looked unprofessional in client meetings

Goal: Build a polished, multi-metric report fast enough to make it part of the weekly routine.

Personas built from the research; names are fictional.

The ticket is not the problem definition.

I synthesized the interview patterns and the Pendo data and brought the opportunity to the Predict product and design team. Once we agreed it was worth pursuing, I scoped a nine-week redesign with my design manager and our Director of Product, focused on the core loop: creating reports, configuring widgets and filters, and editing content. A duplicate-widget ticket had become a rebuild of the whole report-building experience.

Constraints

No new data. No new components. Not much engineering.

Three hard limits shaped every decision. I couldn’t introduce new data sources — missing forecast, wholesale, and logistics metrics were platform gaps I could only document and escalate. I was bound to Predict’s existing design system and component library. And engineering had capacity for a slice of the redesign, not all of it — so the scope became the smallest set of high-impact changes that could realistically ship.

The sharpest cut was the drag-and-drop builder. A canvas where you drag metrics, layer dimensions, and build pivot-style reports matched advanced users’ mental models — and exceeded the engineering budget. I presented the user evidence and the trade-offs, leadership made the call, and my job became preserving the value — flexible report construction — inside a structured flow that could actually ship. Drag-and-drop went to the roadmap; so did per-brand report theming, which brands kept asking for.

The mock that didn’t ship: a Slides-style builder with a draggable thumbnail rail. Right mental model, wrong engineering budget — it lives on the roadmap.
The redesign

Guide the cold start. Get out of the way after.

With poor retention, most returning users were effectively beginners every time they opened the tool — so the redesign attacks the cold start first. The home screen leads with templates and a tile grid that previews every report. A large New Report button opens a guided modal flow that gathers just enough — name, scope, first widget — to land you in a working report, and a first-run wizard explains the toggles, settings, and timeframes that used to be opaque.

Step one explains the choice that used to be invisible: one filter set for the whole report, or unique filters per widget.
The scenario step: timeframes, aggregation, and comparisons picked with context instead of guessed at.

Inside a report, the view/edit split is gone — one mode serves both presenting and editing, with actions in context. Filters became clearer and editable after creation instead of locked in. And widgets finally reorder: a Widget Order list in the report settings with drag handles — the feasible version of reordering, shipped while the full canvas drag-and-drop waited on the roadmap.

Reordering that could ship: drag the list, not the canvas. The whole report reorders from one panel.

Charts broke the two-metric cap: multi-metric comparison, the single most requested capability, became the core of the in-report experience. Reports gained share and export, plus scheduled email sending, so the weekly client report could leave Predict without a screenshot. And because so much sharing happens asynchronously, a widget can now carry a note — the context a manager would otherwise write in the email next to a pasted screenshot travels with the chart itself.

The redesigned widget: five metrics on one chart with color customization — the old tool allowed two.
Widget notes — one of the most requested features from testing: the “why” behind a chart rides along when it’s exported or emailed to a brand.
Testing

Twenty users killed my favorite assumption.

The people this tool was for sat in the same office, so I tested with them directly: twenty live usability sessions — ten brand managers, ten ad strategists — on the redesigned flows.

I assumed people wanted a clean separation between viewing a report and editing it. Watching them work killed that: managers present reports live and edit the graphs on the fly, with the client in the room. A separate edit mode was friction in the exact moment the tool had to shine. The shipped design uses one combined mode.

Filters were the other reversal. In the old tool, the filters you chose at creation were permanent, and they silently constrained which metrics and charts you could build — users never understood why things wouldn’t work. The redesign makes filter setup informed up front, and filters editable after the report exists.

The templates

I didn’t design the templates. I ran a contest for them.

The Templates feature needed starting points that reflected real reporting work, not a designer’s guess at it. So I ran a report-building competition across the brand managers and ad strategists — prizes included — to see who could build the best reports in the new system. The winning reports became the shipped templates, and the contest doubled as another round of honest feedback from the tool’s toughest audience.

Outcome

Validated in testing. Shipped after I left.

My internship ended before the rebuild reached production, so I’m careful about what I claim. The redesign was validated through usability testing and shipped by the team after my internship — the post-launch numbers belong to them.

  • Twenty daily users built multi-metric reports quickly and confidently in testing, against a 30–60 minute manual baseline
  • The two-metric chart cap is gone; one combined mode replaced the view/edit split; filters are editable after creation
  • Templates seeded from contest-winning reports built by the tool’s actual users
  • Full handoff: annotated specs, the prototype, documentation, a backlog, and a follow-up testing plan for the next team
Reflection

More features would have made it worse.

My first instinct was wrong. Every user I interviewed had a different power request, each vital to their own workflow, and early on I believed building all of it would make the perfect tool. It would have made a slow, overbearing one — and an unbuildable one. The discipline of the project was separating the biggest lifts that helped every user from the requests that helped one, and protecting a simple core experience, because complexity was the original product’s actual failure.

This project also rewired what I think my job is. I don’t wait for a defined problem anymore — I watch for friction, ask why it exists, and turn it into something worth investigating. The ticket is the symptom; the workflow around it is the problem. And a design that ships beats a design that impresses: pressure-test what users actually need to decide before polishing the interface they decide it on.

With more time, I’d have built custom brand themes for reports — brands loved seeing their own colors in client decks, and it was cut purely for roadmap capacity.

← Reducing Authentication FrictionHoth Landing Page →
⌂·work·emailcopied·linkedin·résumé