|
|
Storytelling Through Data: A New Inbound Marketing & SEO Report Structure |
Storytelling Through Data: A New Inbound Marketing & SEO Report Structure Posted: 07 Jan 2014 02:32 PM PST Posted by ajfried This post was originally in YouMoz, and was promoted to the main blog because it provides great value and interest to our community. The author's views are entirely his or her own and may not reflect the views of Moz, Inc. No matter what business you are in, it's a pretty sure thing that someone is going to want to monitor how efficiently and productively you are working. Being able to show these results over time is crucial to maintaining the health of the long-term relationship. To us, reporting has become much less about the data, and more about the story you can tell with it. Not to say that data isn't important, but while a big spike in traffic is awesome, the drop that comes after it might not necessarily be a bad thing. It could be seasonal. Or maybe it's just leveling back after the brand was mentioned in a news report. To be totally honest, the same thing could apply to the spike itself, so hold off on those celebrations!
For the sake of transparency, this is something that we always felt we could improve on more at Kahena. We have tried it all, from email write ups, to using straight ranking reports (blerg, I know - so 2007), to a template-based Excel model (which is what we currently use), and even as far as planning a future web-based reporting platform for all of our clients to log in to and utilize as needed. This whole project really started in the wake of Google blocking all keyword data and turning it all into [not provided]. This really forced us to break old and bad habits and redefine what important metrics and insights we were sharing with clients.
We had two goals in mind during this project which were to:
Categorizing all the dataWe held a brainstorm and decided to compartmentalize the data into 3 different categories:
Here's what the brainstorm looked like after our meeting:
What this ultimately turned into is the following (click on the report for a full-sized version): Now, let me be clear, this could have gone in lots of different directions, and in many cases it does depending on the client. We chose the metrics above for our template because we felt they provided the best high-level insight. Let me explain. The KPI's we thought were most important were traffic and goals. That was a relatively simple one to decide since this is ultimately what clients hire us to improve. Leading indicators were a bit more challenging to solidify. We decided that for the purposes of story-telling, landing page data would be able to explain to our clients the progress we were making around specific landing pages we were optimizing. It also would provide more data into which *groups* of keywords were doing well and which needed a bit more attention. We also put an emphasis on vertical rankings (we partner with Rank Ranger to get that data). We specifically did not want to focus on individual keywords, although there is still a section for specific changes which are chosen to highlight campaign progress. The nice to know information is the one section that we didn't trend, and in the future we still might decide to do that. For now, we highlight user engagement data like pages per visit, bounce rate and average time on site. The one area we do trend here is site indexation, because that can have a major effect on a site's search engine health and provides an early warning to any index bloat issues A bonus area we added to the report allows our account managers to think creatively regarding non-standard data highlights and observations. Interestingly, this is often the section that gets the most comments from clients.
The most time-consuming piece in this whole process was setting up the initial template. The report itself is actually quite simple after that. The client-facing portion is one tab, which allows us to PDF everything, and it pulls data from other data tabs.
Most of the tabs have a similar table which has the date and the metric you want to visualize. This is just copying and pasting numbers from Analytics - nothing fancy. But, if you're curious, the tables where we put this data look like this:
Pulling the dataOnce set up, the only data we are pulling from Analytics is the number of:
The report basically does the rest since the data sources for all the graphs and charts have already been selected. We also download landing page data from Google Analytics which includes two segments: organic and total traffic compared by current and previous month. Similarly, when added into the appropriate columns, the template populates the data into this section:
All this data pulling and automation helps a lot with the time element. The problem we found was with a 10 person team (let alone a team of significantly more people), everyone wanted some level of customization, which was completely understandable. Each client is going to have specific requests, and each account manager is going to want to tweak it to their liking. The problem with everyone customizing the template is that it often resulted in some elements displaying weirdly when we made it into a PDF, or worse, broke some of the formulas that caused the template to work. When we investigated this, we found that 80% of our clients could use one of 2 templates:
Keeping the rest of the report intact involved some creativity. For this, if you are not familiar with offsets, then I suggest paying close attention. The offset function creates magicThis is a little-used Excel function from what I have found, but it's super powerful. What it does is: "Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned." Source: Microsoft Excel Help In other words, one cell could control pivoting the entire report between months. Every single table that you have in the report can be linked to one cell and change as that cell changes. Even better, if you can create a button that is connected to this cell, with the simple click of the button, it can adjust data in various parts of the template such as the date, the header, footer, and even provide a way for clients to navigate themselves through the data (if set up correctly). Here is how it works for us: In many ways, this serves as a database that holds historical data so it's saved for the future. Using this, we can show a trended analysis of the progress we have made over time without having to do a ton of data pulling, saving us a significant amount of time.
Given the amount of reports we, as an agency, run on a monthly basis, we need to find better ways of automation without the restrictions that come with third party tools. We have started developing an interactive web-based reporting tool built on the Microsoft Reporting framework. This will work by setting up scheduled jobs to collect data from various data sources (including Google Analytics) and automatically store them in our database so that we don't even have to pull the data. This will allow our team (and in the future - our clients) to access this data via pre-templated online reports and more time to tell stories and analyze trends. For now, we are still using Excel, which our clients still love.
The real point that I want to stress is that no matter what method you use for reports, the story is key. The data is crucial, but the insight around the data is what management wants to see. They want to visually see what is happening with their business, and understand through our analysis why it's happening. We have received an incredible amount of feedback from clients who have said things like "I really LOVE the format of having the charts or graphs, and then having your commentary/insights right next to itâ¦TOTALLY works for me" So they are happy. We are happy. And that's our process â" I hope you found something you can take away for your reports as well. One final tip to build the reportThis is not something that could be done alone. It really took the entire team's effort, ranging from junior associates up to the CEO, getting buy-in, agreeing on the metrics, and believing in the vision for what we were trying to accomplish with reporting. The ideas and feedback were invaluable and they should all be proud of what we accomplished together. Download the templateTo help you get started, we have made the template available for you to download. I am happy to answer any specific questions in the comments and help you as you set up your own report for you and your clients. Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read! |
You are subscribed to email updates from Moz Blog To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
TL;DR is internet talk for "too long; didn't read". It's also a sad, dangerous symptom of the malfunctions caused by the internet tsunami. (Here's a most ironic example of this paradox...)
The triathlete doesn't look for the coldest bottle of water as she jogs by... she wants it fast and now. That mindset, of focusing merely on what's fast, is now a common reaction to many online options. I think it works great for runners, not so well for learners.
There's a checklist, punchline mentality that's dangerous and easy to adopt. Enough with the build up, wrap this up, let me check it off, categorize it and quickly get to the next thing... c'mon, c'mon, too late, TL;DR...
Let's agree on two things:
1. There are thousands of times as many things available to read as there were a decade ago. It's possible that in fact there are millions as many.
2. Now that everyone can write, publish, email you stuff and generally make noise, everyone might and many people already are.
As a result, there's too much noise, too much poorly written, overly written, defensively written and generally useless stuff cluttering your life.
When we had trusted curators it was easy. We read what we were supposed to read, we read what we trusted, regardless of how long it was, because the curator was taking a risk and promising us it was worth it. No longer. Now, it's up to us.
One option is to read incisively, curate, edit, choose your sources carefully. Limit the inbound to what's important, not what's shiny or urgent or silly.
The other option is to assume that you already know what you need to know, and refuse to read anything deeply. Hide behind clever acronyms, flit from viral topic to flame war, never actually diving in. It appears that this is far more common than ever before.
Here's what I've found: When I read in checklist mode, I learn almost nothing. It's easy to cherry pick the amusing or the merely short, but it's a quick thrill with very little to show for it.
Judging by length is foolish. TL;DR shows self-contempt, because you're ignoring the useful in exchange for the short or the amusing. The media has responded to our demand by giving us a rising tide of ever shorter, ever more amusing wastes of time. Short lowers the bar, but it also makes it hard to deliver much.
Please, give me something long (but make it worth my time.)
Perhaps a new acronym: NW;DR (not worthwhile; didn't read) makes more sense. We've got plenty to choose from, but what we need is content that's worth the effort.
[You're getting this note because you subscribed to Seth Godin's blog.]
Don't want to get this email anymore? Click the link below to unsubscribe.
Your email subscriptions, powered by FeedBlitz, LLC, 9 Thoreau Way, Sudbury, MA 01776, USA. +1.978.776.9498 |
Mish's Global Economic Trend Analysis |
Hollande Wants to "Get Things Done" by Decree, Not by Passing Laws Posted: 07 Jan 2014 11:43 PM PST Via translation from Les Echos, inquiring minds may be interested to note Holland wants to "get things done" in 2014 by decree or order, not by passing laws. The first cabinet meeting of the year was held on Friday. François Hollande recalled the objective of reducing public deficits, without new taxes.Well, let's just issue orders, then hope parliament gives legislative approval later. Two Questions
Mike "Mish" Shedlock http://globaleconomicanalysis.blogspot.com Mike "Mish" Shedlock is a registered investment advisor representative for SitkaPacific Capital Management. Sitka Pacific is an asset management firm whose goal is strong performance and low volatility, regardless of market direction. Visit http://www.sitkapacific.com/account_management.html to learn more about wealth management and capital preservation strategies of Sitka Pacific. |
102 Police and Firefighters Caught in Disability Scam Posted: 07 Jan 2014 04:26 PM PST In what I believe amounts to a mere 100th of a percent of the disability fraud problem, CNBC reports About 100 people accused in NYC disability scam. More than 100 people were rounded up and arrested Tuesday morning as part of a massive investigation into disability fraud in the New York City area, authorities said Tuesday.At best the union will choose not to respond. More likely, the union will protest the arrests when the story dies down, just as unions protect child molesters in LA and New York. See the LA Times article L.A. Unified pays teachers not to teach. Also consider Student exodus in Michigan school district where teachers defended child molester. Please check out the above link, it's really quite amazing. Mike "Mish" Shedlock http://globaleconomicanalysis.blogspot.com Mike "Mish" Shedlock is a registered investment advisor representative for SitkaPacific Capital Management. Sitka Pacific is an asset management firm whose goal is strong performance and low volatility, regardless of market direction. Visit http://www.sitkapacific.com/account_management.html to learn more about wealth management and capital preservation strategies of Sitka Pacific. |
Posted: 07 Jan 2014 11:10 AM PST In yet another example of the extreme bubble optimism regarding equities, Trim Tabs reports (via email), Fund Flow Records Smashed Across the Board in 2013. TrimTabs Investment Research reported today that U.S.-listed equity mutual funds and exchange-traded funds took in a record $352 billion in 2013, smashing the previous record inflow of $324 billion in 2000. Meanwhile, U.S.-listed bond mutual funds and exchange-traded funds redeemed a record $86 billion, topping the previous record outflow of $62 billion in 1994.It's fitting that the previous record was set in 2000, right at the top of the dotcom bubble. Mike "Mish" Shedlock http://globaleconomicanalysis.blogspot.com Mike "Mish" Shedlock is a registered investment advisor representative for SitkaPacific Capital Management. Sitka Pacific is an asset management firm whose goal is strong performance and low volatility, regardless of market direction. Visit http://www.sitkapacific.com/account_management.html to learn more about wealth management and capital preservation strategies of Sitka Pacific. |
Google Glass: An Apps to "Glassholes" Review; Borglike or Beautiful? Virtual Reality Contact Lenses Posted: 07 Jan 2014 10:10 AM PST A link about a new app by Hyundai got me thinking about Google Glass. What is Google Glass? Google Glass is a voice activated computer eye-wear system capable of many voice activated functions such as photography, videos, navigation (better than and easier to use than car GPS systems), hands-free internet, and automatic translation of menus in foreign languages. Many apps are available and more are coming. Hyundai released an app for "pre-driving". Google Glass is likely to replace car GPS navigation systems at some point, and it's great car companies are looking in that direction. The rest of the car manufacturers will follow, and probably are already. Images The product is currently in beta mode, with early users reporting on their experiences. Some initial users loved it, some hated it or grew to hate it, and some were bored with it after the initial excitement wore off. Still other users complained that people were suspicious of them while wearing Google Glass. Different arouses suspicion say one "Glasshole" about his trial. Google Vision I am an eyeglass wearer which got me to thinking about just plain glass - as in eye glasses. How many people have truly horrific vision, so bad that eye glasses can only offer partial correction? I have a friend with 20-200 vision after correction. Could "Google Vision" project an image to a person's eyes in precisely the manner required to overcome whatever extremely poor eyesight one had? Better than eyeglasses can? I suspect "Google Vision" could correct for brightness, astigmatism, and severely distorted eye shapes that currently take inch-thick lenses to correct, and then only partially. For the vision function, an image would have to be projected into each eye, perhaps requiring two photographic lenses, perhaps a single photographic lens and two projector lenses. Borglike or Beautiful? If people are treated like Martians, "Glassholes" or Borgs for having a single Google Glass camera above one eye, what would happen to those with lenses sitting over both eyes (the way vision actually works)? Yet, as I browse through images of Google Glass wearers, many are far more beautiful than "borglike". Of course, no matter how people are treated now, if enough people start wearing Google Glass when prices fall (and prices will fall), the stigma of "Google Glass" would likely wear off quickly. Virtual Reality Contact Lenses And what if there were no glass at all, just contact lenses? You would not be able to talk to your contact lenses, but CNet reports Augmented-reality contact lenses to be human-ready at CES Anyone who has ever dreamed up a sci-fi future in which neon interfaces float in front of us and information exists not on screens, but projected onto our eyes, is likely watching the blossoming wearable technology market with great anticipation. With its iOptik system, wearables startup Innovega has sighted in on that futuristic vision, designing special contact lenses that will read the light from projectors fitted to glasses. In doing so, it's inching closer to a product that may rival even Google in its wearable ambition.In addition to contact lenses, Innovega also has something that looks similar to Google Glass. Here is an image. Inquiring minds may be interested in some articles and videos about "Google Glass".
Final Thoughts I would like to test out "Google Glass" or the Innovega iOptik System provided I don't have to pay for the privilege. It would have to fit on top of the glasses I normally wear, but some of the images suggest that is already possible. User Robert Scoble says Google Glass is Doomed. I will take the other side of that bet. I can think of all kinds of apps. Virtual Reality Sharing What about virtual reality sharing? One person wearing Google Glass can share their experience with a group of others far away. What one person sees, everyone sees, as if they were there, real time. That app alone has numerous possibilities. Want to know what it's like to climb Mt. Everest? The possibility awaits, and many would pay for the experience, without going through the cold and training of being there. I suspect everything I have thought of is already being worked on. Google Glass will evolve in more ways than people can imagine. Wine Country Conference II The second annual Wine Country Conference will be held May 1st & 2nd, 2014. We have an exciting lineup of speakers for this year's conference.
In addition, we expect confirmation from a number of other highly respected fund managers and speakers. This year's event is two days and will include additional "break-out" groups. For speaker bios, please check out Wine Country Conference Speakers. This Year's Cause: Autism $100,000 of the money raised last year came from a generous matching grant from the John P. Hussman Foundation. Some of us in the industry who have done well are making an effort to give something back. John Hussman is at the very top of that list. One of John's kids has severe autism. This year, all net proceeds will go to support autism programs. Conference Details For further details about the 2014 conference, please see Wine Country Conference May 1st & 2nd, 2014 Nothing Like It! This event is not just another "come and hear someone talk" kind of thing. Attendees and their significant others can expect an educational, fun, and relaxed time. Last conference, we arranged wine tours. They were a big hit. We will do so again. One of the wine estates we visited had a Bocce Ball court. On a couple of miracle shots, I won both games I played. Stay an extra day and golf or travel. I did. The conference hotel is a fun place in and of itself. Unlike many other conferences, you will have easy access to speakers. Want to chat with me, Steen, John, or anyone else at the conference? You will have an easy chance. Not only do we have an excellent lineup of speakers, you will have an opportunity to meet with them, have intimate discussions on important investment topics, with a lot of fun on the side, including wine tours and great wine. There's nothing like it in the investment business. And your money goes to a great cause! What can be better? Register Now for Discount We extended our $200 "early bird" discount through January 10, for those who register early. There will be no further extensions. Please Register Now! Mike "Mish" Shedlock http://globaleconomicanalysis.blogspot.com Mike "Mish" Shedlock is a registered investment advisor representative for SitkaPacific Capital Management. Sitka Pacific is an asset management firm whose goal is strong performance and low volatility, regardless of market direction. Visit http://www.sitkapacific.com/account_management.html to learn more about wealth management and capital preservation strategies of Sitka Pacific. |
You are subscribed to email updates from Mish's Global Economic Trend Analysis To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
Damn Cool Pics |
The World Needs More People Like This Posted: 07 Jan 2014 11:59 AM PST |
You are subscribed to email updates from Damn Cool Pictures To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
Facebook Twitter | More Ways to Engage