I recently took part in a challenge organized by Storytelling with Data to create a waterfall chart.
I rarely see this type of chart in digital marketing dashboards, if ever! The challenge wasn’t limited to data related to digital marketing but I wanted to find a use case for a waterfall chart in a digital marketing environment.
What is a waterfall chart
Waterfall charts are used to show how an initial value has increased or decreased by a number of values in between that lead to a final value. These intermediate values can either be time based or category based.
My challenge was not only to create such a chart for a digital marketing report but to also find real data.
A couple of years ago I started working with a client on their blog and content strategy. Since we started publishing content that is relevant but also targeting high volume search terms, their visibility improved significantly.
A Waterfall Chart To Visualize Online Visibility Improvements
This type of data is a great candidate for a waterfall chart that will show how the number of keywords ranking on the first page of Google has increased over a certain period of time.
Such data can also be visualized with a bar chart or even a line chart.
The use of a waterfall chart however will emphasize on the intermediate values or in this case the number of new keywords in high positions for the intermediate time period (each month in 2017).
With the inclusion of a takeaway title this visual turned into a great data storytelling example.
Here are a few other use cases for a waterfall chart to be used in digital marketing dashboards
- Newsletter subscribers at the start and end of year with their intermediate positive or negative numbers
- Number of external links at the start of a link building campaign and at its end
- Number of acquired leads for the duration of a paid media campaign
You can create a waterfall chart in Excel 2016 and other data visualization tools like Tableau. I used Excel 2013 and this tutorial.