<?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>Mon, 20 Feb 2012 17:34:19 +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>Yahoo Search Results Showing Latest Tweets with Filter Options</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/q0c6U9WykrI/yahoo-search-results-showing-latest-tweets-with-filter-options</link>
		<comments>http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options#comments</comments>
		<pubDate>Mon, 20 Feb 2012 17:34:19 +0000</pubDate>
		<dc:creator>Ryan Fontana</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8736</guid>
		<description><![CDATA[If you have the slightest interest in professional sports, you have probably heard a thing or two in the news about Peyton Manning’s current situation with the Indianapolis Colts.  The CliffsNotes: He’s coming off a serious injury, he’s due a ton of money, the Colts have the number one pick in the draft and have [...]]]></description>
			<content:encoded><![CDATA[<p style="text-align: left" align="center">If you have the slightest interest in professional sports, you have probably heard a thing or two in the news about Peyton Manning’s current situation with the Indianapolis Colts.  The CliffsNotes: He’s coming off a serious injury, he’s due a ton of money, the Colts have the number one pick in the draft and have all but secured selecting Andrew Luck (considered to be the next great QB).  All signs point to Peyton’s release and the biggest free agent prize in quite some time.</p>
<p>Everyone has their opinion about Peyton, including people in the office here at SEER.  <a href="https://twitter.com/#!/adammm">Adam</a> and I believe that Peyton will play the bulk of the season next year, where <a href="https://twitter.com/#!/lavoritano">Mark</a> believes he is washed up and is all but a press release away from announcing his retirement.</p>
<p>But we are not the only folks speculating about what happens next.  Peyton has created serious buzz in the sports world, as well as the search &amp; Twitter worlds.  This morning, doing a Peyton Manning search on Yahoo showed something interesting:  a tab for the latest stories, and an additional tab for the latest Twitter results about Manning.  Even more interesting is that you can filter for the type of tweets you want to see &#8211; &#8220;Everyone&#8221; vs &#8220;Insider&#8221; tweets.</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/peyton3-3" rel="attachment wp-att-8748"><img class="alignnone size-large wp-image-8748" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/Peyton32-570x407.png" alt="" width="570" height="407" /></a></p>
<p>&nbsp;</p>
<p>I wonder if baby bro Eli Manning, who just won a Super Bowl, is getting the same treatment when you search his name? Nope.</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/eliyahoo-3" rel="attachment wp-att-8749"><img class="alignnone size-large wp-image-8749" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/EliYahoo2-570x437.png" alt="" width="570" height="437" /></a></p>
<p>&nbsp;</p>
<p>What about Tim Tebow, the most polarizing/debated QB in the league? Nothing.</p>
<p>Fine, let’s get off the QB kick.  What are some other hot topics trending right now?  Looking at the top 10 “Trending Now” topics on Yahoo, sure enough Peyton was sitting at number 2 around the time I searched.  Is this the criteria for a query to have a separate tab for the latest tweets?</p>
<p>&nbsp;</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/yahootrending-2" rel="attachment wp-att-8750"><img class="alignnone size-large wp-image-8750" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/YahooTrending1-570x440.png" alt="" width="570" height="440" /></a></p>
<p>I decided to click on Nicolas Cage to see if he receiving the same Twitter love as Peyton.  He sure is. But now you are filtering for everyone versus “Hollywood Insiders.”</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/nickcageyahoo2-2" rel="attachment wp-att-8751"><img class="alignnone size-large wp-image-8751" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/NickCageYahoo21-570x440.png" alt="" width="570" height="440" /></a></p>
<p>&nbsp;</p>
<p>What if we looked at a trend that wasn’t a person, say “Unemployment?”</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/unemploymentyahoo-2" rel="attachment wp-att-8752"><img class="alignnone size-large wp-image-8752" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/UnemploymentYahoo1-570x384.png" alt="" width="570" height="384" /></a></p>
<p>This is something we&#8217;ve seen before (via <a href="http://mashable.com/2009/11/19/yahoo-twitter/">Mashable</a>): showing the latest Twitter results without filter options and included with tabs for photos and videos.</p>
<p>Okay. So only if you are a person trending on Yahoo do you get the latest Twitter results in a separate tab with filtered options?  Wrong.  “U.S. Stocks” results offer the Twitter tab with only one filter option of “everyone”, Reese Witherspoon defaults to an Associated Press photo slide show, and “gold prices” gets nothing.</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/reeseyahoo-2" rel="attachment wp-att-8753"><img class="alignnone size-large wp-image-8753" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ReeseYahoo1-570x409.png" alt="" width="570" height="409" /></a></p>
<p>&nbsp;</p>
<p><strong>Beyond Yahoo’s Trending Topics &#8211; Additional Queries Showing Twitter Tab in Search Results</strong></p>
<p>The Top 10 trending results are constantly updating, but I wanted to run searches on other top newsworthy people/topics.  I decided to jump on CNN.com, and run Yahoo searches on some of the headlines across a number of categories.</p>
<p>Oh yeah, we are in an election year. A search for Barack Obama gets the Twitter tab with filter options. Rick Santorum as well.</p>
<p>What about countries being discussed on CNN? Searches for “Syria,” “Israel” &amp; “Iran” are all showing the Twitter tab with filter options.</p>
<p>Any other people on CNN showing these type of results? Lindsay Lohan and Whitney Houston. Lindsay even gets an additional filter of “Official Tweets.”</p>
<p>&nbsp;</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/lindsayyahoo2-2" rel="attachment wp-att-8754"><img class="alignnone size-large wp-image-8754" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/LindsayYahoo21-570x422.png" alt="" width="570" height="422" /></a></p>
<p>&nbsp;</p>
<p><strong>Any Musicians, Artists or Bands Getting any Twitter Love in Yahoo Search Results?</strong></p>
<p>A Red Hot Chili Peppers die hard, they were my first choice for inspection.  Not only do they have a Twitter tab, but an &#8220;Albums&#8221; tab as well.  This was seen for some other artists (Foo Fighters, Alicia Keys) but not others (Beastie Boys, Bob Dylan).</p>
<p><a href="http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/rhcpyahoo" rel="attachment wp-att-8777"><img class="alignnone size-large wp-image-8777" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/RHCPYahoo-570x420.png" alt="" width="570" height="420" /></a></p>
<p><strong>What does it all mean?</strong></p>
<p>While it’s clear that Yahoo is ramping up its Twitter integration within search results by offering latest tweets for hot topics and people of interest, how they determine which queries will earn the additional tab is unknown.  <a href="http://espn.go.com/nba/player/_/id/4299/jeremy-lin">Jeremy Lin</a> is the most discussed athlete in sports right now; why doesn&#8217;t he have a tab for latest tweets? How is Yahoo deciding which queries receive specific filter options? What qualifies a Twitter handle to be classified as an “insider&#8221;?</p>
<p>What do you think?  Share your thoughts below in our comment section or <a href="https://twitter.com/#!/fontanaRJ">connect with Ryan Fontana via Twitter</a>.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=q0c6U9WykrI:gP1u8UR6o0o: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=q0c6U9WykrI:gP1u8UR6o0o:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=q0c6U9WykrI:gP1u8UR6o0o:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=q0c6U9WykrI:gP1u8UR6o0o:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=q0c6U9WykrI:gP1u8UR6o0o:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=q0c6U9WykrI:gP1u8UR6o0o: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/q0c6U9WykrI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/yahoo-search-results-showing-latest-tweets-with-filter-options?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=yahoo-search-results-showing-latest-tweets-with-filter-options</feedburner:origLink></item>
		<item>
		<title>3 Ways to Monitor MSN Search Partners</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/6AIoeJ6Qmhk/3-ways-to-monitor-msn-search-partners</link>
		<comments>http://www.seerinteractive.com/blog/3-ways-to-monitor-msn-search-partners#comments</comments>
		<pubDate>Wed, 15 Feb 2012 13:35:49 +0000</pubDate>
		<dc:creator>Harris Neifield</dc:creator>
				<category><![CDATA[MSN]]></category>
		<category><![CDATA[PPC]]></category>
		<category><![CDATA[yahoo]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8652</guid>
		<description><![CDATA[As you may know, I am a fanatic about separating search partners and Bing/Yahoo traffic in adCenter ad groups. We&#8217;ve had success with search partners, particularly for financial services clients, but they need to be monitored very carefully as there can and has been fraud on Bing and Yahoo search partners for years. Fraud can [...]]]></description>
			<content:encoded><![CDATA[<p>As you may know, I am a <a href="http://www.seerinteractive.com/blog/ten-tips-for-alliance-search-partners">fanatic</a> about separating search partners and Bing/Yahoo traffic in adCenter ad groups.  We&#8217;ve had success with <a href="http://www.seerinteractive.com/blog/do-not-write-off-bingyahoo-search-partners-just-yet">search partners</a>, particularly for financial services clients, but they need to be monitored very carefully as there can and has been fraud on Bing and Yahoo search partners for years.  Fraud can take two forms &#8211; individual bad partners (my colleague Bonnie <a href="http://www.seerinteractive.com/blog/beware-of-a-new-click-fraud-scam-on-yahoo%E2%80%99s-search-partners">wrote about this</a> with Yahoo) or widespread fraud by many partners.  In this situation, unfortunately I&#8217;m seeing both.  There is a lot of research on this topic; PPC Hero wrote a <a href="http://www.ppchero.com/adcenter-search-partner-quality-why-you-might-be-wasting-money/">good article</a> in December about this.</p>
<p>Around Thanksgiving, one of my clients began seeing a huge spike in search partner conversions.  While the conversion rate rose for search partners, the Bing &amp; Yahoo conversion rate stayed pretty much the same.  This was concerning.</p>
<p><a href="http://www.seerinteractive.com/blog/3-ways-to-monitor-msn-search-partners/by_vs_sp" rel="attachment wp-att-8663"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/BY_vs_SP-570x403.png" alt="" width="570" height="403" class="aligncenter size-large wp-image-8663" /></a></p>
<p>I didn&#8217;t want to be the wet blanket.  Is it possible that MSN added great new sites to their network and this is legitimate?  Of course, but I needed to do several things to be sure I wasn&#8217;t wasting money.</p>
<p><strong>#1 &#8211; Find the Big Fraudsters in Publisher Reports</strong></p>
<p>Start with the basics.  Run publisher reports to identify who the converting search partners are.  In this instance, one Search Partners placement had 14 clicks and 14 conversions, yielding a conversion rate of 100%, while Bing &amp; Yahoo converted at 2.20%.  While Bing and Yahoo can convert at very different rates from search partners, this big of a discrepancy is odd.  Even if a spammy site could convert at 50% (over 20x what Bing and Yahoo do) there is much less than a 1% chance (0.5^14=0.00006) that all 14 clicks will convert.  I actually got an anti-virus warning when I tried to visit one of these domains.  It&#8217;s safe to say that conversions from those sites are fraudulent.   </p>
<p><strong>#2 &#8211; Find the Little Fraudsters in Publisher Reports</strong></p>
<p>As adCenter professionals know, a big chunk of publisher activity may be on sites with only one or two total clicks.  If you&#8217;re advertising for multiple products and you don&#8217;t want to pivot ad group or campaign data to get more performance data on individual publishers, it gets even worse.  Individual clicks can&#8217;t be analyzed like the bigger partners; however, you can look at aggregate small volume site performance.</p>
<p>For this client, I had 964 placements with only one click; 237 of them converted (24.58%).  For a large number of very small search partner sites to convert at over 10x the rate of Bing and Yahoo is &#8220;strange.&#8221;  What makes this even more odd is that the biggest search partner sites for this particular client (keywordblocks, financecity) were converting at rates similar to Bing and Yahoo search properties (3.67% and 3.52% for keywordblocks and financecity respectively).</p>
<p>Hundreds of small search partner sites were likely recording fraudulent conversions, but the biggest search partner sites were likely not doing this.  Why was this happening?  I think Google Analytics data shows how smaller sites could engage in widespread over-reporting of conversions.</p>
<p><strong># 3 Check Analytics Conversion Specific Data</strong></p>
<p>This client has three website conversions, all of which get volume (there is a fairly equitable mix between them).  The Bing pixel can record conversions in multiple ways (Clickable does a good job describing the <a href="http://www.clickable.com/search-engine-marketing/microsoft-adcenter/conversion-tracking.aspx">different MSN tracking methods</a> &#8211; one per click and count all for the pixel).  However, the Bing pixel can&#8217;t distinguish between conversion types.  If we had 100 total conversions, it couldn&#8217;t tell us that 30 were for goal one, 40 were for goal two and 30 for goal three.  This can be a problem if computer program finds a way to exploit one conversion type.</p>
<p>SEER always sets up Google Analytics (GA) goals in addition to the AdWords, adCenter and other engine pixels.  GA goal conversion numbers won&#8217;t match the Bing pixel numbers, but GA gives us a second source to compare conversion trends and we can get the breakdown of conversion types from GA.  When MSN search partner conversions spiked, a large, disproportionate number of the new conversions were recorded in GA as goal type one.  As you can see, goal one&#8217;s conversion rate mirrors the MSN search partner conversion rate as measured by the Bing pixel.</p>
<p><a href="http://www.seerinteractive.com/blog/3-ways-to-monitor-msn-search-partners/sp__ga_conv-_comp" rel="attachment wp-att-8664"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/SP__GA_Conv._Comp-570x403.png" alt="" width="570" height="403" class="aligncenter size-large wp-image-8664" /></a></p>
<p>In this case, for technical reasons as to how the site records goal one (the client&#8217;s IT team can&#8217;t explain how and when goal one&#8217;s conversion page loads), we believe goal one could be getting exploited by computer programs aiming to maximize the number of conversions for search partner sites.  It&#8217;s easy to block publishers in MSN.  If search partners don&#8217;t convert, advertisers will drop them.  My intuition is that there are unscrupulous websites looking to game advertisers by making it look like they have lots of conversions, so they won&#8217;t be cut from search partners.  They found a weak goal conversion page and tried to exploit it, but fortunately we noticed them.</p>
<p>What have we done about it?  We&#8217;ve paused search partners, informed the client, opened a click fraud investigation and I&#8217;m trying to get form data to see if the inputted fields are legitimate.  The last part is hard slogging.  I&#8217;m not sure if the system the client has will be able to associate form information with MSN campaigns and referring websites.  I could then cross reference referrers to publisher report data.  We&#8217;ll see how this finishes up; the click fraud investigation isn&#8217;t done yet.</p>
<p>What are your best tactics for monitoring Microsoft search partners?  Feel free to add comments below.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AIoeJ6Qmhk:aQMnFBKxeu0: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=6AIoeJ6Qmhk:aQMnFBKxeu0:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=6AIoeJ6Qmhk:aQMnFBKxeu0:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AIoeJ6Qmhk:aQMnFBKxeu0:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=6AIoeJ6Qmhk:aQMnFBKxeu0:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=6AIoeJ6Qmhk:aQMnFBKxeu0: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/6AIoeJ6Qmhk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/3-ways-to-monitor-msn-search-partners/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/3-ways-to-monitor-msn-search-partners?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=3-ways-to-monitor-msn-search-partners</feedburner:origLink></item>
		<item>
		<title>Google Scraper in Google Docs (Update)</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/zzSRZHFqk6c/google-scraper-in-google-docs-update</link>
		<comments>http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update#comments</comments>
		<pubDate>Wed, 15 Feb 2012 12:01:10 +0000</pubDate>
		<dc:creator>Chris Le</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8629</guid>
		<description><![CDATA[Sometime on Monday, Google made changes to their results page.  ImportXML doesn&#8217;t work anymore.  So here&#8217;s a function you can use to get SERP results from Google. (Correction: What I meant to say is that if you used =ImportXML("http://www.google.com/search?q=philadelphia seo company&#38;num=100", "//h3[@class='r']/a/@href") it wouldn&#8217;t work.  ImportXML, the function itself, works fine.) Google Scraper in Google Docs [...]]]></description>
			<content:encoded><![CDATA[<p>Sometime on Monday, Google made changes to their results page.  ImportXML doesn&#8217;t work anymore.  So here&#8217;s a function you can use to get SERP results from Google.</p>
<p>(Correction: What I meant to say is that if you used <code>=ImportXML("http://www.google.com/search?q=philadelphia seo company&amp;num=100", "//h3[@class='r']/a/@href")</code> it wouldn&#8217;t work.  ImportXML, the function itself, works fine.)</p>
<p class="sub_orange">Google Scraper in Google Docs Spreadsheet:</p>
<p><a href="http://www.seerinteractive.com/wp-content/uploads/2012/02/Screen-Shot-2012-02-15-at-6.03.55-AM.png"><img class="alignnone size-large wp-image-8642" title="Screen Shot 2012-02-15 at 6.03.55 AM" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/Screen-Shot-2012-02-15-at-6.03.55-AM-570x322.png" alt="" width="570" height="322" /></a></p>
<p><strong>Google Docs</strong>: <a title="Google Scraper Spreadsheet w/ Function" href="https://docs.google.com/spreadsheet/ccc?key=0Apam75iNJI9idHkteFpGYjNhcjRBeUxsRWI0VER6ZWc" target="_blank">https://docs.google.com/spreadsheet/ccc?key=0Apam75iNJI9idHkteFpGYjNhcjRBeUxsRWI0VER6ZWc</a></p>
<p><strong>Source code</strong>: <a title="Seer Interactive public google functions" href="https://github.com/chrisle/seer.js-public" target="_blank">https://github.com/chrisle/seer.js-public</a></p>
<p class="sub_orange">How to use it:</p>
<p style="padding-left: 30px;">1. Click on File &gt; Make a copy.  Name it whatever you want.</p>
<p style="padding-left: 30px;">2. In your spreadsheet, use this formula: <code>=googleScraper("my keyword here")</code></p>
<p style="padding-left: 30px;">That will default to 10 results.</p>
<p class="sub_orange">To get more results:</p>
<p style="padding-left: 30px;">Add a second parameter like this: <code>=googleScraper("my keyword here", 30)</code></p>
<p class="sub_orange">To add the formula to a different spreadsheet:</p>
<p style="padding-left: 30px;">1. Go to the <a title="Google Scraper source code" href="https://github.com/chrisle/google_scraper.js/blob/master/google_scraper.js" target="_blank" class="broken_link">source code for google_scraper.js</a></p>
<p style="padding-left: 30px;">2. Copy all that code to your clipboard</p>
<p style="padding-left: 30px;">3. Create your new spreadsheet</p>
<p style="padding-left: 30px;">4. Click on Tools &gt; Script Editor</p>
<p style="padding-left: 30px;">5. Paste all the code into the editor and save.</p>
<p class="sub_orange">Updates</p>
<p style="padding-left: 30px;">v1.0.1: Fixed Non-URL universal searches getting returned. Thanks Gareth Brown.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=zzSRZHFqk6c:CZuiwtCg950: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=zzSRZHFqk6c:CZuiwtCg950:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=zzSRZHFqk6c:CZuiwtCg950:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=zzSRZHFqk6c:CZuiwtCg950:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=zzSRZHFqk6c:CZuiwtCg950:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=zzSRZHFqk6c:CZuiwtCg950: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/zzSRZHFqk6c" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update/feed</wfw:commentRss>
		<slash:comments>18</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=google-scraper-in-google-docs-update</feedburner:origLink></item>
		<item>
		<title>Bridge the Gap Between Excel and PowerPoint</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/NxIfqWouXEc/bridge-the-gap-between-excel-and-powerpoint</link>
		<comments>http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint#comments</comments>
		<pubDate>Tue, 14 Feb 2012 17:44:16 +0000</pubDate>
		<dc:creator>laurenf</dc:creator>
				<category><![CDATA[PPC]]></category>
		<category><![CDATA[SEO]]></category>
		<category><![CDATA[tools]]></category>
		<category><![CDATA[Excel]]></category>
		<category><![CDATA[PowerPoint]]></category>
		<category><![CDATA[Presentations]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8591</guid>
		<description><![CDATA[As one of the newest members of the SEER PPC team, I was immediately thrown into becoming an Excel Ninja, as our fellow colleagues call us. I quickly learned some of the bells and whistles that Excel has to offer and I am honestly quite disappointed that I hadn&#8217;t previously learned about pivot tables and [...]]]></description>
			<content:encoded><![CDATA[<p>As one of the newest members of the SEER PPC team, I was immediately thrown into becoming an Excel Ninja, as our fellow colleagues call us. I quickly learned some of the bells and whistles that Excel has to offer and I am honestly quite disappointed that I hadn&#8217;t previously learned about pivot tables and vlookups.</p>
<p>Recently, I discovered yet another huge timesaver: the ability to link data from Excel to PowerPoint. This feature is perfect for PowerPoint presentations that are in need of constant updates.<strong> </strong>As we always love to share our favorite lifesaving formulas, tips and tricks, I wanted to share a quick how-to with you. Follow this simple step by step process to link your Excel data to PowerPoint.</p>
<p><strong>Step 1:</strong> Create your table of data in Excel as you usually would. Make sure you save the workbook before linking it to the PowerPoint file.</p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_1" rel="attachment wp-att-8592"><img class="aligncenter size-medium wp-image-8592" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_1-300x126.png" alt="" width="300" height="126" /></a></p>
<p>Q<em>uick Tip: If you are sharing the PowerPoint with people who may not have the Excel file but might need to update the data, make sure you provide them with the most up-to-date Excel file on their device saved as the same file name as the original file. You may want to consider using the Microsoft Office &#8220;Save &amp; Send&#8221; feature or online collaboration tools such as </em><a href="http://box.com/"><em>box</em></a><em> or </em><a href="http://www.dropbox.com/"><em>Dropbox</em></a><em>.</em></p>
<p><strong>Step 2</strong>: Insert a chart to portray your data and adjust the appearance of the Excel chart.</p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_2" rel="attachment wp-att-8593"><img class="aligncenter size-medium wp-image-8593" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_2-300x179.png" alt="" width="300" height="179" /></a></p>
<p><em>Quick Tip: If you have multiple Excel charts that you wish to link to your PowerPoint, make sure they are all in the same Excel file (they may be on separate tabs within the same workbook).</em></p>
<p><strong>Step 3:</strong> Once you&#8217;re satisfied with your Excel chart, copy and paste special it to the corresponding PowerPoint slide. The &#8220;Paste Special, Paste Link&#8221; paste option will update the chart every time the presentation is opened to reflect the current data in the Excel file.</p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_3" rel="attachment wp-att-8594"><img class="aligncenter size-full wp-image-8594" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_3.png" alt="" width="117" height="157" /></a></p>
<p><img class="aligncenter size-medium wp-image-8595" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_4-300x173.png" alt="" width="300" height="173" /></p>
<p><em>Quick Tip: Use the keyboard shortcut Ctrl + Alt + V for Paste Special Options when pasting charts into PowerPoint. The keyboard shortcut Ctrl + V will simply paste the chart into the PowerPoint Slide without linking it to the source file.</em></p>
<p><strong>Step 4:</strong> Your charts are now linked between Excel and PowerPoint! Double-clicking on a chart in PowerPoint will open the Excel file where you can edit the data. Any changes you make in Excel will be reflected in both the Excel <em>and</em> PowerPoint charts.</p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_5" rel="attachment wp-att-8596"><img class="aligncenter size-full wp-image-8596" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_5.png" alt="" width="268" height="230" /></a></p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_6" rel="attachment wp-att-8597"><img class="aligncenter size-medium wp-image-8597" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_6-300x159.png" alt="" width="300" height="159" /></a></p>
<p><em>Quick Tip: If you are adding rows/columns, you will have to right click on the corresponding chart in the Excel file and click &#8220;Select Data&#8221; to select the chart data range. The updated data source should then be automatically applied to both the Excel and PowerPoint charts.</em></p>
<p><strong>Step 5:</strong> Each time you open a PowerPoint file that is link to a Microsoft Office product, you will be prompted to update the links in the PowerPoint file. Simply click on the &#8220;Update Links&#8221; button; this process may take a few minutes depending on the number of charts that are linked. If the linked file is not available, click &#8220;Cancel;&#8221; the PowerPoint will still work and the data will be updated once the linked Excel file is available.</p>
<p><a href="http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/excel_7" rel="attachment wp-att-8598"><img class="aligncenter size-medium wp-image-8598" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/excel_7-300x197.png" alt="" width="300" height="197" /></a></p>
<p><em>Quick Tip: Before sending the PowerPoint presentation to clients (who will not be receiving the source file), you may want to consider breaking the link between Excel and PowerPoint. This can be done in PowerPoint from the Home Button &gt; Prepare &gt; Edit Links to File. Individually select each file you wish to unlink and click &#8220;Break Link.&#8221; Consider saving the unlinked file with a different file name so you can still access the linked PowerPoint for internal changes and updates. Another alternative solution is to PDF the presentation before sending it out. </em></p>
<p>Now that you know the simple five step process of linking data from Excel to PowerPoint, check out <a href="http://www.seerinteractive.com/blog/what-you-didnt-learn-about-ppc-in-college-but-wish-you-did">Morgan&#8217;s blog</a> to learn more lifesaving tricks and be sure to share your Excel lifesavers with us!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=NxIfqWouXEc:rx29ZilwNdo: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=NxIfqWouXEc:rx29ZilwNdo:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=NxIfqWouXEc:rx29ZilwNdo:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=NxIfqWouXEc:rx29ZilwNdo:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=NxIfqWouXEc:rx29ZilwNdo:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=NxIfqWouXEc:rx29ZilwNdo: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/NxIfqWouXEc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/bridge-the-gap-between-excel-and-powerpoint?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=bridge-the-gap-between-excel-and-powerpoint</feedburner:origLink></item>
		<item>
		<title>Writer’s Block? Fret No More. Ubersuggest &amp; Tag Crowd Are Here.</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/SqHg3ZWlPeU/tagcrowd-ubersuggest-seo-linking-on-page</link>
		<comments>http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page#comments</comments>
		<pubDate>Tue, 14 Feb 2012 13:55:05 +0000</pubDate>
		<dc:creator>Ethan Lyon</dc:creator>
				<category><![CDATA[google]]></category>
		<category><![CDATA[linkbuilding]]></category>
		<category><![CDATA[SEO]]></category>
		<category><![CDATA[tools]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8361</guid>
		<description><![CDATA[Sometimes it can be difficult to consistently come up with great content ideas &#8212; both for guest posting but also for on-page optimization. The below process will help you find new ideas &#8212; whether you’re new to an industry, or are a veteran &#8212; to both get links from guest posts but also create a [...]]]></description>
			<content:encoded><![CDATA[<p>Sometimes it can be difficult to consistently come up with great content ideas &#8212; both for guest posting but also for on-page optimization. The below process will help you find new ideas &#8212; whether you’re new to an industry, or are a veteran &#8212; to both get links from guest posts but also create a rich content that can help improve rankings.</p>
<p>We&#8217;re going to use Google Suggest, <a href="http://ubersuggest.org/">Ubersuggest.org</a> and Tag Crowd to find some excellent content ideas &#8212; a technique pioneered by <a href="http://www.seerinteractive.com/team/wil" target="_blank">Mr. Wil Reynolds</a>. Like most things in SEO, let’s first start with Google.</p>
<p>Go to Google.com, and use the search query: how to [INSERT TOPIC]. For example, you would use the query: how to travel . This will bring up suggestions people have search for around how to travel.</p>
<p><img class="aligncenter size-full wp-image-8374" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic1.png" alt="" width="354" height="74" /></p>
<p>In this example, we don’t have too much helpful information to start with. “How to travel around the world,” “how to travel abroad for free,” aren&#8217;t really groundbreaking. Once we begin finishing out our query with a, b, c, etc, we can see Google suggesting a lot of great content ideas. For instance, “how to travel by train in Europe” could be a great guest blog post on a travel site.</p>
<p>Going through the alphabet (e.g. “how to travel a,” “how to travel b”) in Google Suggest can be daunting and incredibly time consuming. This is where Ubersuggest.org can come in handy. It will use your query and go through the alphabet just like we have been doing in the above and Ubersuggest.org will give all results on one page.</p>
<p><a href="http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/ubersuggest_pic2" rel="attachment wp-att-8373"><img class="aligncenter size-full wp-image-8373" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic2.png" alt="" width="338" height="281" /></a></p>
<p>Now begin scrolling down the page and as you can see, there are some really interesting ideas. For instance, “how to travel for free volunteer.” This could be a great blog post or on-page content about how to volunteer and travel abroad for free. Include some programs such as the Peace Corp and you have an excellent, informative post that people are searching for.</p>
<p>Another great example is “how to travel gluten free.” To diversify your backlink profile, you could use this content idea to guest post on food blogs.</p>
<p>Going through all of the ideas can also be daunting. So let’s extract the main themes around how to travel . Select the txt button below the search box on Ubersuggest.org and click the suggest button:</p>
<p><a href="http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/ubersuggest_pic3" rel="attachment wp-att-8372"><img class="aligncenter size-full wp-image-8372" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic3.png" alt="" width="247" height="125" /></a></p>
<p>This will download all of the results into a .txt file. Copy the results from the .txt file and go to Tagcrowd.com and paste all of the Google Suggest ideas into text box.<br />
<a href="http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/ubersuggest_pic4" rel="attachment wp-att-8371"><img class="aligncenter size-full wp-image-8371" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic4.png" alt="" width="294" height="172" /></a></p>
<p>Click “Visualize” and you’ll see all of the most commonly used words:</p>
<p><a href="http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/ubersuggest_pic5" rel="attachment wp-att-8370"><img class="aligncenter size-full wp-image-8370" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic5.png" alt="" width="401" height="125" /></a></p>
<p>This will give you some insight into travel trends and what people are searching for around travel. As we can see, “cheap” is very popular. So we can go back to Ubersuggest.org and drill down on what people are searching for around cheap:</p>
<p><a href="http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/ubersuggest_pic6" rel="attachment wp-att-8369"><img class="aligncenter size-full wp-image-8369" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/ubersuggest_pic6.png" alt="" width="232" height="198" /></a></p>
<p>What I would encourage you to do is if you’re pursuing a  guest blog post linking strategy or optimizing pages on your site, go through the above process and see what comes up. Again, often times when we have been in an industry for a long time or are new to it, we sometimes have writer&#8217;s block.</p>
<p>The above process should help bring some fresh ideas to the surface to help you build out rich on-page content to rank better while also being a resource for guest blog post content.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=SqHg3ZWlPeU:MMMdfN-vHX0: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=SqHg3ZWlPeU:MMMdfN-vHX0:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=SqHg3ZWlPeU:MMMdfN-vHX0:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=SqHg3ZWlPeU:MMMdfN-vHX0:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=SqHg3ZWlPeU:MMMdfN-vHX0:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=SqHg3ZWlPeU:MMMdfN-vHX0: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/SqHg3ZWlPeU" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page/feed</wfw:commentRss>
		<slash:comments>15</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/tagcrowd-ubersuggest-seo-linking-on-page?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=tagcrowd-ubersuggest-seo-linking-on-page</feedburner:origLink></item>
		<item>
		<title>Quick Queries For Link Wins</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/h_ftUzyyZBw/quick-queries-for-link-wins</link>
		<comments>http://www.seerinteractive.com/blog/quick-queries-for-link-wins#comments</comments>
		<pubDate>Mon, 13 Feb 2012 15:08:34 +0000</pubDate>
		<dc:creator>Adam Melson</dc:creator>
				<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8487</guid>
		<description><![CDATA[Time is always crunched to find a few queries that provide quick wins for linking. Short &#38; simple below, these worked tremendously well in the past week. When you&#8217;re kicking off a new client, you want to know everything about them. SEER gets this done through a lengthy questionnaire among other things. We get a [...]]]></description>
			<content:encoded><![CDATA[<p>Time is always crunched to find a few queries that provide quick wins for linking. Short &amp; simple below, these worked tremendously well in the past week. </p>
<p>When you&#8217;re kicking off a new client, you want to know everything about them. SEER gets this done through a lengthy questionnaire among other things. We get a ton of info, but there are always some items we&#8217;ve missed that are easy linking opportunities:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/newsponsorsclientname" rel="attachment wp-att-8495"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/newsponsorsclientname.png" alt="" width="330" height="48" class="aligncenter size-full wp-image-8495" /></a></p>
<p>The larger the company, the more likely they will not know every event they sponsored. Running through the first few pages of SERPs could provide logo linking opportunities or branded anchor text links. <strong>If it&#8217;s already paid for, why not make sure you&#8217;re getting the link value?</strong></p>
<p>Is your client/your company open to sponsoring events? Reverse that query so it looks like:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/newsponsors100" rel="attachment wp-att-8496"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/newsponsors100.png" alt="" width="300" height="48" class="aligncenter size-full wp-image-8496" /></a></p>
<p>This will bring back all sites that have the word &#8220;sponsors&#8221; in the URL as well as bring back affordable sponsorship opportunities starting at $100. This query brings back GREAT results, <strong>but has two holes</strong>:</p>
<p>1. Brings back sites that may mention sponsors at a $100 level, but those pages don&#8217;t link out to anyone.<br />
2. Brings back $100,000 sponsorship pages. I don&#8217;t want to knock $100k sponsorships, if it makes sense it makes sense, but I&#8217;m going to be looking for more affordable ones.</p>
<p>Are you in need of some <strong>higher domain authority</strong> sites? Add onto that query:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/edusponsors-2" rel="attachment wp-att-8491"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/edusponsors1.png" alt="" width="340" height="48" class="aligncenter size-full wp-image-8491" /></a></p>
<p>You can qualify the value of these sites by running it through OSE or other tools that can automate your evaluation just by dropping in the URLs. The big things on my radar when doing this are number of backlinks to that page, PR, DA &amp; to make sure that the sponsorships aren&#8217;t outdated. We have a post from last year about <a href="http://www.seerinteractive.com/blog/qualify-great-links">25 ways to qualify a link</a> if you need some other suggestions on how to determine the value of a page. </p>
<p>Also, you don&#8217;t have to include the AND depending on your query, but it organizes the different variables in my mind.</p>
<p>You can switch it out to be .gov instead of .edu, but you can also make it even longer so that it fits your business:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/eduskiing" rel="attachment wp-att-8492"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/eduskiing.png" alt="" width="417" height="48" class="aligncenter size-full wp-image-8492" /></a></p>
<p>Of course, switch it up to see what brings back the best results that fit your site:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/switchitup" rel="attachment wp-att-8497"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/switchitup.png" alt="" width="330" height="48" class="aligncenter size-full wp-image-8497" /></a></p>
<p><strong>Downsides to expanding your search:</strong></p>
<p>1. Will bring back fewer results or zero results.<br />
2. Will bring back other sponsors that are in your industry &amp; less of a page related to your industry. </p>
<p><strong>The second downside can then be turned into an upside.</strong> Find where else your competitors are sponsoring/advertising/promoted &amp; figure out how to get there too.</p>
<p>Alright, so we have one idea about finding existing sponsorships and one about finding new ones. Insert your paid link argument here, but if your company sells skis and you sponsor a college ski club without being crazy about your anchor text, I can only see that as a win.</p>
<p>Moving away from sponsorships to other places where you client/business might already be mentioned:</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/interviewcompanyname" rel="attachment wp-att-8493"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/interviewcompanyname.png" alt="" width="330" height="48" class="aligncenter size-full wp-image-8493" /></a></p>
<p>The interview might be recent, it might be 5 years old, but finding existing interviews with your company/client should be easy wins to ask for a link. </p>
<p><strong>Downsides:</strong></p>
<p>1. Many articles might already be linking.<br />
2. It could be a stretch to reach out about a link years after the fact.<br />
3. There might not be any results if the client/company is new.</p>
<p>If you never ask, you probably (writing a post after a test is finished about NOT asking for a link) won&#8217;t ever get one.</p>
<p>For the #3 downside, again, reverse it to find where your competitors have been interviewed.</p>
<p><a href="http://www.seerinteractive.com/blog/quick-queries-for-link-wins/evilcompetitor" rel="attachment wp-att-8494"><img src="http://www.seerinteractive.com/wp-content/uploads/2012/02/evilcompetitor.png" alt="" width="330" height="48" class="aligncenter size-full wp-image-8494" /></a></p>
<p>Repeat that over again with your competitor company name as well as their C-levels.</p>
<p>Hopefully these queries will help you find more linking opportunities. If you find these useful, play around with more. You can also follow me on twitter, <a href="https://twitter.com/adammm">@adammm</a>, or find other SEER people on twitter by following <a href="https://twitter.com/seerinteractive">@seerinteractive</a>. </p>
<p>Lastly, check out the <a href="http://www.soloseo.com/tools/linkSearch.html">Link Search Tool</a> from soloseo. There are a TON of queries there similar to those above that I go to on a regular basis.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=h_ftUzyyZBw:GxXpRR00uAk: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=h_ftUzyyZBw:GxXpRR00uAk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=h_ftUzyyZBw:GxXpRR00uAk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=h_ftUzyyZBw:GxXpRR00uAk:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=h_ftUzyyZBw:GxXpRR00uAk:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=h_ftUzyyZBw:GxXpRR00uAk: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/h_ftUzyyZBw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/quick-queries-for-link-wins/feed</wfw:commentRss>
		<slash:comments>7</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/quick-queries-for-link-wins?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=quick-queries-for-link-wins</feedburner:origLink></item>
		<item>
		<title>New Filters in Google Analytics</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/2VdWpkcNG6I/new-ga-filters</link>
		<comments>http://www.seerinteractive.com/blog/new-ga-filters#comments</comments>
		<pubDate>Fri, 10 Feb 2012 04:22:16 +0000</pubDate>
		<dc:creator>Rachael Gerson</dc:creator>
				<category><![CDATA[analytics]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8413</guid>
		<description><![CDATA[Last week, Google rolled out shiny new filter options. In addition to an improved, sorted format for the filters (below), there are also several new custom filters. We can now filter traffic into or out of profiles based on the following criteria: Campaign or AdGroup category: Campaign AdGroup Campaign Referral Path Audience category: Visitor Mobile [...]]]></description>
			<content:encoded><![CDATA[<p>Last week, Google rolled out shiny new filter options. In addition to an improved, sorted format for the filters (below), there are also several new custom filters.</p>
<p style="text-align: center;"><a href="http://www.seerinteractive.com/blog/new-ga-filters/google_analytics_filters" rel="attachment wp-att-8422"><img class="wp-image-8422 aligncenter" title="google_analytics_filters" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/google_analytics_filters.png" alt="" width="351" height="311" /></a></p>
<p>We can now filter traffic into or out of profiles based on the following criteria:</p>
<ul>
<li class="sub_orange">Campaign or AdGroup category:</li>
<ul>
<li>Campaign AdGroup</li>
<li>Campaign Referral Path</li>
</ul>
<li class="sub_orange">Audience category:</li>
<ul>
<li>Visitor Mobile (!!!!)</li>
</ul>
<li class="sub_orange">Location category:</li>
<ul>
<li>Continent</li>
</ul>
<li class="sub_orange">Event category:</li>
<ul>
<li>Event Category</li>
<li>Event Action</li>
<li>Event Label</li>
</ul>
</ul>
<p>Honestly, any new filter options are welcome, but I was most excited about the Event filters and the Mobile filter.</p>
<p>Back in December, Michelle walked everyone through the slightly complex process to <a title="create a mobile profile" href="http://www.seerinteractive.com/blog/creating-a-mobile-profile-in-google-analytics">create a mobile profile</a> in Google Analytics. For the past six months, we found this method to be the best way to properly capture the most mobile traffic possible.</p>
<p>The new Mobile filter changes everything. This filter means we can quickly include or exclude only mobile traffic, negating the need for the multiple steps listed in our previous blog post. Now if you want your profile to include mobile traffic, just add this quick filter:</p>
<p><a href="http://www.seerinteractive.com/blog/new-ga-filters/include-mobile" rel="attachment wp-att-8444"><img class="aligncenter size-full wp-image-8444" title="Include Mobile" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/Include-Mobile.png" alt="" width="441" height="311" /></a></p>
<p>Easy, right?</p>
<p>Google just keeps innovating, adding more features to Google Analytics, and they&#8217;re not slowing down. <strong>Any predictions for future feature releases? Or are there any new filter options you hope Google adds? Let us know in the comments!</strong></p>
<p>&nbsp;</p>
<p><em>Props to <a href="http://twitter.com/chelle_mnn">Michelle</a> for noticing the Mobile filter first!</em></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=2VdWpkcNG6I:qPlkhjtAeIU: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=2VdWpkcNG6I:qPlkhjtAeIU:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=2VdWpkcNG6I:qPlkhjtAeIU:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=2VdWpkcNG6I:qPlkhjtAeIU:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=2VdWpkcNG6I:qPlkhjtAeIU:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=2VdWpkcNG6I:qPlkhjtAeIU: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/2VdWpkcNG6I" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/new-ga-filters/feed</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/new-ga-filters?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=new-ga-filters</feedburner:origLink></item>
		<item>
		<title>AdWords Gets Serious About Privacy Policies</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/WPOTfdKNRGI/adwords-gets-serious-about-privacy-policies</link>
		<comments>http://www.seerinteractive.com/blog/adwords-gets-serious-about-privacy-policies#comments</comments>
		<pubDate>Wed, 08 Feb 2012 16:59:34 +0000</pubDate>
		<dc:creator>Alyssa McGowan</dc:creator>
				<category><![CDATA[google]]></category>
		<category><![CDATA[PPC]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8402</guid>
		<description><![CDATA[Now that I have been been working in the PPC space for almost a year and a half now I&#8217;ve seen my fair share of good and bad landing pages. Here at SEER, when we analyze potential landing pages for our clients one of the main things we look for (and won&#8217;t go live without) [...]]]></description>
			<content:encoded><![CDATA[<p>Now that I have been been working in the PPC space for almost a year and a half now I&#8217;ve seen my fair share of good and bad landing pages. Here at SEER, when we analyze potential landing pages for our clients one of the main things we look for (and won&#8217;t go live without) is that there is a link to the client&#8217;s privacy policy on the page. The reason being is because it is one of the AdWords policies that could cause your ads to be disapproved.</p>
<p>One day this fall I learned the hard way another addition of this rule I had never heard of. I went into AdWords to do my usual checks on one of my clients&#8217; accounts. I had seen volume drop down since the previous week and wanted to figure out what was going on. After digging I saw a lot of my ads were &#8220;suspended&#8221; due to landing page violations. The status notice pointed me to <a title="this link" href="http://adwords.google.com/support/aw/bin/static.py?hl=en&amp;page=guide.cs&amp;guide=1316546&amp;rd=1">this link</a>.</p>
<p>Once I looked around a bit more I realized our violation was specifically for &#8220;information harvesting&#8221; (See the AdWords help article <a title="here" href="http://support.google.com/adwordspolicy/bin/static.py?hl=en&amp;topic=1310866&amp;guide=1308231&amp;page=guide.cs&amp;answer=190438">here</a>). Basically, this policy prohibits “websites that don’t have a clear privacy policy and solicit personal information from users in circumstances where it’s unclear how the information will be used.”</p>
<p>Well that was nothing new&#8230; Except I didn&#8217;t see how this applied to my ads. I was running ads that sent users to landing pages and had a link to the privacy policy at the bottom of the page. I was also sending traffic to the advertiser&#8217;s actual domain, but the pages on the domain where users were sent didn&#8217;t have a form or collect any personal information.</p>
<p>After a few calls to AdWords General Support, it turns out if you are sending traffic to a website&#8217;s main domain (i.e., not a landing page), <strong>anywhere on that domain that asks for personal information needs to have a link to a privacy policy. </strong>Not just anywhere on the page either (there was a privacy policy in the footer when I was suspended), but it needs to be connected to the form in some way. Or, in Google&#8217;s words, <em>&#8220;easily accessible and prominent on the site before users enter their details.&#8221;</em>  While my landing pages did have a privacy policy; just like the pages on the main domain, the link to the privacy policy was in the footer. Below is the landing page I was using and where the privacy policy was when we got suspended.</p>
<p><a href="http://www.seerinteractive.com/blog/adwords-gets-serious-about-privacy-policies/bad_example-2" rel="attachment wp-att-8404"><img class="alignnone size-large wp-image-8404" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/bad_example1-570x443.png" alt="" width="570" height="443" /></a></p>
<p>I should point out it isn&#8217;t just the link on the headline that is reviewed for privacy policy compliance. When Google&#8217;s team reviews your ads they will follow every link in an ad for possible pages a user could end up at, this includes pages that sitelinks direct to. So even if your headline is sending traffic to a landing page that has a privacy policy in the correct place, if your sitelinks are sending traffic to the main domain that collects personal information, without a privacy policy in the right place you could be at risk.</p>
<p>To fix this (and be sure it didn&#8217;t happen again) I did an audit of the entire domain to be sure <em>anywhere</em> we collected personal data- even just a simple email address- there was a privacy policy next to the form. Once everything was updated with a simply call to AdWords General Support I was submitted for re-review within a day of submitting my ads my ads were up and running again.</p>
<p>None of us on the PPC team had ever heard about how far this &#8220;information harvesting&#8221; rule could potentially be taken and result in negative (and not easy to fix) consequences. We have all checked our clients&#8217; domains and landing pages to make sure we are proactive with this policy moving forward. Has anyone ever run into any issues with AdWords privacy policies they weren&#8217;t aware of? What were the results?</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=WPOTfdKNRGI:pndncWBJ3wg: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=WPOTfdKNRGI:pndncWBJ3wg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=WPOTfdKNRGI:pndncWBJ3wg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=WPOTfdKNRGI:pndncWBJ3wg:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=WPOTfdKNRGI:pndncWBJ3wg:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=WPOTfdKNRGI:pndncWBJ3wg: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/WPOTfdKNRGI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/adwords-gets-serious-about-privacy-policies/feed</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/adwords-gets-serious-about-privacy-policies?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=adwords-gets-serious-about-privacy-policies</feedburner:origLink></item>
		<item>
		<title>Take My Money – Fix Your Mobile Website!</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/c9_trpwJNCI/take-my-money-fix-your-mobile-website</link>
		<comments>http://www.seerinteractive.com/blog/take-my-money-fix-your-mobile-website#comments</comments>
		<pubDate>Fri, 03 Feb 2012 13:22:58 +0000</pubDate>
		<dc:creator>Jasmine Hall</dc:creator>
				<category><![CDATA[business thoughts]]></category>
		<category><![CDATA[ecommerce]]></category>
		<category><![CDATA[google]]></category>
		<category><![CDATA[mobile]]></category>
		<category><![CDATA[PPC]]></category>
		<category><![CDATA[tools]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8339</guid>
		<description><![CDATA[I was extremely lazy about holiday shopping this year.  Don’t get me wrong, I’m always lazy about holiday shopping but this year I had an unusual number of gifts to ship which meant that by the time I got around to thinking about shopping (December 17th), I had very few purchasing options. I became one [...]]]></description>
			<content:encoded><![CDATA[<p>I was extremely lazy about holiday shopping this year.  Don’t get me wrong, I’m always lazy about holiday shopping but this year I had an unusual number of gifts to ship which meant that by the time I got around to thinking about shopping (December 17<sup>th</sup>), I had very few purchasing options.</p>
<p>I became one of the hoards of shoppers who needed to do everything online. It’s almost cliché to point out that mobile shopping, or m-commerce, is becoming larger and larger. The research site eMarkerter has a great graph that shows exactly HOW large m-commerce is getting, projecting $11.6 billion in spend for 2012, up 73.1% over 2011.</p>
<p>&nbsp;</p>
<p style="text-align: center"><a href="http://www.emarketer.com/Article.aspx?R=1008769&amp;ecid=a6506033675d47f881651943c21c5ed4"><img class="size-medium wp-image-8343 aligncenter" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/mcommerce-sales-300x283.gif" alt="" width="300" height="283" /></a></p>
<p>So as I sat there eagerly ready to contribute my portion of those billions I ran into the same problem over and over again&#8212; subpar website experiences.</p>
<p>They were creative, they were good, but they were not optimal for viewing on a mobile device.</p>
<p>Since SEM is well, my job, I saw a great opportunity to dig in further to something that is already affecting search.</p>
<p>Google announced late last year that mobile site optimization would become a factor in quality scores for campaigns that were targeting mobile devices. It makes sense!  If a consumer is just going to get frustrated by your website anyway, why would Google reward you with a top spot in the paid search results?</p>
<p>Google put together the site <a href="http://www.howtogomo.com/">www.howtogomo.com</a> which has a lot of ways you can test your website for mobile usability, design tips, and even build your own. For now, I zeroed in on five of their ten mobile top practices!</p>
<ol>
<li><strong>1.       </strong><strong>Keep It Quick</strong></li>
</ol>
<p>This is for the impatient among us &#8211; which is all of us. Personally, if my little status bar takes more than three seconds I’m already hitting the back button and going to another site.</p>
<p><strong>The Tip to Implement:</strong> compress images, use bullet points, and make it easy for your page to load</p>
<ol>
<li><strong>2.       </strong><strong>Simplify Navigation</strong></li>
</ol>
<p>Your mobile site is the place for your most succinct writing. Only put on the page what you really feel is important because here people will get lost in the details.</p>
<p><strong>The Tip to Implement:</strong> Google’s recommendation is 7 links or fewer so make them count! Adding a search box for a complex site is ideal!</p>
<ol>
<li><strong>3.       </strong><strong>Be Thumb Friendly</strong></li>
</ol>
<p>Two words: Fat fingers. High on the list of annoying things about mobile sites is clicking a too small link and ending up somewhere I didn’t want to go because my fingers were too large!</p>
<p><strong>Tip to Implement:</strong> Use large centered buttons and pad them!</p>
<ol>
<li><strong>4.       </strong><strong>Design for Visibility</strong></li>
</ol>
<p>SEER doesn’t give design tips. We won’t tell you what colors to use or which general images work best, but we can let you know that how you use your space is important for conversions. <strong>Do</strong> make use of size and color for the button that leads to your call to action.<strong> Don’t</strong> ask people to fill out long forms, mobile is not the place to get their entire consumer profile, and <strong>Do</strong> make sure that they are not having to surf it, scroll it, pause it, click it (Technologic!) in order to read your page. They may leave first!</p>
<p style="text-align: center"><a href="http://www.seerinteractive.com/blog/take-my-money-fix-your-mobile-website/daft_punk" rel="attachment wp-att-8348"><img class="aligncenter  wp-image-8348" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/Daft_Punk-300x212.jpg" alt="" width="270" height="191" /></a></p>
<p><strong>Tip to Implement:</strong> Make it easy for your customers to read and eliminate the need to pinch and zoom to view content.</p>
<ol>
<li><strong>5.       </strong><strong>Make it Easy to Convert</strong></li>
</ol>
<p>This is important for all websites but where could it be more important than PPC? If someone comes to your site through a PPC ad tell them what you need them to do and allow them to complete this step in as few actions as possible. You can make it even easier on your customer by trying a function like click to call!</p>
<p><strong>Tip to Implement:</strong> Make it as easy as possible for consumers to complete your desired call to action.</p>
<p>Now that you have some of our tips here is a great example from <a href="http://www.einstein.edu" target="_blank">Einstein Healthcare Network in Philadelphia</a> that has all of these tips in action:</p>
<p style="text-align: center"><a href="http://www.seerinteractive.com/blog/take-my-money-fix-your-mobile-website/einstein-fastcare" rel="attachment wp-att-8342"><img class="aligncenter size-full wp-image-8342" src="http://www.seerinteractive.com/wp-content/uploads/2012/02/Einstein-FastCare.png" alt="" width="253" height="490" /></a></p>
<p>&nbsp;</p>
<ul>
<li>In just three lines of text you know the benefits of FastCare.</li>
<li>There is a clear call to action (Call now for Hours Directions or services!)</li>
<li>There is only one large button to press, and you know exactly where it will take you!</li>
</ul>
<p>This page was created in less than 30 minutes using Google’s Mobile Landing Page site templates (<a href="http://www.google.com/sites/help/intl/en/mobile-landing-pages/mlpb.html">http://www.google.com/sites/help/intl/en/mobile-landing-pages/mlpb.html</a>) and has seen a 30% call rate since implementation.</p>
<p>With so many tips and tools it doesn’t have to be time intensive to revamp your mobile site for success. When you are all done fixing it up, learn about Creating a Mobile Profile in <a href="http://www.seerinteractive.com/blog/creating-a-mobile-profile-in-google-analytics">Google Analytics.</a></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=c9_trpwJNCI:gAvXxv_hpMk: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=c9_trpwJNCI:gAvXxv_hpMk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=c9_trpwJNCI:gAvXxv_hpMk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=c9_trpwJNCI:gAvXxv_hpMk:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=c9_trpwJNCI:gAvXxv_hpMk:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=c9_trpwJNCI:gAvXxv_hpMk: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/c9_trpwJNCI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/take-my-money-fix-your-mobile-website/feed</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/take-my-money-fix-your-mobile-website?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=take-my-money-fix-your-mobile-website</feedburner:origLink></item>
		<item>
		<title>What Can Social Media Do For You?</title>
		<link>http://feedproxy.google.com/~r/seerinteractive/dndP/~3/lLMdXrHYhBw/what-can-social-media-do-for-you</link>
		<comments>http://www.seerinteractive.com/blog/what-can-social-media-do-for-you#comments</comments>
		<pubDate>Tue, 31 Jan 2012 18:01:56 +0000</pubDate>
		<dc:creator>Melissa Alam</dc:creator>
				<category><![CDATA[business thoughts]]></category>
		<category><![CDATA[SEO]]></category>
		<category><![CDATA[social media]]></category>
		<category><![CDATA[google plus]]></category>
		<category><![CDATA[seerqanda]]></category>
		<category><![CDATA[seochat]]></category>
		<category><![CDATA[Social Media]]></category>
		<category><![CDATA[twitter]]></category>

		<guid isPermaLink="false">http://www.seerinteractive.com/?p=8147</guid>
		<description><![CDATA[The SEO team here at SEER Interactive was proud to host our first #SEERQandA session via our Google+ page this past Wednesday, January 25th. What resulted was an hour full of rapid-fire SEO questions and answers from users all over the world interested in learning more about our industry and company. Read below for some [...]]]></description>
			<content:encoded><![CDATA[<p>The SEO team here at SEER Interactive was proud to host our first <a href="https://twitter.com/#!/search/seerqanda">#SEERQandA</a> session via our <a href="https://plus.google.com/u/0/b/110773419613073577531/110773419613073577531/posts">Google+ page</a> this past Wednesday, January 25<sup>th</sup>. What resulted was an hour full of rapid-fire SEO questions and answers from users all over the world interested in learning more about our industry and company. Read below for some of our top questions and answers on best practices for SEO, the SEO culture in a small business, and site audits! For the full thread, please view it <a href="https://plus.google.com/110773419613073577531/posts/BpkQLuvpU16">here</a>!</p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;</p>
<p><em><strong><a href="https://plus.google.com/115806047742629766262/posts">Ed Fry</a></strong>  -  Two burning questions about SEO for online marketplaces where users are creating listings where users buy and sell products. So here goes:</em></p>
<p><em>1. When a listing expires (e.g. product runs out permanently) should you 301 or rel-canonical, and point the result to either the users profile or back to a category page (the one you want to rank) based on link juice, optimal user experience and appeasing Matt Cutts. :]</em></p>
<p><em>2. How do you try and rank for competitive terms if you&#8217;re a marketplace and you&#8217;d <strong>really</strong> like to rank in one country where you have lots of users (e.g. the UK) without ranking in another country where you don&#8217;t have as many users (for instance, you haven&#8217;t got critical mass of sellers in the USA, and the USA is really several different markets &#8211; East Coast vs. West Coast if the product is really local). And no, we don&#8217;t have the budget or resources for the multiple TLD&#8217;s and hustling across every country :( Any advice?!?</em></p>
<p><em><strong><a href="https://plus.google.com/105378806328377750709/posts">Wil Reynolds</a></strong>  -  +<a href="https://plus.google.com/115806047742629766262/">Ed Fry</a> thanks for coming out and supporting us&#8230;You are asking the tough questions. So here is my take&#8230; I am a bigger fan of 301&#8242;s than anything just because they are tried and true. +<a href="https://plus.google.com/111294201325870406922/posts">Rand Fishkin</a> has done more research than I have on how they pass juice. The one thing I wonder about is how does 301&#8242;ing vs canonicaling impact social signals for a product (I know that 301&#8242;s don&#8217;t pass vote value) but let’s say that as Google starts using Google +1&#8242;s to value pages, then I bet you a canonical is better because you keep the social voting juice and push the link juice as well. I think as long as the 301 is on topic our buddy Matt Cutts would be OK with it. That is a great question, cc: +<a href="https://plus.google.com/100933086719320173845">Mike Essex</a> +<a href="https://plus.google.com/113402335971622689523">Dana Lookadoo</a></em></p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;</p>
<p><em><strong><a href="https://plus.google.com/100390137279560104405/posts">Andrew Dunkle</a></strong>  -  Do you guys have any advice for developing an effective SEO culture in a small business? We have a team of 8 and I&#8217;m looking for ways to get everyone involved in the process so important SEO related decisions are understood by everyone. Thanks!</em></p>
<p><em><strong><a href="https://plus.google.com/107668176051260472765/posts">Adam Melson</a></strong>  -  +<a href="https://plus.google.com/100390137279560104405">Andrew Dunkle</a> Love this question. It&#8217;s totally important to get this across your developers, PR person, President, etc. Everyone has to get on the same page as to why SEO is important and what you&#8217;re working toward. </em><em>This can be shown to the web devs by showing them the impact of a page that was optimized. It helps get more conversions &amp; doesn&#8217;t have to take forever. </em><em>The PR person can start linking in releases and they&#8217;ll also be tracking who picks up the release and might have a contact at that website to get links in there if they were taken out during distribution. </em><em>Copywriters can be briefed on different keywords they will want to include in their copy so that their articles/blog posts/pages get more visibility. The ego stroke is always a great route and if their content gets more eyes, your company gets more eyes. </em><em>If there are 2-3 big keywords that you know are your money makers, share these as a goal with the team. Share that it&#8217;s important to have them rank. Maybe show how these keywords convert in PPC and the actual value of a sale. If you can save the cost of paying per click, it makes the company stronger, job security stronger, but more importantly it shows people that what they&#8217;re doing for SEO contributes to the bottom line of a company. </em><em>If people are having trouble understanding why SEO goals are important, everyone can relate to dollars. </em><em>&#8220;We need to get this SEO recommendation implemented because it could get us moved from #5 to #4&#8243; isn&#8217;t motivating. &#8220;We need to get this SEO recommendation implemented because if we move from #5 to #4, it could bring in another $10k over the course of the year. Do you have an hour to implement?&#8221; is much more motivating.</em></p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;</p>
<p><em><strong><a href="https://plus.google.com/113277159342362003652/posts">Cleo Kirkland</a></strong>  -  Hi all, What&#8217;s your process for a technical site audit? What are the top 10 errors you look for, how do you find them, and what tools do you use? I come from a link building and copywriting background, so trouble shooting site indexation issues is a bit foreign to me. Thanks!</em></p>
<p><em><strong><a href="https://plus.google.com/116668909172855935913/posts">Rachael Gerson</a></strong>  -  +<a href="https://plus.google.com/113277159342362003652">Cleo Kirkland</a> We have some basic starting processes, but every site ends up being different, so part of the plan needs to be flexibility. We may start an audit only to find there&#8217;s an issue with this particular site that we haven&#8217;t seen in hundreds of sites previously.</em><br />
<em> Some basic things to look for:</em><br />
<em> * Is the site content spiderable to the search engines? Try spider simulators like <a href="http://www.webconfs.com/search-engine-spider-simulator.php">http://www.webconfs.com/search-engine-spider-simulator.php</a>.</em><br />
<em> * Is the navigation spiderable? The Web Developer Toolbar (<a href="https://addons.mozilla.org/en-US/firefox/addon/web-developer/">https://addons.mozilla.org/en-US/firefox/addon/web-developer/</a>) is an absolute favorite. Get it for Firefox and Chrome, b/c Chrome is missing the ability to disable JavaScript. Do basic things like checking out Google&#8217;s text-only cache of a page. </em><br />
<em> * Do you have redirect issues on the site? We had a client previously on a platform that 302 redirected every single link on the site to another URL. Since 302 redirects tell the search engines the redirects were temporary, the actual pages weren&#8217;t being picked up. The platform couldn&#8217;t be edited. If the site was/is redesigned, make sure there&#8217;s a redirect strategy in place. My favorite redirect checker is <a href="http://gsitecrawler.com/tools/Server-Status.aspx">http://gsitecrawler.com/tools/Server-Status.aspx</a>.</em><br />
<em> * Using the same tool, check to make sure that either <a href="http://domain.com/">http://domain.com</a> 301 redirects to <a href="http://www.domain.com/">http://www.domain.com</a>, or vice versa.</em><br />
<em> * Make sure 404 pages actually return a 404 server status. </em><br />
<em> * Go through Google Webmaster Tools. Find the errors, figure out how to resolve.</em><br />
<em> * Review the robots.txt. Are pages being blocked that shouldn&#8217;t be? This can be a huge issue!</em><br />
<em> * Are there duplicate pages/domains/subdomains? Would a multi-faceted navigation make more sense for the site? </em><br />
<em> * Do they have basic things like HTML &amp; XML sitemaps? </em><br />
<em> * Check for pagination issues, mistakes with canonical tags, etc.</em></p>
<p><em> Pausing my response here b/c just got a note that you were already answered&#8230; :)</em></p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;</p>
<p><span style="text-decoration: underline"><strong>Now what does this all mean?</strong></span></p>
<p>Besides the 100+ comments we received and an admirable attempt at justifying having a Google+ page, what we noticed more was the increase in our overall social media following. Here at SEER, I help manage the many social media accounts we have and find myself always looking for innovative ways to increase our fans and followers. We know that as a company, we have extremely valuable insight in both the SEO and PPC worlds, and we want people to know our thoughts and opinions! Hosting this G+ Q&amp;A gave us exactly the push that we were looking for! Using our lunch break on a Wednesday afternoon, we were able to boost our name virally for an all-time high of 63 mentions and gain over 1% more followers (and beat our competitor&#8217;s follower growth that day)! Using <a href="http://www.seomoz.org/blog/introducing-social-analytics-in-seomoz-pro">SEOmoz&#8217;s Social Dashboard</a> (which I highly recommend), the below two graphs highlight my exact enthusiasm (SEER is represented as the green line in the Follower Growth graph and competitors are represented as the red, blue and purple lines, respectively).</p>
<div class="mceTemp mceIEcenter" style="text-align: center">
<dl>
<dt><a href="http://www.seerinteractive.com/blog/what-can-social-media-do-for-you/interactions_over_time" rel="attachment wp-att-8151"><img class=" wp-image-8151 " src="http://www.seerinteractive.com/wp-content/uploads/2012/01/Interactions_Over_Time-570x296.png" alt="" width="570" height="296" /></a></dt>
<dd><strong>Interactions from the past 30 Days</strong></dd>
</dl>
</div>
<p>&nbsp;</p>
<div class="mceTemp mceIEcenter" style="text-align: center">
<dl>
<dt><a href="http://www.seerinteractive.com/blog/what-can-social-media-do-for-you/follower_growth" rel="attachment wp-att-8150"><img class="size-large wp-image-8150" src="http://www.seerinteractive.com/wp-content/uploads/2012/01/Follower_Growth-570x280.png" alt="" width="570" height="280" /></a></dt>
<dd><strong>Follower Growth from the past 30 days</strong></dd>
</dl>
</div>
<p><span style="text-decoration: underline"><strong>In Conclusion</strong></span></p>
<p>Now, looking back, I see that our first Q&amp;A session was a huge success. We were able to inspire people with our knowledge and our creativity using Google+, all while enabling new benchmarks for our future social media efforts. My simple and quick words of advice for other small (or large) businesses that are trying to actively increase their presence online is to be provide knowledge or actionable items for your users, think of creative ways to invite and include your audience and have fun! I hope to continue learning more about social media and implementing new trends for SEER, but as for now, stay tuned for our next #SEERQandA session coming up in early February! We&#8217;ll be switching things up with SEO and PPC-themed discussions, so bring out your best questions and let&#8217;s rock and roll.</p>
<p>I&#8217;d love to hear about your social media successes and failures! Follow me <a href="https://twitter.com/#!/melissa_alam">@Melissa_Alam</a> and fill me in!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=lLMdXrHYhBw:7FJDvIjBB40: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=lLMdXrHYhBw:7FJDvIjBB40:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=lLMdXrHYhBw:7FJDvIjBB40:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=lLMdXrHYhBw:7FJDvIjBB40:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/seerinteractive/dndP?i=lLMdXrHYhBw:7FJDvIjBB40:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/seerinteractive/dndP?a=lLMdXrHYhBw:7FJDvIjBB40: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/lLMdXrHYhBw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.seerinteractive.com/blog/what-can-social-media-do-for-you/feed</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://www.seerinteractive.com/blog/what-can-social-media-do-for-you?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=what-can-social-media-do-for-you</feedburner:origLink></item>
	</channel>
</rss>

