Clinical Research Salesforce Workflow Audit

An outside eye on
your clinical research
Salesforce build.

An independent review of your existing Salesforce implementation across all five stages — from RFP/Protocol and feasibility through study startup, patient recruitment, and enrollment visibility. Is it built correctly? Is it scalable? Are there gaps costing you timeline? This answers all three.

Five-stage review — feasibility through enrollment
Specific object and field-level gap analysis
AI-readiness score per stage (0–100)
30-day prioritized improvement roadmap
Built from nearly 5 years inside a global decentralized research site network
No Salesforce access required — intake form captures everything
Clinical Research Salesforce Workflow Audit
$2,500
Flat fee · 48–72 hour delivery after intake
Book a Discovery Call →
48–72
hour report delivery after intake
5
stages reviewed in depth
What's included
  • Stage-by-stage intake questionnaire
  • Five-stage lifecycle architecture review
  • Object & field-level gap analysis
  • Regulatory and startup workflow assessment
  • Recruitment and enrollment visibility review
  • AI-readiness score per stage
  • 30-day prioritized improvement roadmap
  • 60-min executive review call
Audit credit. Fee credited in full toward any advisory engagement started within 14 days of delivery.
4.5
years building these systems inside a global decentralized research site network
5
stages reviewed — RFP/Protocol through enrollment
48hr
report delivery after intake completion
$0
vendor commissions — fully independent

Ten specific deliverables.
Specific to your intake data.

Every deliverable is produced from your intake responses — not from a generic template. The recommendations map directly to the five stages of your clinical research Salesforce implementation.

📋

Five-Stage Intake Questionnaire

Structured questions mapped to each of the five stages — from feasibility survey architecture through enrollment visibility. Takes ~25 minutes. No Salesforce access required.

Day 0
🔍

Current-State Architecture Review

Review of your existing Salesforce configuration across all five stages — objects, fields, relationships, workflow rules, flows, and reports — mapped against clinical research best practices.

In report
🏗️

Stage-by-Stage Gap Analysis

Gaps identified at each stage — Opportunity & Feasibility, Site Selection, Study Startup & Regulatory, Patient Recruitment, and Screening & Enrollment. Ranked by operational impact.

Core deliverable
📁

Object & Field Recommendations

Specific recommendations for Clinical Study object design, Site Profile structure, Study-Site Junction, Site Tracker, Vendor Services Request and Engagement objects, Physician & Site Sales pipeline, and Enrollment Dashboard.

Technical output

Automation Opportunity Map

Stage-by-stage identification of where flow automation, record-triggered processes, and notification logic will remove the most manual steps — prioritized by time savings and go-live impact.

Operational output
💰

Revenue & ACV Calculation Review

Assessment of current ACV calculation logic, per-patient fee tracking, site count modeling, and enrollment projection accuracy. Recommendations for a defensible clinical trial revenue model in Salesforce.

RevOps output
🤖

AI-Readiness Score Per Stage

A 0–100 score for each of the five stages assessing data structure quality, naming standardization, and readiness for AI applications — site matching, enrollment forecasting, IRB timeline prediction.

Future-state output
🗺️

30-Day Prioritized Roadmap

A specific action plan tied to your most urgent go-live pressure. Tasks, owners, and sequencing — not a strategy deck. Your Admin can start executing this the day after the review call.

Primary deliverable
📊

Audit Scorecard

A visual scorecard across three dimensions — Architecture, Operational Efficiency, and AI-Readiness — that makes the gap concrete and measurable. Shareable with your COO or VP to build the business case for the fix.

Executive artifact
📞

60-Minute Executive Review Call

Structured debrief walking through every stage finding, the prioritized roadmap, and ROI projections. Natural transition to discussing advisory or implementation support if needed.

Day 5–7

Questions mapped to
all five stages.

The intake form is what makes the 48–72 hour delivery possible. Every question is designed to surface a specific gap or confirm a specific capability across the five stages of your clinical research Salesforce build.

01
Opportunity & Feasibility
Weeks 1–2 · RFP/Protocol intake through feasibility survey
1.1
RFP / Protocol IntakeHow are new study RFPs or protocol synopses currently entered into Salesforce? Manual entry, email to Admin, or automated from another system?
1.2
CDA TrackingHow is CDA exchange tracked? Is there a dedicated field or object, or is it noted in activity history / Opportunity description?
1.3
Feasibility SurveyIs the feasibility survey managed inside Salesforce? If not — where does it currently live (email, Excel, external tool)?
1.4
Complexity ScoringDoes the Opportunity record have a complexity score or weighted rating that factors in protocol difficulty, site count, therapeutic area, and enrollment targets?
1.5
ACV CalculationHow is ACV or study revenue currently calculated in Salesforce? Is it a formula field, manually entered, or tracked in a spreadsheet outside Salesforce?
02
Site Selection & Qualification
Weeks 3–5 · SSV through PI commitment
2.1
Site ObjectDo you have a dedicated Site object (or structured Account) in Salesforce that tracks site infrastructure, therapeutic area experience, staff capacity, and historical performance?
2.2
SSV TrackingHow is the Site Selection Visit (SSV) tracked — date, type (remote/in-person), outcome, and follow-up actions? Is this in a Salesforce object or in notes/email?
2.3
PI ManagementHow are Principal Investigators tracked? Is the PI's availability confirmation, CV status, GCP certification date, and therapeutic area experience in Salesforce?
2.4
Study-Site RelationshipIs there a junction object or relationship record connecting a Study to its selected Sites — with individual status, scoring, and milestone tracking per site per study?
2.5
Site Qualification ScorecardIs there a composite qualification score per site that factors in infrastructure rating, PI commitment, and patient database size — or is site selection a judgment call with no structured scoring in Salesforce?
03
Study Startup & Regulatory
Weeks 6–10 · CTA through SIV and Greenlight
3.1
CTA TrackingHow is the Clinical Trial Agreement tracked in Salesforce — negotiation status, execution date, budget version, and amendment history? Or does this live in a contract management tool outside Salesforce?
3.2
Regulatory PacketIs there a Regulatory Packet object or checklist in Salesforce that tracks Form 1572, CV, financial disclosure, and other required document status per site — with flags for missing or expired items?
3.3
IRB / IEC SubmissionHow is IRB or IEC submission and approval tracked in Salesforce? Submission date, approval date, expiry, and amendment history — or is this managed in email and an external document system?
3.4
SIV MilestoneIs the Site Initiation Visit (SIV) tracked as a Salesforce milestone with scheduled date, completed date, and training attestation — or is it recorded in notes or an external project management tool?
3.5
Greenlight TrackingIs Site Greenlight Percentage — activated sites divided by total selected sites — calculated automatically in Salesforce and visible on a real-time dashboard? Or does leadership get this via manual status report?
3.6
Spreadsheet CountHow many external spreadsheets does your startup team currently use to track processes that should be in Salesforce? Name the top three if possible.
04
Patient Recruitment & Pre-Screening
Ongoing from site activation
4.1
Recruitment Campaign TrackingAre patient recruitment strategies and campaigns tracked in Salesforce — strategy type, channel, launch date, leads generated, and cost per qualified referral? Or is this tracked in a separate marketing or campaign tool?
4.2
Pre-Screening ObjectIs the pre-screening questionnaire managed inside Salesforce — with individual responses captured, pass/fail scores recorded, and screen failure reason codes logged? Or does pre-screening happen outside Salesforce?
4.3
Recruitment VelocityIs there a Salesforce dashboard or report that shows recruitment velocity per site — referrals per week vs. target — and triggers an alert when a site falls below threshold?
4.4
Channel PerformanceCan you report from Salesforce on which recruitment channels (EHR queries, digital campaigns, community outreach) are producing the most qualified candidates for this protocol — or is that analysis done manually in a spreadsheet?
05
Screening & Enrollment
Day 1 of patient pathway — visibility layer only
5.1
ICF TrackingIs Informed Consent Form (ICF) status tracked in Salesforce — consent date, ICF version, and site — as an operational visibility data point (no PHI)?
5.2
Screen Failure LoggingIs the screen failure log maintained in Salesforce — with reason codes per failure and aggregate screen fail rates visible per site? Or are screen failures tracked in the EDC or a spreadsheet?
5.3
Enrollment DashboardDoes Salesforce have an enrollment visibility dashboard showing enrollment velocity, enrolled vs. target per site, and forecast vs. actual against protocol timeline — without subject-level clinical data?
5.4
Enrollment AlertsAre there automated alerts when a site hits an enrollment milestone (50% of target, 100% enrolled) or when screen failure rate exceeds an acceptable threshold?
5.5
Overall Data QualityOn a scale of 1–10, how much do you trust the enrollment and site performance data currently in Salesforce for executive reporting — and what is the biggest reason for the score you gave?

The Audit Scorecard —
your gaps, quantified.

Every audit produces a scored assessment across three dimensions. The scorecard makes the gap concrete and measurable — not a narrative opinion. It is the artifact you share with your COO or VP Operations to build the business case for fixing what the audit identifies.

Scores are derived from your intake responses — not industry averages. A client who has a strong feasibility workflow but a regulatory packet process with gaps will see that distinction clearly in their scorecard.

Typical intake scores — before the audit fix
38
Architecture
42
Efficiency
29
AI-Readiness

Clinical Workflow Audit Scorecard

Sample — your scores derive from your intake data

Architecture Integrity38 / 100
Dedicated Clinical Study Object
Feasibility Survey in Salesforce
Site Account Object exists
Study-Site Junction Object
Regulatory Packet Object
Operational Efficiency42 / 100
Automated Close-Won → Study trigger
IRB deadline automation
Some milestone tracking in place
Greenlight % calculated automatically
AI-Readiness29 / 100
Standardized Study & Site ID naming
Historical site enrollment data structured
Screen failure reason codes standardized

Four steps. One week.
A roadmap you can act on.

The audit is designed to be fast without sacrificing depth. You complete one intake form. The analysis happens against the five-stage framework. You receive a bespoke report within 48–72 hours.

01
Day 0
Book & Pay
Book a 20-minute discovery call. Confirm fit and scope. Stage-by-stage intake form sent within 24 hours.
02
Day 1
Complete Intake
25 questions mapped to all five stages. About 25 minutes. No Salesforce access required — the form captures everything needed for the analysis.
03
Day 2–4
Receive Report
A 15–20 page audit report: stage-by-stage gap analysis, scorecard, object blueprint, AI-readiness score per stage, and 30-day prioritized roadmap.
04
Day 5–7
Executive Review
60-minute call. Walk through every finding, prioritize the roadmap, align on what gets built first. Your team leaves with a specific plan.

The audit produces the roadmap.
Your team — or an advisory retainer — executes it.

Many clients use the audit as a standalone diagnostic — they take the roadmap to their internal Admin and execute it independently. Others choose an ongoing advisory retainer for continued architectural guidance as they build. Both outcomes are valid. Either way, your team or a Salesforce resource of your choosing does the configuration work — Greenlight Advisory provides the architecture and the judgment.

If you start an advisory retainer within 14 days of audit delivery, the full $2,500 audit fee credits toward Month 1. You're getting the first month for $2,500 instead of $5,000.

$5K/mo
Advisory Retainer
One scheduled working session per week with your Admin or Salesforce team. Architectural guidance for one active stage at a time. Async access for questions between sessions.
$8K/mo
Priority Advisory Retainer
Two scheduled working sessions per week. Architectural guidance across up to two concurrent stages. Priority same-day response between sessions.

Both tiers are advisory only. Configuration and implementation are executed by your internal Admin or a Salesforce resource of your choosing — Greenlight Advisory does not build or configure.

Do you need access to our Salesforce org?
No. The intake form is designed to capture everything needed for the analysis. Read-only access is welcomed if available but the audit delivers full value from the intake data alone.
What if we're still building — not yet fully live?
The audit is actually more valuable before a build is complete than after. The gap analysis tells you exactly what to build correctly from the start — avoiding the technical debt that most CRO Salesforce orgs accumulate by default.
We only have some of the five stages in Salesforce. Is that okay?
Yes — and it's the most common situation. The audit identifies which stages are covered, which are missing, and what the priority order is for adding coverage based on your specific go-live timeline.
Who conducts the audit?
John Sprankle — Salesforce Solutions Architect with 17+ years of experience, including nearly 5 years inside a global decentralized research site network working directly with this category of clinical research Salesforce architecture. Every audit is conducted personally by John — not delegated.
Book the Audit

Ready for an independent view
of your Salesforce build?

Book a 20-minute discovery call to confirm fit and scope. The stage-by-stage intake form is sent within 24 hours of the call.

Five-stage review from RFP/Protocol through enrollment visibility
48–72 hour report delivery after intake
60-minute executive review call included
Audit fee credited to advisory Month 1 if you engage within 14 days
No Salesforce access required
Every audit conducted personally by John — not delegated

Book a Discovery Call First

20 minutes. Confirm scope and fit before committing.

📅

Schedule 20 Minutes

Replace this block with your Calendly embed. Paste your Calendly URL as an iframe or button here.

Open Calendly →
— or send a message and we'll take it from there —
Send a Message to Get Started →