Interpreting your RedBubble Sales CSV in Google Sheets

I’m going to show you one way to interpret your CSV file from your RedBubble Sales History and draw insights from your first few sales. I would only recommend doing this once you have at least 50 sales, even if you have 20 sales there’s not much extra useful information you can uncover from deep diving into your spreadsheet of sales.

I’ll keep this short, there’s only 3 sections to this post:

1. Add Column for Monthly Sales
2. Analysing Bestsellers
3. Optimising your product range

Add Column for Monthly Sales

You need to create a new column and copy over the Order Date into it for all the rows. Then adjust the format to month only in name by removing the other numbers and changing month to text.

Analysing Bestsellers

Next, you’ll be interested in your bestsellers which you will analyse by reviewing these 4 categories:

Work (Your product title irrespective of the product type)

With this information you can review the product and diagnose why it is selling more than your other designs. For example, your top-selling products may all contain similar keywords. In response to this, you will continue to use the more effective keywords if there are not other variables to take into consideration.

Product (Product Type, so whether it was a Sticker or Water Bottle)

I can guess for most RedBubble sellers, the best-selling product type will be Stickers so we can look beyond that. Are you selling a few more Water Bottles than usual? If so, is there an opportunity here?

Destination Country (Don’t confuse it with Fulfilment Country where the order is made)

In a lot of cases most of your sales will come from United States and Europe but if you start to sell in other countries maybe you can consider adjusting your design text to a language with potential.

Niche (Optional column you can add if you wish)

It would be very manual to assign each product to a niche so it’s fine if you notice a trend in certain categories selling more than others. For example, you’re selling lots of designs with dogs rather than cats or hamsters. So do you stop selling cat designs or add more dog designs? It’s all about focusing on the right niche categories.

Visualise your sales

You can create Pie Charts to see:

1. What month generated the highest % of your sales
2. What product type had the highest % for income and sale numbers

I removed the product titles and chart labels for privacy and business reasons but as you can see I get most of my sales from 1 product. Based on this chart I need to review that winning product and do 2 things:

1. Increase the price margins because it’s a guarantee seller. (Stickers offer little profit so I recommend increasing them as there’s little point only making £1 / $1 from each sale.)
2. Review what makes it successful and try incorporating its style and niche into future designs.

Optimising your product range

There are a few ways to optimise your product range that I have mentioned above including:

• Tailoring your designs towards product types
• Potentially using Facebook Ads on best sellers. But don’t do this at a loss, if you only make £20 off a month on a design, your Facebook Ad budget shouldn’t be more than £5. It’s essentially a gamble when the profit margins on RedBubble sales are so low.
• Focusing on winning categories by doubling down on successful niches and keywords
• Improving and updating designs that sell a little but have potential to sell more

This advice is straight forward and common business sense once you’re aware of what tools and information you have at your disposal. As I continue my own Redbubble journey, I’ll add more posts with more in-depth advice.