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.
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
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!