Finding RSS Subscriber Counts Through Apache Logs

If you’ve declined to use a service like FeedBurner to handle your RSS feeds, you might wonder how many subscribers you actually have. This also works well for finding subscriber counts to specific categories or comment posts on your site, which you typically wouldn’t run through FeedBurner.

It turns out that most of the bigger feed readers like Google Reader and Netvibes will actually show you the count during the request for your feed. All you have to do is take a peek inside your access log files.

First you’ll need to locate your apache logfile, which is normally called access_log or access.log. The location for this file will vary greatly based on distribution and your hosting provider. Here’s a couple of places to start, but you might have to look around.

Ubuntu default:

   /var/log/apache2/access.log

MediaTemple DV default:

   /var/www/vhosts//statistics/logs/access_log

Dreamhost default:

   ~/logs//http/access.log

Now that you’ve found the logfile, it’s a simple matter of running it through grep for the keyword “subscribers”, which most of the feed readers use to show the subscriber count. You could just use the simplest command:

grep -i subscribers access_log

Or, if you wanted to find the subscribers for a particular feed, you could run it through a second grep to restrict to just that rss feed.

grep -i subscribers access_log | grep -i ‘/howtogeek/feed/’

Here’s an example of what that brings back on my personal blog (which I should really update more)

209.85.238.9 – – [28/Aug/2007:06:08:23 -0700] “GET /howtogeek/feed/ HTTP/1.1” 302 572 “-” “Feedfetcher-Google; (+http://www.google.com/feedfetcher.html; 52 subscribers; feed-id=13671896334760112923)”
193.189.143.237 – – [28/Aug/2007:06:12:32 -0700] “GET /howtogeek/feed/ HTTP/1.0” 302 535 “-” “Netvibes (http://www.netvibes.com/; 2 subscribers)”
64.78.155.100 – – [28/Aug/2007:06:14:40 -0700] “GET /howtogeek/feed/ HTTP/1.1” 302 535 “-” “NewsGatorOnline/2.0 (http://www.newsgator.com; 2 subscribers)”

Note the bolded text that shows I have all of 56 subscribers from those three online feed readers. Mysticgeek has a lot more from Google alone:

209.85.238.9 – – [28/Aug/2007:05:57:25 -0700] “GET /mysticgeek/feed/ HTTP/1.1” 302 568 “-” “Feedfetcher-Google; (+http://www.google.com/feedfetcher.html; 111 subscribers; feed-id=5433036316661303107)”

Perhaps I should take a cue from him and start updating my personal blog… but then I would have less time for writing articles.

More stories

Calling All Who Dislike Explorer “Bread crumbs” In Vista

I personally cannot stand the “bread crumb” toolbar Microsoft makes us use as a default.  I really wish this was an option to enable or disable.  I see a lot of praise for this new feature with people saying “it makes navigation extremely fast” … Am I alone here?  Am I the only one who sees no

Configure AutoArchive In Outlook 2007

In a previous article we showed you how to quickly clean out your inbox.  Here we will show you how to have more control over what is kept and what is not.  Let’s look at a way to archive the older items so your inbox is not so cluttered up.

See All Processes During Windows Startup Using Autoruns

A very cool utility to analyze and keep track of everything running on your computer during startup is Autoruns.  This handy little utility displays everything running on your computer when you start up.  Sure you can use the built in utility in Windows “msconfig” however your not getting the full

Upgrade Your Live Bookmarks With LiveClick

If you like to subscribe to feeds using Firefox’s Live Bookmarks feature, the LiveClick extension gives you so many upgrades that I can only cover the highlights of how great it is.

Make Monday Not Suck: Flow

I am starting a new Sunday feature where I will post something cool for you to keep on hand so your Monday doesn’t suck.  For lack of a better title the feature is called “Make Monday Not Suck”  I am going to feature something to do on your PC while at work.  So when the boss is breathing down your

Why Doesn’t AutoComplete Always Work in Firefox?

If you’re the type of person that always allows Firefox to save your login credentials for the sites you visit, you might be very frustrated when you come across a site that doesn’t even prompt you to save the credentials. We’ve got the lowdown on what’s going on here.