A list of keywords and how often they occur.

[kexej28769@nongnue]

Copy and paste your list of recurring terms into a spreadsheet. You can explicitly remove terms and phrases like "is," "for," and "to."

You don't always get the most value by just looking at individual terms. Sometimes a two-word or three-word phrase gives you insight that you didn't have. In this example, you see the terms "milk" and "almond," but it turns out that it's actually part of the phrase "almond milk."

To gather these insights, use the phrase frequency counter from WriteWords and repeat the process for phrases that have two, three, four, five, and six terms. Paste all of this data into your spreadsheet as well.

A two-word phrase that occurs more frequently than a one-word phrase is an indication of its importance. To calculate this, I استعمال کریںthe COUNTA function in Google Sheets to show me the number venezuela number data of terms in a phrase.

=COUNTA(SPLIT(B2," "))

Now we can look at our keyword data with another dimension: not just how often a term or phrase occurs, but how many words are in that phrase.

Finally, to give more weight to phrases that repeat less frequently but have more terms, I put an exponent on the number of terms with the basic formula:

=(C4^2)*A4
In other words, take the number of terms and raise it to a power, and then multiply it by the frequency of its occurrence. All of this emphasizes the fact that a two-word phrase that occurs less frequently is still more important than a one-word phrase that may occur more frequently.

As I don't know just the right strength to increase it, I do several tests and keep rearranging the sheet to try to find the most important terms and phrases in the sheet.



Keyword spreadsheet and their importance