Think for a moment that you have well over 10,000 domain names. You are on the phone with a client, he's ready to buy now, and asks you the magic question "well, what do you have?" What will your reply be? "Uhm.. well, hold on... let me log into my registrar.." all the while fumbling with your 2-factor auth code that is taking longer than usual to come (like it always does when you're in a rush). Or... Will you be a boss, switch over to your spreadsheet and start naming off domain names? Do you ask them what kind of domain they are seeking? If so? Can you sort your domains by their wants and needs? What if they ask you for a 2 word .com with more than 10,000 searches a month that is aged at least 10 years... what do you do? If you are not organized and ready to answer these questions, you are leaving so much money on the table long term that you would be better off quitting today before that number gives you a heart attack 20 years from now. That's how seriously I take this. Overall, this will help you in more ways than one. That is why I made the video and I hope you take something away from it. Enjoy!
Hey Guys! Ali Zandi here: Zandibot.com. Today I want to jump into organizing your domain portfolio. I think it’s super crucial that you have a highly optimized and highly organized domain portfolio so that you can, not only keep track of all of your domain names, you can keep track of their costs, the dates you bought them, their expiration dates, categories, and a whole lot of other statistics that you can recall all of your domains by. The best thing you can do is to organize your portfolio as soon as you can. It can be a really tedious task if you wait too long and you accrue thousands of domain names like some of us have. But, I’ve spent some time organizing my portfolio, and, it was a real pain but I ended up with something I really, really liked, and it’s functional for me and my investing future.So, I’m going to jump right into it. The first thing you’re going to need to do is to open up a spreadsheet. Something like Google Sheets, Excel or Numbers (on Mac) will work just fine. Once you have it open, the best thing you can do is start making your headers and titling them. This is basically what you are going to be organizing your portfolio with - is all of these titled columns and headers that you’ll have and you can freeze, and you can, you know, scroll up and down, sort alphabetically (from A-Z and Z-A, so on and so forth). Being that I have an Afternic-centric portfolio, I usually download the Afternic blank spreadsheet. That gives me access to a ton of different categories that I can give my domain names - so I can sort by category. It also allows me to set up my spreadsheet in a way where uploading to Afternic, anytime I make a change, is a lot easier and smoother. So if you have an Afternic account, you want to sign in. Once you’re signed in, you’re going to go down to PORTFOLIO, click ADD DOMAINS. Once it opens, you can see over here: UPLOAD A SPREADSHEET. You’re going to want to download the BLANK TEMPLATE. So click this and it should download. Once it’s downloaded, you can open it up and you can take a look at all the different sheets that are in this blank template. The most important ones for me are going to be ‘My List of Domains’ and the ‘Category Details’. The ‘Category Details’ is going to let me come in here and really find a perfect category and sub-category to apply to a domain name, so that I can organize my spreadsheet, or organize by names and sort through ‘em via a category. So, I’m going to go over here to ‘My List of Domains’. I usually just take all the headers, copy ‘em (because I’m going to need all of these when I’m uploading to Afternic). So I take all of these, and I come back here to my spreadsheet. I’m just going to paste them in there. Now I have all the Afternic headers right? So what I want to do is…I’m going to size them, and then, you know, the ones that are not required, like: ‘Reserve Price’ - I never put a reserve price, so I’m going to bury that one over here. ‘Floor Price’ - I always use. ‘Buy It Now Price’ - I always use. Here’s your ‘Categories’. Leave blank – shut it down. Leave blank – shut it down. I leave ‘em there. I don’t delete ‘em because when I copy and paste, like I highlight all and I ship it over. So as long as that column’s there, it doesn’t matter if it’s hidden. As long as it translates over to the spreadsheet and leaves this blank, verses, you know, that being deleted and being filled with like description because it’ll move over. ‘Description’ – sometimes I used, sometimes I don’t, so I’ll leave it open. ‘Listing Status’ – that’s required. These are leave blanks. Leave blanks. So I’ll shut those down. Alright, so now I have my Afternic headers. But that’s not all I want to be able to sort my domain portfolio by. So what I’m going to do, I’m going to take these guys here and I’m going to add – I like to add my columns to the left, my custom columns. I’ll ‘Add Column’ to the left. You can add them to the right, it doesn’t matter. So I’m going to insert thirteen (13) to the left here. I’m going to size these all down. Alright, so these are Afternic’s , these are my custom ones. I don’t like that color. I’m going to change the color. I’m going to change. I’m going to center everything, and I’m going to give the font a white color there, make sure it’s bold – it stands out. Alright, perfect! I’m going to add another row above here. I always like adding a row above for like, totals. Let’s say, ‘Acquisition Cost Totals’ where I can do, you know, I can put ‘cost’ here and then up here I can create a formula, but we’ll get into that. So let’s say, first column I want to be able to sort by is the date I bought it. So I put, ‘BUY DATE’. Right? And then the next column I want to sort it by length. So we’ll go ‘LENGTH’. Next column. Let’s say search volume so I’ll just put ‘SV’. You know I like to make these columns as small as possible. So, let’s see, I’ll give them some acronyms. You can name yours whatever you want. I like to give mine acronyms because it makes the columns smaller. And then, you know and then I can sort through them. I can put ‘CPC’ in here. I can put ‘Age’. I can put – let’s see, let’s see – most importantly, ‘Cost’. How much did it cost me? So cost, I want to highlight it. I like highlighting and giving specific ones, you know, specific colors. Cost – Red; red is a cost. It’s a negative. I like the color red. You can color yours however you want. So ‘Buy Date’, ‘Length’, ‘Search Volume’, ‘CPC’, ‘Age’, ‘Cost’. I like to do ‘Type’ – you can name this whatever you want. We’ll get into that. Something like I would put ‘One word’ – like it’s a one-word domain. That’s the type of domain it is - it’s a one- word domain. We’ll get further into that. So ‘Type’, we’ll go ‘TLD’. Let’s see! ‘Buy Date’, ‘Length’, ‘Search Volume’, ‘CPC’, ‘Age’, ‘Cost’, ‘Type’, ‘TLD’. What else can we organize by? We can put ‘Expiration’ (EXPIRATION). Something I’ve been doing lately is I’ve been registering my domains for ten years at a time, at least the ones I plan to hold long term. And then I could put the expiration in here and consolidate them all. Let’s say all of my domains will expire, January 1st 2025, then you know I could put, you know, [types January 1st 2025]. And I could sort by that. I could be like, ‘Hey! How many of these have I paid 10 years registration for?” Should I sell it right now? Do I need to, you know, lower my price? I mean, it’s already paid for, I might as well hold on to it. So these are some of the things you can keep in mind and sort by. So lets say – we’ve got these. You know, obviously, you can keep going and going and going with the different, you know, types of sorting. But I think I have the ones I want to start with and I can always add more afterwards. So now, let’s just delete these for now. And as I go, I’ll think of other things. So let’s say – ‘Buy Date’. Let’s say I bought a domain today. What’s the date today? Today is the 7th. So we have four – do we have 4? Where are we at? [types 4/7/2016]. Don’t know the length. Don’t know da, da, da, da. Okay, so the domain name. What did I buy today? Let’s just say I bought domainname, you know, domainname.com. Whatever! And then the ‘Expiration’, let’s say I paid it up to January 1st 2025. ‘TLD’ – it’s a ‘com’. I don’t like to put periods before the ‘com’ because when I go to sort it, I want to sort it by the letter, not the period. It’s just lest work for me. The ‘Type’ – it’s a two-word. Let’s see! It is a two-word domain. Ok. ‘Cost’ – Let’s say I paid- Lord knows it’s a lot more valuable than this - but let’s just say I paid, for instance, I paid twenty-five grand to pick it up a long time ago. ‘Age’ – it’s ancient. Let’s just say it’s twenty plus years old, right? It’s twenty years old. I don’t know the exact age of domainname.com. It’s just an example. ‘CPC’ – let’s say it’s eight dollars and ninety-two cents. ‘Search Volume’ – I’m assuming it’s dramatic, but we’ll put, let’s just put five hundred thousand. ‘Length’ – So what do we got here? One, two, three, four, five, six, seven, eight, nine, then. It’s a ten-letter domain. Alright, so now I have domainname.com basically organized in my spreadsheet. Right? So it’s in my - it’s in my portfolio. I have it in here. Now I can go over here and be like, “What do I want to price it? What kind of category do I want to put it under? You know, and what my floor price is? And a description” So let’s say ‘Minimum Offer’ – I won’t even talk to you if you don’t come with at least a two hundred and fifty thousand dollar minimum offer. (You don’t want to put dollar signs or commas in anything to the right over here in the Afternic upload because when you upload it, it even states in their upload instructions – somewhere- it says that you should not put dollar signs. Where is the dollar sign here? There it is: “Do not include the dollar sign symbol.” And don’t even put commas in there either.) Okay, so two hundred and fifty thousand. Say the ‘Floor Price’ – so the floor price in Afternic is the minimum amount you’re willing to allow the Afternic brokers to negotiate on your behalf without asking you. So put this at a number where you feel comfortable selling the domain without even being bothered should an Afternic broker be involved in making the sale for you. So, let’s say, you know, ‘Floor Price’ – we put a million dollars. ‘Buy It Now Price’ – we’ll just, you know, whatever - five million. ‘First level Category’ - So now you can go over to the Afternic BLANK TEMPLATE. You can go to ‘Category Details’. From here, you know, you can go down, let’s say, domainname.com - we’ll put business. Right. It’s a - it’s business domain. Let’s say, ‘Category’ (you know, we’re not really going to categorize domainname.com. It’s just an example. ) - ‘Business.’ And then it’s a, let’s say domainname.com is going to be a, you know, management service for domain names or what not. Ok, so we got the category, we got first level, second level and then listing status. So what is listing status? We’re going to come over here: [Reads Afternic’s guide: “Three equals for sale through domain resellers”] So we’ll just put a listing status of three. It’s required, so I’m just going to paste it all the way down to the bottom here, just so that it’s always there. Okay! So we have all of these different headers that we can categorize and sort through our portfolio with. Now, ‘Description’ - you can put it in there if you want do. Description shows up on the Afternic landing pages. Here! Actually, let me just give you an example here. Let’s go [types HDPC.com in search browser] So ‘Description’ - I haven’t put a description on this one, but this is where it shows up. So ‘Description’, it shows up right there right? And then ‘Categories’, it shows here. ‘One and two characters’ – oh that’s not correct. I have to fix that! ‘Listing dates’ - so on and so forth. Ok. Back to it! We don’t need that anymore. Alright, so that’s done, that domain name is in here. That’s categorized, that’s in there and it’s saved. So lets add a few more as a demonstration. One, two, three, four - let’s just make ten domains. Let’s say this one is health.org, this one is security.net, dollar.com, you know, truth.io, whatever.whatever, and, you know, so on and so forth. Domain.org, Domainnet.com. Okay, so on and so forth. Now, we’ve got all these different type of domains in our portfolio. So this is a dot-org, this is a dot-net, com, io, whatever, org, com. This is a two-word. This is going to be a one-word. I always list my ngTLDs as two words or three words. I just remove the dot and count the words. That’s just how I like to categorize them. It’s totally up to you how you do yours. This is one-word, one-word, one-word, so we just copy these- paste, paste. Let’s say I pay thirty five thousand for this, five thousand for this, nine thousand, eight hundred, six thousand. Ok. These are all just examples right? Just showing you exactly, you know, how it’s going to work when you go and organize your portfolio and you need to recall stuff. It’s super important that you have, you know, everything set up to the point where, if you get asked, ‘Hey! What else do you have in the, you know, business management vertical that I can take a look at?” Well you can go okay, “Okay. Hang on one second.” You categorize these by business and then you know, you can categorize second level by management and you can go okay I’ve got these domains. Boom! Boom! Boom! Let me send them to you! You know, and as you can imagine, the different every row is, the more stuff you’re going to be able to sort. So like, all my prices here, I can say, “Hey! What’s my most expensive domain? (Oops! Let me freeze these headers. Another good point - go to View-Freeze - Up to two rows. Since I have two rows here, I want to freeze them.) So, I’ll tell you what my most expensive domain. I want to sort it. Hey look! Forty-seven grand -Domainnet.com – I paid forty-seven grand for it. It’s not really my domain. But yeah! So you can sort everything. What’s my oldest domain? What’s my highest CPC? What’s my highest search volume? Lowest? What’s the longest domain? The shortest domain? When did I buy it? How old is it? When does it expire? You know, the more data that you have that you can sort through for your domains names, the better it is. So now let’s say you got all your domains- ten thousand domains sorted right here. All, you know, you have all of your categories. Everything has a different category. You come in here, you know, you got all this stuff categorized and so on and so forth. Whatever! Done. But what about the domain names that are pending? Like, you just bought them, say, you know, at Flippa and it’s being pushed to your GoDaddy account. You’re just waiting, waiting, waiting, waiting. Whatever it is! You bought it ‘Buy It Now’ and it’s transferring, you know, it doesn’t matter. You create a second sheet. Right! So I’m – I’m just going to just highlight everything, take it over to sheet 2, and I’m going to paste it. So now I have all this stuff again. Let’s see ba ba ba. And I’m going to delete it. Ah, more columns I thought about. Let’s see here. I’m going to add one here and one here. So, I like to have ‘Notes’ and ‘Registrar’. Bingo! Alright! So I’ll go, I’ll go back here, get all these, highlight them, paste them. Boom! Ok. Get rid of this stuff. Okay so let’s say you have domains that you just bought; they’re pending transfer. You know, you’re not quite ready to take them over to….let’s say - [types ‘DOMAINS’ and then ‘PENDING DOMAINS’ ] I can name this sheet here. So I have my live domains and I have my pending domains. So let’s say I’m waiting for, you know, thisdomain.com to hit my account. I can fill out all this information, you know, get it all prepped and ready. (Actually, I can change the heading color just a little bit here so I know it’s PENDING DOMAINS. Let’s see! Yeah! Just so that I am reminded before I go and start offering the domain for sale.) Ok, so it’s a different color. Now, I can fill out all this information down here. Right! So, let’s say, let’s just take this, for instance. And let’s say this domain is pending. It hasn’t hit my account yet. I can’t sell it; I’m just sitting around. I have it waiting in here. So, the moment I get the email from, say GoDaddy, and it’s like, “Hey! Your domain transfer is complete.” I can highlight this row, come back, plop it in here. Boom! My domain is now in my category of domains that I have open and that are available for sale. Again, more stuff I can add here. Let’s see! So I can put a ‘STATUS’ row. Now, for me I like to do different colored statuses, like, if this one is at Afternic. Right! So it’s posted for sale. Let’s say these are all posted for sale at Afternic. Let me center these. I’m going to give it a different color. Let’s say I’ll just color it blue. And then let’s say these are at, you know, these are at GoDaddy auctions. Right! (Copy and paste these. So let me bold and center this entire row here.) So, these are at GoDaddy auctions. And then let’s say, for instance these are ‘PENDING NEGOTIATION’. You know, and then you can have stuff like ‘IN ESCROW,’ so on and so on and so on. You know, different colors help so that way when you sort it, it stands out more. You can see all the domains in that category. It helps me. So you know you can add these, add these, blah, blah, blah, so on and so forth. So now that your entire portfolio is organized. You have all your pending domains waiting to be pushed over to your live domains spreadsheet. And then, okay, so all your domains are uploaded. Now, you want to put them up on Afternic. Super easy! All you got to do is grab all these rows, copy them, head over to ‘My list of Domains,’ paste them. Right! Go to File-Export-CSV. Right! Hit next. Go to Desktop –(upload)upload CSV. Boom! That’s it! Then you hop back over to Afternic, click the ‘UPLOAD SPREADSHEET’ button, choose FILE. Right! You open this up - the ‘UPLOAD CSV’ folder. Right! Click ‘My List of Domains’ - double check it, you got them all. And then you click ‘UPLOAD FILE’, and all of your domains are uploaded and they’re still organized; they’re always organized. You never have to worry about them again. So once you get into the, the mode of listing your domains in here and just taking a few minutes (tops) to put one of your domains. Let’s say you bought 20 domains that day. At the end of the day, get in here and organize them. I mean, you can have hundreds and hundreds of columns if you want to. It really, really doesn’t matter. It’s totally up to you. It’s a preference. But if you are an Afternic user; if you are this passive sales kind of person, where you have thousands of domains and you just want them all organized all in one place, then get these columns handled. And make sure they’re always to the left or always to the right - doesn’t matter which side. But as long as you can grab them all at once, head over to your spreadsheet and just paste. You know what I mean? That’s that. It’s super easy! And that’s my little organization tutorial. I hope you guys enjoy it. If you have any questions, any concerns, anything pops up or even have any ideas, just comment below. Let me know what works for you because you never know what you tell me might work better for me than what I’m doing. Or somebody else might pick something up on it. It’s always awesome to share things. ‘Preciate you guys coming by. Zandibot.com. Bang For Your Buck! Have a good one!