Background & Process
Clients' pain point was lack of visibility on £100k+ per month marketing spend leading to the inability to optimize marketing
Created reports required to ensure all KPI segments and metrics were captured across all marketing channels
Manipulated data in Tableau & with SQL to aggregate data for cross-channel comparison
Built automated Tableau dashboards producing charts for reporting documentation
Created weekly reports doc where charts were exported charts and analysis was fed back to the client
OUTCOMES
Reduced Social Creative & Copy from 20 to 5 Variations with 20% conversion increase
Cut reporting time in half from 4 days to 2 days
Marketing reporting transformed with best-in-class data visualisation & insight
