Can we extract (CSV) more than 400 rows in Adobe Analytics "Workspace" ? | Community
Skip to main content
D
DylanAm75
October 6, 2020
Solved

Can we extract (CSV) more than 400 rows in Adobe Analytics "Workspace" ?

  • October 6, 2020
  • 3 replies
  • 8680 views

Hello everyone,

I tried to figure how to extract to CSV excel, more than the 400 rows broadcasted in the Workspace display tables in Adobe Analytics. The thing is, I can't go more than 400 rows...

Concretly, I need to extract data (it's web traffic per minute) from past 3 months. So, that represents a huge numbers of raws. 3 600 minutes per day (400 rows per extract), that's 4 extracts per day, multiplicate per 90 days = 360 extracts... knowing I have to grouped them in one unique file.

Does someone experimented the same issue or know have to upgrade this number.
In "Report" view, the more granularity time data is per hour, and I absolutely need minute.

Thanks a lot for your help.

Dylan

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by PratheepArunRaj

Hello Dylan,

You can now download more than 400 Rows in Workspace using 'Download Items as CSV) on your Dimension Right Click. The August 2020 release has the notes and the detail to download the same. Check out the link here.

Thank You!

Arun.

3 replies

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 6, 2020

Hello Dylan,

You can now download more than 400 Rows in Workspace using 'Download Items as CSV) on your Dimension Right Click. The August 2020 release has the notes and the detail to download the same. Check out the link here.

Thank You!

Arun.

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
J
johannesh949335
February 23, 2022

This is NOT a solution. 

W
webanalytics838
October 28, 2021

Hello Dylan, 

 

If you have a consistent time to pull the data to a csv and want it sent in an email, this sounds like a Data Warehouse answer. You can set up a report to pull once a day at midnight. Might take a little work to get it tuned correctly, but that would be the route I would take.

L
Linda58
Level 3
October 28, 2021

I'm not really sure if you are replying to Dylan or to me (Linda58) for my post back to Arun... but the way I use it, Data Warehouse does not work either because there is no ability to "sort by"  in Data Warehouse, so you end up with ugly reports that are automatically sorted in the order Data Warehouse wants to sort them in. Adobe does not give us the control that we need in either Workspaces or Data Warehouse. 

J
johannesh949335
February 23, 2022

You can download up to 50,000 by right clicking on the table: 

https://experienceleague.adobe.com/docs/analytics-learn/tutorials/analysis-workspace/curate-and-share-projects/download-50000-items-as-csv.html?lang=en

 

No thanks to Arun...

Terms & ConditionsAccessibility statement

Loading footer...