We'd like to find out which segment of our users is responsible for the most revenue based on a list membership. For reference, we have Shopify sending order information to Hubspot as Deals.
So I'd like to see a revenue report that says something like:
For time xx/xx/xx, we had this much revenue and this % came from members of ListA, this % perrcentage came form members of ListB, and so on.
You can't really serialise lists in a report like that unfortunatly. What you need to do is translate that segmentation to a contact or company property (it can still be list based but use workflows to add it to the required object) and then build a deal amount report based on that property.
I ended up doing a general Revenue report and the filtering it using List Membership and exporting to Excel, then changing it to the other list and exporting again, and so on. It's clumsy, but it works. I'll look more into your suggestion.
You can't really serialise lists in a report like that unfortunatly. What you need to do is translate that segmentation to a contact or company property (it can still be list based but use workflows to add it to the required object) and then build a deal amount report based on that property.