Reporting automation for multi-channel attribution without data engineers
Our marketing team pulls from Google Ads, Meta, LinkedIn, GA4, and HubSpot every Monday. It takes a full day to stitch UTMs, clean joins, and build the exec deck. We tried Looker but our schemas change and engineering is backlogged 2 months.
I need to define KPIs once, have it pull from all sources nightly, handle name mapping, and send a clean PDF plus Slack summary at 7am. If a data source fails, alert me instead of sending a broken report. When a stakeholder asks for a new metric, I want to add it without rewriting SQL. Is anyone automating reporting end-to-end without a data team?