Stats Tracking with Free Downloadable Spreadsheet!

Tweet
This past Monday the subject of the weekly Crafterminds chat was stats.  There are a lot of schools of thought on stats – follow them closely, don’t look at them at all, look at them occasionally… it seems like everyone has a different view on the subject.

image source

I will admit to checking my shop stats more often than really necessary (darn you, Craftopolis!).  Blogger also makes it entirely too easy to view blog stats, so maybe I swing on over to that Stats tab here and there.  But I promise, the serious number crunching only happens once a month!

I made an Excel spreadsheet a few months back to keep track of all of those numbers generated by running your own online business and blog, including blog stats, social networking numbers, and the fees and views associated with selling online and at fairs.  After that chat on Monday I thought maybe I should just share it with you guys!


 

There are 3 pages with a different set of numbers on each.  The first page is information on sales and fees.  I’ve set this page up with a section for two separate online shops (I have an abandoned Cargoh shop, which is another blog post) plus a general craft shows section.  The purpose of this page is to see what percentage of your sales is being spent on fees (there’s a formula already in the spreadsheet to calculate the percentage).





The second page tracks shop views, visits, and item information, again for two separate shops.  I get most of this info from Google Analytics.  I also have a formula in there to track the average views per item.





The last page is mostly social networking stats, plus a column for newsletter subscribers.  No formulas here, just a bunch of good ol’ numbers that I gather from a bunch of sources, including Google Analytics, my Facebook page, and Mail Chimp. 

I’ve filled in six months of stats with some made-up numbers so you can see how everything works.  Also, there’s space on each page to make notes on events that may have affected stats, like a giveaway or a bad craft fair. 

Want to try it out?  Download it here!



Make sure you come on back and let me know if you like it!

One Hundreds!

Tweet Yesterday was just a crazy day.  Evidently 100 was my lucky number, ‘cause it was all over the place!




I got my 100th (and then some!) sale in my Etsy shop!






I passed 100 rss feed and Google Friend Connect subscribers to the blog!





And I have 100 (actually, it’s now 102) bobaloo! facebook fans!

Whew, I’m tired just writing it!  I have been working hard the past week on promotion and it’s obviously paying off.  The Etsy sales are probably due to renewing twice a day last week, plus I listed a bunch of new stuff Sunday and Monday.  The jump in subscribers and Facebook fans probably came from the same two sources – the (very popular) post on making a Facebook landing page, plus the Crafterminds chat about Facebook yesterday.  Plus I shamelessly begged for Facebook fan #100 just so I could make it.

It’s really, really exciting, guys.  Seriously.  It feels like some serious validation - people like what I make and like reading about it.  I try really hard not to focus on numbers and just put out the best product I can, but it’s hard to not get excited about all those triple digits.



So it’s pretty fitting that I can send you all over to a giveaway!  Head on over to Another Day in Paradise where Larissa’s giving away a sweet bobaloo! goodie for either your little man or sweet princess!

THANK YOU, all of you, for being such great supporters and making starting my own little business worthwhile!

By the Numbers

Tweet One thing I love about running my business through the internet is the MASSIVE amount of stats available.  I looooove numbers and I pretty much obsessively check Craftopolis, Google Analytics, and Blogger Stats. For some reason, this week I have reached some big numbers, so let’s have some sharing time!

Number of Blog Followers through Google Friend Connect – 21!  I love each and every one of you lovely ladies (and my husband, who was the first).

Pageviews of the blog – just broke 5000!  That seems like such a huge number to me!  The tutorials I posted were both on One Pretty Thing, and that really boosted visits to the blog.  The Fancy Burp Cloth Tutorial is the most viewed page BY FAR on my blog.

Number of sales in my Etsy shop – 26!  I was excited to reach 20 on Monday, but then a had a few more sales Tuesday and Wednesday.  I’ve been listing new stuff like mad so I’m sure that has something to do with it.  I had my first repeat buyer this week, which is awesome! 

Pageviews in my Etsy shop – just over 12000!  Holy moly.  That makes my head spin.  Some big contributers to that number were being on the front page of Etsy in September and the giveaway going on at luvinthemommyhood (go over there and enter if you haven’t!).  Speaking of, if someone with a big blog offers to host a giveaway, DO IT.  Totally worth it for the number of people going through my shop this week!

Sweet Little Boys in my lap helping with my post – 1!  Isn’t he the cutest?  His big sister is at a sleepover, so it’s just the two of us this morning.  His doctor referred to him as a toddler yesterday.  He may be walking, but I am still insisting he’s a baby.

Have a great weekend!  I have a meeting tomorrow that will hopefully result in some good news – I’ll fill you in Tuesday.  Oh, and don’t forget about my gift card giveaway!