Download More than 400+

[skatofiabah]

Hi,

Is there a way to download more than 400 rows from a workspace table?

[Jennifer_Dungan]

Yes, you can actually download up to 50,000 rows of data by right clicking on the dimension, and selecting "Download items as CSV"

This will not include any breakdown data, so if you need that, this won't help you.

[skatofiabah]

Hi @Jennifer_Dungan,

What about the Download selection as CSV? Will that download breakdowns and download all rows of data/all data? Or is there no true way to do that in workspace freeform table?

[Jennifer_Dungan]

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...

[MandyGeorge]

As Jen said "download item as (item)" is your best way to get up to 50k rows directly from your table.

If you do need more than that, you can use data warehouse. It doesn't let you download the table directly, you essentially have to recreate the table in a data warehouse request. But there isn't a limit to the number of rows that it can pull.

[skatofiabah]

Hi @MandyGeorge,

How do you create a data warehouse request and is that different from FTP file send or request? If so, how are they different?

cc @Jennifer_Dungan 

[Jennifer_Dungan]

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:

Page	Page Type	Canonical URL	Page Views	Unique Visitors	Visits
a	section	https://www.domain.com/a/	5345	335	678
b	section	https://www.domain.com/b/	4783	278	589
c	detail	https://www.domain.com/c/detail/	3658	188	378