MogAlerts

Real-time Mogadishu port delay alerts from community reports and official feeds.

Score: 7.5/10SOEasy BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Somalian businesses face weeks-long import delays at Mogadishu port due to outdated cranes and insufficient berths, driving up costs for perishable goods.

Solution

MogAlerts aggregates crowdsourced reports from port workers/importers with public data for live delay updates. Users get instant SMS/email alerts when their shipment risks delay, enabling quick decisions like rerouting. Focuses on actionable intel to protect perishable cargo during congestion.

Target Audience

Import-dependent businesses in Somalia, especially those dealing with perishable goods via Mogadishu port

Differentiator

Crowdsourced + official Somali port data for sub-day accuracy, community-driven unlike static APIs.

Brand Voice

friendly

Features

Live Delay Feed

must-have12h

Real-time port status from reports.

Personalized Alerts

must-have10h

SMS/Email for your shipments on delay thresholds.

Report Submission

must-have8h

Users submit berth/crane updates anonymously.

Shipment Monitoring

must-have9h

Add ships/containers for tracking.

Risk Score

must-have7h

Perishable risk based on current delays.

Community Chat

nice-to-have6h

Discuss delays in channels.

Historical Alerts

nice-to-have5h

Review past notifications.

API Feed

nice-to-have5h

Webhook for integrations.

Total Build Time: 62 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
phonetextYes
roletextNo

Relationships:

  • one-to-many with shipments, reports

shipments

ColumnTypeNullable
iduuidNo
user_iduuidNo
container_idtextNo
expected_etatimestampNo

Relationships:

  • foreign key to users.id

reports

ColumnTypeNullable
iduuidNo
user_iduuidYes
delay_statustextNo
reported_attimestampNo
verifiedboolNo

Relationships:

  • foreign key to users.id (nullable)

API Endpoints

POST
/api/reports

Submit delay report

🔒 Auth Required
GET
/api/feed

Live delay feed

POST
/api/shipments

Add shipment

🔒 Auth Required
POST
/api/alerts

Trigger user alerts

🔒 Auth Required
GET
/api/user-alerts

User alert history

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + Shadcn/ui + Pusher
Backend
Supabase Edge Functions
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
Twilio SMSPusher realtime

Build Timeline

Week 1: Realtime core

40h
  • DB
  • Report API
  • Live feed

Week 2: Shipments + alerts

35h
  • Tracking
  • SMS/Email

Week 3: UI + reports

30h
  • Submit form
  • Risk scores
  • Dashboard

Week 4: Pay + polish

25h
  • Subscriptions
  • Landing
  • Tests
Total Timeline: 4 weeks • 130 hours

Pricing Tiers

Free

$0/mo

1 shipment, no alerts

  • Basic feed
  • Report submit

Pro

$30/mo

10 alerts/mo

  • Alerts
  • Unlimited shipments

Enterprise

$99/mo

Unlimited

  • All + API, priority verify

Revenue Projections

MonthUsersConversionMRRARR
Month 11202.5%$90$1,080
Month 64507%$945$11,340

Unit Economics

$35
CAC
$360
LTV
4%
Churn
88%
Margin
LTV:CAC Ratio: 10.3xExcellent!

Landing Page Copy

Get Mogadishu Alerts Before Your Goods Spoil

Community-powered real-time port intel straight to your phone.

Feature Highlights

Instant SMS alerts
Crowd-verified reports
Perishable risk scores
Free to report

Social Proof (Placeholders)

"Alert saved my fish shipment - PortFresh"
"Real-time gold - ImporterX"

First Three Customers

Post in Somali port worker Facebook groups and importer forums; incentivize first reporters with free Pro; leverage local networks for virality.

Launch Channels

ProductHuntr/logisticsTwitter #MogadishuPortHackerNews

SEO Keywords

Mogadishu port alertsSomalia port delay SMSreal-time Mogadishu port trackerperishable import alerts

Competitive Analysis

MarineTraffic

marinetraffic.com
Free/premium
Strength

Ship tracking

Weakness

No delay alerts or local intel

Our Advantage

Actionable port-specific alerts

🏰 Moat Strategy

Network effects from report volume; verified contributors.

⏰ Why Now?

2024 port strikes increased need for community intel; high SMS penetration in Somalia.

Risks & Mitigation

legallow severity

Data accuracy liability

Mitigation

Disclaimers + verification

marketmedium severity

Report sparsity early

Mitigation

Seed with partners

technicallow severity

Realtime scaling

Mitigation

Supabase realtime

Validation Roadmap

pre-build7 days

Launch Telegram bot prototype

Success: 50 reports

mvp14 days

Closed beta

Success: Daily active 20%

launch7 days

Viral referral

Success: 200 users

Pivot Options

  • Other ports
  • General supply chain alerts
  • Port worker app

Quick Stats

Build Time
130h
Target MRR (6 mo)
$900
Market Size
$0.4M
Features
8
Database Tables
3
API Endpoints
5