KENYA · GUIDE 0589 · EDITION 4.7
Spreadsheet dashboard building in Kenya: Marketing and First Buyer Outreach
Editorial update: 28 October 2026 · Business planning reference · Review scope
Match the message to the buyer’s decision
Reach owners needing a repeatable operational summary with a scope-led outreach draft and evidence of the promised result.
This is a planning reference for spreadsheet dashboard building. The order below is an invented teaching case. It is not a completed customer job, an operating approval or a prediction of demand or earnings.
The example offer and its boundary
Fictional dashboard DSH-89 summarises an owner-approved sales table using four fixture rows: confirmed 500, confirmed 700, cancelled 300 and refund 200. The example definitions yield confirmed sales 1,200, refunds 200 and net 1,000; cancelled 300 is excluded. These are invented test values, not audited accounts. Output is source table, metric dictionary, three KPI cells, one monthly chart and refresh instructions. Forecasting, tax reporting, accounting assurance and live-system integration are excluded.
A draft to adapt before sending
Hi [owner], I can build three clearly defined KPIs and one monthly chart from your approved table, with a fixture sheet proving what is included. Please explain confirmed, cancelled and refunded states before design. You will practise refresh and trace one number back to source at handover.
This is an unsent draft. Replace placeholders and assumed prices, confirm the actual scope and remove any claim you cannot support. No prospect was contacted for this example.
Prepare proof of the specific promise
| Question from the prospect | Evidence to prepare |
|---|---|
| What will I receive? | Build an explainable spreadsheet dashboard from defined business records. |
| What must be checked before starting? | Order value, cash received and revenue are not assumed interchangeable. |
| How will acceptance be confirmed? | Chart period/units and last refresh are visible; owner signs off definitions before live use. |
| Which mismatch must be addressed honestly? | New month missing |
| What input evidence supports suitability? | Check whether refunds are positive separate amounts or signed entries before writing formulas. |
Follow the enquiry through to a result
| Stage | Record to retain |
|---|---|
| Enquiry | Actual buyer requirement, buying authority, timing and permission to follow up |
| Quotation | Written scope, exclusions, acceptance, price and collection terms |
| Accepted order | Buyer approval linked to a quote version |
| Delivery | Actual accepted quantity, evidence, credits and outstanding issues |
| Collection | Cash received, reference, remaining balance and due date |
Use names, photographs and testimonials only with appropriate permission. A message sent, an encouraging reply and a paying repeat customer are different outcomes. Do not invent reviews, demand figures, certifications or guaranteed returns.
References and their limits
SUMIFS function — Microsoft
Conditional summation and matching range dimensions; business metric definitions remain client decisions. Reference check recorded 2026-10-26.
Keeping leading zeros and large numbers — Microsoft
Import identifier columns as text to preserve zeros and precision. Reference check recorded 2026-10-26.
Import data from data sources (Power Query)
Import preview and data-source workflow; version-specific menus may differ. Reference check recorded 2026-10-26.
Recorded references support only the scope stated beside them. They do not prove current supplier stock, a local quotation, actual buyer demand, operator competence or the feasibility of this particular business. Later editorial changes do not refresh earlier source-check dates.
Prepared by Business Starter Guides using AI-assisted drafting and desk editorial checks. Independent operator trials and specialist certification are not claimed. See the editorial method for the review scope.
Editorial method and evidence limits