How To Use Macros You Find Online In 6 Easy Steps

Have you ever done a search to find out how to do something in Excel, just to find the search results littered with macro options? I used to avoid those results like the plague because I found macros (at least those beyond what I could create with the Macros Recorder) really intimidating. And I’m writing this post because I'm assuming that I’m not the only one who has done that. Amiright? So I’m going to show you how to take a macro you find online or get from a trusted source and add it to your workbook and run it — on both a PC and Mac. If you want to follow along, you can down [...]

How To Turn (Not Provided) Into Useful, Actionable Data

We've all seen it, lurking in our Analytics reports, nearly always at the top, sucking a huge chunk of data into a black hole of uncertainty and uselessness. Not provided was predicted as having a single-digit impact on sites. In my research, I've found it to have upwards of a 40% impact, especially on smaller traffic sites. In conversations with clients, and looking at my own sites, I knew the numbers had to be better – but what do you tell a client when chunks of data, in some cases over 30%, are attributed to (not provided) instead of the keywords you've given time, attention and te [...]

11 Things To Ask Yourself When Optimizing Content

A client asked me the other day why we were optimizing his software for Los Angeles, when he’s located in Raleigh, NC. In explaining the reason to him, I realized that a basic guideline for optimizing pages is long overdue. I’ve developed the following flow chart and explanation in response. Theming Content The first question you need to ask yourself when optimizing a page is, What is the Page About? If you can’t answer this or your answer is a keyword, then maybe you shouldn’t be building the page. Seriously. You need the page to be about something in order for it to have value [...]

How To: Google Analytics Installation For Novices & Beginners

If you're an intermediate to advanced Google Analytics user, this article will probably be of little interest to you personally. I suggest you bookmark it anyway as a reference for clients or friends who are just starting out with Analytics. As a long-time agency employee, I see many clients, prospects and even casual acquaintances with websites that feature absolutely no Analytics data. They have no idea what is going on, or what they're missing because the visitors that come to their site disappear into a vacuum. This article is meant to walk first-time installers through the process, [...]

How To Conduct A Link Audit

In the comments section of my last column, someone asked me about link audits, and after looking around to see if I could find a good resource to point her to, I didn't find anything that was exactly what I was looking for. I found loads of great pieces on SEO audits but not that much specific to links. (Maybe that particular SERP was affected by the latest Google update.) One reason that I've not written much about link audits is that it's a process that's very fluid for me. I love trying out new tools and there are always algorithm updates that favor something more than something else. [...]

How To Look For Trouble & Find Opportunity In PPC Campaigns

As I start each day managing our PPC accounts, the same two questions always come to mind: "What problems do we have to address right away?" and "Where can we find more opportunities?" The more quickly I can get a handle on these two questions, the more quickly I can take appropriate actions. That’s why I love all the visual trend line graphs available in Google AdWords, Microsoft AdCenter and other paid search analytics tools. With a quick glance, well-trained eyes, and the same sense of investigative curiosity that we see every night in crime and courtroom TV programs, I can quickly [...]

10 Simple Tips For Effective Mobile SEO

There is little doubt that mobile search is the hot topic in the SEO world at the moment. Some brands are now finding that more than 30 percent of all searches come from mobile devices, according to Mobile Marketer. It’s fair to say that mobile search is quickly moving out of the Stone Age and into the digital age. That's the premise of a new insight paper, Mobile SEO Best Practices, published recently by my company, MediaWhiz (disclosure: I lead MediaWhiz's search marketing and digital strategy divisions). In addition to a list of our top-10 tips for effective mobile SEO, the paper offers [...]

How To Find Success With Google’s Display Network

Google’s display network is massive, encompassing more than 4 billion daily page views, 700 million monthly users, and reaching more than 80% of the online audience. Yet, with all this inventory, many marketers fail with display marketing. The major reasons are they either are trying to reach the incorrect goals or they don’t understand how all the targeting options work. In this article, I’m going to walk through how to get started with display advertising so you can avoid some of the most common mistakes that cause marketers to fail with the network. Display Keywords Most ma [...]

A Primer On AdWords Remarketing Using Google Analytics

Remarketing has been around for quite a while as part of the Google AdWords suite of tools. Remarketing works by creating a "list" or "audience" within Google AdWords. The pages that are pertinent to that audience are tagged with special code that allows Google to place a cookie in the browser of anyone who visits that page. It's a great way for you to get your brand out there in front of your website visitors, even when they're not thinking about shopping and buying from your site. There are tons of ways for you to segment your website to serve remarketing ads; you can even get as granular [...]

How To Manage & Measure Local PPC Accounts

In my last column, I looked at some of the differences between small and large accounts as the best practices vary for each. In this column, we’re going to specifically focus on one of the most common small accounts: local accounts; and examine some of the best practices for this type of small account. A local account is where there is a limited geographic area being served. When you combine a limited geographic reach with a small budget, you often run into problems trying to balance spending the budget on highly relevant keywords while getting a high enough return for the budget so th [...]

Figure Out What Is Important, Then Measure It

As search marketers, we are constantly digging around in analytics, finding data, thinking it looks neat, then stepping back and saying, "But is this important?" I've done this a million times, and recently came across a quote that put some of what I'm always looking for into perspective. Don't make the measurable things important but make the important things measurable. The data you have is not necessarily the data you need to succeed. I think we go about this all wrong sometimes. Instead of finding data in Google Analytics or some other tracking program and trying to figure out if [...]

Keyword Research Tool Review: Google AdWords

Keywords are important. I've heard from several potential clients recently who have talked to other "professionals" who told them keywords are no longer important for SEO, and that good content is all you really need. Here's the thing. Keywords are language. They'll always be important because words are how we communicate with each other. So until someone invents the microchip that can be implanted in your brain and read your thoughts without using words, you'll need to think about language in marketing. And I can only hope that those potential clients were told this by one seriously mis [...]

Getting Started With GoMo & DudaMobile, Now Backed By Google Analytics

Mobile is all the rage right now. Just a few days ago, Google came out and said that they recommend responsive design for mobile SEO and now, the Google Analytics division has just launched a new mobile solution. Allow me to tell you about this… Just recently, I received an email from Google Analytics offering me the opportunity to, "Make your website mobile-friendly in minutes, and measure the impact with Google Analytics!" This sounded like a great offer to me, so I decided to explore it further. Basically, Google Analytics is offering a new mobile solution known as Google Analytics [...]

Can Local Businesses Jump On The Pinterest Train?

It’s the 'new' social network everyone is talking about – and if you’re a local business owner, it could be a strong addition to your online marketing strategy. For the past few years, marketers have stressed the need for local businesses to leverage social networks like Facebook and Twitter to drive engagement with existing and potential customers. Now Pinterest, the visual scrapbook network that allows users to "pin" images and video they want to share from across the web, is becoming part of the conversation for a number of reasons: Unprecedented user growth. In March, Pinterest [...]

10 Great Adwords Options For Boosting Conversions

We all know that Adwords is the most used system in the world to drive paid traffic to websites. The Adwords system is an extensive system with a lot of complex options to optimize campaigns and increase conversions. Advanced PPC managers should already know all of these features, but beginners and intermediate level Adwords users can definitely get some new inspiration and ideas from this list to boost up performance. In this article, I will highlight 10 features that I love and frequently use. 1.  Adwords Keyword Tool The Keyword Tool is a great starting point when starting a new Adwo [...]

3 Lessons Paid Search Can Learn From SEO

There’s no denying the synergy between SEO and paid search marketing, and paid search marketers would do well to take away a lesson or two from the world of organic search engine optimization to improve their campaigns. 1.  Keywords! Keywords! Sherlock Holmes exclaimed, "Data! Data! …I can't make bricks without clay." And likewise, keywords are the backbone, heart and soul of all search engine marketing, paid or organic. There’s a whole mess of keywords work and reports done for organic search optimization that paid search marketers can and should utilize. On the most basic level, [...]

The SEO Breakdown: Bank Information Center Site Audit

SEO-Audits-Case-Studies-Site-Examples As part of a site audit special series, we're going to review an interesting website, Bank Information Center (BIC). BIC is a non-profit organization that does some very cool things but, like most non-profits, hasn’t updated their website for many years. Needless to say, they have almost no Internet marketing or SEO strategy which led them to ask for help by submitting their site for this series. In this post, I’m going to break down: Who the business is and what they do First Impressions: Overall analysis of website look, feel, targeting and usability Second Impressions: [...]

Are You In Danger Of An Online Traffic Crisis?

As relative newcomers to the world of analytics and site and revenue improvements through analytics, many clients ask me about the traffic sources chart in their Google dashboard:   Why is this important? I give one explanation of this as a measure of "Are my eggs all in one basket?" and "What happens if they are?" For example, the client above has 66.57% of their traffic from search engines. This is a combination of organic and paid traffic. Of that 66.57%, when we drill further into that segment of data, we see that 84.5% of that is from Google alone with a breakdown of 45% [...]

Work Smart, Not Hard – An Introduction To Google Analytics Dashboards

I love my Google Analytics dashboard and I'm not ashamed to admit it. It saves me time, helps me look like I'm 100% on top of things when a client calls, and helps me add hours back into days that were previously spent hunting and pecking for information. Right now, my client load consists of about 19 different domains that all have their own analytics installs. Each week that's a lot of information to check, verify, monitor, and create an action plan from. Without my dashboards, and most importantly, my consistently formatted dashboards, I would spend hours finding information - now I have [...]

Nine Best Practices For Optimized < title > Tags

When I do an SEO audit on a webpage, one of the first things I check is the <title> tag. Why? Well, I have several reasons. [caption id="attachment_112710" align="alignright" width="300" caption="Best Practices for Title Tags in SEO"][/caption] In my book, the <title> tag possesses all of the following: It has the most SEO power of any tag on the page for establishing keyword relevance Its contents are the source for the blue-link text shown in the search engine results pages (SERPs) It’s the best place to get a concise description of the content on the page (well, th [...]

Get Our News, Everywhere!

Daily Email:

Follow Search Engine Land on Twitter @sengineland Like Search Engine Land on Facebook Follow Search Engine Land on Google+ Get the Search Engine Land Feed Connect with Search Engine Land on LinkedIn Check out our Tumblr! See us on Pinterest


Click to watch SMX conference video

Join us at one of our SMX or MarTech events:

United States


Australia & China

Learn more about: SMX | MarTech

Free Daily Search News Recap!

SearchCap is a once-per-day newsletter update - sign up below and get the news delivered to you!



Search Engine Land Periodic Table of SEO Success Factors

Get Your Copy
Read The Full SEO Guide