SayPro Data Quality and Validation Template

SayPro Data Quality & Validation Template

Validation Period: ____ / ____ / 2025 to ____ / ____ / 2025
Validated By: ____________________
Project/Observation Cycle: ____________________
Data Source: ☐ Instore Logs ☐ GPT Outputs ☐ Reports ☐ Survey Results ☐ Other: ___________

---

1️⃣ Data Completeness Check

Data Field	Required?	% Completion	Issues Found	Action Taken
Observation Dates	✔	100%	–	N/A
Store Location Tags	✔	95%	2 missing entries	Flagged and corrected
Demographic Estimates	✔	98%	1 mismatch	Manual correction
…	…	…	…	…

---

2️⃣ Accuracy & Consistency Check

Data Type	Validation Rule	Verified?	Issues Identified	Remarks
Time logs	Match observer sign-in/out	☐ Yes ☐ No	1 time inconsistency	Cross-checked with portal
Product interaction notes	Aligned with checklist	☐ Yes ☐ No	Variance in 2 records	Retraining suggested
GPT-generated themes	Consistent with topic goals	☐ Yes ☐ No	Some vague categories	Prompt refinement required

---

3️⃣ Duplicate & Error Detection

Record Type	Total Checked	Duplicates Found	Corrected	Notes
Observation Logs	50	2	✔ Yes	Tagged as accidental resubmits
GPT Entries	30	0	N/A	Clean
Demographic Logs	45	1	✔ Yes	Auto-filtered

---

4️⃣ Validation Summary & Recommendations

Overall Data Health: ☐ Excellent ☐ Good ☐ Moderate ☐ Needs Attention

Summary Notes:

---

---

Recommendations for Future Cycles:

• Improve demographic tagging automation
• Add dropdown restrictions to observation forms
• Reinforce training on time logging precision

---

🖊️ Validator Signature: ____________________

Date: ____ / ____ / 2025
Submitted To: SayPro Research Portal – Data QA Section