Summary of work done
- Ran from
/Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project after validating Salesforce alias LITIFY_ORG was connected before any write path.
- Reviewed the latest existing CallRail apply artifact from
output/callrail-gclid-sync/scheduled-2026-05-19T10-05-06Z.
- Created a fresh CallRail dry-run artifact at
output/callrail-gclid-sync/daily-2026-05-20T11-01-32Z because there was no current run artifact for today. Result: 80 CallRail calls with GCLID, 77 matched Salesforce call logs, 3 unmatched CallRail IDs, 0 conflicts, 1 call-log update ready, 0 Intake updates, 0 Matter updates.
- Ran the required webform all-history dry-run at
output/webform-gclid-sync/daily-dry-run-2026-05-20T11-01-32Z. Result: 541 linked webforms with GCLID, 0 Intake updates, 0 Matter updates, 3 conflicts, 0 applied updates.
- Did not run webform apply because conflicts remain and the script produced no safe blank-field-only updates.
- Baseline and post-run live counts matched, so no record counts changed: Web_Form with GCLID plus Intake 541, Intake GCLID 537, Matter GCLID 59.
- Ran the Google Ads sheet sync in dry-run mode only because no clean apply occurred. Dry-run manifest:
output/google-ads-data-manager/2026-05-20T11-02-03-116Z/google-ads-sheets-dry-run.json. Would sync 11 production rows and 9 QA rows. No sheet tabs changed.
- Used Outlook plus live Salesforce as a read-only audit layer for Intaker, CallRail, webform, and SpeedAI evidence.
What shipped and what did not
- Shipped: fresh artifacts, live counts, dry-run summaries, and mailbox-to-Salesforce audit findings.
- Not shipped: no Salesforce apply, no rollback command needed, no write from Outlook or SpeedAI evidence.
Audit findings worth carrying forward
- Webform conflicts still block apply on three Intakes:
INT-24122745230, INT-25011745539, and INT-26042754516.
- Today’s CallRail dry-run still shows 3 unmatched CallRail IDs with GCLID and no matching
CallRail_Call_Log__c.
- Intaker inbound call
+18129149030 exposed a full GCLID in the email URL, but linked CRAIL-26051913742 and INT-26051955102 are both blank, no Matter yet.
- Intaker inbound call
+15028808507 exposed a full GCLID in the email URL, but there was no matching recent CallRail_Call_Log__c or Web_Form__c found in this run.
- SpeedAI cross-checks showed matching live records with blank attribution:
Kelsey Buckman to CRAIL-26051913732 and INT-26051955095, Dakota Miley to CRAIL-26051813648 and INT-26051855029 and MAT-26051867618, Craig Saunders to CRAIL-26051813681 with no Intake linkage, Omari Seawright to CRAIL-26051813683 and INT-26051855069, Kumasi Zaki to CRAIL-26051913715, INT-26051955088, and MAT-26051967627. These were reported only, not written.
- Bonita Wilson was a positive control: Intaker Web Chat
WEB-FORM-26052002595 carried GCLID through to INT-26052055108.
Reason for session ending