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