Alex Pana is the Marketing Manager at Oveit, a US-based tech company focusing on improving virtual and in-person experiences. Prior to joining Oveit, Alex worked with 2 of the world's leading financial services companies.
Over the last 4 years, Alex worked directly with hundreds of live and virtual events, understanding how technology improves the overall experience. He is people-oriented and although his role is to share the word about Oveit's solutions, he loves to learn about people's experiences. Be they good or bad.
He has a degree in Public Administration. This is where he first learned that small changes can result in big improvements. Having this in mind it was only normal for him to join Oveit.
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).
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.
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).
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.
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).
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.
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.
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.
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!
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.
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.
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.
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.
This blog post explores the advantages of using NFT ticketing compared to traditional (e)ticketing for event organizers. NFT ticketing provides a more secure and personalized experience for ticket holders, while allowing for better control over the secondary market and generating more revenue. On the other hand, traditional ticketing offers a more familiar and accessible experience compared to NFT ticketing.
Due to their specific nature, NFTs have rapidly gained attention and traction. The blockchain-based digital assets solve many of our current problems in several industries. And event management makes no difference here. However, although they have been used for numerous events, there is a legit question: are NFTs usable in large events? During this article we are going to answer this question, arguing why we could and should use NFTs in events. Be they large or small.
While blockchain technologies in general and NFTs, in particular, serve a wide range of industries, entertainment is one particular area where these technologies will completely change how stakeholders interact. It’s going to change it fast, making the industry safer, equitable, more engaging & entertaining, and ensuring a more equitable financial distribution amongst creators. And most importantly, NFTs will help you serve your attendees better.
Let’s see how!
How NFTs are helping event organizers
As an event organizer, delivering an enjoyable experience to your community is the top priority. However, regardless of the amount of work you put in, some things are just out of your control. But fear not: some of these issues can be easily solved through NFTs.
One of the biggest concerns, especially when it comes to large events, is related to event tickets. Unlike other goods, tickets to an event, no matter how big the event is, are limited. No matter how much we would like to, there is a limit that cannot be exceeded. And this makes event tickets extremely highly desired. The bigger the demand, the bigger the problems.
French minister says 70% of Champions League final tickets were fake
There are two issues that currently used technologies cannot solve. Ticket fraud and secondary market sales. Although related, let’s approach them one at a time.
Tackling ticket fraud with NFT tickets
Like in the above example, for highly coveted events, fraudsters will create and sell fake tickets. No matter the security measures you take, somebody will find a way to replicate and sell them. This can lead to unpleasant situations where a large number of attendees, that paid to join an experience, are forbidden from entering the event premises. With large events, this can easily turn into public safety concerns.
Another used method is selling the same legit ticket multiple times. There have been cases when hundreds of guiltless attendees arrived at the gates holding the same, valid, ticket. Unpleasant to say the least.
Through their immutable nature, NFTs tickets will protect your community against fraudsters. These digital assets cannot be copied or altered, and the blockchain network on which they are issued and deployed is guaranteeing each new item. So it’s going to be impossible to release batches of fake tickets and try to scam your community.
At the same time, as these NFTs are minted into a digital wallet, the same NFT ticket cannot have multiple owners at the same time. Unless you decide otherwise. Nobody will be able to sell the same legit ticket to multiple buyers at once.
Transforming the secondary market
Unlike the first example, secondary market transactions are in a gray area. While some of these transactions are 100% legit, some are immoral or illegal. While it’s only normal for someone that can’t make it to an event to sell the ticket to someone else, things dramatically change when we talk about scalpers automatically buying thousands of tickets just to resell them for a profit.
But NFT tickets are giving you full control not over the initial sale, but over transactions taking place on the secondary market as well. As NFTs are connected to crypto wallets, you can limit the number of tickets that can be minted to a specific wallet address. Thus preventing scalpers to buy large quantities of tickets from your initial releases.
And as NFTs are governed by smart contracts, this means that they can be programmed to act in specific ways when certain criteria are met. You can set upper and lower prices for secondary market sales or even block them from reselling. Although eliminating the reselling option is not recommended for large events, setting up reselling limits will protect your community against those looking to make an easy profit from your work. But as we will see in the next chapters, secondary market resale can open a new revenue stream for event organizers.
New revenue streams for event organizers
But setting up lower and upper limits for reselling is not the only way to customize the NFTs smart contract. The option to set up royalties is one of the reasons that drove the rapid adoption of NFTs. Here is how this works: each time the NFT is part of a transaction, a certain percentage goes back to its original issuer. In fact, the smart contract can be set up to include multiple parties, not just the original issuer. But you get the point: NFT tickets can help event organizers not control how tickets are distributed on the secondary market, but also get a cut from those transactions. So, for your events, you can set up a smart contract to get 50% of any profit the reseller makes for your tickets. Or to donate it to charity.
For large events, where many stakeholders are involved, this can also tackle another inaccessible market: the invites. Although not talked about, for any large festival there is a secondary market where invites are sold for profit. As thousands of invites go out to sponsors and partners, a consistent number of those find themselves sold by their initial holders. Although not against the rules, these transactions could be easily controlled by the event organizers through the use of NFTs. And just like for the above example, a smart contract could be set up so that a certain percentage of these transactions finds its way back to those putting up the hard world. Or to any other third party that you may think of.
Improving the event-goers’ experience via NFTs
NFTs play a major role in protecting your community against fraudsters and scalpers. But there are many other ways they help you improve their overall experience. The non-fungible tokens are a digital representation of any physical or digital goods (or services) that it’s associated with. If we look at them as simple tokenized tickets, the benefit associated would be the access credentials for the event. And maybe some artwork that it comes with. But the truth is that NFTs allow you to customize the experience beyond imagination. You can pre-pack goods and services that create immersive experiences. You can allow your community access to special gatherings, exclusive content, and merchandise, all based on one NFT. So the NFT is more than just a pretty picture. Behind the obvious digital artwork, there are countless possibilities waiting for us.
The smart contract that governs the NFT can be set up to include merchandise, access to special areas within the event, or even access to digital experiences. Each of your attendees can easily create and own unique experiences.
Imagine this scenario: you’re buying a ticket to your favorite band’s gig. You’re including a t-shirt in this purchase, something to eat on-site, and 2 or 3 beverages. And guess what: you’re not buying your average event ticket. You are actually buying an NFT ticket, and this token offers you access to a meet-and-greet online session. Together with a 10% future discount on any new gig where they will perform. And everything is packed up into an NFT that has some digital artwork created by local artists. Quite a collectible digital token, right? Imagine its work 20 years from now. Especially as nobody will ever question the authenticity of this NFT.
Will token-gated events eliminate admission pains?
Not entirely. But they will definitely allow us to have better control over how things are managed on-site. Unlike a classic event ticket, NFTs are accessed through crypto wallets. Meaning that your attendees have 0 chances of losing or misplacing them.
The entire history and authenticity are guaranteed by the blockchain network and fake tickets are completely eliminated. There will be no need for backup checks. You know, the ones that usually keep everyone from getting there faster. The use of NFT tickets will provide better attendance verification. Thus resulting in a more streamlined, efficient, and secure event experience for both organizers and attendees.
While some issues related to event admission cannot be solved by NFTs, they definitely offer you the strings needed to create better overall experiences. And you can further solve these issues by following these tips:
Crowd control: By managing crowds properly, you can reduce wait times and line-ups at admission, making the event experience more enjoyable for attendees.
Plan ahead: Anticipating potential issues created by big crowds will help prepare and deal with them proactively. Prepare for the worsts, and expect the best.
Collaborate with experienced vendors: Experienced vendors, such as security providers, will help you provide a smooth and secure admission.
Potential NFT-related issues
While it’s obvious NFTs are usable in large events, there are technical and logistical challenges you need to consider. And find the right way to overcome them.
One of the first things you need to take into consideration is scalability. Is the system capable of handling increased demand? Large events imply tens of thousands of attendees, meaning that there will be a large number of transactions in a very short period of time. This is why it’s important to choose a solution that is ready to handle these situations. Or you can find yourself in a situation leading to slow processing times and increased gas fees.
As the NFTs are accessed through digital wallets, guests will need to be able to connect online. Although this is an issue in the past, you still need to make sure that your customers can easily access the NFTs. Otherwise, you may find yourself in a very unpleasant situation.
I’ve saved it for last as I find it to be more of a theoretical issue. Although controversy around NFTs exists, their utility becomes clearer with each passing day. Today, roughly 60 million Americans own some form of digital asset. At a global level, almost 1 billion people have transacted some form of cryptocurrency. Blockchain technologies benefit from rapid adoption. It won’t be long until all event tickets will be NFT tickets.
I think it’s safe to say that NFTs are a game-changer in the event management industry. By eliminating ticket fraud and secondary market issues, they protect all the legit stakeholders. The hard and soul of this industry.
Not only do NFTs keep everyone safe, but they also open up new revenue streams. You can now set up smart contracts with royalty options, and earn a cut of any secondary market profits. But most importantly, NFTs can help you enhance the attendee experience, by merging in-person and digital experiences together.
So, whether it’s a large or small event, NFTs are definitely worth considering for all your event needs. From access control to payments.