The DES contains behavioral data and the API contains static data - like a Group name, URL and total views. This can be a little intimidating. At the risk of unbridled self-promotion you could use our Product - InSite for Jive - to create exactly the report you want. InSite pulls all the DES and API data from Jive and presents to you in an easy to manipulate query-by-example interface. We also do more complex queries (we call them Custom Views), run Direct Message and email campaigns off the same data, and can export the data to enterprise data stores, like Tableau.
More info about InSite is here: InSite for Jive: Analytics and Campaign Automation for Employee and Customer Communities and on our corporate website: 411Labs, Inc
If you are interested in more info on InSite I can do an online demo for you. It takes about an hour.
Say hey to Rachel.Happe for me.
Thank you for the feedback Ben. We'll take a look and I'll let you know if I need more. Rachel (and Jillian) say hey back. :-)