This dashboard allows the user to easily view marketing metrics in 17 different countries and 14 page types.
An automated email containing a summary of performance is sent out daily.
The user can create PDF versions of the charts with one click.
Tools used: Excel, VBA, SQL
The many filters the user can change are:
1. 17 country/regions
2. 10 different marketing metrics
3. Moving average calculation (1,7, or 30 day averages)
4. Search engine (include/exclude via checkboxes)