Hi Christoph, Yes, it’s definitely a great idea to leverage community data in a deeper way to understand performance and show value. Khoros has a Bulk Data API that returns the full feed of data from their event logging framework. Reach out to your account folks for details on that. You could do a pull from the API to get the latest data when someone looks at the dashboard, but it’s not a very scalable solution and is probably a bad user experience because of the time required for the request, pull, and live updating of the dashboard. Instead, you should do a regular (nightly, etc) pull of the data and load it into a data warehouse somewhere. This also gives you the opportunity to prep, cleanse, and blend the data with other business data to give you much richer insights. From there you can hook up Tableau and do some visualization.
... View more