NightShiftBW

Schedule video uploads for Botswana's cheapest night data bundles

Score: 7.7/10BWMedium BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Exorbitant mobile data prices in Botswana prevent creators from uploading high-quality videos and live streaming, directly stifling their channel growth.

Solution

PWA compresses videos client-side, stores in local IndexedDB queue, and notifies via push when off-peak (e.g., MTC 12am-5am). User approves auto-upload direct to YouTube, saving 50-80% on data. Dashboard tracks queue and historical costs.

Target Audience

YouTubers and TikTokers in Botswana's creator economy

Differentiator

Real-time off-peak detection using user data plans + geo-specific bundle schedules

Brand Voice

friendly

Features

Local Queue Manager

must-have18h

Compress & queue videos in browser storage

Off-Peak Scheduler

must-have20h

Push notifications for cheap data windows per provider

Data Plan Input

must-have12h

User configures bundles/prices for auto-calc

Auto YT Upload

must-have22h

One-tap upload from queue via access token

Queue Dashboard

must-have15h

View/edit scheduled uploads remotely

Multi-provider Alerts

nice-to-have10h

Switch SIM suggestions

Upload Analytics

nice-to-have12h

Cost per video reports

Shared Schedules

nice-to-have8h

Community bundle calendars

Total Build Time: 117 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
data_planjsonbYes
created_attimestampNo

Relationships:

  • one-to-many with schedules

schedules

ColumnTypeNullable
iduuidNo
user_iduuidNo
video_nametextNo
scheduled_timetimestampNo
statustextNo
data_costintYes

Relationships:

  • foreign key to users.id

subscriptions

ColumnTypeNullable
iduuidNo
user_iduuidNo
stripe_idtextNo
tiertextNo

Relationships:

  • foreign key to users.id

API Endpoints

POST
/api/schedules

Sync queue to server

🔒 Auth Required
POST
/api/notifications

Trigger push for off-peak

🔒 Auth Required
GET
/api/plans

Fetch bundle schedules

POST
/api/youtube/initiate

Start resumable upload

🔒 Auth Required
GET
/api/dashboard

Get user schedules

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + ffmpeg.wasm + idb-keyval
Backend
Next.js API + Supabase Edge
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
Web Push APIYouTube APIPWA

Build Timeline

Week 1: Auth, DB, PWA base

22h
  • Auth
  • Local storage queue
  • DB sync

Week 2: Compression + queue UI

25h
  • ffmpeg integration
  • Queue management

Week 3: Scheduler logic

20h
  • Plan input
  • Off-peak detection

Week 4: Push notifications + YT

25h
  • Push setup
  • Upload flow

Week 5: Dashboard + payments

18h
  • Remote dashboard
  • Stripe

Week 6: Testing + polish

15h
  • Mobile tests
  • Analytics

Week 7: Beta features

10h
  • Nice-to-haves
Total Timeline: 7 weeks • 155 hours

Pricing Tiers

Free

$0/mo

Manual notifications only

  • 3 queued uploads/month
  • Basic scheduling

Pro

$40/mo

50 videos/month

  • Unlimited queues
  • Push alerts
  • YT auto-upload
  • Dashboard

Enterprise

$99/mo

None

  • All Pro
  • Custom bundles
  • Team queues
  • API

Revenue Projections

MonthUsersConversionMRRARR
Month 11204%$192$2,304
Month 67007%$1,960$23,520

Unit Economics

$9
CAC
$360
LTV
6%
Churn
90%
Margin
LTV:CAC Ratio: 40.0xExcellent!

Landing Page Copy

Upload Videos at Night for 80% Data Savings

Auto-schedule compressions for Botswana night bundles – never waste data again.

Feature Highlights

Local storage queues
Provider push alerts
Projected cost savings
Pro: Unlimited $40/mo

Social Proof (Placeholders)

"My uploads now cost half! - BW Vlogger"
"Perfect for Mascom night data - TikTok star"

First Three Customers

Target night-data users in 'Botswana Tech Tips' WhatsApp groups with beta invites; email 20 local YT creators offering custom plan setup; post demo video on Botswana TikTok trends.

Launch Channels

Product Huntr/indiehackersTwitter #BotswanaCreativesAfrican Startup TwitterLocal FB groups

SEO Keywords

night data upload scheduler BotswanaMTC off-peak YouTube uploadschedule video upload cheap dataOrange bundle optimizer

Competitive Analysis

$6/mo
Strength

Social scheduling

Weakness

No data awareness or compression

Our Advantage

Data-cost focused + client-side

$18/mo
Strength

Visual planner

Weakness

Server uploads, ignores mobile data

Our Advantage

Botswana bundles + savings

🏰 Moat Strategy

User-submitted bundle data creates network effects for accurate schedules

⏰ Why Now?

Telcos like Mascom launched new night bundles 2024, creator growth +30% YoY

Risks & Mitigation

technicalmedium severity

Push notifications unreliable on mobile

Mitigation

Fallback to dashboard checks + email

marketlow severity

Users forget to approve uploads

Mitigation

Nudge reminders + auto on Pro

legallow severity

Provider schedule changes

Mitigation

User-updatable plans

Validation Roadmap

pre-build5 days

Interview 30 creators on data habits

Success: 70% use night bundles

mvp21 days

Beta with 50 users

Success: 30% retention week 2

growth60 days

Affiliate program for creators

Success: $1k MRR

Pivot Options

  • General social scheduler
  • WiFi upload reminder
  • Africa-wide bundles

Quick Stats

Build Time
155h
Target MRR (6 mo)
$2,500
Market Size
$1.5M
Features
8
Database Tables
3
API Endpoints
5