Unified Marketing Reporting Template
This project demonstrates how multi-source marketing and donor data can be consolidated in Google Sheets before full BI integration, then surfaced through a stakeholder-facing Looker Studio layer.
What it includes
- Source tabs for social, web, email, and CRM-style data.
- A KPI dashboard structured across the marketing funnel.
- Weekly and monthly reporting views for non-technical teams.
- Data quality checks, governance notes, and Looker-ready tabs.
Why it matters
- Shows Google Sheets as an interim analytics operating layer.
- Demonstrates KPI structure, not just dashboard decoration.
- Bridges raw reporting work and executive-level visualization.
- Fits roles where teams need useful reporting before formal BI maturity.