Projects using Google Sheets in CheshuntProjects using Google Sheets in CheshuntAd Network Publisher Dashboard
Automated publisher dashboard for ad network managing 5+ publishers with monthly revenue tracking.
Part of custom portal system where each publisher gets unique login to view their performance data. Dashboard shows ad requests, impressions, clicks, revenue, eCPM, and CTR with automatic updates from Google Sheets.
Features:
Performance scorecards (requests, impressions, clicks, revenue)
Revenue trends by ad type (Display vs Video)
Detailed performance table by publisher and date
Product-level revenue breakdown
This dashboard is part of a larger system with secure login portal (separate image). Eliminated 10+ hours/week of manual reporting for the client.
Tech: Google Looker Studio, Google Sheets, Cloudflare Pages
Delivery: 7 days (full system) 
