Thank you so much for the SQL query there. I'm doing this all in excel with power queries and I need to learn SQL I think to do this a bit faster.
Two: Constant vigilance is required!
Yes. They constantly create new accounts and some change their patterns.
I've changed my strategy and have a immediate flag for some when they post and a flag within the last 12 hours before payout. I'm separating my lists and adding to them now.
Hey @patrice!
Thanks for all the work you do on this. I appreciate it's a never-ending task and key if we're not all to drown in the tide of over-posting!
I'm self taught with SQL but I've got to grips pretty well with it now. If there are any particular queries you want designed I'd be happy to help out.
Also would it help to have something automated? Not automated flags but just something that lists up certain types of behaviour and refreshes every now and again for you to then investigate? e.g.
I think that this is something we could facilitate through utopian given the range of skills here, although only if it's useful obviously. Let me know what you think.
Great work here!
I hope @patrice gets back to you because I think you've already done much of the graft on the SQL side.