GET HCM
magazine
Sign up for the FREE digital edition of HCM magazine and also get the HCM ezine and breaking news email alerts.
Not right now, thanksclose this window
Ledsnaps Ltd
Ledsnaps Ltd
Ledsnaps Ltd
Follow Health Club Management on Twitter Like Health Club Management on Facebook Join the discussion with Health Club Management on LinkedIn Follow Health Club Management on Instagram
UNITING THE WORLD OF FITNESS
Health Club Management

Health Club Management

features

Promotional feature: Gladstone - Intelligent reporting

There is more to data than just gathering information. An operator also needs to be able to access and analyse its findings

Published in Health Club Management 2015 issue 6
Shetland Recreational Trust is one of the first 
to use the data consultancy service
Shetland Recreational Trust is one of the first to use the data consultancy service

Often described as the oil of the 21st century, data is a hugely valuable asset in any industry, with the power to deliver greater business insights, more targeted product offerings, better customer service and retention rates, and ultimately increased profitability. Just like oil, however, data needs to be skilfully extracted and refined for this power to be released. Within the leisure sector, products such as Gladstone’s eyeQ – a powerful query builder and business intelligence tool launched last year – is already helping operators to get the most out of their data, both in terms of accessing and analysing customer information and monitoring and improving financial processes.

After just two days of training on eyeQ, leisure operators can build detailed queries and run highly customised reports using the standard query builder, while the Custom SQL feature enables the creation of even more complicated queries and reports. And for those challenges where operators need a helping hand, Gladstone can now provide that too – in the form of a bespoke data consultancy service offered exclusively to eyeQ customers by its in-house team of business intelligence consultants.

“eyeQ greatly enhances the ability of operators to write their own queries and do their own ad hoc reporting,” says Guy Bickerton, head of Gladstone’s data consultancy team. “However, there are always going to be instances where the issue is so complex that expert input is needed.

“As well as making the Custom SQL feature work for you, we can access data beyond the standard eyeQ reporting data layer (RDL), further unlocking the power of your data. In short, if it’s stored in your system, we will be able to extract it, and in the format you require.

“Whether you want help to create KPI reports or need us to create an interface between Plus2 and your finance system, our consultants will guide you through the process, and support you afterwards. Ultimately, our goal is to deliver a solution that not only makes life easier for the person using it but also adds real value to your business.”

What can data consultancy do for you?

• KPI reports: sales and usage, membership, attrition, booking and resource utilisation, and member demographics

• Marketing and pricing reports

• Finance extracts for interfaces between your member management software and systems such as SAGE, TechnologyOne and OpenAccounts

• Data cleansing

• Point of sale reconciliation

Norma Johnson,

Clerical Assistant,

Shetland Recreational Trust

In September 2014, Shetland Recreational Trust decided to invest in eyeQ, Gladstone’s new query builder and business intelligence tool. The trust has worked with Gladstone since 2001 and, in addition to the company’s signature Plus2 member management software, is currently using the Connect online booking system across its eight sport and leisure sites, as well as a Kiosk self-service unit at its largest site. eyeQ appealed to us as it offered us an opportunity to improve our reporting capabilities as well as our invoicing procedures.

We had been aware for some time that our invoicing procedures required updating. Plus2 did not link in to our financial software, so we had to create and print our sales invoices from Plus2, and then manually re-enter the details into our accounting system. With 100 invoices to process a month, each with around 10-15 invoice lines, we found this to be very time consuming, taking up to a full day of staff time and inevitably leading to some errors.

We believed eyeQ could help us solve this problem, but while it is possible to create simple reports after the two days’ basic training offered with the product, we knew that for something this complex we required extra support. Gladstone offers all eyeQ customers access to a data consultancy service – provided by a member of its in-house data services team – to assist with this kind of issue.

The service, which was charged per day, involved a consultant visiting us in Shetland for three days in December 2014, to better understand our processes and work with us to find a solution. By looking closely at the mapping of sales products within Plus2 and consulting with the suppliers of our finance package, he created an extract file using the custom SQL feature within eyeQ. This was able to pull the relevant data out of Plus2 and organise it for compatibility, before exporting it into Microsoft Excel ready for automatic upload into the accounting system.

After leaving Shetland, Gladstone continued to work with the supplier of our finance package to develop the extract file, and after some final testing we successfully completed our first upload in February of this year.

In terms of benefits, the sales invoice interface has made a great difference to our workload, with an immediate staff saving of one full-time day per month – time that can now be spent on more valuable tasks – while the automation of the process ensures a much greater level of accuracy.

In addition to these long-term benefits, the project has given us the confidence to work with Gladstone on other, higher-volume interfaces using eyeQ, which we anticipate will result in an even higher financial return.

“It has made a great difference to our workload, with a saving of one full day a month, while ensuring a much greater level of accuracy”

Sign up here to get HCM's weekly ezine and every issue of HCM magazine free on digital.
The new service can help you get even more out of your customer data
The new service can help you get even more out of your customer data
Data consultancy has helped Shetland Recreational Trust dramatically improve its invoicing procedures
Data consultancy has helped Shetland Recreational Trust dramatically improve its invoicing procedures
https://www.leisureopportunities.co.uk/images/723170_964846.jpg
There’s more to data than just gathering information – an operator also needs to be able to access and analyse its findings
Gladstone Norma Johnson, clerical assistant, Shetland Recreational Trust,Gladstone
HCM magazine
The pandemic has disrupted everything and as businesses across the leisure industry reshape themselves to survive and thrive, new competition is emerging that will change the sector
HCM magazine
HCM People

Preston Lewis

Co-founder, Black Box VR
Game designers have figured out how to keep people unhealthily addicted to games. If only you could be the hero in a game that levelled up your life
HCM magazine
Fuel the debate about issues and opportunities across the industry. We’d love to hear from you – [email protected]
HCM Magazine
Sponsored
Jo Farrier, head of commercial and resources at Active Northumberland, talks about how a strategic partnership with Technogym is changing public perceptions of council leisure facilities
HCM Magazine
Interview
Urban Health Club is a key element of the collaborative, future-facing, urban regeneration development that is Urban Harbor. Its founder and CEO tells Kate Cracknell about his desire to create something new, extraordinary and beautiful, while at the same time improving people’s health
HCM Magazine
Training
Six months on from the launch of its Kickstart programme, The Gym Group is hiring the majority of trainees, as Liz Terry reports
HCM Magazine
Sponsored
With gyms reopening as the fitness industry recovers from the impact of lockdowns, members are seeking social interaction and engaging training experiences in a small group setting
HCM Magazine
Sponsored
Empowered Brands has strengthened its leadership team with the appointment of a new chair and CEO following the untimely death of founder, Jan Spaticchia
HCM Magazine
Sponsored
Every gym design project should be designed from the floor up, says Physical Company’s James Anderson. He tells HCM why
HCM Magazine
HCM People
We’re seeing a much greater focus on the need to integrate healthy living into daily life and reconnect with nature and each other
HCM Magazine
Latest News
Industry body ukactive has joined the chorus of organisations across a number of sectors calling ...
Latest News
German fitness operator BestFit Group has acquired regional gym chain EuroFit for an undisclosed sum. ...
Latest News
The US fitness industry lost around 58 per cent of its revenues during 2020, due ...
Latest News
Speaking exclusive to HCM, Ralph Scholz and Nathalie Smeeman have confirmed that B2B trade show ...
Latest News
The Pingdemic of people receiving notifications on their phones, telling them to self-isolate because of ...
Latest News
Xponential Fitness has completed its initial public offering (IPO), becoming the second major franchised operator ...
Latest News
The Gym Group has extended its partnership with digital fitness platform Fiit, becoming the first ...
Latest News
The world's largest fitness trade fair, FIBO, has been rescheduled again and will now take ...
Featured supplier news
Featured supplier news: A new world for memberships
During lockdown clients have had more time to self-reflect than ever before. As a result, many are prioritising mental health and incorporating activity into their day to improve overall wellbeing.
Featured supplier news
Featured supplier news: How are hundreds of gym operators suddenly saving a lot of money for doing a lot less work?
Let’s talk about Orbit4 – the secret behind successful gyms.
Featured operator news
Featured operator news: Everyone Active bolsters Everyone on Demand and enters second year with five new partnerships
Everyone Active has signed a number of new deals which will see the operator strengthen its digital product offering, Everyone on Demand.
Featured operator news
Featured operator news: Everyone Active generates £342m in social value
Award-winning leisure operator Everyone Active generated £342million in social value at its sites across the country in 2019/20.
Company profiles
Company profile: Quoox
With more than 200 integrated features, Quoox is confident there is a solution for every ...
Company profiles
Company profile: Precor
Precor has been a pioneer in delivering fitness experiences for commercial customers for more than ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Skincare
Sothys: Skincare
Independent service & maintenance
Servicesport UK Limited: Independent service & maintenance
Spa software
SpaBooker: Spa software
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Salt therapy products
Saltability: Salt therapy products
Architects/designers
Zynk Design Consultants: Architects/designers
Wearable technology solutions
MyZone: Wearable technology solutions
Exercise equipment
Matrix Fitness: Exercise equipment
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Management software
fibodo Limited: Management software
Property & Tenders
Newport, Shropshire
Lilleshall Sports Academy
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Diary dates
18-19 Sep 2021
Locations worldwide,
Diary dates
21-24 Sep 2021
Messe Stuttgart, Germany
Diary dates
13-14 Oct 2021
Online,
Diary dates
01-03 Feb 2022
Coventry Building Society Arena, Coventry, United Kingdom
Diary dates
07-10 Apr 2022
Exhibition Centre , Cologne, Germany
Diary dates
15-16 Jun 2022
ExCeL London, London, United Kingdom
Diary dates
01-07 Dec 2022
tbc, Dunedin, New Zealand
Diary dates

features

Promotional feature: Gladstone - Intelligent reporting

There is more to data than just gathering information. An operator also needs to be able to access and analyse its findings

Published in Health Club Management 2015 issue 6
Shetland Recreational Trust is one of the first 
to use the data consultancy service
Shetland Recreational Trust is one of the first to use the data consultancy service

Often described as the oil of the 21st century, data is a hugely valuable asset in any industry, with the power to deliver greater business insights, more targeted product offerings, better customer service and retention rates, and ultimately increased profitability. Just like oil, however, data needs to be skilfully extracted and refined for this power to be released. Within the leisure sector, products such as Gladstone’s eyeQ – a powerful query builder and business intelligence tool launched last year – is already helping operators to get the most out of their data, both in terms of accessing and analysing customer information and monitoring and improving financial processes.

After just two days of training on eyeQ, leisure operators can build detailed queries and run highly customised reports using the standard query builder, while the Custom SQL feature enables the creation of even more complicated queries and reports. And for those challenges where operators need a helping hand, Gladstone can now provide that too – in the form of a bespoke data consultancy service offered exclusively to eyeQ customers by its in-house team of business intelligence consultants.

“eyeQ greatly enhances the ability of operators to write their own queries and do their own ad hoc reporting,” says Guy Bickerton, head of Gladstone’s data consultancy team. “However, there are always going to be instances where the issue is so complex that expert input is needed.

“As well as making the Custom SQL feature work for you, we can access data beyond the standard eyeQ reporting data layer (RDL), further unlocking the power of your data. In short, if it’s stored in your system, we will be able to extract it, and in the format you require.

“Whether you want help to create KPI reports or need us to create an interface between Plus2 and your finance system, our consultants will guide you through the process, and support you afterwards. Ultimately, our goal is to deliver a solution that not only makes life easier for the person using it but also adds real value to your business.”

What can data consultancy do for you?

• KPI reports: sales and usage, membership, attrition, booking and resource utilisation, and member demographics

• Marketing and pricing reports

• Finance extracts for interfaces between your member management software and systems such as SAGE, TechnologyOne and OpenAccounts

• Data cleansing

• Point of sale reconciliation

Norma Johnson,

Clerical Assistant,

Shetland Recreational Trust

In September 2014, Shetland Recreational Trust decided to invest in eyeQ, Gladstone’s new query builder and business intelligence tool. The trust has worked with Gladstone since 2001 and, in addition to the company’s signature Plus2 member management software, is currently using the Connect online booking system across its eight sport and leisure sites, as well as a Kiosk self-service unit at its largest site. eyeQ appealed to us as it offered us an opportunity to improve our reporting capabilities as well as our invoicing procedures.

We had been aware for some time that our invoicing procedures required updating. Plus2 did not link in to our financial software, so we had to create and print our sales invoices from Plus2, and then manually re-enter the details into our accounting system. With 100 invoices to process a month, each with around 10-15 invoice lines, we found this to be very time consuming, taking up to a full day of staff time and inevitably leading to some errors.

We believed eyeQ could help us solve this problem, but while it is possible to create simple reports after the two days’ basic training offered with the product, we knew that for something this complex we required extra support. Gladstone offers all eyeQ customers access to a data consultancy service – provided by a member of its in-house data services team – to assist with this kind of issue.

The service, which was charged per day, involved a consultant visiting us in Shetland for three days in December 2014, to better understand our processes and work with us to find a solution. By looking closely at the mapping of sales products within Plus2 and consulting with the suppliers of our finance package, he created an extract file using the custom SQL feature within eyeQ. This was able to pull the relevant data out of Plus2 and organise it for compatibility, before exporting it into Microsoft Excel ready for automatic upload into the accounting system.

After leaving Shetland, Gladstone continued to work with the supplier of our finance package to develop the extract file, and after some final testing we successfully completed our first upload in February of this year.

In terms of benefits, the sales invoice interface has made a great difference to our workload, with an immediate staff saving of one full-time day per month – time that can now be spent on more valuable tasks – while the automation of the process ensures a much greater level of accuracy.

In addition to these long-term benefits, the project has given us the confidence to work with Gladstone on other, higher-volume interfaces using eyeQ, which we anticipate will result in an even higher financial return.

“It has made a great difference to our workload, with a saving of one full day a month, while ensuring a much greater level of accuracy”

Sign up here to get HCM's weekly ezine and every issue of HCM magazine free on digital.
The new service can help you get even more out of your customer data
The new service can help you get even more out of your customer data
Data consultancy has helped Shetland Recreational Trust dramatically improve its invoicing procedures
Data consultancy has helped Shetland Recreational Trust dramatically improve its invoicing procedures
https://www.leisureopportunities.co.uk/images/723170_964846.jpg
There’s more to data than just gathering information – an operator also needs to be able to access and analyse its findings
Gladstone Norma Johnson, clerical assistant, Shetland Recreational Trust,Gladstone
Latest News
Industry body ukactive has joined the chorus of organisations across a number of sectors calling ...
Latest News
German fitness operator BestFit Group has acquired regional gym chain EuroFit for an undisclosed sum. ...
Latest News
The US fitness industry lost around 58 per cent of its revenues during 2020, due ...
Latest News
Speaking exclusive to HCM, Ralph Scholz and Nathalie Smeeman have confirmed that B2B trade show ...
Latest News
The Pingdemic of people receiving notifications on their phones, telling them to self-isolate because of ...
Latest News
Xponential Fitness has completed its initial public offering (IPO), becoming the second major franchised operator ...
Latest News
The Gym Group has extended its partnership with digital fitness platform Fiit, becoming the first ...
Latest News
The world's largest fitness trade fair, FIBO, has been rescheduled again and will now take ...
Latest News
Rainer Schaller, founder of budget gym megabrand McFIT, says that the global fitness industry will ...
Latest News
The most high-risk and controversial Olympics of modern times begin today (23 July) in Tokyo, ...
Latest News
Further research into the levels of positive COVID-19 cases among those to have visited fitness ...
Featured supplier news
Featured supplier news: A new world for memberships
During lockdown clients have had more time to self-reflect than ever before. As a result, many are prioritising mental health and incorporating activity into their day to improve overall wellbeing.
Featured supplier news
Featured supplier news: How are hundreds of gym operators suddenly saving a lot of money for doing a lot less work?
Let’s talk about Orbit4 – the secret behind successful gyms.
Featured operator news
Featured operator news: Everyone Active bolsters Everyone on Demand and enters second year with five new partnerships
Everyone Active has signed a number of new deals which will see the operator strengthen its digital product offering, Everyone on Demand.
Featured operator news
Featured operator news: Everyone Active generates £342m in social value
Award-winning leisure operator Everyone Active generated £342million in social value at its sites across the country in 2019/20.
Company profiles
Company profile: Quoox
With more than 200 integrated features, Quoox is confident there is a solution for every ...
Company profiles
Company profile: Precor
Precor has been a pioneer in delivering fitness experiences for commercial customers for more than ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Skincare
Sothys: Skincare
Independent service & maintenance
Servicesport UK Limited: Independent service & maintenance
Spa software
SpaBooker: Spa software
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Salt therapy products
Saltability: Salt therapy products
Architects/designers
Zynk Design Consultants: Architects/designers
Wearable technology solutions
MyZone: Wearable technology solutions
Exercise equipment
Matrix Fitness: Exercise equipment
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Management software
fibodo Limited: Management software
Property & Tenders
Newport, Shropshire
Lilleshall Sports Academy
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Diary dates
18-19 Sep 2021
Locations worldwide,
Diary dates
21-24 Sep 2021
Messe Stuttgart, Germany
Diary dates
13-14 Oct 2021
Online,
Diary dates
01-03 Feb 2022
Coventry Building Society Arena, Coventry, United Kingdom
Diary dates
07-10 Apr 2022
Exhibition Centre , Cologne, Germany
Diary dates
15-16 Jun 2022
ExCeL London, London, United Kingdom
Diary dates
01-07 Dec 2022
tbc, Dunedin, New Zealand
Diary dates
Search news, features & products:
Find a supplier:
Ledsnaps Ltd
Ledsnaps Ltd