Three quarters of the clicks past our bot flag were one crawl

Up front, I build and run affiliate sites for other people as a paid service, so a click count is something I hand to someone else, and I am not neutral about it being right.

We log every outbound click ourselves instead of reading the network report back, one row per click carrying product, address, signature and time. That decision is what made the rest visible. On one UK tag the report handed me a count of 1,375 and nothing underneath it.

On the site I run myself that table holds 16,976 rows. The flag marked 11,155 of them and left 5,821. Bucketed by day, 4,336 of the survivors sit inside one three day window in August, reaching 674 products from 768 addresses. That is a crawl, and no total would ever have said so.

So the flag is not the number. How clicks fall across days, and how many addresses touched how many products, is what I read before quoting a total, and that is what the row level table is for.

If you keep your own table, what makes a row trustworthy to you?