Start free Log in
Documentation › Exporting conversions
Export guide

Exporting offline conversions

Once a lead becomes a paying customer, mark it as converted in OCT, then export a CSV and upload it to Google Ads to close the attribution loop.

How it works

1
Visitor clicks a Google Ad
Google appends a unique gclid to the landing page URL. OCT captures and stores it for 90 days.
2
Visitor submits a form
OCT records the lead, attaching the gclid from their session.
3
Lead converts offline
The person calls back, signs a contract, or books a job. You mark the lead as Converted in OCT.
4
Export CSV
Download a CSV from OCT containing the gclid, conversion time, value, and name.
5
Upload to Google Ads
In Google Ads → Goals → Conversions → Upload, import the CSV. Google matches the gclid and credits the conversion to the campaign.

Step 1 — Mark a lead as converted

In your dashboard, open the Leads tab and click a lead row to open its details panel. Use the status buttons to set the status to Converted or Won.

You can also fill in:

Tip: Set a default conversion name in Project Settings so you don't have to type it every time.

Bulk converting leads

In the Export page (Project → Export CSV), you can select date ranges and filter by status to batch-export all converted leads at once. You don't need to mark each lead individually if you know a date range of conversions.

Step 2 — Export the CSV

Go to Project → Export CSV. Select:

Click Download CSV. The file is ready to upload directly to Google Ads without modification.

Google Ads CSV format

OCT exports exactly the 7 columns Google Ads requires:

Column Description Example
Google Click ID The gclid captured when the visitor clicked the ad Cj0KCQjwwYSwBhDcARIs…
Conversion Name Must match a conversion action in Google Ads Job Booked
Conversion Time ISO format with timezone offset 2025-03-15 14:30:00 +0000
Conversion Value Numeric value (optional) 1500.00
Conversion Currency 3-letter ISO code USD
Ad User Data Consent signal — always "Granted" in OCT exports Granted
Ad Personalization Consent signal — always "Granted" in OCT exports Granted

The first row of the CSV is a header row. Google Ads accepts this format in the standard upload flow.

Step 3 — Upload to Google Ads

  1. In Google Ads, go to Goals → Conversions → Uploads.
  2. Click + Upload and select your CSV file.
  3. Google validates the file and shows a preview. Check that the column mapping matches the CSV columns above.
  4. Click Apply. Google processes the upload and attributes conversions to the matching gclids.
Important: Google Ads requires that the conversion action referenced in the CSV already exists in your account (Goals → Conversions → New conversion action → Import). The name must match exactly.

Upload timing

Google recommends uploading within 90 days of the original click. After 90 days the gclid expires and the conversion can no longer be attributed.

OCT exports the conversion time as the time you marked the lead as converted — not the time of the original form submission. This is the recommended approach for offline conversions (e.g. a lead converted today via a phone call).

Export history

Every export is logged in the Export page under Recent exports. Each entry shows the date, platform, number of rows, and a re-download link. Leads are marked as exported after the first download — the status column in your lead list will show "Exported".

← Quick-start guide
Install the tracking script and capture your first lead.
Tracking script reference →
Form targeting, ads-only mode, and what the script captures.
Get help →
Something not working? We reply within 24 hours.