Author Topic: How do you keep track of your microstock stats? (Read 10052 times)

S. · « **on:** November 01, 2012, 10:05 »

I have an excel file but it's very unprofessional, for each agency I just keep track of the revenue and portfolio size for each month.

How do you keep track of your stats? Excel spreadsheet? Access? Some software?

Microbius · « **Reply #1 on:** November 01, 2012, 10:10 »

Open Office spreadsheet.
Tried one of the specialized solutions out there but it wasn't working for me.

ca2hill · « **Reply #2 on:** November 01, 2012, 10:49 »

Open Office spreadsheet.

sgoodwin4813 · « **Reply #3 on:** November 01, 2012, 11:40 »

Excel.

Pauws99 · « **Reply #4 on:** November 01, 2012, 11:43 »

Excel you can tailor it to what you need. I keep it fairly simple :-)

microstockphoto.co.uk · « **Reply #5 on:** November 01, 2012, 12:25 »

Excel.

John W. · « **Reply #6 on:** November 01, 2012, 19:39 »

Excel. Filling in the daily downloads and $ for every site since I started. Producing great charts and graphics.

dbvirago · « **Reply #7 on:** November 01, 2012, 19:50 »

Access. Have a small set of tables, with forms for data entry, a lot of queries and a few reports.

Morphart · « **Reply #8 on:** November 01, 2012, 22:22 »

Quote from: jwolf on November 01, 2012, 19:39

Excel. Filling in the daily downloads and $ for every site since I started. Producing great charts and graphics.

Daily downloads? Isn't this time consuming unless you submit 1 or 2 agency?

EXCEL for me too, currently making my programmer build me a custom MySQL db for this, but that's just for my personnal fun

Anita Potter · « **Reply #9 on:** November 01, 2012, 23:24 »

Daily download tracking is going to drive you insane and clutter up your worksheet. Monthly is easier to deal with.

I have mine in Excel. I keep track of my payouts for taxes and what I make at each agency every month plus what I've made with them for the year. Today I started tracking what I've made with each agency all time since 2009.

Keep your paperwork simple. Doing it on a daily basis is going to take time away from creating your works.

THP Creative · « **Reply #10 on:** November 01, 2012, 23:46 »

excel, I track monthly earnings, files online, and payouts. It automagically gives me my earnings total for the year for tax, monthly totals for each library, and yearly totals for each library.

More than enough I'd reckon

ruchos · « **Reply #11 on:** November 02, 2012, 02:54 »

Excel. Track monthly totals from each site - separated for both photo and video sales, and track various stats from that.

gillian vann · « **Reply #12 on:** November 02, 2012, 04:19 »

I'm only a small contributor but a big excel nerd, so I have spreadsheets with image status (accepted, pending, rejected) as well as sale count per site (although it's not 100% accurate for every site), plus monthly sheets & graphs for uploads, downloads, earnings. Love a good, colour coded spreadsheet!

this is only my first real year of stock so I'll have to also add in another chart to compare previous years. I'll save that fun for the xmas hols.

cobalt · « **Reply #13 on:** November 02, 2012, 04:35 »

www.stockperformer.com

It is really helpful, because I get a lot of data from my light boxes.

John W. · « **Reply #14 on:** November 02, 2012, 07:49 »

Quote from: Anita Potter on November 01, 2012, 23:24

Daily download tracking is going to drive you insane and clutter up your worksheet. Monthly is easier to deal with.

I have mine in Excel. I keep track of my payouts for taxes and what I make at each agency every month plus what I've made with them for the year. Today I started tracking what I've made with each agency all time since 2009.

Keep your paperwork simple. Doing it on a daily basis is going to take time away from creating your works.

It's 15 minutes of work a week. Been doing it since 2009. I'm with 9 agencies and dls and $ are the only data I fill in on 1 row and Excel calculates all the rest to different tabs. Ofcourse I'm the kind of person who likes to play around with Excel and keep track of things. Excel can't drive me insane, creating pictures and photoshopping all day will!

rubyroo · « **Reply #15 on:** November 02, 2012, 08:19 »

For a while, when I first started, I documented every single sale! LOL Talk about 'OCD'.

Even daily recording would drive me nuts these days. I like keeping physical books as a bit of continuity with the past, so I rule up my book and physically write down my earnings at the end of each month - enjoying the more tactile nature of that event. Then I speedily copy them into a spreadsheet with a bored demeanour for practical purposes.

ETA: I haven't started doing this by candlelight with a shawl and quill pen yet... but the cold night's are drawing in... and I did buy a shawl last year... so I might start developing a Dickensian vibe...

gostwyck · « **Reply #16 on:** November 02, 2012, 08:45 »

I just rely on the Stats page at iStock to accurately record my sales and earnings. I mean, what could possibly go wrong?

rubyroo · « **Reply #17 on:** November 02, 2012, 08:46 »

Hahahahahaaaaaaaaaaaa

Seriously almost choked on the grape I was eating then...

S. · « **Reply #18 on:** November 02, 2012, 08:51 »

Quote from: gostwyck on November 02, 2012, 08:45

I just rely on the Stats page at iStock to accurately record my sales and earnings. I mean, what could possibly go wrong?

Do you have sales on at iStock?

gostwyck · « **Reply #19 on:** November 02, 2012, 09:01 »

Quote from: Stepunk on November 02, 2012, 08:51

Do you have sales on at iStock?

Apparently I do. Woke up this morning to find my recorded earnings for Sept/Oct had gone up by about $250. My Downloads figure had jumped up quite a bit too. Unfortunately there was no more money in my Balance though. It means I feel a bit richer ... but actually I'm not.

click_click · « **Reply #20 on:** November 02, 2012, 09:05 »

Quote from: gostwyck on November 02, 2012, 08:45

... I mean, what could possibly go wrong?

... the captain of the Titanic said.

RacePhoto · « **Reply #21 on:** November 02, 2012, 12:22 »

Quote from: gostwyck on November 02, 2012, 08:45

I just rely on the Stats page at iStock to accurately record my sales and earnings. I mean, what could possibly go wrong?

Thanks, luckily I wasn't drinking or eating anything at the time. I hate having to clean the monitor so often.

ps when I did, Open Office Free, now I just log cash entries on PayPal and smile.

gillian vann · « **Reply #22 on:** November 02, 2012, 17:01 »

that would be nice, but until I'm earning smile-worthy money I'm content with my coloured line graphs.

cascoly · « **Reply #23 on:** November 02, 2012, 17:12 »

excel spreadsheet - monthly stats on nnew & cum accepted and DL, and income. and a calc of what % each agency is for the total that month

cum stats track improvement over comparable 3 and 6 mo periods last year

a chart shows monthly income, with a running average overlaid on monthly total to smooth out bumps. quickly shows which agencies are producing over time and which may have an anomalous blip

dbvirago · « **Reply #24 on:** November 02, 2012, 17:49 »

Quote from: cobalt on November 02, 2012, 04:35

www.stockperformer.com

It is really helpful, because I get a lot of data from my light boxes.

Took a quick look at this, it says, Data From All Agencies
We support iStockphoto, Fotolia, Shutterstock, Dreamstime and 123RF.

Are those the only ones? Not exactly 'all agencies' but I might try the free trial.

MicrostockGroup Sponsors

Author Topic: How do you keep track of your microstock stats? (Read 10052 times)

S.

Microbius

ca2hill

sgoodwin4813

Pauws99

microstockphoto.co.uk

John W.

dbvirago

Morphart

Anita Potter

THP Creative

ruchos

gillian vann

cobalt

John W.

rubyroo

gostwyck

rubyroo

S.

gostwyck

click_click

RacePhoto

gillian vann

cascoly

dbvirago

Related Topics

Sponsors

Microstock Poll Results

Sponsors