Marketing Command & Ad Intelligence Port 3000 • Postgres 5434

Unified Marketing HUB & Real-Time Ad Intelligence

Centralize your social advertising operations across Meta Ads, TikTok Shop, and Line LAP. Powered by autonomous Mirofish multi-agent persona testing and real-time Supabase PostgreSQL synchronization, the Marketing HUB monitors budget pacing, simulates buyer friction, and ties ad spend directly to verified bank slip revenue.

Supabase Replication: <120ms Latency
Social Stream: 651 Conversations
Vendure Catalog: 103 SKUs Synced
Marketing HUB Cockpit Live
Active Campaigns 6 AI Opt
14
100% Synced across Meta & TikTok
Attributed Sales (GMV) +24.6%
฿3,490,500
Verified bank slips: 94 orders
Blended ROAS High Margins
4.62x
Meta 4.8x • Line 5.4x • TikTok 4.2x
AI Simulation Win Rate Mirofish
78.4%
Simulated on 120 personas
Live Channel Allocation & Return Real-time Pacing
Meta Ads (Reels & Feed) ฿1,570,000 (45%) • 4.8x ROAS
Line LAP & Rich Broadcasts ฿872,500 (25%) • 5.4x ROAS
TikTok Shop Campaigns ฿698,100 (20%) • 4.2x ROAS
Click-to-Messenger Conversational ฿349,050 (10%) • 4.9x ROAS
PostgreSQL schema: public.ad_campaigns Open in Portal
Architecture & Real-Time Data Pipeline

How Marketing HUB Unifies APIs, Databases & AI Simulation

The Super Sales Marketing HUB isn't a mock dashboard. It connects directly to live database tables, multi-agent AI execution runtimes, and headless commerce APIs across a low-latency microservices cluster.

Supabase Real-Time DB

Direct connection via createClient() to PostgreSQL on port 5434. Uses WebSocket replication on ad_campaigns with instant sync latency under 120ms.

Table: public.ad_campaigns

Mirofish Multi-Agent AI

Simulates synthetic localized consumer personas across Yangon, Mandalay, and rural townships. Evaluates objection friction, delivery hesitation, and price resistance before spending ad budget.

Runtime: Port 5001 / 7000

Vendure E-Commerce Core

Links campaign impressions to live warehouse inventory (103 SKUs), delivery zone shipping fees, and completed order transitions via /admin-api.

GraphQL: /admin-api

Omnichannel Stream Sync

Live ingestion of 651 conversation threads across Line, Facebook, and WhatsApp. Correlates customer questions directly to campaign IDs for precise conversation-level ROAS attribution.

Inbound: 651 Threads
PostgreSQL Live Data Grid

Active Marketing Campaigns & Channel Performance

Fully interactive enterprise data table querying live records from public.ad_campaigns. Click column headers to sort, filter by platform/status, or expand any campaign to inspect lead-to-won conversion funnels.

Platform:
Status:
Campaign & SKU ↕
Platform ↕
Daily Budget ↕
Spend ↕
Won / Lost ↕
Win Rate ↕
ROAS ↕
Status ↕
Inspect
Showing 6 of 6 campaigns • 100% Realtime Subscribed
Total Budget: ฿142,000
Total Spent: ฿55,200
Attributed GMV: ฿3,490,500
Weighted ROAS: 4.62x