CVP Post call Survey - How to Run Reports

[abhilash2001]

Hello, any suggestions on how to run reports for CVP Post call survey from the CVP Reporting DB? 

[janinegraves]

It depends what information you're saving from the PCS app to the reporting server DB.

If you're using a Menu element (or a Form followed by a Decision element) then you can use the CVP stock App Summary reports, which have a count of the number of times the each exit state is executed. So you can determine the number of responses that selected 1, 2, 3, etc based on these exit states.

[abhilash2001]

Thank you. I will be using the menu element. Is there any special config I need to do to send the information from the PCS app to Reporting DB or will that be automatic? 

[bill.king1]

Hi, you could also save the data in UCCE like in Peripheral Variables for instance and report out of it that way, people often find that can be easier since your other UCCE data is there as well and it is SQL vs. Informix.

[david.macias]

Make sure you have CVP Reporting as a data source in your CUIC. Then you can create a report definition with a query like this:

select  varvalue+0 as SurveyScore  from 
 vxmlsessionvariable  
 where 
 varname = 'surveyOutput'

[janinegraves]

Note David's query will only work if you also do the following:

1. In the PCS Studio app, assign the caller's input from Element Data into a Session Data variable
2. and configure the inclusive filters through OAMP to be *.*.*.SESSION:sessionVariableName

[janinegraves · Accepted solution]

In the OAMP select each VXML Server and go into its Configuration tab. Select the two radio buttons for Yes. And configure the Inclusive Filters as *.*.nameOfYourMenuElement.* this is case-sensitive and you could use up to 1 wild card in the name of the element here, of specify the name of the one element (you should NOT configure *.*.*.*)

Then Save and Deploy, and then restart VXMLServer.

[abhilash2001]

Hello everyone, thank you so much for all your support. I will deploy this and let you know how it goes.