Showing posts with label tests. Show all posts
Showing posts with label tests. Show all posts

Monday, July 25, 2011

Analyzing My Sales

As promised I have put together an analysts of my etsy sales. I have also put together a way for us to walk through it together.Okay. I wanted to put together my sales data from etsy to see if there were any trends in sales so I could focus my energy.

In putting together my information, it was important that I keep certain things in mind.
1. The massive wholesale order I received was mainly Scarflets and cowls
2. The consignment shops took mostly scarflets, but with no preference on color. The cozy cable scarflets also seemed to sell extremely quickly in a sticks and bricks store.
3. I did not create even numbers of each product that I offered.

Here is what I found out about my etsy store.
  • I sold 25 scarflets, 17 Cowls, 3 patterns, 20 coffee cuffs
  • 16 of the scarflets were in the Lattice Pattern and 12 were Braided
  • I sold 5 Hogwarts House Scarves (before I stopped making them)
  • The colors were as follows
  • 18 - Green
  • 10 - Purple
  • 10 - Red
  • 6 - Gray
  • 6 - White/Cream
  • 4 - Blue
  • 2 - Brown

Here is how I did it.

1.) Download your CSV Files. (Shop Settings - Options - Download Data)
2.) Import them in to a Google (Or Excel) spreadsheet

3.) Copy all of the Item Names and paste them in a Word Documents (you will want to use Microsoft Word)

4.) Go to the toolbar, click edit and then Find. Once the window pops up type in a specific word. (Ex. Scarflet, KeyFAB, etc.)

5.) You will see in the pop up window the number of times your search word was located.

6.) Collect all of your data and proceed to analyze.

I hope this helps you with your shop stats.


Go forth and Analyze!

- LB

Wednesday, July 20, 2011

Knitting in July

It is that time of the year again. When I pull out my needles and get down to business. Despite the fact that the heat index says that it is 104 outside, I am knitting. Do not let me fool you, I love knitting. I love designing new items and thinking about how I am going to sell them. Who might buy them and whether they will have a remarkable moment (first kiss, reunite with an old friend, visit their first Dooney & Bourke flagship store) while wearing it. However as I knit, it is unbearably hot in the the midwest. I wish I had a pool. Like an adult size kitty pool. You can knit and swim right?

I digress. This post is about analyzation. I recently read a blog post (I try to read 3 post a day, everyday.) written by a woman who realized that here most popular etsy item (the one that landed in all of the treasuries and had hundreds of hearts) was not her best selling one. In fact, her best selling item was rarely listed in treasuries and was more expensive. That is when it struck me, I have not analyzed what the best selling items in my shop are.

I am now on a mission. I am going to actually download my Shop Stats (go to your Etsy page and look under orders) and go thru item by item to figure out what I sold the most of and try to figure out why.

Wish me luck friends, this might suck. I will, however gain some much need knowledge of my store.

As always I will share the details of my quest.


Go forth and Swim!


- LB

Tuesday, June 21, 2011

Love Letter: craftopolis.com

So this is a new series that I would like to introduce on my Blog. There are a couple sites that I use everyday and I think that every etsy seller should know about. Things that have made my life easier, or at least taken a little bit of mystery out of this thing called the internet. Today's Love Letter is to and here is why.

Craftoplis is a fantastic site that allows you to do a couple of things that other sites don't. It connects to your google analyitcs as well as etsy to grab tons of information. However, my favorite

Tag Reports -
What are tag reports you ask? They are records of what people searched for on Etsy that brought up your items. Fantastic, I know. You can look at tag reports for 60 days - 30 days - 7 days - Yesterday and Today. I would be lying if I said I was not completely obsessed with this feature. It will also give you the search terms that they used. For example I just listed Lowla's Library and I can see that someone searched for Kindle Book Cover and one of mine came up on page 11.

I have also learned (some of you may already know this) that the title of your item also counts in etsy's tags. So, it might not be the best use of Tags to double up on things that are already in your title. This site has been amazingly helpful.

Go forth and explore it for yourself. It is a blast.

-LB

Friday, September 24, 2010

A Test

It is 10:45p (way past my geriatric bedtime) on a Friday night in Chicago and I have made a choice to test the etsy showcases.

Last weekend I participated in two craft shows. I did fairly well considering that I sell mostly winter items. I has about 30 sales over the to shows. Which is lower then I normally have Nov-Jan, but still good. It is pretty common for me to have between 15-30 sales in one show. Now here comes the crux of this entire post.

I only have 25 sales on etsy. Period. That does not seem right. It can only mean that I am not reaching my target audience or the etsy market is saturated with similar items. Possibly both.

My new goal is to boost my etsy sales by testing out some theories/hopes of mine. Instead of doing one of my intended craft show in the Chicago burbs this October. I am going to take that $60 registration fee (I know, right.) and spend it on etsy showcases. Once a week for all of October.

You might be thinking to your self. "Laura you always say that showcases never lead to sales, and end up questioning whether or not it was a waste of money." That is true, I do. However, this month I will put that theory to the test.

So, that is why I am away at 5mins to 11p poised over the Accessories Showcase. Wish me luck.

As always I will keep you posted.

-LB