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

Related Articles:


App: EZ Exporter

Tags: analytics, sessions, shopify analytics, shopifyql