MicrostockGroup
Microstock Photography Forum - General => General Stock Discussion => Topic started by: 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?
-
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
-
I could be interested Mike
-
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.
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.