MicrostockGroup

Microstock Photography Forum - General => General Stock Discussion => Topic started by: Dan on February 18, 2013, 11:43

Title: tracking stock photo sales
Post by: Dan on February 18, 2013, 11:43
    I've  tried  lookstat"  and  'microstock  analytics"  without  sucess.  Are  they're  any  other  programs  to  track  your  sales  of  stock  photos?
Title: Re: tracking stock photo sales
Post by: Poncke on February 18, 2013, 11:52
Excel
Title: Re: tracking stock photo sales
Post by: tab62 on February 18, 2013, 12:43
Excel as well Dan.

Very Simple- create a monthly file

Headers
Company Name, Total Sales, Dollars, Sales %, and RPD


Plus I have additional worksheets that I keep like the for each month, and gross sales YTD


T
Title: Re: tracking stock photo sales
Post by: Petr Toman on February 18, 2013, 12:45
Google drive spreadsheet :) not so secure maybe as your file on a hard drive, but accessible from everywhere :)
Title: Re: tracking stock photo sales
Post by: John W. on February 18, 2013, 12:54
Stock Performer

https://www.stockperformer.com/ (https://www.stockperformer.com/)

I used their trial version and think they're good but unfortunately pretty expensive imho.
Title: Re: tracking stock photo sales
Post by: Poncke on February 18, 2013, 13:57
Here is one I created a while back. Its very basic but you can rework it.

https://docs.google.com/spreadsheet/ccc?key=0AhjSTiU-8rbUdF9IaGZBdmpNOG5IVTNGZ2k3UUdUWHc#gid=0 (https://docs.google.com/spreadsheet/ccc?key=0AhjSTiU-8rbUdF9IaGZBdmpNOG5IVTNGZ2k3UUdUWHc#gid=0)

Every thing is calculated automatically and all cells have formatted conditions, all you need to do is enter the data. Use the legenda in the file.

There is also a little key word generator on the second tab, for adding, commas, semicolons and/or quotes to make phrases. Just type the words into column A , E, or G. You can copy and paste the keywords into the keyword fields on the stock site.

There is room for your first 200 photos. You can add remove any rows or columns, just remember to change the formulas as well then. Everyone with a bit of excel knowledge can edit the file easily.

You can download the file on Google Docs, just click file and then download as excel.

Here is a link to a handy file name copy tool. Just download and install. Select your photos, and then right click copy file names. And then paste into the excel sheet.

Freeware: http://www.extrabit.com/copyfilenames/ (http://www.extrabit.com/copyfilenames/)
Title: Re: tracking stock photo sales
Post by: RacePhoto on February 18, 2013, 22:40
Excel

Except I used Open Office, but the same thing. I don't track anything anymore except end of the year income, for the accountant.
Title: Re: tracking stock photo sales
Post by: gillian vann on February 18, 2013, 22:53
Google drive spreadsheet :) not so secure maybe as your file on a hard drive, but accessible from everywhere :)

and it comes with free stock images to make your spreadsheets look pretty  :D
Title: Re: tracking stock photo sales
Post by: Microbius on February 23, 2013, 02:53
    I've  tried  lookstat"  and  'microstock  analytics"  without  sucess.  Are  they're  any  other  programs  to  track  your  sales  of  stock  photos?
What problem did you have with microstock analytics?

I find that it takes forever to pull the data whenever I download it, but once it's there it work well for me.
I had problems with Stock Performer