Jansos Posted May 25, 2018 Share Posted May 25, 2018 I'm sure there must be an answer for this but how easy is it to determine how many times an individual image has sold? I would like to easily see which images are selling and which to cull. Many thanks in advance. BW, John Link to comment Share on other sites More sharing options...
spacecadet Posted May 25, 2018 Share Posted May 25, 2018 Just do a text search for the image reference in "summary of images sold". Unlike in the accounts pages it only appears once per licence. Refunds excepted, of course. Link to comment Share on other sites More sharing options...
Thyrsis Posted May 25, 2018 Share Posted May 25, 2018 On your dashboard, go to ‘download sales report. For date range choose roughly the date you started on Alamy and also choose date of invoice. You can then download the csv file and arrange the columns to suit the info you are looking for. Link to comment Share on other sites More sharing options...
Allan Bell Posted May 25, 2018 Share Posted May 25, 2018 Or go to "Sales History" click on "All". You get a picture as well of each sale. As mentioned above look out for refunds though. Allan Link to comment Share on other sites More sharing options...
Kat Posted May 25, 2018 Share Posted May 25, 2018 Once you have the report in Excel I think you could use the COUNTIF function to count how many times an image has been sold. But it will also return refunds. Link to comment Share on other sites More sharing options...
John Richmond Posted May 25, 2018 Share Posted May 25, 2018 I import the data into an Excel spreadsheet in a similar format to the downloaded CSV from the reporting screen. Analysis is then performed using pivot tables and other data analysis tools. I exclude any refunds on import so they don't affect the results. Link to comment Share on other sites More sharing options...
Jansos Posted May 27, 2018 Author Share Posted May 27, 2018 Many thanks for everyone's helpful suggestions. All useful but somewhat labour intensive. I was hoping that there might be a tool tucked away somewhere that facilitated without having to take into Excel etc. Would this be something useful for Alamy to work on do you think? VBW, John Link to comment Share on other sites More sharing options...
Thyrsis Posted May 27, 2018 Share Posted May 27, 2018 On 27/05/2018 at 16:57, Jansos said: Would this be something useful for Alamy to work on do you think? VBW, John Why would Alamy do the work for you?!? Once you’ve downloaded the excel file it’s easy to keep it updated every month. I also use it to calculate our Dacs claim. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.