It’s been a while since I did any little widgets or scripts to help people on RB, but I guess I’m in the fortunate position at the moment where I’m no longer focusing on ‘views’ or ‘comments’ on work, but actually wanting to track ‘sales’.
While RB gives all the raw data for all your sales (going back through history), it doesn’t help you to analyse how things have changed over time.
I realised that you can actually use Microsoft Excel to do web queries and basically suck down the contents of your sales stats table from the site, and then use it in a spreadsheet as raw data to play around with. I was then like a dog with a bone, and eventually got to the point where hopefully others can use it.
I’m no Excel guru, but I’ve put in a few simple macros to do some key things to make it all work.
This spreadsheet is a work in progress, but can be used to retrieve your sales stats from Redbubble and then play around with them in whatever pivot tables and charts you like. This should work with Excel 2007+, and presumably only works on Windows.
The spreadsheet has a web data connection to the redbubble ‘sales by time’ page – which of course needs you to be logged in. It’s assumed you have Internet Explorer, as that’s what Excel will be using under the covers. I’ve provided a browser window in the 3rd sheet so you can do everything in one place without having to open another browser window.
There is existing data in this file, as the charts needed something to go off (data in pivot tables) to work. You can therefore see my glittering sales figures for one of my other RB accounts ‘geekcasuals’ :). Once you’re logged in and have refreshed, everything should be replaced with your own data.
- Make sure you clear all the ‘Excel paranoia’ warnings, like enabling ‘active content’ and ‘enable editing’ – otherwise it won’t work
- Click the ‘Log in to Redbubble’ button to log into RB – make sure you tick ‘remember me’
- Click ‘Refresh’ – it should attempt to retrieve your sales stats. If you’ve not made any sales, then this spreadsheet obviously won’t be of any use to you, and also won’t refresh any of the data.
- Sit back and marvel at your sales stats.
You can download the spreadsheet from my site.
There’s plenty of scope for improvement, so anyone clever enough to do something really whizzy, please send me your updates so I can make it available to everyone else.