How to export data from the Bookings tab

Where can I find it? Bookings >>> Download

In this article, you will discover how to export reports in .csv or .xlsx format from the Bookings tab of your TuriTop control panel. You will learn how to use custom filters to extract the exact data you need, whether it is detailed service information (name, language, etc.), technical booking data (IDs, seats, origin), or specific customer information collected through your booking form.

For an in-depth analysis of your finances, you can consult this article on how to locate and analyze payment amounts, which will provide a detailed overview of sales, bookings, and agent commissions. Additionally, you may refer to this article focused on monetary transactions, designed to individually account for each payment line linked to your bookings.

How to filter your bookings

Before exporting your information, you can apply search filters to segment your bookings according to your needs and obtain more accurate results. If you have already defined your filters, please refer to the next section of this article to select the specific data fields you wish to include as columns in your report.

By using filters, you can locate specific bookings that meet your selected criteria. To configure them, click on the orange filter management button (the fifth icon in the row). From there, check the boxes for the fields you wish to enable and click Save within the same menu. Once activated, enter the required information into the corresponding fields and click the magnifying glass icon to apply the search.

The following filters will be available to you:

• From / To: Define a time range by selecting a start date in 'From' and a cutoff date in 'To'. You can apply this filter based on three different criteria: by booking date (when the purchase was made), by event date (when the activity takes place), or by event validity ('valid until') (specific to open schedule services or gift vouchers).

• Service: Filter results by a specific activity. Select a particular service to view only its bookings or choose 'All services' for a global list of your system.

• Supplier: Use this filter to locate bookings for external services offered in your panel. This option will only be visible if you have linked services from other providers through the Marketplace.

• Come from: This filter allows you to segment your results by sales channel. You can view only online bookings (made via the widget or WordPress), manual entries (added from the back-office by your team), or select 'All' for a complete list.

• Customer: This field allows you to find bookings by filtering by any customer data (such as name, email, or phone number) or by notes included in the comments.

• Checked: Select 'Checked-In' to filter bookings that have already been validated and 'NO Checked-In' for those still pending use. Remember that you can quickly redeem your bookings using our mobile App.

• Booking ID: Use this field to locate a specific transaction by entering its unique identifier (e.g., A468-170127-5). This code consists of three parts: the company prefix (A468), followed by the booking date in YYMMDD format (170127), and finally, the sequential booking number generated that day (in this example, the fifth booking of the day).

• Cart ID: This filter allows you to locate all bookings associated with the same transaction or shopping cart. Note that this field will only be enabled if you have the Shopping Cart functionality activated.

• Multiclient ID: Use this field to filter results based on the unique identifier for group purchases. This code allows you to view all bookings associated with a single multi-customer purchase process together.

• Status: Classify your bookings by selecting their condition in the system. This filter allows you to quickly isolate and manage bookings that are confirmed, pending payment, canceled, or in any other state available in your configuration.

• Created by: Use this field to filter bookings based on the system user who registered them. This way, you can quickly identify which bookings were manually created by each registered user in your TuriTop account.

• Agent / User: Use this field to locate bookings processed by a specific agent with access to your panel. When selected, the system will only show sales linked to that user.

• Unregistered Agent: Use this text field to find bookings made by agents not registered in your system. Unlike the dropdown filter, this allows you to search by name for bookings that enter automatically through external integrations or third-party distribution platforms (e.g., "gyg" or "viator").

• Internal Notes: This search tool allows you to find bookings based on internal management comments. You can locate records containing specific notes written by the admin team, external agents, or third-party sales channels.

• Reseller: Use this filter to segment your bookings by resale channel. This option will only be visible if you have services configured for resale in the Marketplace.

• Transfer Point: This filter allows you to group and view bookings based on the meeting location selected by the customers.

• Pick-up by hour: This filter allows you to segment bookings according to a specific time range for transfers.

• Gift Certificate: Use this filter to manage your voucher sales. You can select 'Redeemed' to see vouchers already used, 'Not redeemed' for those pending use, or filter globally by choosing 'All gift vouchers'. To view only standard bookings that are not gift pre-sales, select 'Not gift vouchers'.

• Payment Method: This filter allows you to segment your bookings based on the gateway used for the transaction. You can filter by options such as Stripe, PayPal, or Redsys, depending on the payment platforms integrated into your TuriTop account.

• Promo Code: Use this text field to filter your results using a specific discount code. Upon entering the code, the system will only show bookings where that promotion was applied.

• Language: This filter allows you to view only bookings made in a specific language.

• Ticket Type: Use this filter to locate bookings associated with a specific ticket type. Simply type the name of the ticket (such as 'Senior' or 'Student') exactly as defined in your panel to get the corresponding results.

• Order by: Use this filter to prioritize how bookings are displayed on the screen. Choose between ascending or descending order based on parameters such as the time of purchase, activity date, assigned agent, or pick-up logistics data.

• Seat: This field allows you to locate the booking associated with a specific seat within your venue. Note that this option is only enabled for Auditorium-type services.

• Redeem Code: Use this filter to perform searches based on valid gift voucher codes. By entering the gift identifier, the system will show you the associated booking, allowing you to manage the redemption or check its details.

• Add sales summaries: Check this box to view cumulative totals for your searches. Calculations for gross income, commissions, and total net amount will be displayed right above the results list.

• View: Customize how your bookings are displayed. Choose the 'Detailed' option if you need to check every customer and service detail, or the 'Minimal' option for a simplified list with essential booking data.

• Show: This filter allows you to view bookings that have been deleted. By checking this box, the system will retrieve deleted bookings (permanently canceled), allowing you to have full control over your account history.

You can consult this article to learn more about the Bookings tab.

How to download your bookings report

Step 1: Apply booking filters

To obtain a much more accurate report tailored to your needs, we recommend applying search filters before starting the export. If you have any questions about how to configure them, you can refer to the previous section of this guide, where we explain the functionality of each filter in detail.

Step 2: Select your export fields

After applying the filters, click the orange Download button to open the field selector. In this menu, you can check the data you wish to export; each selected field will become a column in your file. These fields are grouped into categories such as "Service," "Booking," and "Customer."

Service data:

• Service and Company Information: Data identifying what has been sold, under which brand, and in which language..

  • service_name: Service or activity name.

  • language_code: Language in which the booking was made.

  • service_flow: Booking flow applied (Tour/Activity service type, Open schedule, etc.)

  • company_name / company_short_id: Name and ID of the company.

  • supplier_short_id: supplier's ID (in case of resell).

Booking data:

• Identification and Reference: Data to locate a booking or a specific ticket within the system.

  • short_id / short_id_seat: Unique booking or seat identifier (in the case of services with Auditorium configuration).

  • cart_hash / multi_client_hash: Internal grouping codes for shopping carts or multi-customer bookings.

  • order_list: Number of tickets per booking and the status of their totals (paid or pending). 

  • referer: Source or link from which the booking originated.

• Dates and Chronology: Fields to filter or visualize the different stages of the booking lifecycle.

  • date_booking / date_prebooking: Booking creation date and the start of the user's checkout process.

  • date_event / date_event2: Date and hour in which the activity takes place.

  • date_enjoyed: Date in which the service was validated and the customer's access was confirmed (Checked-in).

  • date_modified / gift_date_modified: Last edition date of the service or gift voucher.

  • date_refund / date_deleted / date_undeleted_system: Log of refund actions, cancellations, or restorations of previously deleted bookings.

  • open_ticket_optional: Validity period (gift voucher purchases) expressed in days after the purchase date, according to the specific service configuration.

• Financial and Payment Information: Data related to prices, fees and payment methods.

  • total_price / currency: Total amount and currency of the transaction.

  • paid_online: Amount paid through the payment gateway.

  • payment_gateway: Payment method used (Stripe, PayPal, efectivo, etc.).

  • turitop_fee: TuriTop service fee.

  • agent_fee / reseller_fee: Commissions destined to the agent or reseller.

  • gift_certificate: Total number of vouchers purchased within a single booking.

  • promo_code: Coupon identifier or promo code used during purchase.

• Client and Service Details: Customer details and purchase characteristics.

  • buyer_email: Customer email address.

  • ticket_type_count_json, tickets_count: Breakdown by ticket type (adult, child, etc.) in JSON format and total number of people.

  • comments: Notes or comments added by the customer in the booking form.

  • transfer_hotel / transfer_point / transfer_time: Specific data for pick-up services (hotel, point and schedule).

• Internal Management and Status: Fields indicating who created the booking and its current status.

  • status / custom_status: Current status (confirmed, pending, etc.) and internal notes.

  • deleted: Indicator determining whether a booking has been deleted from the system (value 1) or remains active (value 0).

  • created_by: Identifier of the user who manually registered the booking or the entry method used to create the record.

  • agent_name: User associated to the booking.

  • agent_affiliate: Indicator determining whether a booking was generated through the affiliate system (value 1) or directly (value 0).

  • source / offline: Booking source channel and whether it was an in-person sale (value 1) or an online sale (value 0).

• Technical Data and Geolocation: Technical information collected during the booking process.

  • ip: IP address from which the purchase was made.

  • geo: Estimated customer geolocation.

Client data:

• Booking Form Fields (standard): Basic and predefined client information recoleted during the purchase process.
  • name / email: Customer name and email address.
  • phone / landline: Buyer's mobile and landline phone numbers.
  • nacionality: Buyer's nationality.
  • birthday / age: Buyer's birthday date and age.
  • language: Buyer's language.
  • address / postalcode / locality / country: Buyer's address, postal code, locality and country.
  • hotel / room: Buyer's hotel name and room.
  • acceptterms: Indicator determining whether the buyer has accepted the terms and conditions checkbox (value 1) or did not (value 0).
  • newsletter: Indicator determining whether the buyer has accepted newsletter checkbox (value 1) or did not (value 0).
• Booking Form Fields (personalized): Specific information obtained through additional questions and requirements configured for the service.
  • customtext / customtext2 / customtext3 / customtext4 / customtext5 / customtext6: Information captured through the 'Custom Question (1-6)' field in the booking form.
  • customtextarea / customtextarea2: Information captured through the 'Large Custom Question (1, 2)' field in the booking form.
  • customcheck / customcheck2 / customcheck3: Information captured through the 'Custom Checkbox (1-3)' field in the booking form.
  • custom / custom2 / custom3 / custom4 / custom5: Information captured through the 'Custom HTML (1-5)' field in the booking form.
  • custom url checkbox 1 / custom url checkbox 2 / custom url checkbox 3: Information captured through the 'Custom Label Checkbox (1-3)' field in the booking form.

To identify the ID of your form fields, go to the Company/Services tab >>> Booking form. The ID is displayed directly below each box, allowing you to quickly locate it to configure your export.

Step 3: Download your report

After selecting the export fields from Step 2, click the orange 'Download CSV' button (.csv format) or 'Download Excel' button (.xlsx format) depending on your preferred format. The file will be saved in your device's downloads folder with the name 'Reservas' (Bookings); if you perform multiple downloads, the system will add sequential numbering (e.g., Bookings (1)) to distinguish them.

Step 4: Data Processing and Formulas

Once the report is downloaded, you will have your database in raw format, compatible with applications such as Excel, Google Sheets, or LibreOffice.

Please note that the management and processing of this data are the responsibility of the user; TuriTop provides the export but does not offer consultancy or database manipulation services for external software.

However, below we explain how to identify the ticket type equivalencies in the ticket_type_count_json field and how to apply formulas in your spreadsheet to break down this information automatically.

1. Identifying and Mapping Ticket Types

   To correctly break down your sales information, you must first identify the internal ID that the system assigns to each ticket type. You can obtain this identifier using either of the following methods:

• Option 1: Via the TuriTop API

  If you have access to the TuriTop API, use the GET /tickets/get call, specifying the desired Service ID. The response will return a complete list of associated tickets with their respective names and unique identifiers.

  

• Option 2: Using the Browser’s "Inspect" Tool

  You can find the ID directly from your TuriTop control panel. To do this, navigate to the Services tab >>> PX PX (Desired Service) >>> Tickets and locate the ticket you want to identify. In your browser (e.g., Chrome), right-click on the ticket name, select "Inspect" (or press F12 to open Developer Tools), and use the element selector to point directly at the ticket element.

  In the highlighted HTML code, look for the numerical value assigned to the element. This ID is the unique identifier that will appear linked to that ticket type in your export reports and logs.

  

  2. Procedure for Breaking Down Tickets Using Formulas

  Once you have identified the numerical values for each ticket, you can apply formulas in your spreadsheet tool to separate these tickets and display the commercial names instead of the internal codes.

  To do this, you can use the following formula in the first empty cell of the adjacent column:

  ---

  Google Sheets Formula:

  =ARRAYFORMULA(IF(I2:I="", "", 
   SUBSTITUTE(
     SUBSTITUTE(
       SUBSTITUTE(
         SUBSTITUTE(
           SUBSTITUTE(I2:I, "\", ""), 
         "530525", "Adult"), 
       "530528", "Child"), 
     "531483", "Infant"),
   """", "")
  ))

  

  ---

  Excel Formula:

  =MAP(I2:I1000, LAMBDA(cell, 
  IF(cell="", "", 
   SUBSTITUTE(
     SUBSTITUTE(
       SUBSTITUTE(
         SUBSTITUTE(
           SUBSTITUTE(cell, "\", ""), 
         "530525", "Adult"), 
       "530528", "Child"), 
     "531483", "Infant"), 
   """", "")
  )
  ))

  ---

How to Adapt This Formula to Your Case

To ensure the formula works correctly with your own data, you must make the following adjustments:

• Identify your column: In this example, the data is in column I, but you must replace all "I" references in the formula with the letter of the column where your ticket_type_count_json field is located.
• Replace the IDs: Change the example numbers (530525, 530528, 531483) with the unique ticket codes found in your own spreadsheet.
• Customize the names: Change the labels "Adult", "Child", and "Infant" to the ticket names that correspond to your specific service.
• Placement: You must paste the formula in the column adjacent to your ticket_type_count_json data. In this example, that would be cell J2.

This function automatically cleans the JSON format by removing backslashes (\) and extra quotation marks to make the text readable. Additionally, it searches for each ID code and automatically translates it into the ticket name you defined. By using MAP+LAMBDA (or ARRAYFORMULA), the conversion will be automatically applied to all rows below without the need to manually drag the formula down.