Sale Upload & Feed Performance : Sandbox

Introduction

Feefo's Sale Upload & Feed Performance dashboard is a comprehensive tool designed to help businesses monitor and analyse their sales data. It provides insights into the data upload process, detailing the number of lines processed, as well as identifying lines that were blocked, duplicated, or contained errors. This detailed analysis helps businesses to streamline their data handling, improve customer satisfaction, and make informed decisions based on comprehensive reports generated by the dashboard.

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:

Filter	Description
Merchant Name	Select the Merchant name of the account you wish to view.
Upload Date	Choose the date range from a preset option or custom range.
Source	The source of the upload, whether it is in Hub or third-party.
Successful Upload	Whether the file uplaod to display has been successful or not.

Report Chart

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

Chart	Description
Processed Lines	Number of lines submitted in the sale uploaded file. This is made up of the following 4 items. Calculation: SUM total order lines
Saved Lines	Number of lines saved into Feefo Database. Calculation: SUM saved lines
Duplicated Lines	How many lines are duplicated Number of duplicated lines such as Order Reference previously used. AND No Campaign Schedule AND Campaign Type is default OR Already has actions for Sale Items Calculation: SUM duplicated lines
Blocked Lines	Number of order Lines that weren’t accepted for some reason, mainly informed by the Merchant, like: Product Blocked SKU Blocked Product Descriptions Emails of domain @marketplace.amazon Excluded Email Minimum Interval Sale Too Old for Update Message Inconsistent auxiliary data Calculation: SUM blocked lines
Error Lines	Number of error lines If something went wrong, there will be an Error message summarizing what went wrong, some possible messages are: Problem processing sales file Invalid user Failed to upload file Failed to parse Sale Content into an order line For Magento Invalid or no Consumer Key and/or Consumer Secret supplied Could not connect to Merchants Magento platform. Please check details supplied Something is missing... please could you confirm you are a valid Feefo Member and verifier code is valid Calculation: SUM error lines
Sales Upload Performance	Present the above metrics in a column chart. Additionally, include a line representing the Rejection Rate, calculated as Error Lines divided by Processed Lines.
Sale Upload x Catalogue Performance	Showing the number of error lines with the error "Row X is rejected because the system could not find the product catalogue information" against all processed lines.
Log Table	Details data for each sales upload file is provided. The 'View Details' option allows users to drill down and access all metrics and error messages for each error or rejected line.