We all know that links are an important part of SEO. They help users and bots navigate a site and give search engines information about its quality and authority. With links confirmed as one of Google’s top three ranking factors, we’ve all been reminded of the importance of quality, relevant backlinks. In order to get those backlinks, we have to put a good amount of effort into link building, and that often proves to be a big challenge. There are scaling issues. There are research and outreach management challenges.
Last week I did a Mozinar on content purging, and how it can improve your SEO. If that sounds interesting to you, click this link to check out the recording.
Now in that webinar, I shared a Google Sheets tool we built to help pull website data fast. Paste a list of your URLs, and voilà – your data is available in a Google Sheets format (which you can easily export into Excel if you wanted to). From different groupings from different date ranges, get your sessions, pageviews, conversions, etc. Not unlike something you can get from URLprofiler or Screaming Frog, but if you like this alternative, you can have it.
Today we’re making that tool available to you as our latest addition to Greenlane Labs (which in a few weeks will have a new name and purpose – more on that later!)
Try It Now > The URL Performance Tool (in Google Sheets)
Simply click the link above. You’ll be prompted to make a copy.
The tool looks like this:
The tool was created to provide a high-level snapshot of a page’s performance without the need of logging into, and navigating through, an analytics platform. Built with the Supermetrics add-on for Google sheets (which you will require for this to work), and combined with Google Analytics, it brings together widely used tools in a scalable and customizable format. Quickly get data like sessions, pageviews, average time on page, bounce rate, conversions and conversion rate.
So next time you just want a quick look at website data for a list of your URLs, you can go to Google Analytics and wrestle it out of there, or use this tool.
- Installed Supermetrics
- Active Google Analytics account, and login access to the desired account
- Google sheets
Note: The logic used to create this tool can easily be converted for use in the Google Analytics API if that is your preference.
Give it a try. If you have any questions, email firstname.lastname@example.org. Have fun!
If you’re not checking your client’s HTTP headers, you’re not giving them good service. I’m not talking about the stuff in between theand tags, either. I’m talking about the server response that you get before you get all that nice HTML, or that fancy PDF, or whatever else your client’s website is slinging. That’s because, well, your client’s website isn’t slinging anything. It’s being slung by a server, and the server’s HTTP response is the first thing a web browser – or a web robot like Google’s crawler – will see.
Whenever I’m working on a linkbuilding campaign for a client, I’m always trying to think of it from a journalist perspective. I worked at The Daily Collegian, Penn State’s student newspaper, when I was in college, and constantly proofreading my colleague’s work for spelling and grammar errors isn’t the only thing that’s stuck with me. Lucky for me, I know people who remained in the industry who I could pester with my questions. And even luckier, they happen to be my best friends.
SEO is hard work. Pitching it to prospective clients shouldn’t be. To support our pitching process, sometimes we’ll generate an SEO opportunity analysis following our introduction call. It’s a great sales tool, but an even better tool for understanding if the client is a good fit (and vice-versa). The following is for those who need to get buy-in from someone else in order to go after the SEO work that they want.
Twitter is getting ready to launch significant changes, including the ability to retweet yourself, as covered by the incomparable Lance Ulanoff on Mashable recently. I got curious. Could it be that these features are already live on Twitter, and just superficially grayed out in the code?
Many members of the Greenlane team are commuters. Traveling thirty minutes or more to the office has created avid podcast listeners out of many of us looking to make the most of our time spent stuck behind the wheel. Keeping true to our “Always Keep Learning” spirit, we’ve internally listed out a few of our favorite podcast episodes. Some are marketing related, and some simply inspire the mind. I thought it might be a good to share this on the blog so you can find some new sources of audible digital marketing information. Let us help optimize your listening time.
Imagine you’re the new agency, SEO lead, or even junior level assistant for a huge brand. You know, the kind of household brand name people know. The kind of company you read about in college or in case studies for their wicked brand recognition, reach, and authority metrics. Cool feeling, right? I remember that feeling from working with my first big client and I still get it today, seven years later. But what I don’t remember were any college courses that discussed marketing at scale. In fact, this topic still isn’t getting the blog playback that it should.
On January 15, 2016, I helped lead an intro to SEO session for the brilliant students of Drexel University in Philadelphia in their New Media Marketing class (led by Jed Singer of Socialight Media and Professor Lawrence Duke). Joining me was the incredible Emma Still from Seer Interactive.