Getting Started with Macros for Excel

Microsoft Excel is almost universally regarded as the gold standard of spreadsheet software, but most users only scratch the surface of the program’s immense capabilities. At Hall many of us use Excel every day to analyze data from Google Analytics, site crawls, and other sources. Part of this process involves formatting raw data – for…

Getting Started With UTM Parameters

A UTM code is a tag added to the end of a URL which, once clicked by a user, sends data back to Google Analytics. UTM codes allow you to track which elements of your online marketing strategy are most effective, from links on an email to content shared via social media. “UTM” stands for…

2 Google Analytics Tips for Managing Page Errors

For this exercise, you’ll need to have a website with Google Analytics installed and a custom 404 page with a unique page title distinguishing it from other pages. How do you know if you have Google Analytics and a custom 404 page set up? First visit GA Check for Google tracking verification. For the 404…

Using Internal Site Search Reports to Improve UX

As an SEO, you are most likely very used to the practice of matching a specific keyword with a desired landing page on your site. You likely do this daily. Similarly, we can use an Internal Site Search report data from Google Analytics to help users get to their desired content on your site in…