Session Objective

Figure out where offline conversion tracking is failing and tighten the loop from Google Ads lead to Litify to Google Ads Data Manager via the connected Sheet.

What Was Accomplished

• Queried live Litify/Salesforce (LITIFY_ORG) for Web_Form__c rows with GCLID__c and linked Intakes.
• Read the connected Google Sheet 1Q0oB5-AN2Ki_zVbHcye6iuyHSlXTPih_6_xT0FM7iSs via the service account.
• Queried Google Ads API customer settings, conversion-action metadata, last-30-day Litify action metrics, and offline upload diagnostics.
• Queried CallRail API and live CallRail_Call_Log__c schema/counts.
• Browser-inspected the public homepage for loaded Google/CallRail scripts.
• Patched /Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/scripts/export-google-ads-litify-conversions.mjs so the production export emits conversion_action,gclid,email,phone,conversion_date_time,conversion_value,conversion_currency.
• Verified the patched export locally at /Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/output/google-ads-data-manager/green-signed-standalone-2026-04-23/ with 497 raw rows, 6 production rows, and 9 QA rows.
• Updated the export hierarchy so Litify - Signed Retainer (Web Form) is standalone: signed retainer rows supersede converted intake rows for the same intake/GCLID. Regression check found 5 duplicate signed/converted pairs before the fix and 0 after.
• Staged a launch agent template at /Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/deploy/com.aguiar.litify-google-ads-sync.plist but did not install or load it.
• Wrote the diagnostic report at /Users/samaguiar/Documents/Projects/Repos/sail-googleads/offline-conversion-zaps-2026-04-21/attribution-loop-diagnostic-2026-04-23.md.
• Updated the Litify environment diary and OPS ledger.

Key Findings

• The Litify web-form export path is not dead: live data exists and exports eligible conversion rows.
• Current corrected production export is 6 rows: 5 signed retainers and 1 converted-only intake, with 0 duplicate same-lead signed/converted pairs.
• Google Ads is configured for the two Litify conversion actions, but metrics.all_conversions for both actions is zero in the last 30 days.
• Google Ads offline upload diagnostics show 41 failed events, but under First Time Phone Call, Repeat Phone Call, and Form Capture, not under the two Litify actions.
• The live Sheet Google Ads Upload tab currently has the wrong human-readable headers. Prior Data Manager validation required snake_case headers.