Using Excel to Keep Sale Portfolios Updated

Keeping a portfolio updated on platforms like Sedo, Afternic, and Dan can be a challenge. With sales and expiries happening on a regular basis, it can be easy to fall behind on updates. It is important to keep these portfolios updated so you don’t accidentally sell a domain name you previously sold or let expire.

I try to keep my portfolio updated in real time. When I sell a name on Dan, for example, I try to immediately delete the listing on Sedo and Afternic. When I let a domain name expire, I remove the listing from all platforms once I receive the final cancelation email. They key word is *try* and names sometimes slip through the cracks. Every once in a while I will do a comparison of my sale portfolios against my inventory list.

I am not a pro at Excel, but I want to share a step by step guide for how I am able to identify the names I previously sold or let expire that I forgot to remove from sales platforms:

  • Step 1: Paste my current inventory list in column A of a new Excel spreadsheet.
  • Step 2: Export data from sale platform. There is a different method for each platform.
  • Step 3: Copy the domain names listed for sale and paste them into column B of the Excel spreadsheet.
  • Step 4: Highlight column A and B.
  • Step 5: On the Home section of the Excel spreadsheet, click “Conditional Formatting.”
  • Step 6: Select “Highlight Cells Rules” from the dropdown menu.
  • Step 7: Click “Duplicate Values.”
  • Step 8: From the dropdown menu, select “Format only unique or duplicate values” formatted with light red fill.
  • Step 9: Compare the sales platform portfolio to inventory.
  • Step 10: If a domain name from the sales platform portfolio does not have red fill (highlight), it means it is not in the inventory list. The means the domain name was sold, expired, or there is a typo on one of the lists.
  • Step 11: Delete any domain names that are no longer in inventory.

When I did this for my Sedo sales portfolio today, I found seven domain names listed for sale that should be deleted. Four had previously expired and three were about to expire. Importantly, this method requires that the inventory list is accurate.

Keeping a sales portfolio updated will help prevent a seller from selling a domain name that he or she no longer owns. There may be other better ways to do this, but this is how I do it.

Elliot Silver
Elliot Silver
About The Author: Elliot Silver is an Internet entrepreneur and publisher of DomainInvesting.com. Elliot is also the founder and President of Top Notch Domains, LLC, a company that has closed eight figures in deals. Please read the DomainInvesting.com Terms of Use page for additional information about the publisher, website comment policy, disclosures, and conflicts of interest. Reach out to Elliot: Twitter | Facebook | LinkedIn

8 COMMENTS

  1. It had been a while since I had used Excel and last week enumerating a part of the domain portfolio went well.
    There was still a lot to do, your post has gone very well.
    Thanks for sharing Elliott!

  2. I just download all the domains from my registrars, delete all the domains in Dan afternic sedo and let it sit empty for 2 days and upload the fresh domains back.
    Easy peasy
    Do that every 2 mths

  3. And I put all my domains at minimum offer at $4999 ,this is to avoid low ballers.
    The default is $20 and you gonna get spams
    I sold so my hand reg domains….

  4. Have you tried Domain.io? It does this for you — it monitors your portfolio by frequently checking the pricing on Dan/Afternic/Sedo and notifying you of any discrepancies. You can manage and adjust your portfolio pricing in one place and then export the individual CSVs to update Dan/Afternic/Sedo.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Posts

Rookie Mistake: Reading Expiry Lists at Breakfast

0
Every morning, as early as I am awake, I look through domain name expiry lists to see what is coming up for auction. I'll...

GoDaddy Auctions Running NameFind Auctions

0
GoDaddy is running a featured auction via its GoDaddy Auctions platform with domain names from its NameFind portfolio. While I would argue the domain...

Spaceship Hits 1 Million DUM – Only 13% of New Registrations are .com

3
Earlier this morning, Richard Kirkendall shared that Spaceship hit the 1 million Domains Under Management (DUM) mark. Richard is the Founder of Namecheap and...

Converse.CO UDRP Decision Turns on Price Inference

6
In general, I thought UDRP panels have gotten past the issue of pricing as it relates to generic / descriptive one word domain names....

Ebbs and Flows of Domain Investing

3
My domain investment portfolio has grown from around 500 domain names to around 2,000 domain names in the last several years. Even at that...