Skip to main content
Back to cases
MarketingWindows app

KOL Collaboration Tracker

One row per creator across "outreach → sample sent → shoot → published → retro" with auto overdue flags.

The problem

Thirty creators in parallel — some haven't got samples, some shot but not posted. Memory fails.

The solution approach

A local sheet: one row per creator, five status dots, dates per step, red on overdue.

What you will end up with

  • Creator list: handle, platform, followers, fee, current step, owner.
  • Five-dot status bar inline.
  • Step stuck > N days = red and shown in top "Nudge" card.
  • Export monthly collab Excel for the boss.

Ready-to-use prompt

You are a senior engineer building local desktop tools. The user is a KOL collab lead, non-developer.

[Goal]
Make every creator collab's progress auditable; stop the "I thought it was posted" trap.

[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; local SQLite

[Core Features]
1. Creator list: handle, platform, followers, fee, owner, current step, last update, notes.
2. Five-dot bar: outreach / sample sent / sample received / published / retro; clicks set date.
3. Overdue rules editable per step (default 3 / 5 / 7 / 7 / 7 days).
4. Top "Nudge" card groups all red items.
5. Detail drawer: notes, links to published content, metric snapshots (likes / comments / sales) for retros.
6. Excel import; monthly export.

[Visual Style]
- Light background, white cards, radius 16, generous whitespace.
- Primary button muted dark; secondary light gray.
- Follows system dark mode; system fonts.

[Robustness]
- All data stays on the local machine. Offline.
- Autosave; 7-day rolling backups.
- Friendly messages on bad input, never raw stack traces.

[Delivery]
1. Outline project structure + plain-text wireframe first; wait for confirmation.
2. Deliver in modules; run each one for me to see.
3. Package a Windows .exe and macOS .dmg, ship a 500-word plain-language user guide, list known limits.

Start with structure and wireframe.

After copying

1

Open Codex Desktop and create a new project

2

Paste the prompt and send

3

Wait for Codex to finish; tweak company names, column names, button text as needed

More cases from this department