Using Excel to Plan Your On-Site SEO

Hi,

I found this article (of Gunjan Pandya) interesting and maybe helpful for guys who wants to organize their tasks.

Add Separate Column for Your Primary Keyword: after doing keyword research with Wordtracker or Google Keyword Suggestion Tool you can select your primary (base) keyword for your particular page and put it in this column.

Add Separate Column for Your Secondary Keywords: after you’ve selected your primary keyword for a page, you should select secondary keywords for your page.

Add Column for Google Competition: check the competition of your primary and secondary keywords in Google. So you can get the basic idea of your keywords competition in Google

Why we should add the column of Primary Keywords, Secondary Keywords and Google Competition?

When writing meta tags, if you can see what your primary keyword and what your secondary keywords are, that will be easier for you to create a proper title and description. Besides, you can always evaluate your chances of getting to Google first page by seeing your Google competition for each phrase.

Read more

Share/Save/Bookmark

Post a Response