FAQ content

Analyzing and exporting a Gate Count dataset

In this article

Getting there

Via the command bar

To analyze a dataset, click on  Analyze in the command bar. This will take you to the default dataset selected in your account's settings. If you are currently viewing the Record Data page for a dataset, however, it will take you to that same dataset's Analyze page instead.

Navigating to the Analyze Data page via the command bar


Via the homepage

In the Shortcuts box, select a dataset from the  Analyze Data In dropdown.

Navigating to the Analyze Data page via the homepage shortcuts


Via the Datasets page

Click on a dataset's Analyze Data () button in the Actions column.

Navigating to the Analyze Data page via the Datasets page


Generating reports

  1. Select the Date Range you want to analyze.
    1. The dataset description will display the date of the earliest record.
  2. By default, all libraries in your dataset will be included in your analysis. Use the Select Library field to limit your analysis to one or more libraries.
  3. Click the Go button.

Example of generating a report


Overview report

The Overview report provides a wealth of information, including:

  • A chart allowing you to break down your visitors by week, month, or year.
  • A statistical summary of your data, including the total, monthly average, and median number of visitors, as well as the busiest and least busy days.
  • A data table breaking down your visitors by month and library.
  • Pie charts showing the distribution of visitors by library, as well as by month.

Daily report

The Daily report provides a breakdown of your visitors by day, including:

  • Pie charts showing the distribution of visitors by day of the week, and weekday vs. weekend.
  • A graph showing you the daily total visitors for the reporting period.
  • A data table showing the total visitors by day and library.

Hourly report

The Hourly report provides a breakdown of your visitors by hour, including:

  • A pie chart showing the distribution of visitors by hour of the day.
  • A data table showing you the total number of visitors by hour of the day.
  • If your date range is set to 7 days or less, you can also see a graph of hourly visitors over that date range.

Daily/Hourly (DH) Grid report

The Daily/Hourly (DH) Grid report allows you to see the busiest days and times during a typical week. This includes:

  • A graph showing you the total number of visitors each hour of each weekday.
  • A data table that provides a matrix of visitors by hour and day.
  • A table of the top 10 busiest periods of a typical week.

This report can be a huge help when it comes to scheduling staff, students, and building hours, as it can help you identify your slowest and busiest times each day.


Trends report

The Trends report allows to see how the total number of visitors has changed over time. You can create charts to visualize trends in your data for the past 2 years, 3 years, 5  years, or even 10 years (if you have that much data!). In addition, you'll get a data table with each year's totals, with the ability to see year-over-year changes and the percentage change against the first year of the report.

Before running your report, make sure that you've selected a date range of one year or less. You can even use partial years, which can allow you to compare the same date range over the past several years. This can be useful, for example, if you want to compare just Fall Semester data over the past 5 years.

  1. Select the time period you want to compare against. This will be determined based upon the dates selected in your report. For example, if you generated a report from January 1, 2016, to December 31, 2016, and choose the last 2 years, then the Trends report will give you a comparison of January 1, 2015, to December 31, 2015, and your 2016 data.
  2. Click the Show Trends button to generate the report.
  3. Click on the Toggle Trend Details option above the table to view year-over-year comparisons.

Export data

The Export tab is where you can export the data of your current analysis to a CSV file. This will only include the filtered records in your report. If you want to export all of your dataset's data, therefore, make sure that you set your date filters to include all of your records.

Data can be downloaded for all libraries at once, or by individual library. Just click on a library's link to download a spreadsheet containing the date, gate start, gate end, visitors, and notes for each record.