1%Club
1% Club runs marketing across multiple channels and ad-accounts. The marketing team has to collate 15-25 reports everyday.
This was happening entirely through spreadsheets and manual entry leading to 2-3 hours of work everyday for the team.
AhaInsights created custom scripts and processes to bring this down to 15 minutes a day, and added dashboards to make data accessible for all.
Objectives
Automate reporting
Eliminate daily manual effort spent on data collection and report generation
Custom processes
New channels/accounts are added every month. The solution should be flexible and the marketing team should be able to manage it.
Dashboard it
Make data accessible to a wider team without going through a reporting bottleneck
AhaInsights Solution
Custom automation tool
Marketing team downloaded marketing reports daily and uploaded them to a folder. The rest was automated.
Data validation
Used Google Script automation to pick up marketing reports from Drive and validate them (column checks, data types, duplicates).
Spend verification
Added multiple layers of verification so any errors are caught before data is saved to database.
Ease of update
Created a Control Centre for managing configurations, so new data sources can be added without touching code
Results
Peace of mind
Team is able to save time while closely monitoring the data as it gets uploaded.
Low error rate
Data errors reduced through automated validation before storage
Self-serve without bottleneck
The operations team can now self-serve via Looker Studio.
Hours saved everyday
Reporting team recovered hours of daily work previously lost to manual data entry