Adsense with DB

[andyholt]

Hi
I am planning on making new sections of my site database driven - basically a template calling articles from the database.

Will adsense be able to spider pages with DB content and will it be able to follow urls similar to page.php?articleID=1

Any info would be appreciated.

Andy

[cyanide]

the short answer is yes.

if you only have 1 or 2 variable, there's no problem.

a tip, try to input a variable in the title tag that would spit out the title of the article.

[andyholt]

Hi cyanide,
thanks for that :) I was planning only passing the 1 variable in the url. The db wil be set up to generate titles etc.

Now I can get to work properly. Adsense is too good a source to miss out on :)

Andy

[cyanide]

no problem.

you're good to go !!

[andyholt]

Just a quick update - it might be useful to others :)

I emailed google to be 100% certain and there isn't a problem with urls with query strings as long as the url doesn't change.

Problems can arise if the urls are dynamic e.g containing session IDs etc.

Hope that helps confirm things for others that might be curious :)

Andy

[cyanide]

andy, you emailed them ?
how long did it take to get a response? -just curious.

yep session ids are a killer.

[andyholt]

Hi

considering the time difference it was quite quick. I emailed them about 3pm UK time and got a reply a couple of hours later.

Very helpful :)

Andy

[ChiefTechnovelgist]

I went round and round with the googlers on dynamically generated URLs. Here's the deal:

1. Use as few parameters as possible (as stated above). Make sure the parameters are in the same order! Any difference in the URL is interpreted as a new page. That includes URLs with session ids that are encoded into the URL.

2. Always make sure that the URL to a given page is written IDENTICALLY!!! at every point in the site. As far as Adsense is concerned, these are three different URLs, and Adsense will waste days crawling all three of them as separate pages:
http://www.techetc.com/stuff.asp?Bnum=4
http://www.techetc.com/stuff.asp?bnum=4
http://www.techetc.com/Stuff.asp?Bnum=4

3. When you get your site up, go through and click through to every item on your site. In my case, I had about 550 different items (Bnum=1 to 550)! Otherwise, you will have customers clicking on the URL for the first time, and Adsense will display generic or humanitarian ads.

4. Don't forget to use Adsense's new alternate ad feature; that way, somebody you like will always get a link.

Now, if only I knew the four rules for getting people to CLICK ON ADSENSE ADS, I'd really know something!

[ChiefTechnovelgist]

I almost forgot rule #5:

5) Be patient in working with Google and Adsense. They have multiple sets of servers performing these tasks; the rules for each server may not be identical, and they are tweaking their rules all the time. Besides giving you better service, all this activity has the effect of making it more difficult to "game" their system. It enforces a user-centric Internet which benefits everyone.

By the way, the term "Google Dance" refers to the fact that Google has three sets of servers at www.google.com, www2.google.com and www3.google.com. They don't always give the same result.

[bossmode]

My website is created on the fly using ASP. AdSense seems to work with this.#

http://www.global-income.com

AdSense works after all the HTML of your page is generated.

[JohnHocking]

My site is dynamic and passes ID's to the pages.

Once you get your site up and adsense added, you
should visit every possible combination of pages as
was suggested eariler. This will allow the googlebot
mediapartner bot to find and index your pages.

The side benefit of this activity is that each
of the pages may also end up indexed in Google.

I currently have 866 pages indexed. Google bots
visit my site dozens of times a day.

One other tip:

Try making the border color of adsence match your
page color (ex: white on white). When I did this,
my click throughs when up over 20%