Support

Home Forums Event Espresso Premium How to retrieve data on ticket redemptions

How to retrieve data on ticket redemptions

Posted: December 15, 2015 at 5:27 pm

Viewing 5 reply threads


Richard Ballinger

December 15, 2015 at 5:27 pm

I have been using Event Expresso for several years now for carnival events where we sell unlimited ride armbands online for our events. The ticket is valid to be used once during the duration of the event with is 30 days long.

I can’t find any way to see how many redemptions I have made each day. This is very important data to us. We ca clearly see the number of sales and when they happened, but redemption is not clear.

Any advice or information on how I can produce a report each day of the carnival to show the number of tickets that were redeemed that day would be invaluable to me and my client.


Lorenzo Orlando Caum

  • Support Staff

December 16, 2015 at 12:02 pm

Hi Richard,

Are you referring to the number of check-ins / scans that occur? If so, you can find that information under the Attended column which looks like this:

http://cl.ly/2x0e1g3z0i2Q

However, there isn’t a report for check-ins per day.


Lorenzo


Richard Ballinger

December 17, 2015 at 2:28 am

Thank you for your reply.
Yes it would be valuable to have clear data on the check-ins as the way we use them lets us know numbers who attended each night.

At the moment we can see sales , how many , which days, but there is nothing in the reports to show redemption, .i.e. check-ins In our senior it doesn’t work breaking every day into different event as people re-purchasing don’t always know which night they will come or due to weather change their mind and come another night. This is why we have it as one long event.

At the moment I have to manually keep a check list to count up the number each night. In V3 the Statistics were so much more in-depth, I was able to see this information.

I hope you will look at improving this in future updates.

Sincerely,

Richard Ballinger


Tony

  • Support Staff

December 17, 2015 at 2:53 am

Hi Richard,

Which version number of Event Espresso are you currently using?


Richard Ballinger

December 17, 2015 at 2:57 am

hello Tony,

Im running Event Espresso 4.8.27.p

Cheers,
Richard Ballinger


Josh

  • Support Staff

December 21, 2015 at 10:15 am

Hi Richard,

The data you’re looking for is in the _esp_checkin table of your database. The last column in there is CHK_timestamp. So one way to generate a report with this date is do an export from PHPmyadmin into your preferred spreadsheet app’s format.

If you’re looking to add specific per day reporting right within the Event Espresso UI, this could be done with some custom PHP programming. One of the pros listed on our recommended developer page should be able to write a quick add-on that pulls that data into an at-a-glance report to your exact specifications.

https://eventespresso.com/developers/event-espresso-pros/

Viewing 5 reply threads

The support post ‘How to retrieve data on ticket redemptions’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso