Visualize the data

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Requirements of the dashboard

Must be easy to understand
- Be understood by a broad range of audiences
Contain key metrics
- Only the important metrics that are often used in making key decisions
It must get to the point, while still delivering important information

example dashboard

example dashboard

Filter with a dropdown

example dashboard

_Filter with a dropdown _

Include the filtered table

example dashboard

_Filter with a dropdown _

_Include the filtered table _

Add a pie chart to percent make up of impressions

doughnut chart

example dashboard

_Filter with a dropdown _

_Include the filtered table _

_Add a pie chart to percent make up of impressions _

View campaigns with a stacked column chart

bar chart

example dashboard

_Filter with a dropdown _

_Include the filtered table _

_Add a pie chart to percent make up of impressions _

_View campaigns with a stacked column chart _

Analyze cost with a bubble chart

example dashboard

Marketing Analytics in Google Sheets