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
Les Mills International
Les Mills International
Les Mills International
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
Running booms when health clubs and gyms are closed. Could this enthusiasm result in treadmill training becoming the new spinning? Kath Hudson reports
HCM magazine
Dr Davina Deniszczyc talks us through the findings of the first Nuffield Healthier Nation Index, which has benchmarked activity levels and attitudes to exercise among the UK population
HCM magazine
Life Fitness introduces Integrity SL, the next-generation LED console with intuitive functionality and digital connectivity
HCM Magazine
HCM People
The market demand is there and we’re going to meet and grow that demand
HCM Magazine
Letters
Fuel the debate about issues and opportunities across the industry. We’d love to hear from you – [email protected]
HCM Magazine
Sponsored
Active IQ is launching courses to upskill fitness professionals to work in social prescribing, extending the reach of the industry
HCM Magazine
Statistics
How have consumers responded to the end of lockdowns? Cesar Carvalho shares some bounceback numbers with HCM
HCM Magazine
Sponsored
Billed as the ‘2021 Experience Tour’, Egym has taken its connected gym floor experience on the road around the UK
HCM Magazine
Everyone’s talking about
Booming membership sales, busy suburban clubs and members visiting during the working day. Operators are reporting it’s good to be back. Kath Hudson finds out what business has been like since the re-set button was pressed
HCM Magazine
Sponsored
Andy Janes and Jamie Whisken explain the vision behind R1SE Bournemouth, and why Technogym was their choice of partner in delivering their unique fusion boutique
HCM Magazine
Latest News
Boxing-inspired fitness operator Rumble has signed a master franchise agreement in Australia, which could see ...
Latest News
Hotel giant Accor has launched a new bespoke, premium fitness service for its upmarket Pullman ...
Latest News
People should concentrate on exercise and staying fit – rather than dieting and weight loss ...
Latest News
Sibec Europe, scheduled to take place in Cologne, Germany, from 2 to 5 November 2021, ...
Latest News
Swim England has warned that 2,000 swimming pools could be lost forever unless the government ...
Latest News
Sports Minister, Nigel Huddleston, has joined gym-goers this morning to kick-off the annual National Fitness ...
Latest News
A new high-end workspace, designed for the use of personal trainers, coaches and other health ...
Latest News
VAT reform, adjustments in business rates and a fitness-led high street regeneration push could see ...
Featured supplier news
Featured supplier news: Power Plate teams up with Myzone for a new exercise experience
Power Plate has teamed up with Myzone to provide its community with new class experiences and the opportunity to offer rewards based on effort, every time they move.
Featured supplier news
Featured supplier news: Surge integrates Fisikal with HubSpot to drive business efficiencies and grow revenue
As Surge expands its offer with the launch of a third dedicated Electronic Muscle Stimulation (EMS) studio this summer – this time in Fleet Street, London – the brand reflects on the vital role of its estate wide digital ecosystem, created in partnership with Fisikal, designed to drive business efficiencies and commercial success.
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: Everyone Active
Everyone Active operates leisure centres in partnership with local councils across the UK. Today, Everyone ...
Company profiles
Company profile: RISE Fitness Franchise
RISE is a brand-new franchise created to fill an emerging gap. Outdoor workouts have become ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Exercise equipment
Matrix Fitness: Exercise equipment
Independent service & maintenance
Servicesport UK Limited: Independent service & maintenance
Architects/designers
Zynk Design Consultants: Architects/designers
Salt therapy products
Saltability: Salt therapy products
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Uniforms
Service Sport: Uniforms
Fitness equipment
Precor: Fitness equipment
Skincare
Comfort Zone - Davines S.p.A: Skincare
Wearable technology solutions
MyZone: Wearable technology solutions
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Property & Tenders
Welwyn Garden City
Welwyn Hatfield Borough Council
Property & Tenders
Newport, Shropshire
Lilleshall Sports Academy
Property & Tenders
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
Boxing-inspired fitness operator Rumble has signed a master franchise agreement in Australia, which could see ...
Latest News
Hotel giant Accor has launched a new bespoke, premium fitness service for its upmarket Pullman ...
Latest News
People should concentrate on exercise and staying fit – rather than dieting and weight loss ...
Latest News
Sibec Europe, scheduled to take place in Cologne, Germany, from 2 to 5 November 2021, ...
Latest News
Swim England has warned that 2,000 swimming pools could be lost forever unless the government ...
Latest News
Sports Minister, Nigel Huddleston, has joined gym-goers this morning to kick-off the annual National Fitness ...
Latest News
A new high-end workspace, designed for the use of personal trainers, coaches and other health ...
Latest News
VAT reform, adjustments in business rates and a fitness-led high street regeneration push could see ...
Latest News
Peloton has completed the merging of its commercial operations with Precor, the equipment brand it ...
Latest News
Half of UK adults aren't happy with their physical fitness levels, according to a study ...
Latest News
Temporary measures brought in to support businesses in the UK from insolvency during the pandemic ...
Featured supplier news
Featured supplier news: Power Plate teams up with Myzone for a new exercise experience
Power Plate has teamed up with Myzone to provide its community with new class experiences and the opportunity to offer rewards based on effort, every time they move.
Featured supplier news
Featured supplier news: Surge integrates Fisikal with HubSpot to drive business efficiencies and grow revenue
As Surge expands its offer with the launch of a third dedicated Electronic Muscle Stimulation (EMS) studio this summer – this time in Fleet Street, London – the brand reflects on the vital role of its estate wide digital ecosystem, created in partnership with Fisikal, designed to drive business efficiencies and commercial success.
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: Everyone Active
Everyone Active operates leisure centres in partnership with local councils across the UK. Today, Everyone ...
Company profiles
Company profile: RISE Fitness Franchise
RISE is a brand-new franchise created to fill an emerging gap. Outdoor workouts have become ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Exercise equipment
Matrix Fitness: Exercise equipment
Independent service & maintenance
Servicesport UK Limited: Independent service & maintenance
Architects/designers
Zynk Design Consultants: Architects/designers
Salt therapy products
Saltability: Salt therapy products
Whole body cryotherapy
Art of Cryo: Whole body cryotherapy
Uniforms
Service Sport: Uniforms
Fitness equipment
Precor: Fitness equipment
Skincare
Comfort Zone - Davines S.p.A: Skincare
Wearable technology solutions
MyZone: Wearable technology solutions
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Property & Tenders
Welwyn Garden City
Welwyn Hatfield Borough Council
Property & Tenders
Newport, Shropshire
Lilleshall Sports Academy
Property & Tenders
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:
Les Mills International
Les Mills International