B2B ENGINEERING SOFTWARE DISTRIBUTOR (SEA)
Description
An automated fortnightly impact report that turns a sprawling event tracker into an Outlook-ready email and a live dashboard, so a regional sales team can see what marketing actually delivers.
Client
Year
2026
Role
Type
Marketing

Goal
Prove marketing's impact with a report people actually open.
From scattered spreadsheet rows to a two-minute read: events, qualified leads, and the funnel in between.
Problem Statement
Marketing ran a steady programme of events across Southeast Asia, but the results lived in a wide, quarter-by-quarter spreadsheet that only marketing could read. Leadership saw activity, not impact.
Redesign
Diving into the aesthetic charm of a dark mode seamlessly mixed with an enchanting blue theme imparts an element of refinement to the user interaction. The pronounced contrast of deep backgrounds against striking blue tones not only augments visual attractiveness, but also aids in lessening eye fatigue during prolonged usage. This inventive take on dark mode doesn't just prioritise user comfort, but encapsulates a spirit of technological design.
The Challenge
Make marketing's contribution visible to a busy, non-marketing audience, inside the tool they already live in (Outlook), with no BI platform and no engineering support.


Overcoming the Challenges
The final system is a packaged AI skill that reads the tracker, counts only completed events, and produces two outputs on every run. The first is an Outlook-safe email (table layout, inline styles) with a year-to-date scoreboard, a Registered → Attended → Qualified funnel, a recent-events table and upcoming registrations against target. The second is an interactive dashboard with filters for quarter, country, format and stage, plus impact toggles and sorting. Where the data had gaps, proxy metrics are clearly labelled and switch to real figures automatically once those columns exist.
Takeaways
Distribution beats features: the best dashboard is useless if nobody opens it. Being explicit about what the data can and can't prove built more trust than bigger numbers would have. And packaging the workflow as a reusable AI skill turned a manual reporting chore into a repeatable, consistent output.

Finalising
I tuned the type hierarchy and spacing for a narrow email column so it reads cleanly on mobile, and added quarter and custom date-range options so each issue can be scoped to any reporting period.

Credits
Design, data model and build by Hajaratih Johana.