borderflow.com

Live EES queue intelligence from Brits already in line — like Waze for EU borders

Score: 8.0/10UKHard BuildReady to Spawn
Brand Colors

The Opportunity

Problem

British travelers must arrive at EU airports 3 hours early due to massive queues from the new biometric Entry-Exit System replacing passport stamps.

Solution

BorderFlow lets British travelers anonymously broadcast their real-time position in EES queues at EU airports. The app aggregates this data to show live wait times, flow rate, and estimated completion time for everyone. Users waiting can also earn credits by sharing updates, creating a self-sustaining information network.

Target Audience

British travelers returning home from EU airports

Differentiator

Pure crowdsourced, real-time data layer built exclusively by and for British travelers — the only system that shows not just how long the queue is, but how fast it's actually moving at this exact moment.

Brand Voice

practical

Features

Live Queue Map

must-have40h

Real-time visualization of current EES queues at major EU airports

Anonymous Check-In

must-have30h

Users tap 'I'm in queue' with estimated people ahead of them

Flow Rate Calculator

must-have35h

Shows how many people per minute are being processed

Arrival Time Estimator

must-have25h

Predicts exactly when you will reach the biometric gate

Credit System for Reporting

must-have30h

Earn premium access by submitting verified updates

Historical Heatmaps

nice-to-have25h

See typical wait patterns by day of week and time

Terminal-Specific Views

nice-to-have20h

Filter by specific terminal or biometric gate area

Alert Subscriptions

nice-to-have30h

Get notified when your chosen airport queue drops below threshold

Total Build Time: 235 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
creditsintNo
created_attimestampNo

Relationships:

  • reports references user_id

live_reports

ColumnTypeNullable
iduuidNo
user_iduuidYes
airport_codetextNo
terminaltextNo
people_aheadintYes
statustextNo
reported_attimestampNo
expires_attimestampNo

Relationships:

  • user_id references users(id)

queue_sessions

ColumnTypeNullable
iduuidNo
airport_codetextNo
start_timetimestampNo
end_timetimestampYes
total_traveled_minutesintYes

API Endpoints

GET
/api/live/status

Get current aggregated queue status for all airports

POST
/api/report

Submit new queue position report

🔒 Auth Required
POST
/api/alerts/subscribe

Create notification when queue drops below threshold

🔒 Auth Required

Tech Stack

Frontend
Remix.run + Tailwind
Backend
Remix loaders/actions
Database
PostgreSQL
Auth
Clerk
Payments
Stripe
Hosting
Fly.io
Additional Tools
Socket.io for realtimeUpstash Redis for live data

Build Timeline

Week 1: Realtime infrastructure and auth

50h
  • Remix setup with Socket.io
  • Clerk auth
  • Basic reporting UI

Week 2: Live aggregation engine

55h
  • Queue calculation logic
  • Geofence validation
  • Credit system

Week 3: Alerts, maps and payments

45h
  • Live map UI
  • Alert system with WebSockets
  • Stripe subscriptions

Week 4: Testing with real travelers and launch

35h
  • Beta at 3 major airports
  • Landing page optimization
  • Documentation
Total Timeline: 4 weeks • 295 hours

Pricing Tiers

Observer

$0/mo

5 views per day

  • View basic queue status
  • Limited alerts

Navigator

$19/mo

None

  • Unlimited live views
  • Flow rate data
  • Personalized alerts
  • Credit earning

Pilot

$44/mo

None

  • All Navigator features
  • API access for personal use
  • Priority data refresh
  • Family accounts

Revenue Projections

MonthUsersConversionMRRARR
Month 11,1007%$1,463$17,556
Month 68,50013%$20,969$251,628

Unit Economics

$14
CAC
$265
LTV
6%
Churn
85%
Margin
LTV:CAC Ratio: 18.9xExcellent!

Landing Page Copy

Real Brits. Real Queues. Right Now.

See exactly how fast the EES line is moving before you leave your hotel. Powered by British travelers already in the queue.

Feature Highlights

Truly live data from inside the queue
Flow rate tells you if it's getting better or worse
Earn credits by reporting
Built by Brits for Brits

Social Proof (Placeholders)

"'Saved me from joining a 2.5 hour queue at CDG' — Oliver R., London"
"'The flow rate feature is genius' — Emma S."

First Three Customers

Seed initial data by paying 30 UK students and digital nomads already living in Spain, Portugal and France €30 each to report for first two weeks. Launch on r/digitalnomad and r/UKPersonalFinance travel threads. Partner with British airline staff unions for early adopters.

Launch Channels

ProductHuntr/digitalnomadr/UKtravelIndieHackersTwitter travel accounts

SEO Keywords

live eu border queueees queue length right nowcurrent wait time eu airport ukreal time ees queuebritish travelers eu border updates

Competitive Analysis

Madrid Barajas Airport App

various airport apps
Free
Strength

Official data for their own airport

Weakness

Only one airport, rarely updated, not EES specific

Our Advantage

Multi-airport, crowdsourced, real-time from actual travelers in the queue

🏰 Moat Strategy

Network effects — the more British travelers use it, the more accurate and valuable the live data becomes, creating a strong flywheel.

⏰ Why Now?

The shift from passive stamping to active biometric processing creates highly variable wait times that change minute-by-minute. Only real-time crowdsourced data can give travelers the information they need.

Risks & Mitigation

markethigh severity

Low initial reporter density makes data unreliable

Mitigation

Incentivize first 1,000 reporters heavily and focus launch on highest traffic routes (Spain, France, Netherlands)

legalmedium severity

Airports object to geofencing or data collection

Mitigation

Keep all reporting fully anonymous and avoid any official integration

Validation Roadmap

pre-build10 days

Validate demand with fake door test (landing page with 'See Live Data' button)

Success: 25% click-through rate and 400 email signups in 10 days

mvp25 days

Deploy at Madrid, Amsterdam, and Paris CDG with seeded reporters

Success: Minimum 40 concurrent users during peak hours and 4.5+ rating

Pivot Options

  • Expand to non-EU borders (US ESTA, etc.)
  • Offer B2B data to travel insurers for dynamic delay predictions
  • Create 'Beat the Queue' route optimization for connecting flights

Quick Stats

Build Time
295h
Target MRR (6 mo)
$21,000
Market Size
$38.0M
Features
8
Database Tables
3
API Endpoints
3