TUG-Libraries Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU
Home TUG Statistics & Reports
Documents Contacts Search

PowerPlay Cube Documentation

Search Reports Status Database

Cube File Name:

  

OPAC primo.mdc

Revision Date:

2011-10-11

Cube Developer:

Gail Sperling

 

Cube Description:

This cube contains information about Primo events and searches. The Primo CLICK_EVENTS view includes counts of various types of activities performed by users in Primo. The
SEARCH_STATISTICS view includes counts of searches done by users in Primo. Some of the counts from the SEARCH_STATISTICS view may also be inlcuded in counts from the CLICK_EVENTS view.

Measure Name

Description

Drill Through Reports

Primo Totals

A count of all Primo search related event types in the CLICK_EVENTS view of Primo (this is a total of the "Primo Count" and "Facet count" measures).  

Primo Count

A count of all Primo search related event types except "Refine" and "DS" in the CLICK_EVENTS view of Primo  
Facet count

A count of "Refine" event types in the CLICK_EVENTS view. "Refine" events use facets.

NOTE: For Refine event types only the first facet of any facet type will be counted in the PowerPlay cube. More details on the facets used can be obtained by doing a drill_through report

Primo_facets_drill
Search Count

A count of the searches from the SEARCH_STATISTICS view in Primo

NOTE: counts from the SEARCH_STATISTICS may duplicate some counts from the CLICK_EVENTS

 
DeepSearch_Count A count of the results returned from Primo Central "DS" events in the CLICK_EVENTS view  

Dimension Name

Dimension Hierarchy

Description and Notes

Valid Measures

Alternate Hierarchy

Date (Fiscal)

Year

 

Date that the script was run to gather event or search statistics (May 1 - Apr 30) Year refers to the end year in the fiscal year.

 
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count

Special Categories for:

  • Current Month
  • Last Month
  • YTD
  • Prior YTD
  • YTD Grouped

Month

Week

Event Type

Event type Group

 

The event type from the CLICK_EVENTS view. If an event type has subtypes (eg) hlp and GetIt the event type can be expanded to show the subtypes.

  • Primo Totals
  • Primo Count
  • Facet count
  • DeepSearch_Count

Event type

Event subtype

View

View Institution

 The view used for the event. There are views for mobile users and pc users in each institutional group
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count
View

User Group

UserGroup Institution

If the user logged on the user group is the user's patron group from TRELLIS, otherwise the user group defaults to GUEST
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count

 

 
User Group
Day Weekday/Weekend The day of the week from the event date or search date
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count
 Alternate drill for all days
Day name
Hour

Time of day grouping (e.g Morning, Afternoon)

 

 The hour from the event date or search date (11 = 11:00 to 11:59). The date is the date that the script to gather event and search statistics is run.
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count

Alternate drill for all hours

Hour
Institution Institution Indicates the institution where the event or search originated from
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count
  
On_Campus On_Campus Indicates whether the user was on-campus or not
  • Primo Totals
  • Primo Count
  • Facet count
  • Search Count
  • DeepSearch_Count
  
Facet-Top level Top Level Facet Inidcates whether the user refined their search by the top level facet
  • Facet count
  
Facet-LC LC Facet first letter Indicates whether the user refined their search by LC facet
  • Facet count

LC Facet subcategory
Facet - Dates Date facet - start date Indicates whether the user refined their search by date facet. Grouped by start date and then by end date, sorted in reverse chronological order.
  • Facet count

Alternate drills

  • By end date
  • All dates
Date facet - end date
Facet-Record Type Record Type facet Indicates whether the user refined their search by record type facet
  • Facet count
  
Facet-Topic

Topic Facet first letter

 Indicates whether the user refined their search by the topic facet
  • Facet count
  
Topic Facet first word
Topic Facet
Facet-library Topic Library Indicates whether the user refined their search by the library facet
  • Facet count
  
Facet-domain

Domain Institution

 Indicates whether the user refined their search by the domain facet
  • Facet count
  
Domain facet
Facet-Journal Title

Journal Title firstletter

 Indicates whether the user refined their search by the journal title facet
  • Facet count
  
Journal Title firstword
Journal Title facet
Facet-Language Language group (English or Other) Indicates whether the user refined their search by the language facet
  • Facet count
  
Language facet
Facet-Creator Creator firstletter Indicates whether the user refined their search by the creator facet
  • Facet count
  
Creator firstword
Creator facet
Facet-Genre Genre firstletter Indicates whether the user refined their search by the genre facet
  • Facet count
  
Genre facet
SCOPE_TYPE Search scope type  
  • Search Count
  
SCOPE_NAME Search scope institution  
  • Search Count
  
Search scope name

 

PowerPlay Model File Name:

OPAC2.pyi