Summary

Created a Google Ads offline conversion upload package for the 9 converted intakes from the dry-run webform GCLID cohort.

Deliverables

Native Google Sheet: https://docs.google.com/spreadsheets/d/1e6ykOHS90aaFFVrRbWO5f9sNiN7EBHBpQv0DGEIgovU
Local workbook: /Users/samaguiar/Documents/Projects/Repos/sail-litify-hub-mdt/Litify_AI_Integration_Project/output/google-ads-offline-upload/manual-converted-cohort-2026-05-28/google-ads-offline-conversions-converted-intakes-2026-05-28.xlsx
Strict upload CSV: /Users/samaguiar/Documents/Projects/Repos/sail-litify-hub-mdt/Litify_AI_Integration_Project/output/google-ads-offline-upload/manual-converted-cohort-2026-05-28/google-ads-offline-conversions-converted-intakes-2026-05-28.csv
Audit CSV: /Users/samaguiar/Documents/Projects/Repos/sail-litify-hub-mdt/Litify_AI_Integration_Project/output/google-ads-offline-upload/manual-converted-cohort-2026-05-28/google-ads-offline-conversions-converted-intakes-audit-2026-05-28.csv

Used the existing conversion action name from the current pipeline: Litify - Converted Intake (Web Form).
Queried live LITIFY_ORG for conversion timestamps, matter IDs, matter names, and paired Web Form created dates.
Built the Google Ads upload tab with Parameters:TimeZone=America/New_York and the columns Google Click ID, Conversion Name, Conversion Time, Order ID, Conversion Value, and Conversion Currency.
Left value and currency blank so Google Ads can apply the conversion action default value.
Imported the workbook into Google Drive as a native Google Sheet and read back Google Ads Upload!A1:F11 successfully.

Rows included: 9 converted intakes.
Likely within Google's 90-day click import window as of 2026-05-28: 2.
Likely outside the 90-day click import window: 7.
Workbook formula scan found 0 formula errors.
This was read-only against Litify and Google Ads. No records or ad settings were changed.