Tableau Software – A Data Analyst’s Dream

by: +Joanne Marcinek

Here it is, my first publicly published data visualization:
Cancer Incidence Rates by State and Cancer Site (Stats from National Cancer Institute)

Facts quickly gleaned from this visualization:

  • Breast and Prostate Cancer are the highest incidence cancer sites in the United States
  • The District of Columbia has the highest Prostate Cancer Rate
  • Massachusetts has the highest Breast Cancer Rate
  • Kentucky has the highest rate of Lung Cancer per 100,000 people

Some helpful tips for interacting with this visualization:

  • At the top of the screen are tabs for the different “sheets” of the visualization (Dashboards are sheets that combine one or more detail sheets): 
  • If you hover over a column heading, you get a little icon that allows you to sort the data in ascending or descending order:
  • You can click on a type of cancer or a state and either exclude it, or display only that data: 
    • Use the <ctrl> key to select more than one filter at the same time.
  • You can also filter the data by State:
  • To Undo or Reset to the default settings, click on the reset button at the bottom of the visualization:
  • You can get more detail about any datapoint by hovering your mouse over it to get a “tooltip” to pop-up: 

Feedback welcome. More visualizations coming soon.

Posted in Uncategorized | Leave a comment

What Businesses Need to Know about Google+

by: +Joanne Marcinek

Do you sometimes feel that things are moving so fast that new technologies become a blur? I do too!  Here are some quick notes on what businesses should be aware of regarding Google+:

More soon!

 

Posted in Uncategorized | Leave a comment

Why Both Weight Loss and Google Rankings Are Limited Goals by Jill Whalen

My husband and I were talking the other night about one of his pet peeves: When people start exercising and eating healthier, they usually measure their success by how much weight they’ve lost (or not) as shown to them by their trusty scale. It annoys him because, while losing weight is one sign that you’re doing things right, after a certain point, it can only tell you so much.

It reminded me of my own pet peeve: how people usually measure the success of their SEO work by checking how well their site ranks in the search engines. Yet, similar to weight loss being a poor main goal for your health and fitness regime, where your pages rank for specific keyword phrases is also a poor main goal.

Healthier Body – Healthier Website

Your principal goal when eating in moderation and exercising regularly should be to become healthier overall, and ultimately to live a longer and more satisfying life. And your chief goal with an SEO program should be to create a better overall website and make more money from it — which, incidentally, can also make for a more satisfying life! ;)

Writing articles nobody is really interested in about the history of your products is like eating lots of junk food. It’s empty calories. There’s no value in it to anyone (except perhaps the donut store) and it keeps you from eating the good stuff. Writing keyword-filled content just for the sake of search engines works the same way: It keeps you from adding true value to your website. While you can try to cover your big ole body in a floral mu’umu’u, let’s face it, you’re still out of shape underneath it all.

And it’s the same with your website. There’s no sense adding good content on top of bad. If it’s already full of junk (food), it’s time to trim it down and cut out the crap (content).

So how do you measure the effects of trimming the fat?

I’m not saying that weighing yourself and checking up on your rankings are utterly useless. In the beginning, both can be a good way to make sure you’re on the right track. Let’s say you get all into your new health kick because none of your clothes fit and you can barely make it up a flight of stairs without having to stop for a rest. The more you exercise and eat right, the better the numbers on your scale are going to look. This can definitely keep you motivated. But the weight loss itself is only one result of your success. Other results might be that you look and feel better. In fact, even if you lost only a few pounds, if you’re eating better and exercising regularly, you’re likely a whole lot healthier and may even have a lot more energy and overall focus.

And so it is with SEO.

When your rankings for a few key terms move from “nowhere to be found” to being on the first page in Google, it shows you that you’re certainly on the right track. But here’s what is more important: You’re likely seeing not only more visitors to your website, but more targeted visitors. And just as more energy results from a good exercise regimen, more conversions and sales come from more targeted website visitors.

But you can only lose so much weight (and check so many rankings).

If you keep up with your fitness program you’ll probably get to a point where — even though you’re back in your skinny jeans — the needle on the scale has stopped moving in the “right” direction. When you measure your success by how many pounds you’re losing, this can be confusing. You know you’re exercising often and eating correctly, but can’t understand why you’re not still losing weight. And this is where my husband’s pet peeve comes in.

According to him, the more you exercise, the more muscle mass you put on your body. This in turn may even cause you to gain weight because muscle weighs more than fat. At this point, it’s silly to be constantly weighing yourself and worrying why you’re not losing weight anymore. So at this point you can change your goals. After all, you are probably looking fabulous with a whole new body shape. You’re healthy, fit and trim. Your scale isn’t measuring your lost percentage of body fat, nor is it taking into consideration the fact that you’re stronger and no longer short of breath. So why keep looking at the scale?

It’s the same with your website.

Once you know you’re on the right track with your SEO, you no longer need to check your rankings. They simply don’t tell the whole story. Rankings don’t make you money or make your site convert. They don’t show you how healthy (or not) your website is.

After the initial stages of your SEO program, it’s time to put away your rank checking software (or scale) and adopt new goals — start counting how often your phone rings, your contact form gets filled out, and how fabulously your website is converting all those extra targeted search engine visitors. Then sit down and have a healthy fruit smoothie — because you deserve it!

Jill


Jill WhalenJill Whalen is the CEO of High Rankings, an SEO Consulting company in the Boston, MA area since 1995. Follow her on Twitter @JillWhalen

If you learned from this article, be sure to invite your colleagues to sign up for the High Rankings Advisor SEO Newsletter so they can receive similar articles in the future!


Reprinted with Permission: I thought this was an excellent analogy and had to share!

 


Posted in Uncategorized | Leave a comment

Personalized Search – Turn it OFF

by: +Joanne Marcinek

I love Google, I really do. I have and frequently use several of their tools and rely on them for keeping my business and personal life organized. However, as an SEO professional/internet marketer, I find nothing more annoying than having my search results be based on my personal search history.

Now, on their answer page about it, they say you can simply click the setting that says: Disable customizations based on search activity Yet, I cannot find that option anywhere on the page. I also don’t want to delete all my search history (which apparently is another way to do it) because I USE the search history to refer back to websites I’ve found and research I’ve done.

They say you can disable personalized search by signing out of your google account, well yes, that’s true, but it also means you will have signed out of Gmail, calendar, docs, etc. so if you have those pages open a the same time, they will no longer work.

I did find a site that tells you how to disable personalized search by adding a parameter to your search results (&pws=0). He also has instructions on how to do it with several browsers.

So, if you want to see the “real deal” when you are searching and not results based on previous websites you’ve visited, disable personalized search. I think I may do a How To at Hubpages on this.

Posted in Google | Tagged , , | Leave a comment

Search Engine Optimization Workshop – Saturday April 9th

SATURDAY, APRIL 9 - BLOOMFIELD – Search Engine Optimization Workshop with Joanne Marcinek

Sponsored by The Center for Holistic Empowerment and The Door Opener Magazine

Boost web traffic with search engine optimization! Improve Web traffic and search engine ranking. Do you want more web traffic? Improving search engine ranking will do just that! If you already have web presence, discover the key steps required to boost your rankings without paid advertising. You’ll learn how to: find quality keywords for your business; choose the right keywords for each page of your site; properly position keywords to optimize your site; submit your site to the “big 3″ search engines and important directories; continually improve search engine visibility. Use savvy SEO methods to build the web presence you desire.


Joanne Marcinek of Ask Joanne, LLC, is a woman on a mission: translating techno-babble into straightforward, understandable language and steps that web site owners and bloggers can easily implement. She has been working with the internet since 1992, and began developing websites in 1999 and optimizing them in 2003. Ask Joanne, LLC helps clients implement complete, frugal and effective internet marketing plans that hit the mark.


Visit TheCenterforHolisticEmpowerment for more info. Held at 3 Barnard Lane, Top Floor (enter through rear of building). Register with The Door Opener at thedooropener@comcast.net or (860) 693-2840.
Time: 10 am to 1 pm. Cost: $30

Posted in SEO, Training, Uncategorized | Tagged , , | Leave a comment

Search Engine Marketing Issues: by Jill Whalen

++Some Farm Aid for the Afflicted++

By now you’ve surely heard of the recent Google algorithm changes dubbed the “Farmer Update.”

According to Google, about 12% of search queries were impacted by this update. The SISTRIX blog  provided additional insight by posting the top 25 websites that overnight stopped showing up in Google for numerous keywords. I was interested in learning Photo Credit: aechempatimore about this update, and SISTRIX was kind enough to share their big list of over 300 sites that have had deep traffic losses. In addition, I’ve had various people send me their sites to look at.

I hoped to analyze the data to spot similarities between the sites that got hit so that I could understand the specific factors Google used when deciding which pages to nuke. As you can imagine, there was a lot of data to sort through and I feel as if I’ve only just gotten started. However, I do have some preliminary findings to share with you as quickly as possible.

Please note that just because I noticed similar things on sites that got hit, it doesn’t mean those things were the cause of the loss of Google traffic. It’s far too easy to make assumptions and mix up cause and effect in nearly every aspect of SEO. So I caution you to treat the information I’m providing as what it is — preliminary findings that make me go “Hmmm.” Also note that I’ve barely had enough time to look at the potential on-page factors that might be causing issues, and haven’t even started to look at the off-page links that are pointing to these sites. Because we know that links and anchor text are Google’s main squeeze, my on-page analysis could very well be completely off base.

With that caveat out of the way, below are some of the interesting things I noticed that made me go hmmm…with the small set of sites I’ve looked at so far.

Semi-hidden Content

One surprise finding, which may or may not relate to the loss of Google traffic, was that many of the sites had content that was behind tabs, and not visible all at once to someone using a typical browser. It’s possible that this type of design element is so common on websites these days that many sites from a random sampling would also be using it, but it definitely struck me as odd. What made it especially interesting was that most of the sites using the tabs had a very large amount of content contained within them. With tabs such as these, a person only sees the content in one tab at a time, while Google sees all the content from all of the tabs, as if it were contained on one page. (Technically it is, because it’s all one URL.) In many cases all the tabbed content put together added up to thousands of words, and often hundreds of links as well.

While there’s nothing inherently wrong with using tabs this way (and many sites are currently using the technique), some cases might trigger red flags.

There are many different coding methods to “hide” content behind tabs. The code on two of the sites I reviewed that had lost Google traffic were using different methods. One had this code: “display: none; visibility: hidden;” and the other had this: “overflow: hidden;”.

Why Google might not like it: Each site was using their tabs for different reasons, and I doubt that the “visibility: hidden” in and of itself caused Google to no longer like those pages. But perhaps Google took issue with the extremely long pages of content because they might appear to be less user-friendly (if Google didn’t realize that the content is tabbed). In addition, the numerous extra links in some of the tabs might appear to go overboard.

In one instance, I set my default browser to Googlebot and tried to browse a page that was using tabs with tons of content behind them, but I got an error message that the page couldn’t be viewed at all. The error seemed to have something to do with a very strange, hidden ad link contained in the tabbed content.

In another case of semi-hidden content, the pages were designed in a way that is very cool and easy to use for people, but all the content from the various hidden areas, when viewed on one long page as Google saw it, ends up looking like a disgusting keyword-stuffed mess! I have no idea if the site was purposely designed to stuff keywords in that way or not, but before the Farmer Update it was apparently working for them.

Completely Hidden Content

Another common finding between some of the sites I reviewed was having the real “meat” of the site behind a registration wall. While there would be some keyword-rich content on the page in question, you couldn’t read the whole article unless you registered for it. Google has never been a fan of that, and even offers their “First Click Free” program so that content publishers who require registration to read their articles can still get their content indexed. But the site must show the entire piece of content to people who have not registered if they got to it from a Google search. The sites I reviewed were not using the First Click Free approach.

Why Google might not like it: They believe that if you want your content indexed, you should play by their rules, which in this case is the First Click Free rule. They probably also believe that a page with just a summary of information related to the searcher’s query is likely not the best page for the user to land on. So it doesn’t surprise me that those types of pages may have been hit in the Farmer Update.

Merry-Go-Round Sites Containing Mostly Ads or Links

Interestingly, I recognized one of the sites on the big SITRIX list as one I had done a website review for last year. I have to say that it was one of the craziest sites I had ever seen, and I was shocked that Google was even showing it highly in the search results. So when I saw it got nuked bigtime by Farmer Google, I wasn’t surprised. I noticed some similarities between that site and a few of the others that got nailed — mostly that you felt you were going round and round in circles as you tried to find the information you were originally seeking at Google.

Here’s what happens on this type of site: You get to a page that uses the keywords you typed into Google, only to find that you need to click a link on that page to really get the information. But when you click that page, you either end up at another site, or on another page on the same site — and you still don’t quite have the info you wanted. It seems that you could keep clicking that way forever and never find what you were looking for. Yet you always have the feeling it is you doing something wrong, not that the site simply sucks wind. (Of course, the pages are also always full of Google AdSense and other ads.)

Similar to the merry-go-round sites, others I reviewed were simply aggregating others’ content in one way or another. In many cases, it would make more sense for Google to just show the original site (or sites) rather than a page with a list of sites — especially when the list of links is actually just running an ad platform that appears to be links.

One site was a niche comparison site, which seemed okay on the surface. But I found that when I browsed to a particular product and then tried to view it on the website that was listed as the cheapest, in many cases I was brought to either the home page of said site or a page that contained a product similar to the one I was looking at, but not the exact one. Ugh.

Why Google might not like it: Google stated that part of this update was to improve the quality of the results their searchers were receiving. All of the above types of sites have numerous pages that meet the “poor quality” label, assuming anyone ever paid attention. In these cases, I can see where it makes more sense for Google to show the pages being linked to directly in their search results, rather than the page that’s doing the linking.

So there you have it — my first impressions from a very small sample of sites.

What You Should Watch Out For

With everything I’ve seen, the consistent themes seem to be usability and the intent of the page in question. I can’t say how Google is technically figuring out intent, but they appear to be going after pages that might frustrate users. Google’s goal is to satisfy the search query of their user — the searcher. Their goal is not to provide their searcher with pages that link to the pages, that link to the other pages, that satisfy the original search.

With all that said, after writing up my findings, I also looked at some of the new Google results, and, sadly, there are some even worse pages that show! In one case, the site I was reviewing, while not satisfying the search query itself (other than having the search words on the page), was beat out by a pathetic little made-for-AdSense site that had no redeeming qualities whatsoever. How that one survived the Farmer Update, I’ll never know.

It’s key to remember that this update is most likely just the beginning. About the only thing I’m sure of at the moment is that Google still has a lot of tweaking to do over the next few months to truly sort things out.

Jill

Jill Whalen is the CEO of High Rankings, an SEO Consulting company in the Boston, MA area since 1995. Follow her on Twitter @JillWhalenJill Whalen

(reprinted with permission)
Posted in SEO | Tagged , , , | Leave a comment

SEO Consultants Are Not the Enemy!

SEOs have been getting a bad rap for a long time. Unfortunately, in many cases, their bad reputation has been well deserved. When a client hires an outside SEO consultant during the design and development of a new website, it’s often not looked upon kindly by the development team. Chances are the team has had bad experiences with an SEO who forced them to design for search engines and not for people.

Who wouldn’t be upset by that? Search engines don’t buy products. They don’t sign up for newsletters, and they don’t tell their friends about your great company.
If that’s what any SEO consultant tries to do, it is wrong. More than that, it isn’t SEO. It is pseudo SEO that is implemented when there’s not enough budget to do things correctly. 

Get that type of SEO out of your head.

Real SEOs Understand Usability

But don’t be fooled into thinking that their SEO recommendations are just for the search engines. Nearly anything that’s implemented for better visibility in search engines, when done correctly, also enhances the website for users as well. But it does take a lot more work, which means you’re also going to have to spend more money.

Remember, while Google’s own user interface may be evolving rapidly, the crawler and indexing components are still very much like old web browsers. Crawlers can’t easily use the search boxes on your website to find information and products hidden in your database. They need obvious links that point to web pages that showcase the content that sits in your database. They also can’t see or index content contained in images. And while they can extract some information from Flash, in practice, it might as well be invisible.

Guess what else behaves like an older web browser? Screen readers meant for people with low vision or other disabilities that impede their ability to surf the web through traditional browsers.

Know what else? Ironically, many mobile browsers (which should be on the cutting-edge) can act in an old-fashioned way – iPhones don’t see Flash at all! And some cell phone browsers make it difficult to navigate around a site that only has search boxes. On slow mobile connections (can you say “Edge Network”?), images may not even show up. In all of these cases, if SEO and usability best practices have been put into place, the visitor experience is much simpler and better all around. Clearly, it’s a lot easier to click links when you’re browsing a website from your phone rather than it is to try to figure out the various configurations of some e-commerce site search boxes.

SEO Creates Better User Experiences

Whether you care if your website is search engine friendly or not (and you ought to care!), it should never be designed so that the only way to get around is via search boxes. It’s nothing short of poor usability. Your target market is composed of different types of people who are likely to find what they’re looking for in different ways. Providing alternate forms of navigation helps everyone (including search engines) find exactly what they’re looking for.

The next time your SEO consultant recommends something that you don’t think is necessary, ask them why it should be that way. If they mention that it will be better for both search engines and site visitors (and can explain why), then you can rest assured that they are not your enemy or trying to sabotage your beautiful website. They have the best interests of everyone in mind at all times.

Jill 

Jill Whalen is the CEO of High Rankings, an SEO Consulting company in the Boston, MA area since 1995. Follow her on Twitter @JillWhalen
Reposted with permission.
Posted in SEO | Leave a comment

Convert HTML to PDF

Looking for a free and easy way to convert HTML pages to PDF documents? Check out PDFCrowd. It also integrates with a Google Chrome Extension to send web pages to Google Docs.

Posted in Tools | Leave a comment

Social Media Strategies: Staying Connected Without Feeling Chained to Your Computer

THE DOOR OPENER MAGAZINE PRESENTS:
Social Media Strategies: Staying Connected Without Feeling Chained to Your Computer

Saturday, December 11, 2010
10 a.m. to 1 p.m. ~ $30
Held at Center for Holistic Empowerment, 3 Barnard Lane – top floor, Bloomfield, CT

GO FOR THE GOLD!
Folks who attended our Business Skills Enhancement Days specifically requested a training dedicated to Social Media only.

We are happy to bring that to you!!
MAKE IT HAPPPEN!

Do you have goals for your business in 2011? Would you like to develop some new marketing strategies? How are your skills in:
Facebook
Twitter
LinkedIn

DON’T HESITATE!

Our presenter will demonstrate much needed info on a big screen LIVE right from her computer! You can see the exact steps to take!

Become confident, connected, and successful!!

Are you timid when it comes to Social Media, but you see everyone else connected and seemingly proficient? This is one of the most powerful marketing tools to come along in a long time. Do you feel the nudge to finally get started?

JOANNE MARCINEK OF ASK JOANNE, LLC has been connected with The Door Opener for many years and we continue to be impressed with her knowledge base and unique ability to bring difficult concepts down to plain language for simple understanding. This is something we definitely need in the area of technology.

Join us on December 11 for a three-hour session of training on these and more:
- learn the difference between a personal and business account
- how to set up an account
- how to post and include a photo or link
- how to link Facebook to Twitter and Linked-In
- and so much more!

Bring your questions. In the meantime, please visit Joanne’s website to see how she can help you and your business, and to get a preview of her extensive knowledge and expertise! Visit www.askjoanne.com

Register through Dory Dzinski at The Door Opener at (860) 693-2840 or through thedooropener@comcast.net We look forward to seeing you there!!!

Posted in Social Media | Leave a comment

More Pictures on Your Google Places (Maps) page

Google LatLong: For your viewing pleasure: a new and improved way to explore online photos:

When you’re curious about a new place – be it a restaurant that you haven’t yet tried or a popular tourist attraction you’re considering visiting on an upcoming trip – you may find it useful to see what that place looks like in advance. For this reason, Place pages make it possible to visually explore various locations by aggregating and displaying photos from around the web.

Today, we’re offering you a better, more streamlined way to view these photos. With this new feature, you can easily flip through a whole collection of photos and find the sites on the web that have relevant pictures of a given place. Photos that have been uploaded by our Panoramio or Google Places users will appear in high-resolution as an overlay when users click on them. For photos from other sources, you can easily click on a specific photo to see more and visit the site it comes from.”

Posted in Google | Leave a comment