Mod Rewrite And Adsense

[geogeo]

Hi all

 

I am working on a dynamic site and I would like to integrate Google Adsense into it. The ads work fine for static html pages and do work with dynamic pages. The problem I am facing is that Google seems to lag behind with their ads.

 

For example, a have pages where users can contribute information and these can be searched by other users and the pages are produced dynamically by msql db. I have tested this with Google adsense and it seems OK, but it takes some while to get targetted ads to the page. If a user looks for information for renting an apartment in New York for example, the page is loaded, but the ad is still for something that was generated some time ago. For example, web design.

 

My idea is to tag the ads onto the end of the article, hopefuly for further reading by the user and a few cents for my site. Is there any way around this issue? I have read that mod rewrite may work?

 

I am new to rewriting, so forgive my ignorance. One thing I did wonder though, was is it possible to actually create a new html flat file from a mysql database? I create static pages with Dreamweaver and save them as whatever.html. Is it possible to have a template and when new articles are submitted, actually create a new file on the root with the content? I hope you understand what I am talking about.

 

Any help will be really appreciated.

 

Andy

[TweezerMan]

I don't know much about Google's AdSense, but it sounds to me like you've got your site set up in such a way that a user can get different content with essentially the same URL. I imagine that Google has to spider your web site in order to figure out what ads to send to you - it doesn't seem practical to me for Google to have to pull your dynamic page every time a user requests the same page in order to generate an ad that matches the current content.

 

I don't see how mod_rewrite would help you. If I understand the issues correctly, your web site should display the same content each time the same URL is requested.

 

One thing I did wonder though, was is it possible to actually create a new html flat file from a mysql database? I create static pages with Dreamweaver and save them as whatever.html. Is it possible to have a template and when new articles are submitted, actually create a new file on the root with the content? I hope you understand what I am talking about.

It is certainly possible - this is what blog apps do, as well as CMS apps (content management systems). Storing content in a central database, publishing that content with templates set up in the system and writing the resulting pages to disk is the heart of what blogging and CMS apps were designed to do.

[geogeo]

Hi David

 

thanks for your reply. You have summed up exactly what I need for my site. I thought about the way Adsense spiders the page and your right, it would be impossible for the spider to keep up with demand.

 

Can you point me in the right direction to start working on a system to create static pages from dynamic content.

 

Thanks.

 

Andy

[TweezerMan]

I don't believe your problem is static vs. dynamic pages. I'm a little fuzzy on exactly how you've set up your dynamic pages, but from your earlier description:

For example, I have pages where users can contribute information and these can be searched by other users and the pages are produced dynamically by msql db. I have tested this with Google adsense and it seems OK, but it takes some while to get targetted ads to the page. If a user looks for information for renting an apartment in New York for example, the page is loaded, but the ad is still for something that was generated some time ago. For example, web design.

...I got the impression that these search pages displayed their results via the same URL, regardless of what the user searches for. The AdSense ads are being delivered based on content that Google saw from some other search, which would explain why the ads don't correspond with the content on the page.

 

If you're interested in using an application to manage your content, there is a whole host of apps to choose from. If a blogging application would meet your needs, the more popular ones now include WordPress, Movable Type, TextPattern, and Expression Engine. If you'd rather use a full-blown CMS, I've know of Drupal and Mambo (but I don't really know that much about CMS systems).