Click ID & URL Parameter Extractor

How to use the URL parameter extractor

This URL parameter extractor reads each landing page URL in your file and splits the ad click IDs and UTM tags into separate columns. It's the fast way to extract the gclid from a URL for hundreds of leads at once. Parameter names come from each platform's own pages — for example Google's auto-tagging help page for gclid.

1. Export the URLs. Most CRMs and form tools store the page a lead arrived on, such as HubSpot's First page seen or a hidden “page URL” field in your form.
2. Load the file or paste the list. The tool picks the URL column itself. If your CRM keeps a first and a last page, choose both — the first value found wins.
3. Choose the columns. Keep your own columns to stay next to names and lead IDs, and switch on the extra click IDs if you advertise on X, Snapchat, Reddit or Pinterest.
4. Check the notes. The tool flags URLs saved in capitals, empty or unfilled parameters, duplicate click IDs in one URL and UTM tags spelled two ways.
5. Download or continue. Download the CSV, copy it into a spreadsheet, or send it straight to the offline conversion builder for Google Ads.

Extract click IDs from CRM landing page URLs, whatever their shape

• Normal links, links without https:// and links inside notes like “Visited https://… then called”.
• Redirect and tracking links where the real URL is encoded inside a parameter.
• Single-page apps that put parameters after the #.
• Links copied from HTML or emails with & instead of &, parameters split by ;, and a URL with a stray space.
• Parameter names in any letter case — a name that isn't in its usual case is flagged, because the value may have been changed too.

What to do with each click ID

1. gclid, gbraid, wbraid: send sales and qualified leads back to Google Ads with the offline conversion builder. Check the gclids first with the GCLID checker if your CRM is older than a few months.
2. msclkid: use it in a Microsoft Advertising offline conversion file. Microsoft's Click ID is 32 characters long, so the extractor warns about values of any other length.
3. fbclid: turn it into an fbc value for the Meta Conversions API. Meta says not to change the click ID in any way.
4. ttclid and li_fat_id: keep them with the lead for TikTok and LinkedIn conversion uploads or their conversion APIs.
5. UTM tags: use them to report leads by source and campaign in your CRM, and to spot campaigns that are tagged inconsistently.

Common problems when you split URL parameters into columns

The URL was saved without its query string

If every row reads like /pricing/ or has nothing after the page path, your form saved only the path. Change the hidden field to store the full address, including everything after the ?.

A redirect dropped the gclid

Google says redirects must pass the gclid through to the final landing page. If the click IDs only appear inside an encoded tracking link, the redirect may be losing them before your page loads.

“{msclkid}” or an empty gclid= in the URL

An unfilled macro or an empty value means the link came from a preview, a test or a template — not from a real ad click. The extractor leaves these cells blank so they don't end up in an upload.

The whole URL is in capital letters

Some systems change addresses to capitals. That breaks click IDs, which are case sensitive. The extractor still finds GCLID=, but flags the row so you can trace the cause.

Two different gclids in one URL

This happens when a tracking template adds a parameter the ad platform also adds. The first value is kept; fix the template so each parameter appears once.

utm_source spelled two ways

“Facebook” and “facebook” show up as two sources in Google Analytics. Decide on one spelling — lowercase is the usual choice — and update your ad links.