Internal Reporting Use Cases

Internal Reporting Use Cases

Below are some use cases for each of the internal reports in the Hive.

QUESTIONNAIRES
Questionnaire export for 'back-of-house' checks
Client: Flight Club
Questionnaire Name: FlightClub_Lunch_Jan25
Questionnaire data: Questionnaire Name, Questionnaire ID
Question Data: Section Number, Section, Question Number, Question Subject, Question text, Question brief, Question weight, Na Option, Benchmark, Analysis tag, comments required, required before visit date
Answer data: answer options, answer type, answer weights

Basic export for clients
Client: Flight Club
Questionnaire Name: FlightClub_Lunch_Jan25
Questionnaire data: Questionnaire Name
Question Data: Section Number, Section, Question Number, Question Subject, Question text, Question brief, Question weight, Na Option
Answer data: answer options, answer weights 

List of clients with live OF questionnaires
Visit Type: Online Feedback
Questionnaire data: Client Name, Client ID, Questionniare Name, Questionniare Id, Visit Count

List of OF questionnaires with 'Age' question
Visit Type: Online Feedback
Analysis tag: Age
Questionnaire data: Client Name, Client ID, Questionniare Name, Questionniare Id, Visit Count

 

BRANCHES & USERS
List of live branches for a client
Client: Flight Club 
Location status: live
Client data: Client data: Brand, Region, Area, Branch, Branch code

List of live users for a client
Client: Flight Club
User status: Live
Location status: live
Client data: Brand, Region, Area, Branch
User data: User name, Email, Online access, Send PDF, Communication delay, delayed period visibility

List of branches and their currency
Client: all
Location status: live
Client data: Client name, Branch, Branch currency

 

CLIENTS
List of live clients and their most recent visit
Client status: live
Client data: Client name, client id, account manager
Visit data: Latest visit date

List of clients with OF data
Client status: live
Client data: Client name, client id
Visit data: Latest visit date, survey sample size 

Number of discarded visits per client
Client: Flight Club
Client data: Client name, client id, account manager
Visit data: Discard reason, Discarded date, visit count

 

VISITS
List of discarded visits in a period of time
Client status: live
Location status: live
Visit type: MV, DA, PA, TA
Visit status: Discarded
Visit date: 1st-31st Jan
Client data: Client Name, branch
Visit date: Visit id, visit date, discard date, discard reason

List of visits in a period of time and their fees
Client status: live
Location status: live
Visit type: MV, DA, PA, TA
Visit status: Reviewed and Completed
Visit date: 1st-31st Jan
Client data: Client Name, branch
Visit date: Visit id, visit date, Fee GBP

Number of OF visits per client per reporting period (weekly)
Client: Flight Club
Location status: live
Visit Type: OF
Reporting period data: Year name, quarter, month, week
Visit data: visit count

 

PERIODS
Export a client's reporting calendar
Client: Flight Club
Client data: Client name, client Id
Reporting period data: Default period, Year name, Quarter name, Month name, week name

Export a list of a client's scheduling periods
Client: Flight Club
Client data: Client name, client Id
Scheduling period data: Name, Start Date, End Date, Default period end, exclude from analysis

Number of visits and their statuses in a client's scheduling periods
Client: Flight Club
Client data: Client name, client Id
Scheduling period data: Name, Start Date, End Date, Default period end, exclude from analysis
Visit date: Visit Status, Visit count

    • Related Articles

    • Delivered Reporting Subscriptions

      There are 2 ways to subscribe a user to delivered reporting in the Hive. Please see below Scribes on each method: <br>

    • Weekly Reporting and Distribution List

      Screencast available here: https://screenpal.com/watch/cZnUFCVKwYx Pret has automated weekly reporting created via Logic Apps on a Wednesday and Thursday. Wednesday Schedule 4am - Asia Area and Region report. 11am - UK, US & EU Area report and UK, US ...

    • Use ‘related question’ as well as same ‘legacy question’ to group questions

      Where setting up a survey where answers, comments, dishes for one question may be stored against another question with the same legacy question (ID), then need to ‘Group’ questions by using the ‘Related Question’ option which tells the system that ...

    • Mystery Visit Questionnaire Design

      This article outlines best practice for structuring mystery visit questionnaires. The goal of a mystery visit questionnaire is to measure whether specific service standards were delivered during a visit, rather than to collect general opinions. ...

    • Historical data import

      Some clients would like us import their historical data from other third parties they have used in the past. This could be from an old survey or mystery visit. We can do these but more often than not, we will need to manipulate the data into a format ...