Neftaly Data Collection Sheet Template
Purpose: To systematically organize raw inputs gathered across Neftaly’s digital platforms and field research channels
Developed by: Neftaly Consumer Behaviour Analysis Research Office
Governed by: Neftaly Research Royalty Protocols
🧾 1. Overview of the Template
| Feature | Description |
|---|---|
| 🗃️ Use Case | Captures raw response data before cleaning and analysis |
| 📲 Input Sources | Neftaly Website, WhatsApp, SMS, Mobile App, Chatbot, USSD |
| 🌐 Supports | Multilingual inputs, open- and closed-ended responses |
| ✅ Formats | Microsoft Excel (.xlsx), Google Sheets, CSV |
📂 2. Sheet Structure & Fields
| Column Name | Description | Format Example |
|---|---|---|
| Entry ID | Unique identifier for each response | USR-001, BOT-846 |
| Date/Time | Timestamp of submission | 2025-06-14 16:43 |
| Source Channel | Platform of submission | WhatsApp, SMS, Web |
| Region/Location | User’s general area | Gauteng, eThekwini, Limpopo |
| Language | Language used in response | English, isiZulu |
| Age Group | Age category (if available) | 18–24, 25–34 |
| Gender | Optional demographic | Male, Female, Other, Prefer not to say |
| Prompt ID | Corresponding GPT or survey question ID | COMM-02 |
| Raw Response | Direct user input or chatbot output | “I prefer voice notes for urgent messages.” |
| Response Type | Open text / Single choice / Multi-choice | Text, A–E, Tick List |
| Sentiment Score (optional) | Auto-detected by AI (−1 to +1 scale) | 0.7 (positive) |
| Validation Status | Pass / Fail / Needs Review | Pass |
| Flag Notes | Comments on data quality or anomalies | “Duplicate entry” or “Incomplete response” |
📁 3. Additional Tabs (Optional)
| Tab Name | Purpose |
|---|---|
Summary Dashboard | Auto-calculated totals by channel, region, tone |
Flagged Entries | Highlighted responses for review |
Validation Log | Notes from manual and automated data checks |
Prompt Tracker | Links response IDs to original prompts |
Consent Log | Timestamps and method of consent confirmation (if collected separately) |
🛡️ 4. Data Protection & Integrity Notes
- Personally Identifiable Information (PII) is not stored unless encrypted and flagged.
- Sheet includes access control suggestions and audit trail tracking for shared environments.
- All fields comply with Neftaly Research Royalty’s Data Security Standards, GDPR, and POPIA.
📝 5. Template Example (Sample Row)
| Entry ID | Date/Time | Channel | Region | Language | Age Group | Gender | Prompt ID | Raw Response | Type | Sentiment | Status | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USR-0092 | 2025-06-22 14:02 | Limpopo | English | 25–34 | Female |
Leave a Reply