CODI - Show Me the Numbers! Using Statistics to Drive Management Planning

Marilyn Borgendale, Ann Hutton, Amy Terlaga, Joseph Fisher, Colleen Medling

Marilyn Borgendale, GMILCS, Inc.

GMILCS is a multi-type, voluntary consortium in New Hampshire.

9 public, 3 academic libraries.

Report generator was developed from the needs and requests of the librarians, allows staff to create reports themselves, presents data for use in creative ways, is the model we are working with as we implement WebReporter.

Eric Graham worked with them 1 yr to form their report generator.

Report generator is staff only, behind firewall. It's a web based product, where the librarians can choose from canned reports such as purchase alert, weeding reports. Items added report by call number for specific time period. Request detail report: “limbo report” list of holds on missing, trace, etc.

“In demand notice” if there is a request on the overdue book, they phone borrower right away: requested btype on report so they know they’re not talking to a juvenile.

Graphs of circ activity for management & board in bright colors comparing 1 year to another.

Colleen Medling, Tampa-Hillsborough County PL

Cooperative/consortia with 25 locations + 1 branch a year for next 5 yrs

one bookmobile, one cybermobile

3 special libraries, 2 co-operative libraries

Are the stats they're asking for already available?

Ad hoc reports, web reporter, snapshot data

Tables that are cleared each day:

Request pull list.

Day end-po’s approved?, expired holds?,

Can the data be captured and recorded on a daily basis?

Number of cko sessions per day

Cko by bstat

Create a table in horizon to retain your stats (see her presentation on the CODI website)

Create SQL query to capture info and insert into the table [capturing data slide]

Then create a scheduled task to run as needed.

Eric Graham & Brian Rawlings white papers:

Building Blocks for Horizon Statistics

Horizon Reports: Obtaining Reports without 3rd party software

Amy Terlaga, Bibliomation

Amy's presentation is on the CODI website. She focused on using Web Reporter to gather ILL statistics and balancing the requests between member libraries in consortia.

Joseph Fisher, Boston PL

130 online databases at Boston PL.

Joseph talked about the time consuming task of gathering the usage stats for the databases.

Some stats are available via Horizon RPA, but to evaluate the usage, the best way was to gather the stats from the vendors.

More vendors are adopting the COUNTER standard (counting online usage of networked electronic resources)

Ann Hutton, SELCO –SE Minneapolis

They needed a report to help determine how much staffing was needed at the circ desk.

Circ per hour custom report SQL

Using EasyAsk: change the red to reflect the location code you wish to report on, change the green to the month you wish to report on

select year, month, day, hour,
convert(int, sum(total))
from stat_summary
where stat_category='cko'
and location='zum'
and year=2005
and month=10

group by year, month, day, hour
order by year, month, day, hour