Tuesday, March 3, 2015

How Google Pulls Structured Snippets from Websites' Tables

Posted by billslawski

An article that came out at the beginning of 2015 was intended to (quietly) let people know about what Google had been doing to offer a new form of search results called Table Search. The article was titled Applying WebTables in Practice (pdf).

It tells us about an initiative that Google's structured data team embarked upon, when they started the WebTables project in the second half of the 2000s, which involved them releasing the following paper:

WebTables: Exploring the Power of Tables on the Web (pdf)

It got some nice press in the paper Structured Data on the Web (pdf).

What is Table Search?

There are many pages on the Web that are filled with data in the form of tables. It's possible that if you weren't paying attention you may have missed Google Table Search entirely—it hasn't gotten a lot of press as far as I can tell. If you include tabular data on the pages of your site, though, you may be able to find tables from your site included in the results from a query in Google Table Search.

Imagine that I am looking to buy a new camera lens, except I'm not sure which one to purchase. I've heard good things about Nikon lenses, so I go to Table Search and look for [ single lens dslr nikon]. The first table returned gives me some choices to compare different lenses:

54ee2f4a4fa809.31701150.jpg

Table Search and structured snippets

One of the interesting things to grow out of Table Search capability from Google is the structured snippet, a search result that is a combination of query results and tabular data results, as described by Google in their blog post Introducing Structured Snippets, now a part of Google Web Search.

For example, this result involving a search for [superman] includes facts from a Wikipedia table about the character:

54f0c3048173c5.27232995.jpg

Those extra facts come from the table associated with a query on Superman that shows tabular data about the character:

54f0c33940aba2.23746399.jpg

We can see Google working in structured snippets elsewhere, e.g., in presenting snippets from Twitter, like from the following profile:

54f0c979c14ae7.95271653.jpg

A search for Rand shows the following (h/t to Barbara Starr for this example of a structured snippet):

54f0c5345b4942.37671661.jpg

Note how Google is taking structured data (highlighted in yellow) from the Twitter profile and including it in the Google search result from the Twitter profile "about Rand". That data may also be from Twitter's API of data that they feed to Google. I have noticed that when there are multiple Twitter accounts for the same name, this kind of table data doesn't appear in the Google snippet.

Getting your structured snippets

The Applying Webtables in Practice paper has some suggestions on how to create tables that might be sources of structured data that Google might use:

  1. Limit the amount of boilerplate content that appears in a table
  2. Use table headings <th> to add labels to the columns they head—this tells Google that they are filled with important data
  3. Use meaningful attribute names in table headings that make it more likely the tables might appear and rank for a relevant query
  4. Use meaningful titles, captions and semantically related text surrounding the table. These can help the search engine better understand what the table is about.
  5. The ranking of tables in Table Search can be influenced by Web ranking features such as The PageRank of a page a table is on and links pointed to that page.

If you decide to use tables on your pages, following these hints from the "Applying WebTables in Practice" paper may help lead to structured snippets showing up in your search results. The inclusion of that data may convince searchers to click through to your pages. A data-rich search result that addresses their informational and situational needs may be persuasive enough to get them to visit you. And the snippet is attached to a link to your page, so your page gets credit for the data.


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Monday, March 2, 2015

Local Centroids are Now Individual Users: How Can We Optimize for Their Searches?

Posted by MiriamEllis

"Google is getting better at detecting location at a more granular level—even on the desktop. The user is the new centroid." - David Mihm

The history of the centroid

The above quote succinctly summarizes the current state of affairs for local business owners and their customers. The concept of a centroid— a central point of relevance—is almost as old as local search. In 2008, people like Mike Blumenthal and Google Maps Manager Carter Maslan were sharing statistics like this:

"...research indicates that up to 80% of the variation in rank can be explained by distance from the centroid on certain searches."

At that time, businesses located near town hall or a similar central hub appeared to be experiencing a ranking advantage.

Fast forward to 2013, and Mike weighed in again with an updated definition of "industry centroids",

"If you read their (Google’s) patents, they actually deal with the center of the industries … as defining the center of the search. So if all the lawyers are on the corner of Main and State, that typically defines the center of the search, rather than the center of the city… it isn’t even the centroid of the city that matters. It matters that you are near where the other people in your industry are."

In other words, Google's perception of a centralized location for auto dealerships could be completely different than that for medical practices, and that neither might be located anywhere near the city center.

While the concepts of city and industry centroids may still play a part in some searches, local search results in 2015 clearly indicate Google's shift toward deeming the physical location of the desktop or mobile user a powerful factor in determining relevance. The relationship between where your customer is when he performs a search and where your business is physically located has never been more important.

Moreover, in this new, user-centric environment, Google has moved beyond simply detecting cities to detecting neighborhoods and even streets. What this means for local business owners is that your hyperlocal information has become a powerful component of your business data. This post will teach you how to better serve your most local customers.

Seeing the centroid in action

If you do business in a small town with few competitors, ranking for your product/service + city terms is likely to cover most of your bases. The user-as-centroid phenomenon is most applicable in mid-to-large sized towns and cities with reasonable competition. I'll be using two districts in San Francisco—Bernal Heights and North Beach—in these illustrations and we'll be going on a hunt for pizza.

On a desktop, searching for "pizza north beach san francisco" or setting my location to this neighborhood and city while searching for the product, Google will show me something like this:

local result north beach pizza san francisco

Performing this same search, but with "bernal heights" substituted, Google shows me pizzerias in a completely different part of the city:

local result bernal heights pizza san francisco

And, when I move over to my mobile device, Google narrows the initial results down to just three enviable players in each district. These simple illustrations demonstrate Google's increasing sensitivity to serving me nearby businesses offering what I want.

The physical address of your business is the most important factor in serving the user as centroid. This isn’t something you can control, but there are things you can do to market your business as being highly relevant to your hyperlocal geography.

Specialized content for the user-centroid

We'll break this down into four common business models to help get you thinking about planning content that serves your most local customers.

1. Single-location business

Make the shift toward viewing your business not just as "Tony's Pizza in San Francisco", but as "Tony's Pizza in North Beach, San Francisco". Consider:

  • Improving core pages of your website or creating new pages to include references to the proud part you play in the neighborhood scene. Talk about the history of your area and where you fit into that.
  • Interview locals and ask them to share their memories about the neighborhood and what they like about living there.
  • Showcase your participation in local events.
  • Plan an event, contest or special for customers in your district.
  • Take pictures, label them with hyperlocal terms, post them on your site and share them socially.
  • Blog about local happenings that are relevant to you and your customers, such as a street market where you buy the tomatoes that top your pizzas or a local award you've won.
  • Depending on your industry, there will be opportunities for hyperlocal content specific to your business. For example, a restaurant can make sure its menu is in crawlable text and can name some favorite dishes after the neighborhood—The Bernal Heights Special. Meanwhile, a spa in North Beach can create a hyperlocal name for a service—The North Beach Organic Spa Package. Not only does this show district pride, but customers may mention these products and services by name in their reviews, reinforcing your local connection.

2. Multi-location business within a single city

All that applies to the single location applies to you, too, but you've got to find a way to scale building out content for each neighborhood.

  • If your resources are strong, build a local landing page for each of your locations, including basic optimization for the neighborhood name. Meanwhile, create blog categories for each neighborhood and rotate your efforts on a week by week basis. First week, blog about neighborhood A, next week, find something interesting to write about concerning neighborhood B. Over time, you'll have developed a nice body of content proving your involvement in each district.
  • If you're short on resources, you'll still want to build out a basic landing page for each of your stores in your city and make the very best effort you can to showcase your neighborhood pride on these pages.

3. Multiple businesses, multiple cities

Again, scaling this is going to be key and how much you can do will depend upon your resources.

  • The minimum requirement will be a landing page on the site for each physical location, with basic optimization for your neighborhood terms.
  • Beyond this, you'll be making a decision about how much hyperlocal content you can add to the site/blog for each district, or whether time can be utilized more effectively via off-site social outreach. If you've got lots of neighborhoods to cover in lots of different cities, designating a social representative for each store and giving him the keys to your profiles (after a training session in company policies) may make the most sense.

4. Service area businesses (SABs)

Very often, service area businesses are left out in the cold with various local developments, but in my own limited testing, Google is applying at least some hyperlocal care to these business models. I can search for a neighborhood plumber, just as I would a pizza:

local results plumber bernal heights san francisco

To be painstakingly honest, plumbers are going to have to be pretty ingenious to come up with a ton of engaging industry/neighborhood content and may be confined mainly to creating some decent service area landing pages that share a bit about their work in various neighborhoods. Other business models, like contractors, home staging firms and caterers should find it quite easy to talk about district architecture, curb appeal and events on a hyperlocal front.

While your SAB is still unlikely to beat out a competitor with a physical location in a given neighborhood, you still have a chance to associate your business with that area of your town with well-planned content.

Need creative inspiration for the writing projects ahead? Don't miss this awesome wildcard search tip Mary Bowling shared at LocalUp. Add an underscore or asterisk to your search terms and just look at the good stuff Google will suggest to you:

wildcard search content ideas

Does Tony's patio make his business one of Bernal Heights' dog-friendly restaurants or does his rooftop view make his restaurant the most picturesque lunch spot in the district? If so, he's got two new topics to write about, either on his basic landing pages or his blog.

Hop over to Whitespark’s favorite takeaways from Mike Ramsey’s LocalUp presentation, too.

Citations and reviews with the user centroid in mind

Here are the basics about citations, broken into the same four business models:

1. Single-location business

You get just one citation on each platform, unless you have multiple departments or practitioners. That means one Google+ Local page, one Yelp profile, one Best of the Web listing. etc. You do not get one citation for your city and another for your neighborhood. Very simple.

2. Multi-location business within a single city

As with the single location business, you are entitled to just one set of citations per physical location. That means one Google+ Local listing for your North Beach pizza place and another for your restaurant in Bernal Heights.

A regular FAQ here in the Moz Q&A Forum relates to how Google will differentiate between two businesses located in the same city. Here are some tips:

  • Google no longer supports the use of modifiers in the business name field, so you can no longer be Tony's Pizza - Bernal Heights, unless your restaurant is actually named this. You can only be Tony's Pizza.
  • Facebook's policies are different than Google's. To my understanding, Facebook won't permit you to build more than one Facebook Place for the identical brand name. Thus, to comply with their guidelines, you must differentiate by using those neighborhood names or other modifiers. Given that this same rule applies to all of your competitors, this should not be seen as a danger to your NAP consistency, because apparently, no multi-location business creating Facebook Places will have 100% consistent NAP. The playing field is, then, even.
  • The correct place to differentiate your businesses on all other platforms is in the address field. Google will understand that one of your branches is on A St. and the other is on B St. and will choose which one they feel is most relevant to the user.
  • Google is not a fan of call centers. Unless it's absolutely impossible to do so, use a unique local phone number for each physical location to prevent mix-ups on Google's part, and use this number consistently across all web-based mentions of the business.
  • Though you can't put your neighborhood name in the title, you can definitely include it in the business description field most citation platforms provide.
  • Link your citations to their respective local landing pages on your website, not to your homepage.

3. Multiple businesses, multiple cities

Everything in business model #2 applies to you as well. You are allowed one set of citations for each of your physical locations, and while you can't modify your Google+ Local business name, you can mention your neighborhood in the description. Promote each location equally in all you do and then rely on Google to separate your locations for various users based on your addresses and phone numbers.

4. SABs

You are exactly like business model #1 when it comes to citations, with the exception of needing to abide by Google's rules about hiding your address if you don't serve customers at your place of business. Don't build out additional citations for neighborhoods you serve, other cities you serve or various service offerings. Just create one citation set. You should be fine mentioning some neighborhoods in your citation descriptions, but don't go overboard on this.

When it comes to review management, you'll be managing unique sets of reviews for each of your physical locations. One method for preventing business owner burnout is to manage each location in rotation. One week, tend to owner responses for Business A. Do Business B the following week. In week three, ask for some reviews for Business A and do the same for B in week four. Vary the tasks and take your time unless faced with a sudden reputation crisis.

You can take some additional steps to "hyperlocalize" your review profiles:

  • Write about your neighborhood in the business description on your profile.
  • You can't compel random customers to mention your neighborhood, but you can certainly do so from time to time when your write responses. "We've just installed the first soda fountain Bernal Heights has seen since 1959. Come have a cool drink on us this summer."
  • Offer a neighborhood special to people who bring in a piece of mail with their address on it. Prepare a little handout for all-comers, highlighting a couple of review profiles where you'd love to hear how they liked the Bernal Heights special. Or, gather email addresses if possible and follow up via email shortly after the time of service.
  • If your business model is one that permits you to name your goods or service packages, don’t forget the tip mentioned earlier about thinking hyperlocal when brainstorming names. Pretty cool if you can get your customers talking about how your "North Beach Artichoke Pizza" is the best pie in town!

Investigate your social-hyperlocal opportunties

I still consider website-based content publication to be more than half the battle in ranking locally, but sometimes, real-time social outreach can accomplish things static articles or scheduled blog posts can’t. The amount of effort you invest in social outreach should be based on your resources and an assessment of how naturally your industry lends itself to socialization. Fire insurance salesmen are going to find it harder to light up their neighborhood community than yoga studios will. Consider your options:

Remember that you are investigating each opportunity to see how it stacks up not just to promoting your location in your city, but in your neighborhood.

Who are the people in your neighborhood?

Remember that Sesame Street jingle? It hails from a time when urban dwellers strongly identified with a certain district of hometown. People were "from the neighborhood." If my grandfather was a Mission District fella, maybe yours was from Chinatown. Now, we’re shifting in fascinating directions. Even as we've settled into telecommuting to jobs in distant states or countries, Amazon is offering one hour home delivery to our neighbors in Manhattan. Doctors are making house calls again! Any day now, I’m expecting a milkman to start making his rounds around here. Commerce has stretched to span the globe and now it's zooming in to meet the needs of the family next door.

If the big guys are setting their sights on near-instant services within your community, take note. You live in that community. You talk, face-to-face, with your neighbors every day and know the flavor of the local scene better than any remote competitor can right now.

Now is the time to reinvigorate that old neighborhood pride in the way you’re visualizing your business, marketing it and personally communicating to customers that you’re right there for them.


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

The 29 Most Common Social Media Rules: Which Ones Are Real? Which Ones Are Breakable?

How did you end up learning the unwritten rules for social media etiquette?

For me, it was a lot of watching and waiting, a bit of experimenting, and tons of trial and error. When I first started out on social media, I had just the most basic rules and intuitions. Even now, I feel like I learn a new quirk or quibble on a near-daily basis.

It’s hard to know which rules exist, which ones are real, and which ones are okay to ...

The post The 29 Most Common Social Media Rules: Which Ones Are Real? Which Ones Are Breakable? appeared first on Social.

Mastering Serving the User as Centroid to Reach Local Searchers

Posted by MiriamEllis

"Google is getting better at detecting location at a more granular level—even on the desktop. The user is the new centroid." - David Mihm

The history of the centroid

The above quote succinctly summarizes the current state of affairs for local business owners and their customers. The concept of a centroid— a central point of relevance—is almost as old as local search. In 2008, people like Mike Blumenthal and Google Maps Manager Carter Maslan were sharing statistics like this:

"...research indicates that up to 80% of the variation in rank can be explained by distance from the centroid on certain searches."

At that time, businesses located near town hall or a similar central hub appeared to be experiencing a ranking advantage.

Fast forward to 2013, and Mike weighed in again with an updated definition of "industry centroids",

"If you read their (Google’s) patents, they actually deal with the center of the industries … as defining the center of the search. So if all the lawyers are on the corner of Main and State, that typically defines the center of the search, rather than the center of the city… it isn’t even the centroid of the city that matters. It matters that you are near where the other people in your industry are."

In other words, Google's perception of a centralized location for auto dealerships could be completely different than that for medical practices, and that neither might be located anywhere near the city center.

While the concepts of city and industry centroids may still play a part in some searches, local search results in 2015 clearly indicate Google's shift toward deeming the physical location of the desktop or mobile user a powerful factor in determining relevance. The relationship between where your customer is when he performs a search and where your business is physically located has never been more important.

Moreover, in this new, user-centric environment, Google has moved beyond simply detecting cities to detecting neighborhoods and even streets. What this means for local business owners is that your hyperlocal information has become a powerful component of your business data. This post will teach you how to better serve your most local customers.

Seeing the centroid in action

If you do business in a small town with few competitors, ranking for your product/service + city terms is likely to cover most of your bases. The user-as-centroid phenomenon is most applicable in mid-to-large sized towns and cities with reasonable competition. I'll be using two districts in San Francisco—Bernal Heights and North Beach—in these illustrations and we'll be going on a hunt for pizza.

On a desktop, searching for "pizza north beach san francisco" or setting my location to this neighborhood and city while searching for the product, Google will show me something like this:

local result north beach pizza san francisco

Performing this same search, but with "bernal heights" substituted, Google shows me pizzerias in a completely different part of the city:

local result bernal heights pizza san francisco

And, when I move over to my mobile device, Google narrows the initial results down to just three enviable players in each district. These simple illustrations demonstrate Google's increasing sensitivity to serving me nearby businesses offering what I want.

The physical address of your business is the most important factor in serving the user as centroid. This isn’t something you can control, but there are things you can do to market your business as being highly relevant to your hyperlocal geography.

Specialized content for the user-centroid

We'll break this down into four common business models to help get you thinking about planning content that serves your most local customers.

1. Single-location business

Make the shift toward viewing your business not just as "Tony's Pizza in San Francisco", but as "Tony's Pizza in North Beach, San Francisco". Consider:

  • Improving core pages of your website or creating new pages to include references to the proud part you play in the neighborhood scene. Talk about the history of your area and where you fit into that.
  • Interview locals and ask them to share their memories about the neighborhood and what they like about living there.
  • Showcase your participation in local events.
  • Plan an event, contest or special for customers in your district.
  • Take pictures, label them with hyperlocal terms, post them on your site and share them socially.
  • Blog about local happenings that are relevant to you and your customers, such as a street market where you buy the tomatoes that top your pizzas or a local award you've won.
  • Depending on your industry, there will be opportunities for hyperlocal content specific to your business. For example, a restaurant can make sure its menu is in crawlable text and can name some favorite dishes after the neighborhood—The Bernal Heights Special. Meanwhile, a spa in North Beach can create a hyperlocal name for a service—The North Beach Organic Spa Package. Not only does this show district pride, but customers may mention these products and services by name in their reviews, reinforcing your local connection.

2. Multi-location business within a single city

All that applies to the single location applies to you, too, but you've got to find a way to scale building out content for each neighborhood.

  • If your resources are strong, build a local landing page for each of your locations, including basic optimization for the neighborhood name. Meanwhile, create blog categories for each neighborhood and rotate your efforts on a week by week basis. First week, blog about neighborhood A, next week, find something interesting to write about concerning neighborhood B. Over time, you'll have developed a nice body of content proving your involvement in each district.
  • If you're short on resources, you'll still want to build out a basic landing page for each of your stores in your city and make the very best effort you can to showcase your neighborhood pride on these pages.

3. Multiple businesses, multiple cities

Again, scaling this is going to be key and how much you can do will depend upon your resources.

  • The minimum requirement will be a landing page on the site for each physical location, with basic optimization for your neighborhood terms.
  • Beyond this, you'll be making a decision about how much hyperlocal content you can add to the site/blog for each district, or whether time can be utilized more effectively via off-site social outreach. If you've got lots of neighborhoods to cover in lots of different cities, designating a social representative for each store and giving him the keys to your profiles (after a training session in company policies) may make the most sense.

4. Service area businesses (SABs)

Very often, service area businesses are left out in the cold with various local developments, but in my own limited testing, Google is applying at least some hyperlocal care to these business models. I can search for a neighborhood plumber, just as I would a pizza:

local results plumber bernal heights san francisco

To be painstakingly honest, plumbers are going to have to be pretty ingenious to come up with a ton of engaging industry/neighborhood content and may be confined mainly to creating some decent service area landing pages that share a bit about their work in various neighborhoods. Other business models, like contractors, home staging firms and caterers should find it quite easy to talk about district architecture, curb appeal and events on a hyperlocal front.

While your SAB is still unlikely to beat out a competitor with a physical location in a given neighborhood, you still have a chance to associate your business with that area of your town with well-planned content.

Need creative inspiration for the writing projects ahead? Don't miss this awesome wildcard search tip Mary Bowling shared at LocalUp. Add an underscore or asterisk to your search terms and just look at the good stuff Google will suggest to you:

wildcard search content ideas

Does Tony's patio make his business one of Bernal Heights' dog-friendly restaurants or does his rooftop view make his restaurant the most picturesque lunch spot in the district? If so, he's got two new topics to write about, either on his basic landing pages or his blog.

Hop over to Whitespark’s favorite takeaways from Mike Ramsey’s LocalUp presentation, too.

Citations and reviews with the user centroid in mind

Here are the basics about citations, broken into the same four business models:

1. Single-location business

You get just one citation on each platform, unless you have multiple departments or practitioners. That means one Google+ Local page, one Yelp profile, one Best of the Web listing. etc. You do not get one citation for your city and another for your neighborhood. Very simple.

2. Multi-location business within a single city

As with the single location business, you are entitled to just one set of citations per physical location. That means one Google+ Local listing for your North Beach pizza place and another for your restaurant in Bernal Heights.

A regular FAQ here in the Moz Q&A Forum relates to how Google will differentiate between two businesses located in the same city. Here are some tips:

  • Google no longer supports the use of modifiers in the business name field, so you can no longer be Tony's Pizza - Bernal Heights, unless your restaurant is actually named this. You can only be Tony's Pizza.
  • Facebook's policies are different than Google's. To my understanding, Facebook won't permit you to build more than one Facebook Place for the identical brand name. Thus, to comply with their guidelines, you must differentiate by using those neighborhood names or other modifiers. Given that this same rule applies to all of your competitors, this should not be seen as a danger to your NAP consistency, because apparently, no multi-location business creating Facebook Places will have 100% consistent NAP. The playing field is, then, even.
  • The correct place to differentiate your businesses on all other platforms is in the address field. Google will understand that one of your branches is on A St. and the other is on B St. and will choose which one they feel is most relevant to the user.
  • Google is not a fan of call centers. Unless it's absolutely impossible to do so, use a unique local phone number for each physical location to prevent mix-ups on Google's part, and use this number consistently across all web-based mentions of the business.
  • Though you can't put your neighborhood name in the title, you can definitely include it in the business description field most citation platforms provide.
  • Link your citations to their respective local landing pages on your website, not to your homepage.

3. Multiple businesses, multiple cities

Everything in business model #2 applies to you as well. You are allowed one set of citations for each of your physical locations, and while you can't modify your Google+ Local business name, you can mention your neighborhood in the description. Promote each location equally in all you do and then rely on Google to separate your locations for various users based on your addresses and phone numbers.

4. SABs

You are exactly like business model #1 when it comes to citations, with the exception of needing to abide by Google's rules about hiding your address if you don't serve customers at your place of business. Don't build out additional citations for neighborhoods you serve, other cities you serve or various service offerings. Just create one citation set. You should be fine mentioning some neighborhoods in your citation descriptions, but don't go overboard on this.

When it comes to review management, you'll be managing unique sets of reviews for each of your physical locations. One method for preventing business owner burnout is to manage each location in rotation. One week, tend to owner responses for Business A. Do Business B the following week. In week three, ask for some reviews for Business A and do the same for B in week four. Vary the tasks and take your time unless faced with a sudden reputation crisis.

You can take some additional steps to "hyperlocalize" your review profiles:

  • Write about your neighborhood in the business description on your profile.
  • You can't compel random customers to mention your neighborhood, but you can certainly do so from time to time when your write responses. "We've just installed the first soda fountain Bernal Heights has seen since 1959. Come have a cool drink on us this summer."
  • Offer a neighborhood special to people who bring in a piece of mail with their address on it. Prepare a little handout for all-comers, highlighting a couple of review profiles where you'd love to hear how they liked the Bernal Heights special. Or, gather email addresses if possible and follow up via email shortly after the time of service.
  • If your business model is one that permits you to name your goods or service packages, don’t forget the tip mentioned earlier about thinking hyperlocal when brainstorming names. Pretty cool if you can get your customers talking about how your "North Beach Artichoke Pizza" is the best pie in town!

Investigate your social-hyperlocal opportunties

I still consider website-based content publication to be more than half the battle in ranking locally, but sometimes, real-time social outreach can accomplish things static articles or scheduled blog posts can’t. The amount of effort you invest in social outreach should be based on your resources and an assessment of how naturally your industry lends itself to socialization. Fire insurance salesmen are going to find it harder to light up their neighborhood community than yoga studios will. Consider your options:

Remember that you are investigating each opportunity to see how it stacks up not just to promoting your location in your city, but in your neighborhood.

Who are the people in your neighborhood?

Remember that Sesame Street jingle? It hails from a time when urban dwellers strongly identified with a certain district of hometown. People were "from the neighborhood." If my grandfather was a Mission District fella, maybe yours was from Chinatown. Now, we’re shifting in fascinating directions. Even as we've settled into telecommuting to jobs in distant states or countries, Amazon is offering one hour home delivery to our neighbors in Manhattan. Doctors are making house calls again! Any day now, I’m expecting a milkman to start making his rounds around here. Commerce has stretched to span the globe and now it's zooming in to meet the needs of the family next door.

If the big guys are setting their sights on near-instant services within your community, take note. You live in that community. You talk, face-to-face, with your neighbors every day and know the flavor of the local scene better than any remote competitor can right now.

Now is the time to reinvigorate that old neighborhood pride in the way you’re visualizing your business, marketing it and personally communicating to customers that you’re right there for them.


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Sunday, March 1, 2015

Toronto budget fight over new city staff positions


Mayor John Tory's executive committee is expected to debate Monday a proposal to reject requests for 16 new city staff positions.

Friday, February 27, 2015

Concrete that hit minivan ‘likely’ fell from Gardiner Expressway

Public works officials are still investigating the concrete that smashed a minivan’s windshield at Lower Spadina and Lake Shore on Tuesday.

My Favorite 5 Analytics Dashboards - Whiteboard Friday

Posted by KitsapKing

Finding effective ways of organizing your analytics dashboards is quite a bit easier if you can get a sense for what has worked for others. To that end, in today's Whiteboard Friday the founder of Sixth Man Marketing, Ed Reese, shares his five favorite approaches.

For reference, here's a still of this week's whiteboard!

Video transcription

Hi, I'm Ed Reese with Sixth Man Marketing and Local U. Welcome to this edition of Whiteboard Friday. Today we're going to talk about one of my favorite things in terms of Google Analytics -- the dashboard.

So think of your dashboard like the dashboard on your car -- what's important to you and what's important to your client. I have the new Tesla dashboard, you might recognize it. So, for my Tesla dashboard, I want navigation, tunes, calendar, everything and a bag of chips. You notice my hands are not on the wheel because it drives itself now. Awesome.

So, what's important? I have the top five dashboards that I like to share with my clients and create for them. These are the executive dashboards -- one for the CMO on the marketing side, new markets, content, and a tech check. You can actually create dashboards and make sure that everything is working.

These on the side are some of the few that I think people don't take a look at as often. It's my opinion that we have a lot of very generic dashboards, so I like to really dive in and see what we can learn so that your client can really start using them for their advantage.

#1 - Executives

Let's start with the executive dashboard. There is a lot of debate on whether or not to go from left to right or right to left. So in terms of outcome, behavior, and acquisition, Google Analytics gives you those areas. They don't mark them as these three categories, but I follow Avinash's language and the language that GA uses.

When you're talking to executives or CFOs, it's my personal opinion that executives always want to see the money first. So focus on financials, conversion rates, number of sales, number of leads. They don't want to go through the marketing first and then get to the numbers. Just give them what they want. On a dashboard, they're seeing that first.

So let's start with the result and then go back to behavior. Now, this is where a lot of people have very generic metrics -- pages viewed, generic bounce rate, very broad metrics. To really dive in, I like focusing and using the filters to go to specific areas on the site. So if it's a destination like a hotel, "Oh, are they viewing the pages that helped them get there? Are they looking at the directional information? Are they viewing discounts and sorts of packages?" Think of the behavior on those types of pages you want to measure, and then reverse engineer. That way you can tell they executive, "Hey, this hotel reservation viewed these packages, which came from these sources, campaigns, search, and social." Remember, you're building it so that they can view it for themselves and really take advantage and see, "Oh, that's working, and this campaign from this source had these behaviors that generated a reservation," in that example.

#2 - CMO

Now, let's look at it from a marketing perspective. You want to help make them look awesome. So I like to reverse it and start with the marketing side in terms of acquisition, then go to behavior on the website, and then end up with the same financials -- money, conversion rate percentages, number of leads, number of hotel rooms booked, etc. I like to get really, really focused.

So when you're building a dashboard for a CMO or anyone on the marketing side, talk to them about what metrics matter. What do they really want to learn? A lot of times you need to know their exact territory and really fine tune it in to figure out exactly what they want to find out.

Again, I'm a huge fan of filters. What behavior matters? So for example, one of our clients is Beardbrand. They sell beard oil and they support the Urban Beardsman. We know that their main markets are New York, Texas, California, and the Pacific Northwest. So we could have a very broad regional focus for acquisition, but we don't. We know where their audience lives, we know what type of behavior they like, and ultimately what type of behavior on the website influences purchases.

So really think from a marketing perspective, "How do we want to measure the acquisition to the behavior on the website and ultimately what does that create?"

These are pretty common, so I think most people are using a marketing and executive dashboard. Here are some that have really made a huge difference for clients of ours.

#3 - New markets

Love new market dashboards. Let's say, for example, you're a hotel chain and you normally have people visiting your site from Washington, Oregon, Idaho, and Montana. Well, what happened in our case, we had that excluded, and we were looking at states broader -- Hawaii, Alaska, Colorado, Texas. Not normally people who would come to this particular hotel.

Well, we discovered in the dashboard -- and it was actually the client that discovered it -- that we suddenly had a 6000% increase in Hawaii. They called me and said, "Are we marketing to Hawaii?" I said no. They said, "Well, according to the dashboard, we've had 193 room nights in the past 2 months." Like, "Wow, 193 room nights from Hawaii, what happened?" So we started reverse engineering that, and we found out that Allegiant Airlines suddenly had a direct flight from Honolulu to Spokane, and the hotel in this case was two miles from the hotel. They could then do paid search campaigns in Hawaii. They can try to connect with Allegiant to co-op some advertising and some messaging. Boom. Would never have been discovered without that dashboard.

#4 - Top content

Another example, top content. Again, going back to Beardbrand, they have a site called the Urban Beardsman, and they publish a lot of content for help and videos and tutorials. To measure that content, it's really important, because they're putting a lot of work into educating their market and new people who are growing beards and using their product. They want to know, "Is it worth it?" They're hiring photographers, they're hiring writers, and we're able to see if people are reading the content they're providing, and then ultimately, we're focusing much more on their content on the behavior side and then figuring out what that outcome is.

A lot of people have content or viewing of the blog as part of an overall dashboard, let's say for your CMO. I'm a big fan of, in addition to having that ,also having a very specific content dashboard so you can see your top blogs. Whatever content you provide, I want you to always know what that's driving on your website.

#5 - Tech check

One of the things that I've never heard anyone talk about before, that we use all the time, is a tech check. So we want to see a setup so we can view mobile, tablet, desktop, browsers. What are your gaps? Where is your site possibly not being used to its fullest potential? Are there any issues with shopping carts? Where do they fall off on your website? Set up any possible tech that you can track. I'm a big fan of looking both on the mobile, tablet, any type of desktop, browsers especially to see where they're falling off. For a lot of our clients, we'll have two, three, or four different tech dashboards. Get them to the technical person on the client side so they can immediately see if there's an issue. If they've updated the website, but maybe they forgot to update a certain portion of it, they've got a technical issue, and the dashboard can help detect that.

So these are just a few. I'm a huge fan of dashboards. They're very powerful. But the big key is to make sure that not only you, but your client understands how to use them, and they use them on a regular basis.

I hope that's been very helpful. Again, I'm Ed Reese, and these are my top five dashboards. Thanks.

Video transcription by Speechpad.com


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!