pancakes

MicrostockGroup Sponsors


Author Topic: RPI calulation  (Read 2604 times)

0 Members and 1 Guest are viewing this topic.

« on: September 29, 2008, 12:05 »
0
both my wife and I have finally gotten enough photos uploaded and are getting enough sales to begin to make tracking meaningful.  I do, however, have a question about obtaining a meaningful RPI calculation, and that is what to use for portfolio size.

We both uploaded a fair amount this month. I probably increased my port size by 30% and my wife by 50%.  If I use the portfolio size as it is now, end of the month, I actually see a fair sized drop in RPI over last month, even though my sales are much higher.  I'm wondering if a more meaningful approach would be to use an average between first of month and end of month portfolio size for the calculation.

What do you think?

I know I only seeing this discrepancy because I don't have that many files on-line (about 150 or so), but even with mid-sized portfolios a busy month of uploading could skew the RPI results, right?


« Reply #1 on: September 29, 2008, 12:17 »
0
yeah, you are right.  I do mine with an excel spreadsheet and calculate my image number by an average of all days...

If you add up all the images from each day and divide them by the number of days you will get a good average.
Example:

day  images
1     100
2     110
3     120
4     120
5     120
6     170
7     200
----------
total 940
average 134 images

I think that works anyhow :)

RacePhoto

« Reply #2 on: September 29, 2008, 12:36 »
0
Personal opinion, and I'm sure someone will disagree and have a better idea, but here's what I'd do.

Don't get all caught up in the details, it isn't a financial report for a Fortune 500 company. It's just something for yourself to give and indication of how things are going. If you wanted to be accurate you would have to track how many photos for each day of the month, because it's changing. With that every site will approve different photos on different days. You would go insane or have some complicated database with all kinds of complicated variables to account for daily changes in your photo count across all the sites.

Easy way. Count your photos at the end of the month, see how much you made that month. Kind of like gas mileage on the car. Divide and there you have it.  ;D

As your portfolio grows, the changes in total photos will be less significant, and your averages will start to smooth out.

I started out tracking which photos were accepted on which site. Spreadsheet with thumbnails and "X's" for rejected in red, Green fill for accepted. Yellow for submitted (so I wouldn't send duplicates by accident). With some sites taking one image and rejecting others, and another site taking ones that were rejected, but rejecting some that were accepted at another site, it was pretty funny looking. Very soon, I was just looking for was a trend, not to track every image. Shortly after that, I just uploaded and gave up trying to track each image.

Lets say I had nine Microstock sites. I'd create a batch of photos, then make nine folders on the computer, one for each agency. One by one I'd upload to that agency from that folder. I might add that some sites require different sizes, so all photos went to all the sites that took the smaller size, then the mid-size and larger went to other sites, and the few that required the largest minimum photo size, got the larger ones.

If I had 50 photos, some got 50, some got 30 something, some got 10. There goes the whole plan to track RPI by image, because they are all over the place, and never the same photos or same number of photos.

Do I count from 50, 30 or ten? I don't know?

That leaves us with RPI by agency, based on total photos at the end of each month, which is the simplest reasonable solution. In my opinion.

I'd rather spend time on something else rather than complex data tracking. Maybe taking pictures or editing.  ;)

« Reply #3 on: September 29, 2008, 12:59 »
0
Fully agree with RacePhoto even if I have myself developed a few scripts and a dedicated database to keep track of each and every download: I do it because I can (I'm a software developer and I liked doing it), but I must admit that the nice graphics I get are just nice and not that useful  :P

You should indeed not take too much time on complex calculations IMHO and rough average values are accurate enough.


« Reply #4 on: September 29, 2008, 15:59 »
0
Thanks for all of your input.

I, too, believe one can get caught us with too much detail.  However, one can also over simplify.  What I am thinking of doing, is carrying forward to closing number of images online for each agency to the beginning number of images for the next month.  Then, at the end of the month, I enter in my closing number of images, and use the average of these two numbers to calculate RPI.  Using excel, it would mean no additional entries, just complitact the RPI formula slightly.  Seems to me this would be the best all things considered, and once I get more and more images online the error would continue to decrease.

« Reply #5 on: October 01, 2008, 18:06 »
0
I was always puzzled about these calculations.

1. Monthly income  / total no. of images - does not make any sense cause it will keep going down when you add more photos
2. Total income / total no. of images  - makes more sense cause you can see whole pictures but you might no see monthly results
3. Monthly income / no. of images upload a month - it's kind of unclear cause different images might be downloaded and uploaded
4. Monthly income / no. of downloads - this would indicate structure of downloads (sub to credit ratio)

« Reply #6 on: October 03, 2008, 09:35 »
0
1. Monthly income  / total no. of images - does not make any sense cause it will keep going down when you add more photos

Why? I think it will go down if you _do not_. This number is more or less reliable if "average" MSG member keep in pace with other stock submitters. If we submit less - they get more, and opposite.

I think astrocady's variation is a good way to go (if you increase in a port size < 10%, even this is too complex, use either end or beginning of month data, does not make almost any difference)


 

Sponsors

Mega Bundle of 5,900+ Professional Lightroom Presets

Microstock Poll Results

Sponsors