Part of Lumen

Analyze a sales CSV: define revenue before ranking results

Decide whether sales means gross orders, paid invoices or net revenue after returns. Identify the reporting date, currency and treatment of cancelled transactions. Group a small sample manually, then compare it with the generated result. A ranking can reverse when you change the metric from units to revenue.

Validate a small example

  1. Use a non-sensitive file with a total you already know.
  2. Check missing values, duplicate rows and the date range.
  3. Inspect the generated SQL and compare one result with a manual calculation.
  4. Keep the question and assumptions with the exported answer.

Before you upload

QueryAI sends the CSV to its server for processing. Review the privacy terms and obtain permission before uploading business data. Start with a small export and remove fields that are not needed for the question. See current plan limits before relying on a recurring workflow.

Try it for real with your CSV

Product details checked 2026-10-26. QueryAI: current workflow and pricing. Vendor capabilities and offers can change.