How are you actually tracking which videos drive commission vs. just views?

Been doing TikTok Shop affiliate for a while now and I'm realizing my "best performing" videos by views are often NOT my best performing videos by actual commission. Feels like I've been optimizing for the wrong metric this whole time.

For those of you doing this seriously how are you tracking conversion at the video level? Spreadsheet? TikTok's native dashboard? Something else? Trying to figure out if I'm missing an obvious tool everyone already uses.