We've Moved!
Please note that we have moved to our New Forum site.
How to create a custom report in GI2 with a few key measures?
We've recently deployed Interactive Insights and I'm looking to create a single report which exports to .csv so I can combine the data with other sources. Here are the historical activities/measures I'm trying to report on:
- Count of inbound customer email interactions that entered the contact centre
- Count of email interactions that were completed with a response to the customer
- Count of email interactions that were completed with no other action required
- Count of active email interactions
- Maximum age of active interactions
I've pored over the out-of-the-box reports and the GI2 user and universe guides, but its not obvious to me that these specific questions can be answered by the existing measures. The available measures in GI2 seem to answer questions that are LIKE the above but not precisely the same. For example, I can create a query in GI2 against the Business Attribute class and aggregate the number of 'Entered', 'Finished No Response' and 'Finished With Response' email interactions. But the 'Finished' count seem to be a subset of the interactions that 'Entered' on that da. This is different to what I want, i.e. I'm looking for the count of completed interactions on a given day, without respect for when the interactions entered the contact centre.
If anybody could help me understand how to report on those specific measures above that would be most appreciated. Or at least let me know whether it is even possible given the way data is structured in Info Mart.
Thanks!
Liam
All