video1.0<iframe src="https://www.loom.com/embed/fcb34ef720e144be9811692b3aa21968" frameborder="0" width="2490" height="1867" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>18672490Loomhttps://www.loom.com18672490https://cdn.loom.com/sessions/thumbnails/fcb34ef720e144be9811692b3aa21968-95c2f49ac96d76aa.gif747.983833This 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.