I've been looking around but have been having difficulty finding how to batch export raw data reports from Adobe Site Catalyst.
I have a Servers report, with about 18,000 servers on it. Each of these servers have unique visitor data that I'm trying to access so that I can view the data across time in order to discern which sites should be shut down. The problem is, my access is limited.
When I am at the report page, and I click on the download, I only get the handful of results on the page. And on top of that, it aggregates the unique visitor data, so I can no longer see how it changes with time.
I can do each server individually by clicking on the server name in the report, and going to 'site metrics -> instances', and then downloading the data via the download button. However, I have over 18,000 sites. Crunching this all manually would take some time.
Ideally, I'd like to be able to pull the data down into a form like this, with the date on the y axis, and the sever name on the x axis, and all the unique page hits as the data.
Even if I can't get it in the ideal format, is there any other way I can pull all of this data?
I'm new to Site Catalyst, is this even possible?
Firstly, when you click on the Download link on the report, there's another Advanced Download Options link you can click. This will give you a popup for additional options, including increasing the number of rows to download, which is 50,000 rows maximum via this method (though the download may possibly fail from a browser request timeout depending on how many metrics you have included on the report...)
Alternatively, you can export data (no row limit) from Data Warehouse. When you login to Adobe Analytics, at the top left is a triple-horizontal icon next to the "Adobe Marketing Cloud" logo. Click on that to toggle open the left-hand menu rail. Navigate to Analytics > Data Warehouse. If you do not see it there, then your contract with Adobe may not include it, or your login account may not have permissions to access it, or both.