1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Old Site with a LOT of Quality content, what to do?

Discussion in 'White Hat SEO' started by martin94, Aug 1, 2016.

Tags:
  1. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Hello all, it's my first answer on this forum, hope it's the right place.

    I'm working with a friend that has an old blog (from 90s still simple html blog) and he made with it some money (around 20-25k/year). For several years he was on top pages on google for a lot of keywords but around 5 years ago he lost most of traffic since his website is too old for google standards (he gets around 2/3k/year now). This blog has a lot of quality and original content, it's a sort of wikipedia (today i get throu the ftp and he hosts 9gb!).

    Now the question is... Is there a way to renew this blog with todays standard? I'm a junior web developer and know how to start a blog, but there is a way to convert the html posts to .cvs or .json format?
    Thank you :D
     
  2. JazzJazzy

    JazzJazzy Junior Member

    Joined:
    Sep 13, 2015
    Messages:
    140
    Likes Received:
    22
    Gender:
    Male
    Learn how to scrape.
     
  3. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    I've head of this, are there a guide or something in this forum?
    Thank you
     
  4. davids355

    davids355 Jr. VIP Jr. VIP

    Joined:
    Apr 25, 2011
    Messages:
    10,424
    Likes Received:
    8,125
    This is what I would do-

    you need to catalogue the content, the potential of each page etc.

    So first, get on ahrefs (ping me if you don't have and I'll send you a report) and get the keywords you are currently ranking or nearly ranking for.

    Then work on those first - optimise each page for the best terms, and refresh the content - a colab would be good here - you do the SEO and your pal does the content (freshening it up, making it more relevant, more useful, include links to authority sites etc).

    Once you get through the easy ones continue through the rest of the unranked pages doing the same thing - research the most lucrative keyword for that page, optimise the page accordingly, refresh / extend the content.

    Keep tracking everything along the way.

    Start getting social media going, let the community around the site and it's niche know about this resource.

    Start building out links - low volume, high quality, mostly to root of site and some to sub pages, keep it branded / naked URL to begin with.

    Re-assess in a few months.

    Side notes -

    Optimize for mobile as well if it's not already, but I'm guessing this will be a big job.

    Tidy up site structure if you can.

    -for both of the above getting it in to WP will probably be the best move, but you really need to preserve URLs etc.
     
    • Thanks Thanks x 1
  5. SkyrocketSEO

    SkyrocketSEO Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 5, 2012
    Messages:
    4,565
    Likes Received:
    11,950
    Occupation:
    travəlɪŋ
    Location:
    Aibres
    Home Page:
    Whats that, yearly traffic?
     
  6. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Nice, thank you!

    Yeah in my last job i changed a platform for the blog and it was hard to preserve all the links for the seo, it was hard with 200 articles, on this one there are thousands of them! D: is there a way to automate this?
    In the last job i did a subdomain with the new site and copied all the content and preserved links, in this case it's pure HTML no database no anything!
     
  7. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Nope, annual income (euros) traffic is around 2k/month for now but i'll have the access to analitycs in few days
     
  8. Tove

    Tove Jr. VIP Jr. VIP

    Joined:
    Jun 21, 2015
    Messages:
    733
    Likes Received:
    546
    What I would do is go with Wordpress as it is simplest CMS and spend some time designing site, doing on-page seo for all those old articles targeting long-tail keywords. Then considering it has tons of content, I would make proper silo structure and organize content, make it easy to navigate for user and do proper inter-linking. This will take a lot of time to do, but it's worth it.
     
    • Thanks Thanks x 1
  9. davids355

    davids355 Jr. VIP Jr. VIP

    Joined:
    Apr 25, 2011
    Messages:
    10,424
    Likes Received:
    8,125
    Yea exactly!

    It's hard though, for the preservation of link juice etc you can probably do a redirect with htaccess and some regex, but copying the actual content from old to new site, I'm not sure, maybe you need a custom bot for this? Not sure.

    Don't rush this, research for the best way.
     
  10. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    For setting up a WP site it's not a problem, i'm good at it, but it's a problem coping all the content at once cause its HUGE!
     
  11. SkyrocketSEO

    SkyrocketSEO Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 5, 2012
    Messages:
    4,565
    Likes Received:
    11,950
    Occupation:
    travəlɪŋ
    Location:
    Aibres
    Home Page:
    hire VA for $50. You wont believe what people do for $50
     
    • Thanks Thanks x 1
  12. henga

    henga Junior Member

    Joined:
    Aug 20, 2007
    Messages:
    194
    Likes Received:
    30
    Just make sure you 301 redirect everything to the new URL structure. I suggest you do this manually, put some time and effort in it :)
     
    • Thanks Thanks x 1
  13. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Will try, now i'm downloading locally all the site structure, will start to scrap and saving in simple txt or html file
     
  14. linus500

    linus500 Registered Member

    Joined:
    Oct 15, 2015
    Messages:
    76
    Likes Received:
    10
    You've got a goldmine here! Definetly 301 redirect each individual page to the new identical page.
    Use a silo structure if possible. Make sure the title and content keywords are relevant. Add title and alt tag to images.
    Set up analytics and webmaster tools.
    Also, update us on your progress and feel free to ask if you want help!
     
    • Thanks Thanks x 1
  15. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Thanks you guys, for sure i'll add more details, and some questions :D
     
  16. Banditoseo

    Banditoseo Regular Member

    Joined:
    Jul 17, 2016
    Messages:
    268
    Likes Received:
    189
    Gender:
    Male
    Exactly. The importance of this can't be understated: since the site has good content and is still indexed by Google, be very careful to 301 redirect individual pages to identical pages. (At least identical content; you can certainly spruce up the navigation, etc.) If you use a redirect to point to a page with different content, Google will treat it as a 'soft 404,' or in other words an error, not a redirect. See http://www.gsqi.com/marketing-blog/redirects-less-relevant-pages-soft-404s/

    And I'd give a thumbs-up for porting to Wordpress. Usually the best choice for everyone.
     
    • Thanks Thanks x 1
  17. jstover77

    jstover77 Executive VIP Jr. VIP

    Joined:
    Feb 27, 2009
    Messages:
    2,384
    Likes Received:
    3,627
    Gender:
    Male
    Occupation:
    Entrepreneur
    Location:
    Doylestown PA
    Home Page:
    Back massage?
     
  18. SkyrocketSEO

    SkyrocketSEO Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 5, 2012
    Messages:
    4,565
    Likes Received:
    11,950
    Occupation:
    travəlɪŋ
    Location:
    Aibres
    Home Page:
    I am sure they would do this as well if you ask them politely :)
     
    • Thanks Thanks x 1
  19. martin94

    martin94 Newbie

    Joined:
    Aug 1, 2016
    Messages:
    11
    Likes Received:
    0
    Gender:
    Male
    Can wordpress handle a huge amount of data? I everytime used it in medium small blog, this One has content from 15 Year of daily posting D:

    Can Someone suggest me a good and economic hosting for it?

    I want to start this journey in the best way.
     
  20. RightFootFanatic

    RightFootFanatic Regular Member

    Joined:
    May 31, 2015
    Messages:
    388
    Likes Received:
    216
    Occupation:
    DevOps
    Location:
    Whimsyshire
    Do you have a list of all the pages? Maybe from the sitemap, otherwise build one.

    • Setup a local xampp installation, and create a database table that stores the current urls and datas of the posts.
    • Fill that table with your url list
    • Download SimpleHTMLDom -> http://simplehtmldom.sourceforge.net/
    • Build a quick and dirty script with it that scrapes the posts / articles from your url list and stores it in your database
    • Setup a wordpress on a subdomain or local and recreate site structure for categories. make sure it matches the old structure if possible
    • Now write a little script that pushes your scraped data into the wordpress database, make sure the permalink you could enter in wordpress is filled with the structure of the old site
    • Mark entries that couldn't be added like the old structure
    • Create rewrites for the previous marked entries
    • Comsmetics, seo, etc make your WP fit the needs of your audience
    • Go live with that Blog
    Maybe I forgot some points, but that would it be in a nut shell. As you're a webdeveloper, fooling around with some little php scripts and a database should be fun.
    If you have questions about simplehtmldom I'm here.
     
    • Thanks Thanks x 1