VIDEO Tracking Your Google Analytics Keywords using Excel

I don't believe I've seen you here before. You may want to subscribe to my feed to keep informed of new posts at DynamicVB.NetRSS feed. Thanks for stopping by!

Tracking your Google Analytics search phrases using an Excel Spreadsheet is fairly simple to do and helps you to store, sort, and organize the data efficiently. If you have already conducted your keyword and key phrase analysis employing numerous resources and software, then make sure you’ve copied and pasted all the keywords and phrases into a single Excel file.

Getting Started With Your Excel Spreadsheet

You might wish to organize the info with a header, so the data of what every column signifies is obvious. This will improve your experience utilizing Excel to manage your information.

The next step in keeping track of your information making use of an Excel spreadsheet is producing a filter for the first column applying a header. By doing so, you will be able to begin filtering data for each specific column. Next, you will want to freeze the entire 1st column. To do that, you have to click on View. After that, click on Freeze Panes and Freeze Top Row.

Now, if you continue to scroll down the massive list of search terms, you may still see the data whilst maintaining the 1st row anchored. This is a handy way to keep data organized and readable, as well as understanding what every one of the columns represents.

Organize And Filter The Key Phrase Info

1. Alphebetize the list from A to Z
2. erase any duplicates
3. Make a decision in trying to keep plural and singular keywords and phrases
4. erase key phrases with related meaning
5. Duplicate method with any other keyword and key phrase

Let us get going on organizing the information. Initially, you need to eradicate any exact duplicates. To do this, proceed and shuffle this list from A to Z. Considering that your document will most probably contain a wide variety of keywords from diverse search phrase software, you might end up with many duplicates. You can merely highlight the duplicates and eliminate them. Make sure you are deleting just key terms which are precisely the same. Even if there might be similar phrases or close matches, retain those key phrases until later.Do not delete any search phrase unless it is a byte-for-byte replica.

For example, consider the keywords and phrases “against stem cell” and “against stem cells.” Even though the discrepency is rather small, and the single distinction is plural form, it may perhaps be tempting to purge the keyword and key phrase entry. Nevertheless, you will need to think about these key phrases as 2 distinctive key terms.

Next, study the search phrase list and eliminate the specific recurring phrases. Next, you will want to trim down the search phrase list even further. You may search through your list and purge all one-word phrases because these keywords and phrases are generally too broad and non-specific. One-word key phrases also normally have a tremendous of search volumes that may be immaterial to your specific domains. Usually, phrased key terms can offer the return on investment of people to your web pages. You may go ahead and scan the list now and purge any exact search phrases or solitary word key terms.

Fine-tune Your Keyword List To Establish A Relevant Search Phrase Database For Your Domains

1. Click on Text Filters
2. Choose a new search phrase
3. Delete duplicates
4. Erase keywords with the same meaning
5. Verify the practicality of the erradication by accessing Search Volume

You are on the way to trimming a very fine search phrase list. But, you must whittle down the list even further. You might start doing so by identifying the same key terms which are not identical but which are very similar in meaning. You can purge sparingly, though it might be a very good idea to excise out the near-identical search terms. Search through thelist and maintain the keyword phrases that you feel would yield the most web-site visitors for you, and preserve the search phrases which are also most appropriate to your web site.

It really is quite easy to reduce the keyword list even even more. You may do this by clicking on the search terms, and next click on Text Filters. Type the text in the entry box. For example, if you want to search which keywords and phrases that contain the word “definition” in them, go ahead and key “definition” into the entry box.

Once you’ve keyed the requested keyword and key phrase into the entry field, the duplicates will be highlighted. This is also a chance to take a look at whether or not the keywords are equivalent in meaning. For instance, “stem cell definition” and “definition of stem cell” have almost the same exact definition. This would be the perfect instance to excise one of the versions—the determination is wholly up to you regarding which variation you want to delete. Make sure to take into consideration Search Volume and other elements of information to establish which version you want to excise.

Begin To Filter The Keyword and Key Phrase Data

1. Click on Filter
2. Click on Clear Filter from Key terms
3. Input new version of key phrase
4. Click on Filter
5. Remove all duplicates
6. Repeat the process with new keyword version

Next, once you’ve gone through the whole spreadsheet and excised the duplicate and synonym keyword phrases, you can begin to filter the data. Click on Filter, and after that click on Clear Filter from Search phrases to start a fresh search. Enter another version of search terms; yet, don’t type in the whole search term this time. For instance, utilizing the stem cell example, you may want to simply type in “embryo” to discover all related key words like “embryonic.” Click on Filter again. A list of matching keywords will turn up. Repeat the above procedure, and delete all exact duplicates.

Customizing Your Search Phrase List Even Further

You could choose to keep the singular and plural versions of diverse keyword phrases, or be at liberty to narrow down the total search term list to simply a very tight grouping of 40 to 50 keywords to put together niche domains. In this case, you can dispose of either plural or singular depending on your personal option. Once again, it may be a good idea to go ahead and analyze the Search Volume data when choosing which word to preserve.

Now, you can repeat this procedure as many times as you wish working with the keywords and phrases of your preference. As you commence to excise down your list, you will start to build a very productive and applicable search term search list. You may apply this list of keywords and phrases to generate niche content Internet websites or to advertise on Google AdWords.

More

Speak Your Mind

*