
Sample Query for Tracking Bot Traffic by Yousuf Bhaijee
ChatGPT and Google AI (SGE) may start eating your content and traffic without you knowing. You can avoid being blindsided and adapt if it happens by
explicitly tracking bot traffic.
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:
SELECT
visit_date AS Date,
COUNT(*) AS "Count of Visits",
Sign up to see more
Create your free account to view the full artifact
Have an account? Sign in
By creating an account, you agree to Reforge's Terms & Conditions