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.
We’ve just released our new smart tickets. Your attendees are going to love them. We’ve updated the design of our tickets but, most importantly, we’ve made a big change in terms of usability.
Why smart tickets? Because buyers can now easily add their event tickets to their mobile wallets, for both Apple and Android. We think it’s the most convenient and secure way for customers to access and manage their electronic tickets. As you already know, our electronic tickets can mean more than just access rights. And ticket addons are also available through the mobile wallet used by your attendees.
Here is how our smart tickets work
Nothing has changed in the registration process. But once customers land on the confirmation page, they’ll see the new option. Two simple clicks and the e-ticket will land in their mobile wallet.
Once the e-Ticket is added to the wallet it can be easily accessed through the app. Much simpler and faster than the traditional way. Or any other way for that matter.
Our tickets can hold unlimited perks and extra benefits. And they’re still available through a simple scan of the QR code. Attendees can easily see these addons straight from their wallets. The “info” icon displayed under the ticket will open a new screen, listing all the perks included in that particular ticket.
While for iOS users the wallet comes preinstalled, Android users have multiple options to choose from. We recommend WalletPasses, but there are multiple wallet apps supporting the .pkpass format.
Changes in the follow-up email
As not all customers will add their tickets to the wallet through the confirmation page, we’ve also updated the confirmation email. It now has the tickets in 3 updated formats:
.pdf for those that want an easy way to print their tickets
.png for those that want to download it to their mobile
.pkpass for those that want to save it to their mobile wallets
Adding the (extra) personal touch
You’ve probably noticed a custom area on the ticket. You can add it to yours as well. The custom image can be uploaded on your tickets and will be available in .png and .pkpass formats. The customization is available through Step 3 – checkout settings.
We’re confident the event-goers will find this option extremely useful. They now have a simpler way to store and access their event tickets. But that’s not all; we’re confident that these smart tickets will also improve check-in times, as most of your attendees know at any given moment where they’ve put their ticket(s).
While technology becomes more powerful and accessible, industries from all over the world change. The way we do business is not the same. As with any change, technology implementation is also looked at with bad eyes. At least sometimes. But when it proves its utility, it becomes accepted by everyone. Today, we will see if NFTs are useful in entertainment. Of course, as you can guess, there are many benefits associated with the use of NFTs in entertainment. It’s the industry that will be first completely transformed for the better. We will focus on the benefits of using NFTs in the entertainment industry. But first, let’s see what they actually are.
As you already know, NFT stands for non-fungible tokens. Meaning that they are unique items, with unique characteristics, that cannot be divided or replaced. An NFT is a cryptographic asset that represents certain digital or physical goods and its nature makes it impossible to alter it.
As NFTs operate on blockchain networks and they are immutable. Their authenticity and ownership can be verified and guaranteed by the entire network. This, together with the fact that NFTs are minted through a smart contract (a short code that runs when certain predefined conditions are met), makes them powerful.
To put this in other words, NFTs are digital assets that cannot be counterfeited. And that records the item’s complete history. They are associated with digital or physical goods and are pre-programmed to act in certain ways.
The entertainment industry is one of the most active and creative industries in the world. So it was only natural for it to be one of the early adaptors of this technology. And while NFTs are already used for businesses operating in this field, we’re still in the early days. There are many applications for NFTs that will completely change the industry for the better.
The entertainment industry is one of the wides fields there are, covering a wide range of activities. Due to its nature, authenticity and ownership are crucial elements of the industry. And as we have seen above, these particular aspects are well covered by the NFTs. Now, let’s take a look at some practical ways of using NFTs in entertainment.
As their entire history can be verified (and altering it is nearly impossible), NFTs are synonyms for authenticity. This is one of the reasons why people pay so much money for specific digital artworks. Besides, of course, the hype that surrounds this technology. An NFT guarantees you that you are the sole owner of a specific digital artwork. But that is just scratching the surface of something way more powerful.
Here is an example: Imagine you are trying to buy a very expensive piece of art. A painting for example. To make sure that you are buying the original one, someone needs to check its authenticity. Authenticity often comes in the form of a Certificate of Authenticity, stating that you are buying the original one. Well, regardless of how well the checking is done, I’m sure that there other collectors that have paid good money for extraordinary copies. That has, of course, Certificates of Authenticity. Which, by the way, is a separate asset and they can always be separated for good.
When it comes to NFTs, this “Certificate of authenticity” is actually part of the asset itself. It’s hardcoded within the token, signed by its creator, and checked and approved by the entire network. The blockchain network mentioned above. And each new layer of information is added as a new immutable block of code. When you decide to buy an NFT you are 100% sure of what you are buying.
Having this said, it’s obvious why people are investing so much money in NFTs. They are sure that they are not buying worthless copies – regardless of the actual utility of what they are purchasing. This is an overview of how authenticity and ownership are tackled by this technology. But now let’s see which characteristics of NFTs can be useful in entertainment. They will, of course, apply to other industries as well. Take a look at how to use them for tourism.
Another incredible asset stands in the smart contract that governs an NFT. This code programs the NFT to act in certain ways when it meets certain conditions. So an NFT can actually do a lot of things for both its issuer and its owner.
You can program an NFT to include future discounts or benefits. A new band that released its first album can use this option to incentivize them to buy it. The NFT can include, besides the actual album, a 15% discount for all future albums they will release. Anybody that supports the artists by buying their first album will enjoy lifetime discounts on their releases.
Allowing fans to actually own your work. Digital items can be tokenized. You’ve heard about the first-ever Tweet sold as an NFT. But you probably haven’t heard about entire movies that went through the same process. Here is an example, one from our own backyard. In 2021, we’ve sold a movie as NFTs. Although this was for a social cause, the same principle could apply to a filmmaker that looks for a way to finance the work. The movie can be tokenized and sold to the supporting community. Fans will not only own part of the work and can receive a cut if the movie becomes a big hit. They are now part owners of the motion picture. A win-win situation indeed.
Setting up royalties. One of the most important benefits of working with NFTs is the potential to set up royalties. This means, that each time the token is (re)sold, a certain percentage goes back to the issuer. This is very important as creative work tends to increase in value over time. It helps creators benefit from the true value of their work.
As NFT ticketing is what we do here as Oveit, we’ve elaborated on this subject on different occasions. NFT ticketing is one of the best use cases to prove how useful NFTs are to the entertainment industry. But If it would be to name just one benefit, this would be protecting your community. And here is how:
Event ticketing fraud is mainly aimed at ticket buyers. Scalpers are looking for easy money by buying and reselling tickets for outstanding prices. Fraudsters are selling fake tickets. Or they’re selling the same legit ticket to numerous buyers.
With the help of NFT tickets, you can set up upper prices for your tickets on the secondary market as well. Being governed by a smart contract, this smart ticket can limit itself when it comes to price or how many times it can be resold. At the same time, ownership and authenticity are embedded into a smart ticket. This way, no one could ever sell fake NFT tickets or deceive tens of hundreds of people by selling the same ticket.
There are plenty of examples of how NFTs enrich the music sector. Music NFTs are pretty common as this is a great way for artists and fans to come together. Usually, music NFTs will offer buyers access to exclusive content together with extra benefits for future releases and events.
You’ve probably heard of Steve Aoki, Snoop Dog, and Don Diablo selling NFT Music for millions. What’s amazing is how this technology can support smaller artists to protect their work.
So instead of focusing on the celebrities that sold Music NFTs, let’s take a look at Verdigris Ensemble, a choir from Dallas. They’ve recorded a 21-minute-long unique interpretation, tokenized it, and listed it for auction as an NFT. It was sold for 56.4 ETH (in May 2021 that worth around $375.00) and they shared the revenue amongst those that took part in the recording.
And this is just one of the cases. More independent music artists are tokenizing their artwork and selling it as NFTs. This allows them to have a direct connection with their fans. And support their business through digitalized ownership.
When it comes to gaming, NFTs take a different form, with both already established companies and web3 startups. In the long run, NFTs will allow players not only to swap assets like skins and weapons. But will also allow them to transfer assets from one game to another. By transforming it into an NFT, the item becomes an immutable token and the player has full control over it. Furthermore, players will be able to use them long after they stop playing a specific game. Or if the developer stops supporting it.
Let’s also take a look at some real examples of using NFTs in the gaming industry.
Have you heard of CryptoKitties? This game allows you to collect and trade digital cats and each cat is an NFT. Will web3 evolve around cute cats as well?
Decentraland is a 3D virtual world where users can play, engage and in various activities, and buy virtual land plots. Not a game in the way we are currently used to, but through gamification, they encourage people to be active in a shared digital world.
Focusing on the classics, Konami sold an NFT collection of 14 NFTs to celebrate 35 since Castlevania saw daylight. Along with the income resulting from the direct sale, the company also keeps 10% of future resales in the form of royalties. Showing that they trust the collection’s value will grow over time.
As I have already mentioned, our example is a perfect showcase of how to use NFTs in the movie industry. This is a flawless process that allows communities and artists to work together. Fans can support projects they believe in, while creators have an easy way to transfer ownership toward their supporters.
For The Whishing Tree – Childhood Memories, we’ve extracted 12.432 video frames. We’ve tokenized them, and sold them as NFTs. This way, everybody that wanted to support this movie (revenue went to a non-profit organization that treats patients with palliative conditions) was able to actually own part of it. The price of an NFT is equal to the cost of home visits made by the non-profit. And the number of frames represents the number of visits they made in 2021.
And while The Wishing Tree – Childhood Memories is one of the first movies sold as NFTs, it will definitely not be the last. “Zero Contact”, one of Antony Hopkins’ newest projects, is also set up as a non-fungible token, making the movie a limited collection. One of the main benefits of NFT Movies, deployed on the blockchain ledger, is that it is protected against piracy. But it can also allow NFT owners access to special extra benefits. Physical or digital.
Just like for music, NFTs can support independent filmmakers who can tokenize and sell their work. Buyers become owners of that specific project. And at the same time, they can benefit from special discounts for future projects, access to premieres, or limited and personalized content.
As Oveit is a company focusing on Web3 ticketing and cashless payments, it was impossible for me to omit ticketing from this list. Events, in the form of token-gated events, will probably benefit the most from this technology. It’s not about stopping someone to access your event with a counterfeited ticket. It solved problems much bigger than that. An NFT ticket is the gateway for a completely new experience. In fact, although we name them NFT tickets, these digital assets are completely different from what we know as event tickets.
There are a lot of great ways we can use NFTs in. And the entertainment industry definitely benefits them. But just like pretty much anything else, there are some concerns about NFTs. And some of them are valid.
Usually, any subject that generates so much hype is used for PR stunts. NFTs made no difference. So, often NFTs without any practical utility were released. And this, in time, affected the whole community. Luckily, more and more projects showcasing the true utility of this technology were born. But there are still 2 main concerns about NFTs and blockchain technology.
What makes NFTs powerful is also making them unfriendly to the environment. Each transaction within a blockchain network is checked and approved in a certain way. As these networks grew in size, so does the need for computing power. But, depending on the cryptographic proof needed to operate the system, there are many differences between different blockchains. While the initial proof-of-work protocol used by bitcoin requires large energy resources, a proof-of-stake validation is more efficient. And while this does not completely solve the environmental footprint issues associated with blockchain ledgers (and NFTs), it’s a big step forward to solving the problem.
As for any new technology, it will take time until NFTs are mass-adopted. The utility of this technology is helping businesses and customers interact in ways never seen before. But it’s still difficult to deliver these experiences to all potential customers.
The transition from web2 to web3 is going to take place over the next few years. And the success of this transition depends on how easy the onboarding process is. And while early adopters are adopting the new technology, it’s going to take a collective push toward mass adoption.
[…]the approach they’re gonna come to us because we’re this cool culture, this cool movement, is just not realistic. Simplifying the process, improving UI & UX, and allowing for that migration to actually happen. I think anyone that kind of stresses that process and makes sure that that’s an integral point of their product is said to have a lot of users.
Yet, experts from McCann Worldgroup expect that by 2026, there will be more than 2 billion web3 users worldwide, accounting for more than 40% of total internet users. Web3 is rapidly gaining ground. And powered by the benefits they provide, so do NFTs.
I hope this article answers the question it’s built around. Although there are (at least) 2 main concerns related to NFTs, the benefits are countless. These new technologies are creating a direct connection between creators and fans. Are allowing communities to easily support artists in a transparent manner. And it helps the latter to reword their supporters.
It’s out of my area of expertise to guess when mass adoption will be reached. But for sure that the critical mass has been reached. The benefits provided by NFTs are allowing us to create better experiences, encouraging end-users to onboard this thrilling ride. So yes, I would definitely say NFTs are useful in entertainment. More than we can even imagine. At least for the moment.