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
Uptivo
Uptivo
Uptivo
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
Lack of exercise is a major cause of death from COVID-19, according to new research, with only advanced age and organ transplant leading to greater risk
HCM magazine
Over time, town planning has led to the creation of obesogenic environments, but Hamilton in New Zealand is taking a fresh approach to mobilising its population, by turning the city into a playground, as Kath Hudson reports
HCM magazine
As we adapt to a new way of living, software developers have been supporting the fitness sector with new systems and strategies. We asked operators and developers to share successes
HCM Magazine
Supplier showcase
Switzerland’s no frills chain, NonStop Gym, has appointed Funxtion to create its member training app, as CEO Ernst De Neef explains
HCM Magazine
Hospitality
Fitness, wellness and recovery are driving new investments in the hotel and resorts market, with Kerzner the latest to enter this space, as Megan Whitby reports
HCM Magazine
Policy
The health and fitness industry felt as though it wasn’t invited to its own party when news of the government’s Fit Miles programme broke. But what does it actually mean and is it good or bad news for the sector? Kath Hudson investigates
HCM Magazine
Write to reply
"Prescribing exercise will always be preferential to prescribing painkillers, given the risks associated with their long-term use"
HCM Magazine
Sponsored
Craig Cocking was appointed Life Fitness UK’s country manager in December, following over 13 years with the business. He reflects on the impact of the past 12 months and shares his views on the future of the industry
HCM Magazine
Sponsored
More than 30,000 Hussle users have been turned into direct members in the last 18 months. Find out how Hussle can help your business bounce back
HCM Magazine
Sponsored
We talk to Dave Wright, CEO of Myzone, about the world’s first interchangeable heart rate monitor that provides real-time feedback – and the impact of COVID-19
HCM Magazine
Latest News
Fully vaccinated people in the US no longer need to wear a face mask whether ...
Latest News
Anytime Fitness UK has revealed that April was its busiest month for new memberships since ...
Latest News
HCM understands that Fitness International, which operates more than 700 health clubs under the LA ...
Latest News
A court has given Virgin Active the green light to erase the rent arrears it ...
Latest News
The Swimming Teachers' Association (STA) has partnered with a psychologist to provide new mindfulness and ...
Latest News
A report commissioned by Parkrun has estimated that allowing mass-participation outdoor events carries an "exceptionally ...
Latest News
Jan Spaticchia, founder and chair of énergie Fitness has died aged 51 following a short ...
Latest News
A new pioneering approach looks to help cancer patients prepare for and respond to treatment ...
Opinion
promotion
The UK’s first dedicated leisure development framework has completed its first four-year term with £144m committed investment in public leisure projects.
Opinion: UK’s first leisure framework celebrates £144m investment in public leisure
Featured supplier news
Featured supplier news: Integrated workout solutions will underpin gyms' recovery, says Les Mills’ Martin Franklin
The UK has spent most of the year in lockdown but finally, clubs are beginning to see their fitness communities open back up, with indoor group exercise not far behind.
Featured supplier news
Featured supplier news: Precor supports Aneurin Leisure Trust in three-site refurbishment
Welsh leisure trust, Aneurin Leisure (ALT), has announced it’s forging ahead with a £600,000 (US$821,000, €696,000) gym refurbishment in all three of its leisure centres.
Company profiles
Company profile: Myzone
Myzone is an innovative heart rate monitor and community engagement tool to track physical activity ...
Company profiles
Company profile: EMD UK
EMD UK is the national governing body for group exercise. Funded by Sport England, EMD ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Skincare
Comfort Zone - Davines S.p.A: Skincare
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Architects/designers
Zynk Design Consultants: Architects/designers
Salt therapy products
Himalayan Source: Salt therapy products
Spa software
SpaBooker: Spa software
Trade associations
International SPA Association - iSPA: Trade associations
Hydrotherapy / spa fragrances
Kemitron GmbH: Hydrotherapy / spa fragrances
Lockers/interior design
Safe Space Lockers Ltd: Lockers/interior design
Exercise equipment
Power Plate: Exercise equipment
Management software
fibodo Limited: Management software
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Diary dates
07-09 Jun 2021
Virtual summit,
Diary dates
12 Jun 2021
Worldwide, Various,
Diary dates
13-14 Jun 2021
Online,
Diary dates
01-04 Jul 2021
Expo Centre & Riviera di Rimini, Italy
Diary dates
18-19 Sep 2021
Locations worldwide,
Diary dates
21-24 Sep 2021
Messe Stuttgart, Germany
Diary dates
28-29 Sep 2021
ExCeL London, London, United Kingdom
Diary dates
04-07 Nov 2021
Exhibition Centre , Cologne, Germany
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
Fully vaccinated people in the US no longer need to wear a face mask whether ...
Latest News
Anytime Fitness UK has revealed that April was its busiest month for new memberships since ...
Latest News
HCM understands that Fitness International, which operates more than 700 health clubs under the LA ...
Latest News
A court has given Virgin Active the green light to erase the rent arrears it ...
Latest News
The Swimming Teachers' Association (STA) has partnered with a psychologist to provide new mindfulness and ...
Latest News
A report commissioned by Parkrun has estimated that allowing mass-participation outdoor events carries an "exceptionally ...
Latest News
Jan Spaticchia, founder and chair of énergie Fitness has died aged 51 following a short ...
Latest News
A new pioneering approach looks to help cancer patients prepare for and respond to treatment ...
Latest News
Peloton is recalling all of its Tread and Tread+ machines in the US, after striking ...
Latest News
Health club operator Bannatyne is repositioning itself as a wellness provider, as it looks to ...
Latest News
Health clubs and leisure centres in Northern Ireland reopened their doors on Friday 30 April, ...
Opinion
promotion
The UK’s first dedicated leisure development framework has completed its first four-year term with £144m committed investment in public leisure projects.
Opinion: UK’s first leisure framework celebrates £144m investment in public leisure
Featured supplier news
Featured supplier news: Integrated workout solutions will underpin gyms' recovery, says Les Mills’ Martin Franklin
The UK has spent most of the year in lockdown but finally, clubs are beginning to see their fitness communities open back up, with indoor group exercise not far behind.
Featured supplier news
Featured supplier news: Precor supports Aneurin Leisure Trust in three-site refurbishment
Welsh leisure trust, Aneurin Leisure (ALT), has announced it’s forging ahead with a £600,000 (US$821,000, €696,000) gym refurbishment in all three of its leisure centres.
Company profiles
Company profile: Myzone
Myzone is an innovative heart rate monitor and community engagement tool to track physical activity ...
Company profiles
Company profile: EMD UK
EMD UK is the national governing body for group exercise. Funded by Sport England, EMD ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Skincare
Comfort Zone - Davines S.p.A: Skincare
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Architects/designers
Zynk Design Consultants: Architects/designers
Salt therapy products
Himalayan Source: Salt therapy products
Spa software
SpaBooker: Spa software
Trade associations
International SPA Association - iSPA: Trade associations
Hydrotherapy / spa fragrances
Kemitron GmbH: Hydrotherapy / spa fragrances
Lockers/interior design
Safe Space Lockers Ltd: Lockers/interior design
Exercise equipment
Power Plate: Exercise equipment
Management software
fibodo Limited: Management software
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Diary dates
07-09 Jun 2021
Virtual summit,
Diary dates
12 Jun 2021
Worldwide, Various,
Diary dates
13-14 Jun 2021
Online,
Diary dates
01-04 Jul 2021
Expo Centre & Riviera di Rimini, Italy
Diary dates
18-19 Sep 2021
Locations worldwide,
Diary dates
21-24 Sep 2021
Messe Stuttgart, Germany
Diary dates
28-29 Sep 2021
ExCeL London, London, United Kingdom
Diary dates
04-07 Nov 2021
Exhibition Centre , Cologne, Germany
Diary dates
01-07 Dec 2022
tbc, Dunedin, New Zealand
Diary dates
Search news, features & products:
Find a supplier:
Uptivo
Uptivo