By Asif Anwar

Article Theme Versioning, was chosen as the name for this strategy. Because, you make many unique articles by making version of a specific theme of an article. So, each version contain the same theme. With Article Theme Versioning, you can create hundreds of articles from just one seed article. It involves manual versioning, word spinning, and sentence shuffling. The problem with spinning softwares is that you have to stay on their mercy for quality. But, in Article Theme Versioning with MS Excel you have the total control of your contents.

Why do you need Article Theme Versioning?

• Content was the King, but recently unique contents are the new King.
• Google now uses a duplicate content filter, which filters out your website if you have duplicate contents. Soon the other search engines will follow the same strategy to wipe out Plagiarism.
• There was a golden era of article promotion and press release submission, when you could gain search engine positions by marketing the same article. But, duplicate content filter slapped this form of marketing. But, Article Theme versioning can revive this marketing technique once again.
• Links from various sites with varied contents, have proven to be very affective for getting ranks in Google. Even for directory submission with <250 character snippet contents, any SEO professional will advise you to use altered contents. The more altered contents, the better.
• Google and other search engines like unique contents and can assign authority to your site if you have large amount of unique contents on the same subject.
• Google understands that gaming their algorithm is easy by creating links with copy-paste duplicate contents or articles throughout the web. Someday, they might treat links from duplicate contents to be commercially generated, not given voluntarily.
• Writing totally new and unique contents can increase your cost in copywriting and decrease your speed in online marketing.
• If you already have a compelling Web Copy, then you can add value to it through Article Theme versioning.
• There are millions of webmasters, bloggers, copywriters that are looking for contents for their websites or blogs. Use their hunger as your Link Baiting strategy and provide them free Private Label Rights (PLR) articles for their use with a deep link back to the source of your compelling article.

Why MS Excel

For Article Theme Versioning, traditional content spinning or twisting software isn’t used. Instead, we’ll use the most effective tool, MS Excel. MS Excel is great tool for computation, and has been a companion for Search Marketers throughout the world. It is a very strong string or text manipulation tool and we mostly don’t know the use of it. We’ll use MS Excel to generate hundreds of unique articles from one. Here are the major reasons why I like MS Excel for Article Theme Versioning:

• MS Excel has many complex formula to handle and manipulate string or text very easily.
• MS Excel comes with a Thesaurus for Synonyms (easily replace synonyms by Alt + Clicking) which you can replace for getting more spinned sentences.
• You can spin sentences in Ms Excel faster than any other word processing software.
• You can automate sentence spinning and shuffling without giving much effort in manually creating unique articles.
• Since the quality of the articles depends on the input you give, you can have total control of the quality of the contents.
• You can convert the MS Excel files into XML, which can be used in other software or online tools for content automation or management.

How Will it Work?

One thing needs to be made clear. The whole process is manual. i.e. you have to write different versions of the same article and then change each word in the sentence for spinning. However, automated scrambling and shuffling of sentences in the article follow planned patterns to have very little duplicate sentence. Ok, here goes our content versioning, spinning, shuffling methodology:

Phase 1 – Sentence Versioning

First, you have to manually rewrite 4 versions of the article and make structural change in the sentences. But, we keep the same semantic meaning (theme) of each sentences.

For example:
Version-1: I eat rice.
Version-2: As a meal, I only take rice.
Version-3: I usually eat rice every day.
Version-4: Rice is my staple food.

This is just sample of a sentence. But, the 1st, 2nd, 3rd, and 4th versioning is done manually for all the sentences. So, if there is about 40 sentences in one version, then we have 40X4=160 sentences.

Please triple click each cell to copy the contents in each cell. Keeping all the contents in HTML format will work better for you to keep the formats along with the template.

Phase 2 – Content Quality Measure

First, do a spell check, so that the same spelling errors are not replicated elsewhere. Then, make sure that the 4 versions are Copyscape verified. Because, before you start spinning and shuffling, you need to make sure that they are not used elsewhere. If duplicate is found, then rewrite them. Also do a Keyword Density Analysis through various SEO Suites and ensure that the first and last 100 words contains the target keyword with mentions in the article 2-3 times. This will ensure you that you will not replicate the copied contents.

Phase 3 – Sentence Tabbing

Now, to utilize the manually versioned articles to create more sentences, you need to spin them. And to spin the sentences, you need to have them in order. Having the words in different cells will allow you to manipulate them easily. To do that, you need to put a Tab between the words in Notepad, and then paste them back to MS Excel. So that, you can easily place the words in cells. For the ease in manipulating the sentences, I’ve divided the sentences in 10 cells. However, you can divide the sentences in as much cells you want.

Please triple click each cell to copy the contents in each cell.

Phase 4 – Sentence Spinning

Last time, we’ve made structural change in sentence manually. Now, we’ll make synonymous change in those sentences within the same sentence structure and create 10 more spinned variation from each sentences.

For example:
Version-1: Telecommunications expense is categorized as one of the top five costs for most businesses as companies are losing more and more money these days.
Version-2: Telecom expenditure is granted as one of the top 5 expenditures for most enterprises as companies are getting less money these days.
Version-3: Telecom cost is deemed as one of the most significant costs for most companies as enterprises are gradually losing money in recent years.
Version-4: Call cost is regarded as one of the top 5 expenses for most enterprises as businesses are throwing away more money recently.

This is the most crucial part of Article Theme Versioning. This phase consumes most of your time, but generates a lot of sentences for you to shuffle. And this phase has most of the quality factors that you should always consider.

Create separate spinning tab for each manual versions. Pull each sentences 3 times in the Spinning Tab ("Referring Sentences" portion). In the example below, we can pull the same sentence 3 times and then use Alt+Click to replace a word with synonym. While, changing a word or phase with synonym, please keep an eye on the meaning of the sentence.

Then, using the "Index" formula, you can scramble the words ("Word Scrambling" portion). The below example gives a specific pattern of scrambling. However, if you wish, you can create another type of scrambling pattern. The scrambling pattern is random, not systematic. However, the pattern should not be redundant and you have to make sure that the pattern generates less duplicates. Therefore, the below scrambling pattern is planned in such a way to reduce duplicacy in the sentences and randomize the scrambling.

This scrambling pattern will generate 9 sentences from the 3 lines in the "Referring Sentence" portion. After the scrambling of words you have to use the "Concatenate" formula to join the words to make the sentences (in "Concatenating Words" portion). Along with the original sentence and the scrambled/spinned sentences, you have 10 versions of the same sentence.

If we previously had about 160 sentences. Now, we have 160 X 10 = 1600 sentences. Now you have to use these sentences to generate unique articles. Here is a sample (look below at the last column for spinned versions of the sentences):

Please triple click each cell to copy the contents in each cell.

Phase 5 – Sentence Shuffling

Now, we actually have 4 X 10 versions of the same sentence among all the 1600 sentences. So, we  now have to shuffle the sentences of the different versions and try to accommodate as many versions of the article as we can with less than 25% duplicate contents. For that, we have to shuffle sentences at a certain level. If we have about 40 sentences, then you can shuffle 10 versions (25% of 40 sentences). This is a simple math, but you can verify duplicate contents with many duplcaite % checking softwares available online and stop at one level when you are generating more than 25% duplcaite contents.

For that bring all the generated spinned sentences of same meaning in a separate tab and place them in a single row. And organize the various 4X10 versions of the sentences vertically in columns. After you have them in a separate tab, you are ready to shuffle the sentences using the below Shuffling Patterns inside the Concatenate formula to join the sentences of the articles. The organization of spinned sentences should look like the example below:

Please triple click each cell to copy the contents in each cell.

Sentence Shuffling Patterns

For generating the full article, we’ll use various shuffling patterns like:

• Straight,
• Diagonal shuffling,
• Reflecting diagonal shuffling,
• Alternate diagonal shuffling,
• Alternate reflecting diagonal shuffling,
• 2nd alternate diagonal shuffling,
• 2nd alternate reflecting diagonal shuffling,
• 3rd alternate reflecting diagonal shuffling,
• and so on.

Figure 1 – Straight Sentence Shuffling

Figure 2 – Diagonal Sentence Shuffling

Figure 3 – Reflecting Diagonal Sentence Shuffling

Figure 4 – Alternate Reflecting Diagonal Sentence Shuffling

For articles, prefer Reflecting Diagonal Sentence Shufflings, since it creates lesser duplicates than only Diagonal Sentence Shufflings. However, if the amount of sentences are few (in case of Snippet Contents), only Diagonal Sentence Shufflings are preferred. The alternation in shuffling (2nd, 3rd, 4th …) can go on up to 10 versions (5th Alternate) as was mentioned earlier. In ideal 40-50 sentence articles, going beyond 5th Alternate Diagonal Shuffling will mean duplicates more than 20%. Here, I’ve showed only downard diagonal shuffling. So, you can create more articles by going upward also.

Phase-6 – Article Theme Versioning Output

We need to parse the contents into a separate tab, so that we can have all the articles togather. And make output as per requirement, either as raw spreadsheet, text, html or xml versions. In this stage, we should do: spell checking (again), replacing periods (.) with periods with a following space (. ) to eliminate spelling errors made by not using space after period, and then replacing the double/triple/quadruple spaces into single space, etc.

Please triple click each cell to copy the contents in each cell.

So here is the output you have:
Best Quality Content: 4 Unique versions manually rewritten articles
Better Quality Content: 40 spinned versions with less than 10% duplicate contents
Good Quality Content: 520 shuffled versions with less than 25% duplicate contents. However, this amount can be less.

What About Snippet Contents

For directory submission and small link posting, you also need altered Snippet Contents that are less than 250 characters. However, since the amount of sentences are low, the amount of duplicate contents are more than 20%. However, you can get a huge number of Snippet Contents that are altered using the same methodology. You can create 5000+ versions of Snippet Contents from 10 Snippet Themes and no Snippet Content will be unique.

Samples

This is an entry to Marketing Pilgrim’s 4th Annual SEM Scholarship contest.