Symptom
When exporting the Lead Survey Results, the Lead description is shown in the Excel file, but not the Lead ID.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Surveys > Surveys.
- Open any.
- Go to Results tab.
- Click on Export button.
- In the Excel file opened, see there is no 'Lead ID' column.
Cause
It is currently not possible to customize the Survey export results for any business object (Leads, Opportunities, etc.). Therefore, adding the Lead ID or any other field/data, is not possible either.
Resolution
This would the expected system behavior.
However, as an alternative, business can create a report based on standard data source CODMKLEASVYAWB. This data source has the Survey Question and Answer, the Survey ID, Lead ID and many more fields to be added.
To see all the available fields for this Data Source (or others), please check: Complete C4C Data Sources Documentation
See Also
Similar requests have already been raised by customers in the past:
Community: survey: excel export format
Customer Influence:
Keywords
Lead name, Sales Order, Sales Quote, Opportunity, Satisfaction Survey, sheet, customizable, editable, changeable , KBA , LOD-LE-SUR , Survey , LOD-CRM-OPP , Opportunity Management , LOD-CRM-LM , Lead Management , Problem