Statistics Report

Statistics reporting allows you to view and download statistical data about your projects, activity groups and locations. Within these categories there are number of options to filter by allowing users to produce reports on the number of unique attendees, attendances, contact hours, session hours, sessions delivered and more.

Accessing the Statistics Report
Column Headers
Creating a Reporting Template
Webinar
Other Reporting Tools
Key Terms

Accessing the Statistics Report

To access the Statistics Report go to Reports > Statistics

From here you can choose the following filters:

Once you have chosen the area of your delivery you wish to report on, you can then decide how this information appears in the report by selecting a particular grouping option.

Finally, you can decide on a time period that you want to report on. By adding a start and end date to the period that you want to report on, only sessions that fall within this time frame will be included in the report. If you leave these fields blank, the report will show all of the information that matches the criteria that you set above.

You also have the option to add a title and subtitle to your report. This allows you to make it easier for others to know what is included in the report. Once you have finished filling out the report filters, click on the GET STATS button to generate your report.

Once you have generated your report, it will look something like this:

You can remove any columns from the report that you don’t need. Do this by clicking on the Remove button above the column you do not require.

If you do remove any columns, the following message will appear at the bottom of the report letting you know which ones have been removed.

Column Headers

• Attendees (all people) – The number of people who attended sessions in any capacity.

• Attendees (participants) – The number people who attended sessions as participants.

• Attendances (all people) – The number of times anyone has attended in any capacity.

• Attendances (participants) – The number of times participants took part.

• Contact hours – The number of hours that each attendee spends in a session combined. For example if a session lasts 2 hours and five people attend, this represents 10 contact hours. The contact hours from each session are added together to arrive at the total contact hours, meaning contact hours cannot be calculated by simply multiplying the number of attendances by the amount of session hours.

• Session hours – The total length of time that sessions have been run for.

• Sessions delivered – The number of sessions that have been delivered.

• Accreditations gained – If any accreditations were gained as part of this particular activity.

• Cost – The total cost of this activity to the organisation. This cost is an average across all of the activities in your project.

• Cost per participant – The cost average to the organisation per participant.

• Cost per participant attendance – The average cost to the organisation for each attendance on a particular project/activity.

• Cost per hour delivered – The average cost per hour to deliver a particular activity.

• Cost per session delivered – The average cost for each session that is delivered, within a particular activity.

• Cost per accreditation gained – The average cost to the organisation for each accreditation gained by participants on a particular activity.

By clicking the Download button, you can generate the same report in Excel. If you have removed any columns from the report in Upshot, these will also be removed from the Excel report. This can then be used for further analysis to make relevant graphs or charts. Click here for more information on how you can create graphs and charts from your download.

Creating a Reporting Template

After you have entered the filters you wish to report on and have clicked GET STATS

You can choose to save the reporting filters you have chosen using the Save report function.

Simply enter a name for the report and click Save.

The following message will be displayed:

Note: These templates are personal to your individual Upshot user profile and so will only be visible to yourself.

Webinar

As part of the Upshot Community Webinar series in 2020 a thirty minute webinar was delivered called ' Monitoring your impact: Upshot Reporting 2' which focused on both Indicators and the Statistics Report (from 19:10) and this can be seen below:

Considerations

When using the Statistics Report it is possible to 'Group by' elements that attendees could meet the criteria for multiple times, for instance when grouping by the 'activities' that individuals have attended (i.e. they could have attended multiple) or by a multiple choice data field on their profile.

When running the report the Attendees (all people) and Attendees (participants) will give you a figure for each individual row and then provide a total at the end of all these figures summed together. It is worth keeping this in mind when reporting to ensure you are reporting on what you require.

For instance, if I report by a 'Project' and do not 'Group by' any element I will get the total amount of unique attendees that have attended anything within the project, this could be 100 attendees. If I then run the report by 'Project' and 'Group by' Activity, the report will present the total number of attendees for each individual activity (e.g. Workshops 20 attendees, Sport Sessions 50 attendees etc.) and then 'Total' these at the bottom. The total presented may be higher than 100 because the same attendee may have attended multiple different activities in this instance.

Other Reporting Tools

Whilst the Statistics Report may be helpful for understanding headline numbers around your Project users may have a more complex query that requires additional filtering, or an export of the data to solve. Additional filtering of the data, for a query such as 'The number of people that attended a certain project who were a certain Gender, certain Age and Ethnicity' could be done by using the People Report. Completely exporting the attendance data, allowing you to manipulate and query further can be done via the Attendance Report.

As mentioned above it is possible to include Head Count data when reporting using the Statistics Report, at other times users may want to 'only' include Head Count data in their reporting queries. More around Reporting on Head Counts can be found here.

Key Terms

Statistics Report:

The statistics report allows you to see headline numbers across different criteria in regards to your project: