Building a PHP Lead Funnel That Feeds Google Ads Offline Conversions

Why Offline Conversions Matter

If your business generates leads online but closes them offline, Google Ads is optimizing for lead submissions — not actual revenue. Offline conversion import fixes this by telling Google which leads actually converted into customers.

Step 1: Capture GCLID on Form Submission

Every click on a Google Ad appends a GCLID parameter to the URL. You must capture this and store it in your database alongside the lead.

// In your PHP form handler:
$gclid = $_GET["gclid"] ?? $_POST["gclid"] ?? "";
// Store in MySQL with the lead record

Step 2: Store the Lead in MySQL

Create a leads table with columns: id, name, email, phone, gclid, source, created_at, converted_at, conversion_value.

Step 3: Push Conversions to Google Ads API

Use the Google Ads API OfflineUserDataJobService to upload the GCLID plus conversion time and value. This retroactively tells Google Ads which clicks became real customers.

💡 Result: After implementing this for a SaaS client, their Google Ads tROAS jumped from 180% to 340% within 60 days.