Skip to content
Jul 25 14

Shared Stories from This Week: Jul 25, 2014

by tmllr

Jul 18 – Maybe The Best Article I’ve Read In 2014 by Kevin Hillstrom

Click here to read this article about restaurants and mobile. Seriously. Do it now.Use the comments …

via Kevin Hillstrom: MineThatData


Jul 18 – Eight intriguing digital marketing stats we saw this week by David Moth

The earth has spun around seven times since the last stats roundup, which means it’s time for anothe…

via Posts from the Econsultancy blog


Jul 18 – Voters Are Rational in Midterm Elections by Harry Enten

Are voters rational? Well, depending on the academic research you read, they’re either irratio…

via FiveThirtyEight


Jul 18 – 10 trends that will impact your mobile commerce strategy by Christopher Ratcliff

Finally, mobile devices are at a stage where technology meets and occasionally exceeds the expectati…

via Posts from the Econsultancy blog


Jul 18 – New Google Disclosures Show Strength of Own Websites

Google revealed new details about its advertising business on Thursday that highlighted the strength…

via WSJ.com: Technology


Jul 18 – Guest Blogging: From Overused Loophole to Untapped Opportunity

SEO hearts fell when Google’s Matt Cutts published his “The decay and fall of guest blogging for SEO…

via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


Jul 18 – The Death of Net Neutrality, or: How to Survive the Internet Slow Lane by Josh Patrice

So it’s come to this.
Our last stand against a tyrannical regime. Our last chance for our voices to …

via Conversation Marketing: Internet Marketing with a Twist of Lemon


Jul 18 – Google Honors ‘Right to Forget’ Tantric Workshop

Google has met a request from a man in the Netherlands to drop search results that tie his name to a…

via WSJ.com: Technology


Jul 19 – Dying at the Grand Canyon by Dan Hopkins

The Grand Canyon is a safe place to visit. I’d trade the dangers of most highways for the security o…

via FiveThirtyEight


Jul 20 – Got a BYOD Problem? Blame the Millennials You Just Hired. by Arik Hesseldahl

CREATISTA / Shutterstock
If your company’s IT department is having any troubles wrestling wit…

via Re/code


Jul 21 – Elevating Bread And Butter by Kevin Hillstrom

Have you had a chance to watch this video (click here)?What does bread and butter have to do with yo…

via Kevin Hillstrom: MineThatData


Jul 21 – The Great Bacon Conspiracy by Remy Porter

As an IT infrastructure manager, Jerry spent more time skimming his junkmail folder than he liked. U…

via The Daily WTF


Jul 21 – Why companies should give digital marketers time off for training by David Moth

No one can doubt the importance of enabling employees to develop themselves and learn new skills by …

via Posts from the Econsultancy blog


Jul 21 – 5 Reasons to Invest in Interactive Content by Dennis Shiao

Author: Dennis ShiaoThe first time I downloaded a white paper was in 2000. The first blog post I rea…

via Marketo Marketing Blog


Jul 21 – New Facebook Feature Lets You “Save” Stuff — On Facebook by Peter Kafka

So you’re on Facebook, skimming pictures of your friends’ kids* and clicking on viral c…

via Re/code


Jul 21 – Americans Think Women, People With Business Experience Govern Better by Jessica Sparks

More than 80% of Americans think the U.S. would be better governed by people with business experienc…

via WSJ.com: The Numbers Guy


Jul 21 – Mobile-Ad Spending Leaps

Spending on mobile ads is expected to jump 83% this year, but given how much time Americans spend on…

via WSJ.com: Technology


Jul 20 – Talking Optimization: Post #1 by SEMangel

[Kelly Wortham and I have been talking optimization at X Change for years. Now that she’s part of th...

via SemAngel


Jul 24 - The Analytics Club by SEMangel

Like most of us, I waste a fair amount of time reading on the internet. Some very small portion of ...

via SemAngel


Jul 21 - Yahoo is Buying Mobile App Analytics Platform Flurry by Mona Zhang

Yahoo is buying the mobile app analytics firm Flurry. “[The acquisition] reinforces [Yahoo's]…

via The Social Times


Jul 21 – There’s no mistake in the barley data by David Smith

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

via R-bloggers


Jul 22 – A Statistical Appreciation of the Washington Generals And Harlem Globetrotters by Nate Silver

Red Klotz, the founder and longtime coach of the Washington Generals, the Harlem Globetrotters’ perp…

via FiveThirtyEight


Jul 22 – The Broken Art of Company Blogging (and the Ignored Metric that Could Save Us All) by evolvingSEO

Posted by evolvingSEOThe perception of success
The following screenshot is from an actual…

via SEOmoz Daily SEO Blog


Jul 22 – Which analytics tools do marketers use? And are they paid-for or free? by David Moth

All digital marketing activity is measurable. Right?
It’s nice to think that’s the case and there ar…

via Posts from the Econsultancy blog


Jul 22 – Making the Case for Tag Firing Priority in Google Tag Manager by Samantha Barnes

A great new feature, Tag Firing Priority was rolled out inside of Google Tag Manager around July 1 …

via Increasing your Website’s Conversion Rate


Jul 22 – How to Know if You Have Startup Equity by Mary Russell

catosdomain.com
As acquisitions become more high-profile and high-dollar, the promise of startup eq…

via Re/code


Jul 22 – Talking Optimization: Post #2 (by Kelly Wortham) by SEMangel

Gary,
First, let me say you’re right….mostly. Second, a caveat – many optimization experts will clai…

via SemAngel


Jul 22 – Analysts Say Google is Best Placed for Mobile Growth by Christie Barakat

After Google Inc. posted its 18th straight quarter of 20 percent-plus revenue growth, analysts said…

via The Social Times


Jul 22 – Chuck Schumer Is Wrong About the Top-Two Primary by Harry Enten

In an op-ed in Tuesday’s New York Times, Sen. Charles E. Schumer of New York called for an end…

via FiveThirtyEight


Jul 22 – One Million Net Neutrality Comments Vs. $42 Million in ISP Lobbying by Amy Schatz

Elena Yakusheva / Shutterstock
Newly released lobbying figures show that broadband providers are st…

via Re/code


Jul 22 – Top 10 Data Breaches of the Past Five Years (Infographic) by TSC Advantage

TSC
TSC Advantage is a holistic security consultancy in Washington, D.C. Reach them @TSCAdvantage….

via Re/code


Jul 22 – America’s Favorite ‘Star Wars’ Movies (And Least Favorite Characters) by Walt Hickey

This week, I caught a sneak peek of the X-Wing fighter from the new “Star Wars” films in…

via FiveThirtyEight


Jul 23 – Dear Google, Links from YouMoz Don’t Violate Your Quality Guidelines by randfish

Posted by randfish
Recently, Moz contributor Scott Wyden, a photographer in New Jersey, receiv…

via SEOmoz Daily SEO Blog


Jul 23 – API-liate Ecommerce by Linda Bustos

Much of the cool, new ways ecommerce sites mesh with social and mobile is thanks to APIs, or Applica…

via Get Elastic Ecommerce Blog


Jul 23 – How do five popular newspapers do mobile app subscriptions? by Ben Davis

How do The Sun, The Times, The Guardian, The New York Times and The Wall Street Journal manage subsc…

via Posts from the Econsultancy blog


Jul 23 – iBeacon trials: 13 brands trying to find a use case by David Moth

You’ve probably heard about iBeacons. It’s the cool new technology that Apple put in the latest iOS …

via Posts from the Econsultancy blog


Jul 23 – Twitter’s New User Pitch Means a New Advertising Pitch, Too by Peter Kafka

Twitter is trying to tell Wall Street that it doesn’t have a user problem. Just a counting problem….

via Re/code


Jul 23 – MozCon 2014 Recap: What I Learned by Sean McQuaide

A holistic industry transformation was the tone at MozCon this year and Erica McGillivray and team …

via Increasing your Website’s Conversion Rate


Jul 23 – A world without statistics by Andrew

A reporter asked me for a quote regarding the importance of statistics. But, after thinking about i…

via Statistical Modeling, Causal Inference, and Social Science


Jul 23 – Hello. I’m a Radical Analytics Pragmatist

I was reading a post last week by one of the Big Names in web analytics…and it royally pissed …

via All Web Analytics Demystified Blogs

This post led to this…


Jul 23 – Google Analytics Now Offers Display Targeting Reports by Jacob Brown

Google recently launched a new Display Targeting report in Google Analytics.

Read more at PPCHe…

via The Adventures of PPC Hero


Jul 23 – Italy Gives Google 18 Months to Change Data Protocols by Christie Barakat

Regulators in Italy say Google failed to adequately disclose its treatment of data to Italian citiz…

via The Social Times


Jul 23 – Talking Personalization: Post 1 (by Gary Angel) by SEMangel

Talking Personalization
[Jim Hazen and I have been talking about Personalization and the appropriate…

via SemAngel


Jul 24 – Spotlight on data privacy: three steps to building consumer trust by Glen Hartman

Consumer concern about data privacy has shifted over the past decade.
More than ten years ago, cons…

via Posts from the Econsultancy blog


Jul 24 – Time travel, flapjacks & smoking – a psychological take on social media: part one by Andrew Nicholson

Reality is an illusion. Ask 100 people to describe the same event, and each one will tell you a slig…

via Posts from the Econsultancy blog


Jul 24 – Billion-Dollar Billy Beane by Benjamin Morris

The film version of “Moneyball” depicts many establishment baseball types as ignorant of where wins …

via FiveThirtyEight


Jul 24 – Coherent population forecasting using R by Rob J Hyndman

(This article was first published on Hyndsight » R, and kindly contributed to R-bloggers) …

via R-bloggers


Jul 24 – Left-handed catchers by Martin Monkman

(This article was first published on Bayes Ball, and kindly contributed to R-bloggers)

B…

via R-bloggers


Jul 24 – The Evolution of SEO by Eric Schiffer

Raywoo/Shutterstock
Digital marketing technology is rather like high fashion — trends that we…

via Re/code


Jul 24 – Major League Baseball Cries Foul on Net Neutrality Proposal by Amy Schatz

MLB.com
Count Major League Baseball among those who aren’t wildly excited by FCC Chairman Tom Wheel…

via Re/code


Jul 24 – Introducing Dynamic Sitelinks by Rob Newton

Whether it’s shopping for a TV or planning a trip, people perform multiple searches when completing …

via Inside AdWords


This is a weekly post that is automatically generated by the RSS feed of stories that I have flagged to share using my implementation of Tiny Tiny RSS (which is an excellent RSS Reader). I will sometimes annotate these posts with commentary related to the stories posted.

To subscribe to my shared feed directly, use http://tmllr.us/shared.

I generally share important news or interesting articles via Twitter (@tmllr) and other social networks, but this is a wider array of content that I find share-worthy.

Jul 18 14

Shared Stories from This Week: Jul 18, 2014

by tmllr

Jul 12 – July 12, 2014
GaymerX rolls on!
via Saturday Morning Breakfast Cereal (updated daily)


Jul 14 – SEOs Know Things about UX: Here’s How to Prove it by Kristina Kledzik
Posted by Kristina Kledzik
As a human being currently using the internet, you have opinions about o…
via SEOmoz Daily SEO Blog


Jul 14 – Lessons from the Eiffel Tower by Seth Godin
It was designed at home, on the kitchen table…
by someone who didn’t get their name on it
Never b…
via Seth’s Blog


Jul 14 – Why CMOs should be looking out for Google penalties by Adam Mason
The recent spate of Google penalties has affected hundreds of brands across the web,  with some not …
via Posts from the Econsultancy blog


Jul 14 – CodeSOD: State of the UNION by Erik Gern
Correct now, optimize later. is one of the most important developer mantras and Scott K. followed it…
via The Daily WTF


Jul 14 – Six experiments in decision theory that show how marketers can use psychology by Ben Davis
Digital psychology is increasingly influencing digital strategy.
I’m not going to define what digita…
via Posts from the Econsultancy blog


Jul 14 – The Second Biggest Search Engine on Earth by Jeff Julian
Based on the number of searches, Google is the greatest search engine on Earth by a long shot. But i…
via Omniture: Industry Insights


Jul 14 – Why you should be monitoring your brand on Twitter by Christopher Ratcliff
66.7% of all public brand mentions on social media happen on Twitter.
Twitter is the key battlegroun…
via Posts from the Econsultancy blog


Jul 14 – Q&A: Gary Vaynerchuk on Facebook marketing by David Moth
There’s been a great deal of discussion recently around the perceived decline in brands’ ability to …
via Posts from the Econsultancy blog


Jul 14 – 6 SEO Myths The Pros Are A Little Tired Of Debunking by Michael Bartholow
You know what’s been grinding my gears lately? No matter how long I’ve been in the sear…
via Increasing your Website’s Conversion Rate


Jul 14 – More Sophisticated Cybercriminals Bring New Threats to the Internet by Kimberlee Morrison
Security vulnerabilities like Heartbleed get a lot of press because they have such a serious impact…
via The Social Times


Jul 14 – How to Deliver Better Recommendations: Forecast the Impact!
One of the most valuable ways to be sure your recommendations are heard is to forecast the impact of…
via All Web Analytics Demystified Blogs


Jul 15 – Net-Neutrality Plan Faces Backlash
The FCC has received more than 677,000 comments on proposed net-neutrality rules, suggesting Chairma…
via WSJ.com: Technology


Jul 15 – But How Do I Create Demand? by Kevin Hillstrom
Assuming you are the only person on the planet who watches live television and pays attention to com…
via Kevin Hillstrom: MineThatData


Jul 15 – Google, Freescale Backing Yet Another Internet-of-Things Standard Effort by Ina Fried
If you thought the only problem with two competing Internet-of-Things standards was that two rivals…
via Re/code


Jul 17 – Promoting modern websites for modern devices in Google search results by Google Webmaster Central
Webmaster level: allA common annoyance for web users is when websites require browser technologies t…
via Google Webmaster Central Blog


Jul 15 – Get Ahead of Google with Insight into Semiotics by Isla_McKetta
Posted by Isla_McKetta
Write it and they will come. That’s the drum we’ve been beating for a long t…
via SEOmoz Daily SEO Blog


Jul 15 – Project management for work that matters by Seth Godin
Resist the ad hoc. Announce that this is a project, and that it matters enough to be treated as one…
via Seth’s Blog


Jul 15 – Digital Dashboards: Strategic & Tactical: Best Practices, Tips, Examples by Avinash Kaushik
I'm excited about the power of a well created dashboard. It is a thing of beauty and a source o…
via Occam’s Razor by Avinash Kaushik


Jul 15 – Just Roll With It by snoofle
DBAs are supposed to bring knowledge of the underpinnings of databases to the table. How to lay out…
via The Daily WTF


Jul 15 – Using Offline and Online data to drive Google Analytics Remarketing by Justin Cutroni
The Google Analytics platform has been changing from a web analytics tool to a user-centric digital …
via Analytics Talk


Jul 15 – Finally, a USB Thumb Drive for the Latest iPhones and iPads by Walt Mossberg
For all of their popularity, Apple’s iPhones and iPads have sometimes been knocked for lackin…
via Re/code


Jul 15 – The Most Effective, Most Used, and Most Budgeted for Digital Marketing Tactics
US-based digital marketers consider email the most effective digital tactic for building awareness, …
via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


Jul 15 – Why June’s ‘Disappointing’ Retail Sales Were Good News for the Economy by Ben Casselman
Read the financial press Tuesday morning, and odds are you’ll see a headline saying that retail sale…
via FiveThirtyEight


Jul 15 – How can Pharma organize for agility in the digital age? by David St. John Tradewell
As pharma and healthcare companies embrace the need for digital transformation, how can they ensure …
via Posts from the Econsultancy blog


Jul 15 – Would You Quit Facebook for 99 Days? by Christie Barakat
Dutch communications agency Just is encouraging Facebook users to give up the network for 99 days.
T…
via The Social Times


Jul 15 – 7 Major Pitfalls for Mobile Websites and How to Avoid Them for Yours by Jon Correll
Today, companies must optimize for three different user experiences: laptop/desktop, tablet, and mob…
via Landing Page Optimization, Conversion Rate Optimization and Techniques


Jul 15 – The Best iPhone, Android and Web Apps to Fix Your Broken Digital Calendar
The calendars we use for different parts of our lives might as well be oil and vinegar—at first, see…
via WSJ.com: Technology


Jul 15 – Net Neutrality Comments Flood FCC, Crashing Site as Deadline Extended by Amy Schatz
Dan_nurgitz/Shutterstock
The Federal Communications Commission extended a deadline for comments on …
via Re/code


Jul 15 – Twitter Bots Keep Watch on Government Edits to Wikipedia by Kimberlee Morrison
Wikipedia has always maintained its commitment to remaining open source, free of advertising, and r…
via The Social Times


Jul 15 – 24 Hours With Bitly [Infographic] by Kimberlee Morrison
Bitly was one of the earliest URL encoders on the market and established a firm foundation as the of…
via The Social Times


Jul 15 – Yahoo’s Ad Prices: ‘Something Went Dramatically Wrong’
Yahoo’s ad business is shrinking because the price its advertisers are willing to pay is falling.
via WSJ.com: Technology


Jul 16 – Pay Attention To Birchbox by Kevin Hillstrom
Click here, retail fans.Look past the glitz of artificial intelligence and machine learning, which s…
via Kevin Hillstrom: MineThatData


Jul 16 – Making the Iterative Optimization Methodology Work for Your Business by Kevin Lindsay
Last week I took a look at part one of Michael Krypel’s new book Refining Design for Business, descr…
via Omniture: Industry Insights


Jul 16 – Six useful email alternatives to ease your workload by David Moth
At Econsultancy’s recent Digital Transformation event it was suggested that businesses could improve…
via Posts from the Econsultancy blog


Jul 16 – Social media in an election year: what can we expect? by Ben Davis
Politics and social media go hand in hand. There’s even a social network with political consciousnes…
via Posts from the Econsultancy blog


Jul 16 – What is agile marketing and why do you need it? by Christopher Ratcliff
“What the heck was that? It happened so fast!
A pop-culture news-story just blew up on Twitter whils…
via Posts from the Econsultancy blog


Jul 16 – Twitter’s analytics update: good news for data-driven marketers by Matt Owen
Those of you with a Twitter advertising account may have noticed that their analytics system has had…
via Posts from the Econsultancy blog


Jul 16 – Continued Growth for Google’s Search Ad Business in Q2 by Sid Shah
As the burgeoning world of search advertising expands with new ad formats, our data indicates that G…
via Omniture: Industry Insights


Jul 16 – Interactive Maps: Comparing Road, Bridge Quality by State by Matt Stiles
How bad are your state’s roads and bridges? See these maps:
via WSJ.com: The Numbers Guy


Jul 16 – “Unfriending My Ex” Author Kim Stolz Is a Parent’s Worst Nightmare by Nellie Bowles
Scribner
Kim Stolz — writer, reality show contestant, restaurateur and banker — was a s…
via Re/code


Jul 16 – 5 Main Themes Emerge in Net Neutrality Debate by Gautham Nagesh
Net neutrality inspires a lot of passion, and it’s an issue with more than two sides. Judging from a…
via Washington Wire


Jul 16 – Introducing a new multi-screen resource in the AdSense Help Center by John A.Smith
Did you know that sites optimized for multiple screen sizes can have an average 15% higher RPM and t…
via Inside AdSense


Jul 16 – Google Navigates a Euro-Regulation Minefield by Kimberlee Morrison
Google is the most dominant search engine in the market. Given this lofty position, the company fre…
via The Social Times


Jul 16 – Demystifying Data Visualization for Marketers by Annie Cushing
Posted by Annie Cushing

I presented on wrangling and demystifying the data visualization pro…
via SEOmoz Daily SEO Blog


Jul 16 – Xbox One Sales More Than Doubled in June by Eric Johnson
Microsoft announced today that, following a $100 price cut, it sold more than twice as many Xbox One…
via Re/code


Jul 16 – Dynamic Data Viz: A Better Way to Plot Rows in Google Analytics by Dorcas Alexander
Have you ever tried to use the “plot rows” feature in Google Analytics and it literally …
via Increasing your Website’s Conversion Rate


Jul 17 – Creative by Kevin Hillstrom
In an omnichannel world, you are supposed to align all channels with beautiful creative, impressive …
via Kevin Hillstrom: MineThatData


Jul 17 – The beginner’s glossary of programmatic advertising by Ben Davis
Programmatic advertising is complicated. There’s no doubt about that.
This complexity explains why t…
via Posts from the Econsultancy blog


Jul 17 – Interactivity as overhead by junkcharts
Making data graphics interactive should improve the user experience. In practice, interactivity too …
via Junk Charts


Jul 17 – Why You Should Do Dynamic Retargeting on Facebook by Anita Avram
You’re an ecommerce advertiser and you’re allocating significant media spend towards driving potenti…
via The Adventures of PPC Hero


Jun 30 – Dear Internet, SCOTUSblog Is Not the Supreme Court by Natalie Andrews
Naming yourself after the organization you cover is supposed to offer clarity, but on Monday, it man…
via Washington Wire


Jul 08 – Fake Document Enters Hiring Case Against Tech Giants
A closely watched antitrust case involving hiring practices of Apple, Google, Intel and Adobe has pr…
via WSJ.com: Technology


Jul 17 – Laura Kalbag on Freelance Design: I Don’t Like It by Laura Kalbag
“I don’t like it”—The most dreaded of all design feedback from your client/boss/co-worker. This isn’…
via A List Apart


Jul 17 – How to Double Your Marketing Team…WITHOUT New Hires by Josh Hill
Author: Josh HillWhen I first heard about marketing automation, I was running demand generation prog…
via Marketo Marketing Blog


Jul 17 – Optimize Internal Site Search Conversion Rates with Google Tag Manager by Jonathon Stephens
Often overlooked, Internal Site Search’s importance shouldn’t be underestimated. Recent…
via Increasing your Website’s Conversion Rate


Jul 17 – Nerd Breakfast With Bloomberg: Media Mogul Opens R&D Lab in SF by Kara Swisher
Daniel Schwartzbaum
Former New York Mayor Michael Bloomberg was a little late to his own geek party…
via Re/code


Jul 18 – Under Pressure, Twitter Tries to Resize
Twitter is expected to unveil as many as four new metrics later this month that it hopes will illust…
via WSJ.com: Technology


Jul 17 – Torment Claims Make GitHub Grow Up
A recent incident shows how rising startups like GitHub are often ill-equipped to deal with complex,…
via WSJ.com: Technology


Jul 18 – The “Just In Time” Theory of User Behavior by Jeff Atwood
I’ve long believed that the design of your software has a profound impact on how users behave within…
via Coding Horror


This is a weekly post that is automatically generated by the RSS feed of stories that I have flagged to share using my implementation of Tiny Tiny RSS (which is an excellent RSS Reader). I will sometimes annotate these posts with commentary related to the stories posted.

To subscribe to my shared feed directly, use http://tmllr.us/shared.

I generally share important news or interesting articles via Twitter (@tmllr) and other social networks, but this is a wider array of content that I find share-worthy.

Jul 11 14

Shared Stories from This Week: Jul 11, 2014

by tmllr

Jul 01 – What Clients Expect of Marketing and Ad Agencies
Businesses expect the marketing and advertising agencies they employ to do a bit of everything, from…
via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


Jul 01 – RKG in Forbes – Big Data Helps Experts Precisely Target Digital Shoppers by Jake
March 24, 2014 – Virginia Business Leaders – RKG – When leading e-retailers look f…
via AudetteMedia


Jul 02 – Stop Worrying About the New Google Maps; These URL Parameters Are Gold by David-Mihm
Posted by David-Mihm
I suspect I’m not alone in saying: I’ve never been a fan of the New Google Map…
via SEOmoz Daily SEO Blog


Jul 02 – 6 Ways to Make Social Measurable by Frank Passantino
Author: Frank PassantinoToday, social media is responsible for driving a huge amount of marketing in…
via Marketo Marketing Blog


Jul 02 – Google Universal Search Trends
Google now delivers Universal Search results–those that include a blend of links, videos, images, n…
via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


Jul 03 – SEO for content marketing: seven success factors by Graham Charlton
Content marketing and SEO go hand in hand. Great content attracts links and can rank highly, while g…
via Posts from the Econsultancy blog


Jul 04 – Create customer experiences that people remember by Tim Wade
The nirvana for marketers is creating customer experiences that people remember and want to share, b…
via Posts from the Econsultancy blog


Jul 04 – The ultimate guide to personalisation: content retargeting and engagement by Ian McCaig
Online shopping has become so much more than simply a place to buy.
Ecommerce websites are now plac…
via Posts from the Econsultancy blog


Jul 05 – Hurricane Arthur
Hurricane Arthur made its way up the East Coast of the United States over the last few days, causing…
via The Big Picture


Jul 06 – Discretion by Seth Godin
How much do you trust your people to do the right thing?
Consider giving every person on your team a…
via Seth’s Blog


Jun 08 – Microsoft’s CEO wants ET method of presentation, not PowerPoint
via Ask E.T


Jul 07 – The global ramifications of Singapore’s new Data Protection Act by Jeff Rajeck
Singapore’s Personal Data Protection Act went into effect on July 2. It’s a local law, but it matter…
via Posts from the Econsultancy blog


Jul 07 – Where Are We Headed? by Kevin Hillstrom
Discovery / Trending: There’s too much information, and you certainly don’t want to be wrong. You wa…
via Kevin Hillstrom: MineThatData


Jul 07 – Percentages vs. Dollars: a Battle for Investors’ Attention
Some experts say percentages don’t seem like real money to people, especially when it comes to risks…
via WSJ.com: Markets


Jul 07 – Landing Page Optimization: What a 29% drop in conversion can teach you about friction by John Tackett
Tweet
I’m sure most of you have heard the old proverb: The road to ruin is paved with the best of in…
via MarketingExperiments Blog: Research-driven optimization, testing, and marketing ideas


Jul 07 – Geolocated Personalization Test Lifts Conversion 12% by Linda Bustos
A couple weeks ago, we covered an advanced personalization tactic: geolocated weather targeting.Burt…
via Get Elastic Ecommerce Blog


Jul 07 – Top ten tweaks to increase ecommerce conversions by James Critchley
Many online retailers remain obsessed with growing overall site traffic, at the expense of increasin…
via Posts from the Econsultancy blog


Jul 07 – The Future of Search: Part 1 by Jeff Julian
I’ve written a lot about the dynamic nature of search—how search is always changing and adjusting to…
via Omniture: Industry Insights


Jul 07 – Social Media Newsfeed: Facebook Removes Image | YouTube Shaming Internet Providers by Tim Sohn
 Click here to receive the Morning Social Media Newsfeed via email.
Facebook Removes Mom’…
via The Social Times


Jul 07 – Why Classic Rock Isn’t What It Used To Be by Walt Hickey
Led Zeppelin is classic rock. So are Mötley Crüe and Ozzy Osbourne. But what about U2 or Nirvana? As…
via FiveThirtyEight


Jul 07 – 10 Ways to Challenge Amazon’s Dominance
Here are five things Amazon is doing that your business isn’t–and five things you can do that Amazo…
via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


Jul 07 – John Lewis Posts Mugshot to Mark 1961 Civil-Rights Arrest by Natalie Andrews
Rep. John Lewis marked his arrest with the Freedom Riders on Twitter, posting his mug shot. The lawm…
via Washington Wire


Jul 07 – Loop Counts Could Become Vine’s Most Important Metric by Kimberlee Morrison
Last week Vine introduced loop counts, and the general consensus has been that counting “loops” …
via The Social Times


Jul 07 – Duplicate Transactions in Google Analytics – The Check and the Fix by Jon Meck
By far the most common issue I’ve come across with ecommerce sites; duplicate transactions ca…
via Increasing your Website’s Conversion Rate


Jul 08 – Tactics That Only “Work” For Big Businesses by Kevin Hillstrom
If you’re an analyst, there are two environments where your improvements really make a big differenc…
via Kevin Hillstrom: MineThatData


Jul 07 – Dividend-Paying Stocks Fit the Bill
Large investors are snapping up stocks that provide steady income, an endorsement of companies’ heal…
via WSJ.com: Markets


Jul 08 – Yo vs. Potato Salad by James Temple
Shutterstock / Teguh Mujiono
Remember the days of Yo? Way back in mid-June, a single-word messaging…
via Re/code


Jul 08 – Why Mobile Matters – Now by Dr-Pete
Posted by Dr-Pete
Having built an online business during the dot-com boom and bust, I’ve always bee…
via SEOmoz Daily SEO Blog


Jul 08 – PlayBuzz Takes a Page (View) Out of BuzzFeed’s Playbook
A tiny start-up founded by the son a former Israeli prime minister is climbing the online news pop c…
via WSJ.com: Technology


Jul 08 – Beware the zeitgeister by Seth Godin
He only cares about what’s trending now. The only worthy examples are this week’s examples, or even …
via Seth’s Blog


Jul 08 – Nine examples of search tools from automotive websites by Graham Charlton
I’ve looked at search and comparison tools on automotive sites in the past, and there was a lot of r…
via Posts from the Econsultancy blog


Jul 08 – Google Analytics Demographic Segmentation Techniques by Jeff Sauer
We all know that Google Analytics is a powerful tool for diagnosing and understanding what happened …
via Online Behavior


Jul 08 – Music Vault Unlocks Concert Videos on YouTube by Dawn Chmielewski
Music Vault, a repository of live music performances, is unlocking 12,000 concert videos on YouTube …
via Re/code


Jul 08 – How to Create an Online Experience for Humans by Meegan Kauffman
The rules of Internet marketing change all the time, and it’s increasingly difficult to keep up. Wha…
via Conversation Marketing: Internet Marketing with a Twist of Lemon


Jul 08 – googleVis 0.5.3 released by Markus Gesmann
(This article was first published on mages’ blog, and kindly contributed to R-bloggers)


via R-bloggers


Jul 08 – 7 Tips For Delivering Better Analytics Recommendations
As an analyst, your value is not just in the data you deliver, but in the insight and recommendation…
via All Web Analytics Demystified Blogs


Jul 09 – Getting The Message Right by Kevin Hillstrom
Maybe the most frustrating project I ever worked on happened at Nordstrom in the mid-2000s.I had two…
via Kevin Hillstrom: MineThatData


Jul 09 – With Google Offer, Cloud Storage Gets Closer to Free
Google Wednesday fired another shot in the price wars for cloud-computing services, offering busines…
via WSJ.com: Technology


Jul 09 – Social Media Newsfeed: World Cup Twitter Record | Social Media and Police by Tim Sohn
 Click here to receive the Morning Social Media Newsfeed via email.
Brazil’s Crushing Defeat to…
via The Social Times


Jul 09 – A small step for interactivity by junkcharts
Alberto links to a nice Propublica chart on average annual spend per dialysis patient on ambulances …
via Junk Charts


Jul 09 – Is it time for ‘marketing-as-a-service’ (MaaS)? by Ashley Friedlein
Snow Fall is a beautiful, interactive and immersive multimedia experience about the avalanche at Tun…
via Posts from the Econsultancy blog


Jul 09 – Author Photos are Gone: Does Google Authorship Still Have Value? by MarkTraphagen
Posted by MarkTraphagen
On June 25, 2014, Google’s John Mueller made a
shocking announcement: Goog…
via SEOmoz Daily SEO Blog


Jul 09 – Senator Asks FTC to Look Into Facebook Mood Experiment by Amy Schatz
Shutterstock
Democratic Sen. Mark Warner of Virginia asked the Federal Trade Commission on Wednesda…
via Re/code


Jul 10 – Thirty years of projects by Seth Godin
I realized the other day that most people grow up thinking in terms of professional affiliations. “I…
via Seth’s Blog


Jul 10 – Seven paid search features local marketers should be using by Matthew Whitehead
Local marketers now have many tools to consider when using paid search that go beyond simply bidding…
via Posts from the Econsultancy blog


Jul 10 – Open-source tools for running online field experiments by Andrew
Dean Eckles points me to this cool new tool for experimentation:
I [Eckles] just wanted to share tha…
via Statistical Modeling, Causal Inference, and Social Science


Jul 10 – Nine user experience lessons travel sites can learn from Airbnb by Graham Charlton
Airbnb’s business model has certainly been ‘disruptive’ for the hotel industry, but a major factor i…
via Posts from the Econsultancy blog


Jul 10 – Does mobile mean the end of photography in web design? by Ben Davis
More and more we are used to slick mobile websites that focus on functionality above all else, and q…
via Posts from the Econsultancy blog


Jul 10 – 7-Minute User Experience (UX) Audit for Landing Pages by Andrew Garberson
A fellow LunaMetrician recently returned from SMX Advanced and said it was refreshing to hear how mu…
via Increasing your Website’s Conversion Rate


Jul 10 – Syrian Refugee Density in Lebanon by jlebeau
(This article was first published on More or Less Numbers, and kindly contributed to R-bloggers…
via R-bloggers


Jul 11 – Retail by Kevin Hillstrom
Read this, my friends (click here).I could be 100% wrong, folks, but I believe we are killing retail…
via Kevin Hillstrom: MineThatData


Jul 11 – Timeghost
via xkcd.com


Jul 11 – Does SEO Boil Down to Site Crawlability and Content Quality? – Whiteboard Friday by randfish
Posted by randfishWe all know that keywords and links alone no longer cut it as a holistic SEO …
via SEOmoz Daily SEO Blog


Jul 11 – Error’d: This Squirrel Error is Driving Me Nuts! by Mark Bowytz
“When War Thunder crashed, apparently there were some squirrels hiding in there and they gnawed on s…
via The Daily WTF


Jul 11 – What’s the Big Idea? by Josh Hannah
kurtcan/Shutterstock
“To me, ideas are worth nothing unless executed. They are just a multipl…
via Re/code


Jul 11 – Social Media Newsfeed: LinkedIn Connected App | Sobrr Social Network by Tim Sohn
 Click here to receive the Morning Social Media Newsfeed via email.
LinkedIn Replaces its Conta…
via The Social Times


Jul 11 – 10 revealing digital marketing stats we’ve seen this week by Ben Davis
Lots of mobile ecommerce stats this week, with a smattering of brand storytelling and advertising.
T…
via Posts from the Econsultancy blog


Jul 11 – Oldest Americans Are the Most Confident in Their Looks by Asma Ghribi
The oldest Americans feel the most comfortable with their physical appearance, according to a Gallup…
via WSJ.com: The Numbers Guy


Jul 11 – Beyond Passwords, Behavior Looms
A new industry of ‘post-password’ behavior-analytics products is making inroads to lock out cybercri…
via WSJ.com: Technology


Jul 11 – The Top Smartphone Apps, Manufacturers, and Platforms
Smartphone penetration climbed to 70% of all adults in the United States (169 million people) in May…
via Marketing Profs – Marketing Concepts, Strategies, Articles, Research, Events and Commentaries


This is a weekly post that is automatically generated by the RSS feed of stories that I have flagged to share using my implementation of Tiny Tiny RSS (which is an excellent RSS Reader). I will sometimes annotate these posts with commentary related to the stories posted.

To subscribe to my shared feed directly, use http://tmllr.us/shared.

I generally share important news or interesting articles via Twitter (@tmllr) and other social networks, but this is a wider array of content that I find share-worthy.

Oct 18 11

Don’t Freak Out about Google’s New SSL Search

by tmllr

Google Analytics Logo

A little over a year ago, I wrote a blog post about why you shouldn’t freak out about people opt-ing out of being tracked in Google Analytics.  Yesterday, Google announced that they are using SSL to encrypt search queries and responses for people that are using Google.com and are logged into their Google accounts.  The result of this change is that referrals from Google organic search in Google Analytics and other clickstream measurement tools will not be able to determine the keywords used in the search that brought a user to the studied site.  The reporting of the fact that the visit was referred by Google organic search will be maintained.

Although this has widespread implications for both Search Engine Optimization and site optimization activities, I’d encourage you to not freak out about this change for a lot of same reasons that I outlined last year.

Why I’m Not Freaking Out – And You Shouldn’t Either

I have no idea what to expect with this change – there is no way for me to predict how many of my sites’ visitors are going to be coming from logged-in Google account holders.  I do know the current impact of Google organic search to my portfolio of sites – it is the single biggest driver of organic (as opposed to paid) search traffic, providing, on average, 75% of visits. According to both Comscore and Hitwise, Google had a 66% market share of U.S. searches in September 2011.

This traffic is important to the overall goals of all of our sites.  We spend a lot of time and effort on building and maintaining our sites’ search traffic and this change has serious implications for both the quality and quantity of data that we use to drive these efforts.  Despite this, I’m still not freaking out.

Using the same thought exercise as my previous post, imagine if 50% of Google’s organic traffic had its keywords obfuscated because those visitors were logged into their Google accounts when they performed the search that ultimately brought them to your site:

It (Still) Isn’t about the Individual Visit (or in This Case, Search)Search data, like all other clickstream data, is useful in aggregate.  By looking at the keywords searched and grouping them by theme, we can calculate the value of certain types of keywords vs. others (for example, brand terms vs. product terms).  Losing 50% of this data will affect the number of Long Tail keywords that get reported and potentially affect the reporting of narrow segments of traffic that have few reported keywords, but not radically affect our conclusions on the aggregate “search intent” of our visitors.

Aggregate Data is More about Precision than Accuracy - With this thought exercise, we are again losing a bit of Accuracy without losing Precision.  There is no reason to suspect that individuals search and post-search behavior is going to change because they happen to be logged into their Google account.  The assumption that these individuals as a group do not significantly behave differently than all Google organic visitors is one that is easily tested within Google Analytics by comparing the group with reported keywords with the one whose search terms are obfuscated.  Because of this (testable) assumption, we can draw conclusions that the “search intent” of the missing 50% in aggregate is going to be similar to the fully-reported 50%.

Perhaps most importantly, from a privacy standpoint, this is the right thing to do.  I spend a lot of time connected to Wi-Fi in other offices, coffee shops, hotels, at conferences, and other places where a nefarious system administrator could easily snoop on my search queries and other non-encrypted web usage data.  Google’s new two-factor authentication makes me secure accessing Google products (including Google Analytics!) while connected to potentially sketchy Wi-Fi.  Now I have the same level of comfort while using Google search in potentially unfriendly places.

The data will show the impact of the change in the next few days as it is rolled out to everyone.  Regardless of the scope of the data that has been affected, I hope this post had made a strong argument for not freaking out about it.

Jan 26 11

Inspirational Video: Creating a Data Driven Culture by Avinash Kaushik

by tmllr

I was inspired to write this post this evening after looking at my LinkedIn social graph and seeing the recent career arcs of some of my former colleagues (more on this later).

This post is to thank and highlight a video from a person that has had a tremendous amount of influence to my career: Avinash Kaushik.  This video was recorded back in 2007, and talks about a topic that is near and dear to my heart:

Culture.

In the wrong context or to the wrong people, talking about “culture” causes people’s eyes to glaze over.  Based on my experience, I am no longer one of those people. My tale of developing a data-driven culture in a large corporation follows:

In 2006, I accepted a position as a Senior Manager of Web Analytics for a large business services firm.  As the product manager of the organization’s enterprise-wide web analytics software and data collection framework, I had my hands full developing a data capture and reporting framework as part of a complete web reboot by the company.  Although implementing an enterprise click stream tool as well as a framework for web data integration into the company’s data warehouse was a technically complex task, it was fairly straightforward once the requirements were determined.

What was not straightforward, however, was how to develop a data-driven culture in regards to how the company used its web data.

The organization had nine different, quasi-independent business units with about thirty-five different web sites.  Nobody from the business units was focused on web analytics, however, each business unit had a web team that was focused on managing the content on the sites.  My goal was to transform those positions from content managers into data driven product managers of their web sites.

So how did I attempt to accomplish this?  I empowered the web managers with their own data. I trained the web teams on both our clickstream and data warehouse tools and gave them the ability to independently develop actionable insight about their clients’ web usage.

Less than a year later, these managers could look at both individual and aggregate customer data and determine how specific web-based activity affected their business units’ bottom line. They had total visibility into all of the company’s marketing data, allowing them to explore the data and develop objective arguments for action.

Looking at my social graph on LinkedIn, I see that, three years later, some have moved into different roles either within or outside of the firm, but at least four of those former web managers have moved on to be web analysts, two with a top-tier web analytics consulting firm.

My approach here was directly influenced by Avinash’s first book, blog, and talks that he was giving at the time.  His guidance was, and continues to be, useful and inspirational for the entire online marketing community.

Creating a Data Driven Culture by Avinash Kaushik

Jan 24 11

Cool Tool: QR Codes

by tmllr

This post is in praise of a simple tool: the QR Code.  QR codes are graphics that represent text strings, typically website URL’s.  Using their cameras and QR scanning software, smart phone users can scan QR codes to launch specific website URL’s in their mobile browser.

Although the “QR” code is one type of two dimensional code (other common ones: Aztec Code,  MaxiCode)  the term “QR Code” has been extended to encompass any two dimensional code that is readable by scanner software on mobile devices.  The QR Code standard is a set standard and license-free, so the platforms for both consumption and generation are interchangeable.

So what’s to like about QR codes?qrcode

QR codes are easy to consume. All the major mobile platforms either support the QR Code standard natively or have free QR scanning applications readily available.  To consume a QR code, a smart phone user needs to simply “take a picture” of it with their phone.

QR codes are easy to create. Since the QR Code is based on a set standard, there are a number of web services that will produce them based on URL input. I’ve been using Kaywa’s generator, but URL shorteners, such as goo.gl and bit.ly now also generate them along with their shortened URL’s.

QR codes are easy to track. Much like a shortened URL or a vanity URL, there is opportunity to tag incoming URL’s to allow tracking of traffic generated by QR code scans. This is a key practice when attempting to determine use of and return from QR code usage.

Where are they useful? With the explosion in advanced smartphone usage, there is increasing opportunity to embed these codes in a wide variety of applications.  I have personally seen QR codes used in billboards, magazine advertisements, bus shelters, bus wraps, business cards, conference badges, and, oddly enough, men’s rooms.

So why aren’t they everywhere? The sad truth is that they aren’t everywhere.  They are still so rare to see “in the wild” that I am still surprised to see them, even in situations with obvious utility.

What are some other uses? I’d like to see QR codes everywhere where a web resource could be useful.  I’d like one on my appliances or in my car that can point me to product information.  I’d like one at Starbucks and Chipotle that would allow me to order and pay while standing in line.  I’d like to see them on TV that would allow me to connect with shows and their advertisers in addition to vanity URL’s.  The potential applications are legion.

Dec 10 10

Poll: How Do You Inform People of Testing Activities on Your Sites?

by tmllr

Testing – it is a critical activity for optimizing any site and an important part of an overall data-driven web site strategy. When it comes to disclosure of web analytics tools within the context of a site’s privacy policy or terms of service, I lump testing tools together with click stream, voice-of-customer, and audience paneling tools. My sites’ privacy policies typically describe them collectively as third-party tools that collect information about the user.

Is there a privacy concern here? No, because the scope of data that is collected is clearly defined – the data collected by testing tools is far less detailed than that collected by click stream tools or transactional data.

Is there a user experience/user sentiment concern here? Possibly.  Although user experience varies widely by platform and site customization features, by the very nature of a test, certain visitors are getting a sub-optimal experience.  Should informing site visitors of the use of these tools, or even the fact that they are participating as a panelist in an experiment, be part of a policy of transparency and potentially cut off any negative sentiments created by the testing?

This all leads to my question:

Do you explicitly inform your sites’ visitors of any A/B or multivariate tests/tools that are deployed on your sites?
No.
Yes, we cover all testing generically in our TOS/Privacy Policy.
Yes, we mention specific tools and/or tests in our TOS/Privacy Policy.
Yes, pages that are part of test treatments inform visitors to the existence and nature of the test.
Web Polls

I’d love to hear about any specific experiences related to testing and disclosure in the comments!

Jun 8 10

Don’t Freak Out about Google Analytics Opt-Outs

by tmllr

Google Analytics LogoOn May 25th, Google announced the availability of a browser add-on for Internet Explorer, Chrome, and Firefox that prevents a user’s browser from reporting site usage data to Google Analytics.  This plug-in has the effect of preventing visit and visitor information from being reported to any site using Google Analytics to collect clickstream data to their site.

Although I have years’ of experience implementing and using other web analytics tools, today I use Google Analytics on nearly every site that I manage.  It has become the de-facto standard web analytics tool for content and small e-commerce sites for a reason: it is easy to implement, has enterprise-grade features and a large user base, and it is FREE.  Here are the reasons why I’m not freaking out about a potential loss of visitor data from this tool:

It Isn’t about the Individual Visit

The power of clickstream analytics tools, like Google Analytics, comes from deriving actionable insights by exploring aggregate site traffic across discrete time periods and specific traffic segments.  You simply aren’t going to get very much actionable insight delivered by looking at one person’s visit to your site or even by tracking one person’s visits over a longer time period. In fact, Google Analytics’ terms of service explicitly forbids implementing it in a way that can uniquely identify individual visitors.

Aggregate Data is More about Precision than Accuracy

Here is a thought exercise: what if Google Analytics or some other clickstream analytics tool is delivering actionable insights that boost your site’s conversion rate but is only collecting data from about 95-99% of your site’s visitors?  That extra 1-5% isn’t a big deal as you can safely assume that the missing 1-5% is acting like the other 95-99% of your visitors.

Due to Javascript not loading, the mechanics of the Javascript not triggering the call back to Google fast enough, or visitors’ current use of ad-blocking and privacy tools, I generally assume that I am CURRENTLY missing about 1-5% of my sites’ pageviews.  Moreover, if you have a site with a large amount of traffic (millions of pageviews per month), Google Analytics suggests that you estimate traffic data based on sampling your site’s traffic to speed up the processing of your reports.

Back to the thought exercise: I expect adoption of this plug-in to be somewhere in the neighborhood of 1-5% of all users.  Is your traffic data fatally flawed if you are missing 2-10% of your pageviews? What about 20%?

Unless the people who install the plug-in are going to behave differently (as a group) than those that do not, Google Analytics will become somewhat less accurate with no loss in precision.  In the context of most sites’ objectives, there is not going to be a reason to question the validity of the conclusions that are drawn from Google Analytics unless there is widespread adoption of the plug-in.  This is because actionable site optimization metrics are based on rates (conversion rate, funnel exit rate), rather than on absolute numbers.

Clickstream is Only Part of the Puzzle

There is an ever-increasing amount of information that is being generated by people interacting with your brand online.  On your site, there is the potential to collect transactional data, direct voice-of-customer data, site testing data, contact us form data, etc., that is typically integrated with, but discrete from, Google Analytics.  Off site, there are interactions with your brand on social media, email marketing activities, and any offline interactions that may also be generating data.  It isn’t that your clickstream data isn’t important – it is just that there are other sources of data that may prompt action on the part of the analyst.

Allowing the Opt-out Is the Right Thing to Do

As site owners, we should never lose sight of our objectives.  There is a reason why our sites exist (sell something, provide information, display advertising) that is fundamentally more important than how we measure and improve our sites’ ability to achieve those goals.  Perhaps unfairly, some peoples’ concerns over privacy will cause them to block a tool that is likely being used to understand and improve their experiences, but we should respect their wishes and accept this as a new browsing paradigm in an environment with many other evolving browsing paradigms.

There Are Alternatives to Google Analytics

Of course, there are other web analytics packages out there if Google Analytics is no longer getting the job done.  It is pretty standard for “enterprise-level” web analytics solutions to include a clickstream tool, a CRM tool, a data warehousing tool, a testing and optimization tool, a social media monitoring and engagement tool, etc., along with their “enterprise level” cost and implementation difficulty.  There are other free tools out there with the features that you would expect with a free tool.  Google also sells Urchin, which doesn’t rely on Javascript to collect data, but instead uses server data logs as its primary data source.

In summary, I don’t think that there will be widespread adoption of the Google Analytics opt-out.  Even if there is, it won’t totally strip away the value of the tool and there are other clickstream analytics tools out there (as well as other sources of web analytics data).

Feb 17 10

Great Trick: Extracting Domains from Email Addresses in Excel and SQL

by tmllr

By using functions in Excel and SQL that return the text from specific locations within a string combined with ones that can isolate the location of the “@” character in every email address, you can easily extract domain names from lists of email addresses.

EXCEL:

The base function for this is RIGHT.  RIGHT gets passed two arguments, text, which is the text being parsed, and num_chars, which is the number of characters returned by the function.  RIGHT takes the form in Excel of RIGHT(text,[num_chars]).

The text argument is obvious; it is the text of the email address to be parsed.

The num_chars argument is determined using a combination of two other functions, LEN and FIND.  We use LEN to determine the length of the overall email address and subtract the position of the @ operator, determined using FIND.  The resulting differencewill return the length of the domain portion of the email address.

LEN(text) returns the number of characters in the string.

FIND(find_text,within_text,start_num) returns the postion of the find_text within the within_text.  start_num, which we won’t use here, is a way to start selecting text after a certain number of characters.

To put this all together, let’s put my email address in cell A1, place our derived function into the B1, and derive the result.

=RIGHT(A1,((LEN(A1)-FIND(“@”,A1)))) calculates to:
=RIGHT(A1,(21-4)) to:
=RIGHT(A1,17) to:
=tomsanalytics.com

SQL:

SQL is a little bit trickier, as there isn’t a right-to-left text selection function, instead we are going to use a left-to-right function, SUBSTRING.

SUBSTRING returns a string of text based on definition passed to the function.  SUBSTRING takes three arguments, value_expression, which is the text being parsed, start_expression, which is the starting character of the returned string, and length_expression, which is the number of characters returned, starting with the start_expression.  This function in SQL looks like this: SUBSTRING(value_expression,start_expression,length_expression).

In this case our email address is the value_expression.  The character following the “@” symbol is the start_expression, with the length of the remaining string being the length_expression.

To determine start_expression, we deploy another SQL function, CHARINDEX, which works exactly like FIND in Excel.  Using SQL’s version of LEN and the same math, we can determine length_expression.

Putting it all together, let’s assume a table named email_addresses with a column named email:

SELECT SUBSTRING(email, CHARINDEX(‘@’, email) + 1, LEN(email) – CHARINDEX(‘@’, email) + 1) AS domain_name
FROM email_addresses
WHERE email like ‘%@%’

The WHERE clause is in there to prevent malformed email addresses from crashing the CHARINDEX function.

The math works the same way as the Excel, except that you have to remember that we are working from the left, so the need arises to add one to the character counter in the CHARINDEX function.

Simple and powerful.  I hope this is useful to someone – the inspiration for this post came from this post at Chandoo.org.  Pointy Haird Dilbert is easily my favorite as well as one of the most useful and entertaining Excel blogs out there.

Jan 15 10

Cool Tool – Tom’s Planner

by tmllr

Toms Planner Export

Export from Tom's Planner

Tom’s Planner is a web-based collaborative project management tool. Despite the name, I have nothing to do with Tom’s Planner. It must be run by “that other Tom”.

Perhaps due to its moniker, but more likely due to its power, flexibility, and ease-of-use, Tom’s Planner has earned a spot in my toolkit.  With a simple drag-and-drop functionality, you can create Gantt charts and easily export them to an image, MS Project file, or even its own (public or private) web space.  That is pretty much all the application does, but it does it well, making it ideal for Project Managers that don’t want to deal with hassle of learning the intricacies of modern Project Management software.

Check it out!  They offer a fully-functional, registration-fee (!) demo at:
http://www.tomsplanner.com/tomsplanner.aspx?template=example