<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>SEER Interactive</title>
	
	<link>http://www.seerinteractive.com</link>
	<description>SEO SEM and the world of search marketing</description>
	<lastBuildDate>Sun, 20 May 2012 20:38:32 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.3.1</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/seerinteractive/dndP" /><feedburner:info uri="seerinteractive/dndp" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>SEOmoz Meetup: Rapid Fire Link Building Strategies</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/9p4ruCq0Z64/seomoz-meetup-rapid-fire-link-building-strategies</link>
		<comments>http://www.seerinteractive.com/blog/seomoz-meetup-rapid-fire-link-building-strategies#comments</comments>
		<pubDate>Fri, 18 May 2012 12:30:24 +0000</pubDate>
		<dc:creator>Chris Le</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=10105</guid>
		<description><![CDATA[Wil Reynolds gave this talk at the SEOmoz Meetup at the Search Church on 5/10/12.  He talks about doing &#8220;s*it real companies do,&#8221; new ways to use old tools, and the importance of persuasion is in Link Building. This is the 1st of 9 presentations from the SEOmoz Meetup at the Search Church on 5/12/12.  I&#8217;ll be [...]]]></description>
			<content:encoded><![CDATA[<p>Wil Reynolds gave this talk at the SEOmoz Meetup at the Search Church on 5/10/12.  He talks about doing &#8220;s*it real companies do,&#8221; new ways to use old tools, and the importance of persuasion is in Link Building.</p>
<p><iframe width="570" height="321" src="http://www.youtube.com/embed/nMADOLcArUs?fs=1&#038;feature=oembed" frameborder="0" allowfullscreen></iframe></p>
<p>This is the 1st of 9 presentations from the <a href="http://www.seomoz.org/blog/meetup-at-the-search-church" target="_blank">SEOmoz Meetup</a> at the <a href="http://www.thesearchchurch.com" target="_blank">Search Church</a> on 5/12/12.  I&#8217;ll be posting each presentation in the order they were given over the next several days.  After the last presentation, I will have a link to all the slide decks and an MP3 of the entire meetup.</p>
<p>Lookout for Monday&#8217;s video: <a href="http://www.seerinteractive.com/team/anniec" target="_blank">Annie Cushing</a>&#8216;s presentation on &#8220;Web Scraping for Code-ophobes&#8221;</p>
<p>The presentations was recorded and streamed live during the event by our friends</p>
<p style="text-align: left;"><a href="http://skoutmediaphilly.com/"><img class="wp-image-10124" title="Skout Media" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/skoutmedialogo_whitetext-300x206.jpg" alt="" width="144" height="99" /></a></p>
<p style="text-align: left;">(Update: I&#8217;ll post Annie&#8217;s video on Monday instead. Not Saturday.)</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=9p4ruCq0Z64:qdJ61jUzeWw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=9p4ruCq0Z64:qdJ61jUzeWw:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=9p4ruCq0Z64:qdJ61jUzeWw:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=9p4ruCq0Z64:qdJ61jUzeWw:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=9p4ruCq0Z64:qdJ61jUzeWw:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=9p4ruCq0Z64:qdJ61jUzeWw:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/9p4ruCq0Z64" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/seomoz-meetup-rapid-fire-link-building-strategies/feed</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/seomoz-meetup-rapid-fire-link-building-strategies?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=seomoz-meetup-rapid-fire-link-building-strategies</feedburner:origLink></item>
		<item>
		<title>A Few Tips for Quick Keyword Research – free tool included!</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/6AxHx1N1eQE/a-few-tips-for-quick-keyword-research-free-tool-included</link>
		<comments>http://www.seerinteractive.com/blog/a-few-tips-for-quick-keyword-research-free-tool-included#comments</comments>
		<pubDate>Thu, 17 May 2012 17:51:04 +0000</pubDate>
		<dc:creator>Abbott Shea</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=10097</guid>
		<description><![CDATA[I cannot necessarily claim keyword research mastery &#8211; just yet &#8211; but I have at least improved on my own process since my first time around the block and I want to share some of what I’ve learned for you to use yourself. These tactics can help you cut your keyword research process by nearly [...]]]></description>
			<content:encoded><![CDATA[<p>I cannot necessarily claim keyword research mastery &#8211; just yet &#8211; but I have at least improved on my own process since my first time around the block and I want to share some of what I’ve learned for you to use yourself. These tactics can help you cut your keyword research process by nearly 50%.</p>
<p>Keyword research can be a cumbersome task – especially for an ecommerce site with a large inventory. But the pockets of opportunity one discovers through good keyword research can be pivotal to the success of a project.</p>
<p>There are a ton of masters that who have already given us resources on how and where to look when first getting into keyword research – a good starters guide being the <a href="http://www.seomoz.org/beginners-guide-to-seo/keyword-research">SEO Moz’ Beginners’ KW Research Guide</a>. This article is not going to repeat the knowledge they have already shared with us, instead it will be aimed at simply giving you tips to execute some of what they’ve taught us faster.</p>
<p>Firstly, you need a quick way to find the KWs you are considering to target. Some quick keyword research tips on discovery and then how to make creating KW ideas quickly.</p>
<p>Things to do for discovery:</p>
<ul>
<li>Plug some top competitors’ sites / target pages into different keyword research tools.</li>
<li>Use Ubersuggest or PromediaCorp’s Suggester to find common queries around our product or service.</li>
<li>Think like a customer.</li>
</ul>
<p>If you’re scratching your head on the last one, what I mean here is to research the market and think of the different ways you might structure your search query if you were in need of your client’s product or service. Am I (<em>and others</em>) looking for a ‘free’ version, or am I looking to find this product ‘for sale’, and so forth.</p>
<p>Once you’ve got a good crop of the different ways people are searching for one of your products , or services, you can apply the same logic – and in many cases the same exact queries – for all of your similar products or services. Now you can speed it up.</p>
<p>Use the CONCATENATE function in Excel to build queries around all of your products for you. Below is a video on exactly how to do that using an examples from a client of ours that sells used trucks, <a href="http://www.ameriquestcorp.com/">AmeriQuest Corp</a>.</p>
<p style="text-align: center"><a href="http://www.youtube.com/watch?v=4htITn84lUQ"><img class="aligncenter size-large wp-image-10099" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Keyword_Research_Video_2-570x346.png" alt="" width="570" height="346" /></a></p>
<p style="text-align: center">(<em>This post links to the video in YouTube. Also, Jing leaves some funky grey marks in the video, not a special version of Excel</em>)</p>
<p>It helps to prioritize keywords based on volume, but you are also going to want to check the actual results around these keywords so that you can also prioritize on relevance and competition.</p>
<p>You may be thinking, ‘<em>Now I have to look at the results of each! But that takes so long!</em>’ This can be true, but if you don’t take the time to search for these things you might find that you’ve targeted a keyword that is not returning any commercial results. Or you could be selling a product like ‘sexual harassment training’ services and find that Google thinks <a href="http://screencast.com/t/CsU6U1HmLNi">Herman Cain parodies</a> are the relevant results for users. So maybe that isn’t a results page you want to be in.</p>
<p>This process <em>can</em> be long, but let’s cut that time in <strong>half</strong>. Again, we will use CONCATENATE.</p>
<p>What  we will do here is have Excel (or GDocs) help me build the actual searches in Google, and then I will check out 10 to 15 of these different SERPs at once – much faster than searching them one at a time or clicking through in the AdWords tool.</p>
<p>This may just be easier to see…</p>
<p><a href="http://www.youtube.com/watch?v=r2En6ey_UO0"><img class="aligncenter size-large wp-image-10100" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Keyword_Research_Video_1-570x344.png" alt="" width="570" height="344" /></a></p>
<p style="text-align: center">(<em>Also leads to a video in YouTube</em>)</p>
<p>Now wasn’t that fast? Using this ‘Query Generator’ and Ontolo, you are able to sniff out all of these SERPs in a matter of seconds.</p>
<p>That Query Generator is linked at the bottom – a free tool for you! It’s really very simple, so PLEASE modify it &#8211; just PLEASE <a href="http://support.google.com/docs/bin/answer.py?hl=en&amp;answer=65320">make a copy for yourself</a> if you do. Another place this tool useful is looking at a list of vendors or suppliers for linking opportunities – often businesses will have the names of these partners readily available, but not their websites.</p>
<p>Hopefully discovering these few things will help you during your next project kickoff, and hopefully you can use the free tool linked below as a stepping stone to create something even better. If you have questions leave them below or shoot me a tweet <a href="http://twitter.com/#!/abbott_shea">@abbott_shea</a>. Thanks!</p>
<p><strong><a href="https://docs.google.com/spreadsheet/ccc?key=0AtvIiGTgvAowdHhzUHJRSEZvdU9ERnNhenlLVXZ4NUE">Basic Query Generator V_1.1</a></strong></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AxHx1N1eQE:aoTu8qCQZoc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AxHx1N1eQE:aoTu8qCQZoc:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=6AxHx1N1eQE:aoTu8qCQZoc:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AxHx1N1eQE:aoTu8qCQZoc:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=6AxHx1N1eQE:aoTu8qCQZoc:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AxHx1N1eQE:aoTu8qCQZoc:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/6AxHx1N1eQE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/a-few-tips-for-quick-keyword-research-free-tool-included/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/a-few-tips-for-quick-keyword-research-free-tool-included?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=a-few-tips-for-quick-keyword-research-free-tool-included</feedburner:origLink></item>
		<item>
		<title>Use Screaming Frog to Verify Google Analytics Code</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/ia5VMk9C2i4/screaming-frog-to-verify-google-analytics</link>
		<comments>http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics#comments</comments>
		<pubDate>Thu, 10 May 2012 21:45:20 +0000</pubDate>
		<dc:creator>Rachael Gerson</dc:creator>
				<category><![CDATA[analytics]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=10038</guid>
		<description><![CDATA[The paid version of Screaming Frog is a lifesaver! I use Screaming Frog regularly to make sure the correct Google Analytics code is in place on every page of a website. Just because the code is in place on the homepage doesn&#8217;t mean the same code is on every page. Some pages could be totally [...]]]></description>
			<content:encoded><![CDATA[<p>The paid version of <a href="http://www.screamingfrog.co.uk/seo-spider/">Screaming Frog</a> is a lifesaver! I use Screaming Frog regularly to make sure the correct Google Analytics code is in place on every page of a website. Just because the code is in place on the homepage doesn&#8217;t mean the same code is on every page. Some pages could be totally missing the code while others could have different versions. Posting my quick process here since I get asked about this frequently&#8230; and since I&#8217;m talking about this today at the <a href="http://www.seomoz.org/blog/meetup-at-the-search-church">SEOmoz Meetup at the Search Church</a>!</p>
<p><strong>Start by selecting Custom Filters under Configuration.</strong></p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_1" rel="attachment wp-att-10039"><img class="alignnone  wp-image-10039" title="Screaming Frog 1" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_1.png" alt="" width="623" height="388" /></a></p>
<p>Determine what you want to search for in the filters. I usually have one filter showing pages that do contain information I&#8217;m looking for then pages that don&#8217;t contain it.For example, filters 1 and 2 will usually be pages that do or don&#8217;t contain the UA number.</p>
<p>For the example below, I used SEER&#8217;s UA: <strong>UA-11852503-1</strong>.</p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_2" rel="attachment wp-att-10040"><img class="alignnone  wp-image-10040" title="Screaming Frog 2" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_2.png" alt="" width="620" height="386" /></a></p>
<p>If a site uses cross domain tracking because it spans multiple domains or subdomains, grab the line of code for cross domain tracking and drop it into filters 3 and 4. Make one filter Contains and the other filter Does Not Contain.</p>
<p>For the example below, I used <strong>setDomainName&#8217;, &#8216;seerinteractive.com</strong>.</p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_3" rel="attachment wp-att-10041"><img class="alignnone  wp-image-10041" title="Screaming Frog 3" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_3.png" alt="" width="617" height="384" /></a></p>
<p>For filter 5, try adding a snippet from the second portion of the GA code. I&#8217;ve been surprised by the number of sites that drop off the second portion and keep only the top part of the code.</p>
<p>For the example below, I used <strong>google-analytics.com/ga.js</strong>.</p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_4" rel="attachment wp-att-10042"><img class="alignnone  wp-image-10042" title="Screaming Frog 4" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_4.png" alt="" width="618" height="384" /></a></p>
<p>Once the settings are all in place, enter the URL in Screaming Frog and hit Start.</p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_5" rel="attachment wp-att-10043"><img class="alignnone  wp-image-10043" title="Screaming Frog 5" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_5.png" alt="" width="617" height="382" /></a></p>
<p>From there, go to the Custom tab. The data that shows up will be for any of your filters. You can quickly scan the filter data for issues, or can export data from each of the filters to a CSV for further analysis or to send to the client.</p>
<p><a href="http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/screaming_frog_6" rel="attachment wp-att-10044"><img class="alignnone  wp-image-10044" title="Screaming Frog 6" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screaming_Frog_6.png" alt="" width="615" height="382" /></a></p>
<p>If you&#8217;re running Screaming Frog on a client&#8217;s site, give them a heads up first. Without that warning, someone may see the tool hitting their site quickly and think there is an issue.</p>
<p>Let me know if you use Screaming Frog to check for GA code too, or if you have other methods you currently use.</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Quick update: Adding a well deserved shout out to Will Critchlow. Even though I wasn&#8217;t at Will&#8217;s <a href="http://www.distilled.net/blog/seo/the-modern-seos-toolkit-my-rant-about-learning-to-code/">Search Love presentation</a> last October, I checked out the slides. They were <em>so</em> full of win. Slide 32 had the image of how Will&#8217;s team uses Distilled to confirm the presence of GA code, which got me to start looking at Screaming Frog and how to take that concept further. Will, Distilled team, etc, thank you!!</p>
<p><img class="alignnone size-full wp-image-10089" title="Distilled_Image" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Distilled_Image.png" alt="" width="676" height="447" /></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=ia5VMk9C2i4:4NLgqVVmgJ8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=ia5VMk9C2i4:4NLgqVVmgJ8:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=ia5VMk9C2i4:4NLgqVVmgJ8:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=ia5VMk9C2i4:4NLgqVVmgJ8:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=ia5VMk9C2i4:4NLgqVVmgJ8:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=ia5VMk9C2i4:4NLgqVVmgJ8:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/ia5VMk9C2i4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics/feed</wfw:commentRss>
		<slash:comments>16</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/screaming-frog-to-verify-google-analytics?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=screaming-frog-to-verify-google-analytics</feedburner:origLink></item>
		<item>
		<title>More ImportXML Cookbooks</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/OPgyi24FdU4/more-importxml-cookbooks</link>
		<comments>http://www.seerinteractive.com/blog/more-importxml-cookbooks#comments</comments>
		<pubDate>Wed, 09 May 2012 12:30:26 +0000</pubDate>
		<dc:creator>Chris Le</dc:creator>
				<category><![CDATA[SEO]]></category>
		<category><![CDATA[tools]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9872</guid>
		<description><![CDATA[5 Scrapers for the price of 1 blog post! Here&#8217;s a new collection of 64 new ImportXML formulas and 5 spreadsheets to jump start your scrape-fest. I wanted to update my original ImportXML Cookbook post so I recently asked twitter for requests (DJ Chris Le.. get it?! HAhaha ah h &#8230; ok, nevermind.)  The majority of requests were [...]]]></description>
			<content:encoded><![CDATA[<p><img class="alignnone size-large wp-image-9898" title="Screen shot 2012-05-08 at 12.29.25 PM" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-08-at-12.29.25-PM-570x452.png" alt="" width="570" height="452" /></p>
<p><strong>5 Scrapers for the price of 1 blog post! </strong>Here&#8217;s a new collection of <em><strong>64</strong></em> new ImportXML formulas and 5 spreadsheets to jump start your scrape-fest.</p>
<p>I wanted to update my original <a title="ImportXML Cookbook" href="http://www.seerinteractive.com/blog/importxml-cookbook" target="_blank">ImportXML Cookbook</a> post so I recently <a href="http://twitter.com/#!/djchrisle/status/198795240243601409">asked twitter</a> for requests (DJ Chris Le.. get it?! HAhaha ah h &#8230; ok, nevermind.)  The majority of requests were for social.  No surprise, right?  Well, here they all are! <strong>Let&#8217;s get cooking!</strong></p>
<h2 style="text-align: left;">Preparations</h2>
<p style="padding-left: 20px;">1. You&#8217;ll need a new <a title="Google Docs" href="https://docs.google.com">Google Docs Spreadsheet</a></p>
<p style="padding-left: 20px;">2. In cell A1, type in the URL you want to scrape.</p>
<p style="padding-left: 20px;">3. In any other cell copy-and-paste the recipe.  Press enter.</p>
<p><strong>Noob tip</strong>: Use the example sheets as your starting point.  <strong>Pro tip</strong>: Use these recipes on any existing Google Doc! No code. Made with 100% pure formulas.</p>
<h2>Quora: Followers of a Topic</h2>
<p style="text-align: left;"><img title="Scraping Quora using Google Docs" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-08-at-6.04.05-PM-570x245.png" alt="" width="570" height="245" /><br />
<a href="https://docs.google.com/a/seerinteractive.com/spreadsheet/ccc?key=0Apam75iNJI9idEcwNmxtZnB1VE04akRJcjJ2UERYTXc#gid=0" target="_blank">Try the Quora starter spreadsheet</a></p>
<p class="sub_orange" style="text-align: left;">First up, by request (@dan_shure): Quora! The best way to get this URL is simply to find the topic on Quora, clicking on to followers and then cutting and pasting that URL into A1.</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1:<br />
</strong><code>http://www.quora.com/Search-Engine-Optimization-SEO/followers</code></p>
<p style="padding-left: 20px;"><strong>User&#8217;s name<br />
</strong><code>=ImportXML(A1, "//a[@class='user']")</code></p>
<p style="padding-left: 20px;"><strong>URL to user&#8217;s profile<br />
</strong><code>=ImportXML(A1, "//a[@class='user']/@href")</code></p>
<p style="padding-left: 20px;"><strong>Number of answers<br />
</strong><code>=ImportXML(A1, "//a[contains(@href, 'answers')]")</code></p>
<p style="padding-left: 20px;"><strong>(Pro tip): </strong><strong>To get around Google Doc&#8217;s 50 ImportXML limit</strong> convert cells into values.  First, select a bunch of cells, then hit copy, and then &#8220;paste as values.&#8221;</p>
<p style="padding-left: 20px;">This will permanently record the result into the cell and free up some ImportXMLs for you.  I usually leave one row untouched so that I can use it later to get more data before converting those into data.</p>
<h2>Quora: User Profiles</h2>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.quora.com/Ian-Lurie</code></p>
<p style="padding-left: 20px;"><strong>Photo<br />
</strong><code>=ImportXML(A1, "//meta[@property='og:image']/@content")</code></p>
<p style="padding-left: 20px;"><strong>Name<br />
</strong><code>=ImportXML(A1, "//meta[@property='og:title']/@content")</code></p>
<p style="padding-left: 20px;"><strong>Twitter profile<br />
</strong><code>=ImportXML(A1, "//a[@class='sn_icon' and contains(@href, 'twitter.com')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>Facebook profile<br />
</strong><code>=ImportXML(A1, "//a[@class='sn_icon' and contains(@href, 'facebook.com')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>Self description<br />
</strong><code>=ImportXML(A1, "//meta[@property='og:description']/@content")</code></p>
<p style="padding-left: 20px;"><strong>Canonical URL on Quora<br />
</strong><code>=ImportXML(A1, "//link[@rel='canonical']/@href")</code></p>
<p style="padding-left: 20px;"><strong>RSS feed on Quora<br />
</strong><code>=ImportXML(A1, "//link[@rel='alternate']/@href")</code></p>
<p style="padding-left: 20px;"><strong>Topics<br />
</strong><code>=ImportXML(A1, "//a[@class='topic_name']//span[@class='name_text']/span")</code></p>
<p style="padding-left: 20px;"><strong>Number of followers<br />
</strong><code>=ImportXML(A1, "//a[@class='link_label' and contains(@href, 'followers')]/span")</code></p>
<p style="padding-left: 20px;"><strong>Number of topics<br />
</strong><code>=ImportXML(A1, "//a[@class='link_label' and contains(@href, 'topics')]/span")</code></p>
<p style="padding-left: 20px;"><strong>Number of questions<br />
</strong><code>=ImportXML(A1, "//a[@class='link_label' and contains(@href, 'questions')]/span")</code></p>
<p style="padding-left: 20px;"><strong>Number of answers<br />
</strong><code>=ImportXML(A1, "//a[@class='link_label' and contains(@href, 'answers')]/span")</code></p>
<p style="padding-left: 20px;"><strong>Number of edits<br />
</strong><code>=ImportXML(A1, "//a[@class='link_label' and contains(@href, 'log')]/span")</code></p>
<h2>Quora: User&#8217;s Followers</h2>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.quora.com/Ian-Lurie/followers</code></p>
<p style="padding-left: 20px;"><strong>User&#8217;s name<br />
</strong><code>=ImportXML(A1, "//a[@class='user']")</code></p>
<p style="padding-left: 20px;"><strong>URL to user&#8217;s profile<br />
</strong><code>=ImportXML(A1, "//a[@class='user']/@href")</code></p>
<p style="padding-left: 20px;"><strong>Number of answers<br />
</strong><code>=ImportXML(A1, "//a[contains(@href, 'answers')]")</code></p>
<h2>Reddit</h2>
<p><img class="alignnone size-full wp-image-9999" title="Scraping Reddit using Google Docs" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-08-at-11.23.13-PM.png" alt="" width="529" height="288" /><br />
<a href="https://docs.google.com/spreadsheet/ccc?key=0Apam75iNJI9idDliWDU2dXRJN09DQTQ0VE9JSUZNUFE" target="_blank">Reddit scraper starter spreadsheet</a></p>
<p class="sub_orange">The URL for Reddit is best typed in manually instead of copying what you see in your browser.  Replace &#8220;importxml&#8221; in the URL with your own search term.</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.reddit.com/search?q=importxml&amp;sort=new</code></p>
<p style="padding-left: 20px;"><strong>Title<br />
</strong><code>=ImportXML(A1, "//p[@class='title']/a")</code></p>
<p style="padding-left: 20px;"><strong>URL<br />
</strong><code>=ImportXML(A1, "//p[@class='title']/a/@href")</code></p>
<p style="padding-left: 20px;"><strong>Submitted on (as UTC)<br />
</strong><code>=ImportXML(A1, "//p[@class='title']/../p[@class='tagline']/time/@title")</code></p>
<p style="padding-left: 20px;"><strong>Author URL<br />
</strong><code>=ImportXML(A1, "//p[@class='title']/../p[@class='tagline']/a[@href][1]/@href")</code></p>
<p style="padding-left: 20px;"><strong>Posted to<br />
</strong><code>=ImportXML(A1, "//p[@class='title']/../p[@class='tagline']/a[@href][2]/@href")</code></p>
<h2>Topsy</h2>
<p><img class="alignnone size-large wp-image-10007" title="Topsy Scraper in Google Docs" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-09-at-12.12.26-AM-570x322.png" alt="" width="570" height="322" /><br />
<a href="https://docs.google.com/a/seerinteractive.com/spreadsheet/ccc?key=0Apam75iNJI9idHByeldMX2xPOFhJaVJuSHQzMlBQVlE#gid=0" target="_blank">Topsy scraper starter spreadsheet</a></p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://topsy.com/s?q=importxml</code></p>
<p style="padding-left: 20px;"><strong>Title<br />
</strong><code>=ImportXML(A1, "//h3[@class='title']")</code></p>
<p style="padding-left: 20px;"><strong>URL<br />
</strong><code>=ImportXML(A1, "//h3[@class='title']/a/@href")</code></p>
<p style="padding-left: 20px;"><strong>Tweeted by name<br />
</strong><code>=ImportXML(A1, "//div[@class='author-bar']/a")</code></p>
<p style="padding-left: 20px;"><strong>Tweet<br />
</strong><code>=ImportXML(A1, "//span[contains(@class, 'twitter-post-text')]")</code></p>
<p style="padding-left: 20px;"><strong>Original tweet URL<br />
</strong><code>=ImportXML(A1, "//div[@class='actions']/a[contains(@class, 'date-link')]/@href[1]")</code></p>
<p style="padding-left: 20px;"><strong>Trackback count<br />
</strong><code>=ImportXML(A1, "//div[@class='actions']/a[contains(@class, 'trackback-link')]")</code></p>
<h2>Topsy: Twitter Trackback</h2>
<p><img title="Topsy + Twitter Combo Scrape Report" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-09-at-12.00.30-AM-570x147.png" alt="" width="570" height="147" /><br />
<a href="https://docs.google.com/a/seerinteractive.com/spreadsheet/ccc?key=0Apam75iNJI9idGJTLXlhdWUwMlg2UHp0YkxKdm9JcEE#gid=0" target="_blank">Stats on Influential people who RT&#8217;ed you spreadsheet</a></p>
<p class="sub_orange">This is where the fun really is.  Combine lots of these ImportXML&#8217;s to make some really great spreadsheets.  This was fun. First, find the page you want to get trackbacks on, copy that URL into A1 and get going!</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://topsy.com/www.seerinteractive.com/blog/importxml-cookbook</code></p>
<p style="padding-left: 20px;"><strong>Posts count<br />
</strong><code>=ImportXML(A1, "//div[@class='retweet-button-box']/span[@class='count']")</code></p>
<p style="padding-left: 20px;"><strong>Tags list<br />
</strong><code>=ImportXML(A1, "//ul[@class='tags-list']/li[@class='tag']")</code></p>
<p style="padding-left: 20px;"><strong>Related (influential): twitter name<br />
</strong><code>=ImportXML(A1, "//span[@class='author-bar']/*[contains(text(), 'Influential')]/../a")</code></p>
<p style="padding-left: 20px;"><strong>Related (influential): tweet<br />
</strong><code>=ImportXML(A1, "//span[@class='author-bar']/*[contains(text(), 'Influential')]/../../span[@class='twitter-post-text']")</code></p>
<p style="padding-left: 20px;"><strong>Related (influential): tweet date<br />
</strong><code>=ImportXML(A1, "//span[@class='author-bar']/*[contains(text(), 'Influential')]/../../../div[@class='actions']/a[contains(@class, 'date-link')]")</code></p>
<p style="padding-left: 20px;"><strong>Related (influential): tweet URL<br />
</strong><code>=ImportXML(A1, "//span[@class='author-bar']/*[contains(text(), 'Influential')]/../../../div[@class='actions']/a[contains(@class, 'date-link')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>Related posts: twitter name<br />
</strong><code>=ImportXML(A1, "//div[@class='twitter-post-big']//a[contains(@class, 'author-link')]")</code></p>
<p style="padding-left: 20px;"><strong>Related posts: tweet<br />
</strong><code>=ImportXML(A1, "//div[@class='twitter-post-big']//span[contains(@class, 'twitter-post-text')]")</code></p>
<p style="padding-left: 20px;"><strong>Related posts: tweet date<br />
</strong><code>=ImportXML(A1, "//div[@class='twitter-post-big']//div[contains(@class, 'actions')]/a[contains(@class, 'date-link')]")</code></p>
<p style="padding-left: 20px;"><strong>Related posts: tweet URL<br />
</strong><code>=ImportXML(A1, "//div[@class='twitter-post-big']//div[contains(@class, 'actions')]/a[contains(@class, 'date-link')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>(Pro tip)</strong>: <strong>Interested in <a href="http://www.slideshare.net/wilreynolds/stalking-for-links" target="_blank">stalking people for links</a>? </strong>(Links to slide deck by <a href="http://www.twitter.com/wilreynolds" target="_blank">@wilreynolds</a>)</p>
<p style="padding-left: 20px;">Combine these ones with ImportXMLs from Twitter to devastating effect. Use Google Docs automate your hit list. You can be creepy <em>and</em> efficient!</p>
<h2>LinkedIn: User&#8217;s profile</h2>
<p class="sub_orange">Here are some updates to the original LinkedIn ImportXML formulas from the first ImportXML Cookbook.</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.linkedin.com/in/wilreynolds</code></p>
<p style="padding-left: 20px;"><strong>Current<br />
</strong><code>=ImportXML(A1, "//dd[@class='summary-current']//ul[@class='current']/*")</code></p>
<p style="padding-left: 20px;"><strong>Number of connections<br />
</strong><code>=ImportXML(A1, "//dd[@class='overview-connections']//strong")</code></p>
<p style="padding-left: 20px;"><strong>Profile summary<br />
</strong><code>=ImportXML(A1, "//p[@class=' description summary']")</code></p>
<h2>Twitter</h2>
<p class="sub_orange">Again are some more updates and additions to the original formulas from the first ImportXML Cookbook.</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.twitter.com/djchrisle</code></p>
<p style="padding-left: 20px;"><strong>Bio<br />
</strong><code>=ImportXML(A1, "//span[@class='bio']")</code></p>
<p style="padding-left: 20px;"><strong>Location<br />
</strong><code>=ImportXML(A1, "//span[@class='adr']")</code></p>
<p style="padding-left: 20px;"><strong>Website<br />
</strong><code>=ImportXML(A1, "//a[@class='url' and @rel='me nofollow']/@href")</code></p>
<p style="padding-left: 20px;"><strong>Following<br />
</strong><code>=ImportXML(A1, "//span[@id='following_count']")</code></p>
<p style="padding-left: 20px;"><strong>Following<br />
</strong><code>=ImportXML(A1, "//span[@id='follower_count']")</code></p>
<p style="padding-left: 20px;"><strong>Lists count<br />
</strong><code>=ImportXML(A1, "//span[@id='lists_count']")</code></p>
<p style="padding-left: 20px;"><strong>Number of Tweets<br />
</strong><code>=ImportXML(A1, "//span[@id='update_count']")</code></p>
<p style="padding-left: 20px;"><strong>Randomly selected followed names<br />
</strong><code>=ImportXML(A1, "//div[@id='following_list']/span/a/@title")</code></p>
<p style="padding-left: 20px;"><strong>Randomly selected followed URLs (add http://twitter.com)<br />
</strong><code>=ImportXML(A1, "//div[@id='following_list']/span/a/@href")</code></p>
<p style="padding-left: 20px;"><strong>RSS Feed of tweets<br />
</strong><code>=ImportXML(A1, "//div[@id='rssfeed']/*[contains(@href, 'statuses')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>RSS Feed of favorites<br />
</strong><code>=ImportXML(A1, "//div[@id='rssfeed']/*[contains(@href, 'favorites')]/@href")</code></p>
<p style="padding-left: 20px;"><strong>Tweets (recent)<br />
</strong><code>=ImportXML(A1, "//span[@class='status-body']//span[@class='status-content']")</code></p>
<p style="padding-left: 20px;"><strong>Tweets (timestamp)<br />
</strong><code>=ImportXML(A1, "//span[@class='status-body']//span[@class='published timestamp']/@data")</code></p>
<p style="padding-left: 20px;"><strong>Users recently mentioned in tweets<br />
</strong><code>=ImportXML(A1, "//span[@class='entry-content']/a[@class='tweet-url username']")</code></p>
<h2>Google Insights</h2>
<p><img class="alignnone size-large wp-image-10009" title="Google Insights scraper for Google Docs" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Screen-shot-2012-05-09-at-12.24.25-AM-570x339.png" alt="" width="570" height="339" /><br />
<a href="https://docs.google.com/a/seerinteractive.com/spreadsheet/ccc?key=0Apam75iNJI9idGdHbTdUUDgxSVZGZnQydU5lZ2JBdVE#gid=0" target="_blank">Google Insights scraper starter spreadsheet</a> (say that 3 times fast)</p>
<p class="sub_orange">And the last song for tonight, this one goes out to @dsottimano and @dohertyjf!  Google Insights!</p>
<p style="padding-left: 20px; text-align: left;"><strong>Example URL for cell A1<br />
</strong><code>http://www.google.com/insights/search/overviewReport?q=seo%20company&amp;content=1</code></p>
<p style="padding-left: 20px;"><strong>Headline Trends<br />
</strong><code>=ImportXML(A1, "//td[@class='trends-headline-headline']/a")</code></p>
<p style="padding-left: 20px;"><strong>Headline Trends URLs<br />
</strong><code>=ImportXML(A1, "//td[@class='trends-headline-headline']/a/@href")</code></p>
<p style="padding-left: 20px;"><strong>Rising search terms<br />
</strong><code>=ImportXML(A1, "//div[@id='overviewRisingSearchesDiv']/table/tr[2]//table[@class='trends-table-data']/tr/td[2]/a[1]")</code></p>
<p style="padding-left: 20px;"><strong>Rising search percent<br />
</strong><code>=ImportXML(A1, "//div[@id='overviewRisingSearchesDiv']/table/tr[2]//table[@class='trends-table-data']/tr/td[3]")</code></p>
<p style="padding-left: 20px;"><strong>Top search terms<br />
</strong><code>=ImportXML(A1, "//div[@id='overviewTopSearchesDiv']/table/tr[2]//table[@class='trends-table-data']/tr/td[2]/a[1]")</code></p>
<p>Trivia: The trick to finding this one is that the content is loaded when you specify the query string &#8220;content=1.&#8221;  By turning on &#8220;Log XMLHttpRequests&#8221; in Chrome&#8217;s Inspect Elements window, you can watch JavaScript make AJAX calls and then start figuring out the right URLs to make calls to.</p>
<h3>OMG! Epic! Here&#8217;s more Google Docs insanity from SEER:</h3>
<p><a title="Visualize Your Backlinks with Google Fusion Tables" href="http://www.seerinteractive.com/blog/visualize-your-backlinks-with-google-fusion-tables">Visualize Your Backlinks with Google Fusion Tables</a> (May, 2012)<a title="Google Scraper in Google Docs (Update)" href="http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update"><br />
Google Search Scraper</a> (February, 2012)<br />
<a title="SEOmoz data for Google Docs" href="http://www.seerinteractive.com/blog/seomoz-data-for-google-docs">SEOmoz Data for Google Docs</a> (February, 2012)<br />
<a title="(Not Provided) Report In Google Docs" href="http://www.seerinteractive.com/blog/not-provided-report">(Not Provided) Report in Google Docs</a> (November, 2011)<br />
<a title="ImportXML Cookbook" href="http://www.seerinteractive.com/blog/importxml-cookbook">ImportXML Cookbook 1</a> (September, 2011)</p>
<h3>Want more?</h3>
<p>(Shameless plug) Talk to me on Twitter <a href="http://www.twitter.com/djchrisle" target="_blank">@djchrisle</a>. I take requests and birthday shout-outs :-D</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=OPgyi24FdU4:nOctMc3nMmU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=OPgyi24FdU4:nOctMc3nMmU:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=OPgyi24FdU4:nOctMc3nMmU:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=OPgyi24FdU4:nOctMc3nMmU:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=OPgyi24FdU4:nOctMc3nMmU:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=OPgyi24FdU4:nOctMc3nMmU:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/OPgyi24FdU4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/more-importxml-cookbooks/feed</wfw:commentRss>
		<slash:comments>6</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/more-importxml-cookbooks?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=more-importxml-cookbooks</feedburner:origLink></item>
		<item>
		<title>“Did You Google It?” A Search Church SEO Event Announcement!</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/eWUdokjL-EQ/did-you-google-it-a-search-church-seo-event-announcement</link>
		<comments>http://www.seerinteractive.com/blog/did-you-google-it-a-search-church-seo-event-announcement#comments</comments>
		<pubDate>Tue, 08 May 2012 21:17:10 +0000</pubDate>
		<dc:creator>Melissa Alam</dc:creator>
				<category><![CDATA[google]]></category>
		<category><![CDATA[SEO]]></category>
		<category><![CDATA[event]]></category>
		<category><![CDATA[search church]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9901</guid>
		<description><![CDATA[With so many SEOs buzzing about our upcoming SEOMoz Meetup happening THIS Thursday, we thought now would be the perfect time to let everyone know about our NEXT planned Search Church event called &#8220;Did You Google It?&#8221; Here are some of the quick details for you! When – June 22, 2012 Where – The Search [...]]]></description>
			<content:encoded><![CDATA[<p style="text-align: center;"><strong><strong>With so many SEOs buzzing about our upcoming <a href="http://www.seomoz.org/blog/meetup-at-the-search-church">SEOMoz Meetup</a> happening THIS Thursday, we thought now would be the perfect time to let everyone know about our NEXT planned Search Church event called &#8220;Did You Google It?&#8221;</strong></strong></p>
<p style="text-align: center;"><a href="http://www.seerinteractive.com/blog/did-you-google-it-a-search-church-seo-event-announcement/didyougoogleit" rel="attachment wp-att-9905"><img class="aligncenter size-medium wp-image-9905" title="didyougoogleit" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/didyougoogleit-300x399.png" alt="" width="300" height="399" /></a></p>
<p style="text-align: center;"><strong><strong>Here are some of the quick details for you!<br />
<span style="text-decoration: underline;">When</span> – </strong></strong>June 22, 2012<strong><strong><br />
<span style="text-decoration: underline;">Where</span> – </strong></strong>The Search Church (1028 N. 3rd Street, Philadelphia, PA)<strong><strong><br />
<span style="text-decoration: underline;">Price</span> – </strong></strong>FREE! (but donations are accepted)</p>
<div class="mceTemp mceIEcenter" style="text-align: center;">
<dl id="attachment_9927" class="wp-caption aligncenter" style="width: 521px;">
<dt class="wp-caption-dt"><a href="http://www.seerinteractive.com/blog/did-you-google-it-a-search-church-seo-event-announcement/presenters" rel="attachment wp-att-9927"><img class="size-full wp-image-9927" title="presenters" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/presenters.png" alt="" width="511" height="127" /></a></dt>
<dd class="wp-caption-dd">Our awesome presenters!</dd>
</dl>
</div>
<p style="text-align: left;"><strong><strong><br />
</strong></strong>The event will feature speakers including Distilled’s Tom Critchlow (<a href="https://twitter.com/#!/tomcritchlow">@tomcritchlow</a>), iAcquire’s Mike King (<a href="https://twitter.com/#!/iPullRank">@iPullRank</a>) and SEER’s own Wil Reynolds (<a href="https://twitter.com/#!/wilreynolds">@wilreynolds</a>) and Ethan Lyon (<a href="https://twitter.com/#!/ethanlyon">@ethanlyon</a>). In typical SEER fashion, this isn’t just an SEO conference. This is also an opportunity to give back to the community and help out an awesome cause!</p>
<p style="text-align: left;">All of the speakers listed above will demonstrate how to rank for a specific charity or non-profit’s top keyword, focusing on different methods and linking strategies that they&#8217;ve acquired from over the years. SEER’s own Google Doc wizard Ethan will also be presenting a super new tool that he’s created specifically for keyword ranking! This is definitely an event you <span style="text-decoration: underline;">do not</span> want to miss.</p>
<p style="text-align: left;">So, who’s the lucky non-profit organization we&#8217;ll be teaming with?</p>
<p style="text-align: left;">You tell us! Fill out the form below (or <a href="https://docs.google.com/a/seerinteractive.com/spreadsheet/viewform?formkey=dEZNVmNBUmdiZ0U5SHFXYWR4LVRmN3c6MQ#gid=0">click here</a>) to submit your charity or non-profit for consideration. We’ll host a contest on SEER’s Facebook Page afterwards with all of the recipients, and whichever non-profit receives the most Likes on their logo in our Facebook contest will win the following:</p>
<ul>
<li><strong>The focus of each individual presentation at the Did You Google It? Search Church event!</strong></li>
<li><strong>A <span style="text-decoration: underline;">FREE</span> SEO consultation by our team of experts to analyze how to increase traffic and conversions for your website, along with different top SEO industry applications and programs worth over $20,000! </strong></li>
<li><strong>All cash donations from the event! The Search Church will be going back to its roots of helping the community and donating to charities by accepting donations throughout the event. All proceeds we fundraise will go directly to the winning non-profit organization.</strong></li>
</ul>
<p><iframe src="https://docs.google.com/spreadsheet/embeddedform?formkey=dEZNVmNBUmdiZ0U5SHFXYWR4LVRmN3c6MQ" frameborder="0" marginwidth="0" marginheight="0" width="760" height="1653"></iframe></p>
<p style="text-align: center;"><strong id="internal-source-marker_0.8472644516732544">We’re looking forward to hosting another awesome SEO meetup here at our Search Church and learning about keyword ranking strategies from some of the most influential SEOs in the country, and we hope you are too! Please spread the word about our search to find great a non-profit organization to focus our event around and get ready for June 22nd&#8217;s &#8220;Did You Google It Event!&#8221; <em>For any questions, please email me at melissaa@seerinteractive.com.</em></strong></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=eWUdokjL-EQ:Obp2jf3X_5E:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=eWUdokjL-EQ:Obp2jf3X_5E:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=eWUdokjL-EQ:Obp2jf3X_5E:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=eWUdokjL-EQ:Obp2jf3X_5E:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=eWUdokjL-EQ:Obp2jf3X_5E:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=eWUdokjL-EQ:Obp2jf3X_5E:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/eWUdokjL-EQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/did-you-google-it-a-search-church-seo-event-announcement/feed</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/did-you-google-it-a-search-church-seo-event-announcement?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=did-you-google-it-a-search-church-seo-event-announcement</feedburner:origLink></item>
		<item>
		<title>Visualize Your Backlinks with Google Fusion Tables</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/pLVi1X88imw/visualize-your-backlinks-with-google-fusion-tables</link>
		<comments>http://www.seerinteractive.com/blog/visualize-your-backlinks-with-google-fusion-tables#comments</comments>
		<pubDate>Mon, 07 May 2012 15:02:12 +0000</pubDate>
		<dc:creator>Mark Cianfrani</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9843</guid>
		<description><![CDATA[Data can be boring. I’m sorry, but it’s true. Don’t get me wrong, I love a good spreadsheet as much as I love a good novel, but whenever I can get away with it, I’d much rather just see the movie. Visualization and presentation have never been more important then they are today. The amount [...]]]></description>
			<content:encoded><![CDATA[<p>Data can be boring. I’m sorry, but it’s true. Don’t get me wrong, I love a good spreadsheet as much as I love a good novel, but whenever I can get away with it, I’d much rather just see the movie.</p>
<p>Visualization and presentation have never been more important then they are today. The amount of data that we collect, process, and analyze is overwhelming. Have you ever peeked into the backlink profile for a domain that has over a million links? Can you even imagine what a million links looks like? I can’t. Luckily, we’ve come a long way in terms of visualization since the invention of the pie chart.</p>
<h3>Introducing . . . Fusion Tables.</h3>
<p>In typical Google fashion, Google quietly rolled out a brand new “<a href="http://googleresearch.blogspot.com/2012/04/working-with-your-data-easier-and-more.html">Experimental</a>” version of their Fusion Table application a few weeks ago. If you haven’t had the chance (or reason) to play with Fusion Tables yet, the time has come. Consider it Google Spreadsheets on steroids, or Google’s answer to “big data.” I’ll be writing a lot more on how to harness the power of Fusion Tables to create massive databases, but for now, I just want to focus on one incredibly awesome feature&#8211;the Network Graph.</p>
<div id="attachment_9845" class="wp-caption alignnone" style="width: 580px"><a href="http://www.seerinteractive.com/wp-content/uploads/2012/05/15000-Links.png"><img class="size-large wp-image-9845 " title="15000 Links" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/15000-Links-570x204.png" alt="1500 Links" width="570" height="204" /></a><p class="wp-caption-text">This is what 15,000 links looks like</p></div>
<p>Who said that competitor backlink research couldn’t be fun? Aside from hosting enormous amounts of data, Fusion Tables can also visualize the connections between your data in a simple, interactive map. This new Network Graph feature takes seconds to set up and can have many different applications.</p>
<p><strong>You can view the completed Network Graph and Fusion Table <a href="https://www.google.com/fusiontables/DataSource?snapid=S4846046-uk" target="_blank">here</a>. </strong></p>
<p>Want to SEE who is linking to you? Here’s how:</p>
<h4>1. Gather your data</h4>
<p>For this experiment, I gathered the backlink profiles for four companies in the SEO industry, SEER Interactive, Distilled, SEOMoz, and Zamolution (who rank #1 for “Philadelphia SEO Company”). What I wanted to see is how are these four sites connected? I pulled all of this data using SEOMoz’s ever-so-helpful Open Site Explorer. You can gather your data any way you choose.</p>
<h4>2. Clean up your data.</h4>
<p>If you’re pulling a lot data from a lot different places, you might want to clean it up. Fusion Tables will actually do this for you and you can even merge tables and aggregate data via the web interface, however, it is still “experimental” and there are still some bugs so I prefer to have everything in one pretty .csv.</p>
<h4>3. Create a new Fusion Table</h4>
<p>Head on over to Google Docs / Google Drive / Whatever We’re Supposed To Call It Now and Create &gt; New Table.</p>
<p><img class="alignnone size-full wp-image-9846" title="CreateNewFusionTable" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/CreateNewFusionTable.png" alt="Create a New Fusion Table" width="454" height="294" /></p>
<p>(If there’s no option for Table, try logging in with a non-Google Apps account)</p>
<p>From there, it’s pretty straight forward. You can either upload a CSV, use an existing Google Spreadsheet or create an empty table.</p>
<p>After you’re done uploading, you can choose which columns you want to import.</p>
<h4>4. Create a Network Graph</h4>
<p>Once you have your massive table of data, you can create your Network graph under Experiment &gt; Network Graph</p>
<p><a href="http://www.seerinteractive.com/wp-content/uploads/2012/05/CreateNetworkGraph.png"><img class="alignnone size-large wp-image-9847" title="CreateNetworkGraph" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/CreateNetworkGraph-570x74.png" alt="Create Network Graph" width="570" height="74" /></a></p>
<p>Set Vertex 1 to URL and Vertex 2 to Target URL and weigh by Number of Links<img class="alignnone size-full wp-image-9849" title="SetVertex" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/SetVertex.png" alt="Set Vertex" width="345" height="131" /><img class="size-full wp-image-9850 alignnone" title="SetNodes" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/SetNodes.png" alt="Set Nodes" width="110" height="147" /></p>
<p>BOOM. That’s it. Now the fun begins.</p>
<p>As you increase the number of nodes shown, more and more blue links begin to appear. At around 2,000 nodes, it’ll start to become unresponsive. You can also use the Filter feature and filter out all links that have a Page Authority lower than 30.</p>
<h3>Analyze This</h3>
<p><a href="http://www.seerinteractive.com/wp-content/uploads/2012/05/BacklinkAnalysis.png"><img class="alignnone size-large wp-image-9851" title="BacklinkAnalysis" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/BacklinkAnalysis-570x274.png" alt="Backlink Analysis" width="570" height="274" /></a></p>
<p>So what does this tell us (other than that SEOMoz = the Death Star)? Well, for starters, if I were an SEO company, I’d want to make sure I was getting a piece of this pie. This visualization gives us a very clear picture on where we’re getting our links from.</p>
<p>Need help identifying a link network?  Here’s your tool. Want to find out who the Death Star is in your industry? Here’s your tool.</p>
<h3>Social Media<a href="http://www.seerinteractive.com/wp-content/uploads/2012/05/Social.png"><img class="alignnone size-large wp-image-9852" title="SEO Twitter Graph" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/Social-570x229.png" alt="Graph of SEO Influencers on Twitter" width="570" height="229" /></a></h3>
<p>If you’re like me, you probably thought that this kind of Network Graph visualization would be great for visualizing social media data. It is. Here I pulled some Twitter data from some of the big names in the SEO industry to see who is following who.</p>
<h3>A Few Things To Consider</h3>
<p>This is barely scratching the surface of what Fusion Tables can do. Since this is “Experimental” also don’t expect things to run smoothly. This feature could also disappear over night (although I hope it doesn&#8217;t). Believe me, there is A LOT more that can be done with Fusion Tables and this is a great push by Google to help make data less intimidating.</p>
<p>Furthermore, I&#8217;m very interested to hear your ideas. How will you use Fusion Tables? What other tools do you use for quick visualizations?</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=pLVi1X88imw:TZyTRkjwk0g:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=pLVi1X88imw:TZyTRkjwk0g:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=pLVi1X88imw:TZyTRkjwk0g:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=pLVi1X88imw:TZyTRkjwk0g:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=pLVi1X88imw:TZyTRkjwk0g:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=pLVi1X88imw:TZyTRkjwk0g:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/pLVi1X88imw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/visualize-your-backlinks-with-google-fusion-tables/feed</wfw:commentRss>
		<slash:comments>11</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/visualize-your-backlinks-with-google-fusion-tables?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=visualize-your-backlinks-with-google-fusion-tables</feedburner:origLink></item>
		<item>
		<title>New Ad Group Ideas (Beta) Improves Keyword Research</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/G42w1owJPR0/new-ad-group-ideas-beta-improves-keyword-research</link>
		<comments>http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research#comments</comments>
		<pubDate>Wed, 02 May 2012 13:14:42 +0000</pubDate>
		<dc:creator>laurenf</dc:creator>
				<category><![CDATA[PPC]]></category>
		<category><![CDATA[tools]]></category>
		<category><![CDATA[AdWords]]></category>
		<category><![CDATA[keyword research]]></category>
		<category><![CDATA[ppc tools]]></category>
		<category><![CDATA[SEM]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9690</guid>
		<description><![CDATA[AdWords finally announced a new gem of a beta, which I accidentally stumbled upon a few weeks ago while completing some keyword research. The Ad Group Ideas beta, which can be found in AdWords&#8217; Keyword Tool, groups suggested keyword ideas into similar ad group themes. This makes the keyword research process a bit quicker and [...]]]></description>
			<content:encoded><![CDATA[<p>AdWords finally <a href="http://adwords.blogspot.com/2012/04/making-campaign-planning-and-build-out.html">announced</a> a new gem of a beta, which I accidentally stumbled upon a few weeks ago while completing some keyword research. The Ad Group Ideas beta, which can be found in AdWords&#8217; Keyword Tool, groups suggested keyword ideas into similar ad group themes. This makes the keyword research process a bit quicker and easier. In the Keyword Tool from the Tools and Analysis tab, AdWords now defaults to the beta tab.<br />
<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta1-5" rel="attachment wp-att-9707">
<p style="text-align: center"><img class="alignnone size-large wp-image-9707" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta14-570x301.png" alt="" width="570" height="301" /></a></p>
<p>It&#8217;s probably not a smart idea to run with these suggestions as they&#8217;re presented – as with many of Google&#8217;s suggestions in AdWords, they may not always be fully applicable to your exact needs. However, it <em>is</em> a great way to help sort the keyword suggestions you are given.  Whether you&#8217;re just getting your feet off the ground or looking for expansion ideas, this beta has a lot of potential to help!</p>
<p>You can use this tool to build new campaigns and ad groups within an existing account or create a new account build from scratch. I, personally, have found this beta valuable in weeding out themes unrelated to the keyword research I was completing, themes which I would want to exclude from my campaigns. Additionally, you can use this beta to better zoom in on keywords that are more related to your clients&#8217; initiatives. For example, I was able to easily weed out all keywords relating to online and free sales, as these themes do not closely align with my clients&#8217; goals.<br />
<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta2-3" rel="attachment wp-att-9712">
<p style="text-align: center"><img class="alignnone size-large wp-image-9712" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta22-570x387.png" alt="" width="570" height="387" /></a></p>
<h2>A few quick notes about some cool features:</h2>
<ul>
<li>Clicking on the plus sign to the left of each theme to expand the section and get more similar keywords.<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta3-3" rel="attachment wp-att-9698">
<p style="text-align: center"><img class="alignnone size-full wp-image-9698" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta32.png" alt="" width="532" height="38" /></a></li>
<li>Selecting the Save all button will select all keywords in that ad group theme.<br />
<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta4" rel="attachment wp-att-9697">
<p style="text-align: center"><img class="alignnone size-full wp-image-9697" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta4.png" alt="" width="228" height="208" /></a></p>
<li>Selecting the drop down arrow to the right of each specific keyword will give you additional options including performing a Google search and going to Google Insights for Search.<br />
<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta5" rel="attachment wp-att-9699">
<p style="text-align: center"><img class="alignnone size-full wp-image-9699" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta5.png" alt="" width="269" height="228" /></a></li>
<li>To exclude a particular ad group theme that you have already selected, you can remove it by clicking the x next to the respective ad group theme idea in the bottom left Save Ideas box.<br />
<a href="http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/beta6" rel="attachment wp-att-9700">
<p style="text-align: center"><img class="alignnone size-full wp-image-9700 aligncenter" src="http://www.seerinteractive.com/wp-content/uploads/2012/05/beta6.png" alt="" width="233" height="155" /></a></li>
<li>You&#8217;ll see in the image above that there is an option to &#8220;View in Traffic Estimator.&#8221; If you click on that link, the Traffic Estimator will open in a new window with your selected keywords already plugged into the tool. You&#8217;ll just have to enter your Max CPC and/or Daily Budget. There is also the option to change the metric of the y axis to clicks, impressions or cost.</li>
</ul>
<p>What do you think about this Ad Group Ideas beta? Have you already seen this beta? How have you been using it? What do you like and dislike about it? Share your comments and be sure to check out Chris&#8217; latest <a href="http://www.seerinteractive.com/blog/using-tagcrowd-to-grow-your-ppc-account">blog</a> for other keyword research ideas!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=G42w1owJPR0:3VBEvKcsjL4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=G42w1owJPR0:3VBEvKcsjL4:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=G42w1owJPR0:3VBEvKcsjL4:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=G42w1owJPR0:3VBEvKcsjL4:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=G42w1owJPR0:3VBEvKcsjL4:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=G42w1owJPR0:3VBEvKcsjL4:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/G42w1owJPR0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research/feed</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/new-ad-group-ideas-beta-improves-keyword-research?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=new-ad-group-ideas-beta-improves-keyword-research</feedburner:origLink></item>
		<item>
		<title>Worst Change in AdWords History?</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/5vPQCro1PWM/worst-change-in-adwords-history</link>
		<comments>http://www.seerinteractive.com/blog/worst-change-in-adwords-history#comments</comments>
		<pubDate>Mon, 30 Apr 2012 22:14:37 +0000</pubDate>
		<dc:creator>Crystal Anderson</dc:creator>
				<category><![CDATA[PPC]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9615</guid>
		<description><![CDATA[Thanks AdWords for fast tracking today into the worst possible case of the Mondays. Don’t believe me? Check out #ppcchat on Twitter. So, what is all the fuss about? Today AdWords has decided that they know what is best when it comes to Advertisers &#038; ad testing by making a change to Ad Settings &#8230; [...]]]></description>
			<content:encoded><![CDATA[<p>Thanks AdWords for fast tracking today into the worst possible case of the Mondays.</p>
<p style="text-align: center;"><img src="https://seerinteractive.box.com/shared/static/e23840b88a4514f14d62.jpg" alt="" /></p>
<p><strong>Don’t believe me? Check out <a href="https://twitter.com/#!/search/realtime/%23ppcchat" target="_blank">#ppcchat</a> on Twitter. </strong></p>
<p><strong>So, what is all the fuss about? </strong></p>
<h2>Today AdWords has decided that they know what is best when it comes to Advertisers &#038; ad testing by making a change to Ad Settings &#8230;</p>
<p>Introducing “Near Rotation”</h2>
<p>You can read the full announcement <a href="http://adwords.blogspot.com/2012/04/new-changes-to-ad-rotation.html" target="_blank">here</a></p>
<p><strong>To highlight the important part of this change:</strong><br />
<em>Starting next week, the “rotate” setting for ad rotation will change.  Instead of rotating creatives for an indefinite period of time, this setting will only rotate for a period of 30 days.  After that, the setting will then optimize to show the ads expected to generate the most clicks.  Every time a creative is enabled or edited, the ads in that ad group will rotate more evenly for a new period of 30 days.  This change will be rolling out next week. At that time, ad groups with creatives that haven’t been added or modified in the past thirty days will see this new ad rotation behavior. Otherwise, this change will begin 30 days after your last creative was enabled or edited.</em></p>
<h2><strong>Yowzah.</strong></h2>
<p>Anyone who is a savvy PPC professional is pulling their hair out now &#8230; if Google had ears, they would be ringing!</p>
<p>Before we drill into why everyone is up in arms, some background on the Rotate ad setting&#8230;</p>
<p>The Rotate setting allows for true A/B testing, meaning that each ad serves (fairly) equally in order to accurately compare results and find the optimal ad text.  This is a setting AdWords has blatantly advised against:</p>
<p><img src="https://seerinteractive.box.com/shared/static/4dae7537ba5519a9de8b.jpg" alt="" /></p>
<p>The <strong>interesting </strong>part is that Rotate is by far the preferred ad rotation setting for savvy PPC professionals. Hence, the outrage from #ppcchat members on Twitter.</p>
<p>This setting is absolutely critical for accurate ad testing.  So much so that it’s been a request for adCenter for years (See <a href="http://www.webranking.com/blog/sem-wish-list#Microsoft_adCenter" target="_blank">Wishlist here</a>) and recently has been added to the roadmap.  </p>
<h2><strong>Bravo adCenter, you are killing AdWords on this one!</strong></h2>
<p style="text-align: center;"><img src="https://seerinteractive.box.com/shared/static/28f4167b5a9d403cd2dc.png" alt="" /></p>
<p><strong>Let’s dive into why this may be the worst change, potentially EVER, in AdWords history!</strong></p>
<p>1. This change automatically takes place NEXT WEEK! Goodbye to-do list…..</p>
<p>2. This new setting is focused on one thing only – Clicks!  Since when do clicks equate to conversions?  Call me crazy, but if I wanted to optimize for clicks, I’d use the ‘Optimize for Clicks’ setting!</p>
<p>3. 30 days is not always enough time for ad testing! Especially for campaigns that are lower volume.</p>
<p>4. This is replacing equal rotation, not in addition to, with no way to avoid this.</p>
<p>5. Obviously since this is focused on finding the ad to generate the most clicks, it’s critical to note that this also doesn’t take into consideration any offline conversions, such as phone calls that may be WHY clicks are less but the ad converts better.</p>
<p>6. All of the <a href="http://support.google.com/adwords/bin/answer.py?hl=en&#038;answer=2404248#ad-rotation" target="_blank">Ad Rotation settings </a>lead you to optimize for clicks to some degree:<br />
Near Rotation &#8211; After 30 days optimizes for clicks<br />
Optimize for clicks &#8211; Optimizes for clicks<br />
Optimize for conversions &#8211; If there isn&#8217;t enough data for conversions, optimizes for clicks</p>
<p><strong>While this is becoming known as the “Evil Setting” and “Worst Change Ever” in the PPC World, I always like to step back and think about the positives this could bring. </strong></p>
<p>It was like pulling teeth to come up with this, but I think I found some.</p>
<p style="text-align: center;"><img src="https://seerinteractive.box.com/shared/static/4987d1a2cfc567efb68b.jpg" alt="" /></p>
<p>First, to a <em>small </em>degree I can see where Google is coming from in regard to <em>&#8220;This change will enable us to provide users with the most relevant ad experience and should help advertisers improve the performance of their AdWords accounts.&#8221;</em>  </p>
<p>In theory, if an ad is generating more clicks, it&#8217;s likely it has a higher CTR, which plays a significant role in <a href="http://support.google.com/adwords/bin/answer.py?hl=en&#038;answer=2454010" target="_blank">Quality Score</a>.  </p>
<p>However, puting that aside, back to my point above &#8211; clicks do not equal conversions/sales for my clients. And neither does a perfect Quality Score.  If they did, my job would be easy peasy!</p>
<p>For advertisers who currently don’t review ad tests, first, shame on you. Second, this may force you to review your ad tests!</p>
<p>And of course, for Google, the one everyone is thinking&#8230;. more clicks = more money!</p>
<p style="text-align: center;"><img src="https://seerinteractive.box.com/shared/static/30aa3634da432c6c3c55.jpg" alt="" /></p>
<p>Come&#8217;on&#8230;had to put that in there, especially as it falls so timely after Q4 reported CPC drops (Read more on CPC decreases:<a href="http://www.forbes.com/sites/tomiogeron/2012/01/19/googles-big-cost-per-click-question-earnings-call/" target="_blank">Forbes article</a> <a href="http://www.clickz.com/clickz/column/2143667/solving-mystery-googles-q4-cpc-drop" target="_blank">ClickZ article</a>)</p>
<h2>
<p style="text-align: center;"><strong>The big question now is how do you prepare for this change?</strong></p>
</h2>
<p>1. Take a deep breath.</p>
<p>2. Put on some good tunes. </p>
<p>3. Inform your clients of the change, what you expect as a result, solutions for how you plan to address the change.</p>
<p>4. Review each individual account to determine what the best action steps are. </p>
<p>For example maybe you should:<br />
  • Review current ad tests &#038; launch new tests. (Tip: set a milestone to review those tests at 25 days so you can launch a new one before Google optimizes for the one getting more clicks)</p>
<p>  •  If you Review current tests &#038; haven’t found a winner, consider using <a href="http://www.google.com/ads/innovations/ace.html" target="_blank">ACE</a> to split test your ads. (Note: remember that ACE has a maximum time frame for tests  at 90 days. Set a reminder to check results!)</p>
<p> •  Review optimal ad settings – Will some accounts now fair better on Optimize for conversions <em>(again, remember if there isn&#8217;t enough conversion data it optimizes for clicks)</em>, Optimize for clicks?</p>
<p>5. Be prepared with a bank of new ads to test!</p>
<p><strong><br />
<h2>This is causing quite the upset in the PPC world and it was announced just a few hours ago. Leave your comments/thoughts/suggestions on the change and how you plan to handle ad testing moving forward. </em></h2>
<p>AdWords &#8211; would love to hear from you as well! Help us understand how this will still allow for strategic ad testing!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5vPQCro1PWM:iI65YeJ0RPw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5vPQCro1PWM:iI65YeJ0RPw:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=5vPQCro1PWM:iI65YeJ0RPw:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5vPQCro1PWM:iI65YeJ0RPw:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=5vPQCro1PWM:iI65YeJ0RPw:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5vPQCro1PWM:iI65YeJ0RPw:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/5vPQCro1PWM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/worst-change-in-adwords-history/feed</wfw:commentRss>
		<slash:comments>19</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/worst-change-in-adwords-history?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=worst-change-in-adwords-history</feedburner:origLink></item>
		<item>
		<title>Are You Gambling OR Investing Your SEO Dollars?</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/5-nSfshOfFA/are-you-gambling-or-investing-your-seo-dollars</link>
		<comments>http://www.seerinteractive.com/blog/are-you-gambling-or-investing-your-seo-dollars#comments</comments>
		<pubDate>Thu, 26 Apr 2012 14:00:33 +0000</pubDate>
		<dc:creator>benb</dc:creator>
				<category><![CDATA[google]]></category>
		<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9561</guid>
		<description><![CDATA[Business owners are constantly making decisions to improve their companies, and many are realizing that being at the top of search results is important. This is why hiring a Search Engine Optimization (SEO ) firm is an increasingly important step for successful businesses. Since businesses rationalize budgets based off of Return On Investment (ROI), this article will show that NOT [...]]]></description>
			<content:encoded><![CDATA[<p>Business owners are constantly making decisions to improve their companies, and many are realizing that being at the top of search results is important. This is why hiring a Search Engine Optimization (SEO ) firm is an increasingly important step for successful businesses. Since businesses rationalize budgets based off of Return On Investment (ROI), this article will show that NOT all SEO strategies are the same. Typically most SEO strategies can be divided into two categories. Those that use their clients budget to  gamble with Google or those that use it to actually invest in the company.</p>
<p>&nbsp;</p>
<h2>Gambling With Google</h2>
<p style="text-align: center;"><a href="http://www.seerinteractive.com/blog/are-you-gambling-or-investing-your-seo-dollars/google-poker-300x298" rel="attachment wp-att-9578"><img class="aligncenter size-full wp-image-9578" title="Gambling With Google" src="http://www.seerinteractive.com/wp-content/uploads/2012/04/google-poker-300x298.jpeg" alt="" width="300" height="298" /></a></p>
<p style="text-align: center;"><a href="http://www.bighitmedia.co.uk/poker-seo-white-hat-seo-play-chicken/" rel="nofollow">[ Image Source]</a></p>
<p>Growing up near Las Vegas, I would constantly see tourists who would go to the famous Vegas strip for the rush and thrill of trying to outsmart and outplay the casinos. There is a similar breed of these people in the SEO industry that are gambling their client&#8217;s SEO dollars by trying to outsmart and beat Googles ranking algorithms in order to win big results of  top rankings on the Search Engine Results Page (SERP). I&#8217;m not saying that these tactics never work, but as you&#8217;ll see with the following examples that these gambling tactics are becoming less and less effective.</p>
<h3><strong>Examples of Gambling With Google Tactics:</strong></h3>
<p><strong>Keyword Stuffing -</strong> Excessively using your keywords in every part of your webpage. In the early days people would stuff the sides of their website with &#8220;Keyword&#8221; over and over and then change the words to match the background. What does the user see? A background. What did Google spiders see? A page that must be very relevant to &#8220;keyword&#8221; because it was listed a thousand times. Google has long since changed their algorithm to ignore such deception.</p>
<p><strong>Buying exact match domains -</strong> This was a really popular tactic in 2010 where people would buy exact match domains, which were ranking well, and then have them redirect to their site. Google has begun devaluing the strength of a site solely on having an exact match domain.</p>
<p><strong>Misspelled Words - </strong>This is when people create pages optimized for the misspelling of common words. Try <a href="https://www.google.com/search?sourceid=8&amp;q=weeding+dresses" rel="nofollow" class="broken_link">Googling Weeding Dresses</a>. Notice that Google now autocorrects and gives you &#8220;Wedding Dresses&#8221; but if you click on &#8220;search instead for weeding dresses&#8221; you&#8217;ll find pages of now useless pages optimized for &#8220;Weeding Dresses&#8221;, like this <a href="http://www.lightweddingdresses.com/popular/weeding-dresses/" rel="nofollow">website</a>.</p>
<p><strong>Content Spinning -</strong> This is when people create crappy content and then change words with synonyms to make them &#8220;unique&#8221; so they can submit them dozens of times to different sites for links. This doesn&#8217;t add any value but rather floods the internet with more crap.</p>
<p><strong>Linking Networks-</strong> Along the same lines of content spinning, some SEO&#8217;s will even go so far as to spin sites, which means they basically duplicate their site over and over and then link them to each other to make them seem more powerful.  A lot of sites have been hurt by this lately because of Googles algorithm changes that have been devaluing link networks, which was the backbone of a lot of these sites link profiles.</p>
<h3><strong> Why I Don&#8217;t Gamble With Google</strong></h3>
<ul>
<li><strong><strong>No Value</strong> - </strong>Walking around Las Vegas with a royal flush in my pocket is worthless. Likewise a lot of these tactics are designed to only fool Google into thinking that you have the best hand.  These strategies really are just trying to bluff Google and are adding no value to the thing that powers Google, the user experience.</li>
<li><strong>Bust at any moment</strong> - You can definitely play the game for a few hands, but the Casino always wins. The same is true for Google: eventually they catch onto the tricks you&#8217;re using to surge your ranking. Then  Google penalizes your site and change their algorithm so it doesn&#8217;t happen again.</li>
<li><strong>Always have to play -</strong> Since your SEO gambling strategy is not adding value to the user and is in constant threat of being busted by Googles algorithm you always have to be playing this game to try and stay ahead.  Which means putting more time and money into a strategy that eventually will become worthless.</li>
</ul>
<h2>Investing In Your Company</h2>
<p>Successful companies make sure to always invest a part of their profits back into itself to make sure that it can continue to be successful.  This is the other style of SEO strategy, where  the focus is on building up content and assets that add value to the site for the user.</p>
<p style="text-align: center;"><a href="http://www.seerinteractive.com/blog/are-you-gambling-or-investing-your-seo-dollars/investment-tips" rel="nofollow"><img class="aligncenter size-medium wp-image-9579" title="Investing In Your Company SEO" src="http://www.seerinteractive.com/wp-content/uploads/2012/04/investment-tips-300x300.jpg" alt="Investing In Your Company SEO" width="300" height="300" /></a></p>
<p style="text-align: center;"><a href="http://www.cadinvestor.com/services/" rel="nofollow">[ Image Source ]</a></p>
<div>
<h3><strong>Examples Of Investment SEO Tactics:</strong></h3>
</div>
<p><strong>Helpful Resources</strong> - FAQ pages, industry glossary, and blog posts are great resources that can gain traffic from searchers with long search phrases or specific questions. EX: SEOmoz keeps a running list of all the <a href="http://www.seomoz.org/google-algorithm-change" rel="nofollow">Google Algorithm changes</a> and has over 10,000 links to it from 270 different domains.</p>
<p><strong>Tools</strong> - Providing tools that make your customer lives easier will keep them coming back again and again to the site. EX: A  <a href="http://www.mortgagecalculator.org/" rel="nofollow">mortgage calculator</a> which has over 22,000 links from 2,200 different domains.</p>
<p><strong>How To and Tutorials</strong> - Educating your clients especially in a well done video or infographic  builds trust with your clients and tends to get links from others who find the information helpful. EX:  Article simply shows the <a href="http://www.wordstream.com/articles/most-expensive-keywords" rel="nofollow">20 most expensive keywords in Adwords</a> and has received 1,160 links from over 350 domains.</p>
<h3><strong>Why I Invest In the Company</strong></h3>
<ul>
<li><strong>Strong Foundation</strong> - These type of strategies won&#8217;t instantly rank your site but they also will not get penalized.  They set the foundation of a strong link profile for your site to build on.</li>
<li><strong>Gain new investors</strong> - I know that I keep saying to &#8220;adds value&#8221;, but the reason is because if you create assets that add value then you will attract people who will want to share, write, and report about your site.  This attention ultimately starts driving traffic to your site from sources other than search engines. An example of this is the coverage that the <a href="https://www.google.com/search?sourceid=chrome&amp;ie=UTF-8&amp;q=dollar+shave+club+commercial" rel="nofollow" class="broken_link">Dollar Shave Commercial</a> received from many authoritative sites.</li>
<li><strong>Can sleep easy at night</strong> - Building valuable assets that drive increased search, referral, and direct traffic that won&#8217;t get penalized by Google allows you to not worry about your rankings and focus on other parts of your business.</li>
</ul>
<div></div>
<h3><strong>Final Word</strong></h3>
<p>I know that this is not a perfect analogy, but the bottom line is that the focus of a SEO strategy should be producing something of value to your customer that in turn generates valuable links and rankings for them. If you&#8217;re wondering if your strategies are gambling with Google or investing in your company, ask yourself some of these questions and you&#8217;ll start to  see where you are.</p>
<p>Does this strategy build any value to my site?</p>
<p>Would someone in the industry find this helpful? Would they link to it?</p>
<p>Would Google penalize this?</p>
<h3>Your Thoughts?</h3>
<p>Always look forward to hearing your thoughts and comments, so please share.</p>
<p>&nbsp;</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5-nSfshOfFA:pQDY8_1UUBE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5-nSfshOfFA:pQDY8_1UUBE:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=5-nSfshOfFA:pQDY8_1UUBE:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5-nSfshOfFA:pQDY8_1UUBE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=5-nSfshOfFA:pQDY8_1UUBE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=5-nSfshOfFA:pQDY8_1UUBE:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/5-nSfshOfFA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/are-you-gambling-or-investing-your-seo-dollars/feed</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/are-you-gambling-or-investing-your-seo-dollars?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=are-you-gambling-or-investing-your-seo-dollars</feedburner:origLink></item>
		<item>
		<title>Don’t Ask for a Guest Post. Offer an Interview.</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/3zfAQ3O0j1c/dont-ask-for-a-guest-post-offer-an-interview</link>
		<comments>http://www.seerinteractive.com/blog/dont-ask-for-a-guest-post-offer-an-interview#comments</comments>
		<pubDate>Wed, 25 Apr 2012 12:46:05 +0000</pubDate>
		<dc:creator>Ryan Fontana</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=9533</guid>
		<description><![CDATA[Show of hands – who has spent countless hours on guest post linking only to receive limited responses from low quality opportunities, earning you a minimal link return on investment?  You are not alone. The problem is that most of us are pitching bloggers who receive the same email countless times a day from people [...]]]></description>
			<content:encoded><![CDATA[<p style="text-align: left" align="center">Show of hands – who has spent countless hours on guest post linking only to receive limited responses from low quality opportunities, earning you a minimal link return on investment?  You are not alone.</p>
<p style="text-align: left">The problem is that most of us are pitching bloggers who receive the same email countless times a day from people asking something from them.  Rather than ask for something, why not offer something?</p>
<p style="text-align: left"><strong>Offer an interview opportunity.  </strong>If you really think about it, how different is it than a guest post?  You are providing content with actionable advice that is built for the blog’s audience.  The biggest difference is that bloggers rarely get offered these opportunities, so your outreach message is already more naturally appealing than most others.</p>
<p style="text-align: left"><strong>Here is what you need:</strong></p>
<ul>
<li>Someone worth being interviewed</li>
<li>Queries that will uncover a footprint of past interview opportunities</li>
<li>The names of well-known people in your industry</li>
<li>An outreach message short, sweet and to the point</li>
</ul>
<p>&nbsp;</p>
<h3 class="sub_orange"><em>Someone Worth Being Interviewed</em></h3>
<p><em></em><img style="padding-right: 8px;padding-top: 8px;padding-bottom: 8px" src="http://1.bp.blogspot.com/-u6_oVK0B6jM/Tgc-QBU3-QI/AAAAAAAAE5o/VoTEC8f6YRA/s1600/interview1.jpg" alt="" width="317" height="254" /></p>
<p style="text-align: left">If you don’t work with/for a company that has something &amp; someone <strong>worth sharing</strong>, this strategy is not for you.</p>
<p style="text-align: left"><em>What is worth sharing?</em></p>
<p style="text-align: left">That could be a lot of things – are you always innovating? A thought leader? Do you have a unique culture? In general, if relevant bloggers are at least aware of your brand and perceive some level of value, you’ve already intrigued them with an interview.</p>
<p style="text-align: left"><em>Who is worth sharing?</em></p>
<p style="text-align: left">You’ll need someone that people within your niche community would want to hear from: the company’s founder? A C-level employee? Marketing director? So long as they carry the right title and can add value with their insight, you can make this work.<em></em></p>
<h3 class="sub_orange" style="text-align: left"></h3>
<h3 class="sub_orange" style="text-align: left"></h3>
<h3 class="sub_orange" style="text-align: left"><em>Smart Queries with a Footprint</em></h3>
<p style="text-align: left">Much like guest post research, you want to run some advanced queries to find the footprint.  If a site has accepted one guest post, they’ll likely accept another.  The same goes with an interview – so let’s change the language of your search queries.  Here are some examples to work with:</p>
<p style="text-align: left"><strong>“interview with” “keyword” expert</strong></p>
<p style="text-align: left"><em>Try swapping “interview” with –</em></p>
<ul>
<li>&#8220;Q and A”</li>
<li>&#8220;Q&amp;A”</li>
<li>“Chat with”</li>
<li>“Discussion with”</li>
</ul>
<p style="text-align: left"><em>Try swapping out “expert” with –</em></p>
<ul>
<li>“CEO”</li>
<li>“Professional”</li>
<li>“CFO”</li>
<li>“Founder”</li>
<li>“Entrepreneur”</li>
</ul>
<p style="text-align: left">Stretch the keyword options as much as you can. Let’s say your keyword is for an email marketing company.  The first keyword you’ll likely explore is “email marketing.”</p>
<p style="text-align: left">But don’t stop there.</p>
<ul>
<li>Does general <em>“business” </em>return relevant results?</li>
<li>Is <em>“small business” </em>the company’s particular niche?</li>
<li>What will <em>“marketing” </em>return  when I remove “email” from the query?</li>
<li>A lot of <em>“start ups”</em> would probably want to know how they could better use email marketing, or even  websites that  focus on <em>“entrepreneurship.”</em></li>
</ul>
<p style="text-align: left">Constructing the right query will require some fine-tuning and refining, but you will get results.  Add some intitle: &amp; inurl: operators in there as well and see what you find.</p>
<p style="text-align: left"><em> </em></p>
<h3 class="sub_orange" style="text-align: left"><em>Identify the Cream of the Crop in Your Vertical</em></h3>
<p><em></em><span class="Apple-style-span" style="color: #666666;font-size: 13px;line-height: 17px;font-weight: normal"><img style="padding-right: 8px;padding-top: 8px;padding-bottom: 8px" src="http://multimedia.heraldinteractive.com/images/20120423/d9fd25_flyers42212.jpg" alt="" width="315" height="275" /></span></p>
<p style="text-align: left">By identifying the most well-known, recognized people in your space, you can follow in their path of successful interviews.  Who are the C-level employees for your competitors? Grab those names and throw them into the query options from above.</p>
<p style="text-align: left">Beyond your direct competitors, who are some of the top dogs in your entire industry or similar industries? For example, if we looked at the SEO community, a popular choice for one of the top dogs is Rand Fishkin:</p>
<p style="text-align: left"><a href="http://www.google.com/search?sourceid=chrome&amp;ie=UTF-8&amp;q=%E2%80%9Cinterview%E2%80%9D+Rand+Fishkin#q=%E2%80%9Cinterview%E2%80%9D+Rand+Fishkin&amp;hl=en&amp;prmd=imvnso&amp;ei=NsKVT8KqHJGe6QHCsaGGBA&amp;start=0&amp;sa=N&amp;bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&amp;fp=98d5445c5607bd30" class="broken_link">“interview” Rand Fishkin</a></p>
<p style="text-align: left">The first 3-4 pages alone are ripe with websites interviewing Rand that could also be interested in a similar opportunity.</p>
<p style="text-align: left">Don’t just stop at the names you can rattle off the top of your head.  Do a search of the “top (industry) professionals” and see what you come up with.  Did you find something with a list of names? Great! Grab it, plug in the names, and start all over again.</p>
<p style="text-align: left"><em> </em></p>
<h3 class="sub_orange" style="text-align: left"><em>Create the Right Pitch Message</em></h3>
<p style="text-align: left">Once you’ve identified the websites that are relevant to your vertical and are a good fit with your interviewee, now you have to hit them with right pitch.</p>
<p style="text-align: left">You already know they’ve done interviews in the past, so don’t waste anyone’s time writing a novel about how great an interview would be for all parties involved.  Matter of fact, take off your linkbuilding hat here and put on your PR cap.  We beg a lot as linkbuilders (those of you at <a href="http://www.distilled.net/blog/events/linklove-boston-2012-recap/">LinkLove in Boston</a> heard Wil cover this), but a PR rep is emailing with an offer.  That offer is the opportunity to interview an industry leader.</p>
<p style="text-align: left">Here is an approach that we’ve used in the past.</p>
<p style="text-align: left;padding-left: 30px"><em>Paragraph 1: </em>Acknowledge you’ve read/listened to their past interviews (provide a URL) and suggest that you have a similar interview opportunity that their readership will find intriguing<em> <strong>(2 SENTENCES)</strong></em></p>
<p style="text-align: left;padding-left: 30px"><em>Paragraph 2: </em>Let the blogger know who you represent, and what type of niche experts you are offering.  Include position titles and name drop. If you have a link to the expert’s bio/background, include it here. <strong><em>(1-2 SENTENCES)</em></strong></p>
<p style="text-align: left;padding-left: 30px"><em>Paragraph 3: </em>Tell the blogger that if they’re interested, your interviewee would be happy to share his/her expert advice &amp; analysis.  You’d also be happy to answer any specific questions the blogger may have or discuss the opportunity in more detail. <strong><em>(2-3 SENTENCES)</em></strong></p>
<h3 class="sub_orange" style="text-align: left"></h3>
<h3 class="sub_orange" style="text-align: left"></h3>
<h3 class="sub_orange" style="text-align: left"><strong>This $!@% Works!</strong></h3>
<p><img style="padding-right: 8px;padding-top: 8px;padding-bottom: 8px" src="http://static.wix.com/media/03fab4886507e5d0e69267dfdf5bb2e0.wix_mp_256" alt="" width="330" height="205" /></p>
<p style="text-align: left"><strong></strong>This pitch has been sent to 30 websites resulting in 12 interview links.  That’s a link acquisition rate of 40% on quality, relevant sites.   One was even mentioned in the Small Business section of the New York Times.</p>
<p style="text-align: left">Give it a shot. Next time you are going to linkbuild for a guest post, try this method instead.  I’ve given you the blueprint, and all that I ask in return is the following commitment from you:  that you’ll stop asking and start offering.</p>
<p style="text-align: left"><em><a href="https://twitter.com/#!/fontanaRJ">Follow Ryan Fontana on Twitter</a></em></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=3zfAQ3O0j1c:Yn4bH7La2sY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=3zfAQ3O0j1c:Yn4bH7La2sY:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=3zfAQ3O0j1c:Yn4bH7La2sY:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=3zfAQ3O0j1c:Yn4bH7La2sY:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=3zfAQ3O0j1c:Yn4bH7La2sY:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=3zfAQ3O0j1c:Yn4bH7La2sY:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?d=qj6IDK7rITs" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/seerinteractive/dndP/~4/3zfAQ3O0j1c" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/dont-ask-for-a-guest-post-offer-an-interview/feed</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/dont-ask-for-a-guest-post-offer-an-interview?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=dont-ask-for-a-guest-post-offer-an-interview</feedburner:origLink></item>
	</channel>
</rss>

