Active IQ
Active IQ
Active IQ
Health Club Management

Health Club Management

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
Get the latest news, jobs and features in your inbox
Health Club Management

Health Club Management

features

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”

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
http://www.leisureopportunities.com/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
People
HCM people

Professor Zhen Yan

director of the Center for Skeletal Muscle Research, University of Virginia
Regular exercise may help people survive COVID-19
People
HCM people

Michael Ramsay

Founder and director, STRONG Rowformer
There’s something about the combination of fast-twitch and slow-twitch fibres working together that absolutely destroys you and gives you an almost euphoric feeling at the end of every workout
People
HCM people

Dr Jonathan Leary

Remedy Place, West Hollywood: Founder and CEO
Remedy Place teaches people how to take care of themselves and gives them the tools they need to be holistically healthy
Features
Coronavirus
The coronavirus pandemic has inspired a huge pivot to digital right across the industry, from sole traders to large chains and trusts. Kath Hudson looks at some of the offerings pulled together in lightning fast time to keep members active and sane
Features
feature
Matrix Connected Solutions helps Roko deliver a digital member experience beyond the four walls of the clubs
Features
Supplier showcase
Wattbike has partnered with Intelligent Cycling to transform indoor cycling with innovative new technology that enables automatic personalisation for riders in a group cycling class
Features
Innovation
With members stuck at home, now’s the perfect time to plan some cost-effective upgrades to your clubs. Suppliers explain how a flooring refresh could help attract members back in-club as the pandemic eases
Features
Software
With the coronavirus pandemic forcing gyms across the world to temporarily close their doors, staying connected to your members digitally has never been more important. Software suppliers tell Steph Eaves how they’re contributing
Features
Insight
Industry analyst David Minton launched his new fitNdata global monitor just in time to catch the headline numbers for the impact of the coronavirus on the sector. He tells us how it’s looking
Features
Coronavirus
As the sector looks into the void of the COVID-19 lockdown and its aftermath, Duncan Wood-Allum presents a blueprint for a positive future
Features
Latest News
The fitness industry in Europe is uniting today (30 May) to launch #beactivehour, a free ...
Latest News
PureGym has become the latest fitness operator to deploy a digital offering in a bid ...
Latest News
A new report has revealed the likely timescales and shape of the UK fitness market's ...
Latest News
There has been a "surge in appreciation" of exercise during lockdown, with people turning to ...
Latest News
Gyms and health clubs in Dubai, UAE, have begun reopening their doors today (27 May) ...
Latest News
HCM understands that the directors of énergie Fitness have brought in specialist company FRP Advisory ...
Latest News
Planning approval has been granted for a new David Lloyd Club in Bicester, Oxfordshire. The ...
Latest News
Aerobic exercise boosts blood flow into two key regions of the brain associated with memory, ...
Job search
POST YOUR JOB
Featured supplier news
Featured supplier: Bicester hotel opens purpose-built performance facilities to attract new target audience
The Bicester Hotel and Spa has launched purpose-built fitness and performance facilities to create a standalone, unique offering to attract a new demographic to the site.
Featured supplier news
Featured supplier: Incorpore and MoveGB ink groundbreaking partnership to transform corporate wellness offering
Incorpore and MoveGB have entered into a landmark partnership, combining the UK’s largest provider of corporate gym memberships with the nation’s biggest network of classes.
Video Gallery
How to use the MZ-Bodyscan
MyZone
The Best Product for the Best Clubs Read more
More videos:
Company profiles
Company profile: Life Fitness
Through our Life Fitness Solutions Partners, we can deliver design and build services, finance solutions, ...
Company profiles
Company profile: Crown Sports Lockers
Crown Sports Lockers has designed, crafted and fitted bespoke timber furniture for spas, hotels and ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Design consultants
Zynk Design Consultants: Design consultants
Skincare
Sothys: Skincare
Direct debit solutions
Harlands Group: Direct debit solutions
Wearable technology solutions
MyZone: Wearable technology solutions
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Hydrotherapy / spa fragrances
Kemitron GmbH: Hydrotherapy / spa fragrances
Spa software
SpaBooker: Spa software
Fitness software
Go Do.Fitness: Fitness software
Management software
Fisikal: Management software
Gym flooring
REGUPOL/Berleburger Schaumstoffwerk (BSW): Gym flooring
Property & Tenders
Greywell, Hampshire
Barnsgrove Health and Wellness Club
Property & Tenders
Derby City Council
Property & Tenders
Diary dates
04 Jun 2020
Marriott Forest of Arden Hotel & Country Club, Birmingham, United Kingdom
Diary dates
13 Jun 2020
Worldwide, Various,
Diary dates
06-07 Jul 2020
Eastwood Hall, Nottingham, United Kingdom
Diary dates
28-31 Aug 2020
Expo Centre & Riviera di Rimini, Italy
Diary dates
21-24 Sep 2020
Loews Coronado Bay Resort, Coronado, United States
Diary dates
11-12 Oct 2020
ExCeL London, London, United Kingdom
Diary dates
17-23 Oct 2020
Pinggu, Beijing, China
Diary dates
27-30 Oct 2020
Messe Stuttgart, Germany
Diary dates
30-31 Oct 2020
NEC, Birmingham, United Kingdom
Diary dates
27-28 Nov 2020
Athena, Leicester, United Kingdom
Diary dates

features

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”

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
http://www.leisureopportunities.com/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
Latest News
The fitness industry in Europe is uniting today (30 May) to launch #beactivehour, a free ...
Latest News
PureGym has become the latest fitness operator to deploy a digital offering in a bid ...
Latest News
A new report has revealed the likely timescales and shape of the UK fitness market's ...
Latest News
There has been a "surge in appreciation" of exercise during lockdown, with people turning to ...
Latest News
Gyms and health clubs in Dubai, UAE, have begun reopening their doors today (27 May) ...
Latest News
HCM understands that the directors of énergie Fitness have brought in specialist company FRP Advisory ...
Latest News
Planning approval has been granted for a new David Lloyd Club in Bicester, Oxfordshire. The ...
Latest News
Aerobic exercise boosts blood flow into two key regions of the brain associated with memory, ...
Latest News
Gympass has launched a new digital platform as a response to the increase in demand ...
Latest News
Austrian medical health and wellness operator, Lanserhof, has launched a programme for people who’ve had ...
Latest News
HCM can report that Europe Active's annual thought-leader conference, the European Health and Fitness Forum ...
Job search
POST YOUR JOB
Featured supplier news
Featured supplier: Bicester hotel opens purpose-built performance facilities to attract new target audience
The Bicester Hotel and Spa has launched purpose-built fitness and performance facilities to create a standalone, unique offering to attract a new demographic to the site.
Featured supplier news
Featured supplier: Incorpore and MoveGB ink groundbreaking partnership to transform corporate wellness offering
Incorpore and MoveGB have entered into a landmark partnership, combining the UK’s largest provider of corporate gym memberships with the nation’s biggest network of classes.
Video Gallery
How to use the MZ-Bodyscan
MyZone
The Best Product for the Best Clubs Read more
More videos:
Company profiles
Company profile: Life Fitness
Through our Life Fitness Solutions Partners, we can deliver design and build services, finance solutions, ...
Company profiles
Company profile: Crown Sports Lockers
Crown Sports Lockers has designed, crafted and fitted bespoke timber furniture for spas, hotels and ...
Catalogue Gallery
Click on a catalogue to view it online
Directory
Design consultants
Zynk Design Consultants: Design consultants
Skincare
Sothys: Skincare
Direct debit solutions
Harlands Group: Direct debit solutions
Wearable technology solutions
MyZone: Wearable technology solutions
Flooring
Total Vibration Solutions / TVS Sports Surfaces: Flooring
Hydrotherapy / spa fragrances
Kemitron GmbH: Hydrotherapy / spa fragrances
Spa software
SpaBooker: Spa software
Fitness software
Go Do.Fitness: Fitness software
Management software
Fisikal: Management software
Gym flooring
REGUPOL/Berleburger Schaumstoffwerk (BSW): Gym flooring
Property & Tenders
Greywell, Hampshire
Barnsgrove Health and Wellness Club
Property & Tenders
Derby City Council
Property & Tenders
Diary dates
04 Jun 2020
Marriott Forest of Arden Hotel & Country Club, Birmingham, United Kingdom
Diary dates
13 Jun 2020
Worldwide, Various,
Diary dates
06-07 Jul 2020
Eastwood Hall, Nottingham, United Kingdom
Diary dates
28-31 Aug 2020
Expo Centre & Riviera di Rimini, Italy
Diary dates
21-24 Sep 2020
Loews Coronado Bay Resort, Coronado, United States
Diary dates
11-12 Oct 2020
ExCeL London, London, United Kingdom
Diary dates
17-23 Oct 2020
Pinggu, Beijing, China
Diary dates
27-30 Oct 2020
Messe Stuttgart, Germany
Diary dates
30-31 Oct 2020
NEC, Birmingham, United Kingdom
Diary dates
27-28 Nov 2020
Athena, Leicester, United Kingdom
Diary dates
Search news, features & products:
Find a supplier:
Active IQ
Active IQ