Stats, can they be exported?

derf

Anyone know of any app that can export the stats to excel or any other format? :wink

scwalter

derf wrote:

Anyone know of any app that can export the stats to excel or any other format?

Statcounter can do this (excel and csv)... here's the tutorial on how to set it up.

http://dgrin.smugmug.com/gallery/1092684

lifeinfocus

Not sure I follow what it exports?

How about the ability to export the stats from one gallery for the previous month and for the current month to a CSV format?

Or how about the capability of being able to sort on all the thumbnails shown when you click on the bar graph stats for a gallery.

For instance, to be able to sort by the most total hits or the most bandwidth used? That would tell me numerically and visually which photos were the most popular for the previous month and the current month. I could use that to determine which photos to use in a DVD, photobook etc. The data is there and it is obviously being stored in a database. Now just need to the capability to sort. We can sort in the "Arrange' function, so I would assume that routine could be expanded and applied to the Stats feature.

Hopefully. This would be a great tool.

Phil

lifeinfocus

While it doesn't allow for sorting on stats, you can simply go to Stats in your control panel. Select one of you galleries (click on the bar graph) then highlight (Ctrl A or Select All) and paste into Excel.

What you get is the thumbnail image along with the stats - small, medium, large, etc and bandwidth used for each photo. Nicely formatted for easy viewing offline.

However the data is not organized in a columnar fashion for sorting. You can uee filters to select for instance just "bandwidth" or "large" but you can not sort on the results. However, you can quickly visualize which ones are the most popular by size or bandwidth.

To get the most of it you would need to manually rearrange - too much work - or write a VBA script to reorganize the data. The latter would be the ideal but would be too much work.

So, in the interim I will copy and paste and view offline which photos in a gallery are the most popular. I know photo rank does this but not for protected galleries and it assumes that people do that.

If there are other methods, please let us know.

This is very valuable information.

Phil

lifeinfocus

To derf, there is a Smugmug feedback forum that has a "planned" update to be able to download stats.

Go to: http://smugmug.uservoice.com/pages/17723-smugmug

You may want to login and vote for "View Stats in Spreadsheet Format". I left a comment of how I plan to use it. You may want to do same.