Fixing formulas every month
A source adds a column or a marketplace renames a field, and the VLOOKUPs break. Whoever builds the report spends hours repairing the file instead of reading the numbers.
Solutions by problem
Many businesses still download files from every source, paste them into one big spreadsheet and fix the formulas every month. DataxLand keeps Excel as a source if you want it, but drops the copy-paste: Si understands the file structure, and the data is standardised, tested and turned into metrics on every refresh.
Free plan with no time limit · No card required · Sample workspace ready in minutes
A source adds a column or a marketplace renames a field, and the VLOOKUPs break. Whoever builds the report spends hours repairing the file instead of reading the numbers.
A row pasted twice or left out still produces a plausible-looking total. Excel won't tell you.
"October report FINAL final" lives in email, the shared drive and someone's laptop. Nobody is sure which one everyone is using.
Formulas on formulas, hidden sheets and hand-coloured cells. When that person is busy, the whole company waits.
Si answers with approved metrics, their source and confirmation level.
Definitions come from the analytics packs; Si, dashboards and reports use exactly these.
| Metric | Definition | Unit |
|---|---|---|
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
| Net margin | Profit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenue | Ratio (%) |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
One sheet per table, plus a sheet describing the columns (data_dictionary); no need to restructure your existing file.
Si reads the descriptions, proposes a mapping into your industry's standard model and flags what it's unsure about; you approve before anything is built.
Next month, upload the new file or connect the source directly; metrics are recalculated on the same definitions and tests run after every build.
Yes. You can export data at any time, and from the Small Business plan you can push numbers to Google Sheets on a schedule.
Si reads column names, descriptions and a sample of the data with personal details masked, then proposes an interpretation with questions where things are unclear. You answer and approve; nothing is built until you do.
Columns marked as personal data are hashed on load and masked before they enter Si's prompt; no API, Si answer or MCP call returns buyers' personal details.
Free plan with no time limit · No card required · Sample workspace ready in minutes