How Do YOU Manage All Your Sites?

Haha I thought I was so primitive using Folders and Notepad.
It appears I am still hip

RedClover

Autumn said:

When I generate a site, I also generate a .txt file that goes in the root directory that describes the url structure and the keywords used. Also all url and keyword data goes into a mysql database, along with the niche and batch, so if I want to return a bunch of urls that use the same keyword, are in the same niche, or belong to the same batch of sites, it's easy.

All my backlinks go into a mysql database so it's easy to pull out random backlinks for backlinking my backlinks.

Click to expand...

That is a really smart move putting your backlinks in a SQL database. I may take a day to organize all my website links this way. Brilliant thank you for the suggestion! Mind if I ask what data you store aside from backlinks URL and site URL?

0_00_0 said:

That is a really smart move putting your backlinks in a SQL database. I may take a day to organize all my website links this way. Brilliant thank you for the suggestion! Mind if I ask what data you store aside from backlinks URL and site URL?

Click to expand...

At the moment for backlinks I just store the backlink url. Storing the url of the site I'm linking to is not so relevant because some backlink pages only have a backlink to one url, but some backlinks (e.g. a profile page where I can put a bunch of links into the "about me" box or similar) will have a bunch of links on them, but all to the pages in the same niche.

The next step will be to store information about the niche and batch of sites that a backlink applies to. Then, for example, if I'm making a profile page, I'll pick a niche, stuff in a bunch of backlinks to my sites in that niche and some niche keywords, plus a few links to my other backlinks in that niche. That would create more of a "theme" for my backlinks and hopefully transfer some relevance rather than just pure pagerank. Possibly storing anchor text could be useful too, but since my system for generating anchor text is all based on percentages, you would expect the anchor text distribution to even out to the percentages I've set over time.

The big advantage to using an SQL database of some sort is that you can just rely on SQL queries to do all the randomization for you - you don't have to do any more coding to pick out random links of whatever type you want.

I also have scripts that go out and spider all my urls and backlink urls, and then remove dead urls from the databases, so I'm not wasting resources backlinking backlinks that don't exist anymore.

If you use only one computer, you can use excel, folders and text files.
But if you use more than one computer a cloud hosted solution is a must.

For me the best solution ever is Google Drive Spreadsheets

Autumn said:

When I generate a site, I also generate a .txt file that goes in the root directory that describes the url structure and the keywords used. Also all url and keyword data goes into a mysql database, along with the niche and batch, so if I want to return a bunch of urls that use the same keyword, are in the same niche, or belong to the same batch of sites, it's easy.

All my backlinks go into a mysql database so it's easy to pull out random backlinks for backlinking my backlinks.

Click to expand...

WAO... super organized Im guessing mysql is for querys when needed not just for reference. Excell and notepad should do for small amount of sites. This tips are at another level but nice.

Autumn said:

At the moment for backlinks I just store the backlink url. Storing the url of the site I'm linking to is not so relevant because some backlink pages only have a backlink to one url, but some backlinks (e.g. a profile page where I can put a bunch of links into the "about me" box or similar) will have a bunch of links on them, but all to the pages in the same niche.
...
The big advantage to using an SQL database of some sort is that you can just rely on SQL queries to do all the randomization for you - you don't have to do any more coding to pick out random links of whatever type you want.

I also have scripts that go out and spider all my urls and backlink urls, and then remove dead urls from the databases, so I'm not wasting resources backlinking backlinks that don't exist anymore.

Click to expand...

Thanks for sharing ... that sounds so effective yet manageable with very little time after it is all setup..

Have you thought about marketing your system or in$talling for others ??

We

We Go said:

Thanks for sharing ... that sounds so effective yet manageable with very little time after it is all setup..

Have you thought about marketing your system or in$talling for others ??

We

Click to expand...

Not really, I've got a whole integrated platform and I couldn't easily chop it up into pieces. Plus there are tons of tutorials on how to install mysql and do basic SQL queries... You really only need a very basic level of SQL knowledge to do something like this, which is basically just inserting rows into the database and then retrieving them again.