E-commerce UTM naming is a mess; how do I reorganize ad attribution?

For a small team doing online retail, UTM naming is often ignored at the start, and it's only when you have many channels that you realize the data is a complete mess. During one of our reviews, we found that for the same TikTok campaign, some people wrote 'tiktok', others wrote 'TikTok_Shop', and some even put the influencer's name in the 'campaign' field. GA4, the ad backend, and the order…