The first post I wrote for this blog was on Bubble Charts in Excel with a video of how to create one and how you can use it in digital marketing reports. For the #SWDChallenge for October 2018 I explored the scatter plot graph and how it can be applied to visualize data for a digital marketing report or project plan.
Here is what I learnt from these exercises:
- Bubble chart is best used when you have a few categories to compare or you want to add a third value to be represented by the bubble size
- Scatter plots are great to analyse a large group of categories and look at a cluster rather than an individual category. Scatter plots also would only compare two values.
Below is a keyword research analysis for search terms related to dresses.
This is great data to support digital acquisition strategies and plan PPC and SEO programs.
This scatter plot looks at keyword search volume and keyword difficulty to rank in organic search results.
Does keyword search volume impact keyword difficulty to rank in Google Organic Search results
– Most search terms related to dresses have below average search volume and very high keyword difficulty to rank in Organic search
– There are several search terms that have below average but still high search volume with very low keyword difficulty
– No search terms have very high search volume and low keyword difficulty for organic search rankings
This second scatter plot graph looks at keyword search volume and cost per click for paid search results.
Does keyword search volume impact Cost per Click for Google Paid Search results
– Most search terms related to dresses have below average search volume and low cost per click
– Only four search terms that have significantly high search volume have low cost per click
– No search terms seem to have high search volume and high cost per click