Reply to this post | See parent post | Go Back

View Post [edit]

Poster:	stbalbach	Date:	September 09, 2010 11:01:01am
Forum:	texts	Subject:	Re: Download report by date or date range for a specific collection

I don't think it's possible to do it the way you tried exactly, but there is another way that takes some extra steps.

The search string for Advanced Search:

collection:(MontanaStateLibrary) AND publicdate:[2008-01-01 TO 2010-07-15] AND downloads:[0 TO 10000]

("10000" is arbitrary range, can't imagine books having more than that).

In Advanced Search, highlight the "downloads", "month", "week" and "title" fields and it should look something like this on HTML output. "Month" is the number of downloads in the past 30 days, "Week" is past 7 days. "Downloads" is total number of downloads since day 1.

Save the above Advanced Search as a CSV and import into a spreadsheet and sum up the total of the downloads and/or month and/or week column, save that total in a local database and repeat on a regular basis with a script to build a chronological history of downloads, per book and/or total collection.

Hope that helps, probably more complicated than you wanted.

Stephen

This post was modified by stbalbach on 2010-09-09 18:01:01

Reply to this post

Reply [edit]

Poster:	MSL Staff	Date:	September 10, 2010 08:35:46am
Forum:	texts	Subject:	Re: Download report by date or date range for a specific collection

Thanks Stephen Balbach,

This confirms what we had worked out from the cryptic, but nonetheless sufficient, help on the advanced search page.