Hey everyone! My name is Justin Briggs, and I'm an SEO consultant at Distilled. A few weeks ago, I packed up and moved across the country to come to Seattle. Some of you might know me better as "seozombie" on Twitter. This is my first post on SEOmoz, but you can expect to see more from me here and on our blog at Distilled.
With the transition of Yahoo! to Microsoft’s Bing backend, webmasters have lost the ability to perform advanced searches using the link: and linkdomain: parameters. Rand Fishkin wrote a post about replacing the Yahoo! linkdomain: data with other data sources. Although Linkscape and Open Site Explorer provide a great data source, there is some functionality that Yahoo! had that isn't present in other tools yet. The primary functionality I missed was the ability to perform searches against page content; not just page title, URL, and anchor text.
These link searches can help you identify link opportunities from other websites' (such as competitors) backlinks.
Searching Content of Backlinks
To solve this problem, I setup a Google Custom Search Engine using data from Open Site Explorer. There are two exports of data you can use, which are links and linking domains. I’ll briefly go over the pros and cons of each as a data source in GCSE.
Linking URLs
Pros
Only search content that has links
Less noise
Cons
Limited to top links
Limited to 25 URLs per domain
Multiple links per domain reduces domain diversity
Limited content (5,000 annotations = 5,000 URLS)
Linking Domains
Pros
Search all indexed content on a linking domain
Find linking sources not included in OSE export
Greater domain diversity
More content (5,000 annotations = 5,000 domains of content)
Cons
More noise
Large linking domains like Wordpress.com and Blogger.com have subdomains (lots of noise)
Results that don’t have link
Setup of Custom Search Engine
Setup of your custom search engine is very easy. For this example, I’m going to use linking domains from OSE.
1) Perform search in Open Site Explorer
2) Pull linking domains for all pages on the root domain, export to CSV
3) Get list from Excel
I used Find & Replace to add a * to the end of all URLs, for matching. You can sort by DA or linking domains. Google Custom Search Engine only allows 5,000 annotations, so only copy up to 5,000 domains.
So here are the pages on domains that link to distilled.co.uk, that include “link building” in the content and “resources” in the title.
This solution gives you a new way to mine for backlinks opportunities using your competitor's backlinks. You can also include linking domains from multiple competitors at the same time. However, you can only include up to 5,000 annotations at a time, so you might want to use some Excel filters to remove noise and duplicate entries.
Tips
Here are a few quick tips to speed things up.
Remove massive domains – Large domains like wordpress.com and blogspot.com can produce a lot of noise.
Use the –site: search to reduce noise – If a particular domain is creating a lot of noise in your search, use a negative site search to remove it.
Search brand mentions – A search for the brand can help find the linking pages on these domains.
Search top anchors from OSE – Find the pages that include the anchors the site is targeting.
Example Queries
"powered by wordpress" "distilled"
Find pages that mention the brand “Distilled” and include “Powered by Wordpress”. This is an easy way to find the blogs linking to Distilled.
“guest blogger” OR “guest post” OR “guest article” OR “guest column” -site:blogspot.com -site:wordpress.com -wordpress.org
Find guest blogging opportunities, but filter out domains that may create a significant amount of noise.
"powered by vbulletin" AND seo
Find vBulletin powered forums mentioning SEO.
“link building” intitle:resources
Find link building resource pages.
Give it a Try & Search SEOmoz's Backlinks
A few queries to try: "top seo tools" “link building” intitle:resources "open site explorer" "powered by wordpress" allinurl:seomoz
Go ahead, try it, you know you want to!
Loading
I removed linking domains with a DA greater than 90, just to remove some noise from larger domains. (Selecting this value to filter by was completely arbitrary and is just to make the example easier to use.)
I hope this helps everyone replace some of the functionality of the Yahoo! linkdomain command. If you've got more link searches or ideas to add, please share.
Your Daily Snapshot for Monday, September 27, 2010
Photo of the Day
President Barack Obama, along with First Lady Michelle Obama, addresses a reception for the United Nations General Assembly at the American Museum of Natural History in New York, New York, Sept. 23, 2010. (Official White House Photo by Pete Souza)
Here are some of the top stories from the White House blog.
Dodging the Impact of Their Policies "Across the Board" A day after the Congressional Republicans unveiled their “Pledge to America,” it becomes even clearer that this is merely a return to the very same special-interest policies that got us into the worst economic downturn since the Great Depression.
President Obama in Ministerial Meeting on Sudan: "The Fate of Millions" President Obama attends a meeting of heads of state, and Sudanese leaders, discussing the responsibility of all parties to fully implement the peace agreement that ended Sudan’s civil war, calling for accountability for crimes, and speaking directly to the people of Sudan about how the United States would support those who work for peace.
I'm starting to feel a bit sorry for Yahoo, not only are they seen by most people as a bit of a joke, largely the stick is unwarranted. They've got some great little products and services, two of which I use to this great little way of keeping tracking of easy social media interaction opportunities.
The main service is Yahoo Answers, its a hugely popular social site where users ask and answer questions. If you've not checked Yahoo Answers recently, go over now and have a look, there will be dozens of people asking questions related to your industry – no matter how obscure or niche it is.
The nightmare though is having to revisit the site everyday to see whether there's anything new or relevant. Fortunately the main categories have RSS feeds so you could set up the feed in your RSS reader to keep track of the mentions in your chosen category, but your a busy digital marketer, you don't have time to check through every question asked on the site. That's where Yahoo Pipes comes in.
If you've never heard of Yahoo Pipes don't worry, nobody has. It's simple tool which allows you to do some very simple filtering and sorting of web data like RSS feeds. It can do some pretty clever tricks but what we want it to do is really simple. Take a feed from Answers, search for any questions that contain your keywords, discard those without and deliver those that do into a new RSS stream.
Start by dragging and dropping the a fetch feed icon from the side bar into the main screen. This will then create a box with a text field. Cut and paste the feed url from your most relevant category in Yahoo Answers. If more than one category is applicable click the addition/plus symbol and it'll add a new text field for another category.
Next click the Operators expanding button in the side bar, find the filter button and drag and drop it between the Fetch Feed Box and Feed Output. It'll have a text field you can type the word or phrases you want to monitor for. The drop down fields give you flexibility whether you want to look just in the Question Title and/or description Etc.
You can add more than one keyword by clicking the plus symbol, it gets quite clever now as well, you could filter questions that include SEO and PPC or you could set it up for questions that include SEO or PPC. It's pretty self explanatory when it's in front of you.
Now you need to connect the feed to the filter and from the filter to the out put. Click the circle and the bottom of the feed fetcher and drag it to the start of the filter, then do the same from the filter to the output. It should look something like the picture below.
Nearly there now, just save the pipe and hit the 'Run this Pipe' button. This will take you to a page where you can subscribe to this new feed. But I'm too lazy/busy to check my feedreader daily, so I take it a step further and use FeedMyInbox to take the feed address and email me whenever there is a suitable question.
Clever time saving trick which with a little tweaking you can use on dozens of social sites with RSS feeds. Do you monitor any social sites like this? Any tips to save time checking back for opportunities?
When someone comes to your site for the first time, they're likely to hit 'about' or 'bio'. Why? Because they want a human, a story and reassurance.
Here are some helpful guidelines (okay, they're actually imperatives):
1. Don't use meaningless jargon:
... is a recognized provider of result-based online and mobile advertising solutions. Dedicated to complete value chain optimization and maximization of ROI for its clients, ... is committed to the ongoing mastery of the latest online platforms - and to providing continuously enhanced aggregation and optimization options.
2. Don't use a stock photo of someone who isn't you (if there is a stock photo of you, congratulations). The more photos of you and your team, the better.
3. Make it easy to contact you. Don't give a contact address or number that doesn't work.
4. Be human. Write like you talk and put your name on it. Tell a story, a true one, one that resonates.
5. Use third party comments and testimonials to establish credibility. Use a lot of them. Make sure they're both interesting and true.
Patience of US legislators regarding the value of the Yuan has finally given out. Last Friday, Congress jumped into the fray after exceptionally harsh statements from Treasury Secretary Tim Geithner, who up until now had always preached diplomacy. Here is a brief sequence of events.
Sept. 15, 2010 Patience appears to have run out in Washington for the standard White House approach that favors quiet diplomacy for dealing with China over the dispute over the value of its currency.
In testimony to the House Ways and Means Committee, a wide array of experts said that quiet diplomacy has essentially been a failure. The only debate at the hearing was what new approach should be tried.
Sept. 16, 2010 "China needs to allow significant, sustained appreciation over time to correct this undervaluation and allow the exchange rate to fully reflect market forces," Geithner said in testimony prepared for the Senate Banking Committee. Geithner will also talk about the yuan with the House Ways and Means Committee this afternoon.
"It is past time for China to move," Geithner said.
An undervalued yuan has helped China to boost exports and encouraged U.S. companies to outsource manufacturing to China from the U.S., Geithner said. He added that the yuan is held at a undervalued level by "heavy intervention" even as Chinese officials have pledged to allow the yuan's value to be guided more by market forces.
Sept. 20, 2010 China pledged not to repeat Japan's mistake and allow its currency to rise in response to foreign pressure, countering criticism from U.S. lawmakers that the yuan is undervalued amid a growing cross-Pacific row over Beijing's currency regime.
"China will not go down the path that Japan did and give in to foreign pressure on the yuan's exchange rate," Li Daokui, an economist and member of the monetary policy committee of the People's Bank of China, was cited as saying in a report by the state-run China Daily.
Li's comments appeared to reference to the 1985 Plaza Accord that resulted in coordinated government intervention in the currency markets to bring down the value of the U.S. dollar amid concerns over a ballooning trade deficits with its most important trading partners.
There's growing concern in Beijing that the strong-yen agreement doomed Japan's economy.
Attracted by the appreciating yen, cash flowed into Japan in the late 1980s, resulting in loose monetary conditions that helped fuel a bull market in stocks and real estate. The resulting asset bubble burst in 1990, followed by two decades of economic stagnation in Japan.
"But what has the US done to reduce its trade deficit?" Li said. "The US should pay much more attention to its own problems."
Congress Risks Trade War
Geithner's sounding off and the rebuke from China were all it took to spur Congress into action.
Sept. 23, 2010 Democratic leaders in the House of Representatives will move ahead with a bill allowing the US to retaliate against China for manipulating its currency, a significant escalation of the dispute between Washington and Beijing.
Sander Levin, chairman of the ways and means committee in the House of Representatives, said on Wednesday the bill would be compatible with World Trade Organisation rules.
But in a largely untested area of trade law the measure will evoke opposition from Beijing and could lead to a legal challenge in the WTO. The bill will go to committee on Friday and could be voted on by the full House as early as next week.
"This bill is being advanced in the absence of effective action on a multilateral basis," Mr Levin said.
Hours later, Wen Jiabao, the Chinese premier, told business leaders in New York that pressure on Beijing was unwarranted.
"The conditions for a major appreciation of the renminbi do not exist," he said. If the renminbi were suddenly to rise by a large degree against the dollar, "we cannot imagine how many Chinese factories will go bankrupt, how many Chinese workers will lose their jobs, and how many migrant workers will return to the countryside... China would suffer major social upheaval".
The adoption of the measure by the Ways and Means Committee on Friday means it will now be voted on by the House of Representatives on Wednesday.
"China's exchange-rate policy has a major impact on American businesses, and Americans jobs, which is what this is all about," said Sander Levin, a Democrat from Michigan and chairman of the committee.
China's determination to shackle the strength of its currency helped turn the country into the world's manufacturing hub for everything from iPods to T-shirts and, until the recession bit, attracted few critics. But an unemployment rate of 9.6pc in the US, as well as upcoming Congressional elections, is spreading anger across Capitol Hill.
According to the bill's supporters, a properly valued yuan would move jobs back to the US as exports from China become more expensive. The Peterson Institute for International Economics in Washington argues up to 500,000 American jobs could be created.
Not every US company shares the committee's view. Wal-Mart and Citigroup are among companies lobbying against the Bill, fearing it will provoke retaliation in China. If the bill passes next week, the Senate will still need to vote on it.
Legislation pressing China to raise the value of its currency is set for a vote in the U.S. House next week, as Republicans joined Democrats in expressing frustration that the yuan is appreciating too slowly.
"We cannot wait any longer to level the playing field for U.S. businesses and protect American manufacturing jobs," Democratic Leader Steny Hoyer of Maryland said yesterday after the Ways and Means Committee sent the bill to the full House.
The committee adopted the measure by voice vote after the panel's top Republican, Dave Camp of Michigan, voted with Democrats to back the bill. The full House will vote Sept. 29, said committee Chairman Sander Levin of Michigan, a Democrat.
The measure would let companies petition for higher duties on imports from China to compensate for the effect of a weak currency. President Barack Obama's administration hasn't taken a position on the bill, said Natalie Wyeth, a Treasury Department spokeswoman.
The currency dispute "is a proxy for the state of the overall U.S.-China commercial relationship," William Reinsch, president of the Washington-based National Foreign Trade Council, said Sept. 23 on Bloomberg Television. "I don't think it will have that big of an impact on the American economy."
Lawmakers fended off warnings from lobbyists representing companies such as Caterpillar Inc., Wal-Mart Stores Inc. and Citigroup Inc., who said the measure may lead to retaliation against U.S. companies operating in China and curb exports to the country. China may retaliate if the House passes the legislation, said Reinsch, who represents multinational companies such as Caterpillar.
Forty-four Republicans had already signed on as sponsors of the original bill, and with Camp's support, lobbyists said they expect additional Republicans to vote with Democrats next week.
"Provoking tension with our trading partners doesn't come without costs, and we should choose our battles carefully," Stephanie Lester, vice president of the Retail Industry Leaders Association, which represents Wal-Mart, said in a statement. "It makes little sense to enact harmful policies that will spark a bilateral conflict over currency with one of our largest trading partners and fastest growing markets for American exports."
Impact on Jobs
I certainly disagree with C. Fred Bergsten, director of the Peterson Institute for International Economics in Washington who says "Forcing China to raise the value of its currency may create 500,000 jobs in the U.S."
I do not think it will create any jobs. In fact, I think it will cost jobs. Manufacturing is not going to return to the US just because we pass tariffs on China. Wage differentials are too great. Instead, imports will simply come from some other country and rising prices will hurt sales.
Of course we could pass tariffs on the whole world, but who then buy our stuff? The most likely thing to happen if we pass massive numbers of tariffs is global trade will collapse.
How Might China Respond?
Assuming we do pass a bill and the President signs it, China will respond.
Some might argue this would prompt China to dump treasuries. I find that unlikely. However, China would certainly buy less of them.
Anti-China sentiment is at a fever pitch in Congress.
If Congress passes a bill, the president will be in a no-win situation, with either his reelection chances or the economy at huge risk.
For example, if the president vetoed a bill he would be attacked from members of both political parties.
If he signed a bill and numerous import tariffs placed, global trade would collapse and the US would soon be back in a deep recession, assuming you believe Good News: The Great Recession is Over
Regardless, trade wars will make matters much worse. Does anyone remember Smoot-Hawley?
First Things First
We still do not know if the Senate will take up the measure before the election, what the Senate version will look like, whether the president will sign the bill if the measure passes, and whether or not the final version of the bill mandates action instead of noise.
Lots of things can happen. Hopefully cooler heads prevail. One final point: Trade wars like these are hallmarks of deflationary times.
Addendum - Fair Trade or Free Trade?
I was asked "Mish, what if we adopted a 'fair trade' policy where we only traded with countries that meet certain standards. Ie.) they need a EPA equivalent, UI, etc. This would seemingly stimulate jobs here while raising the global standard of living no?"
That may sound good but what constitutes "fair trade? Who gets to define "fair"? Us or them?
Assume for a second that everyone is selling us stuff for far less than its worth. Who is harmed by this, us or them? The overwhelming percentage of the population (everyone but the handful of jobs we would save by tariffs) comes out ahead. How is this not a good thing?
Imagine going into Walmart and demanding to pay higher prices. They would think you were nuts, and so would I. Go into a small business and demand to pay more and they will probably accommodate you. People shop at Walmart, Target, Kohls, Best Buy or wherever because they like low prices.
The only people who don't like low prices are those who think (incorrectly) that higher prices will bring back jobs. But they won't.
The irony in this "fair trade" argument is the US is arguably one of the biggest abusers of "fair trade" around, especially on agricultural products. The EU is second.
Even Canada bitches at us regarding agricultural goods and lumber. Year in and year out trade agreements die on US and EU agricultural subsidies.
I maintain the first country that practices free trade regardless of what anyone else does will be a winner.
I sit on the board of a small community bank and I can attest to the fact that our loan portfolio is in excellent shape even when taking into consideration today's dismal economy. That is not to say a loan is good when made can go bad but if that happens, our bank has sufficient collateral pledged against the loan to cover such short falls. We also review our loan loss reserve and increase as needed based on criteria established under current banking regulations.
Sure there are numerous troubled banks identified by the FDIC but I feel many of these banks will survive.
All banks should be making reasonable earnings with today's low interest rate environment. For community banks, loans are vital and banks are interested in making loans to individuals or businesses that meet our underwriting standards but loan demand is down. A big majority of our loans are just loans leaving another financial institution. Why would someone leave one bank for another?
Of course loan interest rates play a part in the decision but I think a big part is the relationship a customer develops with the loan officer. Dealing directly with a local loan officer who understands your business and is genuinely interested in your business is vital.
Today many larger banks only use local loan officers to bring in the loan request but the decision to make the loan and the terms rest in some committee located in a town far away. Most small business persons will leave such a bank for a local bank with more personalized service.
It's ridiculous that Congress passed and our president signed a bill to provide funds to smaller banks for more loans. As a bank director, there is no way this plan can work. If a bank needs more deposits for loans, assuming the bank has sufficient capital, a banker can easily get more deposits from the public at a much lower cost than the bill passed by congress.
Our government is totally out of touch with the real world and passed this legislation strictly as a political move to make the public think they are trying to help small businesses.
This bull, I mean bill, should be labeled TARP II or some similar acronym.
Bazooka Lending Theory and Practice
Unlike October 2008, when Paulson forced the CEOs of the 9 largest banks to accept funds (See Compelling Banks To Lend At Bazooka Point) no one is forcing small community banks to do anything.
This is what I wrote in 2008 ...
For now, you can force banks to take money, but you can't force them to lend it.
Bazooka Theory
There seems to be a fine line between ...
1) Illegally forcing supposedly well capitalized banks at bazooka point to take money on questionable terms
2) And illegally forcing those same banks at bazooka point to lend it
Self Preservation
Thus the best thing banks can do with that money is sit on it. Yet the penalty for sitting on it is the difference between what the Fed will pay on bank reserves and the 5% interest banks have to pay at bazooka point for borrowing money they did not want in the first place. If banks do start lending like Paulson wants, defaults are guaranteed to increase dramatically.
Someone needs to tell Paulson to go to hell but no one at the table had enough courage to do it.
Here We Go Again
Banks paid back those "forced loans" as soon as they could. Small business lending did not go up, nor should it have. Credit worthy customers were (and still are) few and far between.
Nonetheless, here we go again, except this time it's voluntary.
Hells bells, if a program that forced banks to take money at bazooka did not compel banks to lend, how is a small voluntary program supposed to do it?
Supposedly, this plan will create another 4 million jobs according to president Obama. Hmm. It seems we spent a trillion dollars yet created no jobs, so offering $30 billion (little if any will be taken) to create 4 million jobs would be a feat indeed.
Fans of Triestina, a professional soccer team from the northern Italian city of Trieste, were greeted with a surprise Saturday when they arrived at the team's stadium for a game against Padova.
For the first time in four years, nearly every seat in the "Colaussi" stand, which runs along one side of the field and faces the television cameras, appeared to be taken. That stand alone, which holds 10,000 fans, would have nearly doubled the team's average attendance from the previous year.
On television, the crowd looked impressive. But in person, the scene looked a bit strange. The fans were clad in scarves and winter coats—unusual for a balmy September afternoon. They failed to make a sound when the home team ran out on the field and didn't budge when the match ended in a scoreless draw.
Turns out there was a good reason for this: These "fans" were actually two-dimensional images of fans printed on a giant sheet of vinyl and stretched across the empty seats.
"It's depressing," says supporter Marco Caselli. "It's as if we're sending out the message that Trieste has no flesh-and-blood fans, just cardboard cutouts."