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))