Feedback Report

TABLE OF CONTENTS

Introduction


The Feedback Report serves as a rapid access point for merchants to efficiently locate, filter, and review feedback, providing insights into its current status. Notable updates include integrating Accounts and Tags for enhanced data filtration. For instance, users will have the ability to filter feedback based on 'Campaign Tags', streamlining the feedback management process effectively.



Downloading Data Best Practice

When you download a CSV file and open it directly in Microsoft Excel, you might see strange characters instead of the correct text. This happens because the CSV file uses a format called UTF-8, but Excel doesn't always recognise this correctly unless a special marker (BOM) is included. By default, Excel assumes a different format (ANSI or Windows-1252), which can cause text to display incorrectly.

For example:

  • A file exported from Feefo Analytics with UTF-8 encoding might contain the text: Intel®® Core™.

  • When opened directly in Excel, this text could appear as: Intel¬Æ¬Æ Core‚Ñ¢.

Import the CSV File into Excel and Select UTF-8 Encoding

To make sure Excel displays your data correctly, follow these steps instead of opening the file directly:

  1. Open Microsoft Excel.

  2. Go to the Data tab and select Get Data from Text/CSV.

  3. Choose your CSV file.

  4. In the import settings, select Unicode (UTF-8) as the file origin.

  5. Click Load to complete the process.

Use Another Application to Open the File

If you prefer, you can use other programs that automatically recognise UTF-8 encoding, such as:

  • Google Sheets

  • Apple Numbers


Report Filters


Report filters allow users to narrow down the data displayed in their reports based on specific criteria or conditions. Here's what report filters enable users to do:


Field Description
Merchant Name Enter the name or identifier of accounts available to the user. If you select multiple accounts you see the aggregation in the metrics
Child Merchant Name Child Merchant Name(s) option auto-selects all child accounts under the parent account under Merchant Name(s) by default.
Selecting specific child merchants will override this and show only your selections.
This “select all/deselect all” behaviour now works across all tag filters.
Date Source Choose from sales date or feedback request date.
Date Range Choose from preset date range options or create a custom range.
Chart Granularity Choose from Day, Week, Month, Quarter or Year. This determines the X axis in the graphs and how the data points are also aggregated. 
Product or Service Feedback Choose to display Product or Service Feedback
Order Reference Filter to a particular transaction.
Primary Tag Key Once the merchant has been selected only the relevant tag keys will be visible.
Primary Tag Value When you have selected a particular key, only the tag values for that key will be visible. 
Secondary Tag Key Once the merchant has been selected only the relevant tag keys will be visible.
Secondary Tag Value Then you have selected a particular key, only the tag values for that key will be visible. 
Tertiary Tag Value Once the merchant has been selected only the relevant tag keys will be visible.
Tertiary Tag Value Then you have selected a particular key, only the tag values for that key will be visible. 
Comments Filter comments based on key words using a range of preset parameters.
Product/Service Rating A numerical or star-based evaluation of a product or service, reflecting customer satisfaction and quality.
Campaign Name Filter by the designated title of the campaign. You cannot select private and public campaigns.
Moderation Status The current state of review for user content, indicating whether it is approved, pending, or rejected based on community guidelines.
Moderation Rejected Reason If a review is rejected, you can filter by the reason associated to it.
Breakdown Table Value Format Number / %
Hide/Show Child Merchant(s) in Breakdown Show – display feedback per child merchant
Hide – aggregate feedback at the parent level


Report Charts


Feefo charts refer to the visual representations of data generated within the platform.

Note, you can drill down into the charts to see the individual reviews. All the displays are upto to 500 rows. You can download all data if required.


Field Description
Feedback Received The count of distinct product/service feedback id. This isn't at sale level. If there is multiple pieces of product feedback for a single sale, it will appear as multiple pieces of feedback.
% Published The percentage of product/service feedback that are published.
% Rejected The percentage of product/service feedback that are rejected.
% Pending The percentage of product/service feedback that are pending.
% Feedback With Comments The percentage of product/service feedback with consumer comment.
% Replied by Merchant The percentage of product/service feedback that are replied by merchant
Rating Amount of reviews received for each star rating in a pie chart.
Number of Feedback A line chart that shows number of product/service feedback received by date.

 

Feedback Breakdown by Tag

Field Description
Primary Tag The first-level tag used to categorise feedback, typically aligned to major themes or departments.
Secondary Tag A sub-category under the primary tag for more detailed classification.
Tertiary Tag A third-level tag for further granularity in tagging feedback.
Child Merchant The name of the child account that received the feedback, used when viewing data beneath a parent merchant.
Feedback Received The total number of feedback entries submitted for this tag or merchant.
5 Star The number of 5-star ratings given in the feedback received.
4 Star The number of 4-star ratings given in the feedback received.
3 Star The number of 3-star ratings given in the feedback received.
2 Star The number of 2-star ratings given in the feedback received.
1 Star The number of 1-star ratings given in the feedback received.
Average Rating The average star rating across all feedback received in the selected period.
Published The number of feedback items that have been moderated and published.
Pending The number of feedback items awaiting moderation.
Rejected The number of feedback items rejected during moderation.
Total Comments The total number of written comments provided across all feedback received.
Supplier Responses to All Feedback The total number of supplier (merchant) responses posted across all feedback entries.

 

Note: A Response Rate of 100% may be shown if any of the following filters are applied:

• Product/Service Rating
• Moderation Status
• Moderation Rejected Reason
• Any Insight Tag Key
• Feedback Received Date or Feedback Updated Date as the Date Source

When these filters are applied, the data will be filtered to only requests that have feedback. To see the true response rate (including requests without feedback), try using filters like Feedback Requested Date or Sale Date, and avoid filtering by feedback-related fields.



Feedback Columns


Note, you can drill down into the charts to see the individual reviews. All the displays are up to to 500 rows. You can download all data if required. This is only for tiles, not all charts.


Field Description
Merchant Name Show the merchant that received the feedback. Use the hamburger menu to open drill down options
Freeze
Copy values
Autosize All Columns
Reset All Column Widths
Order Ref A unique identifier for an order, used to track and reference the specific purchase.
Sale Date The date on which the product or service was sold to the customer.
Feedback Date The date on which a customer provided feedback or a review about the product or service.
Email The customer's email address, used for communication and notifications regarding their order and feedback.
Product SKU The Stock Keeping Unit (SKU) assigned to a product, used to uniquely identify and manage inventory.
Description A description of the product.
Rating A numerical or star-based score given by a customer to evaluate a product or service.
Comment A customer's written feedback or opinion about a product or service.
Moderation Status The current review state of user-generated content, indicating whether it is approved, pending, or rejected.
Rejected Reason The explanation provided for why a piece of user content was rejected during moderation.
Replied by Merchant Indicates whether the merchant has responded to the customer's comment or feedback.
Rerated Indicates whether the original rating given by a customer has been updated or changed.