How To Use Excel To Easily Spot SERP CTR Trends
Get better insights from your SERP Impressions Vs Clicks report with Excel wizardry for SEO content teams.
Please visit Search Engine Land for the full article.
Uncloaking Keyword-Specific Organic Traffic To Your Site In The Not Provided Era
Google recently released news that it is now moving to encrypt all organic search activity. This means that analytics programs will no longer be able to report on keyword terms that drive organic traffic from Google, instead noting the data as being “not provided.” This could be…
Please visit Search Engine Land for the full article.
Measuring The Effect Of Semantic Markup On Your Search Traffic
There’s a lot of buzz these days around the wonderful world of Schema, semantic markup, and rich snippets — much of it centered around the increased click-through rates from SERPs and other amazing SEO benefits such markup provides. But, once you’ve added the markup to your website, how…
Please visit Search Engine Land for the full article.
Fresh Out Of The Oven: Contextual Tastes Way Better Than Cookies
In recent years, using cookie data in behavioral targeting strategies has been heralded as a game-changer by online marketers. A large part of this attention is focused on data management platforms (DMPs) that enable behavioral targeting through the use of cookie data to categorize a user’s…
Please visit Search Engine Land for the full article.
Fifty Shades Of Full Value
I recently saw an incredible presentation by Google Analytics guru/evangelist Avinash Kaushik on “understanding the full value of mobile.” The concept – at least on its face – is simple: to understand the value of a mobile click, you have to look beyond immediate conversions and give…
Please visit Search Engine Land for the full article.
Tips for Analyzing The Impact Of Your Marketing Activities In Google Analytics
I work with a wide variety of clients across a wide variety of industries, and one of the most common issues I come across is what I call analytics forgetfulness. What typically happens is that a company will devise a plan to improve their online marke…
5 Excel Skills Every Marketer Should Know
One question I get asked a lot is this: what Excel skills are most important for marketers to learn? I have whittled that interminable list down to five skills that I believe are absolutely essential for marketers to know, presented below in order of i…
Using Advanced Segments & Scroll Depth To Test Content Types In Analytics
Last month, I gave readers some tips on measuring engagement using Google Analytics and WordPress. This month, I want to dig deeper into how you can use content scroll depth to help craft a strategy for your future content curating efforts. Creating a …
Deduplicate Your Google Analytics Reports in Excel
One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received traffic in the past year. This can be accomplished by pulling a landing page report and using VLOOKUPs in Excel to see any of your …
Building A Macro To Download Webpages With Excel
When conducting research, it’s not uncommon to perform repetitive tasks like downloading a group of webpages. A favorite tool I use to automate this is iMacros — it’s free and powerful. Just be sure to use the Firefox version, as its capabilities are limited in other browsers like…
Please visit Search Engine Land for the full article.