Currently I can pull bot name as a dimension and bot pageviews as a metric in Analysis Workspace. And I can pull IP address or user agent in Data Warehouse. But I can't pull bot name or bot pageviews in Data Warehouse and I can't pull IP address or user agent in Analysis Workspace (at least out of the box) and breakdown bot name by IP.
I would love the ability in either Workspace or Warehouse, (but ideally both), to be able to breakdown bot name by IP address/user agent, but right now there's not a great way to do that.
Customer care confirmed this was the case.
Here's a brief summary of our discussion for future references:
You were looking to pull out bot reports in Data Warehouse. I informed you that its not possible as bots are excluded from the reporting. The Bot reports are only available in the Workspace and that too, separate from rest of the report suite data. Further, you wanted to enquire if its possible to pull out Bot Reports with IP Address or User Agent. Unfortunately, there is no reporting engine that will give us Bot data with IP Address or User Agent. I suggested to raise this in Experience League Community as a feature enhancement.
