Custom Salesforce Deals Reporting Solution

Posted by: Nolan Barger Date Posted: August 5, 2024
Back to Case Studies

Issue

The client had very custom reporting needs from their integrationsfx setup.  However, the issue we faced was we didn’t have a “home” for some of the data they wanted us to ingest from their CRM and report on.  As we discussed solutions, it was made clear that they had the capabilities to build this report in Salesforce, they just didn’t have our attribution data in there.

Solution

The solution we proposed was very unique.  Instead of passing source/medium to lead records, we actually passed them attribution from the MCFX deals to their Salesforce opportunity.

On the opportunity records, they added the following fields:

  • Source (Source__c)
  • Medium (Medium__c)
  • MROI Channel (MROI_Channel__c)
  • Subchannel (Subchannel__c)
  • Campaign (Campaign__c)
  • WebFX Deal ID (WebFX_Deal_ID__c)
  • Buyer Touchpoint Channels ( Buyer_Touchpoint_Channels__c)
  • Buyer Touchpoint Subchannels (Buyer_Touchpoint_Subchannels__c)

Once those were added, we searched Salesforce via API by the external ID, which was the opportunity ID.  Once the record was found, we posted our deals attribution to it.  We then confirmed all worked as planned, and once approved, we backfilled for 2 years so they could pull YoY growth reports on WebFX’s digital marketing strategy.

Achievement

We came up with a custom solution for their very unique reporting needs.

Snippet/Screenshot/Link