Competitive Displacement Tracker

import os, requests
from collections import Counter

SF   = os.environ["SALESFORCE_INSTANCE"]
SF_T = os.environ["SALESFORCE_ACCESS_TOKEN"]
MV_K = os.environ["MAVERA_API_KEY"]
SF_H = {"Authorization": f"Bearer {SF_T}"}

opps = requests.get(
    f"https://{SF}/services/data/v66.0/query", headers=SF_H,
    params={"q": "SELECT Name, StageName, Amount, Competitor__c, Description FROM Opportunity WHERE Competitor__c != null ORDER BY CloseDate DESC LIMIT 100"},
).json()["records"]

comp_deals = {}
for opp in opps:
    comp = (opp.get("Competitor__c") or "").strip()
    if comp:
        comp_deals.setdefault(comp, []).append(opp)

for comp_name, deals in sorted(comp_deals.items(), key=lambda x: -len(x[1]))[:5]:
    won  = [d for d in deals if d["StageName"] == "Closed Won"]
    lost = [d for d in deals if d["StageName"] == "Closed Lost"]
    deal_ctx = "\n".join(f"- {d['Name']} ({d['StageName']}): {(d.get('Description') or '')[:120]}" for d in deals[:10])

    prompt = f"""Generate a competitive battle card for {comp_name}.

CRM DATA: {len(deals)} mentions | Won: {len(won)} | Lost: {len(lost)}

DEAL CONTEXT
{deal_ctx}

Produce: 1) Overview 2) Their strengths 3) Their weaknesses (where we win) 4) Common objections 5) Killer questions for reps 6) Landmine questions to watch 7) Why customers switch to us"""

    card = requests.post(
        "https://app.mavera.io/api/v1/mave/chat",
        headers={"Authorization": f"Bearer {MV_K}", "Content-Type": "application/json"},
        json={"message": prompt},
    ).json()

    win_rate = f"{len(won)}/{len(won)+len(lost)}" if (won or lost) else "N/A"
    print(f"\n{'='*50}")
    print(f"BATTLE CARD: {comp_name} | Mentions: {len(deals)} | Win rate: {win_rate}")
    print(f"{'='*50}")
    print(card.get("content", "")[:800])