all AI news
Identifying bot traffic with SQL
Web: https://towardsdatascience.com/identifying-bot-traffic-with-sql-3327c893bdb2?source=rss----7f60cf5620c9---4Phillip Glickman
Web data usually includes bot traffic of some kind. Whether it’s an automated test user or an unwanted web scraper, you’ll want to remove them from your data before using it for reporting or analysis.
This SQL query is a quick and easy way to systematically identify non-human browsing behavior so you can spend less time cleaning data and more time doing the fun stuff.
What data do you need
You’ll need a dataset that represents …