#!/usr/bin/env python3 """ Ghost Agency - Additional Revenue Streams v2 More automated revenue streams that can be implemented. """ import os import json import sqlite3 import hashlib import secrets import time import requests from pathlib import Path from datetime import datetime, timedelta from typing import Dict, List, Any, Optional LEADS_DIR = Path("/home/ubuntu/GhostAgency") DB_FILE = LEADS_DIR / "revenue_bots.db" BROKER_DB = LEADS_DIR / "lead_broker.db" # ============================================================ # ADDITIONAL REVENUE STREAMS (v2) # ============================================================ ADDITIONAL_STREAMS = { # === AI-POWERED SERVICES === "ai_content_generation": { "name": "Generazione Contenuti AI per Locali", "price_range": "50-150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 3000, "description": "Post social, blog, menu, email newsletter generati con AI + review umano", "tools": ["OpenRouter/Gemini", "Canva API", "Buffer/Hootsuite API"], "target": "Ristoranti, bar, gelaterie, pizzerie" }, "ai_review_management": { "name": "Gestione Recensioni AI", "price_range": "100-200€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 2000, "description": "Monitoraggio + risposta automatica recensioni Google/TripAdvisor/FB", "tools": ["Google Places API", "OpenRouter per risposte", "Webhook notifications"], "target": "Tutti i locali con recensioni" }, "ai_seo_optimizer": { "name": "SEO On-Page Automatico", "price_range": "200-500€ setup + 100€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 4000, "description": "Ottimizzazione continua meta tag, schema markup, content gap, core web vitals", "tools": ["Google Search Console API", "Screaming Frog API", "PageSpeed API", "OpenRouter"], "target": "Siti esistenti che vogliono più traffico organico" }, # === MARKETPLACE / PLATFORM === "local_deals_platform": { "name": "Piattaforma Offerte Locali (Groupon-style)", "price_range": "15-25% per vendita", "frequency": "per_deal", "automation_level": "high", "current_mrr": 0, "potential_mrr": 5000, "description": "Marketplace offerte locali (pranzo, aperitivo, spa, parrucchiere) con prenotazione integrata", "tools": ["Stripe Connect", "WhatsApp Business API", "Calendar API", "Email/SMS"], "target": "Ristoranti, spa, parrucchieri, palestre, centri estetici" }, "b2b_lead_marketplace": { "name": "Marketplace Lead B2B per Agenzie", "price_range": "15-40€/lead", "frequency": "per_lead", "automation_level": "high", "current_mrr": 0, "potential_mrr": 3000, "description": "Lead qualificati per agenzie web/marketing (già hai broker API)", "tools": ["Lead Broker API esistente", "CRM webhook", "Slack/Discord notifications"], "target": "Agenzie web, freelancer, consulenti marketing" }, "freelancer_marketplace": { "name": "Marketplace Freelancer Locali", "price_range": "10-20% per progetto", "frequency": "per_project", "automation_level": "medium", "current_mrr": 0, "potential_mrr": 2000, "description": "Connetti locali con fotografi, copywriter, videomaker, social media manager", "tools": ["Escrow payments", "Project management", "Portfolio review", "Contracts"], "target": "Freelancer creativi + locali che servono contenuti" }, # === DATA / INTELLIGENCE === "competitor_intelligence": { "name": "Competitor Intelligence Alerts", "price_range": "50-150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 2000, "description": "Alert settimanali: nuovi competitor, cambi prezzi, nuove aperture, recensioni negative competitor", "tools": ["Google Places API", "Website monitoring", "Social listening", "Price tracking"], "target": "Ristoranti, hotel, retail, franchising" }, "foot_traffic_analytics": { "name": "Analisi Flusso Clienti (WiFi/Bluetooth)", "price_range": "100-300€/mese", "frequency": "monthly", "automation_level": "medium", "current_mrr": 0, "potential_mrr": 3000, "description": "Analytics presenze, tempo permanenza, orari picco, clienti ricorrenti via WiFi/beacon", "tools": ["UniFi/Meraki API", "Bluetooth beacons", "POS integration", "Dashboard"], "target": "Ristoranti, retail, centri commerciali, palestre" }, "menu_engineering": { "name": "Menu Engineering & Pricing Optimization", "price_range": "300-500€ setup + 100€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 2000, "description": "Analisi redditività piatti, pricing psychology, menu design, food cost tracking", "tools": ["POS integration", "Recipe costing", "Sales analytics", "A/B testing"], "target": "Ristoranti, pizzerie, bar, gelaterie" }, # === AUTOMATION / SAAS === "whatsapp_crm": { "name": "WhatsApp CRM per Locali", "price_range": "50-150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 4000, "description": "CRM completo su WhatsApp: prenotazioni, FAQ, ordini, fidelity, broadcast, segmentazione", "tools": ["WhatsApp Business API", "Meta Cloud API", "Dialogflow/Rasa", "PostgreSQL", "Redis"], "target": "Ristoranti, parrucchieri, centri estetici, palestre" }, "loyalty_program_saas": { "name": "Programma Fedeltà Whitelabel", "price_range": "50-150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 3000, "description": "Programma punti, cashback, referral, tier, gift card, wallet digitale whitelabel", "tools": ["Wallet API", "QR codes", "Apple/Google Wallet", "POS integration", "Email/SMS"], "target": "Caffè, panifici, gelaterie, retail, palestre" }, "appointment_booking_saas": { "name": "Sistema Prenotazioni Whitelabel", "price_range": "50-150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 4000, "description": "Prenotazioni online, calendario, reminder, depositi, lista attesa, pacchetti, abbonamenti", "tools": ["Calendly-style UI", "Stripe deposits", "Google Calendar sync", "WhatsApp/Email reminders"], "target": "Parrucchieri, centri estetici, palestre, medici, consulenti" }, # === NICCHIA / ALTO VALORE === "ghost_kitchen_optimizer": { "name": "Ottimizzazione Ghost Kitchen / Delivery", "price_range": "300-500€ setup + 150€/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 2000, "description": "Ottimizzazione menu delivery, packaging, prezzi, commissioni JustEat/Glovo/UberEats", "tools": ["API JustEat/Glovo/UberEats", "Menu analytics", "Packaging optimizer", "Commission tracker"], "target": "Ristoranti con delivery, ghost kitchen, dark kitchen" }, "franchise_lead_gen": { "name": "Lead Generation per Franchising", "price_range": "100-300€/lead qualificato", "frequency": "per_lead", "automation_level": "high", "current_mrr": 0, "potential_mrr": 5000, "description": "Lead qualificati per franchisor che cercano franchisee (settore food, fitness, beauty)", "tools": ["LinkedIn Sales Navigator API", "Facebook Ads API", "Landing pages", "CRM"], "target": "Franchisor food, fitness, beauty, education, services" }, "equipment_leasing_marketplace": { "name": "Marketplace Noleggio Attrezzature", "price_range": "5-10% per noleggio", "frequency": "per_rental", "automation_level": "medium", "current_mrr": 0, "potential_mrr": 2000, "description": "Marketplace noleggio attrezzature ristorazione (forni, frigoriferi, lavastoviglie, POS)", "tools": ["Inventory management", "Contract automation", "Payment processing", "Insurance"], "target": "Nuovi ristoranti, eventi, catering, startup food" }, # === EDUCAZIONE / FORMAZIONE === "staff_training_platform": { "name": "Piattaforma Formazione Staff", "price_range": "20-50€/dipendente/mese", "frequency": "monthly", "automation_level": "high", "current_mrr": 0, "potential_mrr": 3000, "description": "Formazione HACCP, sicurezza, servizio, vendita, inglese, soft skills per staff locali", "tools": ["LMS whitelabel", "Video lessons", "Quiz/certificati", "Tracking completamento", "Report manager"], "target": "Ristoranti, hotel, catene, franchising" }, "digital_transformation_consulting": { "name": "Consulenza Trasformazione Digitale", "price_range": "1000-3000€ progetto", "frequency": "per_project", "automation_level": "low", "current_mrr": 0, "potential_mrr": 5000, "description": "Audit digitale, roadmap, implementazione tool, training, change management", "tools": ["Audit framework", "ROI calculator", "Vendor selection", "Project management"], "target": "PMI locali, ristoranti, retail, servizi professionali" }, # === FINANZIARIO / ASSICURATIVO === "insurance_brokerage": { "name": "Brokeraggio Assicurativo Locale", "price_range": "10-20% commissione premio", "frequency": "per_policy", "automation_level": "medium", "current_mrr": 0, "potential_mrr": 3000, "description": "RC professionale, cyber, infortuni, proprietà, HACCP, veicoli per locali", "tools": ["API broker assicurativi", "Quote comparison", "PDF generation", "E-signature"], "target": "Tutti i locali (obbligo RC, HACCP, cyber)" }, "pos_finance_marketplace": { "name": "Marketplace Finanziamento POS/Attrezzature", "price_range": "2-5% per finanziamento", "frequency": "per_deal", "automation_level": "high", "current_mrr": 0, "potential_mrr": 2000, "description": "Finanziamento POS, registratori cassa, forni, frigoriferi, arredi per nuovi locali", "tools": ["API istituti finanziari", "Credit scoring", "Document automation", "E-signature"], "target": "Nuovi ristoranti, ristrutturazioni, upgrade attrezzature" } } # ============================================================ # PRIORITY MATRIX (Effort vs Revenue) # ============================================================ PRIORITY_MATRIX = { "quick_wins": [ # Low effort, High revenue, High automation "ai_content_generation", "ai_review_management", "whatsapp_crm", "appointment_booking_saas", "loyalty_program_saas", "b2b_lead_marketplace", # Already have broker API ], "medium_term": [ # Medium effort, High revenue "ai_seo_optimizer", "local_deals_platform", "appointment_booking_saas", "loyalty_program_saas", "whatsapp_crm", "competitor_intelligence", "menu_engineering", ], "big_bets": [ # High effort, Very high revenue "local_deals_platform", "whatsapp_crm", "franchise_lead_gen", "digital_transformation_consulting", "staff_training_platform", ], "skip_for_now": [ # Low automation, High effort, Regulatory complexity "insurance_brokerage", "pos_finance_marketplace", "equipment_leasing_marketplace", ] } # ============================================================ # IMPLEMENTATION ROADMAP # ============================================================ ROADMAP = { "week_1_2": { "focus": "Quick Wins - Content & Reviews AI", "tasks": [ "Implement ai_content_generation con OpenRouter + Buffer API", "Implement ai_review_management con Google Places + OpenRouter", "Test su 5 clienti esistenti", "Misura: tempo risparmiato, engagement, response rate" ] }, "week_3_4": { "focus": "WhatsApp CRM + Booking SaaS", "tasks": [ "MVP WhatsApp CRM: FAQ + Prenotazioni + Broadcast", "Integra WhatsApp Business API (Meta Cloud)", "Template approvati Meta per categorie", "Beta con 3 parrucchieri/centri estetici" ] }, "month_2": { "focus": "Booking SaaS + Loyalty + Content AI", "tasks": [ "Lancia appointment_booking_saas whitelabel", "Lancia loyalty_program_saas", "Integra ai_content_generation nel flusso", "Primi 10 clienti beta paganti" ] }, "month_3": { "focus": "Marketplace + SEO AI", "tasks": [ "Lancia b2b_lead_marketplace (usa broker API esistente)", "Implementa ai_seo_optimizer", "Lancia competitor_intelligence alerts", "Primi ricavi marketplace" ] }, "month_4_6": { "focus": "Scale + Big Bets", "tasks": [ "Local deals platform MVP", "Whitelabel SaaS platform multi-tenant", "Franchise lead gen pipeline", "Staff training platform", "Digital transformation consulting packages" ] } } # ============================================================ # REVENUE PROJECTIONS # ============================================================ PROJECTIONS = { "month_3": { "mrr": 2000, "clients": 15, "streams_active": 4 }, "month_6": { "mrr": 8000, "clients": 50, "streams_active": 8 }, "month_12": { "mrr": 25000, "clients": 150, "streams_active": 12 }, "month_24": { "mrr": 80000, "clients": 500, "streams_active": 20 } } # ============================================================ # AUTOMATION ARCHITECTURE # ============================================================ ARCHITECTURE = { "core_services": { "radar": "Lead generation continuo", "mailer": "Email outreach automatizzato", "call_followup": "WhatsApp follow-up", "broker_api": "Vendita lead", "revenue_bots": "Upsell/Renewal/Referral" }, "ai_services": { "content_gen": "OpenRouter + templates", "review_mgmt": "Google Places + OpenRouter", "seo_optimizer": "GSC + PageSpeed + OpenRouter", "content_calendar": "AI calendar + Buffer API" }, "platform_services": { "whatsapp_crm": "Meta Cloud API + Redis + PostgreSQL", "booking_saas": "Multi-tenant + Stripe + Calendly-style", "loyalty_saas": "Wallet + QR + Apple/Google Wallet", "deals_platform": "Stripe Connect + WhatsApp + Calendar" }, "data_services": { "radar_data": "Lead gen + enrichment", "competitor_intel": "Monitoring + alerts", "market_reports": "Automated reports", "analytics": "Dashboard + alerts" }, "infrastructure": { "orchestration": "Hermes cron + custom scheduler", "database": "SQLite (dev) → PostgreSQL (prod)", "queue": "Redis + Celery (prod)", "monitoring": "Uptime Kuma + custom alerts", "deploy": "Docker + Docker Compose → K8s (scale)" } } # ============================================================ # DEPLOYMENT CHECKLIST # ============================================================ DEPLOYMENT_CHECKLIST = { "immediate": [ "��� Radar v3 + Mailer v3 + Call Followup v3", "��� Revenue Bots (Upsell/Renewal/Referral)", "��� Lead Broker API + Admin Dashboard", "��� Domain Portfolio Manager", "��� Affiliate Manager", "��� Market Insights Generator", "��� Revenue Streams Registry (17 streams)", "��� Admin API + Dashboard", "��� Cron jobs attivi" ], "this_week": [ "���� AI Content Generation (OpenRouter + templates)", "���� AI Review Management (Google Places + OpenRouter)", "���� WhatsApp CRM MVP (Meta Cloud API + templates)", "���� Affiliate tracking DNS (aff.svoraj.me)", "���� Domain Portfolio → registrazione reale (Porkbun/Cloudflare)", "���� Lead Broker → buyer onboarding (Stripe manuale per ora)" ], "next_week": [ "���� WhatsApp CRM Beta (3 parrucchieri/estetiste)", "���� Appointment Booking SaaS MVP", "���� Loyalty Program SaaS MVP", "���� AI Content Generation beta (5 clienti)", "���� AI Review Management beta (5 clienti)" ], "month_1": [ "���� Appointment Booking SaaS Launch", "���� Loyalty Program Launch", "���� AI Content Generation Launch", "���� AI Review Management Launch", "���� B2B Lead Marketplace Launch", "���� Primi 10 clienti beta paganti" ], "month_2": [ "���� Local Deals Platform MVP", "���� AI SEO Optimizer Launch", "���� Competitor Intelligence Launch", "���� Primi ricavi marketplace", "���� 50 clienti attivi" ], "month_3": [ "���� Whitelabel SaaS Platform MVP", "���� Franchise Lead Gen Pipeline", "���� Staff Training Platform MVP", "���� MRR target: €2000" ], "month_6": [ "���� Local Deals Platform Launch", "���� Whitelabel SaaS Platform Launch", "���� Franchise Lead Gen Launch", "���� Staff Training Platform Launch", "���� MRR target: €8000" ], "month_12": [ "���� Whitelabel SaaS Platform Scale", "���� Franchise Lead Gen Scale", "���� Staff Training Platform Scale", "���� MRR target: €25000" ] } # ============================================================ # EXECUTION FUNCTIONS # ============================================================ def get_all_streams() -> Dict: """Restituisce tutti gli stream combinati.""" all_streams = {} # Import existing from new_revenue_streams try: import new_revenue_streams as nrs all_streams.update(nrs.REVENUE_STREAMS) except: pass all_streams.update(ADDITIONAL_STREAMS) return all_streams def get_priority_streams(phase: str = "quick_wins") -> List[str]: """Restituisce stream per fase di priorità.""" return PRIORITY_MATRIX.get(phase, []) def get_roadmap_phase(month: int) -> Dict: """Restituisce roadmap per mese specifico.""" if month <= 2: return ROADMAP["week_1_2"] elif month <= 4: return ROADMAP["month_2"] elif month <= 6: return ROADMAP["month_3"] else: return ROADMAP["month_4_6"] def calculate_tam(stream_key: str) -> Dict: """Calcola TAM per uno stream.""" stream = ADDITIONAL_STREAMS.get(stream_key, {}) return { "stream": stream_key, "name": stream.get("name", ""), "potential_mrr": stream.get("potential_mrr", 0), "automation": stream.get("automation_level", ""), "price_range": stream.get("price_range", ""), "target": stream.get("target", "") } def print_revenue_summary(): """Stampa summary completo revenue streams.""" all_streams = get_all_streams() total_potential = sum(s.get("potential_mrr", 0) for s in all_streams.values()) total_current = sum(s.get("current_mrr", 0) for s in all_streams.values()) print(f"\n{'='*70}") print(f" GHOST AGENCY - REVENUE STREAMS COMPLETE SUMMARY") print(f"{'='*70}") print(f"Total Streams: {len(all_streams)}") print(f"Potential MRR: €{total_potential:,.0f}/mese") print(f"Current MRR: €{total_current:,.0f}/mese") print(f"Gap: €{total_potential - total_current:,.0f}/mese") print(f"\n{'Stream':<40} {'Potential MRR':>12} {'Auto':>8} {'Status'}") print("-"*70) for key, stream in sorted(all_streams.items(), key=lambda x: x[1].get("potential_mrr", 0), reverse=True): auto = stream.get("automation_level", "N/A")[:6] status = "���� Live" if stream.get("current_mrr", 0) > 0 else "���� Planned" print(f"{stream.get('name', key)[:38]:<40} €{stream.get('potential_mrr', 0):>10,} {auto:>8} {status}") if __name__ == "__main__": print_revenue_summary() print(f"\n\nRoadmap Next 2 Weeks:") for task in ROADMAP["this_week"]["tasks"]: print(f" • {task}")