stone-lead

byNeev Khoreja

This Product Requirements Document (PRD) is the final, comprehensive blueprint for **LeadFlow Ultra**. It integrates deep scraping, automated website auditing, and high-conversion outreach tools into a high-end, minimalist interface designed for professional agency use. --- ## **Product Requirements Document: LeadFlow Ultra** **Project Name:** LeadFlow Ultra **Proprietor:** Webora **Design Ethos:** Dark, Achromatic, Command-Driven (Anti-AI Aesthetic) --- ### **1. Executive Summary** LeadFlow Ultra is a specialized lead extraction and auditing engine built to identify and convert "digitally struggling" businesses. By combining Google Maps data with real-time website performance audits, the platform provides Webora with a ranked list of high-intent prospects who lack a professional web presence or have underperforming digital assets. --- ### **2. Core Functional Requirements** #### **2.1. "Exhaustive" Lead Scraping (Apify Integration)** * **Deep Scrape:** Utilize the **Apify Google Maps Scraper** to bypass the 120-result limit, crawling specific coordinates or subdivision zones to find *all* matching businesses. * **Data Fields:** Capture Business Name, `place_id`, Phone, Physical Address, Website URL, Rating, Review Count, and Category. #### **2.2. Intelligent Lead Vault & Deduplication** * **Primary Key Persistence:** Use the Google `place_id` as the unique identifier in Supabase to prevent duplicate records. * **UPSERT Logic:** If a business is found in a new search, the system must update its rating or website status rather than creating a second entry. #### **2.3. Automated Website Audit (PageSpeed Engine)** * **Health Check:** For any business with an existing URL, the system triggers the **Google PageSpeed Insights API** to generate a **Webora Score** (0–100) based on Performance, SEO, and Mobile-friendliness. * **Status Indicators:** * **Missing:** No website found. * **Critical (< 50):** Outdated, slow, or broken site. * **Suboptimal (50–80):** Needs refinement. #### **2.4. AI-Powered Personalized Outreach** * **Generate Pitch Button:** A dedicated action within the Lead Drawer that synthesizes Google Maps data (e.g., "You have a great 4.5 rating!") and Audit data (e.g., "But your site takes 6 seconds to load") into a concise pitch. * **Language Toggle:** Option to generate the message in professional **English** or conversational **Hinglish** to suit the local Mumbai/Kalyan market. * **Copy to Clipboard:** A "One-Click Copy" button immediately following the message generation for quick pasting into WhatsApp, Email, or DM. --- ### **3. User Interface (UI) & Design** #### **3.1. Aesthetic Guidelines** * **Palette:** Pure Black (`#000000`) background with `Slate-900` surfaces and `Slate-800` borders (1px solid). * **Typography:** **Geist Sans** for interface text; **Geist Mono** for all data points, ratings, and code snippets. * **Anti-AI Polish:** Avoid large rounded corners, gradients, or heavy shadows. The UI should feel like a high-end developer tool (e.g., Linear or Vercel) rather than a generic SaaS. #### **3.2. Dashboard & Navigation** * **Command Palette:** `Cmd + K` functionality to filter by "No Website" or "Low Ratings". * **Lead Drawer:** A sliding side-panel (no pop-up modals) that displays the full audit logs and the **Outreach Module**. * **Search History Sidebar:** A persistent record of all past keyword/location combinations to re-run or review. --- ### **4. Technical Stack & Database Schema** * **Frontend:** React (Vite) + Tailwind CSS + Lucide Icons. * **Backend:** Supabase (Auth & PostgreSQL). * **Intelligence:** OpenAI/Claude API for pitch generation; Google PageSpeed API for audits. #### **Database Schema (SQL):** ```sql -- Leads Table CREATE TABLE leads ( place_id TEXT PRIMARY KEY, name TEXT NOT NULL, category TEXT, maps_rating DECIMAL(2,1), reviews_count INTEGER, website_url TEXT, webora_score INTEGER, -- 0 to 100 audit_data JSONB, -- Stores specific LCP, SEO, and Speed metrics last_contacted_at TIMESTAMP WITH TIME ZONE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Search Logs Table CREATE TABLE searches ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), keyword TEXT, location TEXT, leads_count INTEGER, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); ``` --- ### **5. Roadmap & Success Metrics** * **Phase 1 (The Engine):** Connect Apify to Supabase with `place_id` deduplication. * **Phase 2 (The Auditor):** Integrate Google PageSpeed API to calculate the Webora Score. * **Phase 3 (The Closer):** Implement the Lead Drawer with the AI Pitch Generator and Copy-to-Clipboard functionality. * **Success Metric:** Time-to-lead (how quickly an agency can find a qualified prospect and send a message). --- ### **Final Instruction for Coding Tools:** > "Build LeadFlow Ultra using React and Supabase. The UI must be pure black with 1px slate borders. Sorting must default to 'Maps Rating: Ascending.' For every lead, provide a 'Lead Drawer' containing a 'Generate Pitch' button that creates a customized improvement plan for the business, followed by a 'Copy' button."