Better Quality Conversion Feed and AM Peace of Mind

Posted by: Gina Bennett Date Posted: September 19, 2024
Back to Case Studies

Issue

Janek has two types of opportunities in their Salesforce: Private and Public.   We only wanted to optimize our PPC bidding for Private Opportunities since Public Opportunities are way less valuable long-term and don’t align with our PPC goals.

The other problem was that we had multiple errors with our Salesforce/MarketingCloudFX integration and had to make several edits.  At one point, we actually had to manually comb through integration logs in Workato so we could do a conversion adjustment.  These errors cause the IM AM to have little faith and trust in the integration.  They were always questioning if the integrations were working correctly, if the results were correct, and how they could QA check themselves.

Solution

The type of Opportunity is stored in the ‘Record Type’ field in Salesforce.  We updated our Salesforce/MCFX integration to update our “Sales Territory” field in the Deal object to contain their ‘Record Type’ field.  Rafael then updated the Conversion Feed to exclude any contacts with a Deal with the Sales Territory field equal to “public” (so we were only sending those with “Private” Opportunities).

To give the AM better clarity and peace of mind, Rafael created a Google Sheet that logs all conversions sent to Google and Bing ads.  It includes the fields below, both so the AM can QA check it against Google/Bing Ads and so we can easily upload a conversion adjustment in the future if ever needed!  I also had an internal huddle with the AM to review when conversions are counted in Google Ads.  Offline conversions almost always have different Click, Conversion and Upload Dates/Times, and offline conversions are counted on the Click Date/Time.  That piece of education went a long when in helping the AM better understand what they should be seeing in Google and Bing Ads!

Fields included in the Google Sheet log

  • Conversion Name
  • Value
  • Conversion Date/Time
  • Upload Date/Time
  • C360 Link
  • External Deal ID
  • Google or Bing
  • Ad Click ID

Note: I would recommend uploading any sheets like this into Looker and then into AnalyticsFX (or giving View Only access on the Google Sheet) so AMs don’t have direct edit access to the Google Sheet

Shoutout to Nolan for help with organizing this strategy!

Achievement

  • Updated our integration and conversion feed to only send quality offline conversions
  • Created a log to give the AM peace of mind and easy QA checking

Snippet/Screenshot/Link

  • Dev Task to update the integrations and create the log: https://app.webfx.com/todos/263015506
  • Google Sheet Conversion Feed Log: https://docs.google.com/spreadsheets/d/1icRYqx2JHUg197d0nM6_PYtYLwBRV5nianKE-afyCPY/edit?usp=sharing