Customer Response to a Survey

[Former Member]

Hi,

For email campaigns we need to store the survey responses of each customer in the target list.

The business scenario is that on receiving an email campaign, the prospect/customer clicks on the survey link URL, submits his responses to the survey and sends back. These responses are stored in SAP CRM. I want to know how and where these responses are stored for each customer.

I think this will be a standard feature. Would appreciate an answer from the forum.

Thanks,

Pankaj

[Former Member]

The surveys are actually stored in CRM as Hex/XML. (crmd_survey, crm_svy_db_sd) There are a couple of function modules that you can use to help parse out the survey answers and display how you want.

CRM_SVY_DB_CONVERT_HEX2STRING, CRM_SVY_XML2TAB, CRM_SVY_DB_SVS_READ_SINGLE. You just need the header guid from the order to get the right one. If you do it right

you will get a table that has the question text, the answer text, and the answer identifiers.

Hope this helps

-Jeff-

[Former Member]

Hi,

When I execute function module CRM_SVY_XML2TAB I get a dump with "Access with 'ZERO' object reference not possible".

I try to execute it with a valid XML value. Did this happen to you?

Another thing, I need to load questions answers in my CRM activities. Those answers will return in a txt file. Do you know any BAPi or function module that I can use for that?

Thanks a lot

[Former Member]

Hi,

I am also getting the same error.

Please help if you were able to sort it out!

Regards

Atul

[Former Member]

If any body got the answer  please let me know.

[gregorw]

Hi Pankaj,

you're right, it is a standard feature. The submitted surveys are saved as activities with the survey attached.

Regards

Gregor

[Former Member]

Hi Gregor,

Thanks for the reply. Have a few more queries.

Is it possible to capture the the customer responses without creating an activity or a lead? The idea is to capture the customer responses without creating any transaction.

Also, there is an "Evaluation" button in CRM_SURVEY_SUITE. Is it a case that if I click on this button, then I get to see the survey result for each customer to whom the survey had been sent. Riight now, with the current setting of our system, when we click on this button the message that we get is "No Data for Evaluation". Would appriciate if we can have a step-by-step procedure to have this as well.

Thanks,

Pankaj

[former_member927251]

Hi Pankaj,

You will have to create a transaction to capture the Customer Response.

Why are u hesitating to create a transaction ?

It would be very easy to capture and retrieve the data from transaction. You can use <b>CRM_ORDER_READ</b> function module to retrieve the transaction data.

There is also a report CRM_ORDER_READ which uses the CRM_ORDER_READ function module internally.

<b>Reward points if it helps.</b>

Regards,

Amit Mishra

[Former Member]

Could you explain step by step to create a activity for customer response?

Specially I wonder these.

1.in creating survey, which application should I select, marketing or activity?

2. in IMG setting for survey determin. in activity,

how and what should I input and if I intend to use campaign to send e-mail, how?

Please help me.