Hi,
We have thousands and thousands of search-type keywords that we would
like to know if anyone searches for. Overture's "Search Term
Suggestion Tool" (found at
http://inventory.overture.com/d/searchinventory/suggestion/) does just
this, but only on a one-off basis.
I need a piece of software or macro or something that goes down an
Excel (or CSV) file of thousands of keywords, queries the Overture
database through the link above, and then creates a new column that
shows me the number of searches for the (exact) term.
Because the Overture tool can be kind of slow at times, your program
should ideally open multiple connections to be able to process
multiple keywords at once. We need to screen 50-100k+ keywords on a
regular basis, so it should not take weeks to get through a list, if
at all possible.
I am open to pretty much any type (i.e., macro, standalone,
thin-client) of custom application that does what I've mentioned
above. Let me know if I can answer any additional questions.
Thanks!!
uc |
Request for Question Clarification by
answerguru-ga
on
10 Sep 2003 13:05 PDT
Hello uc1bear-ga,
I would certainly be interested in working with you on something that
could accomplish this task - it seems a multithreaded application
would be most suitable. As far as the programming language is
concerned, do you have any preferences? I would suggest Java myself if
you don't have a preference..
Let me know your thoughts so we can proceed :)
answerguru-ga
|
Request for Question Clarification by
webadept-ga
on
10 Sep 2003 13:15 PDT
Hi,
I have some experience with this type of thing, made one in Perl not
to long ago. One thing I thought I would mention : If you start
sending a 1000 quieries to that site in rapid succesion, every other
day, or even once a week, they are going to bann your IP address. So
don't do this at home or off your main webserver. :-)
I would design your program, like I did, to use a database, something
like MySQL, to put your keywords into, and cycle through them at a set
pace of one every minute. This will keep the flood alarms from going
off at Oveture. Run the program as a Cron job on the server, or a
daemon, and have a third colum which shows the last update date and
time.
Just a suggestion.
webadept-ga
|
Clarification of Question by
uc1bear-ga
on
10 Sep 2003 14:36 PDT
No preference about the language... I'm just an "everyday" user, so it
must be something I can run from my "normal" computer with IE 6.0 or
Win XP, etc.
Thanks! uc
|
Request for Question Clarification by
answerguru-ga
on
10 Sep 2003 20:03 PDT
Hi uc,
Just a quick update - I've begun work on this and have been at it for
about two hours already. I anticipate having it ready sometime
tomorrow - please let me know if this is OK :)
answerguru-ga
|
