Handling Products Removed From Datafeeds

April 15th, 2010 → 6:09 pm @ Eric Nagel

Tweet I received an email the other day from Garrett, and he asked: I’m just curious how you might deal with pages/urls on your site that have been indexed (and may be getting good traffic/links), but all of a sudden they’ll disappear if the product happens to drop off the merchant’s feed. After a couple [...]

Blog

Creating an Image Sitemap from a Datafeed

April 8th, 2010 → 2:35 pm @ Eric Nagel

Tweet Google just announced an image sitemap format which will help get images from your site indexed. I thought this was a perfect extension to the datafeed series. The first step is to make Google think we have the images on our server. So inside an “images” folder, create “image.php” like so: <?php include(‘../vars.php’); $cQuery [...]

Blog

Custom Categories For Your Datafeed Site

March 12th, 2010 → 2:43 pm @ Eric Nagel

Tweet I’m so happy to hear from affiliates who have followed in the datafeed series and created websites of their own! The other day, Jen Goode showed me a site she was working on, and brought up a common problem with datafeeds: how to categorize the products. I was able to do this using simple [...]

Blog

Building a Datafeed Site – Step 3

March 9th, 2010 → 4:20 pm @ Eric Nagel

Tweet In step 3, we’re going to actually display the data saved in the database! So far I’ve held your hand along the way, but now I’m just going to point you in the right direction, because there isn’t one way to do this. Merchants handle categories in their datafeeds differently, so you’re going to [...]

Blog

Building a Datafeed Site – Step 2

March 8th, 2010 → 12:59 pm @ Eric Nagel

Tweet By now, we have selected the niche and chosen a template, added some supporting files and created the database, and are now ready to populate the products table with actual products! The first step, if you haven’t done so already, is to download the datafeed from the ShareASale website. While many merchants offer FTP [...]

Blog

Building a Datafeed Site – Step 1b

March 7th, 2010 → 7:49 pm @ Eric Nagel

Tweet The next step in building a datafeed website is getting the data into the database, but to do this, we need to build an administrative section to your website, and add some helper functions & files. vars.php was a file seen in Step 1, which I use to store the mysql connection and other [...]

Blog

Building a Datafeed Site – Step 1

March 5th, 2010 → 3:36 pm @ Eric Nagel

Tweet This is the first in a series of how to build a datafeed site. I’m building the site right now, and will share the experience with you. This will be an intermediate to advanced method of using datafeeds to build a site. If you’re looking for a simple way to get started, go check [...]

Blog

Follow-up on Datafeeds Podcast

March 4th, 2010 → 9:23 am @ Eric Nagel

Tweet I was listening to the “both sides of the tracks” podcast about Sports Marketing, Datafeeds and Traffic Geyser that Jason, Joe & I recorded earlier this week, and realized I forgot a point that I wanted to cover. Joe was talking about a custom script he had written which generated tens of thousands of [...]

Blog

Tracking ShareASale Commissions with Prosper202

January 26th, 2010 → 2:46 pm @ Eric Nagel

Tweet Prosper202 is a powerful affiliate marketing tracking software package, with the ability to give you your revenue, cost, and ROI on your PPC campaigns. But the true power is shown when you automate as much as possible. I’ve previously written how to use the ShareASale API, but left it up to you to fill [...]

Blog

Getting Stats from Google AdWords using the API

December 23rd, 2009 → 10:26 am @ Eric Nagel

Tweet Previously I have posted how to automatically get your revenue figures from ShareASale, Commission Junction, and PepperJam. Having that done, the next step to automate my P&L report was to get the advertising costs from Google using the AdWords API. First, I had to set-up a MCC account and apply for a developer token. [...]

Blog