Workspace - Downloading more than 400 rows

Thanks @ericmatisoff 

@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/introduction-to-data-warehouse.html)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:

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:

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 💪

Hope that helps!

@ericmatisoff 

Not sure how to make a second request for more than 50K records.

Please guide me.

Thanks,

Mahesh

@ericmatisoff 

Yes!  Thank you for that insight using Ranking.  Cheers!

Hi @shawnangle ,

Report Builder has a maximum of 50k rows per request. You can do a second request for 50,001-100,000 if you'd like 🙂

@gabrielchiararia , @srujanam558322 - you'll be happy to hear that Workspace has upped the number of downloadable rows to the first 50,000 rows in a Freeform Table! Details here: https://www.youtube.com/watch?v=-WrFXrNS0NQ&list=PL2tCx83mn7GuRKH3CsPifBcv77UOBYPfT 

@ericmatisoff 

Hello Eric, 

I'm using Adobe Report Builder and I am only allowed to download 50,000 rows of data...or so it appears to me.

Can you tell me how to download more rows using Report Builder?

Thank you,

Shawn

Hello Eric, 

I'm using Adobe Report Builder and I am only allowed to download 50,000 rows of data...or so it appears to me.

Can you tell me how to download more rows using Report Builder?

Thank you,

Shawn

Hi @gabrielchiararia  Gabriel - I absolutely remember you. I'm glad to see you've landed somewhere that you get to apply your experience from the Analytics Challenge! That's better news than the Metallica album - it was just okay 🙂

Regarding downloading >400 rows of data:

- We have it on our roadmap to bring this functionality to Analysis Workspace (more details here: adobe.ly/aadiscoverworkspace)

- In the meantime, you can extract >400 rows of data using the legacy Ad Hoc Analysis (formerly called Discover) tool, or by using Report Builder (our Excel plugin), Data Warehouse (which exports to CSV), or Data Feeds (which are significantly more granular than Workspace)  products. 

Hope that helps! Good luck with the analysis!

@ericmatisoff 
Hey Eric, we met at the Adobe Analytics Challenge in 2016. I was representing BYU and got 3rd place. I remember you were pumped about the new Metallica album at that time.
Guess what? I'm currently using Adobe Analytics in my current role and need to download more than 400 rows of data urgently. Any idea how to do that?

That’s great to hear and our team will be very happy to see this. Any idea when this will be available? Thanks!