How to Calculate Your Most Popular Post

By John Aberle | Small Business Management

Jan 20
Screenshot of spreadsheet for YCN Articles Sorted by Page Views per Day

Recently I needed to figure out which was my most popular post based on the number of page views it had garnered. You might think that is easy, that you just look at your traffic reports to see which post had the most visits. That would work if all of your posts were published on the same day or if your report covered only page views during a set period of time, like only during November 2013.

Screenshot of spreadsheet for YCN Articles Sorted by Page Views per Day

Fortunately, Yahoo! Contributor Network gives its writers a report of total lifetime page views. This is great because you get to see the popularity of an article over time. The only time such a report isn’t adequate is when you want to compare how popular articles are based on average page views per day. This is the way to level out the playing field.

For instance, if you have a post with 1,000 page views over the two years since you posted it, is that really a more popular post than one that got 400 page views in the six months since it was posted?

This spreadsheet calculates the days since published and divides them into the number of page views total to give you an average number of page views per day. Using it, ” First Person: Organization Chart Template for Small Business ” showed just over 15 page views per day during a period of 359 days. The second most popular article, “First Person: Guerrilla Marketing Ideas for Small Business,” had almost 12.5 page views per day in 86 days.

Screenshot of spreadsheet for YCN Articles Sorted by Page Views per Day

Notice the All-Time Views column in the screenshot above. The third most popular article had 2,523 total page views compared to the second most popular article’s 1,070 total page views. However, once you averaged them out based on the days since they were published, the third most popular only had 11.9 page views per day. You can read my original article on this topic First Person: Creating Small Business Measurement Worksheets in Excel where you can find additional suggestions for using this spreadsheet.

When making business decisions, measurements or metrics can give you incredible insights into what your customers really like. That’s why it’s important to also determine the average page views per day or product sales per day or revenue per day, not just the total numbers. If you track these numbers over a quarter or six months, you might find that the product with the greatest total sales is actually dropping in the averages. This could forewarn you of a change in customer tastes. Be careful, though, as tastes change seasonally so it might rebound.

Building your profits through strong relationships,


John R. Aberle, John R. Aberle, Aberle Enterprises

P.S.  Please +1, Like and Share

P.P.S. You can download this spreadsheet, template-to-analyze-ycn-articles.xls, ( if you want to calculate your own most popular post. Or you can use it to determine any average, like sales, between products that have been available for different numbers of days. 

Share and Enjoy:
  • Print
  • Facebook
  • Twitter
  • Google Bookmarks
  • Add to favorites
  • email
  • LinkedIn
  • PDF
  • RSS
  • Digg
  • StumbleUpon
  • Technorati
  • Tumblr

About the Author

My first Kindle eBook, How Relationship Selling Rewards Small Businesses, went live on April 24, 2012. I've lived a lifetime of service and spiritual search so it's natural for me to incorporate these attitudes into my work. I believe that selling and marketing are spiritual service when done with a heart-centered, relationship selling approach. All of business success comes down to building strong relationships.