Version 3.13.1

Choice Universal Form Tracker v3.13.1

Release Highlights

This release includes two major feature additions:

🎯 Google Ads Offline Conversion Import Export

Export click tracking data in Google Ads OCI format for offline conversion tracking. Includes GCLID filtering, proportional value calculation, and UTF-8 CSV format.

📊 Click Tracking Events Migration

Enhanced click tracking with chronological event history. Track phone clicks, email clicks, form submissions, and qualified leads with JSON-based event storage.

What's Changed

Added - Google Ads Offline Conversion Import Export

• Export for Google Ads: New "Export for Google Ads" button in Click Tracking admin
  • GCLID-only filtering (validates Cj0K% and EAIaIQ% patterns)
  • Google Ads OCI CSV format with Parameters row declaring UTC timezone
  • UTF-8 BOM for Excel compatibility
  • One row per event (phone clicks, form submits, qualified leads)
  • Click records with no events export as "Ad Click"
• Conversion Value Calculation: Proportional lead value based on score
  • Qualified Lead conversions: (lead_value × score) ÷ 10
  • All other conversion types: 0
  • Uses existing cuft_lead_value and cuft_lead_currency settings
• Filter Support: Respects existing admin filters (qualified status, date range)
• Export Limits: 10,000 record maximum for performance
• Security: Administrator-level permissions required, nonce verification

Added - Click Tracking Events Migration

• Event-Based Tracking: New JSON events column stores chronological event history for each click
  • phone_click - Telephone link clicks
  • email_click - Email link clicks
  • form_submit - Form submission events
  • generate_lead - Qualified lead events
• AJAX Event Recording: Client-side event recording via dedicated AJAX endpoint
  • Fire-and-forget pattern (never blocks user interactions)
  • Nonce validation and input sanitization
  • Event deduplication (updates timestamp for duplicate event types)
  • FIFO cleanup (100 event limit per click_id)
• Database Migration: Automated schema migration (v3.12.0)
  • Adds events JSON column
  • Adds date_updated index for recent activity queries
  • Hybrid rollback support (preserves business-critical updates)
• Admin Interface Enhancements:
  • Events timeline display in Click Tracking table
  • Event type filtering
  • "Last Activity" sort option
  • CSV export includes event data
• JavaScript Integration: Event recording added to all tracking scripts
  • Phone/email link clicks (cuft-links.js)
  • Form submissions (all framework scripts)
  • Qualified lead events (generate_lead)
• Performance Optimizations:
  • JSON operations <10ms average
  • Indexed date_updated for efficient recent activity queries
  • AJAX fire-and-forget prevents blocking
• Webhook Compatibility: Existing webhook API fully preserved
  • No breaking changes
  • Enhanced with optional event recording

Installation

Download choice-uft-v3.13.1.zip and install via WordPress admin or upload to /wp-content/plugins/.

Upgrade Notes

• Database migration runs automatically on plugin activation
• All existing click tracking data preserved
• Webhook API remains fully compatible
• No configuration changes required

Documentation

• Specification: specs/001-click-export-google/spec.md
• Click Events Spec: specs/migrations/click-tracking-events/spec.md
• Implementation Complete: specs/migrations/click-tracking-events/IMPLEMENTATION_COMPLETE.md

Full Changelog: v3.12.0...v3.13.1