Hello Claire,
The list URL as displayed in the Google Analytics is actually quite useful as it provides a unique identifer to link back to your data from Aspire.
I haven't done all of this before, but just thinking about it briefly, you can export your top 10 (or 100, or whatever) lists from GA into Excel. A quick macro or text add for each line to add in your own Aspire domain will give you the full URL of each list.
You can then do an export from your All Lists report in Aspire, which gives you the list title and the List URI, which you can match on with your data from your GA export.
If all you are interested in is dragging over the (human sounding) List Title of the list, you can do a VLOOKUP in Excel to dredge over the information, using the list URI as your lookup value, and then use the table array to bring in the list title. Vlookups only work to the 'right' of your lookup value so you might have to re-arrange column A and B in your All Lists export. (there are formulae out there for a 'left' vlookup if you are confident with Excel)
If you want to get a little bit more complicated, and assign each of the lists with their relevant subject librarian, you would need to build a small relational Access database, with maybe four or five tables to link up. In this you'd use your hierarchy data, and you'd also need to manually create a small table (called something like "subject librarians") which would have information about the relevant faculty or department alongside the relevant librarian.
It really depends on what your hierarchy looks like, but your tables could be:
Your GA export (with list URI info)
linked to -> All Lists export (with list title, and "linkedToNode" - which is the module in the hierarchy that the list is linked to)
linked to -> Module hierarchy table, with parent courses info
linked to -> Courses hierarchy table, with parent faculty info
linked to -> Faculty - and subject librarian information which you have manually entered
(Obviously if your university hierarchy has another level e.g. school or deparment, you'll have another table)
... thus your query links back all the way up the levels from the lists in your GA export all the way up to the faculties, where you can see which librarian is in charge of which list... Once you've built your queries it's just a matter of updating it every so often with fresh data from GA, the All Lists export, and your hierarchy files.
Hope that's clear... I'll be in Birmingham to show something similar...
########################################################################
To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
|