#!/usr/bin/env python3
"""
Manual HubSpot data entry based on user's image descriptions.
This ensures accuracy while we work on perfecting the CSV parser.
"""

import json
from pathlib import Path

def get_manual_hubspot_data():
    """Manual data entry from user's HubSpot report images."""
    
    # Based on user's image descriptions:
    # Organic Leads by month (Dec 2024 - Nov 2025)
    organic_leads = {
        '2024-12': 13,
        '2025-01': 14,
        '2025-02': 14,
        '2025-03': 25,
        '2025-04': 14,
        '2025-05': 15,
        '2025-06': 22,
        '2025-07': 32,
        '2025-08': 32,
        '2025-09': 40,
        '2025-10': 81,
        '2025-11': 155,
    }
    
    # Organic MQLs by month (from image description)
    organic_mqls = {
        '2024-12': 11,
        '2025-01': 12,
        '2025-02': 13,
        '2025-03': 24,
        '2025-04': 14,
        '2025-05': 13,
        '2025-06': 16,
        '2025-07': 28,
        '2025-08': 27,
        '2025-09': 27,
        '2025-10': 35,
        '2025-11': 63,
    }
    
    # Organic Customers by month (from image description)
    organic_customers = {
        '2024-12': 4,
        '2025-01': 1,
        '2025-02': 0,
        '2025-03': 5,
        '2025-04': 3,
        '2025-05': 2,
        '2025-06': 2,
        '2025-07': 4,
        '2025-08': 4,
        '2025-09': 6,
        '2025-10': 3,
        '2025-11': 3,
    }
    
    # Demo booked % (from image - green highlighted values)
    demo_booked_pct = {
        '2024-12': 46,
        '2025-01': 54,
        '2025-02': 33,
        '2025-03': 43,
        '2025-04': 69,
        '2025-05': 40,
        '2025-06': 14,
        '2025-07': 50,
        '2025-08': 41,
        '2025-09': 45,
        '2025-10': 15,
        '2025-11': 15,
    }
    
    # Unqualified % (from image - red highlighted values)
    unqualified_pct = {
        '2024-12': 54,
        '2025-01': 54,
        '2025-02': 92,
        '2025-03': 57,
        '2025-04': 69,
        '2025-05': 73,
        '2025-06': 59,
        '2025-07': 59,
        '2025-08': 56,
        '2025-09': 38,
        '2025-10': 31,
        '2025-11': 22,
    }
    
    return {
        'leads': organic_leads,
        'mqls': organic_mqls,
        'customers': organic_customers,
        'demo_booked_pct': demo_booked_pct,
        'unqualified_pct': unqualified_pct
    }

if __name__ == "__main__":
    data = get_manual_hubspot_data()
    output_file = Path(__file__).parent.parent / "06-DATA-ANALYSIS" / "hubspot_manual_data.json"
    with open(output_file, 'w', encoding='utf-8') as f:
        json.dump(data, f, indent=2, ensure_ascii=False)
    print(f"Manual HubSpot data saved to {output_file}")