Collecting your library’s form fields data
This document provides instructions to AskAway coordinators on collecting forms fields data for their institution.
Print version (.doc) of this document.
- Login to the Administrator's account in Firefox
- Go to the drop-down box in the top right of the screen. Select Ask.
- Select the tab “Review Transcripts” then click on the link “Form Fields” (directly below the tabs)
Select Form Fields
- Month: Select the month you want from the dropdown menu
- Format: Click "View Excel File"
- Field Data: Unclick "Patron Email Domain" in the left column
- Field Date: Unclick "IP Address" if it's in the right column
- Do not use Include Labels “As Column Headings” as the tables will not print out correctly. Always use “As Table Cells”.
- Click the gray Submit button at the top
Delete the Practice Questions
Practice questions (such as those used for training) are included in these statistics. Follow the steps below to identify and delete them.
- In the Window menu, select the open Workbook
- Click on any data cell until the cells are white, not blue
- In the Data menu, choose Sort…
- Sort by Field 12
- In Field 12 (Referrer) identify and delete any rows from the Referrer: http://www.questionpoint.org/crs/servlet/org.oclc.ask.PatronChatForm
- If there are many rows, you may wish to use Edit>Find to search for "PatronChatForm". Use the Search by Columns option.
- Select and delete the identified rows (these are Practice Questions)
Add Meaningful Headings
Some of the default headings are not meaningful. As a guide, here is what we re-name these columns:
- Field 1 > Patron Type
- Field 2 > Location
- Field 3 > Course
- Field 12 > Referring Web Page
- Fields 13 > Browser/OS
- Field 14 > Cobrowse
- Field 15 > Category
Identifying Mobile Users
Patrons who access AskAway using mobile devices can be identified by the word “mobile” in the Browser/OS column. Android, iPad and iPhones will be identified by their respective names, as well as by the word “mobile”. It’s a multi-step process to gather all instances of this word together. This is the most straightforward way we have found to organize the data in a way that makes it possible to interpret:
- Sort by the column Browser/OS. To sort, click on any cell so that nothing is highlighted. Go to menu: Data>Sort… and select Browser/OS, using the first drop-down box.
- Use ctrl+f (or cmd+f for Macs) to find all instances of the word “mobile” in the Browser/OS column. This indicates that a mobile device was used.
- Insert a column beside the Browser/OS column, and place a check beside each instance. For the service-wide spreadsheet, we have titled this column “Mobile Device Detected”.
- Sort by the column Mobile Device Detected. To sort, click on any cell so that nothing is highlighted. Go to menu: Data>Sort… and select Mobile Device Detected, using the first drop-down box. In the radial dial, select “ascending” (this should be the default).
- Use the numbers on the left side of the spreadsheet to determine the number of mobile users, and the total number of users for the month.