wiskerke Posted December 30, 2016 Share Posted December 30, 2016 Marc, great presentation! How did you go about it? Wim Hi Wim, I downloaded the data from Alamy using the "Build a downloadable sales report" facility on the contributor page. For those who have never used this or are new, this facility is also useful for compiling your DACS claim and for getting the quickest notification about sales. Sales show up almost immediately in this download, long before they appear in the "Recent Sales" section on the contributor page. You don't have to download all the fields, you can select the fields you are interested in. In any event, it only takes seconds to download. Once the data is downloaded as a .csv file and imported in Excel (or any other spreadsheet software), I created five different "Sheets" in Excel, one for each year. I then sorted each sheet by gross sale value (highlight all columns, then select data, sort by column). If you then highlight the cells that fall within the price band you are interested in, and look bottom right in the Excel information bar, you will see how many cells you have selected (plus other information). This tells you how many sales you had within the price band. Enter this in an empty cell somewhere. Then do the same for the other price bands. From this information you can then make a bar or pie chart. If you highlight all the gross sale value cells for the whole year, the information bar at the bottom will tell you the average. You can then do the same for the net values and make a chart. I was just trying to do it quickly. Of course, there are better ways using formulas and macros, and perhaps I'll put one of those together for everyone to use if I can find time .... you can then have an input screen at the front to select what you want analysed. If I can be of further help, let me know. Marc Thank you! I will try to follow that steps to get to those charts. Because sales still come trickle in (a whopping 4.20 today) I'm still holding out until the first day of 2017. wim Link to comment Share on other sites More sharing options...
Sultanpepa Posted December 30, 2016 Share Posted December 30, 2016 It's been a year of peaks and troughs with 18 sales in June and only 2 so far this month. On the whole prices have reflected the general downward trend experienced by mostly everyone else and with the larger sales becoming less frequent it doesn't bode well for the future. I'm not in the distributor scheme because I just can't abide the thought of sharing the fruits of my labour with two others. Give me my 50% and share what's left however many ways you wish, that's how I see it. I'm looking forward to seeing the new tools and getting on with re-keywording which I think will need to be done to get the best from the new algorithms. My views have certainly taken a hit in the last month and the new year will give me a feel for how zooms are shaping up as December is not the best time to judge. 2016- 107 sales (double of 2015)- revenue showing downward returns but still a good improvement on last years total. Here's hoping you all have a happy and prosperous new year. SLAINTE Link to comment Share on other sites More sharing options...
Rolf Adlercreutz Posted December 30, 2016 Share Posted December 30, 2016 This has been my 2nd best year in the number of sales, but I have had 6 years with more money. I have been with Alamy since 2003, but I don't add many pictures anymore as I get upset by the low prices they are getting. Pity. Link to comment Share on other sites More sharing options...
ReeRay Posted December 31, 2016 Share Posted December 31, 2016 Lots of distributor sales this year which kept the price per image down but nevertheless volume up 50% and revenue up 25%. Happy enough with that. Link to comment Share on other sites More sharing options...
Callie Posted December 31, 2016 Share Posted December 31, 2016 Compared to last year: sales volume up by 28% revenue down 10% average sales price 30% lower I haven't totalled how many but it seems like lots more distributor sales Link to comment Share on other sites More sharing options...
spacecadet Posted December 31, 2016 Share Posted December 31, 2016 Volume up 32% revenue down 2% average down 25% Only 2% over $100, last year 16%. Distributors only about 8% and none of the bigger sales so net rate to me about 48%. Small mercies. Link to comment Share on other sites More sharing options...
AlbertSnapper Posted December 31, 2016 Share Posted December 31, 2016 number crunching......compared to 2015 volume - up 14% sales - down 10% revenue - down 37% 12% of sales I had to report myself 3 sales over $150 Despite remaining high in the rankings, overall not so good ! I'm glad other options are available ! Link to comment Share on other sites More sharing options...
Rolf Adlercreutz Posted December 31, 2016 Share Posted December 31, 2016 I only do 3 distributors, no PU, no newspaper deals. Keeps my blood pressure down. Link to comment Share on other sites More sharing options...
kelal Posted December 31, 2016 Share Posted December 31, 2016 Following the general trend: sales up (a bit); revenue well down. Happy New Year Link to comment Share on other sites More sharing options...
John Richmond Posted December 31, 2016 Share Posted December 31, 2016 86% increase in sales numbers (97 against 52 last year), 52% increase in gross earnings but low average gross of $25.47, down on the $31.23 for last year. Too many low return distributor and newspaper sales. I'm only in my third year with Alamy so still in the early stages of what I recognise as a long term commitment. Link to comment Share on other sites More sharing options...
DJ Myford Posted December 31, 2016 Share Posted December 31, 2016 Best year by volume, but only 5th best by gross revenue. A zoom earlier in the month raised hopes of a late sale to take revenue up to 4th, but it looks like it won’t convert in time (if at all). Link to comment Share on other sites More sharing options...
Martin P Wilson Posted December 31, 2016 Share Posted December 31, 2016 Best year by volume, but only 5th best by gross revenue. A zoom earlier in the month raised hopes of a late sale to take revenue up to 4th, but it looks like it won’t convert in time (if at all). Much the same for me. Link to comment Share on other sites More sharing options...
Doc Posted December 31, 2016 Share Posted December 31, 2016 Managed to continue both increase in image sales and increase in income year on year. Image sales 2016 - 868 (Image sales 2015 - 656 Increase in image sales : 212, or 32% Gross Income 2016 - $28,000 (Gross Income 2015 - $26,560) Increase in Gross income - $1440, or 5% Images added during the year - 1,400 (7.5% increase) Image numbers now on sale 19,980 Kumar Link to comment Share on other sites More sharing options...
phomme Posted December 31, 2016 Share Posted December 31, 2016 Gross income of $26,000 and $28,0000, that is very impressive. Link to comment Share on other sites More sharing options...
ReeRay Posted December 31, 2016 Share Posted December 31, 2016 Well done Doc. Very impressive figures. Link to comment Share on other sites More sharing options...
Craig Yates Posted December 31, 2016 Share Posted December 31, 2016 Sales volume up 40%. Missed equalling last years revenue by a measly $13. Craig Link to comment Share on other sites More sharing options...
Bryan Posted December 31, 2016 Share Posted December 31, 2016 Year ended well with a bumper crop in December, pushing my gross revenue over last year's figure. Over the year volume up by 41% , gross income up by 6.3% , average fee per image leased down by 30% . Link to comment Share on other sites More sharing options...
Lisa Posted December 31, 2016 Share Posted December 31, 2016 Number of Alamy sales (includes Stockimo) 2012 = 1 2013 = 16 2014 = 57 2015 = 76 2016 = 84 Number of Stock photos for sale 2015 = 1,688 2016 = 1,940 Number of Stockimo iPhone photos for sale 2015 = 615 2016 = 669 Highest 2016 Alamy Stock sale = $180 Highest 2016 Stockimo iPhone sale = $150 Link to comment Share on other sites More sharing options...
Brighton Coast Posted December 31, 2016 Share Posted December 31, 2016 340 sales this year and still a few hours left Link to comment Share on other sites More sharing options...
Dave D Posted December 31, 2016 Share Posted December 31, 2016 Well, as this is my first year, and not a full one at that, I'm still happy to have opened my Alamy account with 3 sales in the past 4 weeks, worth just over $65. These are all from images uploaded in April. A coincidence I'm sure?! I spent the best part of the year with around 200 images in my portfolio but have got that up to over 600 in the past month with another 150 gone through QC and waiting to be keyworded etc. Here's looking forward to a productive 2017. Happy new year to you all Dave Link to comment Share on other sites More sharing options...
Foreign Export Posted December 31, 2016 Share Posted December 31, 2016 image sales up 90% on 2015 revenue up 105% on 2015 i have added a lot more images this year though Link to comment Share on other sites More sharing options...
wiskerke Posted December 31, 2016 Share Posted December 31, 2016 351 for 16800 (gross) amount up from 2015: 60% $$ up from 2015: 30% 100 and higher: 39 80-100: 860-80 : 2540-60: 6620-40: 830-20: 131 highest: 650 -and I still think it was The Donald. wim (no graphs: this box doesn't like google or dropbox pix) Link to comment Share on other sites More sharing options...
Ace Posted December 31, 2016 Share Posted December 31, 2016 2014 - 16 sales 2015 - 37 2016 - 80 2016 Double income of 2015 Happy with the progress so far More of the same for 2017 please ! #keepgrowing Link to comment Share on other sites More sharing options...
Betty LaRue Posted January 1, 2017 Share Posted January 1, 2017 Until 2016, 2012 was my best year. In 2012 I had 8 three figure sales among others that were just below 3 figures on about 2000 images. One of them for $700. 2015 I had 7 three figure sales although I had added 1000 or so images. 2016 I've had 5 three figure sales with a port double the 2012 port. Although contrary to some here, three of those have been in July and later. My sales volume for 2016 is up about average to the increase in my port. But income down. Link to comment Share on other sites More sharing options...
Michael Ventura Posted January 1, 2017 Share Posted January 1, 2017 2016 was the best year in fours years, in terms of sales volume but only beat last year's gross and it was up by 19% over 2015. So, overall, I am happy. Going in the right direction again! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.