Afspraak maken
Skip to main content
Hoe kan ik helpen?
< Alle onderwerpen
Afdrukken

Quotation value measurement in Google Ads

Geüpdatet

If you have a business that receives bids you’re going to get to a target CPA pretty quickly. However, this is not the most desirable situation because you don’t know what value you can attach to the quotes. In fact, it is also possible to send the value within the offer back to Google Ads, aka offline conversions. In this article, I write how you can do just that.

Solution: gClick ID & upload quote value

Step 1: Insert script to store gClick ID in a localstorage and URL

Place the script below on every page of your website (via Google Tag Manager, for example). Stores the gClick ID in localstorage and URL.

Check carefully the config at the top of the script. Here you need to set whether you want to use ID or name and which hiddenfield you want to address.

<script type="text/javascript">
  
  // © Bernt Muurling - Freelance SEA-specialist - berntmuurling.nl
  // ---------------------
  // CONFIGURATION SECTION
  // ---------------------
  
  // True for use of ID, false for use of name
  var USE_ID = false;
  
  // Replace this with the ID or Name of your hidden field based on your selection
  var HIDDEN_FIELD_IDENTIFIER = 'et_pb_contact_message_0';
  
  // -------------------------
  // END OF CONFIGURATION SECTION
  // -------------------------
  
  (function() {
      function getGclidFromURL() {
          var match = RegExp('[?&]gclid=([^&]*)').exec(window.location.search);
          return match && decodeURIComponent(match[1].replace(/\+/g, ' '));
      }
  
      function addGclidToLinks(domain) {
          var links = document.querySelectorAll('a[href*="' + domain + '"]');
          links.forEach(function(link) {
              if (!link.href.includes('gclid=')) {
                  var separator = link.href.includes("?") ? "&" : "?";
                  link.href += separator + "gclid=" + gclidValue;
              }
          });
      }
  
      function storeGclidInLocalStorage() {
          localStorage.setItem('gclid', gclidValue);
      }
  
      function addGclidToHiddenField() {
          var hiddenField;
          
          if (USE_ID) {
              hiddenField = document.querySelector('#' + HIDDEN_FIELD_IDENTIFIER);
          } else {
              hiddenField = document.querySelector('[name="' + HIDDEN_FIELD_IDENTIFIER + '"]');
          }
  
          var gclidForField = localStorage.getItem('gclid') || gclidValue;
          
          if (hiddenField && gclidForField) {
              hiddenField.value = gclidForField;
          }
      }
  
      var gclidValue = getGclidFromURL();
      if (gclidValue) {
          addGclidToLinks(window.location.hostname);
          storeGclidInLocalStorage();
      }
      addGclidToHiddenField();
  
  })();

  // © Bernt Muurling - Freelance SEA-specialist - berntmuurling.nl
</script>

Step 2: Submit gClick ID via form

Send gClick ID along in form by creating a hidden field. Script automatically appends gClick ID to form ID or form name. Sample form:

<form action="" name="myForm">
         Name: <input type="text" name="name">
         <input type="hidden" id="gclid_field" name="gclid_field" value="">
         <input type="submit" value="Submit Form" name="btnSubmit">
   </form>

Step 3: Submit quote to CRM or Google Spreadsheet

Quote lead send through your form to your CRM or to Google spreadsheet. This depends on how you process your forms. Many WordPress contact forms, for example, often allow you to automatically put the input into Google Spreadsheets.

If you don’t have a CRM go to step 4.1.

Step 4: Export from your CRM to Google Spreadsheet

Export from your CRM approved leads including price & gClick ID to Google Spreadsheets / add to your Google Spreadsheets the price to the appropriate quote request.

Sample Spreadsheet: Google Spreadsheet Offline Conversions

Step 4.1 (if you don’t have a CRM): Form directly to Google spreadsheets

If you don’t have a CRM, then I recommend shooting all leads from your quote form directly to Google Spreadsheets. This can often be done with many plugins and forms. So then you instantly have all quote information including price column & gClick ID in a clear Google sheet. All you have to do then is that when a quote is approved go to the sheet and fill in the price at that quote.

Sample Spreadsheet: Google Spreadsheet Offline Conversions

Step 5: Upload your data source into Google Ads

Go to “uploads” under “conversions” in Google Ads. Select the Google Spreadsheet as the source and make sure to pull it up daily.

Step 6: Upload quotes without gC member

To bypass iOS17 and thus use Conversion by Leads, you must also upload all quotes without a gC member. You do this in a separate spreadsheet.

That’s it. Questions? Send me a message.

Don’t forget to add me on LinkedIn: Bernt Muurling and press the call button.

Inhoudsopgave
Categorieën