I have been Writing blogs on medium for a while. I do post blogs now and then, So it’s not a lot. Since medium does not provide a full blown tool to see my stats, I was curious to find out more insight on it. I recently got onboard with tableau and seem to be loving it. Let’s Start.
Click here to See Full Project
Data
We need data and Medium wasn’t giving away my story stats. Well there is a workaround for everything! Esteban Pintos was gracious enough to code and provide a small JavaScript, which we need to run on our browser console (Available in developer tools). In a click the csv file will be downloaded.
Here is the code of Esteban Pintos to download your medium stats
Well, the data had a error
The Column Name was not correct
So, I jumped into R and opened the dataset, added the column names and exported the csv file back to start on Tableau.
Here is the Dataset Description, if you would like to know more about the column fields.
Analysis
Some of my Blogs sky rocketed with views while others rarely made it to 100s. Thus I also had to take this into account as a outlier due to the deviation of its position far away from the average value. I started off with a Box Plot
There was my useful to the extreme Left of the graph and one outlier stretching the whole graph to reach the other end making it barely visible to read. There were few more outliers accompanied with it too.
And now we have a better picture once the outliers are gone.
Note : The images included are Screenshots so if it seems to you that it doesn’t look big enough, please click here to view in the Interactive Tableau Visualization mode.
Based on the Box plot the views starting from 0 maxed out till 130. Most of the data points were inside this range. Let’s see a detailed form of this data
We can see with the help of bar plot that “Import That” Blog has 130 views and “It’s Killing me” Being the Least.
Of course views means that your blog was in front of some persons eye. The real gem would be when the person would open and read it and finds it useful. Medium went a extra step ahead on this and added a Data Point to record the amount of the context that people read from the blog. It’s a Blackbox for us and we do not know the details of it’s metrics, But it’s there to provide something which you can base your decisions on.
Let’s see how is the conversion from View to Read is going on
We have Reads on the Y axis and Views on the X axis and the data beautifully spread in a condensed and then relaxed manner.
This plot is denoting Low Positive Correlation.
At least did those whoever read the blog, Found it useful or finish it? Let’s find out..
It is now difficult to say if it is increasing or decreasing. There is no Correlation among the data points and its the reason they choose to spread themselves throughout the graphs.
This was a sweet short Visualization. Click here to use Interactive Visualization Tool
Also Read
