<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2dutchfull.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>André Scholten</title> <link>http://andrescholten.net</link> <description>André Scholten about SEO, Site Speed and Google Analytics</description> <lastBuildDate>Fri, 17 Feb 2012 08:48:42 +0000</lastBuildDate> <language>en</language> <sy:updatePeriod>hourly</sy:updatePeriod> <sy:updateFrequency>1</sy:updateFrequency> <generator>http://wordpress.org/?v=3.3.1</generator> <xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" /> <feedburner:info uri="andrescholten" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://andrescholten.nl/index.php/feed/" /><feedburner:feedFlare href="http://add.my.yahoo.com/rss?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://us.i1.yimg.com/us.yimg.com/i/us/my/addtomyyahoo4.gif">Subscribe with My Yahoo!</feedburner:feedFlare><feedburner:feedFlare href="http://www.newsgator.com/ngs/subscriber/subext.aspx?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.newsgator.com/images/ngsub1.gif">Subscribe with NewsGator</feedburner:feedFlare><feedburner:feedFlare href="http://www.bloglines.com/sub/http://andrescholten.nl/index.php/feed/" src="http://www.bloglines.com/images/sub_modern11.gif">Subscribe with Bloglines</feedburner:feedFlare><feedburner:feedFlare href="http://www.netvibes.com/subscribe.php?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.netvibes.com/img/add2netvibes.gif">Subscribe with Netvibes</feedburner:feedFlare><feedburner:feedFlare href="http://fusion.google.com/add?feedurl=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://buttons.googlesyndication.com/fusion/add.gif">Subscribe with Google</feedburner:feedFlare><feedburner:feedFlare href="http://www.pageflakes.com/subscribe.aspx?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.pageflakes.com/ImageFile.ashx?instanceId=Static_4&amp;fileName=ATP_blu_91x17.gif">Subscribe with Pageflakes</feedburner:feedFlare><feedburner:feedFlare href="http://www.plusmo.com/add?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://plusmo.com/res/graphics/fbplusmo.gif">Subscribe with Plusmo</feedburner:feedFlare><feedburner:feedFlare href="http://my.feedlounge.com/external/subscribe?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://static.feedlounge.com/buttons/subscribe_0.gif">Subscribe with FeedLounge</feedburner:feedFlare><feedburner:feedFlare href="http://www.thefreedictionary.com/_/hp/AddRSS.aspx?http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://img.tfd.com/hp/addToTheFreeDictionary.gif">Subscribe with The Free Dictionary</feedburner:feedFlare><feedburner:feedFlare href="http://www.bitty.com/manual/?contenttype=rssfeed&amp;contentvalue=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.bitty.com/img/bittychicklet_91x17.gif">Subscribe with Bitty Browser</feedburner:feedFlare><feedburner:feedFlare href="http://www.newsalloy.com/?rss=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.newsalloy.com/subrss3.gif">Subscribe with NewsAlloy</feedburner:feedFlare><feedburner:feedFlare href="http://www.live.com/?add=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://tkfiles.storage.msn.com/x1piYkpqHC_35nIp1gLE68-wvzLZO8iXl_JMledmJQXP-XTBOLfmQv4zhj4MhcWEJh_GtoBIiAl1Mjh-ndp9k47If7hTaFno0mxW9_i3p_5qQw">Subscribe with Live.com</feedburner:feedFlare><feedburner:feedFlare href="http://mix.excite.eu/add?feedurl=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://image.excite.co.uk/mix/addtomix.gif">Subscribe with Excite MIX</feedburner:feedFlare><feedburner:feedFlare href="http://www.yourminis.com/subscribe.aspx?u=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.yourminis.com/images/addtoyourminisbadge.gif">Subscribe with Yourminis.com</feedburner:feedFlare><feedburner:feedFlare href="http://download.attensa.com/app/get_attensa.html?feedurl=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.attensa.com/blogs/attensa/WindowsLiveWriter/BadgeredintoBadges_10C02/attensa_feed_button5.gif">Subscribe with Attensa for Outlook</feedburner:feedFlare><feedburner:feedFlare href="http://www.webwag.com/wwgthis.php?url=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.webwag.com/images/wwgthis.gif">Subscribe with Webwag</feedburner:feedFlare><feedburner:feedFlare href="http://hub.netomat.net/account/account.autoSubscribe.jspa?urls=http%3A%2F%2Fandrescholten.nl%2Findex.php%2Ffeed%2F" src="http://www.netomat.net/blogger/images/icon_netomat_feedbutton.gif">Subscribe with netomat Hub</feedburner:feedFlare><item><title>Why I love the new Goal Flows in Google Analytics</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/-vNEZm6C0yk/</link> <comments>http://andrescholten.net/why-i-love-the-new-goal-flows-in-google-analytics/#comments</comments> <pubDate>Wed, 15 Feb 2012 13:05:32 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[flows]]></category> <category><![CDATA[funnels]]></category> <category><![CDATA[goals]]></category> <category><![CDATA[google analytics]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1314</guid> <description><![CDATA[Last October Google added a cool feature to their Analytics suite called Goal Flows. That feature is really amazing and helped my find a lot of 'problems' in several sites. Back in the old days we had the old funnel that looked like this: Problems It was a very helpful funnel that provided some insights [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-en-offline-conversies-cr/' rel='bookmark' title='Google Analytics en offline conversies (CRM)'>Google Analytics en offline conversies (CRM)</a> <small>Het komt wel eens voor dat een conversie nog niet...</small></li><li><a href='http://andrescholten.net/google-analytics-visits-per-page/' rel='bookmark' title='Google Analytics visits per page'>Google Analytics visits per page</a> <small>What do you do if you want to know how...</small></li><li><a href='http://andrescholten.net/waarom-is-de-site-overlay-in-google-analytics-stuk/' rel='bookmark' title='Waarom is de Site Overlay in Google Analytics stuk?'>Waarom is de Site Overlay in Google Analytics stuk?</a> <small>Er wordt mij vaak gevraagd waarom de Site Overlay functie...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Last October Google added a cool feature to their Analytics suite called <a href="http://analytics.blogspot.com/2011/10/introducing-flow-visualization.html">Goal Flows</a>. That feature is really amazing and helped my find a lot of 'problems' in several sites. Back in the old days we had the old funnel that looked like this:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2012/02/oldfunnel.png" alt="" title="oldfunnel" width="308" height="329" class="alignnone size-full wp-image-1315" /></div><h2>Problems</h2><p>It was a very helpful funnel that provided some insights in the way people went through an ordering process. But there were also some huge problems with this funnel:</p><p><span id="more-1314"></span></p><ul><li>People going from step 2 to step 1 to step 3 and then converted were simply counted as going from 1 to 2 to 3 to the thank-you page.</p><li>People going from step 1 to step 3 and then converted were <strong>added to step 2</strong> to simply 'fix' the funnels' numbers.<li>The <strong>"required step"</strong> option only works in the funnel view for a goal and not for that goal in other reports. The funnel could look as if it had 100 conversions whether the site had 1000 conversions for the same goal.<li>If people went from step 1 to 2 to 1 to 2 to 1 to 2 and converted they were <strong>counted once</strong> for each step.<li><strong>Segmentation</strong> on funnels wasn't possible, the only way to create something like that is by using <a href="http://www.lunametrics.com/blog/2010/06/04/segment-goal-funnel-google-analytics/">horizontal funnels</a></ul><p>The second mentioned 'fix' was also a problem if you have a funnel were the second step is optional. You would suspect to see people exit in step 1 to return in step 3 rather than being counted in step 2 were they have never been. Therefore optional steps are almost impossible to analyse in the old funnels.</p><h2>New funnels called Goal Flows</h2><p>But now we have Goal Flows *insert magical music*! First, take a look at this screenshot I took:</p><div style="text-align:center"><a href="http://newcdn.andrescholten.net/wp-content/uploads/2012/02/goalflow.png"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2012/02/goalflow-550x165.png" alt="" title="goalflow" width="550" height="165" class="alignnone size-medium wp-image-1316" /></a></div><p>It's a typical funnel with 5+ steps in it. And I want to highlight 2 cool things you can see here (marked purple):</p><ol><li>You see the purple arrow above step 2? That line represents the people that skipped step 2 in this funnel. So in stead of adding them to step 2 they <strong>go around step 2</strong>. It could be a registration step that people can skip if they want to order as a guest, for example.</p><li>The second arrow after step 5 shows you the people that <strong>went back to step 4</strong>. Perhaps they wanted to change some things before continuing to step 6, we were never able to see that before.</ol><p>This new visualization gives you a much better insight in the way people move through your funnels. The steps can also be segmented to see if some groups are behaving different than suspected. And if you want to zoom in on a specific step to analyse exit behavior for that step you can easily choose "Explore traffic through here":</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2012/02/explorestep.png" alt="" title="explorestep" width="405" height="268" class="alignnone size-full wp-image-1318" /></div><h2>Tips</h2><p>A few simple tips I want to give:</p><ul><li>If you set up a new funnel be sure you include optional steps, they are presented in a nice way</p><li>Segment your funnel for several browsers or resolutions to see if some stay behind in CTR, that could indicate a usability or script error<li>Analyse each step and zoom in to get an idea about what is happening there<li>Test, test, test</ul><p>What do you think? Anyone got some really cool insights to share?</p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-en-offline-conversies-cr/' rel='bookmark' title='Google Analytics en offline conversies (CRM)'>Google Analytics en offline conversies (CRM)</a> <small>Het komt wel eens voor dat een conversie nog niet...</small></li><li><a href='http://andrescholten.net/google-analytics-visits-per-page/' rel='bookmark' title='Google Analytics visits per page'>Google Analytics visits per page</a> <small>What do you do if you want to know how...</small></li><li><a href='http://andrescholten.net/waarom-is-de-site-overlay-in-google-analytics-stuk/' rel='bookmark' title='Waarom is de Site Overlay in Google Analytics stuk?'>Waarom is de Site Overlay in Google Analytics stuk?</a> <small>Er wordt mij vaak gevraagd waarom de Site Overlay functie...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/-vNEZm6C0yk" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/why-i-love-the-new-goal-flows-in-google-analytics/feed/</wfw:commentRss> <slash:comments>5</slash:comments> <feedburner:origLink>http://andrescholten.net/why-i-love-the-new-goal-flows-in-google-analytics/</feedburner:origLink></item> <item><title>Tracking outbound links? I bet you only measure 70 percent</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/wPgR0HUc2zU/</link> <comments>http://andrescholten.net/tracking-outbound-links-i-bet-you-only-measure-70/#comments</comments> <pubDate>Fri, 27 Jan 2012 09:34:42 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[Webdevelopment]]></category> <category><![CDATA[events]]></category> <category><![CDATA[links]]></category> <category><![CDATA[measure]]></category> <category><![CDATA[outgoing links]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1213</guid> <description><![CDATA[A lot of site owners want to track outbound links so they can see how often they are clicked. It's also useful to see when and where people left your site. Google Analytics knows the exit time of your last page, where in normal cases the last visited page is not counted in the spend [...] Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/inkomende-links-volgens-google-live-en-yahoo/' rel='bookmark' title='Inkomende links volgens Google, Live en Yahoo'>Inkomende links volgens Google, Live en Yahoo</a> <small>Ik zag dat Live Search inmiddels het link: commando min...</small></li><li><a href='http://andrescholten.net/uitgaande-links-simpel-meten-met-google-analytics/' rel='bookmark' title='Uitgaande links simpel meten met Google Analytics'>Uitgaande links simpel meten met Google Analytics</a> <small>Soms kan het best handig zijn om te zien welke...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>A lot of site owners want to track outbound links so they can see how often they are clicked. It's also useful to see when and where people left your site. Google Analytics knows the exit time of your last page, where in normal cases the last visited page is not counted in the spend time on site/page.</p><p>But, there is a big but. A lot of outbound link tracking is done like this:</p><pre class="brush: xml; title: ; notranslate">&lt;a href=&quot;http://andrescholten.net&quot; onclick=&quot;trackClick(this)&quot;&gt;Nice site&lt;/a&gt;</pre><p>And this is what happens when you click on this outbound link:</p><ol><li>The onclick is executed first</li><li>The trackClick function generates an IMG element with a URL that points to the Web Analytics vendor</li><li>The onclick function is handled and the browser starts with the href part</li></ol><p>And then the race starts:<br /> <span id="more-1213"></span></p><ul><li>The tracking pixel is requested from the Web Analytics vendor</li><li>The browser kills all activity and opens the URL in the href attribute</li></ul><p>But we can't tell which one is first. A small delay on the Web Analytics vendor side is deadly for the tracking, often the pixel request is killed by the browser. You can see this in a simple tool that shows you all activity in your browser. Because Yoasts' post is was the trigger to blog this I will use his site as an example.</p><p>Take a look at his <a href="http://yoast.com/tracking-outbound-affiliate-links-with-getclicky/">Clicky outbound link tracking</a> post. It has an outbound link in the first sentence. And this happens when I'm clicking it:</p><p><a href="http://newcdn.andrescholten.net/wp-content/uploads/2012/01/clickouts.png"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2012/01/clickouts-550x82.png" alt="" title="clickouts" width="550" height="82" class="aligncenter size-medium wp-image-1226" /></a></p><p>The first two lines are the main Clicky script with all tracking functionality and the basic pageview measurement. The third line is the outbound link tracking: in this case the tracking is send. The line is red because the browser stops waiting for the response, but that isn't necessary for the tracking. Sometimes this line isn't generated and no tracking is done...</p><h2>A solution</h2><p>In the post title I mentioned 70%, but that's merely a guess based on what I have seen in cases where I solved this. After implementing a little timeout before the link opens we saw a lot more outgoing links being measured. I already mentioned the solution: a little timeout to give the tracing some time to execute before the link opens.</p><p>But there are a few caveats using this technique:</p><ul><li>Using "window.open" triggers the popup blocker of Internet Explorer 9+. That's because the link is opened with a script in stead of a user initiated click. We have to use location.href to prevent that from happening.</p><li>Using "location.href" doesn't pass on referrer information in Internet Explorer 6, 7 and 8. External site won't see traffic coming from you.</ul><p>This is de jQuery code I use right now to track outgoing links:</p><pre class="brush: jscript; title: ; notranslate">if(typeof jQuery == 'function')
{
  jQuery(function ()
  {
    jQuery('a[href^=&quot;http&quot;]').click(function (e)
    {
      var url = this.toString();
      if (url.indexOf(document.domain) == -1)
      {
        _gaq.push(['_trackEvent', 'clickouts', jQuery(this).attr('href').replace(/https?:\/\/(.*)/,&quot;$1&quot;)]);
        var target = jQuery(this).attr('target');
        if (target == &quot;&quot;) { target = &quot;_self&quot;; }
        setTimeout(function()
        {
          var a = document.createElement(&quot;a&quot;);
          if ((!a.click) || ((jQuery.browser.msie) &amp;&amp; (parseInt(jQuery.browser.version) &gt; 8))) {
            location.href = url; // for chrome and IE9+, target is lost
          } else {
            a.setAttribute(&quot;href&quot;, url);
            a.setAttribute(&quot;target&quot;, target);
            a.style.display = &quot;none&quot;;
            aElm = document.body.appendChild(a);
            aElm.click(); //  for IE6,7,8 to pass on referrer
          }
        }, 50); // 50ms should be enough timeout
      }
      e.preventDefault();
    });
  });
};
</pre><p>Is this the best way to track outgoing links? For what I've seen this is one of the best and most reliable approaches. But I'm happy to receive additions that makes it even better.</p><p>Ps. In this example I used Google Analytics to track outgoing links, but you can change that part to whatever tracking you want.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/inkomende-links-volgens-google-live-en-yahoo/' rel='bookmark' title='Inkomende links volgens Google, Live en Yahoo'>Inkomende links volgens Google, Live en Yahoo</a> <small>Ik zag dat Live Search inmiddels het link: commando min...</small></li><li><a href='http://andrescholten.net/uitgaande-links-simpel-meten-met-google-analytics/' rel='bookmark' title='Uitgaande links simpel meten met Google Analytics'>Uitgaande links simpel meten met Google Analytics</a> <small>Soms kan het best handig zijn om te zien welke...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/wPgR0HUc2zU" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/tracking-outbound-links-i-bet-you-only-measure-70/feed/</wfw:commentRss> <slash:comments>3</slash:comments> <feedburner:origLink>http://andrescholten.net/tracking-outbound-links-i-bet-you-only-measure-70/</feedburner:origLink></item> <item><title>How to export more than 500 rows in new Google Analytics interface</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/ykg0HBrzaKo/</link> <comments>http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/#comments</comments> <pubDate>Fri, 25 Nov 2011 15:28:16 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[excel]]></category> <category><![CDATA[export]]></category> <category><![CDATA[google analytics]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1192</guid> <description><![CDATA[Since the start of the new Google Analytics version (V5) we're unable to export more than 500 rows to for instance Excel. I figured there must be a solution to raise that number to 10.000 or more, so I started coding. In the old Google Analytics there was the "&#038;limit=10000" parameter that you could add [...] Related articles:<ol><li><a href='http://andrescholten.net/nieuwe-code-voor-google-analytics-nu-ook-werkend-in-asp/' rel='bookmark' title='Nieuwe code voor Google Analytics nu ook werkend in ASP'>Nieuwe code voor Google Analytics nu ook werkend in ASP</a> <small>Vanwege een te vroege release van de nieuwe Google Analytics...</small></li><li><a href='http://andrescholten.net/google-analytics-tabellen-sorteren-verbeterd/' rel='bookmark' title='Google Analytics tabellen sorteren verbeterd'>Google Analytics tabellen sorteren verbeterd</a> <small>Onlangs werd mij de vraag gesteld of er ook iets...</small></li><li><a href='http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/' rel='bookmark' title='AdWords individuele keyword analyse vanuit Google Analytics'>AdWords individuele keyword analyse vanuit Google Analytics</a> <small>Hoe kun je op een andere manier eens naar het...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Since the start of the new Google Analytics version (V5) we're unable to export more than 500 rows to for instance Excel. I figured there must be a solution to raise that number to 10.000 or more, so I started coding.</p><p>In the old Google Analytics there was the "<a href="http://www.google.com/support/analytics/bin/answer.py?hl=en&#038;answer=159501">&#038;limit=10000</a>" parameter that you could add to the export URL. In the new interface you can select the amount of rows below the table:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/11/ga-rows.png" alt="" title="ga-rows" width="385" height="149" class="alignnone size-full wp-image-1193" /></div><p>And after everything is loaded you can export those 500 with the usual export button.<br /> <span id="more-1192"></span></p><h2>The all new and improved method</h2><p>Today I invented (copied) the code that is needed to export more than 500 rows without showing 10.000 rows on your screen first (<a href="http://www.google.com/support/analyticshelp/bin/answer.py?answer=1038573">as explained here</a>). Create a bookmark and set this as the URL:</p><p><code>javascript:function post_andre(params){var form = document.createElement("form"); form.setAttribute("method","post"); form.setAttribute("action","exportReport"); for(var key in params){var hiddenField = document.createElement("input"); hiddenField.setAttribute("type","hidden"); hiddenField.setAttribute("name",key); hiddenField.setAttribute("value",params[key]); form.appendChild(hiddenField);} document.body.appendChild(form);form.submit();}var rowcount=prompt("Amount of rows (10-10000):","100"); hashes=unescape(location.hash).split("/"); date0=hashes[3].substr(hashes[3].indexOf(".date00")+8,8); date1=hashes[3].substr(hashes[3].indexOf(".date01")+8,8); post_andre({'_.date00':date0, '_.date01':date1, 'explorer-table.rowStart':'0', 'explorer-table.rowCount':rowcount+'', 'id':hashes[1], 'ds':hashes[2], 'ef':'TSV', 'exportUrl':location.href});</code></p><p>When you click on the bookmark it will ask you how many rows you want, and the download starts rightaway.</p><p>Notes: for now only the TSV format works, and it's only tested in Firefox and Chrome on several reports. No guarantees <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>Related articles:<ol><li><a href='http://andrescholten.net/nieuwe-code-voor-google-analytics-nu-ook-werkend-in-asp/' rel='bookmark' title='Nieuwe code voor Google Analytics nu ook werkend in ASP'>Nieuwe code voor Google Analytics nu ook werkend in ASP</a> <small>Vanwege een te vroege release van de nieuwe Google Analytics...</small></li><li><a href='http://andrescholten.net/google-analytics-tabellen-sorteren-verbeterd/' rel='bookmark' title='Google Analytics tabellen sorteren verbeterd'>Google Analytics tabellen sorteren verbeterd</a> <small>Onlangs werd mij de vraag gesteld of er ook iets...</small></li><li><a href='http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/' rel='bookmark' title='AdWords individuele keyword analyse vanuit Google Analytics'>AdWords individuele keyword analyse vanuit Google Analytics</a> <small>Hoe kun je op een andere manier eens naar het...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/ykg0HBrzaKo" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/feed/</wfw:commentRss> <slash:comments>21</slash:comments> <feedburner:origLink>http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/</feedburner:origLink></item> <item><title>Google Analytics event tracking not affecting bouncerate?</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/MhMtUgQAmkE/</link> <comments>http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/#comments</comments> <pubDate>Fri, 21 Oct 2011 07:56:58 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[bouncerate]]></category> <category><![CDATA[events]]></category> <category><![CDATA[google analytics]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1178</guid> <description><![CDATA[With the new release of ga.js this is possible. In the old days a fired event immediately after a trackPageview would cause Google Analytics to report a 0% bouncerate for that visit. But sometimes you don't want that behavior because the event is not always triggered by the visitor. For instance: I track page load [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/een-lage-bouncerate-door-het-gebruik-van-setvar/' rel='bookmark' title='Een lage bouncerate door het gebruik van setvar?'>Een lage bouncerate door het gebruik van setvar?</a> <small>Heb je wel eens gezien dat je weigeringspercentage of ook...</small></li><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>With the <a href="http://code.google.com/apis/analytics/community/gajs_changelog.html">new release of ga.js</a> this is possible. In the old days a fired event immediately after a trackPageview would cause Google Analytics to report a 0% bouncerate for that visit. But sometimes you don't want that behavior because the event is not always triggered by the visitor.</p><p>For instance: I track <a href="http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/">page load times</a> the same way Google Analytics does, but in an unsampled way (Google only meausures 10%). To do that I fire an event immediately after the trackPageview, but I do that in another profile with a different UA-XXXX-Y number so it won't affect my bouncerates. But now we have <a href="http://code.google.com/apis/analytics/docs/gaJS/gaJSApiEventTracking.html">an extra parameter</a>:</p><p><code>_trackEvent(category, action, opt_label, opt_value, <strong>opt_noninteraction</strong>)</code></p><p>If you set this opt_noninteraction (boolean) to true it wil not affect bouncerates!!! That makes it possible to:<br /> <span id="more-1178"></span></p><ul><li>Measure page load times without affecting bouncerate</li><li>Measure banner rotations on a homepage without affecting bouncerate</li><li>Measure mouse coordinates to create heatmaps without affecting bouncerate</li><li>Etc.</li></ul><p>Awesome. Don't you think? It saves me a lot of profiles because I can track all events in 1 profile now.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/een-lage-bouncerate-door-het-gebruik-van-setvar/' rel='bookmark' title='Een lage bouncerate door het gebruik van setvar?'>Een lage bouncerate door het gebruik van setvar?</a> <small>Heb je wel eens gezien dat je weigeringspercentage of ook...</small></li><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/MhMtUgQAmkE" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/feed/</wfw:commentRss> <slash:comments>3</slash:comments> <feedburner:origLink>http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/</feedburner:origLink></item> <item><title>Google starts hiding SEO keywords for privacy, but AdWords unaffected?</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/8xwRRkdiZ_c/</link> <comments>http://andrescholten.net/google-starts-hiding-seo-keywords-for-privacy-but-adwords-unaffected/#comments</comments> <pubDate>Tue, 18 Oct 2011 19:37:24 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[SEO]]></category> <category><![CDATA[analytics]]></category> <category><![CDATA[google]]></category> <category><![CDATA[https]]></category> <category><![CDATA[privacy]]></category> <category><![CDATA[seo]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1170</guid> <description><![CDATA[I can't believe it. Google just announced a new 'feature' for their search results pages. If a user is logged in he will be redirected to the secure (SSL) version of their search engine. The main reason (so they claim) is the user's privacy... when a user does a search and navigates to a site, [...] Related articles:<ol><li><a href='http://andrescholten.net/adwords-metingen-google-analytics-gestopt-op-9-januari/' rel='bookmark' title='Adwords metingen Google Analytics gestopt op 9 januari?'>Adwords metingen Google Analytics gestopt op 9 januari?</a> <small>Update: probleem opgelost. Het lijkt er op dat er iets...</small></li><li><a href='http://andrescholten.net/adwords-conversion-tracker-vs-google-analytics-vanwaar-het-verschil/' rel='bookmark' title='Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?'>Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?</a> <small>Waarom zijn de cijfers in Google Analytics anders dan in...</small></li><li><a href='http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/' rel='bookmark' title='AdWords individuele keyword analyse vanuit Google Analytics'>AdWords individuele keyword analyse vanuit Google Analytics</a> <small>Hoe kun je op een andere manier eens naar het...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>I can't believe it. Google just announced a new '<a href="http://analytics.blogspot.com/2011/10/making-search-more-secure-accessing.html">feature</a>' for their search results pages. If a user is logged in he will be redirected to the secure (SSL) version of their search engine. The main reason (so they claim) is the user's privacy... when a user does a search and navigates to a site, that site will only be able to see it's a visitor from Google Organic...yes, without the keyword.</p><p>Why does this suck?</p><ul><li>If Google really had a clear focus on a user's privacy they also wouldn't send the keyword along with an <strong>AdWords</strong> click (as <a href="http://twitter.com/#!/yoast/status/126362846559879168">Yoast tweets</a>). Right now only half of the results are privacy-protected and the other (paid) half not.</p><li>Google claims it will not affect a lot of users, that could be right <strong>on average</strong>. But for some sites a lot of their target groups are logged in to their Google Analytics, Google Reader, Youtube, Gmail, etc. All those visitors will also be logged in on the search results, and that could mean serious loss of information about the used keywords.</ul><p><span id="more-1170"></span></p><p>What are the alternatives? The data provided by the Google Webmaster Tools is way off (as <a href="http://twitter.com/#!/chapter42/status/126367565302857728">Roy tweets</a>), and I agree. I guess we have to rely more on the trends we see based on our actions. But as most SEO's know: diving deep into the data is a must to get a good grip on improvement. It's not all about trends. Also some behavioral targeting tools won't work a 100% anymore if you want to target specific keyword groups.</p><p>There's one advantage: if you search secure through a WiFi connection it's harder for bad persons to be able to retrieve what you where searching for.</p><p>What do you think about these changes? Positive, negative? I have a feeling that this change is for other reasons than they claim.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/adwords-metingen-google-analytics-gestopt-op-9-januari/' rel='bookmark' title='Adwords metingen Google Analytics gestopt op 9 januari?'>Adwords metingen Google Analytics gestopt op 9 januari?</a> <small>Update: probleem opgelost. Het lijkt er op dat er iets...</small></li><li><a href='http://andrescholten.net/adwords-conversion-tracker-vs-google-analytics-vanwaar-het-verschil/' rel='bookmark' title='Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?'>Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?</a> <small>Waarom zijn de cijfers in Google Analytics anders dan in...</small></li><li><a href='http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/' rel='bookmark' title='AdWords individuele keyword analyse vanuit Google Analytics'>AdWords individuele keyword analyse vanuit Google Analytics</a> <small>Hoe kun je op een andere manier eens naar het...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/8xwRRkdiZ_c" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/google-starts-hiding-seo-keywords-for-privacy-but-adwords-unaffected/feed/</wfw:commentRss> <slash:comments>5</slash:comments> <feedburner:origLink>http://andrescholten.net/google-starts-hiding-seo-keywords-for-privacy-but-adwords-unaffected/</feedburner:origLink></item> <item><title>Live Visual Website Optimizer variant switcher</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/nCJjaG6C1U0/</link> <comments>http://andrescholten.net/live-visual-website-optimizer-variant-switcher/#comments</comments> <pubDate>Thu, 14 Jul 2011 11:59:01 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webdevelopment]]></category> <category><![CDATA[testing]]></category> <category><![CDATA[vwo]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1148</guid> <description><![CDATA[Have you ever launched a multi-variate test with the Visual Website Optimizer. And did you want to review all the variants in the test in all browsers? Or do you want to analyze all the variants another site is testing when you see a VWO test being executed? I bring you the magic With my [...] Related articles:<ol><li><a href='http://andrescholten.net/services/implementing-a-visual-website-optimizer-test/' rel='bookmark' title='Implementing a Visual Website Optimizer test?'>Implementing a Visual Website Optimizer test?</a> <small>That can be a technical hell, I can do that...</small></li><li><a href='http://andrescholten.net/google-website-optimizer-calculator/' rel='bookmark' title='Google Website Optimizer Calculator'>Google Website Optimizer Calculator</a> <small>Een betere variant van de Duurcalculator die Google voor de...</small></li><li><a href='http://andrescholten.net/google-live-search-ask-en-yahoo-ondersteunen-nu-de-sitemap-xml/' rel='bookmark' title='Google, Live Search, Ask en Yahoo ondersteunen nu de Sitemap XML'>Google, Live Search, Ask en Yahoo ondersteunen nu de Sitemap XML</a> <small>En zowaar het is zover: er is een soort van...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Have you ever launched a multi-variate test with the <a href="http://visualwebsiteoptimizer.com/" onclick="location.href='http://visualwebsiteoptimizer.com/?partner=andre'; return false;">Visual Website Optimizer</a>. And did you want to review all the variants in the test in all browsers? Or do you want to analyze all the variants another site is testing when you see a VWO test being executed? I bring you the magic <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> With my new VWO-Variant-Switcher&copy; it's easy to view all variants.</p><h2>How does it work</h2><p>In the toolbars of all my browsers I have this little button:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/07/vwoswitcherbutton.png" alt="" title="vwoswitcherbutton" width="346" height="87" class="alignnone size-full wp-image-1150" /></div><p>When I click on it when I'm on a page that is running a live test this popup shows up:</p><p><span id="more-1148"></span></p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/07/vwoswitcherpopup.png" alt="" title="vwoswitcherpopup" width="249" height="327" class="alignnone size-full wp-image-1151" /></div><p>By altering the combination I can put myself in another variant of the test. Just refresh the page and the chosen combination will show up.</p><h2>How to create this button</h2><p>Create a new bookmark called "VWO Variant Switcher" or whatever name you find suitable. Then edit the URL the bookmark is pointing to:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/07/vwoswitcherbookmark.png" alt="" title="vwoswitcherbookmark" width="384" height="265" class="alignnone size-full wp-image-1149" /></div><p>And change it to:</p><p><code>javascript:var%20names="Combinations%20in%20test:\r\n\r\n"; if(typeof%20_vwo_exp_ids=="object"){for(x%20in%20_vwo_exp[_vwo_exp_ids[0]].comb_n) {names=names+x+"%20=%20"+_vwo_exp[_vwo_exp_ids[0]].comb_n[x]+"\r\n"; }};function%20readCookie(name){var%20nameEQ=name+"="; var%20ca=document.cookie.split(';'); for(var%20i=0;i&lt;ca.length;i++){var%20c=ca[i]; while(c.charAt(0)=='%20')c=c.substring(1,c.length); if(c.indexOf(nameEQ)==0)return%20c.substring(nameEQ.length,c.length); };return%20null;}; if(typeof%20_vis_opt_experiment_id!="undefined"){var%20id=_vis_opt_experiment_id; var%20cv=unescape(readCookie("_vis_opt_exp_"+id+"_combi")); txt=prompt(names+"\r\n\r\nChoose%20combination:",cv); if(txt!=null){_vis_opt_createCookie("_vis_opt_exp_"+id+"_combi",txt,100); }}else{alert("No%20live%20experiment%20on%20this%20page.");}; void(0);</code></p><p>That's all. Enjoy testing and viewing.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/services/implementing-a-visual-website-optimizer-test/' rel='bookmark' title='Implementing a Visual Website Optimizer test?'>Implementing a Visual Website Optimizer test?</a> <small>That can be a technical hell, I can do that...</small></li><li><a href='http://andrescholten.net/google-website-optimizer-calculator/' rel='bookmark' title='Google Website Optimizer Calculator'>Google Website Optimizer Calculator</a> <small>Een betere variant van de Duurcalculator die Google voor de...</small></li><li><a href='http://andrescholten.net/google-live-search-ask-en-yahoo-ondersteunen-nu-de-sitemap-xml/' rel='bookmark' title='Google, Live Search, Ask en Yahoo ondersteunen nu de Sitemap XML'>Google, Live Search, Ask en Yahoo ondersteunen nu de Sitemap XML</a> <small>En zowaar het is zover: er is een soort van...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/nCJjaG6C1U0" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/live-visual-website-optimizer-variant-switcher/feed/</wfw:commentRss> <slash:comments>6</slash:comments> <feedburner:origLink>http://andrescholten.net/live-visual-website-optimizer-variant-switcher/</feedburner:origLink></item> <item><title>Simulate Googles trackPageLoadTime without sampling</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/GTXKKpoMidk/</link> <comments>http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/#comments</comments> <pubDate>Wed, 06 Jul 2011 08:40:37 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Site Speed]]></category> <category><![CDATA[events]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[site speed]]></category> <category><![CDATA[w3c]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1126</guid> <description><![CDATA[A while ago I wrote an article about a method to track page load times in Google Analytics. Short after this article Google came with their own technique to track page load times, but both methods have some disadvantages. To give a clear understanding about the differences I want to show you this image: This [...] Related articles:<ol><li><a href='http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/' rel='bookmark' title='How to prevent Google Analytics sampling data'>How to prevent Google Analytics sampling data</a> <small>We all know the horrible sign in Google Analytics that...</small></li><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li></ol>]]></description> <content:encoded><![CDATA[<p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/03/speedometer.png" alt="" title="speedometer" width="100" height="100" class="alignnone size-full wp-image-1032" style="float:right; margin: 0 0 10px 10px;" />A while ago I wrote an article about a method to track <a href="http://andrescholten.net/track-site-speed-with-google-analytics-events/">page load times in Google Analytics</a>. Short after this article Google came with their own technique to track page load times, but both methods have some disadvantages.</p><p>To give a clear understanding about the differences I want to show you this image:</p><p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/07/timing-overview.png" alt="" title="timing-overview" width="550" height="328" class="alignnone size-full wp-image-1127" /></p><p><span id="more-1126"></span></p><p>This image shows all steps from the beginning of a request for a page to the end. The timing of all these steps are stored in a global javascript object called "performance". And with a simple script you can read out all these timings to calculate the load time. This comes directly from the <a href="http://w3c-test.org/webperf/specs/NavigationTiming/">Navigation Timing</a> specification of the W3C.</p><p>The green line is the timing I measure in the above mentioned article, that means: only the time from when the HTML starts loading until the onload event happens.</p><p>The red line is the timing Google uses to measure page load time in Google Analytics. A much more trustworthy number because it includes server response times. But Google only uses a sample of this data to calculate page load times.</p><p>The best way is a bit of both: the more trustworthy measurement method of Google but without the sampling. That can be done with a simple addition to the Google Analytics tracking script:</p><p><code>if (typeof performance == "object")<br /> {<br /> &nbsp;&nbsp;var loadtiming = parseInt(performance.timing.loadEventStart – performance.timing.fetchStart);<br /> &nbsp;&nbsp;if ((loadtiming > 0) &#038;& (loadtiming < 40))<br /> &nbsp;&nbsp;{<br /> &nbsp;&nbsp;&nbsp;&nbsp;_gaq.push(['timer._setAccount', 'UA-XXXXXX-X'], ['timer._trackPageview'], ['timer._trackEvent','w3c-navigationtiming',location.pathname,,loadtiming]);<br /> &nbsp;&nbsp;}<br /> }<br /> </code></p><p>You can execute this code after the onload so visitors won't be slowed down and be sure to use a <strong>NEW</strong> Google Analytics profile, and not your main profile, it will ruin bouncerate measurements. The loadEvenStart and fetchStart are also the ones Google used in their Google Analytics trackPageLoadTime functions.</p><p>Now there's only a small disadvantage with this script: not all browser are supporting this new "performance" object, right now only Google Chrome supports it. But as Site Speed is becoming more and more important I suspect that other browsers will add it soon.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/' rel='bookmark' title='How to prevent Google Analytics sampling data'>How to prevent Google Analytics sampling data</a> <small>We all know the horrible sign in Google Analytics that...</small></li><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/GTXKKpoMidk" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/feed/</wfw:commentRss> <slash:comments>2</slash:comments> <feedburner:origLink>http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/</feedburner:origLink></item> <item><title>And that is why you need to speed up your site!</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/cw5FALhH80Y/</link> <comments>http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/#comments</comments> <pubDate>Mon, 30 May 2011 18:59:53 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Site Speed]]></category> <category><![CDATA[browser]]></category> <category><![CDATA[connection]]></category> <category><![CDATA[performance]]></category> <category><![CDATA[site speed]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1097</guid> <description><![CDATA[Today I read a great presentation from Joshua Bixby (Strangeloop). He showed a nice way to create a business case for Web Performance Optimization (#wpo). The case is that a slower user experience leads to less revenue, but it's not easy to prove that. What you could do is set up an A/B test with [...] Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/meet-de-snelheid-van-je-site-in-google-analytics/' rel='bookmark' title='Meet de snelheid van je site in Google Analytics'>Meet de snelheid van je site in Google Analytics</a> <small>Breid je Google Analytics rapportages uit met de laadtijden van...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Today I read a great presentation from <a href="http://www.webperformancetoday.com/2011/05/27/web-site-performance-in-business-terms/">Joshua Bixby (Strangeloop)</a>. He showed a nice way to create a business case for Web Performance Optimization (#wpo). The case is that a slower user experience leads to less revenue, but it's not easy to prove that. What you could do is set up an A/B test with a slower page as B variant. The upside is that you can make a business case, the downside is that you will lose revenue. Joshua came up with another option: we already have the <strong>connection speed</strong> and <strong>browser version</strong> in Google Analytics!</p><p>The older browsers and slower connection types have a negative impact on page load times. So they should show us numbers for people with a slower user experience.</p><p><span id="more-1097"></span></p><p>I created a spreadsheet and downloaded the data from lots of clients into this sheet. I segmented them by connection type and browser and calculated the average revenue per visitor. These numbers are based on <strong>206.778.873 visits</strong> that did <strong>€4.540.594.926,86</strong> on revenue. That makes an average of €4.97 per visit.</p><h2>The browsers</h2><p>We all know that Internet Explorer has 3 versions that have improved a lot in time: IE6, IE7 and IE8. And all three of them are still responsible for a lot of visits, although IE6 is losing fast lately. I created three groups and the results are:</p><div style="text-align:center; margin: 0 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/rpv-browsers.png" alt="" title="rpv-browsers" width="460" height="302" class="alignnone size-full wp-image-1098"></div><p>Amazing isn't it? The value per visit goes from €3,59 to €5,45 (a 50% improvement). So please force your customers to update their browsers so they are willing to spend more....or do <strong>we</strong> have to speed up our sites <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><h2>The connections</h2><p>The connection speed is also a major factor in the user experience. A slow dialup connection doesn't make you happy when surfing around a shop that has uncompressed 8MB images online to show their products. Let's see if this is also represented in the numbers:</p><div style="text-align:center; margin: 0 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/rpv-connections.png" alt="" title="rpv-connections" width="460" height="302" class="alignnone size-full wp-image-1099"></div><p>The difference is not as big as the browsers show, but there's still enough impact.</p><h2>Both combined</h2><p>I combined both browsers and connections so see if for example IE6 + Dialup would be the worst performing couple, and yes:</p><div style="text-align:center; margin: 0 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/rpv-browsers-connections.png" alt="" title="rpv-browsers-connections" width="464" height="271" class="alignnone size-full wp-image-1100"></div><p>From left to right the browsers and connections in the order as you would expect. Especially IE6 has a big impact on the numbers, but dialup is not te be ignored also.</p><h2>And now?</h2><p>You have the data.<br /> You can calculate the numbers.<br /> You can create a business case.<br /> <strong>Start optimizing your site!</strong></p><p>The load time of your pages has impact on SEO, AdWords Quality Score, the conversion percentage, server load, pages-per-visit, etc, etc. You <strong>can't afford</strong> to have a slow site.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/meet-de-snelheid-van-je-site-in-google-analytics/' rel='bookmark' title='Meet de snelheid van je site in Google Analytics'>Meet de snelheid van je site in Google Analytics</a> <small>Breid je Google Analytics rapportages uit met de laadtijden van...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/cw5FALhH80Y" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/feed/</wfw:commentRss> <slash:comments>15</slash:comments> <feedburner:origLink>http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/</feedburner:origLink></item> <item><title>Google Analytics cleaned up Customvars but broke reports</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/f1Wv490c4I8/</link> <comments>http://andrescholten.net/google-analytics-cleaned-up-customvars-but-broke-reports/#comments</comments> <pubDate>Thu, 26 May 2011 11:21:13 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[customvars]]></category> <category><![CDATA[google analytics]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1084</guid> <description><![CDATA[A small blogpost about a new version of the ga.js file that was launched a week ago. As you can see they changed the way customvars are being reported: "Fixed a bug in Custom Variables that caused some values to be encoded in reports." Spaces (and other characters) were reported as "%20". So if my [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/services/google-analytics-training/' rel='bookmark' title='Google Analytics training'>Google Analytics training</a> <small>Are you looking for a hands-on Google Analytics training from...</small></li><li><a href='http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/' rel='bookmark' title='How to export more than 500 rows in new Google Analytics interface'>How to export more than 500 rows in new Google Analytics interface</a> <small>Since the start of the new Google Analytics version (V5)...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>A small blogpost about a new version of the ga.js file that was <a href="http://code.google.com/apis/analytics/docs/gaJS/changelog.html">launched</a> a week ago. As you can see they changed the way customvars are being reported:</p><blockquote><p><em>"Fixed a bug in Custom Variables that caused some values to be encoded in reports."</em></p></blockquote><p>Spaces (and other characters) were reported as "%20". So if my name was in a customvar it would look like this:<br /> <span id="more-1084"></span></p><blockquote><p>andre%20scholten</p></blockquote><p>But as of may 18th it's being reported as:</p><blockquote><p>andre scholten</p></blockquote><p>The advantage is that you get cleaner reports with nicer values, but your graph for certain customvars will look like this:</p><div style="text-align:center"> <img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/customvar.png" alt="" title="customvar" width="502" height="165" class="alignnone size-full wp-image-1085" /></div><p>The traffic for the old ones drop, and new customvars will rise. So don't be scared when you miss a specific customvar, just look for the cleaned-up version <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/services/google-analytics-training/' rel='bookmark' title='Google Analytics training'>Google Analytics training</a> <small>Are you looking for a hands-on Google Analytics training from...</small></li><li><a href='http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/' rel='bookmark' title='How to export more than 500 rows in new Google Analytics interface'>How to export more than 500 rows in new Google Analytics interface</a> <small>Since the start of the new Google Analytics version (V5)...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/f1Wv490c4I8" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/google-analytics-cleaned-up-customvars-but-broke-reports/feed/</wfw:commentRss> <slash:comments>1</slash:comments> <feedburner:origLink>http://andrescholten.net/google-analytics-cleaned-up-customvars-but-broke-reports/</feedburner:origLink></item> <item><title>Adobe makes it easy to remove and block Flash cookies</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/xOKGoEsbZRE/</link> <comments>http://andrescholten.net/adobe-makes-it-easy-to-remove-and-block-flash-cookies/#comments</comments> <pubDate>Fri, 20 May 2011 07:37:25 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Internet]]></category> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[adobe]]></category> <category><![CDATA[cookies]]></category> <category><![CDATA[flash]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1068</guid> <description><![CDATA[Adobe is rolling out a new version of their Flash player (10.3) that makes it easy to remove and block your Flash cookies. In the old days (yesterday before my update) we had this menu (right-click on a Flash object): But as of the new update we have an extra option. If you right-click on [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-p3p-iframes-internet-explorer-en-cookies/' rel='bookmark' title='Google Analytics, P3P, iframes, Internet Explorer en cookies'>Google Analytics, P3P, iframes, Internet Explorer en cookies</a> <small>Wat hebben deze termen met elkaar gemeen? Dat de combinaties...</small></li><li><a href='http://andrescholten.net/een-select-element-spiderbaar-maken/' rel='bookmark' title='Een select element spiderbaar maken'>Een select element spiderbaar maken</a> <small>Ook problemen met zoekmachines en een selectbox? Lees hier de...</small></li><li><a href='http://andrescholten.net/frames-toegankelijk-maken-voor-zoekmachines/' rel='bookmark' title='Frames toegankelijk maken voor zoekmachines'>Frames toegankelijk maken voor zoekmachines</a> <small>Frames toegankelijk maken voor zoekmachines, een versimpelde weergave van een...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Adobe is rolling out a new version of their Flash player (10.3) that makes it easy to remove and block your Flash cookies. In the old days (yesterday before my update) we had this menu (right-click on a Flash object):</p><div style="text-align:center; margin: 5px 0 10px 0"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/flash-advanced-settings1.jpg" alt="" title="flash-advanced-settings[1]" width="211" height="136" class="alignnone size-full wp-image-1069" /></div><p>But as of the new update we have an extra option. If you right-click on a Flash object you see this new option called "Global Settings" that brings you to this menu:</p><p><span id="more-1068"></span></p><div style="text-align:center; margin: 5px 0 10px 0"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/05/114146-flash_player_system_pref_2_5001.jpg" alt="" title="114146-flash_player_system_pref_2_500[1]" width="500" height="395" class="alignnone size-full wp-image-1070" /></div><p>In the middle are three radioboxes that allow you to block all Flash cookies if you want. And there's a "<strong>Delete All</strong>" option that makes it easy to delete them.</p><p>It's a good thing to give users more control over these Flash cookies, often they are used to create <strong>non-removable cookies</strong>. Clever webdevelopers are able to create scripts that can restore removed browser cookies by copying the Flash cookies to a normal cookie. This is also called respawning cookies or zombie cookies (because a deleted browser cookie is back again on browser reload). And this is kind of a privacy thing, because users are not able to decide themselves which sites may track them.</p><p>Happy deleting <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-p3p-iframes-internet-explorer-en-cookies/' rel='bookmark' title='Google Analytics, P3P, iframes, Internet Explorer en cookies'>Google Analytics, P3P, iframes, Internet Explorer en cookies</a> <small>Wat hebben deze termen met elkaar gemeen? Dat de combinaties...</small></li><li><a href='http://andrescholten.net/een-select-element-spiderbaar-maken/' rel='bookmark' title='Een select element spiderbaar maken'>Een select element spiderbaar maken</a> <small>Ook problemen met zoekmachines en een selectbox? Lees hier de...</small></li><li><a href='http://andrescholten.net/frames-toegankelijk-maken-voor-zoekmachines/' rel='bookmark' title='Frames toegankelijk maken voor zoekmachines'>Frames toegankelijk maken voor zoekmachines</a> <small>Frames toegankelijk maken voor zoekmachines, een versimpelde weergave van een...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/xOKGoEsbZRE" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/adobe-makes-it-easy-to-remove-and-block-flash-cookies/feed/</wfw:commentRss> <slash:comments>0</slash:comments> <feedburner:origLink>http://andrescholten.net/adobe-makes-it-easy-to-remove-and-block-flash-cookies/</feedburner:origLink></item> <item><title>Track site speed / load time with Google Analytics events</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/Lalf2Mal90k/</link> <comments>http://andrescholten.net/track-site-speed-with-google-analytics-events/#comments</comments> <pubDate>Wed, 30 Mar 2011 08:54:40 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Site Speed]]></category> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[events]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[site speed]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1027</guid> <description><![CDATA[In the rebound an article about the tracking of your site's performance with Google Analytics. Almost a year ago I wrote this article in Dutch, but there are some improvements that made life easier. Google Analytics released the 'set events as goals' functionality that is really helpful here. The script I'm going to explain will [...] Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/' rel='bookmark' title='And that is why you need to speed up your site!'>And that is why you need to speed up your site!</a> <small>Today I read a great presentation from Joshua Bixby (Strangeloop)....</small></li><li><a href='http://andrescholten.net/how-to-check-real-time-if-a-google-analytics-implementation-works/' rel='bookmark' title='How to check real-time if a Google Analytics implementation works'>How to check real-time if a Google Analytics implementation works</a> <small>Often I get questions about how you can tell if...</small></li></ol>]]></description> <content:encoded><![CDATA[<p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/03/speedometer.png" alt="" title="speedometer" width="100" height="100" style="float:right; margin: 0 0 5px 5px;">In the rebound an article about the tracking of your site's performance with Google Analytics. Almost a year ago I wrote <a href="http://andrescholten.net/meet-de-snelheid-van-je-site-in-google-analytics/">this article</a> in Dutch, but there are some improvements that made life easier. Google Analytics released the 'set events as goals' functionality that is really helpful here.</p><p>The script I'm going to explain will track <strong>page load time</strong> and <strong>page render time</strong> per individual URL. I know some <a href="http://www.optimisationbeacon.com/analytics/track-page-load-times-with-google-analytics-asynchronous-script/">other</a> articles that describe a comparing technique but I really think the way I use it gives you more insights (at least for smaller sites).</p><h2>Sitespeed tracking is important</h2><p>I don't have to tell you how important it is to know how visitors experience your site. Sluggish sites will cost you money in the end. Site speed is a minor SEO ranking factor and fast sites tend to have more pageviews per visit and a higher conversion rate.</p><p><span id="more-1027"></span></p><h2>First the technical part</h2><p>To get the right numbers in your Google Analytics account you have to add some extra scripts. First a script that tracks the starttime of the page loading proces:</p><p><code>&lt;script type=&quot;text/javascript&quot;&gt;loadtimer=new Date();&lt;/script&gt;</code></p><p>Put this code directly after the &lt;head&gt; tag. Then put the next line just before the &lt;/head&gt;:</p><p><code>&lt;script type=&quot;text/javascript&quot;&gt;rendertimer=new Date();&lt;/script&gt;</code></p><p>And last but not least the event tracking code that can be everywhere in your code:</p><p><code>&lt;script type="text/javascript"&gt;<br /> window.onload = function()<br /> {<br /> _gaq.push(['timer._setAccount', 'UA-XXXXX-2'], ['timer._trackPageview']);<br /> _gaq.push(['timer._trackEvent', 'loadtime', location.href, , parseInt(new Date() - loadtimer)]);<br /> _gaq.push(['timer._trackEvent', 'time-to-render', location.href, , parseInt(rendertimer - loadtimer)]);<br /> }<br /> &lt;/script&gt;</code></p><p>Please use a brand new profile with a different UA number for this script. If you use the same UA number as your regular Google Analytics script this script will mess up your data.</p><p>I used the simple "window.onload" as an example here. But in most cases you would use a <a href="http://therealcrisp.xs4all.nl/upload/addEvent_dean.html">more robust</a> method for adding something to the onload event of your document.</p><h2>The results</h2><p>By adding this script you can see the actual time that it takes for a visitor to completely load a page. This is more reliabe than a n=1 measurement that a tool like <a href="http://www.webpagetest.org/">WebPageTest</a> can do (no bad words about that tool, it gives you a lot of other useful insights):</p><div style="text-align:center; margin: 10px 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/03/loadtimes.png" alt="" title="loadtimes" width="428" height="164"></div><p>If you go to the "event" report you will see two new categories: "loadtime" and "time-to-render". The first one shows you the time it took to completely load the page. The second one is the time people stared at a blank page. If that time is to high you also need to do some updates. If you click on one of those categories you will get the screenshot shown above. The column "Avg. Value" gives you the time it on average took to load a page.</p><p>What you can do also is an analysis of the loadtimes per browser, campaign, keyword or country:</p><div style="text-align:center; margin: 10px 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/03/loadtimescountries.png" alt="" title="loadtimescountries" width="247" height="337"></div><p>I now know my site is slow in the United States, India and China, just look at the numbers. So, if you are worldwide oriented this could be a really important report.</p><h2>Google Analytics events as goals</h2><p>It's possible to set an event as a goal in Google Analytics. I created this one to keep track of slow page load times:</p><div style="text-align:center; margin: 10px 0 10px 0;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/03/eventgoal.png" alt="" title="eventgoal" width="456" height="694" class="aligncenter size-full wp-image-1030" /></div><p>Every time someone hits a page that takes longer than 5 seconds to load it will trigger this goal. My target is to keep this number as low as possible <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p><strong>Additional comment:</strong><br /> The described technique only measures the load time after the server has send the first byte (TTFB = Time To First Byte). Make sure you also look at the process before that first byte. Aaron gave some <a href="http://andrescholten.net/track-site-speed-with-google-analytics-events/#comment-42723">more explanation</a> in the comments.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/how-to-measure-site-speed-or-web-performance/' rel='bookmark' title='How to measure Site Speed or Web Performance'>How to measure Site Speed or Web Performance</a> <small>A very hot topic last year: site speed, web performance,...</small></li><li><a href='http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/' rel='bookmark' title='And that is why you need to speed up your site!'>And that is why you need to speed up your site!</a> <small>Today I read a great presentation from Joshua Bixby (Strangeloop)....</small></li><li><a href='http://andrescholten.net/how-to-check-real-time-if-a-google-analytics-implementation-works/' rel='bookmark' title='How to check real-time if a Google Analytics implementation works'>How to check real-time if a Google Analytics implementation works</a> <small>Often I get questions about how you can tell if...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/Lalf2Mal90k" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/track-site-speed-with-google-analytics-events/feed/</wfw:commentRss> <slash:comments>30</slash:comments> <feedburner:origLink>http://andrescholten.net/track-site-speed-with-google-analytics-events/</feedburner:origLink></item> <item><title>How to measure Site Speed or Web Performance</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/v1hNq2X6A6o/</link> <comments>http://andrescholten.net/how-to-measure-site-speed-or-web-performance/#comments</comments> <pubDate>Wed, 23 Feb 2011 08:00:42 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Site Speed]]></category> <category><![CDATA[site speed]]></category> <category><![CDATA[tools]]></category><guid isPermaLink="false">http://andrescholten.net/?p=1002</guid> <description><![CDATA[A very hot topic last year: site speed, web performance, site performance or whatever you want to call it (got better suggestions?). But how do you measure the speed of you own site? There are several tool that can measure the load times of your site, but which one is right? First of all: what [...] Related articles:<ol><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/' rel='bookmark' title='And that is why you need to speed up your site!'>And that is why you need to speed up your site!</a> <small>Today I read a great presentation from Joshua Bixby (Strangeloop)....</small></li><li><a href='http://andrescholten.net/tracking-outbound-links-i-bet-you-only-measure-70/' rel='bookmark' title='Tracking outbound links? I bet you only measure 70 percent'>Tracking outbound links? I bet you only measure 70 percent</a> <small>A lot of site owners want to track outbound links...</small></li></ol>]]></description> <content:encoded><![CDATA[<p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/stopwatch.png" alt="" title="stopwatch" width="90" height="121" style="float:right; margin: 0 0 5px 5px;">A very hot topic last year: site speed, web performance, site performance or whatever you want to call it (got better suggestions?). But how do you measure the speed of you own site? There are several tool that can measure the load times of your site, but which one is right?</p><h2>First of all: what is Site Speed</h2><p>The speed of a site is the time it takes from the moment a user navigates to your site (for example through a link) until the site is fully loaded and usable. But there are many factors in this period that helps keeping the visitor patient enough to wait for a full load. The first moment is the moment when the browser begins rendering a site: until that moment people have to look at a white screen where nothing happens. Then the site starts to appear on the screen bit by bit until he is usable. And the last stage is where all the images are loaded to make the site look complete.</p><p><span id="more-1002"></span></p><h2>The tools to analyse Site Speed</h2><p>You need a good set of tools to see how your site is doing and what the greatest bottlenecks are during loading. I will describe a group of tools and their pro's and cons. Important things to consider is your <strong>target audience</strong>: worldwide or several countries, and which <strong>browser</strong> are they using. You want to test your site on both these areas.</p><h3>Webpagetest</h3><p>The first tool I want to mention is <a href="http://www.webpagetest.org/">Webpagetest.org</a>. This tool allows you to do an analysis of the load time of your site from a list of locations all over the world. The reports are detailed and tell you exactly how the different elements of the tested page load. It shows a waterfall, an optimization checklist, the Google Page Speed scores (see more details further below), screenshots during loading, first-view and repeat-view load times, etc. Really an extensive list of point so you can start working on your site.</p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/webpagetest.png" alt="" title="webpagetest" width="333" height="284"></div><p>And yes, the load time of my site is 5 seconds for the first view, but that has mainly to do with the Time To First Byte. Thats's the time it takes for the server to create a page, do some database stuff, etc before he sends out the first byte. After that the site loads within 1-2 seconds, as you can see in the repeat view numbers.</p><h3>Loads.in</h3><p>Relatively new in the field is <a href="http://loads.in/">Loads.in</a>. This tool makes it easy to test your site quickly from different locations and multiple browsers. It also stores the tests (<a href="http://andrescholten.net.loads.in/">see mine</a>) on a public URL to see improvements over time. It has a waterfall to see the order of the elements that are loading. Great tool for fast analysis and visual attractive pages you can use to convince clients <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/loadsin.png" alt="" title="loadsin" width="540" height="196"></div><h3>Pingdom</h3><p>A few weeks ago I saw the online tool from <a href="http://tools.pingdom.com/">Pingdom</a>. It says it measures load times of your website, but this tool doesn't work as a browser. And to have a good indication about scripts that are doing stuff you really need a tool that renders the page so it actually can see what is happening (thanks to <a href="http://www.aaronpeters.nl/">Aaron Peters</a> for telling me this).</p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/pingdom.png" alt="" title="pingdom" width="450" height="150"></div><h3>Page speed</h3><p>Google launched a tool of their own: <a href="http://code.google.com/speed/page-speed/">Google Page Speed</a>. It's an extension to the well known <a href="https://addons.mozilla.org/nl/firefox/addon/firebug/">Firebug Firefox Extension</a>. The advantage of this tool is that it works in your own browser, so you don't have to depend on online tools. What the tool does is giving you an extensive list of points that need some attention:</p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/pagespeed.png" alt="" title="pagespeed" width="336" height="158"></div><p>Each point shows the elements that can be optimized along with a link to a help page that gives you more explanation about the subject.</p><h3>Yslow</h3><p>Yahoo also created a tool (<a href="http://developer.yahoo.com/yslow/">YSlow</a>) that can analyse your site performance on a huge list of things. The tool works in Firebug also and is basically the same as Google's Page Speed, although they mention some other points. It can never hurt to create a report with this tool also.</p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/yslow.png" alt="" title="yslow" width="323" height="292"></div><h3>GTmetrix</h3><p>If you don't have the availability over a Firefox browser than you can use this online <a href="http://gtmetrix.com/">GTmetrix</a> tool that will do the Google Page Speed and Yahoo YSlow analysis for you. It returns with both optimization lists and huge grades that can break your day <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/gtmetrix.png" alt="" title="gtmetrix" width="467" height="133"></div><p>Next to the grades they provide a waterfall as we saw before.</p><h3>Google Webmaster Tools</h3><p>Recently Google put an extra report in the "labs" section of the Google Webmaster Tools called "Site Performance". It shows a graph with the time it takes for users to fully load a page in your site. The line is the average for all users (that have a Google Toolbar) on all pages of your site. Mines looks like this right now:</p><div style="text-align:center; margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/siteperformance.png" alt="" title="siteperformance" width="442" height="157"></div><p>I launched my new site a few weeks ago, and during the last weeks I improved the performance step by step. I expect the line to go further down in the next days. Almost always the improvements I do to a site are reflected in this graph: so yes, performance tuning works.</p><p>They also have other graphs in the "Diagnostics" -> "Crawl stats" screen, but they will tell you how fast Google could download a page. That's good to know, but a fast server doesn't mean a fast site.</p><h3>Google Analytics</h3><p>Last but not least: what Google can do with their toolbar, you can do with your Google Analytics account. Add some extra code and track the load time of all your visitors. Great advantage of having them in Google Analytics is that you can segment by browser or country. There are some existing articles that describe the load time tracking with pageviews or customvars, but I still prefer my own solution to <a href="http://andrescholten.net/track-site-speed-with-google-analytics-events/">track load times with event tracking</a>:</p><div style="text-align:center;margin-bottom: 20px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/04/laadtijden.png" alt="" title="laadtijden" width="622" height="313"></div><h2>Free extra tip</h2><p>In the past I improved a lot of sites to get them faster and faster. And almost each time one of the bigger factors in load time was external content. That could mean "Tweet this" or "Like that" buttons, ads, etc. If you want to improve load times of your site: have a look at the <strong>external content</strong> that you are loading and decide whether it's <strong>really necessary</strong> to have it or not. And if it's really necessary, try to load that content after your site is loaded. I did the same with the "Tweet this" buttons on my site: if you have a good look at the site when it is loading you will see that the buttons appear after everything else is loaded. Another great tips is to <a href="http://yoast.com/reduce-http-requests-wordpress/">reduce the amount of HTTP requests</a> as Yoast described.</p><h2>What are you using?</h2><p>Do you have tools that can add something to the mentioned ones? Which tools do you prefer?</p><p>Related articles:<ol><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/and-that-is-why-you-need-to-speed-up-your-site/' rel='bookmark' title='And that is why you need to speed up your site!'>And that is why you need to speed up your site!</a> <small>Today I read a great presentation from Joshua Bixby (Strangeloop)....</small></li><li><a href='http://andrescholten.net/tracking-outbound-links-i-bet-you-only-measure-70/' rel='bookmark' title='Tracking outbound links? I bet you only measure 70 percent'>Tracking outbound links? I bet you only measure 70 percent</a> <small>A lot of site owners want to track outbound links...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/v1hNq2X6A6o" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/how-to-measure-site-speed-or-web-performance/feed/</wfw:commentRss> <slash:comments>15</slash:comments> <feedburner:origLink>http://andrescholten.net/how-to-measure-site-speed-or-web-performance/</feedburner:origLink></item> <item><title>Google Analytics visits per page</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/lfqkVPB7i3g/</link> <comments>http://andrescholten.net/google-analytics-visits-per-page/#comments</comments> <pubDate>Mon, 14 Feb 2011 20:15:13 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[pageviews]]></category> <category><![CDATA[visits]]></category><guid isPermaLink="false">http://andrescholten.net/?p=967</guid> <description><![CDATA[What do you do if you want to know how many people visited a specific part (single page or subfolder) of your website? Very often people want to know this so they can report about it. A company can have multiple business units that all have their own subfolder on the company website, and they [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/' rel='bookmark' title='How to prevent Google Analytics sampling data'>How to prevent Google Analytics sampling data</a> <small>We all know the horrible sign in Google Analytics that...</small></li><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>What do you do if you want to know how many people visited a specific part (single page or subfolder) of your website? Very often people want to know this so they can report about it. A company can have multiple business units that all have their own subfolder on the company website, and they all want to know what their pages did. Or a campaign manager wants to know how many visits his action page attracted.</p><p>The first guess for most people would be to create this report with the Google Analytics Custom Report function:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/visits-page.png" alt="" title="visits-page" width="473" height="185"></div><p><span id="more-967"></span></p><p>It gives you nice looking numbers about the amount of visits for the specific pages:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/visits-page-report.png" alt="" title="visits-page-report" width="503" height="209"></div><p>But hey, guess what, this is:</p><div style="text-align:center; margin: 20px 0 20px 0"><span style="font-size:30px; color: red;">WRONG</span></div><p>It's a long story about Google's data model and their way of data processing, but you're not looking at the number you thought you where. When you create this Custom Report, Google shows you the amount of visits where that specific page was the first page the visitors saw. Also known as the landingpage. Let me show you a new report:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/visits-entrances-page.png" alt="" title="visits-entrances-page" width="462" height="170"></div><p>And the outcomes:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/visits-entrances-page-report.png" alt="" title="visits-entrances-page-report" width="524" height="198"></div><p>Look, it's magic, both columns show (almost) the same numbers which proves my point.</p><h2>My advice</h2><p>Do <strong>not ever</strong> use the metric "visits" for the dimension "page". Google should make it impossible for people to create this report, it will cause anger, disappointment and distrust <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><h2>How to split visits per page or subfolder?</h2><p>There are only 2 good ways to do this properly: <strong>Create a segment</strong> for a group of pages or subfolders. That segment will exactly tell you in how many visits people saw the specified pages. And yes: the content reports will also show other non-specified pages, because people visited those too during the visits on the pages you specified.</p><p>The second solution can help you with that: <strong>create new profiles</strong> that will only track the specified pages or subfolders you included in the profile filters. The huge disadvantage is that it only works from now on. And it's good for tracking a few subfolders, and not every single marketing campaign, because you are limited to 100 profiles max.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/' rel='bookmark' title='Google Analytics Event Tracking and Profile Filters'>Google Analytics Event Tracking and Profile Filters</a> <small>Last week I ran into an interesting situation. I wanted...</small></li><li><a href='http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/' rel='bookmark' title='How to prevent Google Analytics sampling data'>How to prevent Google Analytics sampling data</a> <small>We all know the horrible sign in Google Analytics that...</small></li><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/lfqkVPB7i3g" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/google-analytics-visits-per-page/feed/</wfw:commentRss> <slash:comments>11</slash:comments> <feedburner:origLink>http://andrescholten.net/google-analytics-visits-per-page/</feedburner:origLink></item> <item><title>How to prevent Google Analytics sampling data</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/QTharB5ecjM/</link> <comments>http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/#comments</comments> <pubDate>Thu, 03 Feb 2011 14:41:03 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[sampling]]></category><guid isPermaLink="false">http://andrescholten.net/?p=958</guid> <description><![CDATA[We all know the horrible sign in Google Analytics that looks like this: You want to analyze a bunch of data but because of that sign you know it will be sampled (incomplete) data. So, what is "sampling" exactly and how can you prevent it. What is sampling After Google Analytics gathered the raw unaggregated [...] Related articles:<ol><li><a href='http://andrescholten.net/geen-e-commerce-data-sinds-1-mei/' rel='bookmark' title='Geen E-Commerce data sinds 1 Mei'>Geen E-Commerce data sinds 1 Mei</a> <small>Zie je op dit moment ook het volgende gebeuren in...</small></li><li><a href='http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/' rel='bookmark' title='Simulate Googles trackPageLoadTime without sampling'>Simulate Googles trackPageLoadTime without sampling</a> <small>A while ago I wrote an article about a method...</small></li><li><a href='http://andrescholten.net/meet-de-snelheid-van-je-site-in-google-analytics/' rel='bookmark' title='Meet de snelheid van je site in Google Analytics'>Meet de snelheid van je site in Google Analytics</a> <small>Breid je Google Analytics rapportages uit met de laadtijden van...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>We all know the horrible sign in Google Analytics that looks like this:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/sampled.png" alt="" title="sampled" width="337" height="99"></div><p>You want to analyze a bunch of data but because of that sign you know it will be sampled (incomplete) data. So, what is "sampling" exactly and how can you prevent it.</p><h2>What is sampling</h2><p>After Google Analytics gathered the raw unaggregated data that is being tracked by the tracking script it processes it to understandable and useful <strong>visit</strong> data. And with that visit data all available standard reports are pre-calculated and stored. That means for example that if you try to get the "Top Content" report, Google Analytics can show it to you in seconds because most of the calculations are already done.</p><p><span id="more-958"></span></p><p>But if you want to get some data that is not pre-calculated, and Google Analytics has to search for it in the stored visit data, you could hit the sampling trigger. As you can imagine, this is a very heavy process that costs a lot of resources. Google has decided that if you are searching for data in <strong>more than 500.000 visits</strong> or <strong>1.000.000 lines of data</strong> it will sample the data to save time. That means that only 500.000 visits or 1.000.000 dimensions are used to create the report you're asking for, and Google Analytics will provide you with a certain range:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/02/confidence.png" alt="" title="confidence" width="274" height="91"></div><p>That range indicates the lower and upper boundary of where the truth lies with a <a href="http://en.wikipedia.org/wiki/Statistical_significance">statistical significance</a> that has a significance level of 5%. That means it's for 95% sure the presented range is correct.</p><h2>How to prevent sampling</h2><p>If you really want to use unsampled data in your reports while segmenting: make sure you select a date range that has <strong>less than 500.000 visits</strong> in it. If you want to analyze a larger date range: export the numbers of the two (ore more) date ranges to Excel and combine them there.</p><p>Another solution is to <strong>create multiple profiles</strong> that track a smaller part of your site. Within those profiles you won't hit the 500.000 limit as soon as the main profile.</p><p>The other sampling threshold regarding the 1.000.000 max dimensions is not reached very often. In most cases the top content report is the first one to hit that limit. Google will only retrieve 1.000.000 URL's for a specific period. That means, 1.000.000 divided by the days in your selected date range. For example: 2 months will give you 1.000.000/60 = 16667 unique URL's. So it could be that the URL you where looking for is not in the report. The solution is to select a date range where the amount of unique URL's in less than 1.000.000.</p><h2>Final word</h2><p>I know, the solutions are not the ones you really want, and with huge accounts they are useless. But in many cases exporting per proper date range selection is a good solution.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/geen-e-commerce-data-sinds-1-mei/' rel='bookmark' title='Geen E-Commerce data sinds 1 Mei'>Geen E-Commerce data sinds 1 Mei</a> <small>Zie je op dit moment ook het volgende gebeuren in...</small></li><li><a href='http://andrescholten.net/simulate-googles-trackpageloadtime-without-sampling/' rel='bookmark' title='Simulate Googles trackPageLoadTime without sampling'>Simulate Googles trackPageLoadTime without sampling</a> <small>A while ago I wrote an article about a method...</small></li><li><a href='http://andrescholten.net/meet-de-snelheid-van-je-site-in-google-analytics/' rel='bookmark' title='Meet de snelheid van je site in Google Analytics'>Meet de snelheid van je site in Google Analytics</a> <small>Breid je Google Analytics rapportages uit met de laadtijden van...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/QTharB5ecjM" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/feed/</wfw:commentRss> <slash:comments>6</slash:comments> <feedburner:origLink>http://andrescholten.net/how-to-prevent-google-analytics-sampling-data/</feedburner:origLink></item> <item><title>How to check real-time if a Google Analytics implementation works</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/Ahz5LK0c6M4/</link> <comments>http://andrescholten.net/how-to-check-real-time-if-a-google-analytics-implementation-works/#comments</comments> <pubDate>Fri, 28 Jan 2011 07:54:44 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[implementation]]></category> <category><![CDATA[tools]]></category><guid isPermaLink="false">http://andrescholten.net/?p=934</guid> <description><![CDATA[Often I get questions about how you can tell if a Google Analytics implementation is successful. People don't want to wait at least 4 to in some cases 24 hours before they see some data... or not. That's why I will tell you how I check this seconds after the codes are placed. How does [...] Related articles:<ol><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/services/google-analytics-training/' rel='bookmark' title='Google Analytics training'>Google Analytics training</a> <small>Are you looking for a hands-on Google Analytics training from...</small></li><li><a href='http://andrescholten.net/services/technical-google-analytics-help/' rel='bookmark' title='Technical Google Analytics help'>Technical Google Analytics help</a> <small>Do you need help with a simple or hard Google...</small></li></ol>]]></description> <content:encoded><![CDATA[<p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/analytics-logo.png" alt="" title="analytics-logo" width="141" height="129" style="float:right;margin:0 0 5px 5px;">Often I get questions about how you can tell if a Google Analytics implementation is successful. People don't want to wait at least 4 to in some cases 24 hours before they see some data... or not. That's why I will tell you how I check this seconds after the codes are placed.</p><h2>How does the tracking work</h2><p>Google Analytics uses pixel tracking technology to send data to the Google servers. That means that the GATC (Google Analytics Tracking Script) will put a little image on the page that is being tracked. The URL of this image looks like this:</p><p><span id="more-934"></span></p><blockquote><p>http://www.google-analytics.com/__utm.gif?utmwv=4.8.6d &#038;utmn=123456789 &#038;utmhn=andrescholten.net &#038;utme=8(2!echteresolutie)9(2!1600-750)11(2!1) &#038;utmcs=UTF-8 &#038;utmsr=1600x900 &#038;utmsc=32-bit &#038;utmul=nl &#038;utmje=1 &#038;utmfl=10.1%20r103 &#038;utmdt=Andr%C3%A9%20Scholten%20about%20SEO %2C%20Site%20Speed%20and%20Google%20Analytics%20%E2%80%A2%20Andr%C3 %A9%20Scholten &#038;utmhid=0123456789 &#038;utmr=- &#038;utmp=%2F &#038;utmac=UA-XXXXX-1 &#038;utmcc=__utma%3D96932303.227455505.1294957259.1296151377.1296158590.15%3B%2B __utmz%3D96932303.1296082197.13.7.utmcsr%3Dgoogle%7Cutmccn%3D(organic)%7Cutmcmd %3Dorganic%7Cutmctr%3Dandre%20scholten &#038;aip=1 &#038;utmu=qSEAAAAAAAAQ</p></blockquote><p>This utm.gif image will be fetched from the Google server and now Google can see by it's parameters what is being tracked. The same happens with the event tracking and ecommerce scripts. Each event will generate a call to this image, and each ecommerce transaction will call this image once for the transaction and once per individual item.</p><p>Now you know this you also know how to see if an implementation works: watch for the utm.gif calls. To do this you need a tool:</p><h2>Tool 1: Firefox extension Live HTTP Headers</h2><p>Firefox has a great extension called <a href="http://livehttpheaders.mozdev.org/">Live HTTP Headers</a>. Once you installed you can open the tool to get a view at everything that is being send between Firefox and the internet:</p><div style="text-align:center; margin-bottom: 10px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/liveheaders1.png" alt="" title="liveheaders1" width="485" height="243"></div><p>And with a little configuration effort the tool is set to only track Google Analytics calls:</p><div style="text-align:center;margin-top: 10px;"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/liveheaders2.png" alt="" title="liveheaders2" width="390" height="258"></div><p>The first tab in the tool will show you all calls with the utm.gif in it. The big advantage of this tool above the next mentioned, is that it also shows the details of tracking that is send over secure (HTTPS) connections.</p><h2>Tool 2: Fiddler2</h2><p><a href="http://www.fiddler2.com/fiddler2/">Fiddler2</a> is a more robust tool that is capable of tracking all traffic between your PC and the internet. That means it can do checks for Firefox, Opera, Chrome, Internet Explorer, etc. And as we all know: they can all behave different regarding the more challenging implementations. The tool will show you the Google Analytics tracking pixel like this:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/fiddler2.png" alt="" title="fiddler2" width="473" height="295"></div><h2>Tool 3: Google Analytics Tracking Code Debugger</h2><p>That last one I want to mention (but certainly not the least) is a tool <a href="https://chrome.google.com/extensions/detail/jnkmfdileelhofjcijamephohjechhna">developed by Google</a> self. It's an extension for Google Chrome that will show a lot of information about what the tracking code is doing on your page. It checks the code for errors and it will break down every single piece of information in readable parts. In my opinion the best tool for the job:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/chrome-gatc.png" alt="" title="chrome-gatc" width="400" height="563"></div><h2>What to analyse?</h2><p>With the mentioned tools you can see the entire utm.gif request with all the parameters being send. The most important parameters to keep an eye on are:</p><ul><li>utmp: after this parameters is the URL that is being measured</li><li>utmcc: this long parameter contains all cookie info, check if the source (it's after the "utmcsr" part) stays the same until a visitor converts, if not, something is broken and the conversions will be attributed to another source.</li></ul><p>A full list of all the other parameters can be found on <a href="http://code.google.com/apis/analytics/docs/tracking/gaTrackingTroubleshooting.html#gifParameters">this page</a>. The parameters for events and ecommerce transaction are somewhat different, but you will be able to analyze them soon enough.</p><p>Useful? Have some other tools to mention? Let me know in the comments.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/track-site-speed-with-google-analytics-events/' rel='bookmark' title='Track site speed / load time with Google Analytics events'>Track site speed / load time with Google Analytics events</a> <small>In the rebound an article about the tracking of your...</small></li><li><a href='http://andrescholten.net/services/google-analytics-training/' rel='bookmark' title='Google Analytics training'>Google Analytics training</a> <small>Are you looking for a hands-on Google Analytics training from...</small></li><li><a href='http://andrescholten.net/services/technical-google-analytics-help/' rel='bookmark' title='Technical Google Analytics help'>Technical Google Analytics help</a> <small>Do you need help with a simple or hard Google...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/Ahz5LK0c6M4" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/how-to-check-real-time-if-a-google-analytics-implementation-works/feed/</wfw:commentRss> <slash:comments>16</slash:comments> <feedburner:origLink>http://andrescholten.net/how-to-check-real-time-if-a-google-analytics-implementation-works/</feedburner:origLink></item> <item><title>Google Analytics Event Tracking and Profile Filters</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/zvOsTWdIP0g/</link> <comments>http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/#comments</comments> <pubDate>Mon, 24 Jan 2011 21:55:11 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[events]]></category> <category><![CDATA[filters]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[profiles]]></category><guid isPermaLink="false">http://andrescholten.net/?p=915</guid> <description><![CDATA[Last week I ran into an interesting situation. I wanted to create a profile for a specific subfolder in Google Analytics. And I only wanted the events that where launched from pages within that subfolder to be reported there. This graphic shows you the situation: A visitor lands on the homepage, he than goes to [...] Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li><li><a href='http://andrescholten.net/de-kracht-van-reguliere-expressies-in-google-analytics-filters/' rel='bookmark' title='De kracht van reguliere expressies in Google Analytics filters'>De kracht van reguliere expressies in Google Analytics filters</a> <small>Wil je graag meerdere pagina's tegelijk filteren of selecteren in...</small></li><li><a href='http://andrescholten.net/google-analytics-visits-per-page/' rel='bookmark' title='Google Analytics visits per page'>Google Analytics visits per page</a> <small>What do you do if you want to know how...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Last week I ran into an interesting situation. I wanted to create a profile for a specific subfolder in Google Analytics. And I only wanted the events that where launched from pages within that subfolder to be reported there. This graphic shows you the situation:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/pageviews-events.png" alt="" title="pageviews-events" width="550" height="271"></div><p>A visitor lands on the homepage, he than goes to the French subfolder (what is a virtual folder because the entire site is working with AJAX). And than he decides to read some Dutch texts to have a good laugh about the weird language. On both pages he prints out the text he found there, what is being measured with Google Analytics' event tracking system.</p><p>Nothing strange now right?</p><p><span id="more-915"></span></p><p>Well, when I created the French profile with a specific "Include request URL" filter on it:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/include-folder-filter.png" alt="" title="include-folder-filter" width="465" height="324"></div><p>But the Event Tracking report stayed empty? As a Google Analytics technology nerd I wanted to get to the bottom of this.</p><h2>To which pages are events attached?</h2><p>The first question I needed to find out is to which pages the events are attached to. If you take a good look at the request that is being send to Google you will see this:</p><blockquote><p>http://www.google-analytics.com/__utm.gif?utmwv=4.8.8&#038;utmn=12345678&#038;utmhn=www.example.com&#038;utmt=event&#038;<strong>utme=5(Print*Print-Page)</strong>&#038;utmcs=UTF-8&#038;utmsr=1600x900&#038;utmsc=24-bit&#038;utmul=nl&#038;utmje=1&#038;utmfl=10.1%20r102&#038;utmdt=Example&#038;utmhid=0123456789&#038;utmr=-&#038;<strong>utmp=%2F</strong>&#038;utmac=UA-XXXXXX-1&#038;utmcc=[cut-cookie-values]&#038;utmu=7DMAg</p></blockquote><p>In the UTME parameter are the event values: the category and the action. And as you can see: in the UTMP parameter is the URL that was in the browsers' address bar (%2F stands for /). Not the last virtual pageview URL, not the last real URL, but the actual URL in the address bar.</p><p>So the conclusion is: if you want to filter events, you need to filter the pages they were fired from. And if you're working with virtual pageviews you definitely have a problem.</p><h2>Side-effects</h2><p>It could be that your site reports 100 URL's in the Top Content report. But there could also be an extra 100 'hidden' URL's that weren't tracked with a trackPageview but did fire a trackEvent. You can find these url's in the Event reports:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2011/01/event-pages.png" alt="" title="event-pages" width="413" height="256"></div><p>Click on the 'Page' item and see which URL's are attached to the events. It could be that these URL's are not in the Top Content report at all. If I created a filter that would only include these URL's it could be that the profile would show 0 pageviews and 100 visits.</p><h2>Is there a solution?</h2><p>Well, not really. In most cases a filter on the right folder will work perfectly. Because most events are fired after a trackPageview call that used the URL from the address bar. But if you have a Flash/AJAX site, or some Game/Campaignsite that only uses events on special URL's you need to work out a proper solution.</p><p>In my opinion Google should attach events to the last URL that was being send with the trackPageview command. What are your thoughts?</p><p>Related articles:<ol><li><a href='http://andrescholten.net/google-analytics-event-tracking-not-affecting-bouncerate/' rel='bookmark' title='Google Analytics event tracking not affecting bouncerate?'>Google Analytics event tracking not affecting bouncerate?</a> <small>With the new release of ga.js this is possible. In...</small></li><li><a href='http://andrescholten.net/de-kracht-van-reguliere-expressies-in-google-analytics-filters/' rel='bookmark' title='De kracht van reguliere expressies in Google Analytics filters'>De kracht van reguliere expressies in Google Analytics filters</a> <small>Wil je graag meerdere pagina's tegelijk filteren of selecteren in...</small></li><li><a href='http://andrescholten.net/google-analytics-visits-per-page/' rel='bookmark' title='Google Analytics visits per page'>Google Analytics visits per page</a> <small>What do you do if you want to know how...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/zvOsTWdIP0g" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/feed/</wfw:commentRss> <slash:comments>1</slash:comments> <feedburner:origLink>http://andrescholten.net/google-analytics-event-tracking-and-profile-filters/</feedburner:origLink></item> <item><title>Hello World!</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/Iqg-EYcOaRE/</link> <comments>http://andrescholten.net/hello-world/#comments</comments> <pubDate>Wed, 19 Jan 2011 22:49:45 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Divers]]></category> <category><![CDATA[personal]]></category><guid isPermaLink="false">http://andrescholten.net/?p=904</guid> <description><![CDATA[An appropriate title for a new and refreshed blog, don't you think? At least, my focus was always on the Dutch speaking part of the world, and now I'm targeting the whole world (the English speaking part). For people who don't know me, and there are a lot of them I once wrote some blogs [...] No related articles.]]></description> <content:encoded><![CDATA[<p>An appropriate title for a new and refreshed blog, don't you think? At least, my focus was always on the Dutch speaking part of the world, and now I'm targeting the whole world (the English speaking part).</p><p>For people who don't know me, and there are a lot of them <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> I once wrote some blogs on my friend Yoast his site. They were about <a href="http://yoast.com/track-seo-rankings-google-analytics/">tracking SEO rankings</a> <a href="http://yoast.com/track-seo-rankings-and-sitelinks-with-google-analytics-ii/">with Google Analytics</a>. And it was reasonably succesful, I almost got a <a href="http://www.semmys.org/2010/analytics-2010-finalists/">Semmy</a> for it. Other cool thing is my <a href="http://andrescholten.net/search-submit-auto-submit-to-search-engines/">Search Submit&copy;</a> tool, you must absolutely check it out.</p><p>The site still needs some work, some speed tweaks and some translation. The most popular Dutch articles will be translated to new English ones, the rest will stay in Dutch. And I already have some cool new posts queued up, ready to hit the RSS scrapers <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>So, what do you think? Do you like the new design and the new logo?</p><p>No related articles.</p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/Iqg-EYcOaRE" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/hello-world/feed/</wfw:commentRss> <slash:comments>13</slash:comments> <feedburner:origLink>http://andrescholten.net/hello-world/</feedburner:origLink></item> <item><title>2011, op eigen benen</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/kLJxSRgQK90/</link> <comments>http://andrescholten.net/2011-op-eigen-benen/#comments</comments> <pubDate>Mon, 10 Jan 2011 20:57:55 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Personal]]></category> <category><![CDATA[personal]]></category><guid isPermaLink="false">http://andrescholten.net/?p=901</guid> <description><![CDATA[Na een aantal keer flink jeuk gehad te hebben heeft de kriebel nu echt doorgezet: ik ga vanaf februari voor mezelf beginnen. Naast mijn vaste baan bij Traffic4u wordt er tijd ingeruimd om zelf werkzaamheden te ontplooien. Een ideale droomcombinatie van 2 werkgevers: Traffic4u en mezelf Aan de ene kant is het werken in een [...] Related articles:<ol><li><a href='http://andrescholten.net/maak-nu-je-eigen-zoekmachine/' rel='bookmark' title='Maak nu je eigen zoekmachine'>Maak nu je eigen zoekmachine</a> <small>*ook verschenen op Marketingfacts Op diverse sites waaronder die van...</small></li></ol>]]></description> <content:encoded><![CDATA[<p>Na een aantal keer flink jeuk gehad te hebben heeft de kriebel nu echt doorgezet: ik ga vanaf februari voor mezelf beginnen. Naast mijn vaste baan bij <a href="http://www.traffic4u.nl">Traffic4u</a> wordt er tijd ingeruimd om zelf werkzaamheden te ontplooien. Een ideale droomcombinatie van 2 werkgevers: Traffic4u en mezelf <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>Aan de ene kant is het werken in een team aan een online marketing strategie voor erg grote klanten uitdagend en interessant. Maar aan de andere is het zelf ontplooien en bedenken/uitwerken van nieuwe diensten ook een toffe bezigheid. Vanaf heden ga ik dat combineren door deels voor Traffic4u en deels voor mezelf te werken.</p><h2>Wat ga je dan doen?</h2><p>De focus van de dienstverlening zal liggen op:</p><p><span id="more-901"></span></p><ul><li>SEO</li><li>Site speed (laad je site snel genoeg?)</li><li>Google Analytics</li><li>Trainingen organiseren over bovenstaande onderwerpen</li></ul><p>En daarnaast zullen andere interessante gebieden en ontwikkelingen in de gaten gehouden worden. Het bloggen wordt weer geïntensiveerd, ik heb nog een aantal gave onderwerpen op de plank liggen. En er zou ook nog wel eens een website hier en daar live kunnen gaan.</p><h2>En je site?</h2><p>Ja ja, ik weet het, Joost <a href="http://yoast.com/web-design-magic-wand/">schreef</a> er al over, een goed design is belangrijk. En daarom ben ik nu al hard aan een nieuw design inclusief nieuw logo aan het werken. Binnenkort dus een complete overhaul. En last but not least, while I'm in the right language now: the site will be continued in English. My Dutch readers are capable of reading English, but the rest of the world seem to have a problem with the Dutch language. So, a new language and a new domain, soon to be published. But as all marketers know: first get your SEO migration plan right before you launch a new site <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><h2>Tot slot</h2><p>Tja, waar begin je dan? Met het aanbieden van <a href="/contact/?phpMyAdmin=hzatdkYE-JiaoWULr-XZXwZHhd5">hulp</a>.</p><p>Related articles:<ol><li><a href='http://andrescholten.net/maak-nu-je-eigen-zoekmachine/' rel='bookmark' title='Maak nu je eigen zoekmachine'>Maak nu je eigen zoekmachine</a> <small>*ook verschenen op Marketingfacts Op diverse sites waaronder die van...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/kLJxSRgQK90" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/2011-op-eigen-benen/feed/</wfw:commentRss> <slash:comments>32</slash:comments> <feedburner:origLink>http://andrescholten.net/2011-op-eigen-benen/</feedburner:origLink></item> <item><title>AdWords individuele keyword analyse vanuit Google Analytics</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/XeRTB64TnZo/</link> <comments>http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/#comments</comments> <pubDate>Tue, 28 Sep 2010 14:26:14 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Webanalytics]]></category> <category><![CDATA[adwords]]></category> <category><![CDATA[excel]]></category> <category><![CDATA[google analytics]]></category> <category><![CDATA[keywords]]></category><guid isPermaLink="false">http://andrescholten.net/?p=797</guid> <description><![CDATA[Hoe kun je op een andere manier eens naar het effect van je AdWords zoekwoorden kijken vanuit Google Analytics? Hieronder beschrijf ik een manier die voor mij vaak tot goede inzichten leidt, maar het is wel wat bewerkelijk. Allereerst de benodigdheden (het is net een knutselwerkje): Een Google Analytics account vol data Een AdWords campagne [...] Related articles:<ol><li><a href='http://andrescholten.net/adwords-metingen-google-analytics-gestopt-op-9-januari/' rel='bookmark' title='Adwords metingen Google Analytics gestopt op 9 januari?'>Adwords metingen Google Analytics gestopt op 9 januari?</a> <small>Update: probleem opgelost. Het lijkt er op dat er iets...</small></li><li><a href='http://andrescholten.net/adwords-conversion-tracker-vs-google-analytics-vanwaar-het-verschil/' rel='bookmark' title='Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?'>Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?</a> <small>Waarom zijn de cijfers in Google Analytics anders dan in...</small></li><li><a href='http://andrescholten.net/echte-zoekwoorden-en-inhoudsnetwerk-adwords-zichtbaar-met-analytics/' rel='bookmark' title='Echte zoekwoorden en inhoudsnetwerk Adwords zichtbaar met Analytics'>Echte zoekwoorden en inhoudsnetwerk Adwords zichtbaar met Analytics</a> <small>Wil je eindelijk zien met welke woorden bezoekers je echt...</small></li></ol>]]></description> <content:encoded><![CDATA[<p><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/letters.png" alt="" title="letters" width="150" height="107" style="float:right; margin: 0 0 5px 5px;" />Hoe kun je op een andere manier eens naar het effect van je AdWords zoekwoorden kijken vanuit Google Analytics? Hieronder beschrijf ik een manier die voor mij vaak tot goede inzichten leidt, maar het is wel wat bewerkelijk.</p><p>Allereerst de benodigdheden (het is net een knutselwerkje):</p><ul><li>Een Google Analytics account vol data</p><li>Een AdWords campagne van een tijdje (maand tot enkele maanden) oud<li>Excel (of een soortgelijk pakket)<li>Een handige plain tekst editor (<a href="http://notepad-plus-plus.org/">Notepad++</a>)<li>Voor grote campagnes een snelle pc (rekenkracht in Excel)</ul><p><span id="more-797"></span></p><h2>Dan de theorie</h2><p>Deze keywordanalyse gaat eigenlijk om het ombouwen van deze tabel:</p><style>.example{border:2px solid #000;width:600px}.example td{border:1px solid #000;width:150px}</style><table class="example"><tr><th>Zoekwoord</th><th>Bezoekers</th><th>Omzet</th><th>Omzet per bezoeker</th></tr><tr><td>Vakantie Ameland</td><td>100</td><td>€ 120</td><td>€ 0,83</td></tr><tr><td>Vakantie Texel</td><td>50</td><td>€ 80</td><td>€ 1,60</td></tr><tr><td>Weekendje Texel</td><td>20</td><td>€ 200</td><td>€ 10,00</td></tr></table><p>Naar deze:</p><table class="example"><tr><th>Zoekwoord</th><th>Bezoekers</th><th>Omzet</th><th>Omzet per bezoeker</th></tr><tr><td>Vakantie</td><td>150</td><td>€ 200</td><td>€ 1,33</td></tr><tr><td>Ameland</td><td>100</td><td>€ 120</td><td>€ 1,20</td></tr><tr><td>Texel</td><td>70</td><td>€ 280</td><td>€ 4,00</td></tr><tr><td>Weekendje</td><td>20</td><td>€ 200</td><td>€ 10,00</td></tr></table><p>Waarom? Zo kun je in dit voorbeeld heel snel zien dat de zoekopdrachten met het woord "weekendje" erg waardevol zijn. Ook zou je op deze manier heel snel woorden kunnen opsporen die helemaal niet bijdragen aan de omzet: deze kun je vervolgens weer uitsluiten.</p><h2>Stap 1: De zoekwoorden exporteren</h2><p>Ga in Google Analytics naar het rapport "Keywords" onder "Traffic Sources" -> "AdWords":</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/keywords-rapport.png" alt="" title="keywords-rapport" width="264" height="145" /></div><p>Kies in dat rapport in het pulldown menu "Keyword" voor "Matched Search Query". We willen namelijk de ingetypte woorden hebben en niet de woorden waarop geadverteerd word:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/matched-query.png" alt="" title="matched-query" width="627" height="177" /></div><p>Wanneer de tabel geladen is kun je tabel exporteren. klik bovenin het scherm op "Export" en klik met de rechtermuisknop op de "TSV" link. Kopieer de URL van de link en zet deze in de adresbalk. Type er vervolgens "&#038;limit=10000" achter, dat is de manier om meer dan de standaard aantal rijen te exporteren.</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/tabellimiet.png" alt="" title="tabellimiet" width="207" height="87" /></div><p>Vervolgens kun je het bestand openen of <strong>downloaden</strong>. Kies voor de laatste, want het bestand is nog niet klaar voor Excel. Open vervolgens het TSV bestand in de tekst editor en voer 2 zoek-en-vervang acties uit:</p><ul><li>Zoek alle komma's (,) en vervang deze met niets ()</p><li>Zoek alle punten (.) en vervang deze door komma's (,)<li>Verwijder de eerste rijen tot aan waar de echte tabel begint</ul><p>Nu is het bestand klaar om in Excel geopend te worden. Doe dat <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><h2>Stap 2: de bewerkingen in Excel uitvoeren</h2><p>Je hebt nu een Excel werkblad met daarin alle data (we noemen dat werkblad "Data"). Als het goed is gegaan is de data ook al mooi gepresenteerd in kolommen. Kopieer kolom A (de zoekwoorden) van werkblad "Data" naar de text editor. Daar doe je de volgende zoek en vervang actie:</p><ul><li>Zoek alle spaties ( ) en vervang deze met een break voor een nieuwe regel (\n):</ul><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/zoekenvervang.png" alt="" title="zoekenvervang" width="492" height="330" /></div><p>Nu staan alle individuele woorden op een enkele regel. Kopieer deze woorden naar kolom A van een nieuw werkblad genaamd "Analyse" in Excel. Selecteer in dat werkblad kolom A en kies voor de volgende functie:</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/duplicaten.png" alt="" title="duplicaten" width="336" height="219" /></div><p>Hiermee worden alle dubbele woorden uit de kolom verwijderd en blijft er van elk woord maar 1 vermelding over. Ga terug naar werkblad "Data" en voeg daar 2 extra kolommen toe: "Bouncers" en "Pages". Deze kolommen moeten respectievelijk als formule bevatten: "=bouncerate*visits" en "=pages-visits*visits". Zo hebben we het absolute aantal bouncers en bekeken pagina's. Die zijn weer nodig in het werkblad "Analyse".</p><p>In werkblad "Analyse" kunnen we nu de extra kolommen gaan toevoegen. Eerst zoeken we het aantal visits per zoekwoord op. Dat gaat met de volgende formule die we in kolom B plaatsen:</p><p><code>=SOMMEN.ALS(Data!B:B; Data!A:A; Analyse!A2 &#038; " *")+SOMMEN.ALS(Data!B:B; Data!A:A; "* " &#038; Analyse!A2)+SOMMEN.ALS(Data!B:B; Data!A:A; Analyse!A2)+SOMMEN.ALS(Data!B:B; Data!A:A; "* " &#038; Analyse!A2 &#038; " *")</code></p><p>Kort gezegd zoekt deze formule in werkblad "Data" alle vermeldingen op van het zoekwoord uit kolom A van werkblad "Analyse" waar het zoekwoord geen onderdeel is van een langer woord. Dus bij het woord "goed" wordt "goedkoop" niet gematched maar "alles is goed gedaan" wel.</p><p>Van de rijen die matchen worden dan de waardes uit kolom B (de visits) opgeteld. Hetzelfde kun je doen om alle bouncers op te tellen:</p><p><code>=SOMMEN.ALS(Data!F:F; Data!A:A; Analyse!A2 &#038; " *")+SOMMEN.ALS(Data!F:F; Data!A:A; "* " &#038; Analyse!A2)+SOMMEN.ALS(Data!F:F; Data!A:A; Analyse!A2)+SOMMEN.ALS(Data!F:F; Data!A:A; "* " &#038; Analyse!A2 &#038; " *")</code></p><p>Zelfde formule, alleen worden nu de waardes uit kolom F (de bouncers) bij elkaar opgeteld. Zo kun je alle velden uit werkblad "Data" opvragen: revenue, time-on-site, enz.</p><h2>De final touch</h2><p>Het enige wat rest is in het nieuwe werkblad de kolom "bounce rate" aan te maken door het aantal bouncers door het aantal visits te delen.</p><p>Omdat het werkblad "Analyse" wel eens heel zwaar kan zijn bij grote aantallen zoekwoorden kun je voor het analyseren het beste een kopie maken. Je maakt een nieuw werkblad aan en kopieert werkblad "Analyse" daar naar toe. Bij het plakken kies je dan voor "Waarden plakken":</p><div style="text-align:center"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/waardesplakken.png" alt="" title="waardesplakken" width="186" height="281" /></div><p>Zo ontstaat er een nieuw werkblad dat geen formules meer maar alleen waardes bevat. Hier kun je vervolgens je echte analyses op los laten. Welke woorden genereren veel omzet, welke niet. Waar zitten de bouncers, enz.</p><h2>Een voorbeeld sheet</h2><p>Ik kan me voorstellen dat het allemaal niet even duidelijk is. Ik heb daarom een voorbeeld sheet gemaakt met daarin de besproken tabbladen:</p><ul><li><a href="http://andrescholten.net/downloads/analysevoorbeeld.xls">Voorbeeld van keyword analyse in Excel</a></ul><p>In de praktijk kom ik zo veel bijvoeglijke naamwoorden tegen die het erg goed doen. En zonder deze analyse was ik daar niet snel achter gekomen. Ook levert het vaak veel woorden op die uitgesloten moeten worden. Google's <strong>Extended Super Wide Huge Broad Matching algoritme</strong> wil nog wel eens voor rare zoekwoord matches zorgen.</p><p>In plaats van Excel en Notepad++ zijn er ook andere tools, maar die zullen wellicht niet alle opties aan boord hebben om de analyse op de beschreven manier te doen. Je zult dan creatief moeten zijn in het zoeken naar een andere oplossing.</p><p>Vragen? Leuk? handig? Hieronder <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>Related articles:<ol><li><a href='http://andrescholten.net/adwords-metingen-google-analytics-gestopt-op-9-januari/' rel='bookmark' title='Adwords metingen Google Analytics gestopt op 9 januari?'>Adwords metingen Google Analytics gestopt op 9 januari?</a> <small>Update: probleem opgelost. Het lijkt er op dat er iets...</small></li><li><a href='http://andrescholten.net/adwords-conversion-tracker-vs-google-analytics-vanwaar-het-verschil/' rel='bookmark' title='Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?'>Adwords Conversion Tracker vs Google Analytics, vanwaar het verschil?</a> <small>Waarom zijn de cijfers in Google Analytics anders dan in...</small></li><li><a href='http://andrescholten.net/echte-zoekwoorden-en-inhoudsnetwerk-adwords-zichtbaar-met-analytics/' rel='bookmark' title='Echte zoekwoorden en inhoudsnetwerk Adwords zichtbaar met Analytics'>Echte zoekwoorden en inhoudsnetwerk Adwords zichtbaar met Analytics</a> <small>Wil je eindelijk zien met welke woorden bezoekers je echt...</small></li></ol></p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/XeRTB64TnZo" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/feed/</wfw:commentRss> <slash:comments>20</slash:comments> <feedburner:origLink>http://andrescholten.net/adwords-individuele-keyword-analyse-vanuit-google-analytics/</feedburner:origLink></item> <item><title>Een rondje tools en tips: iphone, sitespeed, testen en backups</title><link>http://feedproxy.google.com/~r/AndreScholten/~3/ZXIibFLOPSc/</link> <comments>http://andrescholten.net/een-rondje-tools-en-tips-iphone-sitespeed-testen-en-backups/#comments</comments> <pubDate>Wed, 22 Sep 2010 20:08:02 +0000</pubDate> <dc:creator>André</dc:creator> <category><![CDATA[Divers]]></category> <category><![CDATA[keywords]]></category> <category><![CDATA[site speed]]></category> <category><![CDATA[tools]]></category><guid isPermaLink="false">http://andrescholten.net/?p=785</guid> <description><![CDATA[Vorige week in San Francisco, of beter gezegd Mountain View mochten een aantal Google Analytics partners hun tools laten zien. Eentje daarvan viel me op en krijgt hier zijn eigen vermelding: BAM Analytics. Het is een iPhone app waarmee je heel makkelijk meerdere Google Analytics accounts kunt bekijken. De schermen zijn overzichtelijk en de app [...] No related articles.]]></description> <content:encoded><![CDATA[<p><a href="http://www.blastam.com/google-analytics-iphone-app.aspx"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/bamanalytics.jpg" alt="" title="bamanalytics" width="100" height="100" style="float:right;margin:5px;" /></a>Vorige week in San Francisco, of beter gezegd Mountain View mochten een aantal Google Analytics partners hun tools laten zien. Eentje daarvan viel me op en krijgt hier zijn eigen vermelding: <a href="http://www.blastam.com/google-analytics-iphone-app.aspx">BAM Analytics</a>. Het is een iPhone app waarmee je heel makkelijk meerdere Google Analytics accounts kunt bekijken. De schermen zijn overzichtelijk en de app zit vol met allerlei functionaliteiten. Het is de eerste mobiele app voor Google Analytics die me positief verraste.</p><p><span id="more-785"></span></p><h2>Sitespeed testen</h2><p>Dan een tool die door 1 van mijn commenters genoemd werd: <a href="http://gtmetrix.com/">GTmetrix</a>. Deze tool laat je eenvoudig een site controleren door Google Page Speed en Yahoo !Slow. Daarnaast wordt een waterval getoond, dat is een visuele weergave van het inladen van alle onderdelen van de geteste site. Zo zie je eenvoudig waar de bottlenecks zitten. Het leuke is ook dat ze de scores van je site onthouden, en zo kun je goed bijhouden wat je inspanningen om je site te versnellen opleveren. Uiteraard mag naast deze tool niet de site van <a href="http://www.webpagetest.org/">WebPagetest</a> ontbreken, ook een erg goede tool.</p><h2>Eenvoudig A/B of multivariate testen</h2><p><a href="http://visualwebsiteoptimizer.com/?partner=andre"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/i_love_a_b_testing.png" alt="" title="i_love_a_b_testing" width="125" height="125" style="float:right;margin:5px;" /></a>Ben je flauw van de Google Website Optimizer omdat je voor elke test een bak scripts moet plaatsen terwijl je dan ook de kans loopt om je Google Analytics meting om zeep te helpen? Dan is het tijd om over te stappen naar de <a href="http://visualwebsiteoptimizer.com/?partner=andre">Visual Website Optimizer</a>:</p><ul><li>1 script plaatsen op alle pagina's en je hoeft nooit weer scripts te plaatsen.</p><li>Met een paar kliks selecteer je testgebieden: titels, teksten, enz.<li>Daarna on-the-fly een paar doelen instellen en je bent klaar om te testen.<li>Tijdens de test meer doelen toevoegen of varianten uitschakelen.<li>Direct gekoppeld met Google Analytics zodat je de resultaten per variant ook daar bij kunt houden.</ul><p>Bekijk deze <a href="http://visualwebsiteoptimizer.com/features.php?partner=andre">pagina + video</a> voor een snelle indruk.</p><h2>Simpel en zonder moeite een backup maken</h2><p><a href="https://www.dropbox.com/referrals/NTEwMDgzMjUzOQ"><img src="http://newcdn.andrescholten.net/wp-content/uploads/2010/09/dropbox.png" alt="" title="dropbox" width="231" height="60" style="float:left;margin:5px;" /></a>Zet een bestand in een speciale folder, en dat bestand is direct gebackupped en gesynchroniseerd online en op alle andere pc's waar je <a href="https://www.dropbox.com/referrals/NTEwMDgzMjUzOQ">Dropbox</a> geïnstalleerd hebt. Zo kun je recente foto's en belangrijke documenten eenvoudig op diverse geografische lokaties backuppen. En met een speciale link kun je bestanden eenvoudig delen met anderen. Lui en toch recente backups willen hebben? <a href="https://www.dropbox.com/referrals/NTEwMDgzMjUzOQ">Dropbox</a>.</p><p><strong>Referral linkjes?</strong><br /> Ja, als ik mensen bij Dropbox aanbreng krijg ik 500mb gratis ruimte er bij <img src='http://newcdn.andrescholten.net/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /></p><p>No related articles.</p><img src="http://feeds.feedburner.com/~r/AndreScholten/~4/ZXIibFLOPSc" height="1" width="1"/>]]></content:encoded> <wfw:commentRss>http://andrescholten.net/een-rondje-tools-en-tips-iphone-sitespeed-testen-en-backups/feed/</wfw:commentRss> <slash:comments>4</slash:comments> <feedburner:origLink>http://andrescholten.net/een-rondje-tools-en-tips-iphone-sitespeed-testen-en-backups/</feedburner:origLink></item> </channel> </rss><!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/

Minified using disk: basic
Page Caching using disk: enhanced
Database Caching 2/219 queries in 0.103 seconds using disk: basic
Object Caching 7960/8213 objects using disk: basic
Content Delivery Network via newcdn.andrescholten.net

Served from: andrescholten.net @ 2012-02-17 17:15:33 -->

