Identifying Causes of Unattributed Website-Generated Deals

Posted by: Gina Bennett Date Posted: March 5, 2025
Back to Case Studies

Issue

Swiftwall’s AM and POC flagged to me that they had a really high number of deals in the “CRM Data – No Channel Provided” category. I initially assumed that this was due to adblockers/browsers blocking our pixel and the client getting higher number of referral/returning customers than they thought.

We started pulling in their Lead Source field from Salesforce, and there were 243 deals created since 2024 that were attributed to the Website in Salesforce that we had no attribution for.

Solution

I ran an analysis on the unattributed deals to better understand exactly why these deals are unattributed.  Is it our pixel being blocked?  Are we missing tracking on a form?

Analysis Steps:

  • Created a Looker report of “CRM Data – No Channel Provided” deals broken out by their CRM source
  • Downloaded an export of “CRM Data – No Channel Provided” deals with a CRM Source of “Swiftwall Website”
  • Checked for missing contact data
  • Downloaded entries from Gravity Forms to cross-compare (using vlookup) for submissions not tracked in LeadManagerFX
  • Broke the deals out into different categories based on why it seems like we don’t have attribution for them

Findings
Their “CRM Data – No Channel Provided” deals with a CRM Source of “Swiftwall Website” can be broken out into 4 categories:

  1. 18 (~7%) have no email address or phone number in Salesforce
  2. 48 (~20%) match a form submitted to the Dealer Map Contact Us form in Gravity Forms (that we didn’t track in RevenueCloudFX)
  3. 83 (~34%) match a form submitted to the Contact Us form in Gravity Forms (that we didn’t track in RevenueCloudFX)
  4. 92 (~38%) don’t fit into the above categories

Theories as to why each category isn’t attributed:

  1. No email and phone = nothing to match against
  2. We weren’t tracking the Dealer Map Contact Us form. This form was mistakenly put into the “do not track category” by a former Analyst during an audit in Dec 2024 (ss).
  3. Our pixel is being blocked by adblockers and related software since we are tracking this Contact Us form and have other valid submissions
  4. This could be a mix of things! Different emails being used, main opportunity contacts switching, lead source being entered in incorrectly, etc

How to increase our attribution in each category:

  1. Make sure the sales team is adding email and phone to each contact << their sales team needs to handle this
  2. Re-enabled tracking for the Dealer Map Contact Us form
  3. Upgrade to the DNS Pixel (pending)
  4. Unclear!  The Swiftwall team will be checking deeper into the Opportunities on their side to see why some where marked with a Source of “Website” in Salesforce.

Achievement

Identified causes of website-generated deals having no attribution in RevenueCloudFX and solutions that, when implemented, should give us attribution for another ~100 deals/year.

Snippet/Screenshot/Link