ShufflePoint is a paid application that uses Excel’s built-in “Web Query” function to pull data from Google Analytics into Excel. It is an extremely powerful tool and allows you to take advantage of Excel’s data manipulation abilities. This gives you the freedom to develop compelling visuals that will help you quickly assess the performance of a website. When I was developing my first ShufflePoint report, I found that thinking about and planning data organization took the most time. My hope is that this article will help you graph your Google Analytics data in Excel with as little trial and error as possible.
Spurred on by the Edward Snowden revelations, Google has begun taking security more seriously. After the revelations came out, Google quickly secured and patched their own weaknesses. Now they are pushing to encrypt all internet activity by incentivizing websites that use SSL certificates by giving them a boost in rankings.
During a Google I/O presentation this year called HTTPS Everywhere, speakers Ilya Grigorik and Pierre Far made it clear that this move is not just about encrypting the data being passed between server to browser, but also to protect users from having the meta data surrounding those requests collected.
Though the meta data collected by visiting a single unencrypted website is benign, when you aggregate that data it can pose serious security risk for the user. Thus by incentivizing HTTPS, Google has begun to eliminate instances on the web where users could be vulnerable to having information unknowingly collected about them.
I will give you the spark notes version of the HTTPS Everywhere presentation, but even that will warrant a TL;DR stamp. My hope is that this outline and the resource links contained within it give you a hub you can use when evaluating and implementing HTTPS on your site. (more…)
A holistic industry transformation was the tone at MozCon this year and Erica McGillivray and team did a fantastic job getting speakers that supported this theme. Those chosen for the conference are experts in their fields, pushing conventional wisdom and challenging us with new ways to tackle old problems. Each spoke on different topics, but to the same point.
MozCon started with a presentation from our fearless SEO leader, the Wizard of Moz himself, Rand Fishkin. Rand started off the conference by reflecting on the past year in search and framing his vision for the future. He highlighted 5 big trends from the past year.
MozCon is a three day marketing conference put on by Moz.com. The conference brings together next-level speakers to talk about everything from SEO to brand development to analytics. This year Erica McGillivray and team will bring 29 speakers to the Emerald City to give their expert opinions on the future of marketing. It is a jam packed three days, so I have outlined eleven of the people I am most excited to see along with some of their own reasons you should watch them.
When: July 14-16, 2014
We here at LunaMetrics are born from data and to data we return time and time again to uncover insights and craft strategy. But staring at large sets of data is a mind numbing process, one I personally hate. So when I began performing health checks for large websites I immediately starting thinking about how I could eliminate as much work as possible. Using some Excel magic, many Mr. Excel videos, and data pulled from Screaming Frog I created a simple copy & paste workbook that counts, totals, and visualizes all the data Screaming Frog gives you.
Shout out to Dan Sharp of Screaming Frog for his great feedback on this workbook. Keep an eye out for Screaming Frogs new version being released in the next couple weeks. The big addition? Data visualization. Can’t wait for that!
Google recently announced that they added more precise data in webmaster tools. The announcement highlighted the ability to track secure (https) versions of a site and also cast a light on a webmaster’s ability to track subdomains and subdirectories.
In their documentation Google provided examples of the types of URLs you can add.
What is rel=”author”?
Part of the HTML5 spec, rel=”author” can be added to any <link>, <a> or <area> tag to inform search engines that the other end of the author link represents the author of the piece of content it is crawling.
In 2011 Google began using rel=”author” in an attempt to understand authorship of content more broadly. There has been some turbulence in the SEO community over whether Google will actually be using this to rank content in future. But Google’s Matt Cutts has most recently stated that Google is using rel=”author” as part of an Author Rank when serving in depth articles in their search results. Thus it is important to know you have this set up properly on your website. (more…)
Hmm…I wonder what this post is about.
You don’t spend endless hours online without coming across some great websites that the average person wouldn’t find. I have folders and folders of these sites and thought offloading some of them into a blog post would be useful for some. The following resources focus on design: free stock image sites, free vector graphic sites, color generates, pattern generators, and a couple great free font and data visualization websites.
“A designer knows he has achieved perfection not when there is nothing left to add, but when there is nothing left to take away.” –Antoine de Saint-Exupery
Keep it simple stupid. Moderation is the key to a good life and good 2014 UX. Flat design is about removing all the unnecessary flare and letting the what you have to say be the main focus. In the past there has been a gap between the world the designers are living in (Photoshop) and the developers were living in (text editors). Browsers are getting better about what they can and cannot do from a color and design(svg) perspective, which used to bottleneck the creativity of the designers. This gap will begin to close as the adoption of flat design provides designers with more incentive and necessity to design within the browser. Because of this browser focused design, the capabilities of the developer will be paramount to the execution of the designer’s vision. The developers ability to understand not only how to code the design, but understand how that design will translate across browsers and devices will make finding the designer-developer team as important as either one of their capabilities. Will we see the first crowning of a Developer-Designer team crowned as the king of 2014 web design?
This is The 404 Situation.
No wait, this is. You have thousands of product images stored across many different directories on your website. In an effort to keep things more organized you decide to consolidate those images to one directory on your website, leaving you with the task of creating a best match redirect map for the old images to their new directory. The only similarity between the new and old URLs is the product name. Below I’ll show you how to use regular expression and Excel to make a best match redirect map for complex URLs, leaving you more time to GTL.