Hey Warriors, First Post But I hope a Good one...
Hey everybody, this is my first post but I've been reading on the forum for awhile now. I know this isn't the place, but let me introduce my self, then I will get into my question. My name is Mark I've been marketing online for 4 years now and I've tried every marketing tactic under the sun. I have some experience. But I want to keep it short. So i'll get to you question, its about using Microsoft Excel spreadsheets.
When i'm doing keyword research on any given niche that I thinking about promoting something in. I've use many tools to help me pick the right keywords. Without making this post into a novel all quickly go over the process I use.
1. Open up: Wordtracker, Google Keyword Tool, Google Home page & Yahoo Site Expoler.
2. Use G Keyword Tool to make a list of Longtail Keywords (3 or more words). Copy them in to a excel spreadsheet.
3. Then I recopy each individual keywords back into, Wordtracker, G KW Tool, Google search in "quotes". Then I copy each of the Numbers, I.E. Searchs per day, Mth & competition sites in to a excel spreadsheet. Then I copy the top 3 websites on a google search and I copy them in to Yahoo site expoler. And I get out many links are pointing to the top 3 websites ranking on google.
As you can see step 3 is the biggest step. Having to do this with 100+ keywords takes a lot of time. Going back and forth to excel to the internet pages.
So my queastion is, Is there a way to use the Funtions abilty in Mircosoft Excel, to have the program automaticly go out and retive this info. I hope there are, but for some reason I think i'm just hoping for something that just isn't so. The probelm is I don't know much about setting up excel spreadsheets functions. I hope i've made it clear, if I have not, please let me know if you need any clearing up. If there is a way or if you know of a way, i'm happy to offer you some $$$ if you could set it up for me. Any Idea's... Thank you for all your comments.
When i'm doing keyword research on any given niche that I thinking about promoting something in. I've use many tools to help me pick the right keywords. Without making this post into a novel all quickly go over the process I use.
1. Open up: Wordtracker, Google Keyword Tool, Google Home page & Yahoo Site Expoler.
2. Use G Keyword Tool to make a list of Longtail Keywords (3 or more words). Copy them in to a excel spreadsheet.
3. Then I recopy each individual keywords back into, Wordtracker, G KW Tool, Google search in "quotes". Then I copy each of the Numbers, I.E. Searchs per day, Mth & competition sites in to a excel spreadsheet. Then I copy the top 3 websites on a google search and I copy them in to Yahoo site expoler. And I get out many links are pointing to the top 3 websites ranking on google.
As you can see step 3 is the biggest step. Having to do this with 100+ keywords takes a lot of time. Going back and forth to excel to the internet pages.
So my queastion is, Is there a way to use the Funtions abilty in Mircosoft Excel, to have the program automaticly go out and retive this info. I hope there are, but for some reason I think i'm just hoping for something that just isn't so. The probelm is I don't know much about setting up excel spreadsheets functions. I hope i've made it clear, if I have not, please let me know if you need any clearing up. If there is a way or if you know of a way, i'm happy to offer you some $$$ if you could set it up for me. Any Idea's... Thank you for all your comments.