电子商务 代金券 战略 代理

import requests, json, pandas as pd

API_VOUCHERS = "https://api.ecommerce.com/v2/marketing/vouchers"

def fetch_voucher_report():
    resp = requests.get(API_VOUCHERS, params={"status": "active"})
    return resp.json().get("vouchers", [])

def analyze_vouchers(vouchers):
    df = pd.DataFrame(vouchers)
    df["roi"] = (df["revenue"] - df["discount_cost"]) / df["discount_cost"]
    avg_roi = df["roi"].mean()
    best = df.loc[df["roi"].idxmax()]
    return {
        "active_vouchers": len(df[df["status"] == "active"]),
        "avg_roi": round(avg_roi, 2),
        "total_redemptions": int(df["redemptions"].sum()),
        "best_voucher": best["code"],
        "total_discount": round(df["discount_cost"].sum(), 2)
    }

report = analyze_vouchers(fetch_voucher_report())
print(json.dumps(report))