You want to report on the e-mail of the Social Channel used in Tickets, however there is no option available at Reports.
Reproducing the Issue
- Go to Administrator work center.
- Go to Service and Social view.
- Under Communication Channels, select E-mail Addresses.
These E-mails are not showing up in any report.
This is currently a system limitation.
In order to show the Social Channel's, you can use Data Sources SEODSRQTIMEB01 and SEODSRQTIMEB02 (All Social Media Inbound Tickets and All Social Media Tickets), however the E-mail is not going to show up as this is currently a limitation.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To