There are a number of ways to measure how your SEO competitors are performing in Google using Excel. You’ll need to have ranking data for both you and your competitors, as well as search volumes of your competitors. I’ll also cover how to do this to analyse link...
Analytics Posts
What is Page Value in Google Analytics and how to use it to measure ROI of content marketing
So, you’ve built a great asset on your site. It cost you 10K to build, plus media spend to get the word out on social, and now you have to report to the boss/client on how well this piece of work did. You can report on how many sessions it received and how many links...
Bounce rates: A guide to keep your site bobbing along
Quick, we need to report on some engagement metrics! How about bounce rate? Sure, why not? This post will foray into “what even is bounce rate?” as well as some good ways to analyse it for different aspects of digital marketing. What is a bounce rate? For this, we’ll...
Should you invest in a premium web analytics platform?
When choosing a web analytics platform, you must assess what will be most beneficial for your site. Key things you should be asking are: Is the site big enough to warrant a more premium analytics package? How many visitors does it receive a month? Do I utilise all the...
Excel for Search: How to analyse keyword fluctuations
Excel is a much more powerful tool than we often give it credit for. In fact, with the tools and reporting that can be made with Excel, I think its uses far exceed its initial purpose. So, how can we use Excel within Search? We’ve already shown one method in a...
Boosting content offering with SEMrush
SEMrush is a great tool for SEOs to get access to keyword and competitor data in an easy to use interface. It also provides the ability to export ranking data quickly for potentially thousands of terms. With this data, we can analyse the content on a domain and...
Google Analytics Multi-Channel Funnels and Assisted Conversions guide
Google Analytics is frequently relied on by digital marketers like you to report on how their campaigns are performing. You go to your favourite report, look at the “goal completions” column and put it in a spreadsheet. Done. What does “Our organic campaign drove 175...
Custom Content Groups in Google Data Studio
Customising Content Groupings or Channel Groupings within your Google Analytics account can be a great way of better attributing marketing efforts, or even just looking at the data a different way. But the issue, like all things GA, is that they only take effect once...
10 hidden gems of Google Analytics
I was once told by a client that they wanted to know how to "track everything" with Google Analytics. They were very excited about adding event tracking to every possible click and interaction with the website. While that is possible, it's good to take a look at what...
Google’s Data Studio quietly adds data export functionality
There have been some good updates to Google Data Studio in recent months, with Google's data visualisation platform being enhanced for the better with some extended functionality. We’ve had some fun with Data Studio over the last year; it is a great way to quickly...