Back to Projects
Automated PPC reporting for a multi-client agency.
Problem
Manual reporting cycles consumed hours each week and delayed client updates.
Approach
Unified data sources, automated narrative summaries, and generated report packs.
Impact
Cut reporting time by 80% while improving consistency.
What I Built
- Built a unified data ingestion layer pulling from Google Ads, Meta Ads, and Google Analytics APIs into a normalized schema.
- Implemented LLM-powered narrative generation that transforms raw metrics into client-friendly performance summaries.
- Automated weekly report pack generation with branded PDF output, trend analysis, and actionable recommendations.
- Created a scheduling system that runs report generation overnight and delivers results before client morning meetings.
- Reduced weekly reporting overhead from 6+ hours to under 1 hour across a portfolio of 20+ clients.
Technologies
PythonAPI IntegrationsData AutomationAI/LLM