Halting the Headaches: Why Online Forms Help Measure Your ROI

Investors can measure ROI in real time. They purchase a stock, and by looking at the stock’s price at any given moment, they can instantly know if the ROI rate is positive or negative.

If only it were that easy for marketers. Continue reading


TeamKeeper: Modernize Talent Retention with Management Analytics

A new hire aced the interview, but hasn’t performed as well as expected. Team members aren’t hitting quotas because they aren’t receiving proper coaching. Talented salespeople are leaving the company because they don’t feel engaged with the work.

The sales manager plays a critical role in all of the above scenarios. Strong managers are key to an organization’s success, but only 12% of U.S. employees strongly agree their managers help them set work priorities – and those 12% are much happier in their work than the others. Continue reading

How to Uncover Hidden Keyword-Level Data Using Google Sheets

Posted by SarahLively


Keyword-level data isn’t gone, it’s just harder to get to. By using Google Sheets to marry the data from Search Console and Google Analytics into a sheet, you’ll have your top keywords and landing page engagement metrics together (for free!). It’s not perfect keyword-level data, but in 7 steps you can see the keywords that drove clicks to a page and the organic engagement metrics for that page, all together in one place. The Google Analytics Add-on for Google Sheets will pull organic landing page engagement metrics, and the Search Analytics for Sheets Add-on will pull the top queries by landing page from Search Console. Then, use VLOOKUP and an Array Formula to combine the data into a new tab that has your specified landing pages, the keywords that drove clicks there, and the specified engagement metrics.

What do you mean you don’t know which keyword drove that conversion?

Since the disappearance of keyword-level data in Google Analytics, SEOs have been struggling to tie keyword strategies to legitimate, measurable metrics. We put much of our time, resources, and research efforts into picking the perfect keyword theme, full of topically relevant terms that leverage new semantic strategies. We make sure to craft the perfect metadata, positioning our top keywords in the right place in the title tag and integrating them seamlessly into the meta description, but then what? We monitor rankings and look to landing page metrics, but all of our data is disjointed and we’re left to extrapolate insights based on a limited understanding of how our themes are truly performing. Continue reading

How to Implement Google Analytics Custom Groups with Google Tag Manager

Google Analytics Content Grouping

In a previous article, I shared how to implement Google Tag Manager and Universal Analytics. That’s a fairly basic starter just to get you off the ground, but Google Tag Manager is an incredibly flexible (and complex) tool that can be used for dozens of different strategies.

While I realize some development could alleviate some of the complexities of this implementation, I opted to go manual with plugins, variables, triggers and tags. If you have a better means of implementing this strategy without code – by all means share it in the comments!

One of those strategies is the ability to populate Content Grouping in Universal Analytics using Google Analytics. This article is going to be a combination of a rant, problems to be aware of, and a step-by-step guide in specifically implementing Content Grouping using DuracellTomi’s Google Tag Manager plugin for WordPress, Google Tag Manager and Google Analytics. Continue reading

How to Install Google Tag Manager and Universal Analytics

We’ve been converting clients over to Google Tag Manager recently. If you’ve not heard of tag management yet, we’ve written an in-depth article, What is Tag Management? – I’d encourage you to read through it.

What is a Tag?

A tag is a snippet of code that sends information to a third party, such as Google. If you don’t use a tag management solution such as Tag Manager, you need to add these snippets of code directly to files on your website or mobile app. Google Tag Manager Overview

Aside from the benefits of tag management, Google Tag Manager has some native support for applications like Google Analytics as well that you’ll want to take advantage of. Because our agency works quite a bit on content strategies for our clients, we’re configuring GTM across our clients. With Google Tag Manager and Universal Analytics, we can configure additional insights with Google Analytics’ Content Groupings without having to edit core code on our clients’ sites. Configuring the two to work with one another is not for the faint of heart, though, so I want to document it for you. Continue reading

How to Use Search Analytics in Google Sheets for Better SEO Insights

Posted by mihai.aperghis

As an SEO, whether you’re working in-house or handling many clients in an agency, you’ve likely been using this tool for a bunch of reasons. Whether it’s diagnosing traffic and position changes or finding opportunities for optimizations and content ideas, Google Search Console’s Search Search Analytics has been at the core of most SEOs’ toolset.

The scope of this small guide is to give you a few ideas on how to use Search Analytics together with Google Sheets to help you in your SEO work. As with the guide on how to do competitive analysis in Excel, this one is also focused around a tool that I’ve built to help me get the most of Search Analytics: Search Analytics for Sheets.

The problem with the Search Analytics UI

Sorting out and managing data in the Google Search Console Search Analytics web UI in order to get meaningful insights is often difficult to do, and even the CSV downloads don’t make it much easier.

The main problem with the Search Analytics UI is grouping.

If you’d like to see a list of all the keywords in Search Analytics and, at the same time, get their corresponding landing pages, you can’t do that. You instead need to filter query-by-query (to see their associated landing pages), or page-by-page (to see their associated queries). And this is just one example. Continue reading

Digimind: Social Media Analytics for the Enterprise

Digimind is leading SaaS social media monitoring and competitive intelligence company utilized by enterprise companies and the agencies working with them. The company offers multiple solutions:

  • Digimind Social – for understanding your audience, measuring your social marketing ROI, and analyzing your reputation.
  • Digimind Intelligence – offers competitive and industry monitoring so you can anticipate market shifts and identify business opportunities.
  • Social Command Center – a real-time display center to showcase your brand’s social visibility.

Continue reading