{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/fcb34ef720e144be9811692b3aa21968\" frameborder=\"0\" width=\"2490\" height=\"1867\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1867,"width":2490,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1867,"thumbnail_width":2490,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/fcb34ef720e144be9811692b3aa21968-95c2f49ac96d76aa.gif","duration":747.983833,"title":"AI Mastermind - UTM Translator (SFDC)","description":"This Loom explains a Salesforce UTM to channel translator workflow, focusing on a future-proof approach using Custom Metadata Types. The author builds a taxonomy-driven flow that triggers on changes to UTM source, medium, campaign, last referring site, and attribution completed date time, while bypassing execution when the user has a bypass flow automation permission. They argue for custom metadata tables over hard-coded flow values or custom objects, creating a Channel Mapping custom metadata type with an active flag and 11 fields populated with 30 records. They also confirm handling for blank values with a fallback to Website Direct and include match logic that sets or clears channel and related fields based on taxonomy rules."}