How can I exclude bots from my Shopify Analytics Sessions reports in ShopifyQL?
In your ShopifyQL query, you can add the following condition in the WHERE clause to exclude sessions that Shopify detected as bots:
human_or_bot_session = 'human'
This filter will only include sessions that appeared to be "human".
For example, to generate a report of Sessions by hour which excludes bots, you would use a ShopifyQL query like this:
FROM sessions SHOW online_store_visitors, sessions, pageviews WHERE human_or_bot_session = 'human' TIMESERIES hour SINCE startOfHour(-24h) UNTIL now ORDER BY hour DESC
App: EZ Exporter
Tags: analytics, sessions, shopify analytics, shopifyql