Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

WHY DATA WAREHOUSE TAKE SO LONG TO EXPORT DATA?

Avatar

Level 1

It is already 48hrs. since I requested for the data but still I don't receive anything. Is there a way we can track it? It says In progress in the status. 

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @mikikagawamercado122620 

If you see data warehouse requests consistently take a long time, consider altering your requests to accommodate the following:

  • Use a segment containing a smaller sample of data: The less data a request works with, the faster it returns a report.
  • Run requests in 14 day increments or less: Smaller requests are processed faster than large requests.
  • Use fewer breakdowns: Many breakdowns in a Data Warehouse request exponentially increase the time it takes to process.

Please visit the following document to troubleshoot delivery times for DWH report and review other alternatives: https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/delivery-time.html?lang=en#d...

 

 

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

Hi @mikikagawamercado122620 

If you see data warehouse requests consistently take a long time, consider altering your requests to accommodate the following:

  • Use a segment containing a smaller sample of data: The less data a request works with, the faster it returns a report.
  • Run requests in 14 day increments or less: Smaller requests are processed faster than large requests.
  • Use fewer breakdowns: Many breakdowns in a Data Warehouse request exponentially increase the time it takes to process.

Please visit the following document to troubleshoot delivery times for DWH report and review other alternatives: https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/delivery-time.html?lang=en#d...

 

 

Avatar

Community Advisor

Also, if your report's date range is "This Month", you won't get the report until after this month has ended. So if you had set it up on 2 March, you need to wait till 1 April to get it.

Avatar

Employee Advisor

It depends on the amount of data and complexity of the report on how much time a Data Warehouse report will take to complete the request.