Affiliate Revenue Lookup
Find users with affiliate.code, get their orders where status == "completed", and sum amountUSDC. Cache-first to minimize reads.
Lookup
Total Revenue
USDC Amount
—
Statistics
Enter an affiliate code and calculate to view statistics