How can I exclude bots from my 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