import sys
sys.stdout.reconfigure(encoding="utf-8", errors="replace")
import pandas as pd
p = r"C:\Users\Alaa_S\Downloads\1794578751304998581-orders-2026-11-13.xlsx"
df = pd.read_excel(p, dtype=str)
print("rows:", len(df), "| unique IDs:", df["ID"].nunique())
df["dt"] = pd.to_datetime(df["CreatedAt"], errors="coerce")
print("range:", df["dt"].min(), "->", df["dt"].max())
print("\nUTM Source:")
print(df["Utm Source"].fillna("(فاضي)").value_counts().head(8).to_string())
print("\nUTM Campaign top:")
print(df["Utm Campaign"].fillna("(فاضي)").value_counts().head(8).to_string())
print("\nStatus:")
print(df["Status"].value_counts().head(8).to_string())
print("\nphones sample:", df["Phone"].dropna().head(3).tolist())