How to Create Multiple Short Links Using Okurl.io by Excel Form

Okay, everybody. We will go through how to create short links in a large amount of, you know, number. So, because sometimes when we do promotion, we have many links. They are in the same tracking or maybe different tracking, but we want them to create, you know, like quickly. Not one by one, but just, you know, put together and get it once. So, yeah, there is, you know, some way we can do it. So, let's open OKURL. This is OKURL. I saved it here. But also, you can type OKURL here or use your saved link. OKURL.IO and then you type OK. And then this is my OKURL. I already logged in. And we're going to go through real quick for the, you know, short links we make one by one, like individually. So, here you have a link. For instance, you can copy it from here and paste it here. Yeah, this is the link. Or maybe I just use one. I can save it here. And paste it here, a video, and then shorten. I make it shorten and then you have this UTMBuilder here. And then you go UTMBuilder. Source means how you're going to promote it. For instance, you promote it using X, Twitter.com, or Facebook. And then Medium. Medium means like a country, like which team is promoting it. Like the United States. Once I type the U, the United States will jump out. So remember, all the characters, we want only the small characters. And if there is two words, then you use this underline to connect them. So we also have a form that shows the standard country name and the terms. And you can check how to create the short links we have before. And then you can find it in Medium, Country, and Terms, how we're going to define it. And Campaign is how we need outreach. Outreach and Term. Term means that we have several categories of terms. So then you must use the standard words. And don't create it by yourself, but you write the standard term. And then Content. Content is very unique, like we can find the U. So for instance, my name is Xinyu. Put it here. And the source platform is somewhere under your country, like the United States. We have many states. So I'm in New York. I put New York here. And then you put UTM Builder here. And the builder, they will build it to this link by themselves. You don't have to change anything, and it will do it by itself. Here you have a short soft sign-up and hard sign-up. Soft sign-up means it will come out a sign after 30 minutes. But you can cross it. You can close it. You don't have to sign up. But if you put the hard sign-up, well, that means they have to sign up. Otherwise, they won't continue to look at your content. So you can choose whichever you want. And then here is the short URL. And it can create a random name for you. But you also can write by yourself. For instance, this is a movie. I write movie. You just put it here. And then finally you can find out this name and give you a reminder. Oh, this is a movie. This is what it's about. So it's easier for you to find it later on. Okay, so I just created it. So I changed it. I put it number one. And then you can copy this to use. And then you can also create a QR code here. And you download the QR code. And then you can try using the QR code to scan. You can see this is the short link you created. And this is the target long link. And you can read the UTM, whatever, here. But right now, for instance, we have this support. We have 40 links. We want to make them into the short links. For instance, here. See, we have all these original links. We want to create the short links for them in an easier way. So how to use OKQL to create multiple short links? So you go to all links on the left-hand. And then go all links. And then on the top, you will have import Excel. Then you click the import Excel. And then go into the page. Create short links from Excel like this. In Excel, you can list all the information in one place. And they will create the short links at once. So it's easier. But once you go in here, you need to download the template. And fill in the information you need. So I download the template. Download it here. I open it. So this is the template. You have to use this template at the first time. But afterwards, you know how they put it this way. And then next time, you can create it on your own. So this URL. This is the original link. And the title. And also this is slug. You don't have to put into anything. Because this is the short links they created randomly for you to make. And this is the tracking information. You can source, medium. Like we put into the indie video. Like how to play the indie videos. So they are the same. But they listed here all at once. So then it can help you to do it quickly. So original URL. We have this form. So you can copy it directly. You can also put it. Because sometimes it's not in itself. And you can also put it by yourself. So put it inside. And then the next, title. So this is the title. Like the title of the videos, the shirts. And then you copy it. And then you type here. You paste it here. So this is the original link. And the title. And the slug. You don't have to. And the source. You put it here. And once you put it here, the source. For instance, you will use X to create it. So you will use X to create it. And then you can drag it down. And they are all X. Or if not all X, then you can put Facebook or something. A different one. Because when you're tracking, actually, you put what you want to track in the source. And the medium. Last time, we have United States. And then you put it here. You put your mouse here. Dragging it down. And then it goes to here. They are all United States. But they can be different. No problem. You just put whatever for them. And for the campaign, it always be all H. So you paste or you type in all H. You put your mouse on the very end. And drag it down. And they are all H automatically. And the term. So we have this category. You use this category. Select and copy. And then you put it here. And then paste. Yeah, sometimes it pastes like this. Because they have the Excel formula here. So then you can click, right click. And then you choose values. Like how they put it here. And then it will show up as the words. Exactly the words. And the UTM content. Content means it's very unique words. Like people can find it. So for instance, I'll put Xinyu. It's my channel name. And I put it down here. And they are all Xinyu. And the first example. Like something under the country. We have New York State. Alright. So then you fill in all of this with the template. So we are now done. So we right now save this from the file. And then we save as. And then save as a name. Because this is a 14. So I will save 3914. And the dash 1. And we put it here. And then we save it. Alright. So this is the form we saved. After we save the form. Then we will go back to the OKURL. So right now we download the Excel template. We put the tracking information. By source, medium, content, that kind of thing. And then we go to the short link domain. We will use OKURL.io. But if you have gjw.us, you can also use it. But OKURL.io is the same. Just use different name. There are a lot of difference regarding to create the short links. So Excel form. So then because we already made the Excel form. We will choose the Excel form. And then this one. Excel form. We select it. And then open. Put it here. And then we right now start this here. But you can also upload and preview. Because you put it here. You need to upload it. And then you can preview. You see. Oh, this is pending. This is pending. Because they are strapped into different lines. So pending. And this is your. You see. You are OK with the tracking information. And the original link. Right. So OK. Since everything fine. And there is UTM. You have seen New York. Category. Outreach. And so. And X. You check everything correct. And then you start. Oh. Oh, sorry. So I'm going to choose. So I'm going to use. And choose file. Click file. And then upload and preview. OK. Everything correct. And then come back. And start resume. So once you start resume. You can see this is waiting list. And it created here. Then you can see what's going on. And then you can see. OK. So this one create short. The finish. And then if you are waiting for another one. It will automatically fill it for you. You see. Another one. And then it will go through one by one. Until the very end. So what you need to do is just wait. Or you can do other things. And then come back. So. We're going to. You can pause it here too. But you don't have to wait. Because you know. You see. It still takes a little time. I'm going to pause it. And I download the results. So this is your results. So I'm going to download it. You see. This is the four of them. It created for me. This is the status. Success. And all others is still pending. And the ID. This doesn't matter. So this is the short. You know. URL you can use. And this is the title. This is the slog. You can see like. The one created randomly. So then this is the URL. Original. And also this is. You know. Your input. The. This is the original URL. With the tracking UTM. Like the information. And this is the. You input the title. You input the original. What you want. Okay. This is everything. Then you can save it from the file. Save. A name. So like a result. And then. Search. Results. It tells you results. And then you save it. Like search. 0914. Search. Okay. Alright. So this is the way. How we create the short links. And you know. Multiple ones. Large number. And it's easier. Alright. Thank you.