Hi David
Nice idea for a site!
Here's a topic that's been on my mind lately and this seems like a good place to raise it...
Until recently I've been a 'content' affiliate, focusing on smaller sites that house long articles, blogs and so on (I took this route mainly because I have a journalism background). So, my aff links have been all manually added text links and banners as they're easy to maintain on small sites.
But I've always felt I'm missing out on the benefits of the long tail that using product feeds bring. Especially with Christmas coming I wanted to be able to spread out with many more pages and really reach out to those long tail searchers. That's why I got into Price Tapestry.
But one concern is the fact that if we all use the same generic product feeds with duplictate descriptions, product names and so on Google 'thinks' "ah...seen this cookie cutter before" and it's a non starter. So I wonder, do you have any tips on differentiation that can help sites that effectively contain duplicate material to stand out in Google's eyes as different and worthy of inclusion.
Cheers
Oliver
Hi Oliver, Something that a
Hi Oliver,
Something that a number of Price Tapestry users have done, where they also have a network of other affiliate sites, is to use your Price Tapestry database to source related products from an existing page of content - perhaps not bringing the description field in depending on your views on duplicate content. Seems a bit quick to point you straight back at pricetapestry.com, but you may or may not have come across the following thread that contains code for bringing in products like that....
http://www.pricetapestry.com/node/1625
In the code in that thread, you will see a line constructing the SQL:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."products` ORDER BY RAND() LIMIT 2";You would basically change this to contain a search style query based on the content of the page that you want to incorporate feed data into; for example:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."products` WHERE MATCH name AGAINST ('keyword1','keyword2','keyword3') LIMIT 2";...where keyword1, keyword2 etc. etc. are brought in from other data on the page....
Something to think about...!
Cheers,
David.