Question 1

Adding and using filters

Accepted Answer

Filtering your data

You can think of each "Analysis" page (e.g. Performance, Interactions etc) as being a bit like a giant spreadsheet filled with data. And there's a lot of data - far too much to display all at the same time.

| 💡 Analysis pages aren't actually spreadsheets but it's a good way to visualise what you are doing.

Using combinations of filters you can reduce this data based on your own specific criteria e.g. "I only want to see interactions that our WP teams performed last month".

| 💡Using the spreadsheet analogy you are reducing the number of rows.

Watch a quick video

${frame}Adding filters

Question 2

Definitions of the available performance data

Accepted Answer

Definitions for performance filters

| There are 219 available data fields.

Below is a breakdown of the data filters and fields that are available to query and report against in performance:

Census Data (England)
KS4 (England)
KS4 pupil destinations (England)
KS5 (England)
KS5 student destinations (England)
KS5 student HE destinations (England)
Census Data (Wales)
KS5 (Wales)

Census Data (England)

No. pupils

|| No. pupils on roll (all ages)

Total number of pupils on roll
No. girls on roll
No. boys on roll
Percentage of girls on roll
Percentage of boys on roll
No. SEN pupils with an EHC plan
Percentage of SEN pupils with an EHC plan
No. eligible pupils with SEN support
Percentage of eligible pupils with SEN support
No. pupils where English not first language
No. pupils with English first language
No. pupils where first language is unclassified
Percentage pupils where English not first language
Percentage pupils with English first language
Percentage pupils where first language is unclassified
No. pupils eligible for free school meals
No. pupils eligible for FSM at any time during the past 6 years

Question 3

Selecting the fields you want to see

Accepted Answer

Using the fields selection dropdown

As mentioned in Adding and using filters, you can think of each "Analysis" page (e.g. Performance, Interactions etc) as being a bit like a giant spreadsheet filled with data. And there's a lot of data - far too much to display all at the same time.

| 💡 Analysis pages aren't actually spreadsheets but it's a good way to visualise what you are doing.

Once you have added filters to reduce the total number of results, you must then decide which fields of data you would like to see for those results.

| 💡Using the spreadsheet analogy you are choosing which columns you want to see

You may select up to a maximum of 20 fields.

Watch a quick video to get started

${frame}Adding filters

Ordering/sorting fields

Wherever possible you can order the columns by clicking or pressing the header for that column. The current sort direction of that column will be shown by the arrows in the header.

These can be in 3 states:

Unsorted
Sorted in ascending order
Sorted in descending order

|| Due to the nature of the data this has a few caveats… || For instance when ordering Applications Data the data shown has both a sum of the applications for all apply centres and also the application data per apply centre nested below. In this scenario, ordering will order based on the combined application figures and not th

Question 4

Adding and editing interactions

Accepted Answer

How to add an interaction

|| An interaction is the term we use for recording a point of interaction with a institution/campus. For example a video call, an HE event, a visit to a campus etc.

You can add an interaction (or contact or note) from anywhere using the dropdown which appears in the main navigation bar. Or when you have a school details window open the dropdown appears in the header of the open window.

Dropdown button in the top navigation bar Dropdown button in the school details window

Fill in the form and click the Save & Close button.

Fill in the new interaction form

Should I assign a single or multiple institutions?

|| The biggest difference between assigning a single institution and assigning multiple institutions is that you can only assign a specific campus when an interaction is associated with just a single institution.

We let you decide on the association your specific team prefers to structure and report on interactions.

For example if you attend an HE Fair and speak to students from 50 schools, you could choose to structure that in one of two ways:

Record 50 interactions - one for each of the institutions. In your reporting this will show that on a single day yo

Question 5

Identify schools by apply centre

Accepted Answer

Identify schools by apply centre

Apply centres do not always relate to a particular school. For instance: an apply centre can be virtual; a single school may have 2 apply centres associated; or multiple schools may use the same apply centre.

Due to the fact there is not a direct relationship with schools, we cannot associate entities and campuses with apply centres directly. We know this is frustrating and will be releasing an extra field next to an apply centre, showing the title provided by UCAS.

In the meantime you maybe use the list below to identify a school by name by looking up its apply centre.

``` 10001 - Ysgol Syr Thomas Jones 10002 - Ysgol David Hughes 10003 - Holyhead High School 10006 - Ysgol Gyfun Llangefni 10008 - Redborne Upper School and Community College 10011 - Bedford Modern School 10012 - Bedford School 10018 - Stratton Upper School, Bedfordshire 10022 - Queensbury Academy 10023 - Stoke College, Sudbury 10024 - Cedars Upper School, Bedfordshire 10026 - St Marylebone Church of England School 10027 - Luton VI Form College 10029 - Abingdon School 10030 - John Mason School, Abingdon 10031 - Our Lady's Abingdon Trustees Ltd 10032 - Radley College 10033 - St Helen & St Katharine 10034 - Heathfield School, Berkshire 10036 - The Marist School 10038 - St Georges School, Ascot 10039 - St Marys School, Ascot 10040 - Garth Hill College 10041 - Ranelagh School 10042 - Bracknell and Wokingham College 10043 - Ysgol Gyfun Bro Myrddin 10044 - Edgbarrow School 10045

Question 6

Setting up webhooks

Accepted Answer

Outgoing webhooks reference

This useful feature makes it really easy to connect to your own applications. Once set up they allow your systems to be informed instantly, whenever a new resource (contact, interaction or note) is saved or deleted.

Whenever you save a form for contacts, interactions or notes, Datafiltr will send an HTTP request with a JSON payload to any secure endpoint you register.

You will need:

A publicly available, secure (HTTPS) endpoint that you will need to configure to handle the payloads specified below.

Available events

As you will see in the documentation below we pass a parameter in the payload with the event action (i.e. created, updated or deleted). This way a single endpoint can be used per resource. The options are:

Contact created, updated or deleted
Interaction created, updated or deleted
Note created, updated or deleted

Setting up your webhooks

|| ⚠️ Your user account will need the correct permissions to configure webhooks.

Visit the Developers section using the profile dropdown in the top right of the screen and go to the Webhooks section.
Click the + Add a webhook button.
Use the information about your public endpoint to fill in the details in the form and save.
Your new webhook will appear in the table.

Checking webhook signatures

Only HTTPS endpoint are allowed, but in addition we recommend using a "secret" in your configuration. This is a secret that will be shared

Frequently Read Articles

Browse All Categories