1. ReferAll Help Centre
  2. Analyse your Service Data

Exporting data from ReferAll

ReferAll's Reporting Solution includes the export of data. For complex data analysis, there maybe be times when Exporting your data is appropriate. Understand ReferAll's Export Data features below:

  1. Click the Export / Import icon (found on the dashboard, top right)
  2. The default setting is Export Data
  3. The first section is all about Templates:

    Once you've selected the desired Export filters, scroll up to the Export Template section to save as a Template. If you need to export the same data on a regular basis this is an awesome time-saving feature!
  4. The next section is all about Filters for exporting your data:
  5. Apply the required filters to Scheme / Export Sharing / Referral Status / Date Range.
  6. The final section is all about the data you wish to export:
  7. Within Select Export Data there are 6 key areas:

The Referral ID is the unique identifier that links all records.

Please note: when fields from columns Export Referral Data and Export Referral and Biometric Data are selected, only referrals with biometrics stats saved in the referral record will be exported.

  • 7.1 Export Referral Data: contains data relating to Participants and the Referral Record.
  • 7.2 Export Referral and Questionnaire data: contains responses to questionnaires linked by ReferralID.
  • 7.3 Export Referral and Activity data: contains information relating to bookings and attendance data of activities linked by ReferralID.
  • 7.4 Export Referral, Activity and Questionnaire Data: a combination of the above – this export can be vast and complex. Consider running options 7.2 and 7.3 separately however 7.4 is available for customers.
  • 7.5 Export Referral and Biometric data: individual biometric entries recorded such as a blood pressure at every session.
  • 7.6 Export Referral and History data: contains the history entries recorded by ReferralID. This is a huge area and covers things like James recorded a history note last Wednesday and that contained “James spoke to customer and they want to rebook". The export will contain a vast amount of data.

What you need to know about exporting postcode and deprivation data

Why are some referrals missing "postcode" data?

This usually indicates that for that Referral the postcode does not exist in National Statistics. 

For ElectoralWard, Districts, QoD, DoD, IMD, and LSOA this means we do not have any data for those postcodes.

If we have no data, it will export the string "No data, or invalid postcode." instead.

Most commonly these are postcodes which do not exist, or no longer exist as old postcodes can be terminated. More seldom, new postcodes may be assigned or created and it could take a while before data is available for them.

For certain regions we may only have the wards, districts, LSOA data but no quintile, decile or IMD.

Why are some referrals "in scheme coverage" but do not have further postcode data?

The "In Scheme Area" in Exports and the similar usage of what is considered to be in scheme coverage/area is based on a simple string match. If your schemes defines BN11 1 to be in coverage then any postcodes which start with that pattern are considered to be "in coverage". The fact that BN11 1AG does not exist is not taken into account, whereas for export the other postcode it does matter (we have no way of knowing whether our fictional BN11 1AG would have the same deprivation data etc. as BN11 1AF (which does exists), or BN11 1AE (which used to exist until September 2009).

Why does it matter?

Most health-related programmes report on referral outcomes for people in areas of deprivation. The updates to these ReferAll solutions, we hope will enable Scheme Managers to produce clearer reports on the data collected - at the touch of a button

8. When you have made your selection and are ready, click Export Data

9. It may take a few minutes for the export to be generated. Once the data is ready, you will notice the number update in the Messages icon (top of dashboard).

10. When this happens click on the Messages icon. Here you will see various options to manage your messages and data downloads.

11. Click on Download. The data will be exported into excel for further analysis.

N.B. Data exports are up to midnight the day before to maintain smooth performance.

Any changes made on the day will NOT be reflected in the data you are exporting.