Create a Report to display a list of attendees for an event

If you have Salesforce integration enabled for a given event that is collecting attendee information, you may choose to create a Report in Salesforce which provides a list of attendees for an event. This Report can then be linked to from the Campaign page layout for all Soapbox Registration Campaign Record Types.

This may have been setup as part of the Soapbox Events for Salesforce package installation process. If not, you may follow these steps to add it at any time.

NOTE: If this Report and button have been added to your Salesforce instance but it is not appearing on your Campaign layout, confirm that the Campaign record you are viewing is of type Soapbox Registration. If it isn't, update the Campaign Record Type and view the layout again. If the button still does not appear, review the steps below to confirm proper setup.

You may also wish to export a CSV file of attendees from Soapbox.

Create a report to display a list of attendees for an event

1. Go to the Reports tab
2. Click the “New Report...” button
3. Under “Select Report Type”, click the plus sign next to “Opportunities”, then click once on the “Opportunities with Tickets” option, and click the Create button/li>
4. For the Date Field range, choose “All Time”/li>
5. Click the Add button next to “Filters” to add a filter on the Campaign field, with an “equals” for the value c, and click the OK button next to the new filter
6. Remove any existing fields in the report, and then add the following fields to the report
   Ticket: Ticket Name
   First Name
   Last Name
   Email
   Account Name
   Purchaser
7. Click Close button, then Save & Close in the popup window
8. Use the following to name the report
   
   Report Name: Ticket List
   Report Unique Name: Ticket_List
   Report Description: List of tickets for a particular event
   Report Folder: (choose your folder as you see fit)
9. Save Hierarchy Level: (unchecked)
10. Click Save button

Create a button for Campaigns to allow admins to quickly view a list of attendees for an event

1. Go to Setup > Customize > Campaigns > Buttons and Links
2. Under Custom Buttons and Links, click the New button
3. Fill in the form as follows
   
   Label: Tickets Report
   Name: Tickets_Report
   Description: Takes the user to the Ticket List report with tickets associated with this particular Campaign.
   Display Type: Detail Page Button
   Behavior: Display in New Window
   Content Source: URL
4. Add the following in the main textarea at the bottom of the page, replacing <> matches the Salesforce “pod” (typically something like “na14”) in your Salesforce web address, and replacing <> with the Salesforce ID for the Ticket List report you made earlier.
   
   https://<>.salesforce.com/<>?pv0={!Campaign.Name}
5. Click Save button

Place the Tickets Report button on the Soapbox Registration Campaign page layout to allow admins to quickly collect view a list of attendees for an event

1. Go to Setup > Customize > Campaigns > Page Layouts
2. Click the Edit link in the row containing the Soapbox Registration Campaign Layout
3. Drag the Tickets Report button to the Custom Buttons landing zone on the page layout
4. Click Save button