Build a systematic literature search tracking log

Create a structured PRISMA-ready protocol and tracking sheet for thesis literature reviews. Use this before starting database queries to ensure reproducible results.

You getSearch Strategy Blueprint, screening Log Architecture and inclusion/Exclusion Matrix

Prompt

Prompt
Act as an academic research librarian specializing in systematic reviews. Design a standardized literature search tracking protocol and audit log for a graduate thesis.

- Provide a tracking framework aligned with PRISMA documentation principles for reproducibility.
- Include fields for databases, Boolean strings, search limits, deduplication, and screening stages.
- Establish concrete inclusion and exclusion criteria templates to prevent screening drift over time.
- Keep instructions clear, precise, and practical for multi-week research projects.
- Fill each table with two sample rows on an example topic, low-cost water filtration in rural areas, so the layout is clear.

Output format:
- Search Strategy Blueprint: table layout showing fields required to record every query run.
- Screening Log Architecture: table columns for tracking articles from identification to final inclusion.
- Inclusion/Exclusion Matrix: 4 standard eligibility categories with selection rules.
- Verification Checklist: 4 essential checks to perform before freezing the search results.

Example output

Search Strategy Blueprint

Record each query in a master spreadsheet using these columns:

Log IDDate RunDatabaseFull Search String UsedFilters Applied (Years, Language)Raw Hits
S012024-03-04Scopus("clean water" OR "filtration") AND ("rural" OR "low-cost")2015-2024, English, Peer-reviewed342
S022024-03-05Web of Science("ceramic filter" OR "clay membrane") AND ("pathogen")2015-2024, English, Articles188
Screening Log Architecture

Track collected citations across screening phases:

Citation KeyTitleFirst AuthorYearDuplicate? (Y/N)Title/Abstract Screen (Pass/Fail)Full-Text Screen (Pass/Fail)Exclusion Reason
Smith2021Ceramic disc water purification...Smith, J.2021NPassPassIncluded in final synthesis
Miller2019Industrial municipal wastewater...Miller, R.2019NPassFailWrong setting (industrial plant)
Inclusion/Exclusion Matrix
  • Study Design: Include randomized trials, field interventions, and lab-bench tests; exclude opinion editorials, book reviews, and patent applications.
  • Population / Setting: Include low-resource, off-grid, or decentralized communities; exclude centralized municipal treatment plants.
  • Intervention: Include point-of-use or decentralized physical filtration; exclude chemical-only chlorination without physical filters.
  • Timeframe & Language: Include peer-reviewed articles published in English between January 2014 and the search date.
Verification Checklist
  • Export and save full search histories directly from each database platform as backup documentation.
  • Run automated deduplication in your reference manager, followed by a manual check of identical titles with varied author punctuation.
  • Test your Boolean string against a benchmark set of 3 known landmark papers to verify they appear in the raw hit count.
  • Document the final search date across all databases to establish the clear eligibility cutoff point for your methodology chapter.
Written by AI from this prompt. Your results will vary.

Copy and paste this prompt directly into ChatGPT, Claude, or Gemini. The sample rows use a water filtration topic only to show the layout. After reviewing the tables, follow up by naming your own topic and asking the model to draft Boolean strings for PubMed, Scopus, or Web of Science.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Academic Writing & Study
Academic Writing & Study

Prepare for tough thesis defense questions

Pressure-test your thesis manuscript against skeptical committee members before your defense. Uncover methodology flaws, scope issues, and hidden assumptions.