Expand my Community achievements bar.

Workspace - Downloading more than 400 rows

Avatar

Level 3

11/5/18

Hi,

Currently we are able to download only a maximum of 400 rows at a time, although we can see additional records when we are logged in. It will be helpful if Adobe can add a feature so users are able to download more rows. Especially now that Adobe AdHoc being sunset, users are having a challenge with the limitation of the number of rows that can be downloaded from Freeform tables in the Workspace projects.

Thanks!

12 Comments

Avatar

Employee Advisor

7/28/23

@MaheshKo1 - happy to help!

 

I won't lie, it was a bit of a pain. There's nothing in the UI to help solve for this, so you have to get a little bit creative with Calculated Metrics and Excel. Ideally, you just use Adobe Analytics Data Warehouse (https://experienceleague.adobe.com/docs/analytics-learn/tutorials/exporting/data-warehouse/introduct...)to do this. But if you can't, here's my convoluted solution.

 

In short: I ended up building a calculated metric to help me filter to the next 50k rows, then sorted by that metric.

 

I noticed that my first 50k rows of data ended somewhere in the middle of having 13 Occurrences per dimensional item.
Here's the last rows of my CSV Export of the first 50k rows:

Eric_Matisoff__1-1690558291990.png

 

So I deleted all the CSV rows that had 13 Occurrences in them, since there's a chance there were additional rows of data with 13 Occurrences that didn't get exported.

 

Then, I created a Calculated Metric that had an IF statement in it to filter to just dimensional items with 13 Or Less Occurrences:

Eric_Matisoff__2-1690558430440.png

I then added this Calc Metric to my Freeform Table, sorted by it, and ... ouilah! My next 50k rows were ready to download.

 

For my use case, I actually had 213k rows to download, so it was a bit of rinse and repeat on the above. But hey - now I have an enormous CSV

Eric_Matisoff__3-1690558521931.png

Hope that helps!