Affiliate Project work with Affiliate Newbie on niche sites
Recently we got a message from Stuart Smale (Smale Media) asking for some help on setting up his product data feeds into his niche websites using PHP and MYSQL. He found us through our How to pull product datafeeds using PHP and MySQL and display into your Webpage post. Since helping Stuart with some basic guidance,he has gone on and very quickly figured out how to do this and now has this running on his site instead of using EasyContentUnits, which although is an great tool to use, isn’t that great for SEO because the free version uses javascript which search engines cannot index.
Between us we’ve also improved my original php script to include some nice new features such as adding in a clickref to help track which products are most popular. Also adding into the script, how to pull in the merchant logos as these aren’t in the datafeeds supplied by the merchants. I was very impressed with how quickly Stuart has come on since he didn’t have this knowledge until recently. In fact Stuart has also spent quite a bit of time looking into pagination and also auto updating his feeds, something on our task list. Stuart has kindly shared these ideas and the code with us so this has been very helpful.
We have made a good contact and look forward to working with Stuart more in the near future. We’ve now added him to our MSN Affiliate Friends and been in regular contact over the last few weeks sharing ideas and opinions. This just goes to show what a good industry Affiliate Marketing can be, you could have friends who are effectively your competition but still share and discuss ideas and help each other out every now and again.
I would also like to mention some of the work Stuart has done on his niche sites. He certainly has a couple of good niches with some high search volumes and I think its only a matter of time and a bit of hard work and he’ll be seeing the rewards for those sites. The first site is children’s shoes and something that people may think will these sell online. Well I think there will be a percentage of people shopping online for most things you wouldn’t usually buy because you can get them cheaper and also use voucher codes. We recently did this with our little girl because we already had her feet measured up, then new the size and went searching online.
Another site Stuart has done and now using the product data feeds with his own database is Larder Fridge which is a really nice simple design, so very easy to use. He’s using pagination as some pages have a lot of products. I do think Stuart has a good eye for design.
Thanks Stuart for getting in contact with us and we hope to see you grow and succeed in Affiliate Marketing. Good luck mate
Similar Posts:
- None Found
Comments
7 Responses to “Affiliate Project work with Affiliate Newbie on niche sites”
Leave a Reply
-
Sponsors / Adverts
Thankyou guys for mentioning me on your blog, all of which is very flattering, not sure if my cheeks could get any pinker (never been the subject of a post before!).
It’s been a pleasure speaking to you both, this site is after all what gave me the incentive to try out datafeeds and playing with MySQL in the first place, long may our chats (business discussions) continue!
Wishing you the best for the future.
Stuart
Cheers Stuart, sorry I didn’t reply sooner, been out of action with man flu
Catch up soon buddy
These sites are very inspiring! I noticed on the children’s shoes site Stuart is using WordPress and EasyContentUnits but on the refrigerator site he has built a php site using the data feeds. Curious to know if search engine traffic to these sites is good/fair/poor and which site performs better in terms of search engine traffic!
Glad I found this site!
Thanks for the feedback Josh. Stuart hasn’t got round to doing the datafeeds on his childrens shoes site but I’m sure he will do this in the new year. Then we’ll see if his sites make any difference in search engine ranking as well as traffic to his sites after he has changed to using datafeeds rather than ECU. I’m sure he will see a difference.
With regards to search engine traffic, the rankings on larder fridge have definately risen since the changeover to datafeeds and traffic has gone up accordingly, still not huge amounts per day but it still isn’t in the top 3 as yet, have to get around to adding a bit more content to it as it’s a little sparse, plus the usual sprinkling of backlink building when time allows.
As Gary mentioned, i will be converting children’s shoes over to datafeeds in the near future, even though it will be a bit of a job but it’ll be interesting to see the effect it has, particularly on conversions.
@Gary and Stuart – Thanks for the replies!
I am really fascinated with the use of datafeeds and I spent several hours the other day trying to get a 50mb .csv file imported into a MySQL database with no success. I’ve tried BigDump but even it was having problems. Anyway, don’t want to get off topic.
Gary, have you considered installing the “Subscribe to Comments” plugin? I wish to stay in the loop.
Thanks Josh, I’ve now installed the plugin. Keep following
Cheers
Gary