using web management reports to track circulation at consortium and local levels ohiolink 2013 pcirc...
TRANSCRIPT
Using Web Management Reports to Track Circulation at Consortium and Local Levels
OhioLINK 2013 PCIRC ConferenceJune 14, 2013
Lorna NewmanHead, Interlibrary Services and Government Documents Dept.
University of Cincinnati LibrariesUniversity of Cincinnati
INN-REACH STATISTICSLENDING
• Problem:– Consortial statistics only provide overall statistics
for an institution– Lack information regarding individual library fill
rates– Lack information regarding which parts of
collection circulate to consortial partners
INN-REACH STATISTICS
INN-REACH STATISTICSLENDING
• Solution:– Create circulation cross tab reports– Ability to create custom queries– Use LOCATION and HOME LIBRARY to see what
materials are being sent
CROSS TAB QUERY TO DETERMINE WHO WE LEND TO
• Report Parameters– Date
• User specified– Statistic Type
• Checkout– Limited By
• System– Rows
• Location (displays statistics by location)– Columns
• Home Library (displays statistics by the patron’s home library)
Web Reports
Choose Parameters
Cross Tab Report
Download Report
• Use the download function to create an Excel file or
• Copy the entire file from the screen and import into Excel
Rows – Remove Non-LocalColumns – Remove Local
61113Circulation Crosstab 2.01E+15 LOCATION HOME LIBR
ARBAntioch University Ashland U
Athenaeum of Ohio
Baldwin Wallace University
Belmont College
Bluffton University
Bowling Green CCM CCPL CEAS
CEAS Annex CECH
ARB C.U. Coll 0 0 0 0 0 0 0 0 0 0 0 0 0ARB Fick 0 0 0 0 0 0 0 0 0 0 0 0 0ARB Rare Bk Ovsz 0 0 0 0 0 0 0 0 0 0 0 0 0ARB Rare Books 0 0 0 0 0 0 0 0 0 0 0 0 0Antioch University 0 0 0 0 0 0 0 0 6 0 1 0 1Ashland U 0 0 0 0 0 0 0 0 24 0 5 0 1Athenaeum of Ohio 0 0 0 0 0 0 0 0 5 0 4 0 0Baldwin Wallace University 0 0 0 0 0 0 0 0 44 0 1 0 0Belmont College 0 0 0 0 0 0 0 0 0 0 1 0 1Blue Ash Media 0 0 0 0 0 0 0 3 1 9 0 0 1Blue Ash Oversize 0 0 0 0 0 0 0 0 0 0 0 0 0Blue Ash Reference 0 0 0 0 0 0 0 0 0 0 0 0 0Blue Ash Reserve 0 0 0 0 0 0 0 0 4 0 16 0 0Blue Ash Stacks 0 3 2 1 2 1 7 22 13 40 35 0 4Bluffton University 0 0 0 0 0 0 0 0 15 0 1 0 0Bowling Green 1 0 0 0 0 0 0 0 155 0 84 0 3CCM Journals 0 0 0 0 0 0 0 0 39 0 0 0 4CCM LCtr Hphone 0 0 0 0 0 0 0 0 859 0 4 0 0CCM Media 0 0 0 0 0 0 0 1 7896 0 28 0 7CCM Media Annex 0 0 0 0 0 0 0 0 52 0 0 0 1
Remove local “home library” locations from columns
Remove non-local “locations” from rows
Results
Antioch University Ashland U
Athenaeum of Ohio
Baldwin Wallace University
Belmont College
Bluffton University
Bowling Green
LANGSAM Cohen 2 7 3 4 4 3 48LANGSAM Cohen Over 0 0 0 0 0 0 0LANGSAM GovDoc Media 0 0 0 0 0 0 0LANGSAM GovDoc OH 0 0 0 0 0 0 0LANGSAM GovDoc US 0 0 0 0 0 0 1LANGSAM Latest in Ref. 0 0 0 0 0 0 0LANGSAM Media 14 23 0 6 2 4 35LANGSAM Media Comp 0 0 0 0 0 0 0LANGSAM Micro Gov 0 0 0 0 0 0 0LANGSAM Microforms 0 4 0 1 0 0 21LANGSAM Oversize 0 0 0 0 0 0 3LANGSAM RIS Offices 0 0 0 0 0 0 0LANGSAM Ref/Docs Storage 0 0 0 0 0 0 0LANGSAM Reference 0 0 0 0 0 0 0LANGSAM Res Closed 0 0 0 0 0 0 0LANGSAM Stacks 41 79 15 41 21 27 379
Annual Report
INN-REACH STATISTICS BORROWING
• Problem:– Consortial statistics only provide overall statistics
for an institution– Lack information regarding what individual
libraries are receiving from our consortial partners
INN-REACH STATISTICSBORROWING
• Solution:– Create circulation cross tab reports– Ability to create custom queries– Use LOCATION and HOME LIBRARY to see what
materials are being checked-out at individual institution libraries
– Does not provide statistics on the number of books received but not checked out
CROSS TAB QUERY TO DETERMINE WHO LENT TO US & WAS CHECKED OUT
• Report Parameters– Date
• User specified– Statistics Type
• Checkout– Limited By
• Terminal– Rows
• Location– Columns
• Home Library or PTYPE
Results
Rows – Remove LocalColumns – Remove Non-Local
ARBAntioch University Ashland U
Athenaeum of Ohio
Baldwin Wallace University
Belmont College
Bluffton University
Bowling Green CCM
Antioch University 0 0 0 0 0 0 0 0 0Ashland U 0 0 0 0 0 0 0 0 1Athenaeum of Ohio 0 0 0 0 0 0 0 0 1Baldwin Wallace University 0 0 0 0 0 0 0 0 2Belmont College 0 0 0 0 0 0 0 0 0Blue Ash Media 0 0 0 0 0 0 0 0 0Blue Ash Stacks 0 0 0 0 0 0 0 0 4Bluffton University 0 0 0 0 0 0 0 0 0Bowling Green 0 0 0 0 0 0 0 0 0CCM Media 0 0 0 0 0 0 0 0 1CCM Microforms 0 0 0 0 0 0 2 0 0CCM Oversize 0 0 0 0 0 0 0 1 2CCM Stacks 0 0 11 0 7 0 0 30 56
Remove non-local “home library” locations from columns
Remove local “locations” from rows
Results for Check-outs atTerminal 220
CCM CEAS CECH CH PRATT CHEMBIOL CLASSICS CLERMONT DAAPGEOMATHPHYS
HEALTH SCI LANGSAM
Antioch University 0 1 0 0 0 0 0 1 0 1 25Ashland U 1 1 0 0 0 0 0 2 0 1 69Athenaeum of Ohio 1 1 0 0 0 0 0 0 0 0 23Baldwin Wallace University 2 1 0 0 0 0 0 0 0 0 13Belmont College 0 0 0 0 0 0 0 1 0 0 9Bluffton University 0 0 0 0 0 0 0 2 0 0 36Bowling Green 0 27 0 0 0 0 0 5 2 1 266CCPL 0 1 0 0 0 0 0 0 0 0 25CWRU 3 17 0 0 0 0 0 6 0 0 238Capital U 0 3 0 0 0 0 0 0 0 0 33Cedarville U 3 12 0 0 0 0 0 0 0 0 52Central State U 0 7 0 0 0 0 0 0 0 0 23Cincinnati Christian Univ 0 2 0 0 0 0 0 0 0 1 30Cincinnati State 0 0 0 0 0 0 0 0 0 0 26Clark State CC 0 0 0 0 0 0 0 0 0 0 15Cleveland Clinic 0 0 0 0 0 0 0 0 0 0 1Cleveland State 0 9 0 0 0 0 0 4 1 0 125
Annual Report
OhioLINK / SearchOhio StatisticsLending
• Lending– OhioLINK and SearchOhio statistics can be found on the OhioLINK PCIRC web
reports page:• http://olc1.ohiolink.edu:4454/olinkpatrep/report1/0//• SearchOhio statistics are located at the end of the columns• SearchOhio libraries begin with a ~
– Export the data to Excel• Remove all OhioLINK libraries from the columns• Remove all SearchOhio libraries from the rows
– (There is no data for SearchOhio libraries in the rows since borrowing data is not available here)
Results – Items Lent to SearchOhio Libraries
OhioLINK / SearchOhio StatisticsBorrowing
SearchOhio borrowing statistics can be found on the SearchOhio web reports page:
• http://66.213.126.165:4448/olinkpatrep/report1/0/mtd/
• Export the data to Excel –Remove all SearchOhio libraries from the columns–Remove all OhioLINK libraries from the rows
Results – Items Borrowed from SearchOhio Libraries
Pick-Up Anywhere Statistics
• Statistics available in Sierra / Millennium– Pickup Anywhere – Statistics
• General Statistics not specific transactions– Received– Checked Out– Shipped– Returned– Completed
Results
Transaction # Date
Pickup Site
Item Site Code
Patron Site Code Status
Previous Status
Patron Central PTYPE
Item Central ITYPE
Pickuplockey
82903 07-02-2012 ci3ug ca2ug cp4ug Completed Returned 202 200 20583109 07-03-2012 ci3ug ci3ug ws3ug Completed Returned 202 200 20583534 07-02-2012 ci3ug mu3ug cp4ug Completed Checked out 202 200 20583748 08-02-2012 ci3ug bg1ug mo3bg Completed Returned 202 200 20583752 10-14-2012 ci3ug ak2ug sl4gg Completed Returned 204 200 20583791 07-02-2012 ci3ug ci3ug si3tg Completed Received 205 200 20583819 07-07-2012 ci3ug da3ug cp4ug Completed Checked out 202 200 20583824 07-07-2012 ci3ug ca2ug cp4ug Completed Checked out 202 200 20583914 07-21-2012 ci3ug cs2ug si3tg Completed Returned 205 200 20583929 07-13-2012 ci3ug os4ug mu3ug Completed Checked out 201 208 20583930 07-13-2012 ci3ug os4ug mu3ug Completed Checked out 201 208 20583969 07-13-2012 ci3ug wt3ug mu3ug Completed Checked out 201 200 20583970 07-13-2012 ci3ug jc2ug mu3ug Completed Checked out 201 208 20583976 07-18-2012 ci3ug ci3ug mu3ug Completed Returned 201 200 20583980 07-13-2012 ci3ug ou4ug mu3ug Completed Checked out 201 208 20583981 07-13-2012 ci3ug ou4ug mu3ug Completed Checked out 201 208 20583982 07-06-2012 ci3ug ou4ug mu3ug Completed Shipped 201 208 20584001 07-13-2012 ci3ug oh5dp mu3ug Completed Checked out 201 200 20584002 07-13-2012 ci3ug ob2bg mu3ug Completed Checked out 201 200 20584028 07-13-2012 ci3ug ak2ug mu3ug Completed Checked out 201 208 20584029 07-13-2012 ci3ug ak2ug mu3ug Completed Checked out 201 208 20584039 07-30-2012 ci3ug cs2ug mu3ug Completed Returned 202 200 20584069 07-13-2012 ci3ug ou4ug mu3ug Completed Checked out 201 200 20584135 07-30-2012 ci3ug ou4ug mu3ug Completed Checked out 202 200 20584213 07-13-2012 ci3ug ci3ug cp4ug Completed Shipped 202 200 20584320 07-30-2012 ci3ug ou4ug mu3ug Completed Returned 201 208 205
More Information
• Pivot table to show which patron sites use UC as a pick-up location
mu3ug 247 cp4ug 73 ou4ug 45 ca2ug 17 si3tg 10 ws3ug 8 mo3bg 5 sl4gg 5 xa3ug 3 os4ug 3 mv4bg 3 ct3tg 1 bw3bg 1