Central Perk

sâmbătă, 25 mai 2013

8 Great Tools to use with Google Analytics

8 Great Tools to use with Google Analytics

Posted: 24 May 2013 08:43 AM PDT

We hear so much about great SEO tools that we should be using, but we rarely see much written about tools to help you with your Google Analytics data. Over the past year I have been using more and more tools to help with Google Analytics data, from API extraction to data visualisation, and I wanted to share them with you. Below are just 8 tools that I used for Google Analytics on a regular basis that save me a lot of time.

ScreamingFrog

Who has come across GA traffic disappearing and it being down to some GA code being removed? How long has that taken you to find the pages that no longer has the GA code on?

Over the past few years I have been using ScreamingFrog to check websites for any pages that have missing Google Analytics code, and comparing it against those that have. Once I have a list of URLs with missing GA code, I supply this to the internal team to have them look at it and implement. Once implemented, I then re-run the crawl to ensure the missing pages now have the GA code.

Running a ScreamingFrog report to look for Google Analytics code is very easy and can be done in six steps:

1. Open ScreamingFrog ;)
2. Enter the URL in the search bar
3. Navigate to Configuration > Custom
4. Filter 1 “contains” > UA Code.
5. Filter 2 “does not contain” > UA Code (As shown Below)
6. Hit OK, and then start the crawl.

Once the report has run you will find a list of URLs within the Custom tag, for both pages with and without GA code on them. Export the list of URLs without the Google Analytics code and send them to the developer.

Get ScreamingFrog here.

GA Copy and Paste

The GA Copy and Paste plugin has saved me so much time over the months, where I have had to replicate features or settings across a number of different accounts and profiles. The handy GA Copy and Paste Chrome plugin does exactly what it says on the tin. You navigate to your filter/goal and press the plugin button in the address bar, and press copy. You then create a new filter/goal, press the plugin button again followed by the paste button, and voila! Your filter/goal has been copied across effortlessly.

As I have already mentioned, this saves me a lot of time, and hopefully it will do the same for you. Get GA Copy and Paste here.

CustomReportSharing.com

Using Segments, custom dashboards and reports is becoming the norm in everyday online marketing. Diving deep into the data to get a more granular view on your marketing activities allows you and the business to make much better decisions. The huge advantage Google Analytics has is the ability to share those features with your colleagues and peers. Now it is even easier to find some great information thanks to those over at CustomReportSharing.com.

Whether you are looking for an eCommerce custom report, or you are looking to start an SEO Dashboard, CustomReportSharing.com has it all. You simply search the forums for the dashboard you are looking for and add it to your account. Some of the features have been provided by some of the brightest minds in the Analytics field, so you can always guarantee quality. You can also upload your own report, segment or dashboard by signing up. Hopefully I will see a few of you over there in the near future.

Check out CustomReportSharing.com here

GA Debugger – Firefox/Chrome

The GA Debugger extension is great for looking at useful information about your GA installation, providing any error or warning messages direct into your JavaScript console. This can be easily located either by selecting Inspect Element and choosing Console in Chrome, or opening Firebug and navigating to the Console in Firefox. I tend to use this tool when checking to ensure correct set-up and that any cookies are being passed correctly.

Get GA Debugger here.

URL builder

We tend to be involved in creating campaigns on a regular basis, with each one needing to be tracked. Whether it is PPC, Display Ads, Media Campaigns or you are tracking traffic generated by your outreach team having an understanding of where your visits come from is essential. For those who are working with single URLs, Google has provided a very simple tool that allows you to add the data that you require for it to generate the required string here.

However, in most cases you would want to create multiple tags in one go, and be able to keep a track of those for future reference. We were conducting a lot of campaigns, and to make things easier I decided to create a spreadsheet that emulated the Google URL Builder. This allowed us to create hundreds of campaign tags very quickly and easily. This has saved me lots of time in the past and I hope it will do the same for you.

Google URL Builder
Daniel’s Campaign Builder Spreadsheet – Please make a copy.

Table Booster

The Table Booster Chrome plugin is a great way to further enhance your view of the data grid within Google Analytics by providing three different visualisations for every column.

Download Table Booster here

SEO Tools for Excel

For those of you who haven’t heard about SEO Tools for Excel, where have you been? You need to go and download it right now, well, after you have finished reading this post. SEO Tools for Excel is great for lots of different SEO jobs, and has automated a lot of processes that we do; however, one part I feel is not used as much as it should is the Google Analytics integration.

The integration allows you to run reports straight from the Google Analytics API (similar to the magic script) into your spreadsheet with no coding required. Once you have set up the report and you have all the data that you need, it becomes purely a case of adding the data into a format that works for you as a business or your client.

Get SEO for Excel here.

Chartelligence

This Chrome plugin has been great. Similar to Panguin, it overlays in your Google Analytics account and provides the dates for the latest Google algorithms to easily identify whether you have been hit by a penalty.

Another awesome feature that Chartelligence has is the ability to upload your own holidays, events and site alterations so that you can see what has affected your website during different periods of the year. Over the past few months, I have been using this plugin more and more, and I feel that you should be to.

Get Chartelligence here.

So that’s it – these are some of the tools I use regularly when looking into Google Analytics. What tools, plugins or extensions do you use to enhance Google Analytics? I would love to hear your thoughts in the comments below or on Twitter @danielbianchini.

Thanks to Dan Barker, Anna Lewis, Charlie Williams and Bridget Randolph for their contributions.

Plugging the link leaks, part 2 – site canonicalisation

Posted: 22 May 2013 01:39 AM PDT

A couple of months ago we took a look at how you can reclaim links that you are simply throwing away. For the second look at how to fix common link leaks, we're going to look at issues around site canonicalisation, and how easy it is to lose link authority through simple duplicate URLs.

As before, this is a simple way many sites lose valuable links without even realising. By plugging these leaks, we’ve helped clients gain an instant boost in link authority, without irking anyone on Google's anti-spam team.

The many faces of a homepage

The best place to start when digging for link leaks is actually one of the checks you should carry out when looking at a new or prospective client for the first time – how many ways can you find the site homepage? Type your domain name into your browser, and then do the same for all the possible variations:

http://www.example.com
http://example.com
http://www.example.com/index.htm (or index.html, .aspx, .php or whatever the CMS/server uses)
http://www.example.com/

Does the homepage come up for more than one of these? If so, take a look in Google using a site: search for each to see if they have been indexed. If they redirect, did they redirect using a 301 redirect, which indicates the file has permanently moved? You can check via a tool such as the Redirect Path Chrome extension or an http header checker. If the redirect is not a 301 (for example, a 302 has been used), you had better go and see if that page has been indexed.

Why does this matter? Well, for all Google's power and expertise, in some ways it works in a very simple, black-and-white manner. As each of these different versions of our homepage could, in theory, contain different content, they are regarded as different pages by the search engines.

This means each of these pages can be considered duplicate content, as Google and the other major search engines see two, or more, pages with the same content. Even worse, this is bad for SEO efforts, as it dilutes your inbound links between these different URLs; if someone links to a different variation of your homepage to the one you expect, that link equity simply leaks away. Got links pointing to the wrong version? They don’t count.

An example

But just how bad can this be? Don't most people simply link to the main version?

Our site's homepage has a large amount of links to both the www and non-www version

Oh. That's bad. That's really bad.

Here you can see with a quick search in Open Site Explorer (and it works just as well with MajesticSEO and Ahrefs) a site that is losing a ton of link equity to its homepage by having links to both the www and non-www versions. A look for the brand name in Google and Bing reveals they have both selected the non-www version to show in their results pages.

If we look at the links for the entire subdomain in MajesticSEO and Open Site Explorer it gets worse.

A look in OSE shows there are many links to the www sub-domain

MajesticSEO also shows links to the www sub-domain that are 'leaking' away

This site is leaking links not just to the homepage, but to multiple pages, and losing huge amounts of link equity.

Once you've checked for your homepage, and looked to see how many links leaks have sprung up as a result, you might want to check to see if these variations have occurred on any inner pages. This is a less common issue than the homepage, but still something we see regularly.

Firstly, to check internally, do a crawl of the site using a tool such as Screaming Frog and navigate to the page titles tab. Here you can filter for duplicate title tags; if you have duplicates, check to see if these are variations of the same URL. If any are, that means that somewhere on the site you have internal links pointing to different URLs for the same resource.

Then, to see if Google is finding duplicate versions, take a look in Google Webmaster Tools. Navigate to the HTML suggestions tool in Diagnostics, and look for duplicate title tags and meta descriptions, again checking to see if there are any pages with multiple URLs for the same content. Wherever you find different ways to reach the same URL, make a note of them for later.

Checking Webmaster Tools for duplicate versions of the same page

Fixing the link leaks

Regardless of where you found your links leaks, you want to plug them. Fortunately, in most cases this is a relatively straightforward job.

Now of course, the best solution to plugging this kind of link leak is to set up your site's architecture so that duplicate URLs cannot occur. Of course, with many CMSs and site set-ups, this can be tricky.

So, the next alternative is to put in place site-wide redirects that automatically redirect to a consistent version of each URL. Canonical issues you should be sure are correct include:

Redirecting either www or non-www version (whichever you are not using)
Redirecting /index.html, or equivalent, URLs
Ensuring all URLs use the same characterisation – normally set as lowercase
Use of trailing slash at the end of a URL – do you want to use or not?

Doing site wide redirects this way allows you to capture common duplicate URLs in one stroke. They are not always possible, however, so instead you'll have to do individual redirects. If this is the case, make sure you capture every duplicate page that you have linked to internally, and that it is appearing in Google and Bing's indices. Site: searches and a check of Google Analytics landing pages can also help, as can a thorough check of backlink targets from your tool of choice.

There are not necessarily right or wrong choices of the URL version to use – the important thing is to consolidate all the options into one URL for each page, and to be consistent. In most cases the most powerful, consistent format will be clear. 301 redirects need to be created so that each page or resource can only be reached by one URL. You want to set it up so that if someone links to, or types in a different variation, say http://www.example.com/PageTitle or http://example.com/pagetitle, they are 301 redirected to http://www.example.com/pagetitle. By using 301 redirects, all or nearly all of any link juice that page has accrued will be passed along to the target URL.

In the example above, we added a redirect sending the www versions of each page to the non-www version, and immediately got an extra 120 linking domains for the site’s homepage.

There are, however, times when, sadly, implementing 301 redirects is not possible, either through lack of access to a client's developer, or CMS limitations. When this occurs, our third choice of solution is rel=canonical tags.

Rel=canonical should only be used if other options are not possible, or in conjunction with 301 redirects if you are worried that there are so many variations of a URL out there that you want a 'belt and braces' approach.

The rel=canonical tag gives a strong indicator to the search engines that we want the URL in the tag to be regarded as the primary version of this page, and other variants (marked with the tag) to be regarded as duplicates, not to be indexed. This often works extremely well, but does have a couple of disadvantages.

Firstly, whilst it is a strong hint, and Google will generally honour the canonical request, it does not have to, should it have reason. Google has said that it is better to fix site issues in the first place, or use 301 redirects. Secondly, using this method means that these pages can still be crawled, so you are wasting crawl budget on pages that you don't even want Google to index. Finally, there is no guarantee that other search engines will listen to your canonical tag, and that might be important in certain countries your site may be targeting.

However, despite this, the rel=canonical tag can be helpful if you genuinely can't redirect your duplicate URL variations. Not only will Google generally index your preferred URL, they will also try and consolidate all the links pointing to the different URL variations and apply them to the specified canonical address, getting you back your lost link authority. As Google put it themselves in this handy recent post on rel=canonical mistakes:

The rel=canonical link consolidates indexing properties from the duplicates, like their inbound links, as well as specifies which URL you'd like displayed in search results.

Next you want to check your Screaming Frog internal crawl, and go to the Advanced Export option in the main navigation and select 'Success (200) In Links'. Take this export into Excel, and turn it into a table (ctrl + t). Filter the Destination column by your duplicate URLs (that you noted earlier) to find all the internal links pointing to each non-canonical variation. You can then pass this on to your client or developer so all the incorrect internal links can be fixed. The least you can do is make sure you are not directing any users, and no search engines, to the wrong URLs!

Finally, if you haven't already, verify both the www and non-www versions of your site in Google and Bing Webmaster Tools. Not only will this allow you to spot issues the search engines are having with your site, but you can explicitly request which URL variation you want to show in the SERPs with Google Webmaster Tools, but only if you've proved you own both (another clue that different sub-domains are regarded as separate sites if the above was not enough).

Choosing your preferred domain in Google Webmaster Tools

And that's it. A relatively straightforward process, but as the examples above prove, one that can reveal a rather tasty number of links that are simply leaking away. As with link reclamation, for only a couple of hours' work you can give your site a boost of link authority that you’ve already earned.

Do you have any examples of helping a site leaking links this way? Or advice on how to check, or remedy, multiple URLs for the same resource with a particualr CMS?

Seth's Blog : On adding a zero

On adding a zero

What happens if, instead of one sales call a day, you make ten?

Or if instead of 3 freelancers working on scaling your work, you have thirty?

What happens if you add a zero in places where it feels impossible to handle... what then?

Scale isn't always the answer, but if it is, then scale. Build the systems necessary to dramatically change your impact. Halfway gets you nowhere.

• Email to a friend •

vineri, 24 mai 2013

Mish's Global Economic Trend Analysis

Beppe Grillo Supports "Referendum on the Euro Within a year"
Discussion in Spain on Leaving the Euro; Euro Exit Manifest
Greek Debt Unchanged Since 2010; EU to Give Greece Still More Time; More Time Is Useless
Another Look at Bernanke's Employment Recovery in Chart Form

Beppe Grillo Supports "Referendum on the Euro Within a year"

Posted: 24 May 2013 04:17 PM PDT

Via google translate from Corriere Della Sera, Beppe Grillo is in favor of a "Referendum on the Euro Within a year"

"Europe needs to be rethought. We consider just one year of information and then hold a referendum to say yes or no to the euro and yes or no to Europe. " Beppe Grillo to ride a strong theme of the last election campaign the 5 Star Movement. "Europe on the euro and the British teach us democracy. No party can claim the right to decide for 60 million people. "

"I want to go to Europe and re-discuss a Plan B to be in five years, "added the leader M5S, explaining:" When we do, then we are ready for a referendum and we decide whether to stay in the euro or not."

Sooner or later this sentiment is going to catch fire. And the sooner the better for Europe when it does.

Also see Discussion in Spain on Leaving the Euro; Euro Exit Manifest.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

Discussion in Spain on Leaving the Euro; Euro Exit Manifest

Posted: 24 May 2013 11:07 AM PDT

Some common sense discussion is taking place in Spain regarding the necessity of Spain exiting the eurozone.

For example, please consider Opposition to the euro breaks: first manifesto to leave the single currency as translated from El Economista.

The political opposition that Spain remains part of the euro begins to crystallize. And the tool to achieve that end-Spain output of the single currency is again signing a manifest public that, for the moment, has already been signed by around 1,000 professionals convinced "the risks of deterioration and degradation that there are the enormous social suffering caused by the persistence of adjustment policies, austerity and privatization of the public ".

Among the signatories are former general coordinator of United Left (IU) Julio Anguita or economists Juan Francisco Martín Seco and Pedro Montes, Manuel Monereo addition, Manuel Muela and Carlos Martinez, president of Attac Spain, or exsindicalista Agustin Moreno. Written Signatories to the start for a first finding analysis: the level of unemployment is "catastrophic "the indebtedness of the Spanish economy to the outside is" unable to cope "and the evolution of public accounts leads inexorably to the" economic collapse of the state ".

Specifically, they say, more than six million unemployed, more than 2.3 billion euros of gross liabilities from the outside and a public debt of almost a billion euros, growing and already close to 100% of GDP, "are data defining an unmanageable mess, endanger destroy coexistence and social rights. "

"Spain Must Have a Plan to Exit the Euro"

Also note an article on El Econimista Jose Carlos Diez: "Spain Must Have a Plan to Exit the Euro"

Jose Carlos Diez, chief economist at Intermoney, feels Spain should not be the first country to leave but "should have a plan to do it." This was pointed out in a meeting he had with el Economista.

Spain should never be forced out. We are a big country in Europe, and we must enforce our political weight, seeking alliances to solve the crisis. But if Portugal or Italy decide to leave the euro, we must have a plan to get out that day, "he answered a question from a reader. "I hope that there is intelligent life in Europe and that day may never come," he added.

Euro Exit Manifest

The talk has started. That is the first step. Inquiring minds may wish to read the Euro Exit Manifest mentioned in the first link.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

Greek Debt Unchanged Since 2010; EU to Give Greece Still More Time; More Time Is Useless

Posted: 24 May 2013 08:11 AM PDT

Greece was supposed to get it's debt to GDP ratio to 100% by 2012, then 100% by 2013, then 110% by 2014. Now Jeroen Dijsselbloem, president of the Eurogroup finance ministers, says Greece May Get Still More Time to meet fiscal targets.

And the alleged level of debt sustainability keeps rising all the while.

The euro zone may give Greece more time to meet fiscal targets agreed under its international bailout, the chairman of the euro zone finance ministers said in an interview published today.

"The Commission΄s approach regarding fiscal consolidation is more flexible, giving certain countries more time to meet their targets. I believe that this will be the case for Greece if needed," Jeroen Dijsselbloem told Kathimerini newspaper.

Greece΄s European partners agreed last year to extend the maturities and reduce the interest on the nation΄s bailout funds to help cut its debt mountain to a more sustainable level of 124 percent of GDP in 2020, from an estimated 173 percent this year.

Greek Debt Unchanged After Massive Bailouts and Haircuts

Note that the sustainable level of debt is now 124% of GDP, ratcheted up numerous times in the past couple of years..

Keep Talking Greece has some rather interesting facts about Greek debt in its report 2 bailouts + 1 haircut = Greek public debt at €309.4 billion in 1Q 2013, as much as in 2010

Two bailout agreements, total aid of 240 billion euro, and one bonds' 'haircut' later…. Greek public debt remains as high as it was in 2010 – the year in which Greece sought the 'rescue' by the International Monetary Fund.

2010: Public debt: 310.3 billion euro
2013: Public debt: 309.4 billion euro

The public debt is almost the same, we are all still sitting on the same old boat. Just the economic situation of the average Greek is much worse: bankrupt households, unemployment at 27% and 64% among youth 15-24 years old, recession and even deflation. Oh, and a sharp rise in suicides and homeless.

I hope nobody remembers Evangelos Venizelos, finance minister in March 2012, heralding after the Greek bond swap (53.5% haircut) "we got rid of 100 billion euro debt."

More Time Is Useless

By now it should be readily apparent the situation is totally and completely hopeless.

Greece will not reduce debt to 124 percent of GDP by 2020 from an estimated 173 percent this year, unless of course Greece defaults.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

Another Look at Bernanke's Employment Recovery in Chart Form

Posted: 24 May 2013 12:38 AM PDT

Reader Tim Wallace took note of Bernanke's testimony on jobs (see Bernanke's Semi-Annual Tap-Dance of Distortions, Half-truths, Lies, and Hypocrisy to U.S. Congress) and sent me the following chart.

April Employment vs. April Employment in Previous Years

click on chart for sharper image

Tim writes ...

Hello Mish

Bernanke was touting the direction of employment using the familiar "7.5%" numbers and pointing to all the improvement. While granting that more people are working now than in 2010, we recognize that more people are working part time and less people are working overall than in 2008.

This got me wondering how long it took to recover to pre-recession employment numbers in the past.

Up until the recession of 1982, All drops in employment from one year to the next had fully recovered to new employment highs within 2-3 calendar years. In the recessions around 1982, 1991 and 2001, job recovery took about three calendar years.

In our current malaise, we have been at this 5 years and employment is still 2.2 million people below the employment number in April 2008. Moreover, part-time employment is up about 2 million workers. Thus, full-time employment is 4 million below the 2008 number, 5 years ago.

Tim

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

sâmbătă, 25 mai 2013

8 Great Tools to use with Google Analytics

8 Great Tools to use with Google Analytics

ScreamingFrog

GA Copy and Paste

CustomReportSharing.com

GA Debugger – Firefox/Chrome

URL builder

Table Booster

SEO Tools for Excel

Chartelligence

The many faces of a homepage

An example