This feature is limited to users on the Pro plan or the Confirmed Festival Pass.

If you are participating in a festival that uses Red61 ticketing, such as the Edinburgh Festival Fringe, Melbourne Comedy Festival, Adelaide Fringe, Perth Fringeworld, etc, you can import your ticket data directly to your Confirmed dashboard, which will give you regular updates on the status of your sales, as well as allow you to track historical data.

Here’s a silent youtube video clicking through the steps:

If it looks blurry, click on the cog and pick 720p or higher resolution

• We need actual data coming from Red61, so make sure you have at least one ticket sold before setting up the tickets export
  

• In the main menu, click on Additional Settings → Ticket Data Import (if you don’t see the menu option, reach out to us to enable it).

• Add New Source

• Give the source some sort of name you will recognize it by later, e.g. <Show Name> <Festival, Year>

• Keep this tab open - we will need it later
  

1. In the left-side menu, pick New Report and in the report type look for “full sales breakdown” (the name changes depending on the festival)

2. Scroll down and click on Save for Later

3. It will ask for name - “Tickets for Confirmed” or something similar should do - this is just so you can recognize what’s going on later.

4. Once report has been saved, click on Schedule saved reports and then on the green New Schedule button

5. Select our newly created report

6. You can ignore start time/date, but please specify the end date - put it a week after festival end or such

7. For the Schedule Runtime section

   • Start time: 00:00

   • End time: leave empty

   • Run Time Interval: 15 minutes

8. Send To

   • Email address: head back to the Confirmed tab and copy the generated email address

   • Format: Comma separated values

9. Hit Add Schedule
   

1. In Red61 head to saved reports. Find the row with the confirmed report, click on the PDF dropdown (it doesn’t look like dropdown at all), switch to Comma Separated Values, and the click on the download icon.

2. Head to the Confirmed tab, and hit the Upload Sample CSV Report to Edit Mapping

3. Pick the file you just downloaded

4. Confirmed will ask you to provide which column maps to which field. In the dropdown, on the left side is field name, and on the right side a sample value from the file you uploaded

   • Leave Venue and Room empty unless you have several shows happening at the same time. If you do specify venue/room, make sure that the names there match the venue names you have in your venues tab

   • Show name most of the time maps to event_title

   • Date and time field most often maps to perf_date

     • The shows are matched by date and time, so make sure that the Red61 time and date matches whatever you have in Confirmed

   • Tickets sold - there seem to be several fields that might map. The sold_count_incl_ca seems to include comps as well

   • Ticket type - this is used to distinguish between different types of tickets, but the best we can do right now is concession_code

   • Your config should look something like this:

You are all set now. If things have worked properly ticket data should start streaming in about 30 or so minutes. The Red61 scheduler is not an exact device, so check the “last run” column in “schedule saved reports” tab to see whether it has run. If the report has run and tickets are not showing up, give us a holler at support@confirmed.show.