Q2 Stats Wrap Up
July 2, 2009 • JP • No Comments • Rate This Article
• Links to this article
Quarter 2 of this year has passed, and here are the highlights of the last three months.
Visits
The site had 800 visitors on June 25th, the most for a single day this past quarter, and seems to be consistently producing numbers in the mid-600 to 700 range on a daily basis. There was a slight drop in overall traffic when I switched the main site to use WordPress as a CMS, but finally seems to be recovering in the last week or so.
The VBA Search Engine hit 400 sites (become a volunteer contributor), and we're very close to 200 blog posts and 800 feed subscribers.
As usual, the most popular pages were the blog homepage, the Excel page and the Outlook page.
There were 36 posts and 59 comments/trackbacks (half of the comments were me, I think).
Thanks to Dick's blog, the Random Data Generator was by far the most popular page this past quarter. The Add-Ins page was also very popular during this time.
Top Referral Sources:
I'd to thank and send some link love to the following sites that top out the list of referring sites for Q2:
- Excel VBA Macro – a wonderfully keyword-loaded URL with a useful blog.
- Chandoo and Pointy Haired Dilbert
- John Walkenbach's Spreadsheet Page
- Debra Dalgleish and her Contextures blog
- Jon Peltier's PTS Blog
- Daily Dose of Excel
- NewtonExcelBach
- Excel Guru Ken Puls
Plus some new friends at accessclub.jp and utteraccess.com, who seem to be paying visits more frequently. I attribute that to the Access code samples I've been posting.
Add-Ins
To save bandwidth, I've moved the add-ins to Amazon's S3 service. The download traffic was extremely high last month, so I also decided to move all the images to Photo Bucket. It seems to be working, and the site is faster with PHP compression (take that, mod_deflate!). So much so that I was able to turn off WP-Super Cache. (I don't think I configured it properly anyway.) If I see the bandwidth being abused again (especially the zip files, which third party download sites love to link to), I may move the files back here, and simply block any access to zip files if there's no valid referrer from this site.
The add-in download traffic was brisk, both from here and from download.com. Here is the breakdown. Next quarter it won't be accurate, since Amazon S3 doesn't show you which files were downloaded.
April add-in downloads
- Random Data Generator – 441 downloads
- Post To Twitter – 250 downloads
- ShipTrack (and UI) – 127 downloads
- Data Filter Tool – 298 downloads
- SheetPicker – 108 downloads
- Amazon Ad Link Generator – 29 downloads
- Bingo Number Generator (.NET version) – 5 downloads
May add-in downloads
- Random Data Generator – 340 downloads
- Post To Twitter – 117 downloads
- ShipTrack (and UI) – 138 downloads
- Data Filter Tool – 159 downloads
- SheetPicker – 56 downloads
- Amazon Ad Link Generator – 29 downloads
- Bingo Number Generator (.NET version) – 4 downloads
June add-in downloads
- Random Data Generator – 217 downloads
- Post To Twitter – 94 downloads
- ShipTrack (and UI) – 114 downloads
- Data Filter Tool – 106 downloads
- SheetPicker – 21 downloads
- Amazon Ad Link Generator – 19 downloads
- Bingo Number Generator (.NET version) – 11 downloads
Visit the Add-Ins page to download any of these Excel add-ins.
Other News
Several DMCA complaints were successfully filed with ISPs that hosted download sites that for some unknown reason felt very comfortable taking my add-ins without asking and putting them up for download on their own sites. The site owners, who live in Hungary, China, and other eastern locations, choose to host their sites in the U.S.A., where we have laws against that. A few form letters, combined with a few .htaccess tweaks, should prevent any more incidents.
Coming soon (read: six months) I'll have a standalone version (VB .NET) of the Random Data Generator which will export to Excel/Access/CSV and be available for purchase.
Stats Mania!
Seems everyone's getting into the stats mood. My timeline might be wrong, but I believe Chandoo started it, then J-Walk posted his, then Dick, then Jon.
Best month ever
Visitor Stats
June Stats
Web Stats – June 2009
And Debra from Contextures also posted hers.
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: List matching files in a folder, part two
Next Post: Need Ribbon help? You're not alone.
@JP.. seems like a good quarter. I am sure your site would scale new heights consistently and provide exciting content.
Thanks Chandoo!