MarketingWindows app
Daily Campaign ROI Dashboard
Paste daily spend and conversions. The tool computes ROI and weekly trends per channel. No more waiting on data engineers.
The problem
Marketers track channel ROI, spend share, and cost trends daily. Data lives in separate consoles, consolidation takes hours, and data teams are always booked.
The solution approach
A small tool. Paste daily "spend / impressions / orders / revenue" per channel into a standard Excel. The tool computes ROI, CPA, weekly trend, and generates a daily report card.
What you will end up with
- Top cards: today's total spend / revenue / ROI in big numbers.
- Per-channel detail table below: spend, orders, ROI, delta vs yesterday.
- Bulk import from Excel, auto-aggregated by date.
- One-click "weekly report" as PDF or image, ready to drop into chat.
- Runs locally; nothing leaves your PC.
Ready-to-use prompt
You are a senior engineer experienced with Windows desktop apps. Build a local Windows tool for a marketing team at an e-commerce company. User is a non-developer.
[Goal]
Enter daily channel campaign data (spend, orders, revenue) once, auto-compute ROI / CPA / trends, and generate a weekly report that can be shared.
[Platform & Stack]
- Windows 10/11 desktop app
- Electron + React + TypeScript
- Local SQLite for history
- SheetJS for Excel; pdf-lib for PDF export
- Fully offline; ship a Windows .exe installer
[Core Features]
1. Home: three big cards — today's total spend / revenue / ROI — with deltas vs yesterday.
2. Per-channel detail table: channel, spend, impressions, clicks, orders, revenue, ROI, CPA, delta vs yesterday (% up/down).
3. Data entry:
- Quick form for a single day's entry per channel.
- Bulk Excel import with template: Date / Channel / Spend / Impressions / Clicks / Orders / Revenue.
4. Weekly report: pick a week, generate a PDF or PNG with:
- Weekly total ROI / spend / revenue
- Horizontal bars for channel distribution
- Daily ROI line chart
- Top 3 / bottom 3 channels (Codex-generated captions, neutral tone)
5. SQLite; filter by date and channel.
[Visual Style]
- Clean business look: white background, large numerals, block cards.
- Strong typographic hierarchy: title / subtitle / numerals in three clear tiers.
- Minimal charts — thin strokes, muted colors.
- Segoe UI / Microsoft YaHei from the system.
[Robustness]
- Empty states everywhere.
- PDF failure falls back to PNG with a friendly message.
- Don't white-screen on missing fields; show "no data".
[Delivery]
1. Structure + wireframes for home, entry, report.
2. Phase 1: home + entry. Phase 2: Excel import. Phase 3: weekly report export.
3. Package .exe; write a 500-word user guide.
Start with structure and wireframes.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