How to schedule a report from adobe analytics to include all the items

[user87585]

Hi there,

We’re currently trying to schedule a report from a workspace that includes two panels, each containing thousands of items. Right now, we’re downloading them manually via the “Download items as CSV” option, since the scheduled reports only include the first 50 items per panel.

I’m wondering if there’s a more automated way to export the full dataset from each panel. Any guidance would be appreciated!

[harishkumar]

@user87585 as per the current feature available, you can download using "download item as csv" only. Its not possible to exact all data in panel in excel within workspace. 

You can utilize Adobe analytics APIs to get data, you can get the API call code by clicking on "Help" Menu-> Debugger. It will enable spidder on each visualization and you can get the API code to extract the data. This will be more customized solution rather than direct option. 

[MandyGeorge]

My suggestion would be to use data warehouse. You can customize the table with the dimension items and metrics that you need. Then you can schedule it. It sounds like you're trying to pull this data on a regular basis. You can schedule the report to send to your email automatically, or drop it to another location, there's a few options for delivery.

In workspace it's going to be much more difficult to get all of the rows that you need, and it's way more manual. You can automate the process with data warehouse.

[Jennifer_Dungan · Accepted solution]

Depending on the complexity of your report either the API or the Data Warehouse might suite your needs.

There are potential issues with both...

The API won't handle breakdowns, if you need them; unless you run additional API calls for each breakdown.... this can get intensive.

Data Warehouse on the other hand is good for simple reports, but it essentially a flat table... with no de-duplicated totals, and it doesn't allow for stacking segments and metrics in individual columns...  This can make things challenging, particularly if you are trying to pull UVs or Vs... 

The third option is to use Raw Data feeds, and to process all the raw data... but this is a huge undertaking, and is probably not the best option, as this would be a huge project to replicate all the exclusions and UV/V calculations.

No matter which option you choose, you will have to be mindful in your approach and ensure that you can replicate your Workspace properly.

[PoornimaThakur5]

Hello @user87585 ,

I recommend one of these three options:

1. Report Builder (Excel): Connect Excel to Adobe Analytics to pull full datasets (not just 50 rows). You can schedule updates, set large row limits, and use Excel macros to automate refresh and email delivery.

2. Adobe Analytics API: Use a script (Python, JS, etc.) to extract all data, automate daily/weekly runs and save or send the file as needed. Ideal for teams with coding capability who want scalable automation.

3. Split Tables in workspace (Last Resort): As a workaround, break your large table into smaller ones (e.g., by region or category), each showing 50 rows. Then schedule them together. It’s manual but helps bypass the limit in Workspace reports. 
Considering the challenges @Jennifer_Dungan has already mentioned, I would personally go with Report Builder option!

Let me know if you have any follow up on this!

[Sukrity_Wadhwa]

Hi @user87585,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!

[Vinay_Chauhan]

I've dealt with this too. Right now, scheduled reports from Workspace only send the top 50 rows per panel, so if you’re working with large sets of data, it’s not ideal.

The “Download items as CSV” option is still the only way to get everything straight out of Workspace, but yeah—it’s manual.

If you want to automate things, you’ve got a few other routes:

• You can use the Adobe Analytics API to pull full datasets and set it up to run on a schedule.

• Data Warehouse is another good option—it lets you export much more data, and you can schedule those reports too.

• And if you need every single data point (like hit-level info), you might want to look into Raw Data Feeds, which send data directly to cloud storage like S3 or Azure.

Each option depends on what you need and how your setup looks, but there are ways to get around the limits in Workspace. Let me know if you want help figuring it out.