meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
accutrack:reportsmanual:visits-reports [2020/01/16 09:50] – [WAIT TIMES (INTAKE SYSTEM)] nick | accutrack:reportsmanual:visits-reports [2020/02/05 10:24] – santi | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== VISITS REPORTS ====== | ====== VISITS REPORTS ====== | ||
- | ===== BY ACTIVITY ===== | + | {{ : |
- | ==== BY ACTIVITY | + | ==== BY ACTIVITY ==== |
- | ===== ACTIVITIES WITH SESSIONS ===== | + | {{ : |
- | ==== Activities with Sessions | + | **Purpose: |
- | ===== STUDENT ATTENDANCE- DETAIL ===== | + | **Available Filters:** Reporting period, Students, Activities, Student Groups, Lab IDs |
- | ==== STUDENT ATTENDANCE - SUMMARY ==== | + | **Display Options:** Show/hide visitor ID. Time format (hour: |
- | ===== VISITS SUMMARY ===== | + | **Grouped by:** Category, activity, student |
- | ===== WEEKLY STUDENT TIME ===== | + | **Order:** Alphabetical by category name, activity name within each category, student’s last name within each category |
- | ===== WEEKLY STUDENT VISITS ===== | + | **Summary Report Available: |
- | ===== CHART VISITS ===== | + | **Description: |
- | ===== SERVICE USAGE ===== | + | <note tip> |
- | ==== SERVICE USAGE (Summary View) ==== | + | This report also shows the total number of hours students spent on each activity and on each category of activities. |
- | ===== SERVICE TYPE USAGE WITH TOTALS ===== | + | === BY ACTIVITY (Summary View) === |
- | ===== SERVICE TYPE USAGE (ACTIVITY INCLUDED) ===== | + | {{ : |
- | ===== VISITOR HISTORY ===== | + | ==== ACTIVITIES WITH SESSIONS |
- | ===== ZERO VISITS ===== | + | {{ : |
- | ===== NEW VISITORS ===== | + | **Purpose: |
- | ===== VISIT TYPES ===== | + | **Available Filters:** Reporting period, Activities, Students, Student Groups, Lab IDs |
- | ===== WALK-INS VS. APPOINTMENT VISITS ===== | + | **Grouped by:** Category, activity, student |
- | ==== WALK-INS VS. APPOINTMENT (Summary View) ==== | + | **Order:** Alphabetical by category name, activity name within each category, student’s last name within each category |
- | ===== WAIT TIMES (INTAKE SYSTEM) ===== | + | **Summary Report Available: |
+ | **Description: | ||
+ | |||
+ | === Activities with Sessions (Summary View) === | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== STUDENT ATTENDANCE- DETAIL ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Activities, Students, Student Groups, Lab IDs | ||
+ | |||
+ | **Display Options:** Show/hide visitor ID. Time format (hour: | ||
+ | |||
+ | **Grouped by:** Student, category, and activity | ||
+ | |||
+ | **Order:** Alphabetical by student name, category, and activity | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | The total time the student spent on each activity and on each category of activities is also shown in this report. | ||
+ | |||
+ | === STUDENT ATTENDANCE - SUMMARY === | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== VISITS SUMMARY ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** None | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== WEEKLY STUDENT TIME ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Activity, Instructor | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Student’s first name | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | < | ||
+ | |||
+ | < | ||
+ | |||
+ | ==== WEEKLY STUDENT VISITS ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting Period, Activity, Instructor | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Student’s last name | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | < | ||
+ | |||
+ | Click on “OK” and the report will update. You can apply the same filters to the categories, classes, instructors or even classes, and you can even use a combination of these filters! | ||
+ | |||
+ | < | ||
+ | |||
+ | ==== CHART VISITS ==== | ||
+ | |||
+ | The Chart Visits report will analyze your traffic patterns using Excel charts and tables. Start by selecting the reporting period and any other available filters you would like to use. Now select the “Chart Visits” report, and the click the “Show Report” button. You will then be presented with a Save As screen where you can save the report if so desired. After you click either Save or Cancel in the Save As screen, AccuSQL/ | ||
+ | |||
+ | **Important: | ||
+ | |||
+ | The Chart Visits report is really several reports in one and it enables you to analyze how busy your center(s) are by day, week, and overall in a series of pivot tables that a are generated on tabs and the bottom of the generated Excel document. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Click the tabs at the bottom of Excel to view the available view and also the raw table data that is used to generate the pivot tables. | ||
+ | |||
+ | For example, the Weekly Sign-Ins tab is the first one generated by the report output. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | and the raw data used to generate that pivot table is located in the Weekly Sign-in Table tab: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Note:** To learn more about PivotTables and how to use them, try the Microsoft Training: Create a PivotTable and analyze your data page at: https:// | ||
+ | |||
+ | ==== SERVICE USAGE ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Start date and time, end date and time, Students, Activities, Tutors, Instructors, | ||
+ | |||
+ | **Grouped by:** Service type | ||
+ | |||
+ | **Order:** Service type, First/Last, Last/ | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | < | ||
+ | </ | ||
+ | |||
+ | === SERVICE USAGE (Summary View) === | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== SERVICE TYPE USAGE WITH TOTALS ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Start date and time, end date and time, Students, Activities, Tutors, Instructors, | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Service Type | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | < | ||
+ | |||
+ | ==== SERVICE TYPE USAGE (ACTIVITY INCLUDED) ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Start date and time, end date and time, Students, Activities, Tutors, Instructors, | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Service type | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== VISITOR HISTORY ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Students, Activities, Tutors, Student Groups, Service Types, Lab IDs | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Last/First, First/ | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== ZERO VISITS ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Students, Activities, Student Groups, Service Types, Sports, Lab IDs, registered or non-registered students | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None. | ||
+ | |||
+ | **Order:** Last/First, First/ | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== NEW VISITORS ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Students, Activities, Student Groups, Lab IDs | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Order:** Last/First, First/ | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== VISIT TYPES ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** None | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | ==== WALK-INS VS. APPOINTMENT VISITS ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Students, Activities, Tutors, Instructors, | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Student, Tutor, Activity ID, Activity, Category, Service, Instructor, Lab ID, Sign In Time | ||
+ | |||
+ | **Summary Report Type Available: | ||
+ | |||
+ | **Description: | ||
+ | |||
+ | === WALK-INS VS. APPOINTMENT (Summary View) === | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== WAIT TIMES (INTAKE SYSTEM) ==== | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **Purpose: | ||
+ | |||
+ | **Available Filters:** Reporting period, Students, Activities, Tutors, Student Groups, Lab IDs, Tutor Groups | ||
+ | |||
+ | **Display Options:** None | ||
+ | |||
+ | **Grouped by:** None | ||
+ | |||
+ | **Order:** Student, Tutor, Activity ID, Activity, Category, Admit Time | ||
+ | |||
+ | **Description: | ||
---- | ---- | ||
[[accutrack: | [[accutrack: |