Sample Query for Tracking Bot Traffic by Yousuf Bhaijee
Example ChatGPT Query
How to Track Bots
Here is a starting point to set up tracking:
Parse “user agent string” in your website log data. You probably can’t do this in Google Analytics but you can with SQL or a BI tool. Track by ChatGPT, Bing, and Google bot visits per day by page. If bot traffic starts to go up for certain pages, figure out what searches are associated (Google Search Console) and then see if you are showing up in the AI Generative Results. If not, start experimenting. Knowledge is power.
Some starting SQL to adapt:
visit_date AS Date,
COUNT(*) AS "Count of Visits",