biks
Power Member
- Oct 28, 2008
- 719
- 388
So I'm just trying to make an iMacro which goes to Google's keyword tool and scrape the top results. I sorta can do it, but I suspect it'll take some VB and that's where my head starts to implode. This is what I've got. I wanna start here:
https://adwords.google.com/select/KeywordToolExternal
Let's assume I'm already logged in and have already entered a keyword, done the captcha and have finished the search. Let's say I did a search for "fat loss" I run this imacro:
I end up with this:
But what I really want is this:
How hard is it to extract to the first two, then go to the next cell? I suspect it requires VB stuff.
Does anyone know of any other keyword tool scrapers that I can just use?
https://adwords.google.com/select/KeywordToolExternal
Let's assume I'm already logged in and have already entered a keyword, done the captcha and have finished the search. Let's say I did a search for "fat loss" I run this imacro:
Code:
VERSION BUILD=6600525
TAB T=1
TAB CLOSEALLOTHERS
SET !ERRORIGNORE YES
SET !EXTRACT_TEST_POPUP NO
SET !DATASOURCE_COLUMNS 2
SET !LOOP 1
'Increase the current position in the file with each loop
SET !DATASOURCE_LINE {{!LOOP}}
'
TAG POS=1 TYPE=TD ATTR=CLASS:c0&&TXT:* EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=CLASS:data&&TXT:* EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=CLASS:c0&&TXT:* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=CLASS:data&&TXT:* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=CLASS:c0&&TXT:* EXTRACT=TXT
TAG POS=6 TYPE=TD ATTR=CLASS:data&&TXT:* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=CLASS:c0&&TXT:* EXTRACT=TXT
TAG POS=8 TYPE=TD ATTR=CLASS:data&&TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=keywordTEST.csvI end up with this:
But what I really want is this:
How hard is it to extract to the first two, then go to the next cell? I suspect it requires VB stuff.
Does anyone know of any other keyword tool scrapers that I can just use?