So I've been using a self managed solution (Funnelflux) and the client service (super nice) and dev team are trying to figure out the issue but its been a while and the problem still persists so wondering if anyone had a similar issue or any clues? As you can imagine this is causing me a lot of heartattack moments as 100+ conversion can be missing for a few hours in which I have to manually check the discrepancy to make sure it is not an infrastructure issue e.g. faulty offer/landers.
Problem seems to be that my conversions don't show up on the front end until at least after an hour delay and it gets worse during peak hours. I've cross checked this with my aff network's tracker (more than one as well) where all the conversions show up and seems that the postback was sent just that it can't be seen in my front end UI.
I've tried to ugprade my server which support says should be fine and the backend of the tracker seems to be working mostly since the traffic costs get logged quickly and the conversions are being posted back to the traffic sources as well etc. Suspect its some issue betwen the jobs that are pushing the data from backend to frontend which is being delayed or stuck. Kind of at wits end here and have even looked into changing trackers but would prefer to if I can help it since I've built custom code on top of the tracker and its just a hassle to move things. If anyone has any suggestion or clues would appreciate it. Thanks.
My guess is that the postback to the traffic source might be handled by a different segment of the tracker's code than updating the UI which causes the delay. Might be how the team coded the priority of the queues (I mean front end UI being the lowest priority is probably correct since it doesn't impact the actual conversion but its causing usability problems). Also to add that I updated my server and the load seems to be manageable so not sure why the significant delays...
Uploading 1 or 2 conversions get updated but its not immediate (since it queues the job).
I've also segmented my traffic by time/day as well and I expect a discrepancy of 2-3 conversions should be fine but when it averages 30-40 and can reach 100+ in peak hours, doesn't seem like a slight timing issue.
Also final note is that day before's conversion is usually 90%+ there which means that the conversions aren't lost at least, just appears to be some issue with the queuing of tasks?