-- ============================================================
-- CAE -- Projects Seed (generated from Savit Projects Upload.xlsx)
-- ============================================================

INSERT INTO `projects`
  (`business_name`, `website_url`, `target_audience`, `content_intent`,
   `brand_positioning`, `tone_voice`, `brand_dos`, `brand_donts`,
   `pov_type`, `seo_philosophy`, `compliance_rules`,
   `brand_reference_style`, `cta_style`, `no_no_words`, `guideline_doc_url`)
VALUES
  ('Chirag Nettings', 'https://chiragnettings.com/', 'Individuals looking for Nets', 'SEO traffic, product education', 'Value', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Nettings Solutions', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Power Ace India', 'https://poweraceindia.com/', 'B2B', 'SEO traffic, service education', 'niche', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Industrial Products Manufacturing', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Iconic Brow N Lash ', 'https://iconicbrownlash.com.au/', 'Women looking for beauty services in Australia', 'SEO traffic, service education', 'Value', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Beauty Parlour', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Shah Doshi', 'https://shahdoshi.com/', 'Users looking for CA services', 'SEO traffic, service education', 'Value', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'CA Firm - Professional Services', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('National Academy', 'https://nationalacademy.co/', 'Women looking for teacher training', 'SEO traffic, service education', 'Value', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Teacher Training Institute', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('I leaf Banquets', 'https://www.ileafbanquets.com', 'anyone looking for banquets halls - individuals, corporate offices', 'SEO traffic, service education', 'luxury', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Banquet Hall / Wedding & Event Venue', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Khed City', 'https://khedcity.com/', 'Industrial Investors', 'SEO traffic, service education', 'niche', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Industrial Real Estate', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Classic Solvents', 'https://classicsolvents.com/', 'Industrial Buyers', 'SEO traffic, product education', 'niche', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Chemical Supplier', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Mukand', NULL, 'Industrial Buyers', 'SEO traffic, product education', 'niche', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Steel Manufacturer', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Xaviers Group', 'https://xaviersgroup.co.in/', 'Parents seeking school admissions for their children', 'SEO traffic, product education', 'Value', 'Informational, professional', 'simple human friendly', NULL, 'first_person_we', 'Natural Keywords Integration', 'Education Institute', 'Conclusion', 'Direct CTA', NULL, NULL),
  ('Healthy Wrinkles', 'healthywrinkles.com', 'caregivers, and relatives looking for elderly care solutions for parents/seniors; typically age 30–60; category: senior care / assisted living / home care / elder support; geography: mainly India, especially urban families searching for care options', 'SEO traffic + service education + lead generation', 'Premium healthcare aggregator', 'Professional, Informational, Reassuring', 'Simple patient-friendly language', 'Medical jargon or treatment guarantees', 'third_person', 'Natural SEO with high intent keywords', 'Healthcare compliance, avoid cure guarantees', 'Intro + Conclusion', 'Direct CTA (Book consultation)', '“Guaranteed cure”, “100% results”', NULL),
  ('BD Gift', NULL, 'People living outside Bangladesh who want to send gifts to family, friends, and loved ones in Bangladesh; typically age 25–50; category: online gift buyers, occasion-based shoppers, NRBs/expats; geography: international users from USA, UK, Canada, UAE, Australia and other countries sending gifts to Bangladesh', 'Product discovery + transactional SEO traffic + ecommerce conversions for gift delivery to Bangladesh', 'Trusted online gift delivery platform focused on Bangladesh gifting; value-driven, reliable, occasion-led ecommerce brand', 'Friendly, emotional, simple, occasion-based, customer-focused', 'use warm, easy-to-understand language focused on gifting, emotions, convenience, and timely delivery', 'use overly corporate language, heavy jargon, or unrealistic promises', 'third_person', 'Aggressive SEO for product keywords', 'Low regulatory sensitivity, but avoid misleading delivery promises, fake urgency, and unsupported product/service guarantees', 'Conclusion mention', 'Sales-heavy / Direct CTA (Order now, Send gifts now, Shop now, Explore gifts)', '“Guaranteed delivery in every case,” “cheapest,” “best in the world,” “instant delivery everywhere,” “100% perfect every time”', NULL),
  ('Expert Cancer', 'https://cancerhomoeoclinic.co.in/', 'Cancer patients and families seeking supportive homeopathic treatment alongside conventional treatment; age 35–70; India and international patients', 'Patient education + appointment leads', 'Niche alternative healthcare provider', 'Professional, Reassuring, Medical', 'Use supportive language', 'Cure claims', 'third_person', 'Natural SEO focused on disease queries', 'Healthcare compliance required', 'Intro + Conclusion', 'Direct CTA (Book appointment)', '“ cure”, “instant recovery”', NULL),
  ('Route2 Fashion', 'https://route2fashion.com/', 'Men and women buying branded perfumes, deodorants, innerwear, lingerie, and apparel online; typically age 18–45; category: ecommerce shoppers, fragrance buyers, gifting buyers, branded lifestyle product buyers; geography: India', 'Product discovery + ecommerce SEO traffic + conversion-focused content', 'Value-driven premium branded fragrance and fashion ecommerce store', 'Stylish, friendly, modern, conversational, product-focused', 'use clear product-led and benefit-led language', 'sound overly generic, academic, or make fake luxury claims', 'third_person', 'Aggressive SEO for product, brand, and transactional keywords', 'Low compliance sensitivity, but avoid false authenticity or misleading pricing/performance claims', 'Intro + Conclusion', 'Sales-heavy CTA (Shop now, Buy now, Explore collection)', '“Cheapest original perfume,” “guaranteed compliments,” “100% imported” unless verified, fake scarcity phrases', NULL),
  ('Wellwomenclinic', 'https://www.wellwomenclinic.co.uk/', 'Women seeking gynecology care, fertility treatment, pregnancy care, and reproductive health support; age 25–45; urban India', 'Patient education + consultation leads', 'Premium women''s healthcare clinic', 'Professional, Reassuring', 'Empathy-driven messaging', 'Medical overclaims', 'third_person', 'Natural SEO', 'Healthcare sensitivity', 'Intro + Conclusion', 'Direct CTA (Book consultation)', '“Instant fertility solution”', NULL),
  ('Energy Spoc', 'https://energyspoc.com/', 'Homeowners, commercial building owners, factories, and businesses planning rooftop solar installations; age 30–60; India', 'Lead generation + solar education', 'Value-driven renewable energy provider', 'Professional, Informational', 'Explain ROI & savings', 'Unrealistic savings claims', 'third_person', 'Aggressive SEO', 'Energy regulations', 'Conclusion', 'Direct CTA (Get quote)', '“Zero cost installation everywhere”', NULL),
  ('Kaf Valcunindia', 'https://kaf-vulcanindia.com/', 'Primary audience: plant maintenance teams, mechanical engineers, application engineers, technical buyers, procurement managers, and factory decision-makers looking for industrial sealing solutions such as encapsulated O-rings, mechanical seals, gland packings, PTFE gaskets, cryogenic O-rings, and high-temperature insulation; industries include pharma, food & beverage, chemical processing, semiconductor, marine, water treatment, refrigeration, oil & gas, and process industries; age 30–55; geography: India industrial market', 'Product education + B2B enquiries', 'Niche, premium, engineering-led industrial sealing solutions supplier and official distributor of Vulcan Engineering Ltd. (UK & USA); positioned as quality-first, compliance-aware, and solution-oriented', 'Professional, technical, authoritative, informative', 'use precise technical language where needed, explain applications clearly, mention product suitability, standards, reliability, and operating conditions', 'use vague marketing fluff, oversimplify technical use cases, or make unsupported performance claims', 'third_person', 'Natural keyword integration with strong technical and product-intent targeting; focus on exact industrial sealing terms rather than stuffing', 'High sensitivity around technical accuracy, certifications, material compatibility, temperature/chemical resistance, and compliance claims; avoid unverified claims about FDA/USP/ISO/chemical suitability/performance range', 'Intro + conclusion, with natural brand mention where technical trust is needed', 'Direct CTA (Contact us, Enquire now, Request a quote, Discuss your application)', '“Works for all chemicals,” “universal seal,” “zero maintenance,” “guaranteed performance in every condition,” “best for every industry,” “100% leak-proof”', NULL),
  ('Vastusure', 'https://www.vastusure.com/', 'Homeowners, property buyers, business owners seeking Vastu consultation for homes, offices, plots, factories; age 30–60; India', 'SEO education + consultation leads', 'Niche spiritual consultancy', 'Simple, Advisory', 'Positive guidance', 'fear-based messaging', 'third_person', 'Natural SEO', 'Spiritual advisory sensitivity', 'Intro + Conclusion', 'Soft CTA (Book consultation)', '“Guaranteed wealth”, “remove all problems instantly”', NULL),
  ('Exel Moto', 'exelmoto.com', 'Urban commuters, students, fitness enthusiasts looking for electric bicycles for daily commuting; age 18–40; India', 'Product awareness + ecommerce sales', 'Premium lifestyle EV brand', 'Energetic, Modern', 'Highlight mobility innovation', 'exaggerated range claims', 'first_person_we', 'Aggressive SEO', 'EV product compliance', 'Intro + Conclusion', 'Sales CTA (Buy now / Book now)', '“Unlimited range”, false specs', NULL),
  ('Atvio.in', 'https://atvio.in/', 'Businesses requiring staff uniforms such as corporate offices, hospitals, hotels, security agencies, schools, facility management companies; age 30–55; India', 'SEO traffic + B2B enquiries', 'Value-driven B2B uniform manufacturer', 'Professional, Corporate', 'Highlight customization', 'fashion-style tone', 'third_person', 'Aggressive SEO', 'Low compliance', 'Conclusion', 'Direct CTA (Request quote)', '“Cheap uniforms”, unrealistic delivery', NULL),
  ('Alankar Vision', 'https://www.alankar.vision/', 'Contact lens users, eyewear buyers, and customers purchasing branded optical products online; age 18–50; India (with strong Mumbai presence)', 'Ecommerce sales + product education', 'Trusted legacy optical brand', 'Professional, Informational', 'Trust & expertise messaging', 'medical claims', 'third_person', 'Aggressive product SEO', 'Healthcare sensitivity', 'Intro + Conclusion', 'Direct CTA (Shop now)', '“No prescription required” claims', NULL),
  ('Asha Hospital', 'https://ashahospital.co.in/', 'Patients and families in Malad, Kandivali, Goregaon, Borivali seeking multispeciality hospital services; age 25–65; Mumbai', 'Patient education + appointment leads', 'Community healthcare provider', 'Professional, Reassuring', 'patient-first messaging', 'cure guarantees', 'third_person', 'Natural SEO', 'Healthcare compliance', 'Intro + Conclusion', 'Direct CTA (Book appointment)', '“Guaranteed surgery success”', NULL),
  ('Uaeelan', 'https://www.uaeelan.com/', 'Industrial companies, chemical manufacturers, logistics companies needing bulk industrial packaging such as drums, IBC tanks, pails, tarpaulin; procurement managers age 30–55; UAE and MENA region', 'B2B product education + industrial leads', 'Industrial packaging manufacturer', 'Technical, Corporate', 'Emphasize durability & compliance', 'vague marketing claims', 'third_person', 'Aggressive product SEO', 'Industrial compliance', 'Conclusion', 'Direct CTA (Contact sales)', '“Works for every chemical” claims', NULL),
  ('Amar Equipment / Amar Bio / Amar Flow', NULL, 'B2B—R&D chemists/process engineers & lab/pilot plant teams in pharma, specialty chemicals, petrochemicals, materials science; plus universities/research institutes.', 'Product/service education + qualified lead generation (with SEO support).', 'Niche + premium engineering, positioned as quality/safety-first and cost-effective value vs global peers.', 'Professional, authoritative, informational (technical but clear).', 'be precise, safety-first, mention standards/specs.\n', 'hype, absolute claims, or heavy jargon.', 'first_person_we', 'Natural keyword integration (technical terms used where relevant).', 'Emphasize safety + compliance (e.g., ISO 9001:2015, ASME; CE/PED when applicable); avoid overpromising certifications/specs without confirmation.', 'Mention Amar in intro + conclusion, then use “the company / the system” naturally in between.', 'Direct, professional CTA (Contact us / Request a quote / Discuss your application).', NULL, NULL),
  ('Digital Data Automation Pvt Ltd', NULL, 'Primary Audience - Operations Head, Procurment Head, Supply Chain Manager Etc. \nAge - 35 to 45 \nCategory - \nDemography - PAN INDIA', 'Objective - Core Lead Generation and market leader', 'Value', 'Informational, Professional, Authorative, formal, corporate , also conversational ', 'Use correct grammar and always use operational layman''s words and also use tech words for exact match keyword.', NULL, 'third_person', 'Aggressive SEO', NULL, 'Works - could be a mix and match strategy', 'Direct CTA ', NULL, NULL),
  ('Hochi Minh Florist', 'https://www.hochiminhflorist.com/', 'Gift buyers, expats, locals sending flowers in Vietnam, age 22-55', 'seo traffic, product discovery', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'E-commerce / Flower Delivery', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Vietnams Florist', 'https://www.vietnamsflorist.com/', 'International buyers sending gifts/flowers to Vietnam', 'seo traffic, product discovery', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'E-commerce / Flower Delivery', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Lab Chemicals', 'https://www.labchemicals.in/', 'Laboratories, pharmaceutical companies, research institutions, universities, biotech companies, and chemical manufacturing industries that require laboratory chemicals, reagents, and scientific equipment.', 'Product education + B2B SEO traffic for laboratory chemicals, reagents, and scientific supplies.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Manufacturing and Chemical Industry', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Jumpin Heights', 'https://www.jumpinheights.com/', 'Adventure travelers, thrill-seekers, domestic and international tourists visiting Rishikesh or Goa, mainly aged 18-40 looking for activities like bungee jumping, flying fox, and giant swing.', 'SEO traffic for adventure tourism keywords + experience education + activity bookings.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Adventure Tourism & Safety', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('BK Infotech', 'https://bkinfotech.in/', 'Small and medium businesses, startups, and enterprises seeking IT services', 'Service education + SEO traffic + lead generation for IT and technology services.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'IT Services', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Kayakalp International', 'https://kayakalpinternational.com/', 'healthcare businesses', 'SEO traffic + patient education on sexual health issues + lead generation for consultation bookings.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Healthcare', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Jairaj Ispat', 'https://jairajispat.com/', 'Construction companies, infrastructure developers, builders, contractors, and industrial buyers looking for steel products.', 'Product education + B2B SEO traffic + enquiry generation for TMT bars.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Steel Manufacturing Industry', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Zirconia Guys', 'https://zirconiaguys.com/', 'Dental laboratories, dentists, dental technicians, dental distributors, and clinics that use zirconia materials for dental restorations.', 'Product education + dental SEO traffic + enquiries from dental labs and dentists.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Dental Materials Industry', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Silver Plaza', 'https://silverplaza.co.in/', 'Jewelry buyers, wedding shoppers, gift buyers, and customers looking for silver jewelry, ornaments, and accessories.', 'SEO traffic + jewellery product discovery + ecommerce sales.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'E-commerce Jewelry', 'intro + conclusions', 'Direct CTA', 'Everyday wear or Daily Wear', 'The content should not include Everyday wear or Daily Wear'),
  ('Diet Therapy', 'https://thediettherapy.com/', 'Individuals seeking diet plans, weight management solutions, lifestyle improvement, and clinical nutrition guidance.', 'Educational SEO traffic for health and diet topics + lead generation for nutrition consultation.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Healthcare / Nutrition', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Clamet', 'https://www.calmet.com/', 'Calmet is industrial manufacturing companies, OEMs, and engineering firms worldwide', 'Industrial SEO traffic + product education + B2B enquiries for casting and machining solutions.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', NULL, 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Bluestar Slides', 'https://www.bluestarslides.com/', 'Pathology laboratories, diagnostic labs, hospitals, research institutions, medical colleges, pharmaceutical labs, and scientific distributors requiring microscope slides and cover glasses for laboratory analysis.', 'Product education + laboratory SEO traffic + distributor enquiries.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Manufacturing & Engineering', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Renarte LLC', 'https://renartellc.com/', 'Luxury homeowners, property developers, architects, and commercial clients looking for high-end interior design and renovation services.', 'Product education + hospitality SEO traffic + B2B enquiries.', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keywords integration', 'Healthcare Laboratory Supplies', 'intro + conclusions', 'Direct CTA', NULL, NULL),
  ('Vinati Organics', 'https://vinatiorganics.com/', 'B2B Business', 'seo traffic, product discovery', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Manufacturing and Chemical Industry', 'conclusions', 'Direct CTA', NULL, NULL),
  ('New Horizon', 'https://www.new-horizon.co.in/', 'companies looking for hr services', 'seo traffic, product discovery', 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Hr Services', 'conclusions', 'Direct CTA', NULL, 'do hiring in India for companies outside India (no oversea placements, job is offered to candidates/companies looking for employees within india)'),
  ('Jin Office Solution', 'https://www.jin.net.in/', 'Individuals and Businesses Seeking Ergonomic Office Solutions', NULL, 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Ergonomic Workspace Solutions', 'conclusions', 'Direct CTA', NULL, NULL),
  ('Kapil''s Salon', 'https://www.kapilssalon.com/', 'Beauty Service Seekers,\nPersonal Grooming Enthusiasts,\nAspiring Beauty Professionals', NULL, 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Beauty & Wellness', 'conclusions', 'Direct CTA', NULL, NULL),
  ('Vora Spice Mills', 'https://voraspices.com/', 'broad target audience covers both individual consumers and businesses that would use spices in cooking, food production, or retail', NULL, 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Manufacturer & Supplier', 'conclusions', 'Direct CTA', NULL, NULL),
  ('Infinzi', 'https://www.infinzi.in/', 'startups, SMEs, and growing businesses', NULL, 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Finance', 'conclusions', 'Direct CTA', NULL, NULL),
  ('Techmark', 'https://www.techmarkfze.com/', 'B2B Business', NULL, 'Niche', 'Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'Supplier & Dealer', 'conclusions', 'Direct CTA', NULL, NULL),
  ('GIIS', NULL, 'Parents', NULL, 'Niche', 'conversational, Academic, Informational, Professional', 'simple human friendly', NULL, 'third_person', 'natural keyword integration', 'education', 'conclusions', 'Direct CTA', NULL, NULL);
