FARISI Road Show - Sales Report Spreadsheet

# FARISI ROAD SHOW

📊 SALES REPORT SPREADSHEET TEMPLATE

📅 Date: 5th June 2026 | 📍 Route: Kasarani → Roysambu → Zimmerman → Lucky Summer → Baba Dogo → Kariobangi North → Allsops

## 📝 Sheet 1: Sales Leads Capture

Track all prospects collected during the roadshow and monitor follow-up actions.

No. | Date | Location | Sales Rep | Customer Name | Phone Number | Product/Service Interest | Lead Status (Hot/Warm/Cold) | Follow-up Date | Remarks
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 |  |  |  |  |  |  |  |  |
2 |  |  |  |  |  |  |  |  |
3 |  |  |  |  |  |  |  |  |
4 |  |  |  |  |  |  |  |  |
5 |  |  |  |  |  |  |  |  |

## 💰 Sheet 2: Sales Conversion Report

Track actual sales generated from each location.

No. | Date | Location | Sales Rep | Customer Name | Product Sold | Quantity | Unit Price | Total Sale (KES) | Payment Method | Receipt No.
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 |  |  |  |  |  |  |  |  |  |
2 |  |  |  |  |  |  |  |  |  |
3 |  |  |  |  |  |  |  |  |  |
4 |  |  |  |  |  |  |  |  |  |
5 |  |  |  |  |  |  |  |  |  |

## 📍 Sheet 3: Location Performance Report

Performance metrics summary for each activation location.

Location | Customer Interactions | Leads Generated | Sales Closed | Revenue Generated (KES) | Conversion Rate (%) | Remarks
--- | --- | --- | --- | --- | --- | ---
Kasarani |  |  |  |  |  |
Roysambu |  |  |  |  |  |
Zimmerman |  |  |  |  |  |
Lucky Summer |  |  |  |  |  |
Baba Dogo |  |  |  |  |  |
Kariobangi North |  |  |  |  |  |
Allsops |  |  |  |  |  |

### 📌 Formula

Conversion Rate = (Sales Closed ÷ Leads Generated) × 100

## 👥 Sheet 4: Sales Rep Performance Report

Individual performance metrics for each sales representative.

Sales Rep Name | Interactions | Leads Generated | Sales Closed | Revenue Generated (KES) | Conversion Rate (%)
--- | --- | --- | --- | --- | ---

### 🎯 KPI Targets

- Minimum Leads per Rep: 20
- Minimum Sales per Rep: 5
- Revenue Target per Rep: KES

## 📊 Sheet 5: Daily Roadshow Summary

### Event Details

📅 Date:
📍 Route: Kasarani → Roysambu → Zimmerman → Lucky Summer → Baba Dogo → Kariobangi North → Allsops

### Summary Metrics

Customer Interactions
Leads Generated
Sales Closed
Revenue Generated (KES)
Conversion Rate (%)
Actual Achievements

### Top Performers

🏆 Best Performing Location:
Revenue Generated (KES):
⭐ Best Performing Sales Rep:
Sales Closed:
Revenue Generated (KES):

### Challenges Encountered

### Recommendations

Prepared By (Date)
Approved By (Date)