Support Channel → Persona Pain Points

import os, requests, time

SL_TOKEN = os.environ["SLACK_BOT_TOKEN"]
SL_BASE = "https://slack.com/api"
SL_H = {"Authorization": f"Bearer {SL_TOKEN}"}
MV = os.environ["MAVERA_API_KEY"]
MV_BASE = "https://app.mavera.io/api/v1"
MV_H = {"Authorization": f"Bearer {MV}", "Content-Type": "application/json"}

CHANNEL_ID = "C0123SUPPORT"  # Replace with your #support channel ID
DAYS_BACK = 14

# 1. Fetch support channel
oldest = str(int(time.time()) - DAYS_BACK * 86400)
messages = []
cursor = None
while True:
    params = {"channel": CHANNEL_ID, "limit": 200, "oldest": oldest}
    if cursor:
        params["cursor"] = cursor
    r = requests.get(f"{SL_BASE}/conversations.history", headers=SL_H, params=params)
    data = r.json()
    if not data.get("ok"):
        break
    messages.extend(data.get("messages", []))
    cursor = data.get("response_metadata", {}).get("next_cursor")
    if not cursor:
        break
    time.sleep(1)

tickets = [m for m in messages if m.get("type") == "message" and len(m.get("text","")) > 20]
print(f"Support input: {len(tickets)} (past {DAYS_BACK} days)")

# 2. Build corpus
corpus = "\n\n".join(
    f"[msg-{i}] {m.get('text','')[:400]}"
    for i, m in enumerate(tickets[-80:])
)

# 3. Mave categorization
analysis = requests.post(f"{MV_BASE}/mave/chat", headers=MV_H, json={
    "message": f"Customer support analyst. Categorize these {len(tickets)} support messages by PERSONA TYPE and PAIN POINT.\n\n"
        f"MESSAGES:\n{corpus[:8000]}\n\n"
        "PERSONA TYPES to identify:\n"
        "- Enterprise Admin (manages team accounts, SSO, billing)\n"
        "- SMB User (small team, price-sensitive, self-serve)\n"
        "- Developer (API, integrations, technical issues)\n"
        "- End User (uses the product daily, UX issues)\n\n"
        "For EACH persona:\n"
        "1. Pain points (ranked by frequency)\n"
        "2. Emotional intensity (1-10)\n"
        "3. Representative quotes (exact words from messages)\n"
        "4. Suggested marketing response (how to address in copy)\n"
        "5. Feature request signal (what product change would help)\n\n"
        "End with a PRIORITY MATRIX: persona × pain point × urgency."
}).json()

print(f"\n{'='*60}\nSUPPORT PAIN POINTS BY PERSONA\n{'='*60}")
print(analysis.get("content", "")[:3000])