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:


FilterDescription
Merchant NameSelect the Merchant name of the account you wish to view.
Upload DateChoose the date range from a preset option or custom range.
SourceThe source of the upload, whether it is in Hub or third-party.
Successful UploadWhether 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.


ChartDescription
Processed LinesNumber of lines submitted in the sale uploaded file. This is made up of the following 4 items.


Calculation: SUM total order lines

Saved LinesNumber of lines saved into Feefo Database.


Calculation: SUM saved lines

Duplicated LinesHow 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 LinesNumber 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 LinesNumber 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 PerformancePresent 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.