E-ticket Report

At Guru, you have the flexibility to export your e-tickets to organize and store all relevant information. The e-ticket spreadsheet provides direct access to the fields present in Guru's E-ticket report, offering a comprehensive view of tickets, event participation status , participant/guest data, and all transactional details.

Essential for efficient event management and accurate tracking of your e-ticket sales, this documentation details each of these fields, allowing you to make the most of your data's potential.

On this page:

• Code

• Participant data

• State (status)

• Link (E-tickets URL)

• Product data (event/ticket)

• Event Location and Date Information

• Offer data

• Marketplace Data

• Status and Order Date

• Contact Data

• Custom Fields (Columns Extra)

Code

In the Code column, the field refers to the unique identification code assigned to each generated e-ticket, which allows for the search of individual ticket information, being essential for its tracking and validation.

Attendee data

In the Name, email, country, and phone columns, you will find detailed information about each participant, essential for event management and communication.

Available data includes:

1. Attendee name

   1. this field displays the full name of the individual associated with the e-ticket, with the text format primarily used for confirming the identity of the e-ticket holder.

2. Attendee email

   1. the field contains the participant's email address, which you can fundamentally use for direct communication with the participant/guest and serves as an additional means of identification.

3. Attendee country

   1. indicates the country code of the participant/guest's origin, and this data is relevant for obtaining information to ensure compliance with local regulations.

4. Attendee phone

   1. displays the participant/guest's phone number, including the country code, and this contact is crucial for situations involving direct support to the participant.

State (status)

This field indicates the current status of the e-ticket in relation to the event and reflects the e-ticket's situation within the event lifecycle, allowing for precise tracking of each ticket's status and assisting in access control.

Possible values: ⁣

• assigned: e-ticket assigned to a participant, but not yet used;

• checked_in: participant checked in at the event;

• canceled: e-ticket was canceled;

• open: e-ticket issued but not assigned to a specific participant - tickets to be filled;

• invited: e-ticket sent as an invitation.

Link (E-tickets URL)

The E-tickets URL is the direct link where your participants or guests can access tickets for an event you are promoting.

When exporting the e-ticket spreadsheet, a column named Linkwill appear, and the information in the column appears as follows:

• When the e-ticket Status is:

  • assigned : indicates that the e-ticket has been assigned to a participant but not yet used, and

  • invited: indicates that the e-ticket was sent as an invitation.

• When the e-ticket Status is:

  • open: indicates that the e-ticket has not been assigned; and

  • canceled: indicates that the link is not available at this time - the row appears empty.

You can filter the exported spreadsheet by states (status) to search for information about e-tickets that have not yet been assigned (open) and/or list assigned e-tickets where the participant/guest has not accessed the e-ticket.

Product data (event/ticket)

In this section, you will find essential information about the event to which the e-ticket is associated, through the Product ID and Product Name columns.

Available data includes:

1. Product ID (event/ticket):

   1. is the unique identifier of the product (event/ticket) and indicates that it is an exclusive number that identifies the specific event or ticket, allowing direct linking of the e-ticket to its original product, facilitating management and tracking.

2. Product name:

   1. displays the name of the product to which the e-ticket is associated and presents the descriptive name of the event or ticket type, providing easy and quick identification of the event or ticket category.

Event Location and Date Information

In this section, you will find details about the location (where) and period of the event (when) the event will occur, essential for logistics and participant information.

1. Event location:

   1. indicates the place where the event will happen and presents the address or specific name of the event venue, and its purpose is to provide the participant/guest with essential information about where to go, in addition to assisting in the logistical organization of the event.

2. Event Period (event start and end dates and times):

   1. start date (including time zone): indicates the event's start date and time and records the exact moment the event is scheduled to begin, being fundamental for participant planning and event schedule control.

   2. end date (including time zone): indicates the event's end date and time and records the exact moment the event is scheduled to finish, offering the full duration of the event for the participant and for organizational purposes.

Offer data

In this section, you will find information about the ID and name of the offer to which the e-tickets are associated.

Available data includes:

1. Offer ID:

   1. has a unique and exclusive identifier for each specific ticket offer, and its use is indispensable for precise tracking of the origin of each e-ticket. This traceability allows for data cross-referencing and the generation of detailed reports on sales and the performance of different offers.

2. Offer name:

   1. offers a readable and direct description of the ticket type or batch in question and provides immediate detail about the characteristics of the purchased ticket.

With the Offer ID and Name, you ensure that both the organizer and the system have a clear and precise understanding of each e-ticket transaction, optimizing management and data analysis.

Marketplace Data

In this section, you will find information about the ID and name of the marketplace to which the e-tickets are associated.

Available data includes:

1. Marketplace Name:

   1. describes which payment processor was used to process the specific transaction, and its main utility is to clearly identify the origin of the transaction, which is crucial for financial reconciliation and customer support.

2. Marketplace ID:

   1. is the exclusive identifier of the transaction within the marketplace's own system, and through the ID, direct and precise tracking of the original transaction on the payment platform is allowed, facilitating audits, problem resolution, and the linking of information between different systems.

This data is a powerful tool for financial management, control, and analysis, essential for any business operating with multiple payment platforms.

Order Status and Date

In this section, you will have access to information related to the order (transaction) status and date, to track e-ticket sales.

Available data includes:

1. Transaction Status:

   1. shows the progress of the e-ticket status, which may indicate the status as, for example, “Approved", confirming the success of the transaction, and/or "Canceled", signaling that the transaction was not completed. In addition, it provides additional details about the transaction lifecycle.

2. Order Date (Transaction):

   1. informs the exact day and time the e-ticket purchase occurred, and you can organize your sales, facilitating sales flow analysis and identifying peaks or drops in certain periods.

Contact Data

In this section, you have access to contact data, such as name and email, facilitating the identification of contact information.

Available data includes:

1. Contact Name:

   1. indicates the name of the main buyer of the transaction;

2. Contact Email:

   1. provides the email address of the same buyer.

Both fields are essential for you to identify buyer (transaction) information and ensure more precise customer management and a closer relationship with those who purchase your e-tickets.

Custom Fields (Columns [Extra])

In this section, you will find information about the custom fields, which will appear as additional columns in your export. These columns represent the extra data you configured to be collected during the e-ticket transaction.

You can configure both custom fields and smart fields to collect the information you want for your event.

Examples found when exporting the spreadsheet:

• [Extra] policy_privacy: privacy policy acceptance indicator;

• [Extra] Notes: free text field for observations;

• [Extra] Choose 2 options: selection field with predefined options;

• [Extra] Required selection list: mandatory selection field in a list;

• [Extra] Date and time for arrival: specific date and time for arrival;

• [Extra] use_terms: acceptance of terms of use;

• [Extra] select: selection field;

• [Extra] list: selection field in a list.

More Resources