How do you track which affiliates actually make money
so I've been running a tiktok shop affiliate program for a few months now and I'm honestly drowning in data, like I have spreadsheets of creators I've reached out to, some of them posted, some of them got samples and ghosted, and I have no idea who actually made me money versus who just wasted my time and product and It really feels careless and I feel like I'm lacking behind something everytime.....
I'm sending out samples to like 50 creators a month but I can only track like half of what's happening because everything is scattered between dms, email, my notes app, and about the actual sales data, I don't even know which creators are posting consistently versus which ones were just a one time thing.
now what I think is that the problem is that I can't see the full picture, like I don't know if creator a cost me more in samples than they made back in revenue, and I don't know which creators would be worth reaching out to again versus which ones I should just forget about, I'm basically just guessing at this point....
I feel like there has to be a better way to organize this stuff and actually see which affiliates are performing versus which ones are just bleeding my budget
like I really wanna know how are you guys managing this, so like do you manually track everything or is there a system that actually shows you the journey from outreach to sample shipment to post to revenue because I have seen some systems that are helpful but right now I'm just winging it and it's killing me.