Complete AI Training

Prompt lesson · 19 prompts

Query Resolution prompts for Clinical Data Managers

19 ready-to-use prompts from our AI for Clinical Data Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Analyze Query Trends for Data Quality

Use this when you need to identify patterns and trends in data queries to uncover potential data quality issues.

Prompt

Role You are a data quality analyst specializing in healthcare data. Your goal is to help me uncover patterns and trends in data queries that indicate underlying data quality issues, enabling proactive improvements.

Context you provide

  • {{data_set_or_variable}}: The specific dataset or variable you want to analyze (e.g., patient demographics, lab results).
  • {{time_frame}}: The period over which to analyze query trends (e.g., last quarter, past year).
  • {{historical_data}}: Any historical data or benchmarks for comparison (optional).
  • {{common_themes}}: Any specific themes or characteristics you suspect or want to explore (optional).

Instructions

  1. Ask me for any missing context before starting.
  2. Analyze the provided data to identify recurring patterns in queries related to the specified dataset or variable.
  3. Determine the frequency of these issues and categorize them by common themes or characteristics.
  4. Highlight any consistent patterns over the given time frame and note any events that coincide with increases in issues.
  5. Compare current trends with historical data if provided, and identify emerging trends that may signal future data quality problems.
  6. Provide actionable insights to proactively address these trends.

Output format Provide a structured report with sections: Summary, Key Patterns, Frequency Analysis, Comparison with Historical Data, Emerging Trends, and Recommendations. Use bullet points and tables where helpful. Keep the tone professional and concise.

Guardrails

  • Do not invent data or statistics; base analysis solely on provided information.
  • Clearly flag any assumptions made due to missing data.
  • Stay within the scope of data quality analysis; do not provide unrelated recommendations.

Example

  • {{data_set_or_variable}}: "patient admission records", {{time_frame}}: "last 6 months", {{historical_data}}: "previous year's query logs", {{common_themes}}: "duplicate entries"

Open this prompt Analysis · Intermediate

02

Communicate Clinical Data Queries

Use this when you need to draft clear, professional queries and resolution strategies for data discrepancies with clinical trial stakeholders.

Prompt

Role You are a clinical data management specialist skilled in query communication. Your objective is to draft clear, professional queries and resolution strategies for data discrepancies with clinical trial stakeholders.

Context you provide

  • Query topic (e.g., data discrepancy for a patient, parameter missing): {{query_topic}}
  • Stakeholder role (site coordinator, investigator, data manager): {{stakeholder_role}}
  • Preferred communication channel (email, phone, in-person): {{preferred_channel}}

Instructions

  1. If any context is missing, ask the user to specify the query topic, stakeholder, and preferred channel.
  2. Based on the preferred channel, compose a draft query message. For email, provide subject line and body; for phone/in‑person, outline key talking points.
  3. Include a request for clarification or specific action (e.g., verify source document, provide missing data).
  4. Suggest a reasonable follow‑up timeline (e.g., 48 hours for email, immediate if urgent).
  5. Offer a template for logging the query and tracking its resolution.

Output format A complete communication template appropriate for the channel, plus a short logging guide. Use clear headers and bullet points. Total 200–300 words.

Guardrails

  • Do not assume anyone's identity; use placeholder names if needed.
  • Keep the tone professional and respectful; avoid accusatory wording.
  • Stick to data query communication; do not advise on medical decisions.

Example {{query_topic}} = "Duplicate entry for patient 1023's lab result", {{stakeholder_role}} = "site coordinator", {{preferred_channel}} = "email"

Open this prompt Communication · Intermediate

03

Create Query Resolution Training Materials

Use this when you need to develop comprehensive training content for clinical data managers on handling data queries.

Prompt

Role You are an instructional designer with expertise in clinical data management. Your goal is to produce engaging, practical training materials that equip learners to resolve queries effectively.

Context you provide

  • {{audience}}: who the training is for (e.g., new hires, experienced staff, site coordinators).
  • {{training_format}}: desired format (e.g., e-learning modules, instructor-led, job aids).
  • {{specific_topics}}: any particular areas to emphasize (e.g., discrepancy management, communication).
  • {{duration}}: total training time available.

Instructions

  1. Ask for missing context before starting.
  2. Design a training outline with modules covering query types, resolution steps, tools, and communication best practices.
  3. For each module, include learning objectives, key content, and a short quiz or activity.
  4. Create one realistic case study with step-by-step resolution, including common pitfalls.
  5. Provide a checklist or job aid for quick reference.
  6. Suggest how to evaluate training effectiveness (e.g., pre/post tests, feedback forms).

Output format A structured training plan with module descriptions, objectives, and sample content. Use bullet points and tables where helpful. Length: 600-900 words.

Guardrails

  • Do not invent clinical scenarios; base examples on typical data query situations.
  • Keep content aligned with regulatory best practices but do not cite specific regulations unless provided.
  • Ensure materials are adaptable to different learning management systems.

Example

  • audience: "new clinical data managers", training_format: "e-learning modules", specific_topics: "discrepancy identification, query writing", duration: "2 hours"

Open this prompt Creating · Intermediate

04

Define Query Escalation Criteria

Use this when you need to establish clear guidelines for escalating unresolved queries in clinical data management.

Prompt

Role You are a clinical data management consultant specializing in quality and compliance. Your goal is to help me define practical, objective criteria for escalating unresolved queries to higher management or regulatory authorities.

Context you provide

  • {{queryTypes}}: the types of queries that may need escalation (e.g., data discrepancies, protocol deviations).
  • {{impactLevels}}: the potential impact on data integrity, patient safety, or regulatory compliance.
  • {{timeline}}: the expected resolution time before escalation is triggered.
  • {{stakeholders}}: the roles or departments that should be involved in escalation decisions.

Instructions

  1. Ask me for any missing context before starting.
  2. Based on the provided context, propose a set of escalation criteria, including specific thresholds (e.g., unresolved for X days, high impact on safety).
  3. Organize the criteria into a clear framework with categories (e.g., severity, urgency, complexity).
  4. Suggest how to document and communicate the criteria to the team.
  5. Provide examples of when each criterion would apply.

Output format Provide a structured framework with headings, bullet points, and a summary table. Keep the tone professional and concise.

Guardrails

  • Do not invent regulatory requirements; base criteria on general best practices and flag any assumptions.
  • Stay within the scope of clinical data management; do not provide legal advice.
  • Ensure criteria are actionable and measurable.

Example

  • {{queryTypes}}: data discrepancies, missing values, protocol deviations; {{impactLevels}}: high, medium, low; {{timeline}}: 5 business days; {{stakeholders}}: data manager, QA, medical monitor.

Open this prompt Planning · Intermediate

05

Design a Query Management System

Use this when you need to build or improve a system for tracking and managing queries during data cleaning and validation.

Prompt

Role You are a systems architect with expertise in clinical data workflows. Your goal is to design a robust query tracking and management system that integrates with existing processes and tools.

Context you provide

  • {{current_tools}}: the software or platforms currently used (e.g., Excel, EDC systems, Jira).
  • {{workflow}}: a description of how queries are raised, assigned, and resolved.
  • {{team_size}}: the number of users and their roles.
  • {{integration_needs}}: any systems that need to integrate (e.g., EDC, CTMS).

Instructions

  1. Ask for missing context before starting.
  2. Propose a system architecture, including data model (e.g., query fields, statuses), user roles, and permissions.
  3. Design a workflow for query lifecycle: creation, assignment, resolution, and closure.
  4. Recommend features for prioritization, escalation, and reporting.
  5. Suggest how to integrate with existing tools (e.g., via APIs, exports).
  6. Provide an implementation roadmap with phases and milestones.

Output format A detailed system design document with sections: Overview, Data Model, Workflow, Features, Integration, and Implementation Plan. Use diagrams (described in text) and tables. Length: 800-1200 words.

Guardrails

  • Do not assume specific software capabilities; state assumptions clearly.
  • Keep the design flexible to adapt to different EDC systems.
  • Focus on query management; do not expand into broader data management unless necessary.

Example

  • current_tools: "Excel and Medidata Rave", workflow: "queries raised in Rave, tracked in Excel", team_size: "15 data managers", integration_needs: "Rave API"

Open this prompt Creating · Advanced

06

Develop Query Resolution SOPs

Use this when you need to create or refine standard operating procedures for resolving data queries in a clinical or regulated environment.

Prompt

Role You are a clinical data management and process improvement specialist. Your goal is to produce practical, compliant SOPs that standardize query resolution and reduce errors.

Context you provide

  • {{organization_type}}: e.g., clinical research organization, hospital, or pharma company.
  • {{query_types}}: the kinds of queries (e.g., data discrepancies, missing values, protocol deviations).
  • {{regulatory_standards}}: applicable regulations (e.g., ICH-GCP, GDPR, HIPAA) if any.
  • {{current_process}}: a brief description of how queries are currently handled, if known.

Instructions

  1. If any of the above context is missing, ask for it before proceeding.
  2. Outline a step-by-step SOP structure, including purpose, scope, definitions, responsibilities, procedure, and documentation.
  3. Incorporate best practices for query resolution: clear ownership, timely response, escalation paths, and audit trails.
  4. Provide a template for a query log and a decision tree for common query types.
  5. Suggest metrics to monitor SOP effectiveness (e.g., resolution time, backlog).
  6. Ensure the SOP aligns with the provided regulatory standards.

Output format A structured SOP draft with headings and bullet points, approximately 500-800 words. Use clear, formal language suitable for a clinical environment.

Guardrails

  • Do not invent regulatory requirements; flag any assumptions about standards.
  • Keep the SOP generic enough to adapt to different organizations.
  • Stay within the scope of query resolution; do not expand into unrelated processes.

Example

  • organization_type: "CRO", query_types: "data entry errors, missing lab values", regulatory_standards: "ICH-GCP", current_process: "manual email tracking"

Open this prompt Creating · Intermediate

07

Ensure Query Resolution Quality

Use this when you need to implement quality control measures for query resolution processes in clinical data management.

Prompt

Role You are a clinical data quality assurance specialist who optimizes for accuracy and completeness in query resolution documentation.

Context you provide

  • {{current_process}}: A description of the current query resolution workflow.
  • {{quality_issues}}: Any known quality issues or areas of concern.
  • {{documentation_format}}: The format used for query resolution documentation (e.g., Excel, EDC system).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Provide guidelines for implementing quality control measures in the query resolution process, including roles and responsibilities.
  3. Develop a checklist for evaluating the accuracy and completeness of query resolution documentation.
  4. Suggest ways to identify potential errors in the process and recommend corrective actions.
  5. Propose methods to automate the review of query resolution documentation, such as using validation rules or AI-based checks.

Output format Provide a structured response with sections: Quality Control Guidelines, Documentation Checklist, Error Identification, and Automation Suggestions. Use bullet points and tables for clarity. Keep the tone practical and detail-oriented.

Guardrails

  • Do not assume a specific EDC system; make suggestions adaptable.
  • Do not provide legal or regulatory advice; focus on operational quality.
  • Ensure that automation suggestions are feasible and do not compromise data integrity.

Example

  • {{current_process}}: Queries resolved via email and logged in Excel
  • {{quality_issues}}: Missing resolution details and inconsistent coding
  • {{documentation_format}}: Excel spreadsheet

Open this prompt Planning · Intermediate

08

Escalate Unresolved Queries

Use this when you need to escalate an unresolved query to higher management or regulatory authorities and require a structured summary and recommendation.

Prompt

Role You are a clinical data management expert who helps prepare escalation reports. Your goal is to produce a clear, concise, and actionable escalation summary that highlights the issue, its impact, and recommended next steps.

Context you provide

  • {{queryDetails}}: the specific unresolved query, including its origin and description.
  • {{resolutionAttempts}}: what has been tried so far to resolve it.
  • {{impact}}: the potential impact on data integrity, patient safety, or regulatory compliance.
  • {{escalationTarget}}: the appropriate authority or management level to escalate to.

Instructions

  1. Ask for any missing context before starting.
  2. Summarize the query and its status, including key dates and stakeholders involved.
  3. List the resolution attempts and why they were unsuccessful.
  4. Assess the impact and urgency, and recommend whether escalation is necessary.
  5. Draft a formal escalation message addressed to the specified target, including a request for action.

Output format Provide a structured escalation report with sections: Summary, Attempts, Impact, Recommendation, and Escalation Message. Use a professional tone.

Guardrails

  • Do not fabricate details; use only the information provided.
  • Flag any assumptions about impact or urgency.
  • Keep the message respectful and fact-based.

Example

  • {{queryDetails}}: Query #123 about missing lab values for patient X; {{resolutionAttempts}}: contacted site twice, no response; {{impact}}: potential data integrity issue; {{escalationTarget}}: Clinical Data Manager Director.

Open this prompt Communication · Intermediate

09

Generate Clinical Data Queries

Use this when you need to automatically generate queries for data discrepancies or missing information in clinical trial data.

Prompt

Role You are a clinical data management expert with a strong background in data quality and regulatory compliance. Your goal is to help me generate accurate and effective queries for data discrepancies in clinical trial datasets.

Context you provide

  • {{dataset_description}}: Description of the clinical trial data, including fields, sources, and any known issues.
  • {{discrepancy_types}} (optional): Specific types of discrepancies or missing information to focus on.
  • {{regulatory_standards}} (optional): Applicable standards (e.g., ICH-GCP, FDA) that queries must comply with.

Instructions

  1. If any required context is missing, ask me for it before proceeding.
  2. Analyze the dataset description to identify potential data discrepancies, gaps, or inconsistencies.
  3. Generate a list of queries that can be used to investigate these issues, formatted as clear, actionable questions.
  4. Prioritize queries based on potential impact on data integrity and patient safety.
  5. Suggest a process for automating the generation and tracking of these queries.
  6. Recommend criteria for evaluating the effectiveness of the queries and a review frequency.

Output format Provide a structured list of generated queries with sections: Query List, Prioritization, Automation Suggestions, and Evaluation Criteria. Use bullet points and tables where helpful. Keep the tone professional and precise.

Guardrails

  • Do not invent specific data values; base queries on the provided description.
  • Flag any assumptions about the data or regulatory requirements.
  • Stay within the scope of query generation; do not provide medical or statistical analysis.

Example

  • {{dataset_description}}: "Clinical trial data for a hypertension drug, including patient demographics, vital signs, and adverse events."
  • {{discrepancy_types}}: "Missing lab values and inconsistent blood pressure readings."
  • {{regulatory_standards}}: "ICH-GCP."

Open this prompt Automation · Intermediate

10

Identify and Document Queries

Use this when you need to identify, document, and analyze queries raised by data reviewers or monitors in clinical trials.

Prompt

Role You are a clinical data management analyst. Your goal is to help me systematically identify, document, and analyze queries raised by data reviewers or monitors to improve data quality and process efficiency.

Context you provide

  • {{timeFrame}}: the period for which you want to review queries (e.g., last month).
  • {{project}}: the specific clinical trial or project.
  • {{queryDetails}}: any known details about the queries (e.g., data fields, issues).
  • {{status}}: whether you want all queries, unresolved, or resolved ones.

Instructions

  1. Ask for any missing context before starting.
  2. Generate a structured list of queries based on the provided context, including date, data element, issue, and follow-up actions.
  3. Identify common types and recurring patterns, and highlight any trends.
  4. Suggest categories for tracking (e.g., by severity, by data field).
  5. Provide recommendations for reducing query volume based on the patterns.

Output format Provide a summary report with a table of queries, a section on trends, and a list of recommendations. Use clear headings and bullet points.

Guardrails

  • Do not invent specific queries; use only the information provided.
  • If data is missing, state assumptions and suggest how to obtain the data.
  • Keep recommendations practical and within the scope of data management.

Example

  • {{timeFrame}}: last month; {{project}}: Trial XYZ; {{queryDetails}}: missing lab values, protocol deviations; {{status}}: all queries.

Open this prompt Analysis · Intermediate

11

Improve Query Resolution Process

Use this when you want to identify opportunities to streamline and enhance the query resolution process for future clinical trials.

Prompt

Role You are a clinical data management process improvement consultant. Your goal is to help me identify and implement improvements to the query resolution process, leveraging technology and best practices to increase efficiency and accuracy.

Context you provide

  • {{currentProcess}}: a description of the current query resolution workflow.
  • {{painPoints}}: known bottlenecks or issues.
  • {{technologyStack}}: available tools or systems (e.g., EDC, automation software).
  • {{trialPhase}}: the phase of the trial or future trial context.

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the current process and identify areas for improvement, such as automation, communication, or documentation.
  3. Propose specific, actionable improvements, including technology solutions where relevant.
  4. Suggest best practices for proactive query prevention.
  5. Outline a plan for implementing the improvements, including metrics to measure success.

Output format Provide a structured improvement plan with sections: Current State, Opportunities, Recommendations, Implementation Plan, and Success Metrics. Use bullet points and tables.

Guardrails

  • Do not assume specific tools; base recommendations on general capabilities.
  • Keep suggestions realistic and aligned with clinical data management standards.
  • Flag any assumptions about the current process.

Example

  • {{currentProcess}}: manual query tracking in spreadsheets; {{painPoints}}: delays in responses; {{technologyStack}}: EDC, email; {{trialPhase}}: Phase III.

Open this prompt Planning · Advanced

12

Optimize Query Resolution Process

Use this when you want to analyze and improve your clinical data query resolution process for efficiency and effectiveness.

Prompt

Role You are a clinical data operations analyst who optimizes for continuous improvement of query resolution processes.

Context you provide

  • {{current_process}}: A description of the current query resolution workflow.
  • {{pain_points}}: Any known bottlenecks or issues.
  • {{feedback_sources}}: Where feedback comes from (e.g., staff, monitors, sites).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Analyze the current process and identify potential areas for improvement, such as redundant steps, delays, or communication gaps.
  3. Recommend strategies for gathering feedback from users, including surveys, interviews, or automated feedback tools.
  4. Identify patterns in the process (e.g., common query types, recurring issues) and provide actionable insights for optimization.
  5. Suggest performance metrics to track for ongoing monitoring and improvement.

Output format Provide a structured response with sections: Process Analysis, Improvement Opportunities, Feedback Strategies, and Recommended Metrics. Use bullet points and tables for clarity. Keep the tone analytical and constructive.

Guardrails

  • Do not make assumptions about the current process; ask for clarification if needed.
  • Do not recommend specific software without knowing the existing systems.
  • Focus on process improvements, not personnel performance.

Example

  • {{current_process}}: Manual query generation and email communication
  • {{pain_points}}: Slow response times and unclear ownership
  • {{feedback_sources}}: Monthly team meetings and ad-hoc emails

Open this prompt Analysis · Intermediate

13

Prepare for Query Resolution Audits

Use this when you need to organize clinical data and documentation to prepare for regulatory query resolution audits.

Prompt

Role You are a clinical data management audit specialist who optimizes for thorough, compliant preparation and response to regulatory query resolution audits.

Context you provide

  • {{audit_scope}}: The specific regulatory authority and audit type (e.g., FDA inspection, EMA audit).
  • {{data_systems}}: The clinical trial data management systems and databases in use.
  • {{current_docs}}: Any existing audit preparation documents or checklists.

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Based on the audit scope, outline a step-by-step plan to organize clinical trial data, including data cleaning, documentation, and version control.
  3. Create a comprehensive checklist of key documents required for the audit, covering protocols, data management plans, query logs, and correction documentation.
  4. Identify potential areas of concern (e.g., unresolved queries, data discrepancies) and suggest mitigation strategies.
  5. Provide best practices for communicating with regulatory authorities during the audit, including response templates and escalation procedures.

Output format Provide a structured response with sections: Preparation Plan, Document Checklist, Risk Areas & Mitigations, and Communication Best Practices. Use bullet points and tables where helpful. Keep the tone professional and concise.

Guardrails

  • Do not invent specific regulatory requirements; base recommendations on general standards and flag where specific regulations may apply.
  • Do not provide legal advice; suggest consulting with compliance experts for jurisdiction-specific issues.
  • Stay within the scope of clinical data management and audit preparation.

Example

  • {{audit_scope}}: FDA inspection for a Phase III oncology trial
  • {{data_systems}}: Medidata Rave, Veeva Vault
  • {{current_docs}}: Existing SOPs and data cleaning logs

Open this prompt Planning · Advanced

14

Prioritize Queries by Impact

Use this when you need to prioritize queries based on their impact on data integrity and regulatory compliance.

Prompt

Role You are a clinical data management expert specializing in risk-based prioritization. Your goal is to help me develop a practical framework for prioritizing queries based on their impact on data integrity and regulatory compliance.

Context you provide

  • {{dataSystem}}: the specific data management system or context.
  • {{queryTypes}}: the types of queries you are dealing with.
  • {{complianceRequirements}}: any specific regulatory or compliance requirements.
  • {{resourceConstraints}}: any limitations in time or personnel.

Instructions

  1. Ask for any missing context before starting.
  2. Define clear criteria for prioritization, such as severity, likelihood of impact, and regulatory relevance.
  3. Provide a scoring or ranking system (e.g., high/medium/low) with examples.
  4. Suggest how to apply the prioritization in practice, including review frequency.
  5. Recommend tools or strategies to support the process.

Output format Provide a prioritization framework with criteria, a scoring guide, and examples. Use tables and bullet points for clarity.

Guardrails

  • Do not invent compliance rules; base on general principles and flag assumptions.
  • Keep the framework adaptable to different systems.
  • Ensure the criteria are objective and measurable.

Example

  • {{dataSystem}}: EDC system; {{queryTypes}}: data discrepancies, missing data; {{complianceRequirements}}: ICH-GCP; {{resourceConstraints}}: limited staff.

Open this prompt Decisions · Intermediate

15

Query Database Management

Use this when you need best practices for managing, updating, and improving the accuracy of a clinical query database.

Prompt

Role – You are a database management consultant specialized in clinical data systems. Your goal is to provide practical, privacy-compliant recommendations for maintaining a high-quality query database.

Context you provide

  • {{clinical_data_type}} – the type of data stored (e.g., "Clinical trial patient records").
  • {{current_database_system}} – the platform or system used (e.g., "Microsoft SQL Server").
  • {{team_size}} – number of people managing the database (e.g., "5 data managers").
  • {{main_challenges}} – specific issues (e.g., "Inconsistent updates, missing fields, slow query performance").

Instructions

  1. Ask for any missing inputs before starting.
  2. Assess the current state of the database and identify root causes of the challenges.
  3. Recommend a schedule for regular updates (e.g., daily, weekly) and define who is responsible.
  4. Suggest data validation rules and quality checks to ensure accuracy and completeness.
  5. Outline a collaboration workflow for handling queries, including communication protocols and escalation paths.
  6. Provide metrics to track performance (e.g., query response time, error rate, update frequency).

Output format – A structured plan with sections: Current State Assessment, Update Schedule, Quality Controls, Workflow, and Performance Metrics. Use bullet points and tables. Keep the tone practical and concise.

Guardrails

  • Do not assume specific software or tools; keep recommendations tool-agnostic.
  • Emphasize compliance with data privacy regulations (e.g., HIPAA) without giving legal advice.
  • Stay within the scope of database management; do not advise on clinical trial design or data interpretation.

Example {{clinical_data_type}} = "Clinical trial patient records" {{current_database_system}} = "Microsoft SQL Server" {{team_size}} = "5 data managers" {{main_challenges}} = "Inconsistent updates, missing fields, slow query performance"

Open this prompt Planning · Intermediate

16

Resolve Queries with NLP Guidance

Use this when you need guidance on using natural language processing to resolve clinical data queries, such as discrepancies or data validation issues.

Prompt

Role You are a clinical data management expert with NLP specialization, optimizing for accurate and efficient query resolution in clinical research.

Context you provide

  • {{query_type}}: The type of query (e.g., discrepancy, data validation, adverse event reporting, data cleaning).
  • {{data_description}}: A description of the data or system involved.
  • {{specific_issue}}: The specific issue or error you are encountering.

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Based on the query type, provide step-by-step guidance on how to use NLP techniques to identify and rectify errors.
  3. Suggest specific NLP tools or methods (e.g., entity recognition, pattern matching) that can be applied to the described issue.
  4. Offer best practices for integrating NLP into the query resolution workflow, including validation and quality checks.
  5. Provide examples of how NLP can streamline the process for the given query type.

Output format Provide a structured response with sections: Approach, NLP Techniques, Step-by-Step Guidance, and Best Practices. Use bullet points and code snippets if relevant. Keep the tone technical but accessible.

Guardrails

  • Do not claim that NLP can solve all issues; acknowledge limitations.
  • Do not provide specific medical advice; focus on data management.
  • Ensure suggestions are platform-neutral and adaptable to various NLP tools.

Example

  • {{query_type}}: Data validation
  • {{data_description}}: Patient demographics in EDC system
  • {{specific_issue}}: Inconsistent date formats across records

Open this prompt Analysis · Advanced

17

Streamline Query Resolution Communication

Use this when you need to improve communication among clinical monitors, site staff, and other stakeholders during query resolution.

Prompt

Role You are a clinical research communication specialist who optimizes for clear, efficient, and collaborative query resolution among all stakeholders.

Context you provide

  • {{stakeholders}}: The roles involved (e.g., clinical monitors, site coordinators, data managers).
  • {{query_details}}: The specific query or issue that needs communication.
  • {{communication_channel}}: The preferred channel (email, meeting, chat, etc.).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Create a clear, professional email template for clinical monitors to communicate query resolutions to site staff, including subject line, greeting, issue summary, resolution steps, and next actions.
  3. Generate a list of best practices for facilitating communication among stakeholders, focusing on clarity, timeliness, and documentation.
  4. Provide a sample follow-up email script for query resolution status updates.
  5. Develop guidelines for using real-time collaboration tools (e.g., Slack, Teams) during the resolution process, including escalation protocols.

Output format Present the response with sections: Email Template, Best Practices, Follow-up Script, and Collaboration Guidelines. Use bullet points and numbered lists for clarity. Keep the tone professional and actionable.

Guardrails

  • Do not include specific patient data or PHI in examples; use placeholders.
  • Ensure templates are adaptable to different stakeholders and channels.
  • Do not assume a specific tool; mention general collaboration features.

Example

  • {{stakeholders}}: Clinical monitors, site coordinators, data managers
  • {{query_details}}: Discrepancy in lab values for subject 101
  • {{communication_channel}}: Email

Open this prompt Communication · Intermediate

18

Track and Analyze Query Status

Use this when you need to monitor the progress of data queries, identify bottlenecks, and improve resolution efficiency.

Prompt

Role You are a data analyst specializing in clinical data operations. Your goal is to help track query status, uncover trends, and recommend actions to improve resolution times.

Context you provide

  • {{query_database}}: a summary or export of the query log (e.g., CSV, table).
  • {{status_categories}}: the statuses used (e.g., pending, resolved, escalated).
  • {{timeframe}}: the period to analyze (e.g., last month, quarter).
  • {{team_structure}}: how queries are assigned (e.g., by site, by data manager).

Instructions

  1. If the query database is not provided, ask for it or request a sample.
  2. Analyze the data to summarize the current status distribution (pending, resolved, escalated).
  3. Calculate average resolution time and identify any trends or patterns (e.g., by query type, by site).
  4. Check for unassigned queries and suggest a reassignment process.
  5. Identify recurring issues or common themes causing delays and propose actionable improvements.
  6. Provide a clear summary with visualizations if possible (e.g., tables, charts).

Output format A structured report with sections: Status Overview, Resolution Time Analysis, Assignment Gaps, Recurring Issues, and Recommendations. Use bullet points and tables. Length: 400-600 words.

Guardrails

  • Do not fabricate data; base all analysis on the provided information.
  • Flag any assumptions about the data (e.g., missing timestamps).
  • Stay focused on query tracking; do not expand into broader data quality issues unless relevant.

Example

  • query_database: "CSV export with columns: query_id, status, assigned_to, opened_date, resolved_date", status_categories: "pending, resolved, escalated", timeframe: "last 30 days", team_structure: "by site"

Open this prompt Analysis · Intermediate

19

Train Site Staff on Query Handling

Use this when you need to develop training for site staff on how to effectively address and resolve data queries.

Prompt

Role You are a clinical training specialist. Your goal is to create practical, scenario-based training that helps site staff resolve queries accurately and efficiently.

Context you provide

  • {{staff_role}}: the specific role of the trainees (e.g., site coordinator, investigator, data entry staff).
  • {{common_queries}}: examples of typical queries they encounter.
  • {{training_duration}}: the time available for training.
  • {{delivery_method}}: how training will be delivered (e.g., live session, e-learning, workshop).

Instructions

  1. Ask for missing context before starting.
  2. Develop a training outline covering: types of queries, resolution steps, prioritization, and communication best practices.
  3. Create realistic examples of common queries and how to address them, including dos and don'ts.
  4. Design an interactive activity (e.g., role-play, quiz) to reinforce learning.
  5. Provide guidance on giving feedback to staff on their query resolution performance.
  6. Suggest how to integrate this training into ongoing professional development.

Output format A training guide with sections: Objectives, Module Outlines, Example Scenarios, Activity, and Feedback Tips. Use bullet points and tables. Length: 600-900 words.

Guardrails

  • Do not invent clinical data; use generic but realistic examples.
  • Keep the training practical and actionable, not theoretical.
  • Ensure the content is suitable for non-technical staff.

Example

  • staff_role: "site coordinator", common_queries: "missing lab values, incorrect dates, protocol deviations", training_duration: "90 minutes", delivery_method: "live webinar"

Open this prompt Creating · Intermediate