Campaign Tracking & Real-Time Webhooks Data Synchronization - Poly Tracking Connect for WordPress Project

Full-Featured Campaign Tracking, Webhook Integration & Google Sheets Sync Engine for WordPress

339.35 ms
Description Changelogs Products related
Copy changelogs

The Campaign Tracking & Real-Time Webhooks Data Synchronization (Poly Tracking Connect - wptrackingconnect) plugin is a complete event tracking, lead capture, and webhook integration solution for WordPress websites. Built for digital marketers, media buyers, and e-commerce managers, it seamlessly bridges your WordPress site with external CRMs, analytics servers, and Google Spreadsheets.

Core Features & Subsystems

1. Multi-Source Event Triggers & UTM Capture

  • Event Listeners: Intercepts Page Views, Contact Form 7 form submissions (wpcf7_mail_sent), new WooCommerce orders (woocommerce_thankyou), button clicks, and custom JavaScript events.
  • UTM Context Preservation: Automatically captures and preserves utm_source, utm_medium, utm_campaign, utm_term, utm_content, client IP, referrer URLs, and user-agent data.

2. Direct Google Sheets Sync via Google Apps Script

  • Zero Third-Party Cost: Syncs leads directly into Google Spreadsheets using a free Google Apps Script Web App Endpoint, bypassing expensive middleware services like Zapier or Make.
  • Integrated Setup Guide: Includes step-by-step Apps Script deployment guidelines directly inside WP Admin.

3. Multi-Target Webhooks & Dynamic Payload Mapping

  • Custom Webhook Dispatcher: Sends HTTP POST/GET requests to any custom endpoint with custom headers (Bearer Auth tokens) and dynamic payload key-value mapping.
  • Dynamic Placeholders: Supports placeholders like ${items[].names}, ${orders_memo}, ${timestamp}, and CF7 form field tokens.

4. Real-Time Logs & Webhook Retry Engine

  • Transparent Logging Table (ptc_logs): Records HTTP request payloads, response status codes (200, 400, 500), and latency.
  • Manual Webhook Retry: 1-click Retry Webhook button allows instant re-dispatch of failed requests when recipient servers experience downtime.

System Architecture & Data Flow

graph TD A[Event Trigger CF7 Form / WooCommerce Order / Page View] --> B[PolyTrackingConnect Context Collector] B --> C[Extract UTM Parameters Client IP Referrer & Form Fields] C --> D{Dispatch Target Engine} D -->|HTTP Webhook| E[WebhookDispatcher HTTP POST / GET to Endpoint] D -->|Google Sheets| F[GoogleSheetsDispatcher POST to Google Apps Script] E --> G[Record Request Response Status in ptc_logs DB Table] F --> G G --> H[Admin Log Inspection & Manual Webhook Retry]