Ecommerce Marketplace Performance Dashboard Agent

import requests, json, pandas as pd

API_STORE = "https://api.marketplace.com/v2/stores"

def fetch_marketplace_data(stores):
    results = []
    for s in stores:
        resp = requests.get(f"{API_STORE}/{s}/performance")
        results.append(resp.json())
    return results

def analyze_performance(data):
    df = pd.DataFrame(data)
    df["conv_rate"] = df["orders"] / df["traffic"] * 100
    df["avg_order"] = df["sales"] / df["orders"]
    trends = df.groupby("category")["sales"].pct_change() * 100
    return {
        "total_sales": round(df["sales"].sum(), 2),
        "total_traffic": int(df["traffic"].sum()),
        "avg_conv": round(df["conv_rate"].mean(), 2),
        "top_channel": df.loc[df["sales"].idxmax(), "channel"],
        "trends": trends.to_dict()
    }

report = analyze_performance(fetch_marketplace_data(["shopee","lazada","pgmall","tiktok"]))
print(json.dumps(report))