HANDS - FREE SALEs REPORTING

Entradas.com is a Spanish company specializing in ticket sales, and
is part of one of the world’s leading international ticketing and live
entertainment providers. Approximately 250 million tickets per year
are sold using EVENTIM systems, and this is done through box
offices, online, or via phone. Their online portals operate under
brands such as eventim.de, oeticket.com, ticketcorner.ch,
ticketone.it, and Entradas.com.

The client was looking to leverage the systems they already had to enhance their processes, which were divided into two parts: entertainment (cinemas, theatres, and concerts) and sports.

The existing sales process included the weekly task of configuring a number of queries within their database and sending partners a CSV document containing their latest sales figures. Although this task didn’t require much time at the beginning of the season, towards the end it could take between 2 to 3 hours to complete per person.

The client was looking to leverage the systems they already had to enhance their processes, which were divided into two parts: entertainment (cinemas, theatres, and concerts) and sports.

The existing sales process included the weekly task of configuring a number of queries within their database and sending partners a CSV document containing their latest sales figures. Although this task didn’t require much time at the beginning of the season, towards the end it could take between 2 to 3 hours to complete per person.

First, we studied the process, mapped the data, reworked the query, and developed a process that, by taking advantage of one of the partners’ APIs, sends the required information every 5 minutes. This is the minimum amount of time necessary to complete the query while there is a big sales process running.

From a technical point of view, the aim of our design was to build a process that, using data returned by the improved query and reworking the information, allowed us to send it correctly to the partner’s API.

This provides a foundation for us to add further improvements to the API, and code updates will allow for further automation and data management.

Entradas.com spent approximately 130 hours each year carrying out this single task, which has been reduced to zero, allowing partners to access information in near real-time. All of this was achieved within just 70 hours of development time. This 100% automation eliminates the need for human interaction, enabling significant time and cost-savings for Entradas and their partners.