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.
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:
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.
We came up with a custom solution for their very unique reporting needs.