Description
This Python-based tool fetches marketing campaign data via REST APIs from Google Analytics, Facebook Ads, and email platforms. It merges datasets using UTM parameters and campaign IDs, then applies ROI and attribution models to allocate revenue. The script generates an Excel report with interactive charts, campaign performance tables, and cost-per-acquisition metrics. A parallel PDF summary highlights top-performing channels and suggests budget reallocations. Users can customize date ranges, attribution windows, and output themes through a YAML config file. Built-in error handling retries failed API calls and logs issues for review. Integration with AWS Lambda and CloudWatch means you can schedule daily or weekly runs with minimal overhead. Comprehensive documentation includes API setup steps, OAuth configuration, and sample output examples. This automation frees marketing teams from manual CSV downloads and disparate analytics consolidation. Ideal for digital marketers, growth hackers, and data-driven CMOs.
Instant download
API integration, data merging, attribution modelling, report creation, serverless scheduling
Digital product – Python script bundle with API connectors
Marketing analysts, digital marketing teams, CMOs
