Speaker 1: At first glance, you might think an Apple Keynote is a very different event compared to say, my last birthday party. Yes, WWDC might be on a slightly higher budget, but there are many similarities as well. Both events have attendees who in turn have to go through some sort of registration or invitation process. My party is a bit more exclusive by the way. They both have a set agenda, both have some sort of promotional materials to let people know about the event. And those materials need to be distributed through various channels. And of course, it doesn't hurt to have a charismatic, good-looking and very tastefully dressed host. All right, jokes aside, although the scale of those two events are extremely different, the cool thing about event management is that the structure you use and the process you follow more or less stays the same. Let's get started. Hi friends, welcome back to channel. If you're new here, my name is Jeff. I'm a product marketing manager at a large technology company. And in the past five years, I've planned and executed hundreds of offline and online events. These events include both small-scale C-level round tables that take place in a single afternoon and thousand people webinar series that go on for several months. Now, event management is an extremely broad topic that cannot be covered in a single YouTube video. So I created a free event management 101 course over at Skillshare and included some of the key highlights in this video as well. Basically, I walk you through step-by-step the entire event planning process on Google Sheets, share how I structure the spreadsheet for cross-team collaboration, and talk about the purpose of each tab. To be completely transparent, if you just wanna be a bit less amateur when it comes to planning the next happy hour or team offsite, the concepts I'll go through in this video is more than enough. If you're a professional who comes into regular contact with events at work or even an aspiring marketer, then I highly recommend you go through that course because that's what I wish I could have had when I joined the marketing team. Without further ado, let's dive in. Right off the bat, you'll notice I've split this Google Sheet to the six different sections, overview, key information, pre-event, during event, post-event, and raw data using these empty tabs and section headers, and these are all color-coded as well, right? And you do this for two reasons. Number one, you're gonna receive a lot of questions about the event from different stakeholders, and you need to find that information as quickly as possible. And number two, because there's so many teams involved in event planning, you want the spreadsheet to be as self-explanatory as possible. The idea of the overview tab is very simple. Imagine someone with zero background of the event comes across this spreadsheet. After they look through the information on this tab, they should have a general understanding of what the event is about without having to ask you directly. Key information tabs include RSVP snapshot, agenda, promotion channels, and comms timeline. And the way to think about these four tabs is also very simple. Just imagine if someone very senior, like your manager or another team's director, message you about the event. What would they be asking about? 99% of the time, the answer can be found in one of these four tabs. They might ask about how many people have signed up so far, RSVP snapshot, how the content is coming along, agenda tab, which promotion channel is driving the most signups, promo channels, and when we're sending the next confirmation or a minor email out, comms timeline. For us, the project managers, every single one of these tabs within the spreadsheet is important, right? But trust me when I tell you, very few senior managers will care about all the specific details and will only want the high level information that you have so thoughtfully already consolidated in the key information section here. Pre-event tabs. This is where the pre, during, and post method comes in. Broadly speaking, this part just helps you organize all the things you need to plan before the event actually takes place, hence pre-event. During event tabs list out the things you need to take care of during the event, and you guessed it, post here means post office. No, post event tabs help you organize the things you need to do after the event is complete. Quick note, these yellow, purple, and green tabs are by no means an exhaustive list of tabs you need for each section, but this provides a very good start. And as long as you think about it in this way, like before, during, and after the event, we decrease the chances of missing something important. Raw data tabs, this is exactly like it sounds. This is where you keep all the raw data you collect throughout the event planning and execution process, like registration data, attendee data, engagement data, post event survey data. They're all kept here, and I like to mark these in gray. Over the next few lessons, I'm gonna deep dive into each one of these tabs and explain that tab's purpose, go over the formatting and formulas within, and make adjustments based on real life situations. Okay, let's dive. All right, and we're back. I hope you enjoyed that snippet of the event management 101 course. There are a total of 11 lessons over at Skillshare, and it covers the exact structure I use when I plan and manage events at work as a product marketing manager. If that was at all interesting, you can use the link down below to sign up to a two-month free trial of Skillshare. They're not sponsoring this video, by the way. Also down below is the exact event management template I go through, so you can make a copy of that as well. It might be slightly confusing without the accompanying explanations and the real-time adjustments I make within the course, but I didn't wanna hold back any resources from you guys because I'm an angel, remember? Anyways, let me know down in the comments what you think. See you on the next video, and in the meantime, have a great one.