Granular reporting – how to get a better understanding of the attendee data

Oveit’s granular reporting allows you to gain a deeper understanding of their attendees’ registration details. And while we collect and offer any information processed through our platform, it’s impossible to export it into one single report. The level of complexity shown by our system, together with the multitude of different set-ups you can opt for, offer a merely infinite number of possibilities. Yet, throughout this article, we’ll show you how to combine various reports and have a crystal-clear image of the customer journey for each attendee.

To do it, we are going to use the following reports:

Orders – the report containing all information regarding the orders placed for your event, including the billing information and total amount paid.
Attendees – the report containing all information about the attendees associated with each of your tickets.

Now, let’s check and see how to combine this information and get a better understanding of each attendee’s journey. As you will see below, by combining this information, we will learn everything there is to know (event-related) about the people attending your experience.

Log in to your Oveit account.

Navigate to the “Reports” section. Locate and download the Orders Report for the specific event you want to analyze.
The Orders Report provides information about each order placed for the event. It includes details such as the order number, purchaser’s (individual or company) name, billing information, and the discount code used (if applicable).

Orders reports can be easily accessed from your Dashboard

Download the Attendee Report. This report is directly connected to the event for which it’s collecting data and you’ll find it right under the event for which you plan to analyze the data.
The Attendee Report provides detailed information about each attendee’s registration. It includes fields such as name, email, registration date, and any additional data collected through the registration form.

“Attendees” reports are connected to each event and can be accessed and downloaded

The attendee information we’re looking for

Now, let’s look at what we’re planning to obtain by combining information from these two reports. As all the attendee data is available through the Attendees Report, we’re probably looking to see how they registered. As Oveit allows you to set up an unlimited number of discount Vouchers (each with its own discount codes), you can track to see who used what code. How they paid, or who placed the order for a specific attendee.

Here is how Excel, through the VLOOKUP formula, helps us get the information.

Combining the event Reports using VLOOKUP

Open both the Attendee Report and the Orders Report into separate worksheets.
Both reports have a common field – the order number. This field is used to link the attendee’s information with the respective order.

In the Attendees report, in the first unfilled column, enter the VLOOKUP in the second cell. The formula should look like this: =VLOOKUP(order_number, orders_report_range, column_number, FALSE).

working with both files, we can easily import the values we’re looking for

Decoding the formula

“order_number” refers to the cell containing the order number in the Attendee Report. In our case, we will select the first Order (cell B2)


“orders_report_range” refers to the range of cells in the Orders Report having the order numbers and associated information. In our case, we will select the entire Orders worksheet as we want to search through all the information.


“column_number” represents the column number in the Orders Report that contains the desired information you want to extract (e.g., discount code). As we are looking to extract de discount code located in column L, we will enter 12 (for the VLOOKUP formula to correctly return the value that we are looking for, we need to enter the number of the column from which we’re extracting the information). Alternatively, if we were looking to bring to the “Attendees” report the payment method for each ticket, we would look to extract information from the Payment method (column I), we would need to enter the number of the column; 10.


“FALSE” ensures an exact match is found. In our case, the formula will return “0” for attendees that haven’t used a discount code, and the exact code for those that used one.

we’ve now added the discount code to the “Attendees” report

p.s. Depending on your Excel version, it’s possible that the Orders column is stored as numbers inside text cells. Please make sure that your values are stored as numbers, otherwise, the formula will be invalid.

Analyzing the Combined Data

Once you use the VLOOKUP formula, you will see the desired information (e.g., discount code) from the Orders Report corresponding to each attendee in the Attendee Report. Furthermore, you can repeat this process and combine relevant data from any two (or more) reports downloaded from our system, including cashless payments. Just imagine the level of knowledge when combining attendee demographics with purchasing habits (including products sold through our cashless payment system).

May 26, 2023 Event registration No comments yet

New features available

We’re excited to share our latest updates with you. As you will sell below, we’ve been working hard to add new features to our ticketing, account Dashboard, and cashless payments system. Read on to see the updates and how to use use them to create better experiences for your attendees and visitors.

Calendar option – sell tickets for specific days and dates

Looking to sell electronic tickets for specific dates or days of the week? Using our Calendar option, you can easily create ticket categories that offer this. When creating your event, you’re now able to select tickets that are active just for specific days of the week, certain dates, or any date range that you need.

you can now create event ticket categories serving just the selected dates, days of the week, or a specific range

Thus, when buying their tickets, attendees will be able to select the key ticket(s) for the date (or dates) they want to visit your event or venue. Pretty cool, right?

How calendar tickets help you and your community

Especially if you are managing a location (venue, theme park, museum), you need to have accurate, real-time information about the number of visitors you should expect. With this option, you can select the total number of tickets allocated to each day – without having to actually set up limits for each individual day. We’ll take care of everything on your behalf.

With Oveit’s ticketing software, you’re not just seamlessly selling electronic tickets. You are also getting a better understanding of when your attendees plan to visit your location. Using this information, you get all the logistics in place and better prepare to welcome your attendees.

It’s also extremely useful if you manage a location that uses different pricing for different days of the week. So let’s say you’re managing a location. Let’s say you have different prices for weekdays vs weekends. You can now set up two different ticket categories, each with its own pricing, total number of available tickets, and so on. In a matter of minutes, you’ll have everything up and running for the next few months.

For this particular example, the two ticket categories are set up to run for the next 5 months, with different prices and total available tickets for weekdays vs weekends.

. 

At the entrance, you can scan the tickets using our mobile apps, see what day they have purchased, and check in attendees based on what they have bought from your side

For your visitors, it becomes much easier to plan their visit. They can buy tickets for the exact day they’re planning to visit your location, save them to their digital wallet, and make their trip even more enjoyable.

Dashboard – we’ve made things simpler

Oveit comes with all the features you need to deliver extraordinary live experiences. And we’re constantly updating our solution to continue to serve our users while incorporating the latest technologies. But at the same time, we know that you need a user-friendly solution. So we’ve also updated our Dashboard so that you can work more easily.

We want to thank our users for their constant feedback – it always helps us get better and better.

So, here is what you will find in our latest version of the dashboard:

In the main section of the page, we’ve kept the options needed to start your event: Events,   Seating maps, and Vouchers. They will help you set up your first event.

And once you begin selling tickets, you’ll have access to two new options: Community (the CRM with data about your customers) and Reports.

We’ve also grouped all the extra options under one dropdown list, to make it easier to navigate through all the features we offer. We truly believe this will streamline your work.

But we strongly encourage you to share your feedback. This is the only way we can make your experience absolutely unforgettable.

Updates on the cashless payments system

For Oveit Pay, our cashless payment system, we’ve recently released two major updates in terms of usability. Both have the role to make the in-event economy run smoother and take some of the load off your team.

First, we’ve added a balance viewer option to the vendor account. While previously attendees were able to check their balance at top-up points or designated credit checkpoints, attendees can now ask a vendor to update them on the remaining balance. 

When it comes to making a purchase, the technicalities that run in the background remain the same: the system automatically checks the balance and compares it to the total amount of the order, providing an “Insufficient funds” message when needed. 

But we wanted to find a way to save your attendees from an extra walk. We’re sure they’re gonna appreciate it.

We’ve saved the best for last. So truly hope you made it through here – otherwise, this will prove to be a not-so-good idea.

Oveit Wallet is up and running

We’ve released Oveit Wallet, and we think it’s going to completely revolutionize cashless payments. Our wallet is dedicated to event-goers, and it helps them manage their finance throughout the entire festival. It helps them top up credit using a debit or credit card, pay using the app’s dynamic QR codes, view their purchasing history, and withdraw credit when the experience is over.

Although this update deserves a much more extensive section, we will list here briefly the benefits that Oveit Wallet brings to your community, to you, and to the environment:

For your community, Oveit Wallet means no more queuing for top-ups and withdrawals. They will be able to operate these transactions straight on the mobile app by simply connecting their card(s) to their profiles. From there on, they’ll have the option to top up and pay with just a few clicks.

For you and your team, this means lower costs and less work. As Oveit Wallet replaces the need for NFC chips (wristbands or cards), you’ll save time and money when setting up the logistics needed for running the event’s economy. This option will take much of the pressure from your top-up points as they will only serve those that are looking to add credit using cash. 

For the environment, Oveit Wallet means less plastic used at your festival. It helps you go green(er), supporting your environmental-focus efforts, and keeping (almost) everything digital. As a company that operates in the event industry, we acknowledge and support your efforts to reduce the impact our experiences have on the environment.

May 11, 2023 Event registration No comments yet

NFT Ticketing main concerns – Q&A

We’ve asked Chat GPT about the 3 main concerns related to NFT ticketing and answered them through this article.

We’ve said it before, but we’ll say it again. Here at Oveit, we feel that NFT ticketing is the future of ticketing. The benefits offered by blockchain technologies have the power to fundamentally change the industry for the better. These tokenized tickets are not only protecting your community against scalpers and fraudsters. They’re doing it while allowing you to create new, immersive experiences for your attendees.

Table of content
NFT Ticketing and its benefits
NFT ticketing concerns
Access and Adoption
Technical Complexity
Cost and Equipment
Final Words

NFT ticketing and its benefits

Unlike traditional tickets, which generally allow their holders access to a specific venue or area, NFT tickets have the ability to govern the connection between you and your community. While still serving a ticket’s primary meaning, they also govern loyalty memberships, can store extra physical or digital products, and offer access to #web3 experiences. Not to mention that their immutable nature transforms them into desired collectibles! 

But as with any emerging technologies, there are valid concerns that need to be addressed. Whilst implementing NFT tickets for events around the globe, we’ve had a chance to see what people’s main concerns are.

But for this article, we’ve decided to have a different approach. We’ve asked Chat GPT to tell us what the 3 main concerns people may be having when considering implementing NFT tickets for their events. We’ve then addressed these concerns and answered them ourselves.

Just to add, we do agree these concerns are normal to have, but as you can see below, using Oveit’s NFT ticketing is easy to use, extremely accessible, and nothing to be concerned about!

NFT ticketing concerns – according to Chat GPT

This is it. Below, you’ll find the 3 concerns Chat GPT mentioned. And our answer for each of them.

Access and Adoption: Adopting NFT ticketing may take some time, as it requires end users to understand the technology and how it works.

Our NFT ticketing system has been created to be user-friendly and intuitive, making it easy for anyone to use. As an event organizer, no #web3 technical knowledge is required. We’ve built our NFT solution to work on top of the existing ticketing processes and we handle all the technicalities. All that’s needed is a wallet address to use for any incoming royalties in the future. If an organizer doesn’t have a wallet, we can set up the NFT tickets under our collection, so even #web3 beginners can easily sell NFT tickets with Oveit.

For ticket buyers, the process is equally simple. NFT tickets are minted straight to the buyers’ wallets, and all they need to do is connect their wallet address to receive the smart tickets. What happens if somebody with zero blockchain experience wants to buy a tokenized ticket? Besides non-custodial wallets, we also support custodial wallets such as Gryfyn. So somebody completely new to this space can easily open a wallet using their email address. And once they set up a full KYC with the wallet, assets can be recovered even if they lose their login credentials. 

Technical Complexity: NFT ticketing may require complex technical solutions and infrastructure to manage ticket issuance, distribution, and tracking.

Issuing, distributing, and tracking NFT tickets are all done through our proprietary system and partners’ network, allowing our users to use these features without any #web3 technical know-how. We’ve developed a full smart ticketing process that can be used by anyone interested in the benefits of blockchain technologies, even without any experience in the area. 

Here are some of the use cases:

Our network of payment processing partners allows you to sell tickets for both fiat and cryptocurrency and receive your money in fiat currency, regardless of how your customers decide to pay.

You can sell NFT tickets even if you don’t own a crypto wallet. All smart tickets can be deployed under Oveit’s collection, so you and your community can benefit from all the perks without worrying about the complexity of the process.

Anybody can buy an NFT ticket, even customers who haven’t interacted with #web3 technologies before. NFT tickets can be bought with fiat currency through traditional card payment, just like any other electronic ticket. Customers who don’t own a crypto wallet can easily open a Gryfyn wallet – a custodial wallet that requires only a valid email address.

With Oveit, NFT tickets can be scanned just like regular electronic tickets. We’ve worked hard to create a smart ticketing process that resembles the traditional eTicketing process. Although based on blockchain technologies with improved capabilities, the interaction is as smooth as the current process. Your customers will show you a QR code that you scan with our mobile app. In the background, this technology completely changes the process, making it safer for all parties involved.

Cost and Equipment: Smart tickets may require a significant investment in hardware and software infrastructure to support the technology, which may not be feasible for smaller events or organizations with limited resources.

With Oveit, you can use our mobile apps to scan electronic and NFT tickets, together with all the included perks. Our NFT ticketing capabilities are built on top of the existing ticketing process – ensuring a smooth process for both. No special hardware or additional software infrastructure is required in order to use our smart ticketing solution.

When it comes to costs, we’ve kept them simple as well. While Oveit runs on a subscription model, for NFT tickets we’ll take care of all the minting costs and charge just a small percentage of the cost of these tickets. This way, you’re sure that you will never have to pay anything extra for the blockchain technology that supports the NFT tickets – you’ll pay just for the minted tickets.

Final words

We hope this article helped you get a better understanding of how we address the main concerns regarding NFT ticketing. And although we’ve focused on what are, according to Chat GPTthe 3 most common, we know that there are other questions you may have. So here is what we want you to do:

If you have an NFT ticketing-related question for which you haven’t found an answer, leave it in the comments. And we’ll answer it for you. Meanwhile, we’ll keep asking Chat GPT to see if other relevant questions appear – and we’ll update this article accordingly.

May 5, 2023 Event registration, NFT ticketing No comments yet