Two Quick Ways to Make Your Copy of Merchants Data Feed Different From All Other Affiliates

Home
>
Affiliate Revenue
>
Two Quick Ways to Make Your Copy of Merchants Data Feed Different From All Other Affiliates

Two Quick Ways to Make Your Copy of Merchants Data Feed Different From All Other Affiliates

Product data feeds are really popular among affiliates because they can help produce thousands of product pages quickly and easily. Such pages can be used to drive highly targeted search engine traffic looking specifically for those products. But there is a big problem.

The problem with data feeds is the fact that a lot of affiliates use the same copies of feeds in the same exact ways. Most data feed affiliates put just the product names in HTML titles, so they all end up with a bunch of similar pages that have identical titles. And since the search engines give a lot of weight to the titles of HTML pages, those affiliates end up competing with each other for the same highly specific keywords.

Luckily, this problem has a quick and dirty solution. It's worse than going over the feed by hand, but much better than doing nothing. What I get from affiliates is that manually modifying feed simply defeats the purpose. But being able to do it automatically can help one differentiate his site from other affiliates without losing the benefits of using data feeds.

There are two basic ways to automatically make your site a little bit different from other affiliates of the same merchant.

The first way is to add some keywords before and/or after the product name in the HTML title. For example, let's say you pick a phrase "On Sale" to add after the product name. So instead of "Blue Widget #MN-3143" you have in the original data feed, you would now have "Blue Widget #MN-3143 On Sale" in the HTML title of that product page. You simply add that phrase to the titles of all products in the feed. That lets you specifically target people who would search for "blue widget on sale" or "mn-3143 on sale."

You can also use some arbitrary keywords like "Cheap" or "Discounted" or "Quality" before the product name to have something like "Cheap Blue Widget #MN-3143." The keywords you pick largely depend on the merchant's product line.

Another variation of this technique is to randomize the keywords that are displayed before and after product names in the titles. You can use a sever-side technology of your choice to pick a random keyword out of some predefined list and append it to the name of a product to form the title for the page. Your scripts would pick a new keyword for each request for the product page. Of course, that would only work if you are using a database, and do not generate static HTML using Webmerge or a similar program. That way, even though you don't control the exact keyword that is displayed for any particular page, with enough product pages you can cover a wider market of people searching with different modifiers. You should be able to cover different shopper types -- the ones looking for bargains as well as the ones looking for quality.

The second way to make your site different from others is a bit more complex, but could yield much greater results. Instead of adding something to the product names, you can try changing the names on a large scale. As I said earlier, modifying feeds by hand would defeat the purpose of using them. But if you perform a find-and-replace operation on the whole file then you can get different content without spending much additional time.

The utility you might want to use for feed modification is called sed. You can search for that name using you favorite search engine. It's sed -- the stream editor. I'm going to skip much of the technical detail on how and why it does certain things in a certain way. Instead, I will concentrate on describing practical application of sed with product feeds.

At its core, sed takes input data, modifies it according to certain rules and outputs the result -- all done line-by-line. It uses regular expressions and can perform extremely complex operations, by for now I just want to concentrate on simple replacements.

The good thing about sed is it can use an external file with multiple commands and execute them one after another for the entire input file (in our case, it's a product feed). So you can replace as many words as you need. Also, once you define those commands, you can use them for many different feeds with different merchants.

Let's go over a few examples that should illustrate the true power of this approach.

I'll assume that the merchant we are working with sells widgets of various kinds. You looked over the feed and saw that the merchant has some porcelain widgets; red and blue, large and small. One of the synonyms for porcelain is ceramic, so first thing you would do is replace the word porcelain with ceramic in all product names and descriptions.

This can be done by adding the following commands to a sed script file before running it against the feed:

s/porcelain/ceramic/g s/Porcelain/Ceramic/g

Those commands will replace your keywords while preserving capitalization. So that a title like "Big Blue Porcelain Widget" becomes "Big Blue Ceramic Widget."

To make things more interesting, let's assume that the feed already has some ceramic widgets aside from the porcelain ones. So you do not want to end up with just one kind. Instead, you want to switch them around. Remember, your goal is to be as different from the original feed as possible.

You can achieve that with the following set of commands:

s/porcelain/MYTEMPKEYWORD/g s/ceramic/porcelain/g s/MYTEMPKEYWORD/ceramic/g

In the example above, I used MYTEMPKEYWORD as a place-holder. That let us make sure that we are not losing the original keywords.

What happens there is:

all "porcelain" is changed to "MYTEMPKEYWORD' then all "ceramic" is changed to "porcelain" then all "MYTEMPKEYWORD" (which used to be the original porcelain) is changed to "ceramic"

and then the same thing should be done for all capitalized keywords.

You can use anything in place of MYTEMPKEYWORD as long as it does not already appear in the feed. You want to use some unique keyword.

Once you are done with those keywords, you can change something like "Metallic" to "Shiny Metal Finish" -- assuming that makes sense for a given product line.

Adding that to a command file would give you:

s/porcelain/MYTEMPKEYWORD/g s/ceramic/porcelain/g s/MYTEMPKEYWORD/ceramic/g s/Porcelain/MYTEMPKEYWORD/g s/Ceramic/Porcelain/g s/MYTEMPKEYWORD/Ceramic/g s/Metallic/Shiny Metal Finish/g s/metallic/shiny metal finish/g

That would also change "Blue Metallic Widget" to "Blue Metal-Looking Finish Widget."

As I said earlier, you can add as many commands as you want for different words and phrases. And with enough such small changes, you will be able to reach traffic that is not already covered by your competing affiliates. While a few hundred affiliates with their data feed sites might be displayed for a keyword "blue porcelain widget" -- there might be just a few (if any) covering "blue ceramic widget" for the same merchant.

Even something like

s/TV Set/Television Set/g

along with diagonal sizes and brand names might help you stand apart from the rest of the affiliates who use the same feed. Any change is better than having the same exact content as others.

I encourage you to download a copy of sed and check it out. Once you get a hang of it, you will be able to automate the whole process. And if you are already using scripts to refresh merchants' feeds and rebuild sites automatically, then you can plug sed in the middle and modify feeds on the fly.

Also, if you are having a hard time coming up with words to replace, you might want to check out Princeton's WordNet. You can even download the word database and use it locally on your desktop.

Konstantin Goudkov manages an affiliate program with a merchant that carries 2500+ gifts. If you enjoy working with companies that treat affiliates like valued partners then be sure to check us out.

You can find more information about our program at: http://www.genericgifts.com/affiliate_progr am.jsp

In The News:

Yahoo! News: Top Stories

Gaza civilian toll rises; diplomats seek truce (AP)

AP - Israel ignored mounting international calls for a cease-fire and said it won't stop its crippling 10-day assault until "peace and tranquility" are achieved in southern Israeli towns in the line of Palestinian rocket fire.

Obama says his plan with tax cuts to get quick OK (AP)

AP - President-elect Barack Obama plunged into rare pre-inaugural crisis talks with congressional leaders Monday, declaring the national economy was "bad and getting worse" and embracing tax cuts now expected to reach $300 billion. He predicted lawmakers would approve a mammoth revitalization package within two weeks of his taking office.

Obama's intel picks short on direct experience (AP)

AP - President-elect Barack Obama's decision to fill the nation's top intelligence jobs with two men short on direct experience in intelligence gathering surprised the spy community and signaled the Democrat's intention for a clean break from Bush administration policies.

Burris says he's senator but Dems won't seat him (AP)

AP - Senate Democrats struggled to avert a showdown steeped in race and corruption Monday as a defiant Roland Burris declared, "I'm a United States senator" and flew to the capital to claim President-elect Barack Obama's old seat in Congress.

Congressmen sound off against SEC in Madoff affair (AP)

AP - Republican and Democratic House members said Monday that the alleged $50 billion fraud involving Wall Street figure Bernard Madoff reflects deep, systemic problems at the Securities and Exchange Commission.

Records reveal anguish of anthrax suspect's wife (AP)

AP - Anthrax mailing suspect Bruce Ivins tormented his wife with rudeness and behaved erratically in the weeks before the Army scientist took his own life by overdosing on Tylenol, according to documents released Monday.

Death certificate: Travolta son killed by seizure (AP)

AP - Jett Travolta's body shows no sign of head trauma and his death certificate says he was killed by a seizure, an undertaker said Monday, after doctors performed an autopsy on the 16-year-old son of the U.S actor.

Health care spending slows in 2007 with generics (AP)

AP - Spending on health care slowed slightly in 2007 as consumers turned more to generic drugs instead of brand-names to fill their medicine cabinets, the government reported Monday.

Toyota to suspend production for 11 days in Japan (AP)

AP - Toyota is suspending production at all 12 of its Japan plants for 11 days over February and March, a stoppage of unprecedented scale for the nation's top automaker as it grapples with shrinking global demand.

Texas rallies past Ohio State 24-21 in Fiesta (AP)

AP - Left out of the national title game, Colt McCoy and Texas made the most of their trip to the Fiesta Bowl.

Israeli troops deepen push into Gaza (Reuters)

Reuters - Israeli forces pressed closer and into cities in the Gaza Strip on Tuesday despite new international calls for a ceasefire in an 11-day-old conflict in which hundreds of Palestinians have been killed.

Prosecutors seek to jail Madoff (Reuters)

Reuters - U.S. prosecutors asked a judge to jail accused swindler Bernard Madoff on Monday, saying he sent jewelry and other items worth more than $1 million to family and friends in violation of his bail.

New Congress set to convene with economy in focus (Reuters)

Reuters - The new U.S. Congress convenes on Tuesday under pressure to deal with a worsening economy by passing a stimulus package that Barack Obama could sign into law soon after being sworn in as president.

Toyota shuts plants as crisis bites (Reuters)

Reuters - Toyota Motor Corp, reeling from its worst U.S. sales decline in more than a quarter of a century, will shut all its factories in Japan for 11 days as the global economic slump hits demand and company profits.

Obama picks former Clinton aide Panetta for CIA (Reuters)

Reuters - President-elect Barack Obama has chosen former White House chief of staff Leon Panetta to lead the CIA, which has been widely criticized for harsh interrogation of terrorism suspects, Democratic officials said on Monday.

Democrat wins Minnesota Senate seat in recount (Reuters)

Reuters - Democrat Al Franken beat Republican incumbent Norm Coleman to win the U.S. Senate seat from Minnesota, officials conducting a final recount said on Monday, though the loser promised to challenge the result.

California gay marriage battle turns to court role (Reuters)

Reuters - The legal battle over gay marriage in California turned on Monday to whether the state's top court could strike down a change in the state constitution that was approved by voters.

Ukraine says Gazprom cuts Europe gas supply to 1/3 (Reuters)

Reuters - Ukraine's state energy company Naftogaz said on Tuesday that Russia's Gazprom had cut gas supply to Europe via Ukraine to around a third of its normal flow and that the shortage would hit Europe in a few hours.

Fighting rages in Gaza as Israel spurns truce bids (AFP)

AFP - The heaviest fighting of Israel's war on Hamas raged in Gaza City early on Tuesday as Israeli Prime Minister Ehud Olmert rebuffed appeals to stop the death toll from mounting further.

DR Congo rebel chief denies leadership change (AFP)

AFP - One of Congo's main rebel military chiefs denied that Laurent Nkunda, head of the National Congress for the Defence of the People (CNDP), had been toppled by a dissident group.

Two Quick Ways to Make Your Copy of Merchants Data Feed Different From All Other Affiliates

Affiliate Revenue Affiliate Revenue