Download More than 400+

I believe that "Download selection" is based on what you actually have selected in the Workspace...

So if you have the totals row selected, only that will be returned... if you have 7 rows selected in the table, those 7 rows will be returned...

So unfortunately, that would then limit you back to what you can see in the UI, which is limited to 400...

Now, if you do need breakdowns, there isn't going to be an easy way to do this... I think the option left to you is to use the API... but unfortunately, the way API 2.0 works, you have to make a call for each breakdown separately...

So if you have 1000 rows, and each of those is broken down once each, I think you have to make 1000 requests for each of those breakdowns, then another request for the "top level"... so 1001 requests in all...

Data Warehouse (found in Tools > Data Warehouse) is basically a "flat table" export tool.

You can curate your columns of dimensions and metrics and get the file as Excel, CSV, etc.

You can apply segments to the entire table (not to individual columns, though interestingly, you can now add segments into the dimension breakdowns... but again, they will apply to all the data, and pulling multiple segments as dimensions will make them nest.. I don't know how this comes out in the final file, I've never used that functionality within this tool)

Some caveats to this, however, are:

• "stacking" metrics, like Visit or Unique Visitor will count on each unique row, but there is no de-duplication for the total, so the risk of over-counting could be likely depending on what you are trying to do
• If you are exporting list data (lists, props with lists enabled, products), each unique value in the list will create its own row, so even non-stacking metrics like Page Views could be inflated

You build the request like this:

which will result in a flat table like: