MicrostockGroup

Agency Based Discussion => Dreamstime.com => Topic started by: fintastique on January 18, 2009, 15:49

Title: NEW DT earnings stats in a spreadsheet
Post by: fintastique on January 18, 2009, 15:49
For all you stats junkies  ;D

Now on your uploads and earnings page at Dreamstime you can download an zipped excel file (which will also open with "open office calc")

There are multiple sheets listing your files in chronological order only

with DLs, views and total earnings.

The first sheet lists all your accepted files then subsequent sheets list all the files accepted in a particular month of December 2008, November 2008 etc with DLs, views and total earnings up to 31/12/2008. If you scroll down to the bottom of that sheet you can see how many files you uploaded that month and how much they have earnt until 31/12/2008.

Also if you know the month of a particular shoot you can quickly check to see what files were the earners. There are no thumbnails just the image ID and the title but with the former you can see the image in question.
Title: Re: NEW DT earnings stats in a spreadsheet
Post by: Opla on January 18, 2009, 15:59
That's useful, thanks for the heads-up.
I noticed the icon before but never bothered.
It's on the earnings page for me though...
Title: Re: NEW DT earnings stats in a spreadsheet
Post by: litifeta on January 18, 2009, 17:36
Yes and with a bit of manipulation and combining different data, you can get some really interesting results. Like I discovered my RPI was .25 cents, well above the average.
Title: Re: NEW DT earnings stats in a spreadsheet
Post by: madelaide on January 20, 2009, 21:26
I liked it very much.  Lots of info to have fun with.   :D

Only after this I tried IS's option to dld a CSV file.  Excel reads it, but you have to split text into columns - not difficult.

What other sites have this option of a spreadsheet with files/sales data?

Regards,
Adelaide
Title: Re: NEW DT earnings stats in a spreadsheet
Post by: RacePhoto on January 20, 2009, 21:49
Yes and with a bit of manipulation and combining different data, you can get some really interesting results. Like I discovered my RPI was .25 cents, well above the average.

How did you get an RPI out of that data, it doesn't show the total number of images? Or do you mean you divided sales by the number of images, which I think I could do without a spreadsheet.  ???

I did find that I had 1 download for every 27.16 views?  ;D