Digital Passport Project Retrospective

MAPLE GROVE

RESTAURANT WEEK 2025

░

EXECUTIVE SUMMARY

The Maple Grove Restaurant Week 2025 Digital Passport reimagined civic engagement through technology. In just four months, our team delivered a gamified digital platform that turned a local dining event into a citywide, data-driven experience.

6,000+

Participants

1.2M

Platform Requests

1,055

Verified Sign-ups

99.99%

Uptime

My role: Led full-stack engineering and platform architecture, ensuring real-time scalability, fraud-proof engagement tracking, and sub-100ms performance across thousands of concurrent users.

░

INTRODUCTION & PROJECT MANDATE

The Maple Grove Restaurant Week 2025 digital passport initiative was undertaken as a strategic pilot project designed to modernize community engagement for one of the city's flagship events. The core mandate was to move beyond traditional event promotion and create an interactive, data-rich experience for participants.

This project aimed to provide measurable results for a local economic event, deliver tangible value to participating businesses, and establish a reusable digital framework that could serve as a long-term asset for the City of Maple Grove.

Client

City of Maple Grove

Role

Lead Full-Stack Engineer & Platform Architect

Timeline

4 Months (Launch: August 10, 2025)

░

PROJECT OBJECTIVES & CORE REQUIREMENTS

Drive Community & Visitor Engagement

Develop an interactive, mobile-first experience to track visitor engagement across all participating venues.

Support Local Businesses

Seamlessly coordinate and onboard over 40 participating restaurants with zero hardware or training friction.

Provide Measurable ROI

Implement real-time analytics and role-based dashboards to deliver live insights for city stakeholders.

Build a Scalable Foundation

Engineer a reusable digital infrastructure suitable for future city events like art crawls and brewery trails.

Meet a Critical Deadline

Deliver a polished, production-ready platform by the hard launch deadline of August 10, 2025.

░

SOLUTION: THE GAMIFIED DIGITAL PASSPORT

We selected a 'gamified digital passport' as the core solution. The strategic intent was to transform the passive activity of restaurant discovery into a competitive, social, and memorable experience. Gamification was chosen as a psychological lever to tap into intrinsic motivation — creating engagement through achievement, social comparison, and tangible rewards.

Core Mechanics

  • QR Code Check-Ins — Scan at participating venues to collect digital stamps, verifying visits
  • Live Leaderboard — Public ranking system displaying participants with most stamps in real-time
  • Raffle System — Each digital stamp automatically serves as one entry into a grand prize raffle
  • Social Proof Feed — Live activity feed displaying recent check-ins across the city
  • Multi-Language Support — Spanish localization for inclusive community reach

Technical Architecture

  • Frontend: Next.js 14, TypeScript, Tailwind CSS — fast, type-safe, mobile-optimized
  • Backend: Supabase (PostgreSQL) — Row Level Security for data isolation
  • Auth: Clerk — <30 second sign-up via Google OAuth, <5% drop-off
  • Infrastructure: Vercel Edge — sub-100ms global response times
  • Caching: Redis/Upstash — real-time leaderboard performance at scale
  • Analytics: GA4 + Vercel Analytics — user behavior and core web vitals
░

PERFORMANCE ANALYSIS: USER ENGAGEMENT & REACH

Week 1 Performance (August 9–17, 2025)

6,066

Unique Visitors

+445% growth

21,744

Page Views

+409% growth

4,100

Active Users

Platform engagement

1,055

Total Sign-Ups

728 in Week 1

122

Daily Retained Users

12% retention rate

1m 41s

Avg Engagement Time

3x industry standard

45%

Bounce Rate

11% better than city avg

89%

Mobile Traffic

iOS 69%, Android 22%

7 cities

Regional Reach

941 from Minneapolis

░

KEY CHALLENGES & RESOLUTIONS

Challenge 1: Aggressive Launch Timeline

Constraint

The project had an immovable 4-month deadline for the August 10th launch. Missing this date was not an option, as it was critical to the city's marketing investment.

Approach

  • Agile methodology with 2-week sprints to ensure iterative progress
  • Prioritized core MVP feature set to prevent scope creep
  • Utilized Vercel's continuous deployment pipeline to streamline releases

Result

Platform launched on-time and on-spec, experiencing zero downtime during first week despite handling thousands of users.

Challenge 2: Security Without User Friction

Constraint

As a public application with raffle incentives, the platform faced significant fraud risk. However, complex security could deter participation.

Approach

  • Time-limited (24-hour) QR tokens to prevent sharing
  • Database-level Row Level Security for data isolation
  • Rate limiting (one stamp per restaurant, per day)
  • Clerk for fast, secure authentication

Result

Zero security incidents or fraud reports while successfully signing up 1,055 users with minimal friction.

Challenge 3: Real-Time Leaderboards at Scale

Constraint

Under peak load, leaderboard queries were at risk of slowing to 5+ seconds, degrading user experience.

Approach

  • PostgreSQL materialized views refreshing every 30 seconds
  • Redis caching layer for frequently accessed top rankings

Result

Leaderboard queries consistently returned in under 100 milliseconds, ensuring seamless experience during peak traffic.

░

BUSINESS & COMMUNITY IMPACT

For The City of Maple Grove

  • ✓Measurable ROI — First city event with real-time participation tracking
  • ✓Enhanced Stakeholder Visibility — Admin dashboards checked daily by city leaders
  • ✓Reusable Digital Asset — Platform now powers Art Crawl and Brewery Trail
  • ✓Regional Brand Awareness — 941 potential visitors from Minneapolis acquired

For Participating Restaurants

  • ✓40+ restaurants onboarded within project timeline
  • ✓Real-time data on venue engagement and traffic patterns
  • ✓Leaderboard mechanic drove multi-restaurant discovery
  • ✓Zero-friction adoption — no hardware or training required

For Users

  • ✓Frictionless Experience — Sub-30-second sign-up via Google OAuth
  • ✓Engaging Competition — 122 daily active users consistently returning
  • ✓Mobile Optimized — 89% mobile traffic fully supported
  • ✓Inclusive Accessibility — Spanish language support broadened reach
░

CONCLUSION: A FOUNDATION FOR FUTURE INNOVATION

The Maple Grove Restaurant Week 2025 Digital Passport project was a resounding success, exceeding its objectives for community engagement, business support, and technical execution. The initiative not only delivered a memorable experience for residents but also established a proven, scalable, and reusable platform for the City.

A civic tech prototype that turned engagement into data.

With key outcomes including 6,066 unique visitors, 1,055 user sign-ups, consistently sub-100ms platform response times, 95+ mobile performance scores, and 99.99% uptime, the project has set a new standard for data-driven event management in Maple Grove. This platform is now poised to power future initiatives, including the planned Art Crawl and Brewery Trail passports.

░