Statistics

Statistics Overview

The Statistics module is used to produce statistical reports on SFX usage. Reports include the following information for each SFX transaction:

IP address of user
Date of the SFX request
SFX targets displayed in the SFX menu
SFX targets clicked in the SFX menu
SFX sources used to send the SFX request to the SFX server (sid)
Type of SFX service requested
Whether or not the getFullTxt service was offered in the SFX menu
Object type
Institute, user group, and faculty

SFX statistical reports also include attributes of the context object, such as:

ISSN
ISBN
ArticleTitle
JournalTitle
BookTitle
ConferenceTitle

Queries

This section includes the following:

Scheduling Queries
Scheduled Queries List

To create a statistical query, click Queries from the Statistics section of the Data Management area.

Statistics

The Statistics Queries window opens:

Statistic Queries

The following queries are available:

Number of SFX requests and clickthroughs per dateThe number of times users clicked the SFX button in all sources over a specified period of time and the number of clickthroughs.
Number of SFX requests and clickthroughs per source The number of times users clicked the SFX button in any particular source (rec$sourceId) and the number of clickthroughs; output is sorted by source name.
Number of SFX requests and clickthroughs sorted by object typeThe number of times SFX services were requested and the number of clickthroughs, based on the type of object. Output is sorted by object type. If there is no match between the object in the OpenURL and the SFX database, the Object Type used is genre.
Number of SFX requests and clickthroughs per service typeThe number of SFX requests and clickthroughs for each service type.
Number of SFX requests with/without full-text servicesThe number of SFX requests that resulted and did not result in full-text services in the SFX menu.
Top target services shown in the SFX menu The number of times the most popular targets services appeared in the SFX menu.
Number of clickthroughs per target The number of times specific targets were selected in the SFX menu.
Number of clickthroughs per target service The number of times specific target services were selected in the SFX menu.
Number of clickthroughs for one particular serialThe number of times one particular full-text journal was selected in the SFX menu for different targets.
Most popular serials selected by targetThe number of times the most frequently requested full-text journals were shown and selected in the SFX menu from one particular target.
Most popular journals selected by source The number of times the most frequently requested full-text journals were shown and selected in the SFX menu from a particular source.
Journals requested but have no full-text The top journals for which SFX requests resulted in no full-text services in the SFX menu.
Selected document delivery targets by source The number of times users clicked getDocumentDelivery targets in any particular source (rec$sourceId).
Books accessed via SFX ranked by use Books (ISBNs) sorted by usage within a specified time period. Output includes ISBN book title, book OBJECT ID, and the number of times accessed. If multiple ISBNs exist for the object, they are all included in the report. If no title or object ID exists, the statistics result include a line with the text No title or No object id.
Services preferred over full-text The services users are choosing when full-text is available as a service in the SFX menu and users choose another service.
Unused full-text journals The journals for which there are active full-text portfolios that did not appear in the statistics tables. Note that the RSI index must be built in order for this query to be usedv. For more information on building this index, refer to the Rapid Service Indicator section of the SFX System Administration Guide.
Number of SFX requests which resulted in SFX menu screen without services – The number of times SFX services were requested and no results were displayed in the SFX menu.
Number of SFX requests and clickthroughs by IP address – The number of times SFX services were requested and the number of clickthroughs, sorted by IP address.
Most popular journals The number of times the most frequently requested full-text journals were shown and selected in the SFX menu.
OpenURLs that resulted in no full-text services, selected by source The OpenURLs for a particular source where SFX requests resulted in no full- text.
Unused full-text journals per target – Per target, list the journals for which there are active full‐text portfolios that did not appear in the statistics tables. Note that the RSI index must be built in order for this query to be used. For more information on building this index, refer to the Rapid Service Indicator section of the SFX System Administration Guide.

Click a query. The following window opens:

Query Input

Fill in the fields according to the following table. Note that the options vary depending on the query selected:

Statistic Queries
Field	Description
Total by:	For a total by time period: select a time period by which to total the results. For a total by Source: the result is displayed with a count per Source (this option is available for Query 5)
Show	Select one of the following: All Top 10 Top 50 Top 100
Group by Netmask:	This option is applicable only for query 18: 255.255.255.255 – Each IP address is listed separately in the query results. 255.255.255.0 – IP addresses that start with the same three values are grouped together in the query results. For example, 10.1.2.31 and 10.1.2.233 are grouped together as 10.1.2.0. 255.255.0.0 – IP addresses that start with the same two values are grouped together in the query results. For example, 10.1.2.31 and 10.1.3.233 are grouped together as 10.1.0.0.
Dates to Query	Relative Date Range – Select a time period relative to the date the report is run. Sunday is considered the first day of the week. Specific Date Range – Set a specific date range.
Filters	Enter information to include the filter information in the results. Select Exclude to exclude the filter information from the results. Institute – If institutes have been specified in your instance, they are displayed in the institute filter drop-down list. DEFAULT is also listed, so that it is possible to include a filter on the DEFAULT institute as well. More information about institutes can be found in the Institute Feature section of the SFX Advanced User’s Guide. Format – Select a format. HTML is the default. The list of formats corresponds to the sfx.responsetype information sent in the OpenURL. When no sfx.responsetype is sent in the OpenURL, the default (HTML) is used. The list of formats is taken from the data currently in the offline STAT tables, so if XML requests are not set in the instance, these formats are not displayed. Requests with the following sfx.responsetype are not stored in the SFX statistics tables (since they are not requests initiated by an end-user or performed on behalf of a specific end-user): image-small image-large service_exist Usergroup – Enter a user group name. This information is set as part of the authentication process of MetaLib. Use a space to separate multiple user group names. Faculty – Enter a faculty name. This information is set as part of the authentication process of MetaLib. Use a space to separate multiple faculty names.
IP Address	Specify multiple IP addresses or ranges. Use an asterisk (*) as a wildcard. Use a space to separate multiple IP addresses or ranges.
Output	Format – Select an output format: HTML Plain text Delivery – Select a delivery method Screen E-mail

If you select e-mail for the output delivery method there is a 500 KB file size limit by default. If the file size exceeds this limit, the following message is displayed:

A query result was generated by SFX. However, the file was too big to include as an attachment.

It can be retrieved on the server at:

/exlibris/sfx_ver/sfx4_1/<sfx_instance>/dbs/scratch/stats_<instance>_<query)_<timestamp>.html

You can increase the file size limit by entering a new file size limit (in bytes) in the file_size_limit parameter of the following section of the config/sfxctrl.config file:

Section "stat"

file_size_limit ""

EndSection

In query 11, it is possible to use truncation by using an asterisk (*) when selecting or specifying sources.
- Example 1 – To get information about the most popular journals in all EBSCO Host databases, select one of the EBSCO Host databases from the Source drop-down list. In the adjacent text box, the source sid value is displayed—for example, EBSCO:aph. Change this value to EBSCO* to make sure the query results in statistics data for all EBSCO Host databases.
- Example 2 – To get information about the most popular journals in all sources that send a sid value, from the Sources drop-down list, select ALL SOURCES.
- Example 3 – To get information about the most popular journals in all sources that do not send a sid from the Sources drop-down list, select NO SOURCE or leave the text box empty.
Use query 19 to get information about the most popular journals, regardless of source information.

Scheduling Queries

To schedule a query to be run, click Schedule. The Scheduling Parameters dialog box opens:

Scheduling Parameters

Select a day, date, and time to run the query and enter an e-mail address to which to send the results. Click Submit. The query is run against the offline STAT tables. If you selected Screen as the output format, the results are displayed. If you selected E-mail as the output format, the results are e-mailed to you. By default there is a 500 KB file size limit for the e-mail output format. For information on changing the default, see the end of Queries.

For query 20, the output format is slightly different. For each request in the result output, the OpenURL info is included in the .txt version of the statistics report.

In the HTML version, you can view the OpenURL by moving the mouse over, or clicking the small SFX button next to, each request. Clicking the SFX button submits the OpenURL and displays the SFX menu.

Note that for this query, a change was made in the SFX database STATISTICS tables to store OpenURL information. SFX statistical usage information gathered before the database changes (for example, SFX version 3 statistics data) does not include OpenURL information. If this is the case, a red cross indicates that no OpenURL information is available for the request.

Scheduled Queries List

To see a list of the scheduled queries, click Scheduled Queries List. The following window opens:

Scheduled Queries List

To view the details of the scheduled query, click the query.

UStat

UStat, a hosted service provided by Ex Libris, analyzes usage data according to COUNTER (Counting Online Usage of Networked Electronic Resources) standards—the set of widely accepted standards and protocols for reporting usage statistics to libraries and information providers.

UStat supports the following:

The upload of COUNTER statistics obtained by the library from information providers
Cross-vendor platform reports
Journal Report 1 (Number of Successful Full-Text Article Requests by Month and Journal) and Database Report 1 (Total Searches and Sessions by Month and Database), as defined in the COUNTER Code of Practice.
NISO Standardized Usage Statistics Harvesting Initiative (SUSHI)

For more information on UStat, refer to the UStat User’s Guide, available in the Documentation Center.