I've been using it for two years now. It's given me clarity on how much I've been selling week by week. I can see on what days people have been buying stuff. I have gratitude that I have been selling regularly. It's also made me conscious of how things are going for the shop.
All this from just a simple little spreadsheet.
But just tracking isn't enough. You have to know where you're going. So I set an audacious goal. Audacious, but hopefully achievable. What this does for me is enable me to really know how well I am doing from week to week, how close I am (or not) to reaching my goals. And then I can adjust accordingly.
So without any further ado:
Download the Etsy Goal Spreadsheet for 2011
Here's how you use it.
First, add your sales goal (where you'd like to be, sales wise at the end of the year) in the cell below the GOAL cell. (I've put 500 in randomly, but change it to whatever your goal is.)
The first column has weekly dates in it. Along the top are the days of the week. Enter how many sales you've had on any given day. They'll automatically subtract from the Left to Go cell. That's it!
Notes:
* Feel free to share & change this willy nilly, but please let people know you found it at http://absolutelysmall.com/blog
* This spreadsheet is an .xls file. In other words, it's made to be opened with Excel, but can (hopefully) also be opened by a number of other programs. (Numbers, Open Office, etc.)
* It may be titled Etsy, but of course this spreadsheet would work equally well for Artfire, your own site, or whatever else it is you need to track.
*1/1/11 - The dates have been corrected. However, dates pulling up as #### has been reported. This is not a spreadhseet error. Simply widen the column to make those pound signs go away.
(Thank you Chrystal S & Madeline from the comments for pointing this out!)
27 comments:
[...] This post was mentioned on Twitter by Claire. Claire said: The Etsy Goal Spreadsheet for 2011 is here! http://bit.ly/fnRPSs [...]
Oooh, this is great! I'm working on a blog post for Thursday about setting goals, so I'll be adding this in. Thanks for sharing!
Thank you so much for making this! I used the 2010 one and loved it! It was rather interesting to see when I was really busy, but seeing the dry spells sometimes can be a little discouraging. xD I did reach my goal of 200 sales though and got 50 more! Woohoo! :D Here's to a great 2011!
Thank you so much for sharing this brilliant tool! I just read your post on the Etsy forums about it and popped by. Tracking goals is a great way to stay focused and this sheet will help me to see the days that are busy and ones that are less so.
Thanks again.
Great little tool! I've downloaded it and will be linking to it in a blog post later this week as well. Thanks!!
Thanks for the post..I saw this some time ago..maybe the 2010 version and forgot about it...well now its on the desktop:)
I downloaded, and will share on FB business page...now I just need to make myself use this....the computer should kick out a treat if I fill in a column...don't you think?
I'll try it out, thanks. Shared on Twitter and Facebook. :)
Thanks for making this spreadsheet! I set a lofty goal but I am going to give it a whirl!
Thank you, this is such a great tool!
ok, I'll give it a try.
thank you for this. i hope that you reach your goal & above for sharing this with us!!may the universe reward you with what you want.
Thank you so much - I'm planning to open up my ETSY store this year so this will help loads!
Thanks. Downloaded it and will try to use this tool in 2011.
thank you so much! I love this idea and look forward to seeing how I do this year.. you rock!
Thank you soooo much for sharing this spreadsheet. It is EXACTLY what I need to start the year off on the right foot. Love it!
Thank you so much, I love statistics and will give this a really good go.
I'm going to try this out and then recommend it to all my team. Thanks for sharing! :)
Brilliant! So kind of you to share this!
Thank u so much for sharing !
This is very cool! Thank you so much for sharing! You are awesome! :)
As for the # #### coming up in the date column, the column just needs to be a little wider... Works like a charm!
Thanks again!!! :)
Thanks so much for making this! I can't wait to try it out! And also, fyi, when dates come up as ######, all you have to do is widen the column.
Brilliant - thank you!
THANK YOU Chrystal & Madeline! I knew there had to be a simple explanation not related to the coding. :)
Thank you so so so so much! This was an extremely useful tool for me in 2010. Felt so good about almost reaching my little goal! This year, I intend to aim a LOT higher! :D
Goddess bless you for sharing such a lovely gift with all of us! :)
Thank you so so much! I love having something to motivate and record my sales, but generally I'm too impatient to make my own spreadsheet! This is perfect.
This is great, thanks for sharing!
Post a Comment