I Make Data Sexy
If you had the good fortune of attending the Interactivity Digital conference, here are the slides and links from my presentation. I talked about a handful of off-the-beaten-path KPIs you should be monitoring for both organic and paid campaigns. You can either access the links from within the presentation or get them from this bitly [...]
UPDATE: If you would like to add your company to the list, please fill out the form below. I’ll add them in batches. Thank you for the overwhelming response! Best. Industry. Ever. BlueGlass employees were informed Monday afternoon that they had been terminated, leaving the BlueGlass Tampa office eerily vacant. But what did the industry do in [...]
Normally, in Google Analytics, if you create a custom report and you need more than one dimension, you create drill-down dimensions like this: However, if you want to export that, you’re only going to see in the export whatever you see on your screen, i.e., a list of landing pages or a list of keywords [...]
UPDATE: Google Analytics now gives you up to 5000 rows, so you don’t need to do this trick unless you have > 5,000 rows in a report. Thanks, Goog! When you create a report in Google Analytics (GA), the interface limits you to 500 rows. You can get around that limit though. Your browser will probably [...]
By popular demand, I’ve created a video walk through of how to create and customize pivot tables. If you haven’t use pivot tables, they are especially useful in large data dumps exports, such as those you get from analytics applications like Google Analytics, Screaming Frog exports, and link reports (e.g., Open Site Explorer, Majestic, and [...]
I noticed an extra icon in my Gmail and decided to explore it. Turns out, Google has dialed up its Gmail/Drive integration by allowing users to send large files with Drive — up to 10gb. In an effort to nudge people to use its new compose feature, Google added this feature. But it doesn’t work [...]
I had to get down and dirty with Google Analytics this week to analyze how mobile users were faring on a client’s site. Spotting an anomaly in the data, figuring out what was causing the issue came down to screen resolution. I came across a site with a comprehensive list and, of course, scraped it [...]
Last week I wasted an entire afternoon because of an errant bug in my Excel that prohibited me from being able to use Excel’s Paste Special dialog. When I’d select Paste Special, I’d get this useless menu: After reinstalling Microsoft Office, I was dismayed to find out the bug was still there. Turns out the [...]
Trying to rope up traffic from image search is like trying to nail jello to a tree. To keep us on our toes, Google moved its image search engine from images.google.com to google.com in May 2010, then apparently moved image search from referral reports to organic reports in July 2011. (You can keep abreast of [...]
This isn’t new news by now, but I released a Google Doc with hundreds of tools that marketers can use. To make tools easier to find/use, I broke the doc down by task instead of the tools themselves. How It’s Organized The spreadsheet is broken into 14 categories: SEO Analysis Domain Links Keyword Competitive Analysis Tracking [...]
But enough about me ...
My renewed goal in this blog is to provide marketers with bite-size tips, strategies, tricks, and warnings in the pursuit of gathering and visualizing data. Basically, I ask myself, "Could this possibly make a marketer's job easier? If so, could it be digested in 5 minutes max?" If the answer to both those questions is yes, I go for it.
[Read More …]
