article thumbnail

Two Amazing Bar Charts: % Content Consumption, % Share of Search

Occam's Razor

In the second example there is no site analytics data, that bar chart will tell you that you might be celebrating success too early when it comes to Search while pinpointing for you how high the upper limit is. 2: Quantifying the Missed, Search, Opportunity. Two stories. #1: Content marketing is all the rage, as you are well aware of.

Search 135
article thumbnail

Google Analytics Visitor Segmentation: Users, Sequences, Cohorts!

Occam's Razor

In fact I've gone so far as to say: "All data in aggregate is crap." " That's certainly a bit melodramatic, but beyond the most bare bones "ahh, I see something is happening" you are unable to get anywhere with aggregate data. Even though Mr. Green only crossed that limit of 125 across two visits.

Analytics 145
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Data Analysis 101: Seven Simple Mistakes That Limit Your Salary

Occam's Razor

I love that the analyst is segmenting the data rather than showing the aggregate trend ("all data in aggregate is essentially crap" – me). The part that is clean is that there is very little overlap between Search Traffic and Referral Traffic. Making that green graph useless. But Mobile is a platform.

Salary 130
article thumbnail

Lessons Learned: Please teach kids programming, Mr. President

Startup Lessons Learned

But aggregated across many schools, there are thousands or tens of thousands of them. May 16, 2009 1:52 PM Todd Green said. You can find out more at: manning.com/sande Many thanks in advance, Todd -- Todd Green Manning Publications Co. Not all programmers are entrepreneurs, granted there are exceptions. Hello Eric, Great post.

article thumbnail

Benchmarking Performance: Your Options, Dos, Don'ts and To-Die-Fors!

Occam's Razor

Any big changes in your marketing/customer acquisition strategy over the last time period (more money doing Search, less money in Email, elimination Facebook as it does not work, etc., and Organic Search Traffic (can't ever have enough of that!)… Outcomes of the conversations with your Finance team and Sr.

Analytics 133
article thumbnail

Marching through quicksand

Startup Lessons Learned

The biggest lost opportunity of all, though, is this one: we no longer need to rely on scarcity or status-oriented measures to filter which projects should get the green light. link] August 24, 2009 2:50 PM Quentin said. Very good "chewy" stuff, Eric - well done & thanks. Though technology tools and Web 2.0 ideas (e.g.

article thumbnail

Google BigQuery: A Tutorial for Marketers

ConversionXL

Every month, you go to each of these tools and search for useful data to fill your report. Pulling your Google Analytics data into BigQuery has benefits: No sampling; You own the data; Non-aggregate stats; Ability to create custom attribution models , etc. A (not so) hypothetical use case. Put your developers to work. NO * SELECT.

SQL 84