Archive for the ‘Miscellaneous’ Category
Here’s a quick tutorial on how to use Excel to analyze the keywords that have more than one of your site’s pages ranking in Google organic search results.
Your site may have plenty of keywords that have more than one landing page ranking for a variety of reasons. For example, when someone googles “Google Analytics Training”, there are many different LunaMetrics pages that might display, based largely on where the user is located.
Let’s look at how we can break these out and analyze them further. (more…)
Raise your hand if you’ve heard a co-worker say “Ugh, I’ve gotta jump on a call”! Most people don’t look forward to phone calls with clients. There’s the inherent fear that you’re not prepared (It’s hard to imagine the audience in their underpants when you’re only calling one person across the country), or that you don’t have the right report or solution lined up.
If you work in the Search & Analytics fields like we do at our office, it’s quite possible that you have not and will not meet certain clients face-to-face due to distance, so building rapport can be a challenge. You just don’t get to shoot the breeze on the phone like you might during an on-site visit or lunch with your client.
In fact, relationship building is my favorite part of working with clients. Helping them succeed and meet their objectives helps me succeed and meet mine, so I invest in good client relationships wherever I can.
If you don’t share my excitement over client calls, I’ve assembled the following presentation to help you ease any fears when preparing for and executing your next client call.
Did you ever want micro-level geographic information inside Google Analytics? What if you really need “street level” knowledge about your users; like where are they, what neighborhood are they in? Often, when we talk and write about Google Analytics we’re thinking about the big guys. National or even International traffic, filtering by country, comparing one region to another. We’re thinking macro, not micro.
I wrote previously comparing DMA areas to gain insight, but that’s really only helpful if you have a true national or bigger presence. What if you’re just a local Seattle business, and don’t really have much call for looking at traffic outside the Seattle-Tacoma metro area?
Well, first thing you should do is think about taking our Seattle Google Analytics, AdWords, and Tag Manager Training (shameless plug). Second, read on…
Seattle is actually ahead of the game when it comes to data, which is the real reason I’m using them as an example. The city has a Chief Technology Officer, and data.seattle.gov was started in 2010 as a central hub for all local Seattle data. In fact, a number of businesses claimed that the use of this local data helped them with their businesses.
How so? Well, if you’re a local business then the traffic from, and information about, the Queen Anne neighborhood of Seattle might be more important to you than Downtown or Riverview.
But how can you use Google Analytics to help you on this sort of granular level? Also what if you DO care about national level data, but you care about it on a very granular local level as well, maybe looking for interest in your brand to help place billboards, or expand your franchising? The truth is that you can’t, at least not right out of the box. But with a few very easy additions, you can start getting some great local data that can let you make street level decisions about your business in Google Analytics. (more…)
The news that Google plans to drop Authorship photos from the search results was unexpected, but probably not shocking to many SEOs. It will be done in an effort to provide a better mobile experience by decluttering the results, said Google’s John Mueller.
All speculation and mourning aside, we are curious how this affects Google users that have grown accustomed to Authorship photos and Circle information.
In my role here at LunaMetrics I talk a lot about blogs. I love advising our clients on creating engaging blogs using unique, clever content. Our team here at LunaMetrics has been having lots of discussions lately about our own site. Everyone at our company contributes to our blog.
When I came across Matthew Barby’s awesome method for scraping websites to identify link prospects, I immediately wondered what trends I could identify from our own blog using this method. In this post, I’ll examine our blog with third-party tools to extract some actionable insights.
Scraping websites is an awesome way to collect data (provided you’re not violating anyone’s Terms of Service…). In this example I used Screaming Frog to crawl an entire website (Yours!) as well as SEO Tools for Excel to crawl elements of the site’s pages and an API to identify social shares. When it comes to competitor research or building a list of potential press outlets and authors to contact, this technique can’t be beaten because you don’t even need Google Analytics access to amass this data. We’re automatically taking it right from the page. (more…)
Want to segment your users by whether they live in a cool neighborhood in GA? We’ve got an API for that.
How Much Does Scrap Metal Cost?
About a year ago we were working with a client who wanted to bring some very specific data into their Google Analytics account. They wanted to compare their site traffic with the current price of scrap metal, by adding it as a Custom Variable on the visit. While scrap metal prices aren’t exactly something that would help many other clients, we started thinking more about different kinds of ways we could pull other information from APIs around the web, into Google Analytics, in ways that would increase our insight. (more…)
In a couple of weeks, I will be attending the 2014 SMX Advanced conference in Seattle, WA. This is my first search marketing conference, and I couldn’t be more excited to be locked in a room with a bunch of SEO and PPC nerds (like me) from June 10-12. I’ve reviewed this year’s agenda more times than I’m willing to admit. (more…)
Note: This article contains updates to the previous article “Statistical Significance Script for Google Analytics”, which has been redirected to this article. See the changelog for details.
In March I wrote a script for the statistical evaluation of time-frame comparisons in Google Analytics. The idea seemed well received, but who wants to have to hit F12, open their developer console, and then come back to my blog post for the code… every time you want to run the script?
So, I converted the script into a Chrome Extension (click below)!
To celebrate our survival through the harsh winter and welcome spring, LunaMetrics held a cut-throat Peeps Diorama competition! All LunaMetricians were given the opportunity to create and submit a diorama depicting a major news or entertainment event from the past year. There was only one rule; all entries must contain a peep! The competition ran throughout the month of April. On April 30th, the employees of LunaMetrics cast their votes for their favorite diorama and chose one peep to rule them all!
Read on to view the five entries, then pick your favorite and see if it was the same as our grand prize winner!
GWT Pages Export 1.0
And below is an updated Bookmarklet with a progress count:
GWT Pages Export 1.1
In order to save this Bookmarklet, drag and drop this link onto your Bookmarks Toolbar. Alternatively, right-click it and copy its link address. Then, create a new bookmark and paste your copied address as the Bookmark address.