Create a marketing data quality audit framework.
**Data Systems:** ${{SYSTEMS}}
**Key Data Sources:** ${{SOURCES}}
**Known Issues:** ${{ISSUES}}
**Business Impact:** ${{IMPACT}}
Generate the framework:
**Data Quality Dimensions:**
**Accuracy:**
- Data correctness
- Error rates
- Validation rules
- Source verification
**Completeness:**
- Missing data
- Required fields
- Coverage gaps
- Fill rates
**Consistency:**
- Cross-system alignment
- Definition consistency
- Format standardization
- Duplicate handling
**Timeliness:**
- Data freshness
- Update frequency
- Latency issues
- Real-time needs
**Validity:**
- Format compliance
- Range validation
- Business rule compliance
- Logical consistency
**Audit Checklist:**
**Customer Data:**
- [ ] Contact information accuracy
- [ ] Email deliverability
- [ ] Duplicate detection
- [ ] Profile completeness
- [ ] Consent tracking
- [ ] Segmentation accuracy
**Campaign Data:**
- [ ] Tracking accuracy
- [ ] UTM consistency
- [ ] Attribution data
- [ ] Performance metrics
- [ ] Cost data
**Conversion Data:**
- [ ] Conversion tracking
- [ ] Revenue accuracy
- [ ] Lead data quality
- [ ] CRM integration
- [ ] Attribution alignment
**Analytics Data:**
- [ ] Tag implementation
- [ ] Event tracking
- [ ] Cross-domain tracking
- [ ] Filter accuracy
- [ ] Goal configuration
**Issue Identification:**
**Issue Log:**
| Issue | Severity | Impact | Root Cause | Fix |
|-------|----------|--------|------------|-----|
**Root Cause Analysis:**
- Process issues
- System issues
- Human error
- Integration problems
**Remediation Plan:**
**Immediate Fixes:**
- Critical issues
- Quick wins
- Manual corrections
**Systematic Improvements:**
- Process changes
- Automation
- Validation rules
- Training
**Prevention:**
- Quality controls
- Monitoring
- Documentation
- Governance
**Monitoring:**
- Quality metrics dashboard
- Alert thresholds
- Regular audits
- Continuous improvementOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
[{SYSTEMS][{SOURCES][{ISSUES][{IMPACT]Copy and paste into your favorite AI tool
Explore more Marketing prompts
Browse Marketing