E-Discovery Collection & Review Summary
Internal status report tracking ESI from collection through attorney review, with completion projections.
Prerequisites
- Custodian list with collection scope (systems, date ranges, locations)
- Collection logs and processing reports from vendor
- Review platform exports (coding, reviewer activity, search-term results)
- Search-term list or Boolean queries
- Review protocol (relevance, privilege, issue tags) and QC standards
- Key deadlines the review must meet
- Protective order or confidentiality requirements for reporting
Quick Start
- Gather source data (collection logs, processing reports, review exports, search-term results, privilege summaries).
- Normalize custodian names into a master mapping table.
- Run integrity checks — pipeline totals must satisfy: Collected ≥ Processed ≥ Loaded ≥ Reviewed.
- Compute core metrics tables (see below).
- Draft executive summary with risks and recommendations.
- Apply work-product legend.
Core Metrics
A. Collection & Processing by Custodian
Per custodian: Collected GB, Item Count, Processed %, Load Failures, File-Type Mix, Exceptions.
B. Search-Term Effectiveness
Per term/query: Hits, Hit Rate %, Sample Precision %, Overlap %, Recommended Action.
C. Review Status (Matter-Level)
Total Reviewable, Reviewed Count, % Reviewed, Relevant %, Privileged %, Non-Responsive %, Est. Completion Date.
D. Reviewer Productivity
Per reviewer/team: Docs Reviewed, Hours, Docs/Hour, Relevant %, Privileged %, QC Rate %.
E. Privilege Patterns
Per custodian: Privileged %, Dominant Doc Types, Red Flags.
Key Formulas
| Metric |
Formula |
| Hit Rate % |
hits ÷ total reviewable corpus |
| Precision % |
relevant hits ÷ sampled hits |
| Review Velocity |
docs reviewed ÷ time period |
| Completion ETA |
remaining docs ÷ current velocity |
| Privilege Rate % |
privileged ÷ reviewed |
Executive Summary Template
- Collection completeness — status and anomalies
- Processing health — success rate and key errors
- Search-term performance — top/weak terms and overlap
- Review progress — reviewed %, relevance %, privilege %
- Forecast — ETA with assumptions
- Risks & actions — top three items
Integrity Checks
- Custodian names align across all sources (master mapping table).
- Pipeline totals are monotonically decreasing through each stage.
- Every search term in the term list appears in the results export.
- Coding records contain reviewer, date, relevance, and privilege fields.
- Processing errors are reconciled against re-runs.
Findings & Recommendations
- List missing sources and resulting limitations.
- Flag custodians with outlier volumes or error rates.
- Identify low-precision or high-overlap search terms.
- Note reviewer inconsistencies and QC actions taken.
- Recommend resource changes or search-term refinement.
- Document assumptions and gaps with impact and mitigation.
Pitfalls
- Report only aggregate metrics — never disclose privileged content.
- If counts conflict, surface the discrepancy and state the suspected cause.
- Use U.S. discovery terminology; confirm local rules before external distribution.
- Mark uncertain legal citations with
[VERIFY].
- Keep narrative neutral and data-driven; avoid strategy conclusions.
- Always include: "Attorney Work Product / Privileged & Confidential. Internal use only."
1---2name: ediscovery-review-summary3description: Produces an internal U.S. litigation e-discovery status summary covering ESI collection, processing, search-term hits, review throughput, relevance and privilege rates, and completion forecasts. Triggers when the user requests an e-discovery status report, collection log summary, processing report, review statistics, coding report, search-term results, or privilege review summary.4---5
6# E-Discovery Collection & Review Summary
7
8Internal status report tracking ESI from collection through attorney review, with completion projections.
9
10## Prerequisites
11
12- Custodian list with collection scope (systems, date ranges, locations)
13- Collection logs and processing reports from vendor
14- Review platform exports (coding, reviewer activity, search-term results)
15- Search-term list or Boolean queries
16- Review protocol (relevance, privilege, issue tags) and QC standards
17- Key deadlines the review must meet
18- Protective order or confidentiality requirements for reporting
19
20## Quick Start
21
221. Gather source data (collection logs, processing reports, review exports, search-term results, privilege summaries).
232. Normalize custodian names into a master mapping table.
243. Run integrity checks — pipeline totals must satisfy: Collected ≥ Processed ≥ Loaded ≥ Reviewed.
254. Compute core metrics tables (see below).
265. Draft executive summary with risks and recommendations.
276. Apply work-product legend.
28
29## Core Metrics
30
31### A. Collection & Processing by Custodian
32
33Per custodian: Collected GB, Item Count, Processed %, Load Failures, File-Type Mix, Exceptions.
34
35### B. Search-Term Effectiveness
36
37Per term/query: Hits, Hit Rate %, Sample Precision %, Overlap %, Recommended Action.
38
39### C. Review Status (Matter-Level)
40
41Total Reviewable, Reviewed Count, % Reviewed, Relevant %, Privileged %, Non-Responsive %, Est. Completion Date.
42
43### D. Reviewer Productivity
44
45Per reviewer/team: Docs Reviewed, Hours, Docs/Hour, Relevant %, Privileged %, QC Rate %.
46
47### E. Privilege Patterns
48
49Per custodian: Privileged %, Dominant Doc Types, Red Flags.
50
51## Key Formulas
52
53| Metric | Formula |
54|---|---|
55| Hit Rate % | hits ÷ total reviewable corpus |
56| Precision % | relevant hits ÷ sampled hits |
57| Review Velocity | docs reviewed ÷ time period |
58| Completion ETA | remaining docs ÷ current velocity |
59| Privilege Rate % | privileged ÷ reviewed |
60
61## Executive Summary Template
62
63- **Collection completeness** — status and anomalies
64- **Processing health** — success rate and key errors
65- **Search-term performance** — top/weak terms and overlap
66- **Review progress** — reviewed %, relevance %, privilege %
67- **Forecast** — ETA with assumptions
68- **Risks & actions** — top three items
69
70## Integrity Checks
71
72- Custodian names align across all sources (master mapping table).
73- Pipeline totals are monotonically decreasing through each stage.
74- Every search term in the term list appears in the results export.
75- Coding records contain reviewer, date, relevance, and privilege fields.
76- Processing errors are reconciled against re-runs.
77
78## Findings & Recommendations
79
80- List missing sources and resulting limitations.
81- Flag custodians with outlier volumes or error rates.
82- Identify low-precision or high-overlap search terms.
83- Note reviewer inconsistencies and QC actions taken.
84- Recommend resource changes or search-term refinement.
85- Document assumptions and gaps with impact and mitigation.
86
87## Pitfalls
88
89- Report only aggregate metrics — never disclose privileged content.
90- If counts conflict, surface the discrepancy and state the suspected cause.
91- Use U.S. discovery terminology; confirm local rules before external distribution.
92- Mark uncertain legal citations with `[VERIFY]`.
93- Keep narrative neutral and data-driven; avoid strategy conclusions.
94- Always include: "Attorney Work Product / Privileged & Confidential. Internal use only."
95
96---
CaseMark