Author Topic: Sales stats into excel (Read 2690 times)

heywoody · « **on:** June 20, 2015, 17:32 »

I built a little tool for my own use which pulls port and sales data (each individual sale) from the top 5 into an Access database and allows me to slice and dice, export to Excel etc etc. This is not a slick "product" like what is commercially available and not really suitable for distribution. However, I could fairly easily adapt the code to work in individual excel files for the various sites.

Given the tools that are already out there, and I haven't looked at them in any detail, is this something anyone would be interested in if made available for a nominal sum?

leaf · « **Reply #1 on:** June 21, 2015, 01:11 »

What makes sales data useful is when you can group the same image from site 1 and site 2 and see the total sales from that one image over all the sites it is on. The only one I know of right now that can do it is MicrostockAnalytics

Semmick Photo · « **Reply #2 on:** June 21, 2015, 01:36 »

I could be interested Mike

heywoody · « **Reply #3 on:** June 21, 2015, 06:00 »

Quote from: leaf on June 21, 2015, 01:11

What makes sales data useful is when you can group the same image from site 1 and site 2 and see the total sales from that one image over all the sites it is on. The only one I know of right now that can do it is MicrostockAnalytics

That is the one tool I looked at. I'm guessing he uses you image matching algorithms to match across the sites using the thumbnails - not perfect but pretty * close and you can establish missing links manually. When I looked at it it had good canned views of the data but didn't see how I could get at the underlying data to create my own.

My DB is way, way less sophisticated but does have a master table that links across the sites so I do have this functionality. Pain to set up initially but simple to maintain on on an ongoing basis for anyone with basic SQL or Access query skills. I can pump monthly details of new images and sales across each site on a monthly basis into excel which then does automatic tracking of stuff like port size, rpi, rpd etc for the individual sites and overall. Similarly another spreadsheet automatically tracks dls and sales for each individual image across the sites.

Quote from: Semmick Photo on June 21, 2015, 01:36

I could be interested Mike

For some reason, I figured you might be J Do you by any chance have MS Access? If so, happy to give you the whole thing as I’m interested to see how it behaves with bigger ports and sales than I have and to see how practical it might be for someone else to set up.

MicrostockGroup Sponsors

Author Topic: Sales stats into excel (Read 2690 times)

heywoody

leaf

Semmick Photo

heywoody

Related Topics

Sponsors

Microstock Poll Results

Sponsors