Re: Print advertising (search terms)

All,

I thought I would pick up this thread again. A couple of weeks ago,
Robert Bernier offered to pick up a bit of advertising for keyword
search for PostgreSQL on his own budget.

I picked at the Overture (now Yahoo) Keyword Selector tool:

http://inventory.overture.com/d/searchinventory/suggestion/

for a couple of hours yesterday and believe I have a basic strategy:

1) It would be a bad idea to get into a search term bidding war on
Robert's dime
2) For any term selected, should show up in the Top 8 --- otherwise end
up on a 2nd page and rarely viewed.
3) Using derivatives or complementary technology may produce low
costs/high return results.

As an example, a search for:

open office

yields
112456 open office security issue
25960 open office
1784 open office download
710 open office software
410 free open office
391 microsoft to open office
321 open source office
etc

search
openeoffice

yields

16494 openoffice
2286 openoffice download
1005 openoffice 2.0
557 the openoffice org
551 openoffice software
etc

Off the top of my head possible ad:
"Did you know that you can use PostgreSQL to securely store your Open
Office documents?
bla bla bla. " Then a link to a very brief tutorial on the pg site.

The same basic idea can be used for many other features:
ADODB = 632

""Did you know that ..."

procedure stored = 1289

and so on. All of which would put an ad either at the top or very near
the top - affordably. There must be content relative to the search
term. In the case of "adodb" or "procedure stored" (as examples), it
already exists. For Open Office, a bit of something would need to be
created.

I will spend some time pecking away, but only if there is a level of
concensus that the basic concept above would be helpful. If so, I will
peck --- then send to Robert (he's the money man), who can edit and post
to the list.

Thanks,
Mike

btw: As an aside - "partnering" (reciprocal links at the mimimum) with
Open Office (or others) may prove quite fruitful. But that's probably a
task for Steering guys.

More traffic---> more developers---> more ad revenue---> ensuing
development, etc.
Everyone benefits.

Robert Bernier wrote:

>On Monday 21 November 2005 09:08, Mike Ellsworth wrote:
>
>
>>I guess development of a keyword list along with adwords & Gavin's piece
>>would be next.
>>
>>I just bought a list of 3,300 US Newspapers which would be a start for
>>regular mailing of a "press release" - with wording yet to be
>>determined. I will eventually need to know what to use as a return
>>address. A pg graphic along with "c/o"..... my company address?
>>
>>I think Robert's Google ad + implementation of Gavin's idea + snail mail
>>press release (PG - What it is & Why you need it) will be a good start
>>to supplementing existing efforts.
>>
>>
>
>Google Ads work by using keywords i.e. "postgresql new version" etc. They can be targetted geographically and also within a budget.
>
>You target an ad by using phrases that you know the intended audience will use in their google searches. For example, if you want to attract the attention of MS SQL Server users then you would use phrases that they themselves type in a search. Our ad then appears off to the side.
>
>We should generate a list of keywords and see where this leads.
>
>cheers
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>