NOTE: Sale ended at midnight PST 2 Dec 2013
OK - I bought the December flash sale from Jon's email, with 251 articles on weight loss PLUS the keyword list of 15,000 related keywords and decided to do some work on them tonight - right now!
This is what I did. Happy to take comments, if you want to make any.
I first did a "save as" on my file, in case I made a mistake!
I took the keywords, which were in a CSV file and opened them in an Excel spreadsheet (or any other spreadsheet program will work too) selected them all, then used the data "sort" tool to list the keywords in order of the number of searches each month. They keywords ranged from thousands for "weight loss" right down to small numbers for other long tail keywords. By doing it this way, there were some keywords in there that did not appear to me to be related to weightloss and I deleted those.
As there are 15,000 keywords, I decided to use the top keywords only and stopped at 200 searches monthly. I saved the spreadsheet with only my chosen keywords (those with searches greater than 200 per month)
I looked at the top few keywords and found one I liked, including a common keyword. I then searched down through the keywords I had saved (use Ctrl +F in Excel to do a "find") to find any other keyword searches that used that particular word. There were 11 keyword phrases that all included that word. I copied and pasted the keyword phrases into a notepad file, one per line and then wrote two paragraphs, using all those keywords in a natural way. That became my introduction to a long article. I also used 3 of the phrases as "headers" for an article.
I then searched through the zip file of PLR weightloss articles that I bought from Jon and selected 9 paragraphs from different articles that fitted exactly to the "headers" I had chosen. I tweaked them a bit (because I am fussy
) and pasted the article to a weight loss website.
Using the keywords and articles this way, I have a LOT of material that will be unique and that I can post as I get round to it. I do NOT have masses of sites that I need to post thousands of articles to.