I'm looking for a extension to export/report the revenue per category and per shopview.
Try Freento Analytics & Reports service for Magento 1. Magento 2 version is comming soon.
it allows to see different reports, including report by categories.
It has clear filters with ability to filter any report by store.
It's free for now.
There’s a number of great tools out there for this type of reporting! Ultimately, it depends on the how you’d like to interact with a reporting tool and what sorts of insights you are looking to access.
A number of existing extensions and low-cost third party softwares will offer basic revenue reporting and segmentation with minimal customization. These types of tools are great for a high-level snapshot of the business.
If you’re looking for further customization like the ability to create custom segments and analyze conversion and revenue across across various sources like google analytics, your ad spend, and your magento data, you may want to consider a full-stack Business Intelligence platform. These platforms ultimately provide more in-depth reporting and scalability, but come with an added cost.
In your ideal world, how do you see yourself creating and interacting with internal reports @webm_nickey?
That's exactly what Exto Analytics does: https://exto.io/analytics-for-magento-2.html
It's a free product, enjoy!
For your request, I am not sure about report per category in Magento 2 or Magento 1. And in my answer also for both Magento 2 and Magento 1. You can use Advanced report for Magento Store.
Hope you have a wonderful experience with this extension. If you have any question relate this extension or other Magento Extension on Landofcoder, pls feel free to contact us and our dev help. Thanks a lot,