While 5 years ago, we may have said we predominately worked with ecommerce clients, our portfolio has evolved to include Liquid Galaxy clients and many non-ecommerce sites as well. With the inspiration from reading through these recent posts, I decided to share some updated stats.
Do you remember my post on Wordle from early 2011? Wordle is a free online word cloud generator. I grabbed updated text from 2013 and on from our blog, using the code included in my original post, and generated a new word cloud from End Point blog content:
End Point blog Word cloud from 2013 to present
I removed common words from the word cloud not removed from the original post, including "one", "like", etc. Compared to the original post, it looks like database related topics (e.g. PostgreSQL) still have strong representation on the blog in terms of word count, and many other common developer words. Liquid Galaxy now shows up in the word cloud (not surprising), but many of the other technology specific terms are still present (Spree, Rails, Bucardo).
I also took a look at the top 10 blog posts by page views, as compared to this post:
- Streaming Live with Red5 Media Server
- API gaps: an Android MediaPlayer example
- Streaming Live with Red5 Media Server:Two-Way
- Using cec-client to Control HDMI Devices
- MySQL and Postgres command equivalents (mysql vs psql)
- RailsAdmin: A Custom Action Case Study
- Git Workflows That Work
- Increasing MySQL 5.5 max_connections on RHEL 5
- Restoring individual table data from a Postgres dump
- Using ln -sf to replace a symlink to a directory
The page views are not normalized over time, which means older blog posts would not only have more page views, but also have more time to build up traffic from search. Again, this list demonstrates qualitatively the broad range of topics for which our blog is popular, including both very technology specific posts as well as general development topics. I also suspect our traffic continues to attract long-tail keywords, described more in this post.
Finally, back in October, I visited End Point's Tennessee office and got into a discussion with Jon about how we define our services and/or how our business breaks down into topics. Here's a rough chart of what we came up with at the time:
How do End Point services break down?
Trying to explain the broad range and depth of our services can be challenging. Here are a few additional notes related to the pie chart:
- Our Liquid Galaxy work spans across the topics of Hardware & Hosting, Cloud Systems, and Databases.
- Our Ecommerce services typically includes work in the topics of Backend & Client Side Development, as well as Databases.
- Our development in mobile applications spans Backend & Client Side Development.
P.S. If you are interested in generating word statistics via command line, the following will get you the top 20 words given a text file:
tr -c '[:alnum:]' '[\n*]' < some_text_file.txt | sort | uniq -c | sort -nr | head -20