📢 Marketing
Google Ads Offline Conversion Import Planner for Lead Gen: GCLID Capture in Hidden Fields, CRM Stage to Conversion Action Mapping, Upload CSV Headers and Time Zone, 90 Day Window, Primary vs Secondary Goals, and Error Fixes
Feed real sales outcomes back into Google Ads: capture the GCLID on every form, store it in the CRM, map lead stages to import conversion actions, build an upload file with the right headers, time zone, and values, respect the click window, choose which actions are primary for bidding, and fix the usual upload errors.
0Reviews
Prompt
Act as a paid search analyst who sets up Google Ads offline conversion imports for service businesses with long sales cycles, and who has fixed uploads rejected for missing click IDs, conversion times before the click, and conversion names with a stray space. Inputs: - Business and sales process: what a lead is, the CRM stages a lead passes through, and typical time from lead to sale: [SalesProcess] - CRM or lead store and how forms reach it (website form tool, call tracking, chat): [LeadStack] - Current Google Ads conversion actions, which are primary, and the bid strategy in use: [CurrentConversions] - Values you can stand behind per stage (average contract value, or a value only at close): [StageValues] - Account time zone and the time zone the CRM stores timestamps in: [TimeZones] - Consent setup for ad user data where required, and who owns the upload: [ConsentAndOwner] - Output format: [Format] Generate: 1. A GCLID capture plan from LeadStack: auto tagging on, a hidden form field that stores gclid from the landing URL (and gbraid or wbraid if present), persistence across pages, and a CRM field to hold it. Mark CHECK for any tool specific step. 2. A stage to conversion action map: one import conversion action per CRM stage worth optimizing, with exact names, count setting (one per lead), value from StageValues, and click through window. 3. Primary vs secondary: which action bidding should use given CurrentConversions and how many conversions per month each stage produces, and which stay secondary for reporting so nothing is double counted. 4. The upload file: a Parameters:TimeZone line from TimeZones, then the headers Google Click ID, Conversion Name, Conversion Time, Conversion Value, Conversion Currency, with three sample rows and the time format. 5. Timing rules: conversion time must be after the click, clicks older than the action's window will be rejected, and how often to upload (scheduled file, Sheets, or API). 6. A fallback for leads with no click ID: enhanced conversions for leads with hashed email, and where consent from ConsentAndOwner limits it. 7. An upload error table: common errors, what causes each, and the fix. 8. A first month QA plan: compare CRM counts to imported counts by week and flag gaps over a set threshold. Constraints: - Use only facts from Inputs. Never promise lower cost per lead or quote typical lift. Mark UI paths that may have moved as CHECK. - Plain language for the business owner; no em dashes.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
SalesProcess: residential solar installer; web form lead, then site survey booked, then signed contract; about 21 to 45 days from lead to contract LeadStack: WordPress with Gravity Forms posting to HubSpot; calls tracked separately CurrentConversions: Form Submit (website tag, primary), Calls from ads (secondary); bidding Maximize Conversions StageValues: survey booked has no reliable value; signed contract average 24,000 USD TimeZones: Google Ads account America/Phoenix; HubSpot exports in UTC ConsentAndOwner: US only traffic, cookie banner in place; marketing coordinator Priya uploads weekly Format: plan, tables, sample CSV, QA
Example Output
1. GCLID capture - Confirm auto tagging is on (Admin, Account settings; CHECK path). - Gravity Forms: add hidden fields gclid, gbraid, wbraid, each set to populate from the URL query parameter of the same name. CHECK the field setting name in your Gravity Forms version. - Store the value in a first party cookie on landing so it survives if the visitor clicks to another page before the form. Read it into the hidden field on submit. - HubSpot: create contact properties gclid, gbraid, wbraid (single line text) and map the form fields to them. 2. Stage to action map (Goals, Conversions, New, Import, CRM or files, track conversions from clicks) | CRM stage | Action name | Count | Value | Window | | Site survey booked | Survey Booked | One | none | 90 days | | Contract signed | Contract Signed | One | 24000 USD | 90 days | Names must match the upload file exactly, including capitals and spaces. 3. Primary vs secondary - Now: Form Submit stays primary until imports run cleanly for 4 weeks. - Then: make Survey Booked primary and Form Submit secondary. Contract Signed stays secondary at first because a 21 to 45 day lag and low monthly count give bidding little to learn from. Revisit when it reaches steady monthly volume. - Never leave Form Submit and Survey Booked both primary; each lead would count twice. 4. Upload file (CSV) Parameters:TimeZone=America/Phoenix Google Click ID,Conversion Name,Conversion Time,Conversion Value,Conversion Currency Cj0KCQjw_sample1,Survey Booked,2026-09-14 15:20:00,, Cj0KCQjw_sample2,Survey Booked,2026-09-16 09:05:00,, Cj0KCQjw_sample3,Contract Signed,2026-10-02 13:45:00,24000,USD Time format yyyy-MM-dd HH:mm:ss in the account time zone. HubSpot exports UTC, so subtract 7 hours for Phoenix (no daylight saving) before upload, or set the parameter line to UTC and keep raw times. Pick one and write it in the SOP. 5. Timing rules - Conversion time must be later than the click time. - Clicks older than the 90 day window are rejected, so upload Contract Signed rows weekly, not quarterly. - Priya uploads every Monday; CHECK how long after creating a new action Google accepts the first upload. 6. Leads with no GCLID - Turn on enhanced conversions for leads: the site tag sends hashed email on form submit, and uploads match on hashed email. US only traffic with the current banner; review again if you add EU visitors. - Calls stay tracked separately; do not import them twice. 7. Upload errors | Error | Cause | Fix | | Click ID not found or invalid | gclid truncated or from another account | Check field length; confirm the click came from this account | | Conversion precedes click | UTC times not converted | Apply the time zone rule above | | Conversion action not found | Name mismatch | Copy the exact name from Goals | | Click too old | Uploaded past 90 days | Upload weekly | | Duplicate | Same click ID, name, and time uploaded again | Keep an uploaded flag in HubSpot | 8. First month QA - Each Monday compare HubSpot survey bookings with a gclid against imported Survey Booked for the prior week. Investigate any gap over 10 percent: missing gclid, failed rows, or name errors.