This information is reported on a weekly basis. The web portal outputs into an Excel file which is upload to a bespoke Access tool.
Once the data had been downloaded, we then run a series of checks to ensure there was no duplication and produced a series of different summary reports and dashboards in Excel. In order to store the data appropriately and to generate one series of reports, the data is imported into a database to keep track of all changes to the various gyms as well as the data associated. The data is only ever identified by membership number in order to ensure compliance with data protection laws.
Data is then used to analyse and generate a number different reports. Xlteq manage the entire process including:
- Sending reports to multiple recipients
- Automating list generation
- Full reporting suite
- Managing web tool hosting
The Output
Interactive reports in Excel are produced from the database to show the results of the survey by region and to allow the various metrics to be examined in more detail. In addition, simple summary reports were produced on a weekly basis in excel to illustrate the numbers of members leaving and the team members recording the most surveys. The metrics displayed in the database reports allowed the user to analyse the reasons given for leaving as well as the numbers showing the “through-put” for each gym.
This reporting has enable PureGym to identify the patterns in behaviour that lead to continuing or discontinuing period of membership.
Accurate analysis has shaped the ongoing growth plans at a national and local level. Reports are generated in Excel and PowerPoint format depending on the client requirement.
Xlteq, as part of their Managed Service Desk service, provide the regular reporting and manage the site on behalf of Puregym.