I'm trying to extract keywords for my google adwords campaign from the google keyword suggestion tool.
I only want the keywords listed under "more specific keywords"
I've tried several macros, but can't get it to work right.
This one extracts the correct data, but it is all lumped into one "paragraph". I need each keyword seperated by a newline, or some other marker (like [EXTRACT]) so I can use a script to organize the data.VERSION BUILD=5010115
TAB T=1
TAB CLOSEALLOTHERS
URL GOTO=https://adwords.google.com/select/KeywordSandbox
SIZE X=977 Y=883
TAG POS=1 TYPE=TEXTAREA FORM=ACTION:/select/KeywordSandbox ATTR=NAME:keywords CONTENT=mortgage
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:/select/KeywordSandbox ATTR=NAME:submit&&VALUE:Show<SP>matching<SP>queries<SP>and<SP>alternatives
EXTRACT POS=1 TYPE=TXT ATTR=<UL>*
I also tried
But this has 2 problems.EXTRACT POS={{LOOP}} TYPE=TXT ATTR=<LI>*
1) It's hard to tell how many loops should be used - because the google page returns a different number of keywords every time (could be 12, could be 200)
2) If I loop to many times, the macro starts extracting the "Expanded Broad Matches" section of the page. (This is why looping till EXTRACT returns #EANF# won't work in this case)
The ideal solution would be to use something like ATTR=<UL>* - but with a seperator after each <LI>.
Thanks for your help!