Sales target by quarter
USD, quantity × MD price
Sales target by product category
USD
Marketing budget by month and activity
USD
Sales target vs marketing budget by sales person
Same order in all three panels, sorted by sales target
Sales target
Marketing budget
Marketing as % of sales target
Consolidated by sales person
Click a row to filter to that person
Consolidated by region
Sales target by sales person
USD
Top distributors
By sales target value
Marketing budget by activity
Promotional materials
Consolidated product report
All products and SKUs across the selected budgets, grouped by category. Click a row for the breakdown by sales person and distributor.
Budgets
Drop budget workbooks here
or click to choose files (.xlsx). You can select several at once.
or click to choose files (.xlsx). You can select several at once.
Each workbook is read in your browser and checked before saving. Uploading again for the same sales person and year replaces the previous version. New products and SKUs found in a template are added to the catalogue automatically.
Downloads follow the filters above and only include budgets you have access to. Every workbook states the exchange rate used; marketing and promotional figures are given in KES and USD, volumes in KG.
Consolidated budget
Summary by sales person, product report, product × sales person, sales vs marketing, marketing by month, and every line from every budget.
Individual budgets
One workbook per sales person: summary, product targets with KG, marketing budget by month, promotional materials and distributor targets.
Product report
All products and SKUs with units, KG and value by quarter, plus breakdowns by sales person.
Sales vs marketing
Sales target, marketing and promotional budgets and ratios per sales person and region.
Marketing budget
Activity × month, by sales person, and all marketing and promotional lines.
Catalogue
Products, SKUs, categories, MD prices and KG per unit.
Exchange rate
Used to compare KES marketing and promotional budgets with USD sales targets.
SKU weights (KG per unit)
Access control
The dashboard owner and anyone it is shared with as Editor are always admins. Sales people found in budgets are listed automatically; link each one to their account to give them access.
People also need the dashboard shared with them (Share button): Contributor for anyone who uploads or edits budgets, Viewer for read-only users. Roles here decide which pages and budgets each person sees.
Add a product or SKU
To add a new pack size to an existing product, pick its category and type the same product name. You can also use “+ SKU” on any product below.