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!
I searched the forum for similar topics but only found threads which were from at least 4 years ago and also without solution. As I have to export reports on regular basis, it would be more than helpful if the reports could be exported in xlsx-format. I think that many users would appreciate this feature, as Excel is still a standard tool.
Thank you for your reply Brandon - and for the tip about downloading an individual table! This is very useful.
One thing: I noticed that the csv does not contain a first row with the column headers (Metric names). Could this be added?
Strangly the table I exported contains a dimension breakdown (Referrer --> Entry Page) and the csv does contain one row for the broken down referrer where all metric headers are shown. And under that a row shows with the name of the breakdown dimension (Entry page) is shown --> see screenshot:
The missing metrics at the top seems odd (they should be there) - please submit an issue with Customer Care and we'll look into it. I think the breakdown dimension is correct, but we can look into that as well. Thanks again for the feedback.
I found out that I double-clicked on the wrong cell (one row too low). Should have double-clicked the empty cell to the left of the metrics to select everything. so all is fine with this now!
We are going to make an update to CSV downloads (and Copy/Paste from Workspace) to remove the thousands separator. We will continue to respect the decimal separator as defined in Components > Report Settings. In addition, the UI will continue to show the thousands separator.
The CSV updates were delivered as part of the Apr MR. We are going to mark this as Delivered. If there are still open needs that require downloading to XLSX, please file a new idea with those details listed.
Hi Patrick, not sure if this is still relevant, but the company I work for (Daexus) released an Adobe Analytics web data connector for Tableau. It's free and ultra-secure and supports scheduled refreshes like you mentioned but that feature is available in the paid version.
You can find more information on our website and I'm more than happy to answer any questions you might have!
