Ecommerce Affiliate Performance Agent

import requests, json, pandas as pd

API_AFFILIATE = "https://api.shopee.com/v2/marketing/affiliates"

def fetch_affiliate_data(month):
    resp = requests.get(API_AFFILIATE, params={"month": month})
    return resp.json().get("affiliates", [])

def analyze_performance(affiliates):
    df = pd.DataFrame(affiliates)
    df["roi"] = df["revenue"] / df["commission"] * 100
    df["rank"] = df["conversions"].rank(ascending=False)
    top = df.loc[df["conversions"].idxmax()]
    return {
        "total_affiliates": len(df),
        "total_conversions": int(df["conversions"].sum()),
        "total_commission": round(df["commission"].sum(), 2),
        "avg_roi": round(df["roi"].mean(), 1),
        "top_affiliate": top["name"]
    }

report = analyze_performance(fetch_affiliate_data("2026-06"))
print(json.dumps(report, indent=2))