HelpCenter

ADM - Reporting - Consumer Feedback Survey - KB38426
Updated

 

Report Specifies

Report Service Class: ReportAPIService

Web Service Class: ConsumerFeedbackSurveyController

Report Method: fetchReportMdl

Web Service Method: buildReport

Web Service URL: /api/consumerFeedbackSurvey/buildReport

 

 

Purpose

The purpose of this report is to show the results of the consumer feedback that was provided to a market.

 

Description

This report is used to view the results of the feedback provided to a market by their consumers. Results can give operators information on how to improve the consumer experience for their market.

 

Selection/Filter Criteria

Parameter Name

Parameter Type

Mapped Table

Mapped Column

Mandatory/Optional

Default Value (if any)

Report Name

List

reportorg_view

name,rptaction

Mandatory

 

Date Range

DateSelect

consumerfeedback

 

datecreated

Mandatory

Dates can be selected based on the following:

1.Custom Range

2. Yesterday

3. Today

4. Last seven days

5. Last 30 day

6. Last 60 days

7. Last week (SU-SA)

8. Last week (SA-FR)

9. This week

10. This month

11. Last month

12. Current and Previous Month.

Time Range

List

consumerfeedback

 

datecreated

 

Optional

Has a hh:mm format (24 hours)

Locations

List

consumerfeedback

salesheader

Mandatory

Multiple  selection of  Locations is allowed.

 

Image2_-_Customer_Feedback_Survey.png

Selection Fields

 

Report’s Data Source

Table Name

Table Type

Linked to

Linked Column

Join Type

Remarks

consumerfeedback

Master

     

 

salesheader

Transaction

consumerfeedback  sah.id = cfb.salesheader Inner Join

 

marketaccount

Transaction

salesheader

ma.id = sah.marketaccount

Left Join

 

 

 

Report Details

First level includes Location level data:

Column Name

Description

Direct/
Computed

Source Table

Source Column

Data Type

Calculation Logic

Display Format

Location Name

The name of the location.

Direct

salesheader

 

location

varchar(255)

 

 

String

Total Unique Questions

Total count of all unique questions rolled up from the survey questions under the location for the date and time selected.

Direct

consumerfeedback

 

question

text

COUNT(DISTINCT question)

 

Integer

 

Total Feedback count

Total count of all responses received across all survey questions under the location for the date and time selected.

Direct

consumerfeedback

 

id

Char(32)

COUNT(id)

 

Integer

 

Bad Count

Total count of all responses received for “Scale” style surveys that responded with a Sad Face under the location for the date and time selected.

Direct

consumerfeedback

 

rating

varchar(255)

Count(‘sad’) in rating column

 

String

Neutral Count

Total count of all response received for “Scale” style surveys that responded with a Neutral Face under the location for the date and time selected.

Direct

consumerfeedback

 

rating

varchar(255)

Count(‘normal) in rating column

 

String

Good Count

Total count of all responses received for “Scale” style surveys that responded with a Happy Face under the location for the date and time selected.

Direct

consumerfeedback

 

rating

varchar(255)

Count(‘happy’) in rating column

 

String

Yes Count

Total count of all responses received for “Yes/No” style surveys that responded with a “Yes” under the location for the date and time selected.

Direct

consumerfeedback

 

isreadytorefer

varchar(255)

Count(1) in isreadytorefer column

 

String

No Count

Total count of all responses received for “Yes/No” style surveys that responded with a “No” under the location for the date and time selected.

Direct

consumerfeedback

 

isreadytorefer

varchar(255)

Count(0) in isreadytorefer column

 

String

Total contact info received

Total count of all contact form information received under the location for the date and time selected.

 

Computed

consumerfeedback

 

Name, email, phone

Char(32)

Max of count name, email and phone

 

Integer

 

 

Second level includes Question level data:

Column Name

Description

Direct/
Computed

Source Table

Source Column

Data Type

Calculation Logic

Display Format

Question

 

The actual question displayed on the kiosk for the location.

Direct

consumerfeedback

question

 

varchar(255)

 

String

Style

The style of survey (e.g., Scale or Yes/No).

Direct

consumerfeedback

questiontype

varchar(255)

 

String

Contact Form

The contact form set to show or not show for this survey question.

 

 

 

varchar(255)

 

String

Triggers

Triggers were set to show the contact form button.

Direct

consumerfeedback

ratingoptions

varchar(255)

 

String

Options

Options or fields that were set to be included in the contact form.

Direct

consumerfeedback

 

contactoptions

 

varchar(255)

 

String

Total Feedback Count

Total count of all responses received for this one survey question under the location for the date and time selected.

Direct

consumerfeedback

 

id

 

Char(32)

COUNT(id)

 

Integer

Bad Count

Total count of all “Sad Face” responses received for this one survey (if it was a scale style) under the location for the date and time selected.

Direct

consumerfeedback

 

rating

 

varchar(255)

Count(‘sad’) in rating column

 

String

Neutral Count

Total count of all “Neutral Face” responses received for this one survey (if it was a scale style) under the location for the date and time selected.

Direct

consumerfeedback

 

rating

 

varchar(255)

Count(‘normal) in rating column

 

String

Good Count

Total count of all “Happy Face” responses received for this one survey (if it was a scale style) under the location for the date and time selected.

Direct

consumerfeedback

 

rating

 

varchar(255)

Count(‘happy’) in rating column

 

String

Yes Count

Total count of all “Yes” responses received for this one survey (if it was a Yes/No style) under the location for the date and time selected.

Direct

consumerfeedback

 

isreadytorefer

varchar(255)

Count(1) in isreadytorefer column

 

String

No Count

Total count of all “No” responses received for this one survey (if it was a Yes/No style) under the location for the date and time selected.

Direct

consumerfeedback

 

isreadytorefer

varchar(255)

Count(0) in isreadytorefer column

 

String

Contact Info Received

Total count of all contact form information received for this one survey under the location for the date and time selected.

Computed

consumerfeedback

 

name, email,phone

Char(32)

Max of count name , email and phone

Integer

 

Third level includes Consumer level data:

Column Name

Description

Direct/
Computed

Source Table

Source Column

Data Type

Calculation Logic

Display Format

Date

Date of the transaction related to the consumer feedback.

Direct

consumerfeedback

 

datecreated

 

varchar(255)

 

String

Device

The device name related to the transaction and the consumer feedback.

Direct

salesheader

 

devicename

 

varchar(255)

 

String

Trans ID

The transaction ID related to the transaction and the consumer feedback.

Direct

salesheader

 

transid

 

varchar(255)

 

String

Customer Name

The name of the consumer if they paid by account, and their first and last name is available.

Direct

marketaccount

 

concatname

 

varchar(255)

 

String

Customer Email

The email of the consumer if they paid by account and their email address is available.

Direct

marketaccount

 

email

 

varchar(255)

 

String

Feedback

The feedback results Bad, Neutral, Good, Yes, No related to the transaction.

Direct

consumerfeedback

 

rating, isreadytorefer

 

varchar(255)

IFNULL(rating, isreadytorefer)

 

String

Contact Name

The name inserted in the contact form, if available, related to the transaction.

Direct

consumerfeedback

 

name

 

varchar(255)

 

String

Contact Phone

The phone number inserted in the contact form, if available, related to the transaction.

Direct

consumerfeedback

 

email

 

varchar(255)

 

String

Contact Email

The email address inserted in the contact form, if available, related to the transaction.

Direct

consumerfeedback

 

phone

 

varchar(255)

 

String

Contact Form Text

The contact form text given by the user.

Direct

consumerfeedback

contactformtext

varchar(255)

 

String

 

Image1_-_Customer_Feedback_Survey.png

Consumer Feedback Survey