Open Forum

Has anyone else struggled with the way survey reports are generated? I had around 80 sessions, so the spreadsheet I received had 80 tabs, which is fine except that...

• I had to go through and name each tab so I know which session it was for.
• The headers for each row are actually in row 5, so there's not an easy way to generate graphs/etc without first deleting the top 4 rows. I have to do that on 80 tabs.
• The numbers for the responses (1-5) came through as text, not numbers, so I had to do a huge workaround to convert them all to numbers so I could do something as simple as highlighting a row to see the average.
• The speaker name is not included in the output, so I'll need to add that in for each tab as well if I want to see speaker data at a quick glance.
• I'd love to be able to run a report on a speaker who taught multiple sessions so it is all together in one sheet instead of multiple tabs.

Am I missing something in the setup of the report to make my life easier when I try to create visual graphics of the data? Would love any help anyone out there can offer!

#ReportingandInsights

------------------------------
Jen Howver
Training Manager
Christian Camp And Conference Association
------------------------------

Hi Jen,

Thanks for your question. You're not missing a hidden setting-the multi‑tab export you used is a detail‑style Session Feedback report that's great for auditing but not ideal for quick analysis, which is why you're getting 80 tabs, headers on row 5, text‑formatted ratings, and no speaker name field. Instead, use Cvent's comparison and dashboard reports that keep everything on one sheet and already include session and speaker fields plus averages-especially Session Feedback Dashboard, Session Comparison Details, and Speaker Feedback Dashboard (or Cross Survey reports if you're on Premium Surveys). Those give you cleaner, consolidated data you can filter or pivot by speaker without manual renaming, row deletion, text‑to‑number conversions, or adding speakers tab by tab; only if you absolutely must use the existing multi‑tab export is it worth automating the cleanup with Excel macros. Hope that this helps!

Julianna 

------------------------------
Julianna Hampshire
Lead Customer Success Advisor
SalesforceGenericAccountUnited States
------------------------------