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

B2B ENGINEERING SOFTWARE DISTRIBUTOR (SEA)

B2B ENGINEERING SOFTWARE DISTRIBUTOR (SEA)

Year

2026

Role

Marketing Designer (Design, Data & Build)

Marketing Designer (Design, Data & Build)

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.

Contact

Ready to bring your vision to life or just want to chat? Reach out, and let's create something memorable together.

I'm here to listen, collaborate, and craft design solutions that resonate.

hajaratih98@gmail.com

message me

Contact

Ready to bring your vision to life or just want to chat? Reach out, and let's create something memorable together.

I'm here to listen, collaborate, and craft design solutions that resonate.

hajaratih98@gmail.com

message me

Create a free website with Framer, the website builder loved by startups, designers and agencies.