hot mess to hot mama making over the sfx most popular journals report n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Hot Mess to Hot Mama: Making Over the SFX Most Popular Journals Report PowerPoint Presentation
Download Presentation
Hot Mess to Hot Mama: Making Over the SFX Most Popular Journals Report

Loading in 2 Seconds...

play fullscreen
1 / 22

Hot Mess to Hot Mama: Making Over the SFX Most Popular Journals Report - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Hot Mess to Hot Mama: Making Over the SFX Most Popular Journals Report. Melissa Platkowski Coordinator of Library Technology University of Wisconsin – Green Bay platkowm@uwgb.edu. About UW-Green Bay. Four-year campus with a few graduate programs

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Hot Mess to Hot Mama: Making Over the SFX Most Popular Journals Report' - bruce-wade


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
hot mess to hot mama making over the sfx most popular journals report

Hot Mess to Hot Mama:Making Over the SFX Most Popular Journals Report

Melissa Platkowski

Coordinator of Library Technology

University of Wisconsin – Green Bay

platkowm@uwgb.edu

about uw green bay
About UW-Green Bay
  • Four-year campus with a few graduate programs
  • Part of the University of Wisconsin System, which is made of 13 four-year campuses and 14 two-year campuses.
  • About 6,000 students
  • 16 permanent library staff
what is the most popular journals report
What is the Most Popular Journals Report?

Report #19 out of the SFX Statistics Queries

what does it count
What does it count?

For all the journals used in a given time period, this report counts:

  • Requests: Number of times a title is called up on an SFX menu
  • Clickthroughs: Number of times a link on the SFX menu for that title is clicked
some very useful data
Some very useful data…

Usage is independent of:

but a hot mess
…but a hot mess!

It comes out of SFX looking like this:

but a hot mess1
…but a hot mess!

It is a BEAST.

but a hot mess2
…but a hot mess!

It is unique every month.

  • It lists only journals with at least one request or clickthrough
  • Titles are added, deleted, and changed every month
but a hot mess3
…but a hot mess!

If a journal title starts with the word “The”, it is on the list under “T”.

There are hundreds of these.

but a hot mess4
…but a hot mess!

Some Weird Stuff shows up on it.

the first spruce up
The First Spruce-Up
  • Text-tab delimited file converted to Excel.
  • Fixed alphabetical listing (most of the time, but missed some!)
  • Printed and put into binders.
no celebrity stylists
No Celebrity Stylists

My “Geekiness Ranking” is not very high, so I had to work with tools I knew. (No scripts!)

www.innergeek.us/geek.html‎

the extreme makeover
The Extreme Makeover

Modifying the Most Popular Journals report:

  • To pull out the “dead end” no-object-ID data, you need the Object ID on the report.
  • It’s a simple tweak to the settings for the report (ask Ex Libris tech support), but you do need to muck around in Unix and…

break your symbolic link.

(Scary, but worth it.)

breaking a link too scary
Breaking a link = too scary?
  • You can also use the Lookup tool in SFX admin to give you the object ID’s for the titles on your report.
  • Use this to retroactively add the Object ID to past reports.
  • I didn’t want to do this every month.
the facial for y our data
The “Facial” for Your Data:

Clean up the spreadsheet:

  • Weed out the items with no Object ID
  • Delete the query parameter data at the end of the report
  • Correct the journal titles that begin with “A” or “The” and re-sort by title
excel magic pivot tables
Excel Magic: Pivot Tables

What’s a pivot table?

Pretty

Data!

excel magic pivot tables1
Excel Magic: Pivot Tables

So you give Excel the data…

one hot mama
One Hot Mama!

And it cheerfully provides this…

…and you just use the Find feature in Excel to search by title or ISSN!

the big reveal
The Big Reveal

Pretty

Data!

be a stats rock star
Be a Stats Rock Star!
  • Give good data, quickly!
  • Low maintenance!
  • Collection Management will love you!
  • No more Big Fat Binders!
personality quirks
Personality Quirks

Some things just don’t quite work in the pivot table:

  • Title variations that don’t blend
  • Titles with no ISSN
guide questions
Guide & Questions

I have written a step-by-step guide to making over the Most Popular Journals report, from cleaning up the Excel files to creating the pivot tables. I will post them to EL Commons with my notes and presentation after the conference.

Questions?

platkowm@uwgb.edu