How every prospect flows from ad click to CGM device shipment — Zoho CRM, Zapier automations, PVerify insurance verification, and the workflows that connect it all.
Google Ads (PMax + Search) and Meta Ads (26 segment-based campaigns) drive prospects to the website form.
Patient fills out a CGM request form on one of two websites. This fires the Zapier workflow chain.
4 Zapier Zaps fire simultaneously — creating the Zoho record, normalizing timezone, running the Full Benefit Report, and assigning the Prospect ID.
PVerify checks insurance, eligibility, and duplicate status. 3 gates must pass (Insurance Found, Eligibility Passed, Same/Similar Passed).
Prospects move through Verification Complete, In Chase, and final verification stages. Failures route to specific team members for manual intervention.
Fully qualified patients receive their CGM device (FreeStyle Libre or Dexcom). Conversion signals feed back into Google Ads for optimization.
Performance Max + Search
26 Segment-Based Campaigns
CRM-stage retargeting architecture: each patient segment (HMO, Just Turned of Age, No Contact, Denied By Patient, Bad DOB, P Match) gets 3 targeting variants:
Plus General cold traffic campaigns for net-new patient acquisition.
One of two STJ websites collects: name, DOB, phone, insurance info, diabetes type, and device preference (FreeStyle Libre / Dexcom).
Within seconds of form submission, 4 independent Zapier workflows trigger in parallel — each handling a different piece of the onboarding process.
The prospect lands in Zoho CRM. 8+ workflow rules fire automatically: round-robin owner assignment, confirmation email sent, timezone updated, prospect ID generated, and the Full Benefit Report is created.
The Full Benefit Report Zap calls PVerify to look up the patient's insurance. 3 gates must pass: Insurance Found, Eligibility Passed, Same/Similar Passed.
Based on PVerify results, the prospect routes to either the happy path (Verification Complete, In Chase, Patient) or a failure/stalemate stage requiring manual intervention.
Key stage transitions (In Chase, Sales) fire conversion signals back into Google Ads via Zoho CRM sync, enabling the ad algorithm to learn which clicks produce real patients.
This is the main automation engine. It calls PVerify to verify insurance, checks eligibility, runs duplicate detection, and routes the prospect based on the results. The Zap uses nearly all 100 available Zapier steps.
Detailed breakdown in Section 08 below.
All 4 zaps fired within 53 seconds of the form submission.
PVerify runs an Insurance Discovery search. Must return "Found" status. If not found, routes to Validator Warning for manual lookup.
Eligibility check validates the insurance plan covers CGM devices. Checks for HMO restrictions, inactive Part B, and advantage plans.
Checks SOS (Schedule of Services) for K-Codes and A-Codes to detect if the patient already has a CGM or similar device. Passes if no conflicts found.
Insurance Not Found — Routes to Validator Warning. STJ team manually searches for insurance info by calling the patient.
Eligibility Failed — Routes to specific failure bucket (HMO, Inactive Part B, Advantage Plan) based on the reason.
Same/Similar Conflict — Patient already has a CGM. Routes to Same/Similar Pending for manual review.
Invalid MBI Format — Medicare Beneficiary Identifier format is wrong. Routes to team for correction and retry.
These stages require the STJ team to take manual action — calling the prospect, their doctor, or their insurance company.
Terminal stages where the prospect cannot be qualified. Some can be retried periodically.
| Workflow Rule | Trigger | What It Does |
|---|---|---|
| Roundrobin for Intake Team | Prospect Created | Assigns prospect owner via round-robin to intake team members |
| Update to Non-Insulin on Creation | Prospect Created | If prospect is non-insulin dependent, reassigns owner to Jennifer Gibbons |
| Update Upload Time and Owner | Prospect Created | Sets the Upload Date timestamp on the prospect record |
| Mark Created Time | Prospect Created | Stamps the Create Time field for reporting and SLA tracking |
| Update Timezone | Prospect Created | Fires a webhook to normalize the prospect's timezone based on location |
| CC2 - Stage is New Prospect | Stage = New Prospect | Sends confirmation email to patient: "Your CGM request has been received" |
| On Create - Run Full/Partial Benefit Report | Prospect Created | Creates the Benefit Report record that triggers PVerify verification |
| autoFillProspectID | Prospect Created | Auto-generates a unique Prospect ID (e.g., 4890925000385012813) |
| Sync Lead to Backend | Prospect Created | Syncs the lead to external backend + creates email-to-SMS address |
| Update Insurance | PVerify Result | Marks Insurance field as "Found" (green badge) when PVerify returns positive |
| Update Last Verification Date | PVerify Result | Timestamps when the last insurance verification was run |
| Update Eligibility | Eligibility Check | Marks Eligibility as "Passed" (green badge) after eligibility verification |
| Update Same / Similar | SOS Check | Sets Same/Similar to "Pending" (gray badge) while checking for existing CGM devices |
| Mark Same / Similar Passed | SOS Check Complete | Updates Same/Similar from "Pending" to "Passed" (green badge) when no conflicts found |
| Track Prospect Stages | Stage Change | Logs every stage transition for reporting, SLA tracking, and offline conversion signals |
Zoho fires a webhook when a new prospect is created. The Zap receives all patient data including name, DOB, insurance info, and the Zoho record ID.
Steps 2-4: Fetches the full prospect record from Zoho, obtains an API token from PVerify, and extracts the data fields needed for insurance lookup.
Step 5: Calls PVerify's Insurance Discovery API to find the patient's insurance plan. Posts the Insurance Discovery ID back to the Zoho prospect record.
Step 6: Based on Insurance Discovery results, the Zap splits into 4 branches:
Steps 7-12: For prospects that PASSED insurance discovery — posts insurance info to Zoho, gets a new PVerify token, runs the Eligibility API call, and posts the Eligibility Summary ID + L2 Overview Link back to Zoho.
Step 13: Based on eligibility results, splits into 6 more branches:
Steps 14-18: For fully eligible prospects — updates Zoho module entry, gets a fresh PVerify token, then checks SOS (Schedule of Services) for both K-Codes and A-Codes. If no conflicts found, the Same/Similar check passes and the prospect advances to Verification Complete.
Created by Wolf Schramm at 5:27 PM. Immediately assigned via round-robin to Maryssa McCloud-Braxton, then reassigned to Jennifer Gibbons (Non-Insulin workflow). Upload Date and Create Time stamped. Timezone webhook fired.
Confirmation email sent to Sharon. Confirming Request record created. Benefit Report created. ProspectID auto-filled. Backend sync + email-to-SMS address generated.
Insurance status updated to "Found". Last Verification date set. Primary ID (5TV0XW1GF09) assigned by Wolf Schramm.
Eligibility: "Passed". Same/Similar went from "Pending" to "Passed". All 3 gates cleared. Track Prospect Stages workflow triggered.
Sharon Sanford successfully cleared all automated checks and advanced to the In Chase stage — ready for the STJ team to process the CGM order. Total time from form submission to In Chase: under 2 minutes.
V2 account with PMax General (workhorse) + Search. Receives offline conversion signals from Zoho CRM stages (In Chase, Sales) via GCLID matching.
26 segment-based campaigns. CRM stage audiences (HMO, No Contact, Denied) are uploaded from Zoho for multi-channel retargeting.
4 core Zaps: Form-to-Zoho (v53), Timezone Normalization, Full Benefit Report (89 steps, v6), Primary ID Assignment. The orchestration layer.
Central prospect database. 15 workflow rules handle assignments, emails, verification tracking, and stage transitions. The source of truth for every prospect.
External insurance verification API. Runs 3 checks: Insurance Discovery, Eligibility Verification, and SOS Code Check (Same/Similar). Called via Zapier.
Handles patient communications — automated SMS sequences, email nurture campaigns, and follow-up scheduling. Connected to Zoho via Zapier.
This is what makes the system intelligent. Google Ads doesn't just know about form submissions — it knows which clicks turned into real patients.
Each stage fires a conversion signal back to Google Ads, allowing the algorithm to optimize for clicks that produce qualified patients — not just form fills.