Published: 13th February 2018
The Alumni Numbers Report breaks down our Alumni database into various categories, for easy access to statistics such as age and gender breakdown, contactable by email/phone/post etc, and donor numbers.
Please find an explanation of all tabs on the Alumni Numbers report below.
Please note that Discoverer does not work with Chrome Browser, so you should use either Internet Explorer or Mozilla Firefox.
__________________________________________________________________________________________________
all counts month_year
This tab tracks the total number of Alumni on a month by month basis.
The graph rises and falls depending on factors including deaths and graduations.
__________________________________________________________________________________________________
Age Breakdown by Month Year
This breaks down the Alumni totals into age groups, e.g. 31-40 etc. Again, it shows this evolving on a monthly basis.
__________________________________________________________________________________________________
Age Breakdown Graph
Contains the same info as the previous tab, but presented in graph form.
__________________________________________________________________________________________________
Gender Breakdown by Month Year
This breaks down the total number of Alumni into Female, Male and Unknown columns.
__________________________________________________________________________________________________
Gender Breakdown Graph
This contains the same information as the previous tab, but presented in graph form.
__________________________________________________________________________________________________
Contactable
This breaks down the alumni database into two categories depending on whether they are Contactable or not.
It gives this figure both in numbers and in percentages.
__________________________________________________________________________________________________
Addressable
This shows the number of alumni we have addresses for (excluding Opt Outs).
__________________________________________________________________________________________________
This shows the number of alumni we have email addresses for (excluding Opt Outs).
__________________________________________________________________________________________________
Phone
This shows how many alumni we have a phone number for (any type) excluding TPS numbers. If a constituent has one TPS number and one non-TPS number, they are included.
__________________________________________________________________________________________________
TPS Permission
This shows the number of alumni we have permission to call even though their numbers are TPS registered.
__________________________________________________________________________________________________
Gender & Age Breakdown by Month Year
This tab breaks down the Alumni database by age and gender, and tracks this on a month by month basis.
__________________________________________________________________________________________________
Alumni Numbers by Country
This breaks down the Alumni database by country and by UK region.
Before displaying this tab, a box appears on screen named Edit Parameter Values.
Click on the torch icon to the right of the search box.
This opens the Select Values box. If you would like to select all countries to view, click on All values.
If you would rather choose one or more selected countries, click Selected values. Then double click on a country/region from the Displayed values table on the left to move it to the Selected values table on the right.
If you find the country is not listed in the left hand table, you can click the arrow underneath the Displayed values table to display the next 100 countries/regions.
Finally, click OK to run the report.
__________________________________________________________________________________________________
Multi Sheet
This tab can be used to filter the data by all the measures available in the reports. e.g. Age Distribution, Addressable etc.
In order to filter, just select one of the options in the top part of the tab and choose Y or N (the default is <All>).
The Alumni Count SUM will change depending on the filters you have selected.
__________________________________________________________________________________________________
USA Alumni Counts by State
This tab displays a breakdown of every US state and how many alumni we have in each.
It displays these figures on an ongoing monthly basis so the figures can go up or down.
__________________________________________________________________________________________________
Rating by Contactable
This gives a breakdown of the number of rated prospects we have who are contactable.
It is divided into the 5 rating categories of A*, A, B, C, and D.
__________________________________________________________________________________________________
Rating by Faculty
This breaks down the rated prospects into the various faculties they graduated from.
It’s also divided by rating.
__________________________________________________________________________________________________
Rating by Contactable Graph
This gives the same information as Rating by Contactable (Step 15) but in graph form.
__________________________________________________________________________________________________
TPS Numbers
This report shows the number of alumni where all of their numbers are TPS registered.
__________________________________________________________________________________________________
Business Details
This shows how many alumni records we have employment contact details for. This does not necessarily mean that we can contact them at their business, just that we know something about their employment (e.g. position and organisations).
It breaks this down by numbers and percentages.
__________________________________________________________________________________________________
Business Details Graph
This displays the same information as Business Details but in graph form.
__________________________________________________________________________________________________
TPS Numbers
This displays the number of alumni where at least one of their contact numbers is TPS registered.
__________________________________________________________________________________________________
Alumni Current Year Donor Numbers
This displays the number and percentage of the alumni database who have donated in the current year.