Who this is for
Owner or manager with one sales export and the same ten questions every week.
The same questions are answered by hand each week, or a chat tool once gave a plausible wrong number.
The result
Ten named questions become saved, parameterised queries or pivots on your export, each returning your hand-worked number on a test snapshot, with a one-page note on how each answer is calculated. Rephrased questions go to the right saved query or are refused. No query is written at run time.
What is included
- One table of up to 1 million rows and ten questions you write down
- A saved query or pivot for each question, checked on a fixed snapshot
- A second snapshot in which you change rows we are not told about, to check answers move correctly
- A routing step that maps rephrased questions to a saved question, or refuses
- A one-page note on how each answer is calculated
You receive
- The ten saved queries or pivots
- The routing step and its refusal list
- The test snapshots and expected answers
- The one-page calculation note
- Run steps
What is not included
- Questions outside the ten
- Writing new queries at run time
- A live warehouse or database connection
- Personal data columns
- Charts or dashboards
What we need from you first
- The ten questions in your own words
- The columns in your export, as text
- No real records, personal data or credentials in the first enquiry
Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.
How we check it is done
- On the fixed snapshot, all ten answers equal your hand-worked numbers.
- On a second snapshot in which you change a few rows without telling us which, each answer moves by an amount you compute yourself.
- Of your 30 held-back rephrasings (three for each of the ten questions), at least 27 go to the right saved question and none goes to a wrong one; a refusal counts as a miss. 27 of 30 shows the true rate is at least 76% with 95% confidence.
- 5 questions outside the ten, which you write and we do not see beforehand, each get a refusal, not a guess.
- The run log shows only saved query names; no SQL or formula is generated at run time.
You inspect the ten answers, the routing results and the refusals, and sign off in writing. Payment follows sign-off.
When we would stop or decline
- You want to ask anything of a live warehouse
- The table holds personal data columns that cannot be removed
- You want the system to write new queries as it goes
- You cannot work out the ten answers by hand
Questions
Is this a chatbot?
No. It maps your wording to one of ten saved, checked queries, or says it cannot answer.
Can I ask a new question?
Not without adding a saved query for it. That is deliberate: every answer is one we checked against your numbers.
Will it connect to my database?
No. It works on an export you send.
Price and terms
£245 · untested offer price. £245 after the agreed test passes on the held-back part and you sign off. No payment before sign-off.
This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.