Analytics & Tag Manager Blog

12 Months Later & I am Finally Google Analytics Qualified!

Today I finally got around to taking the Google Analytic Individual Qualification (GAIQ) exam that I have been meaning to take for the last 12 months. Although disappointed in the score (88%), I am glad that I have passed and got it out of the way, and can now say that I am a qualified user of Google Analytics.

Now that I have passed I wanted to provide you guys with some tips and suggestions that you might like to use when taking your exam. Although I didn’t think the exam was ridiculously difficult, I did find that the hardest part was to decipher what Google were providing for the multiple choice answers. Depending on how you read the question, you may provide completely different answers.

Blog General

Moving to SWBroadband Hosting

SWBroadband - Web Hosting ProviderOver the last few years I have been meaning to move away from my former web hosting company Real Web Host. There was no specific reason for moving as I had been with them since I was at University, but I wanted to move to a UK based server and collate all my domains/hosting in one account.

Moving web hosting provider always felt as if it was going to be a painful experience, probably the reason I had put it off for such a long time. During this time I spoke to lots of people who had bad experiences with providers such as 123reg and Fasthosts, that I decided to bite the bullet and stay where I was.

Blog Presentations

SEO Promotion in Online Marketing [Presentation]

On the 6th December 2010 I was asked to speak at Oxford Brookes University to a class studying for their Master’s in Business.

The presentation focused around using SEO as part of an online marketing campaign. Please find the slides below.

Blog SEO

5 Tools for Creating Awesome SEO Reports

This post was originally published on Search Engine Journal

Do you spend hours hacking around Microsoft Excel every month to create a compelling SEO report for your clients, knowing that they are probably not going to get read or even opened?

In my post below I have provided five tools that can help improve your SEO reports, taking them from being the standard Excel spreadsheet to a report that can be given to anybody at any level within your client’s organisation.


Price: Offers three different pricing plans – 30 day trial available.

Shufflepoint is a web-based application that integrates directly into Google Analytics to provide reports straight into Microsoft Powerpoint, Excel or bespoke gadgets.

Since using Shufflepoint to create SEO reports, things have become so much simpler. By connecting directly to Google Analytics I am able to create reports based on the templates supplied by Shufflepoint, or I can create customised templates with the support of their technical team.

Using the drag and drop query tool I can quickly import all the relevant data from Google Analytics directly to either Powerpoint or Excel in a visually pleasing format. Once the data has been imported I work through the document adding commentary to each slide to provide the user with some text analysis alongside the graphical representation.

Although Shufflepoint’s main feature is to integrate into Google Analytics, they are continuously growing, by supporting other data driven-platforms including:

  • Google AdWords
  • ZoomRank
  • KeywordEnvy
  • Constant Contact

Another cool thing when using Shufflepoint is the auto refresh and delivery function that is installed with the application. Most of the reports generated have the same top level metrics, and this means that each month I am copying and pasting the same charts and graphs. With the auto refresh and delivery feature the reports are automatically updated, leaving me only having to analyse the data downloaded and write detailed commentary to accompany the graphs created.

Creating SEO reports previously took a lot of time, but since I have been using Shufflepoint my reporting time has been reduced, allowing us to concentrate more on the actual work.

Analytics Canvas

Price: Starts at $49 a month + free trial

Analytics Canvas allows you to bring multiple Google Analytics accounts, profiles and campaigns together all under one dashboard.
One of the most frustrating things I find when generating reports for large clients is the tooing and froing from analytics accounts and profiles. Large websites tend to have multiple analytics accounts for different areas of their website but want reporting based on the entire website.

Analytics Canvas allows us to import Google Analytics data in from multiple accounts to a single dashboard to analyse a combined data set, as well as individual profiles. By using the Analytics Canvas data blocks to combine, filter and drill down into the data gathered, you are able to carry out a more thorough analysis.

Once you have created multiple dashboards and utilised the data blocks to their full potential you can export all the data to Excel to create visual representations of the data in the way of graphs and charts.

I have used Analytics Canvas for generating large data sets to analyse and find trends across multiple websites that you might not otherwise be able to see. Using the full power of Analytics Canvas has allowed me to find and provide information to clients that might not necessarily have been identified previously.
The reports generated have saved a large amount of time, but most of all have allowed us to improve our reporting to our clients.

Workbooks CRM

Price: Free

Workbooks is a web-based CRM system which, as well as its obvious customer management uses, has some great SEO and PPC applications.

Traditional reporting tools can only show you a limited part of the buying cycle; you get as far as clicks or conversions (whatever they may be) but no further, and for a lot of sites this won’t show the whole picture. For example, if the aim of your site is to generate leads through an online form you may track conversions as someone filling in a form. While this is useful, it doesn’t take into account the quality of the lead generated. It may be that what you thought was the best keyword to focus on (because it generates the most leads), is actually the worst, as none of the conversions are of good enough quality. Unconverted leads won’t generate any ROI.
This is the gap that Workbooks fills in your reporting. Using cookies, Workbooks is able to track from first touch all the way through to conversion from the site, and then on to completion of the buying cycle. With all this information you are then able to produce incredibly insightful reports and calculate ROI down to keyword level, allowing better analysis of SEO and PPC campaign effectiveness and improved efficiency in the allocation of budgets. Reporting on ROI will also give the best justification of tactics and really prove your worth.

Use APIs

Price: API Dependent

Most analytics applications or reporting software will provide a free API for you (or your developer) to use. These APIs allow the developer to extract and manipulate information from a specific application or software to use as they require, providing they are within the licensing terms.

APIs become considerably more powerful when they are used alongside each other to create large data sets. Consider the information that you could get if you combined Google Analytics, Google Adwords, Raven and the MajesticSEO APIs together. Gathering information from these different areas could provide you with some very interesting data to analyse and make decisions.

The biggest advantage of using APIs for applications such as Google Analytics is that it helps you to create in-house tools or applications to extract data that you generate on a regular basis quickly and efficiently. Whether you want to upload that information to an internal network or directly into a document for further manipulation, all depends on the skill level of the developer.
Putting time and effort into learning how APIs work and how to get the most out of the web will help you create some great tools and find some interesting data.

For our clients, we currently use APIs to help us generate SEO reports that are time consuming. Using APIs alongside other 3rd party tools helps provide a more informed and actionable report.


Price: $49

Linkdex is an SEO tool predominately used for link building, although there are other aspects to the software including keyword ranking, task management and auditing.

The biggest asset that Linkdex possess is in its link building and prospecting suite, with some very impressive tools. What makes this tool different to all the rest on the market is that it uses the MajesticSEO index and adds an extra filter on it to remove any links deemed not to be influential. Other features, such as checking to see if the link still exists on a regular basis and showing a timeline of links that are built over a period of time, also stand out.

When creating SEO reports, I believe that incorporating link building progress is a must have and using the graphs and charts provided by Linkdex does exactly that.

Using the timeline chart you can see the progress of the link building campaign by seeing how many links had been created at the start of the program and how many have been built at present. This report will show the client a clear indication of how many influential links have been built to their website. Another good report to show is the site type reports, which splits all your links by the type of platform that they are built on. If you use this report and compare your site to your nearest competitor you can see where you might need to improve by identifying areas that they are stronger in.

Using Linkdex’s link building reports to add to your SEO report will provide a more thorough link building analysis to your client. Since link building is a very important part of SEO, it is imperative that some kind of analysis is included, and if they aren’t already then you should definitely do so moving forward.

Blog Events Presentations

SEO Tactics to Tame the Panda

On Tuesday I gave my first conference presentation at A4U London alongside SEOptimise Director of Search Kevin Gibbons.

View more presentations from Daniel Bianchini
Blog SEO

Should Your Brand Use Online Video?

Online video is exploding onto corporate websites as more and more businesses recognise its marketing potential.

But will this platform work for your organisation? What kind of video should you produce? How can you optimise it?

The right video for you

Different businesses benefit in different ways from online video. A big brand like Coca Cola or a bank might use entertaining content to spread brand awareness, meaning it might publish content that’s not specific to a product.

However, a smaller company would potentially benefit more from producing videos that show how to use its products.

Generally speaking, there are three kinds of video. Conversion videos, typically product information clips; educational videos, which spread brand awareness by offering useful information; and viral videos, which use entertaining content to generate buzz behind a brand.

Blog SEO

Will Changing URLs During a Website Redesign Damage my Search Engine Visibility? – Video

This post is the first in a series of regular video blogs, answering questions that have been directed at me through twitter.

Todays question was:

“When re-designing a website, how important is it to name the pages the same in order not to lose any search engine visibility?”

I hope that you enjoy todays video and I look forward to your comments below.

Copy embed code below:

Transcript coming soon.

Blog Events

BrightonSEO – 9th September 2011

On the 9th September Kevin, Stuart and I attended BrightonSEO a free search marketing conference on the south coast, organised by Kelvin Newman of Site Visibility.

The conference one of the largest on the circuit, hosted many great speakers talking giving away actionable information, along with the odd controversial comment here or there.

I have written a full round up of the day with the majority of presentations included over on the SEOptimise blog. There were a lot of good posts written about the day with a few mentioned below.