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
JP Lennard
JP Lennard
JP Lennard
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
Researchers have shed new light on the effects of HIIT on skeletal muscle, according to a study published on the eLife platform
HCM magazine
Despite industry challenges, there’s a fresh air of positivity
HCM magazine
It’s a travesty that teenage girls are being pushed out of sport on such a scale
HCM Magazine
Write to reply
The top reason respondents say they exercise is to feel better mentally
HCM Magazine
Sponsored
The body composition specialists are showing no signs of slowing down, with new leadership and launches for 2022
HCM Magazine
Editor's letter
The sharp increase in energy prices has left some operators reeling, but there’s reason to be optimistic if we can learn from other sectors, while moving to a low carbon future
HCM Magazine
Event showcase
As Elevate returns to the market, we talk to director Lucy Findlay about how the event has come together
HCM Magazine
Postbag
As HCM passed its 300th edition milestone, readers shared their thoughts and feelings on HCM’s contribution to the industry in a very special postbag
HCM Magazine
Sponsored
Yate Leisure is one of the largest sites in Circadian Trust’s portfolio, with around 4,000 members. Ben Beasley, director of commercial development, explains why they were an early adopter of Technogym Biocircuit, and how the offer has evolved
HCM Magazine
Everyone's talking about
In the wake of the pandemic, is the time ripe to change the language around the role of exercise professionals, and gain greater trust from the healthcare sector?
HCM Magazine
Latest News
Music service provider Rehegoo (pronounced Reh-air-go) has launched a streaming service for health clubs, gyms, ...
Latest News
F45 has launched a corporate partnership programme which will enable businesses to open an F45 ...
Latest News
A two-year research project will look to find ways to transform the UK's physical activity ...
Latest News
The best in the business from across the physical activity sector were honoured last night ...
Latest News
At UK Active’s Active Uprising event yesterday (30 June) in Birmingham, Hattie Jones, the head ...
Latest News
HCM understands researchers are moving closer to creating a pill to mimic some of the ...
Latest News
Establishing new data and insight services and strengthening relationships with both government and the NHS ...
Latest News
More than one in five (27 per cent) Americans belonged to a health club or ...
Featured supplier news
Featured supplier news: The University of Bath enhances sports facilities with £150,000 Matrix Fitness equipment upgrade
Leading UK university the University of Bath is steeped in a history of sporting excellence, with Team Bath committed to offering its students a wealth of sporting opportunities and access to world-class facilities.
Featured supplier news
Featured supplier news: How wearables-driven gamification will boost your business
It’s a known fact that gamification is an effective method to make everyday activities and work more fun.
Featured operator news
Featured operator news: Everyone Active to launch new exercise classes to reduce gender gap
As part of their work to break down the barriers that deter women and girls from participating in sport and physical activity, Everyone Active has teamed up with EMD UK to launch new exercise classes linked to the This Girl Can campaign.
Featured operator news
Featured operator news: New £42m Moorways Sports Village to open on 21 May
Everyone Active will open Moorways Sports Village to the public on Saturday 21 May with a grand opening weekend – in time for the half term holidays.
Video Gallery
Mindbody, Inc
Sport Alliance GmbH
Total Vibration Solutions / Floors 4 Gyms / TVS Sports Surfaces
Company profiles
Company profile: Xn Leisure Systems Ltd
Xn Leisure is a provider of cutting-edge health and fitness software, offering an exceptional service ...
Company profiles
Company profile: IONTO Health & Beauty GmbH
IONTO-COMED offers a wide range of treatment beds offering maximum flexibility and the symbiosis of ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
On demand
Fitness On Demand: On demand
Lockers/interior design
Safe Space Lockers Ltd: Lockers/interior design
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Salt therapy products
Himalayan Source: Salt therapy products
Wearable technology solutions
MyZone: Wearable technology solutions
Fitness equipment
A Panatta Sport Srl: Fitness equipment
Spa software
SpaBooker: Spa software
Management software
Premier Software Solutions: Management software
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Skincare
Comfort Zone - Davines S.p.A: Skincare
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Runcorn
Halton Borough Council
Property & Tenders
Diary dates
12-13 Sep 2022
Wyndham Lake Buena Vista Disney Springs® Resort, Lake Buena Vista, United States
Diary dates
21-21 Sep 2022
Various, London, United Kingdom
Diary dates
25-28 Oct 2022
Messe Stuttgart, Germany
Diary dates
25-28 Oct 2022
Ibiza, Ibiza, Spain
Diary dates
01-07 Dec 2022
tbc, Dunedin, New Zealand
Diary dates
17-18 Mar 2023
Tobacco Dock, London, United Kingdom
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
Music service provider Rehegoo (pronounced Reh-air-go) has launched a streaming service for health clubs, gyms, ...
Latest News
F45 has launched a corporate partnership programme which will enable businesses to open an F45 ...
Latest News
A two-year research project will look to find ways to transform the UK's physical activity ...
Latest News
The best in the business from across the physical activity sector were honoured last night ...
Latest News
At UK Active’s Active Uprising event yesterday (30 June) in Birmingham, Hattie Jones, the head ...
Latest News
HCM understands researchers are moving closer to creating a pill to mimic some of the ...
Latest News
Establishing new data and insight services and strengthening relationships with both government and the NHS ...
Latest News
More than one in five (27 per cent) Americans belonged to a health club or ...
Latest News
Ultimate Performance (UP) – the private gym chain and PT business – has opened a ...
Latest News
Luxury hotel chain Mandarin Oriental has launched a new brand called Intelligent Movement to deliver ...
Latest News
Boutique fitness chain 1Rebel opens the doors to its tenth club today (Monday 27 June ...
Featured supplier news
Featured supplier news: The University of Bath enhances sports facilities with £150,000 Matrix Fitness equipment upgrade
Leading UK university the University of Bath is steeped in a history of sporting excellence, with Team Bath committed to offering its students a wealth of sporting opportunities and access to world-class facilities.
Featured supplier news
Featured supplier news: How wearables-driven gamification will boost your business
It’s a known fact that gamification is an effective method to make everyday activities and work more fun.
Featured operator news
Featured operator news: Everyone Active to launch new exercise classes to reduce gender gap
As part of their work to break down the barriers that deter women and girls from participating in sport and physical activity, Everyone Active has teamed up with EMD UK to launch new exercise classes linked to the This Girl Can campaign.
Featured operator news
Featured operator news: New £42m Moorways Sports Village to open on 21 May
Everyone Active will open Moorways Sports Village to the public on Saturday 21 May with a grand opening weekend – in time for the half term holidays.
Video Gallery
Mindbody, Inc
Sport Alliance GmbH
Total Vibration Solutions / Floors 4 Gyms / TVS Sports Surfaces
Company profiles
Company profile: Xn Leisure Systems Ltd
Xn Leisure is a provider of cutting-edge health and fitness software, offering an exceptional service ...
Company profiles
Company profile: IONTO Health & Beauty GmbH
IONTO-COMED offers a wide range of treatment beds offering maximum flexibility and the symbiosis of ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
On demand
Fitness On Demand: On demand
Lockers/interior design
Safe Space Lockers Ltd: Lockers/interior design
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Salt therapy products
Himalayan Source: Salt therapy products
Wearable technology solutions
MyZone: Wearable technology solutions
Fitness equipment
A Panatta Sport Srl: Fitness equipment
Spa software
SpaBooker: Spa software
Management software
Premier Software Solutions: Management software
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Skincare
Comfort Zone - Davines S.p.A: Skincare
Property & Tenders
Pendine Sands, Carmarthenshire
Carmarthenshire County Council
Property & Tenders
Runcorn
Halton Borough Council
Property & Tenders
Diary dates
12-13 Sep 2022
Wyndham Lake Buena Vista Disney Springs® Resort, Lake Buena Vista, United States
Diary dates
21-21 Sep 2022
Various, London, United Kingdom
Diary dates
25-28 Oct 2022
Messe Stuttgart, Germany
Diary dates
25-28 Oct 2022
Ibiza, Ibiza, Spain
Diary dates
01-07 Dec 2022
tbc, Dunedin, New Zealand
Diary dates
17-18 Mar 2023
Tobacco Dock, London, United Kingdom
Diary dates
Search news, features & products:
Find a supplier:
JP Lennard
JP Lennard
Partner sites