Within SchoolsBuddy we have some pre-built queries to enable you to ensure your parents data is as good as possible.
Login as an admin.
- Click on Reception
- Click on Users
- Check the Data Checks option
- Choose a query from the dropdown box
Definition of the queries below:
* Important starting queries
* Students with no linked accounts
Show a list of students who do not have at least one linked parent account.
Students with inactive parent accounts
At the start this should be the same count as all of your students as none of your parents are live. Useful as you can track initial signups and usage.
Students who have never attended an activity
Useful later to see those students that have not been in at least one activity since the inception of SchoolsBuddy at your school.
* Students where all linked accounts are missing an email address
Shows a list of all students whereby all of their linked accounts (parents) are missing an email address. Parents can be imported if they have a mobile number but not an email in which case they are generated a 'dummy' random email.
* Students with all linked accounts having no mobile numbers
Useful for safeguarding and checking of your own MIS/SIS to see if all students have at least one parent with a mobile number.
Parents with no mobile number
Displays a list of parents with no mobile number.
Parents and students with missing MIS Id
Displays a list of manually entered parents and students (Not always correct but if the student / parent has come from an MIS / SIS link their MIS ID will never be empty.
PLEASE NOTE: If you update your MIS / SIS system to try and fix some of these issues please note updates to SchoolsBuddy only happen overnight so please check again the next day.