Conversion Feed Solutions When Having Trouble Pulling GCLIDs from Contacts

Posted by: Melissa Shoff Date Posted: January 10, 2024
Back to Case Studies

Issue

We’ve been having some trouble with Deep Trekker’s conversion feeds over the last several months. They use max conversion value bidding for their Ads strategy, but we weren’t sending quality or sales data due to the click IDs not getting sent to the webhook. While conversion values have been set for other conversion actions, the results are focused mainly on lead form submissions now and not quality leads anymore.

Solution

To keep things moving for them, I worked with Nolan and we recommended the following workaround until the Google click ID issue had been resolved.

  1. Use LMFX’s API to get all new leads from the past 90 days.
  2. Add a filter to filter out anything that isn’t a contact stage of “Sale” or “Prospect” (see here). Also add a filter that the lead must have an add click ID. This will return the SQLs and Customer stage contacts they have along with Gclid.
  3. Post contact ID and gclid to the google sheet along with the conversion name they post to. Ie. any customer should have a conversion name of “MCFX – Sale”. If the person is a customer, they should be added for both conversion actions in the sheet (two separate lines).
  4. Next, search contacts in c360fx by ID. For sales, you could grab the sales value from the lifetime revenue OR from querying the deals.
  5. Post the revenue to the google sheet to an amount column for any MCFX – Sale conversion.

Achievement

Felipe was able to complete the integration workaround using the recommended method!

  1. I completed the integration using Nolan’s method.
  2. We used a Pubsub to keep track of the individual deals we submit to Google Ads.
  3. All conversions in the Pubsub have been submitted to Google Ads.

These were the results:

  1. DT MCFX – SQL – 51 leads found in MCFX, 38 conversions uploaded to Google Ads
  2. DT MCFX – Sale – 28 leads found in MCFX, 24 conversions uploaded to Google Ads

This will continue to run and push the quality data we were previously missing back into Ads for this client to help propel their campaign moving forward until the large issue is resolved!

Snippet/Screenshot/Link