Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

Adhoc Analysis : Get around the 50000 row limit


Level 2

Hi Everyone,


I am trying to pull a report which has three breakdown levels: Week > A custom Value > A custom segment. The issue I am running into on Adhoc analysis tools is that it is displaying only 50000 rows in a single instance and if I need to look at all the rows in my data I am having to manually click on each of the buttons to expand for a full view. Even exporting the report displays data in the same fashion.

Is there any way to get around this? I've tried using the report builder, however, I ran into an issue with that tool as well where I cannot add the segments as dimensions in the report.

Any help on this would be greatly appreciated. Please let me know if you need any more info.



4 Replies


Community Advisor

Hi Akshat,

To have the dimensions broken down by other dimensions without manually clicking on them, you may want to use the table builder configurator where you should be able to set how many lines need to be broken down and how many lines of each dimension should be displayed.

However, if you are looking for a way to export more than 50k rows, AdHoc Analysis is not designed for that. You may want to use Data Warehouse instead.


Level 2

I tried using the data warehouse to get the data needed. However, with data warehouse I am unable to breakdown the data in the same format as I am able to in Adhoc analysis. Also, in Adhoc analysis I am able to track occurrences as a metric but with the warehouse I do not see that option in the metrics.


Level 2

I tried increasing the breakdowns in the Table Builder tool but even if I select the breakdown to be 100 it still only breakdown the first 10. That is the major concern I am having with Adhoc Analysis.


Community Advisor

Could you attach a screenshot with the table builder configuration?

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now