GMB Now Allows All Dashboard Accounts to Access 18 months of Data

Yesterday, bulk users received the ability to download 18 months worth of data across all of their listings. Today it appears that all accounts, whether bulk or not, have the same capability.

This means that individual businesses will now be able to go back 18 months in their data analysis AND it means that agencies will now be able to retrieve meaningful data for all of the individual clients in their dashboard.

This will allow agencies the ability to track information for longer periods and to do more month over month comparisons.  This will allow for better trend spotting. With a little Excel macro magic, it might even allow for complete automation of their monthly reporting of this data to their clients.

Now if we could just get the CSV sent automatically.

Google GMB Upgrades Bulk Listing Insights and Provides High Traffic Store Data

There are two recent Google My Business Insights roll outs that are happening that should benefit bulk listings and those businesses with higher levels of foot traffic.

Bulk Insights Download

Evan Older reports on G+ that Google is now shipping the ability to download aggregate data in a spreadsheet form on all of your listings.

The report currently includes these fields per location:

Total searches Direct searches Discovery searches Total views Search views Maps views Total actions Website actions Directions actions Phone call actions

I knew that this product was in beta and the fact that Evan is seeing it likely means that it is rolling out more widely. It has not yet been included in the GMB new features page  So it might be a while before you find it in your bulk dashboard.

Update: As a note this download is now also available via the card view of the dashboard so if you are an agency and have management access to all of your client’s listing you can download the information in bulk into a spreadsheet and then, using macros, assign it to each client. It can go back 18 months.

Return Customers and Popular Times

Also first spotted by Evan Older in the Local Search Pros community and reposted at the Local Search Forum and now confirmed by Google is the inclusion of Popular Times and this new view, Return Customers, in the Insights dashboard

This is apparently being rolled out now in stages and shows both frequency of return visits and moved the popular times information from the Knowledge Panel into the GMB dashboard for any given listing. These data points do not yet appear to be available in the bulk upload.

I am curious how many of you see either or both of these new reports and the bulk download?

The Largest Review Spam Network Ever Or… Who is Shazedur Rahman and why should you care?

The title, The Largest Review Spam Network Ever, might seem like hyperbole. While I don’t yet know the network’s full size, it is responsible for tens if not hundreds of thousands of fake reviews. If you are interested in stories with happy endings, you would be better off reading some other post0.

Now onto the more important question…

Who is Shazedur Rahman and why should you care?  

Apparently she is a world traveler that purchased her wedding ring in Israel and eight months later hired a PI to track her husband down in Cebu1. She had her cell phone fixed by the same franchise in both Toronto & Vancouver2 and procured Pest Control services in both NYC and San Antonio. While in Austin she had her children’s teeth examined but prior to doing so checked out four other dentists before she chose Dr. Melanson.

Shazedur has had her cars shipped from Seattle to Kansas City, Portland to NYC and from Simi Valley Ca to someplace. Oh and for some reason she doesn’t like3 the cigars from Sam’s Smokes in Brisbane, Australia. Did I mention that she studied mortuary science in Wheeling Il.

All of this and more has occurred within the last year. Truly a renaissance woman.

This is a screen shot of Shazedur Rahman’s reviews around the world. Click it to view them all.

OK. I confess. She’s a review spammer. But you already figured that out.

What you haven’t figured out is that she sits amidst one of the largest review spam networks I have seen and I have been unable, due to its size, to get anywhere near the end of it.

Worse, I have been unable to get it removed from Google.

I have no idea how many fake reviewers are in the network but every time I click through to another business using the service I find 10-20 more. They go on and on.4

The Pattern(s)

When you start cross checking her reviews against other reviewers you find a similar pattern of reviews over large geographic areas5, for businesses that often have spammy names6, they are frequently in the service industries rife with spam7, the reviewers often review similar types of services in disparate locations8, and the reviews contain conflicting life stories and obviously fake identities9.

And there is always an overlapping of businesses that they review in common with the other reviewers. Usually any reviewer has no more than 3 reviews in common with any one of their compatriots.

While the pattern is obvious it is apparently too subtle for Google’s algos or human reviewer to spot.

Click to view and contribute to the spreadsheet.

How many are there?

I have no idea how expansive this network is but in the hours I have studied it, I have found at the very minimum a hundred reviewers and many more businesses10.

Continue reading The Largest Review Spam Network Ever Or… Who is Shazedur Rahman and why should you care?

Living Presidents Speak Out About Google Fake Listings & Research

Google recently released and touted their research on fake listings in Google Maps. While their may have been a few problems with the research and quibbling about the details, I wanted authoritative voices as to its worth. I reached out to the living past and soon to be past presidents1 and asked2 them.

“It depends on your definition of fake, but I found the research very interesting”.



 “The research was very, very special and very, very nice. We have some bad hombres here and with my help Google’s gonna get ’em out”.


“Intelligence gathered by this and other Google research leaves no doubt that the fake listings possessed and concealed some of the most awful spam ever devised. Google has been been very candid about their past. They found the weapons causing this abuse and destroyed them”.

“Read my lips, if Google says no new spam, it means no new spam”.



“I’ve looked on a lot of spam with lust. I’ve created fake listings in my heart many times. I am glad it was just in my heart or Google would have suspended me. Or maybe not since I was a lawyer”.


“During my administration, Google signed into effect the biggest fake listing cut in history”.



1 – Who knew that Bush One was still alive?  I had to do this search Is Is George Bush 1 still alive and verified that he was by reading  Wikipedia. There is a even a Snopes article on the topic George H.W. Bush Death Hoax  and a piece  in the Onion: Bush Dies Peacefully In His Sleep covering his demise. 

2 – OK I didn’t really. But if you are going to be in the fake news business I figure go big or stay at home. I always thought that it was the famous propagandist Goebbels who noted “the bigger the lie the better” but apparently that was not the case. It has been falsely attributed to him. This fake stuff is hard to keep track of.  There is a certain “meta-ness” to discovering that a quote by the most famous fake news master is fake while researching and writing a fake news article about a fake story on fake listings. 

Google Finally Adds Menu Link Option for Smaller Restaurants to GMB

The Google My Business Dashboard now allows restaurants to add menu URL. Last December, Google updated the GMB API to allow for a menu URL attribute to be added. Yesterday they announced that the feature is now available to regular dashboard users via the Google My Business New Features Page.

GMB interface to add menu URL

Many restaurants use PDF file formats for their menu but this is apparently not accepted. And there is only one URL space for a menu. Most restaurants offer up multiple menu pages for lunch, dinner and desserts so a business needs to make a choice as to which menu to share.

Last December when I had spotted an early version of the feature I noted: Giving this feature directly to the small business owner will solve one of the persistent and annoying problems that crops up in the GMB forums IF owners are given enough control over their menus AND 3rd party order options that Google auto loads. Few businesses want an outdated SingPlatform page as a default, uncontrollable link in their Knowledge Panel.

Google guidelines delineate two types of menus:

  • A menu for an eating and drinking establishment (like restaurants or cocktail bars) that lists the complete set of food and drink items that are available at the business.
  • A menu for a service business like a barber, spa, or car repair shop that lists the complete set of services that are available at the business.

However it appears that the interface does not yet support a service page and automatically prevents its inclusion:

Although the feature description implies that they will accept something beyond restaurant menus: Enter URL attributes for your business to add links to more kinds of information, like a restaurant’s menu.

Single location restaurants will appreciate the opportunity to directly control this feature as many are tired of Google’s previous insistence to include a 3rd party menu no matter how old and crusty it might have been.

Mike B Around the Local Web

In case you didn’t get enough of me this week here on my blog, you can overindulge in local  until you puke at these other fine publications:

Ductape Marketing: How to Get Found Using Ever-Changing Local SEO Tactics I have a fun conversation about Local with one of my favorite marketers, John Jantsch. We talk about all things local and how Google’s ranking algo works. What Happens When Google Can Manipulate the Very News It Seeks to Protect? where “I howl against SkyNet’s wind”.

LocalU: Video Deep Dive: How Google determines authority of local entities a conversation with Mary Bowling about local entity authority. Also now available as a podcast:

LocalU: Video: Last Week in Local with Mary Bowling for the week ending April 10th. Also available on a weekly basis as both a podcast and an email newsletter.


The State of Internet Marketing for The SMB: Frustrated

Credits: Peter Alfred, under Creative Commons 2

I recently received this comment from poster Frustrated.  And it rang so true that I decided to track the writer down.

Frustrated is Marc Reisner of Reisner Construction in northern Michigan. He has moved around a bit; Colorado, Seattle and finally landed in Port Sanilac, MI. Turns out he had relatives from the Olean area so we had a long talk. He wants nothing more than to move out of home construction and into making custom furniture full time.

He thought he could do that with internet marketing. But the lack of knowledge opens up small businesses to this sort of problem that he writes about. They are vulnerable  while thinking that they are missing something that the cold caller is promising to deliver.

It is interesting that Google, by association, was tarnished with the same brush. It is not surprising that the over promising and under performing digital marketing hype plus the hard sell scammers, ended up hurting Google as well as everyone else in the space.

Here is Marc’s story:


Marc Reisner’s (Reisner Construction) custom furniture

I was contacted by Yodle, then Townsquare Interactive, then Yelp. All 3 within a year.

Wanting to sell custom made furniture via the Internet, I fell for Yodle with anticipation of what they promised. After an initial discounted 6 months, no results….account closed and listing was pulled off the internet.

A week later TS calls. Their sales pitch was similar to Yodel, but they do not hold you to a predetermined period of time. 3 months, one call. I closed that account & lost a website.

Then, Yelp called. I explained to them my results with the first two and was lead to believe they were more established with a BBB rating and would create more business. I fell for it. They assured me they were the best. (I took notes on every conversation.) An initial monthly fee + $6 per click……meaning anyone calling my number listed on the internet I got charged $6/call. The number of calls that supposedly were dropped my me was unbelievable and I complained about it.

In looking at the actual phone numbers, I’d call the numbers Yelp listed and got the other side to answer with a recording, “The number you have called is not a working number.” The $425/month hit… contact via by one person, which looks like one real client.

It was a pain to actually close the account with Yelp with a closing fee of $450. They said they’d leave the account active for 2 months thinking I’d reconsider. One thing to do is set up your account with a credit card that is front loaded….put money into the card so you know how much will get spent, it’s like a debit card, but more protected from hackers. I closed the account.

Today, Google called to list my company for $600, but offered a one time discount dropping the fee to $399 for life….One time offer. I’d heard that before from them. I told them up front I’m not agreeing to sending any money today, I got this ‘that’s okay, I’ll just finish your company information’.

When done he went for the money via Cc #. I refused, so he said “I’ll get our finance manager on the line, he can help you. As soon as he said that, Bryce pipes in saying he had been listening to the call and could offer a better deal, $299 for life. I told him I didn’t have the money today…they hung up.

Word of mouth is the best advertising I’ve experienced over 35 years. Using the internet sounded appealing, so I figured I’d give it try hoping to find a good company to work with. I’ve not found one yet. I’ve learned a lesson that hopefully no one else will have to learn.


In a subsequent conversation where I asked if I could publish his name he noted:

As to the use of my name in your blog, I don’t see it as much of a problem.

It’s one of those “buyer beware” reality checks I think a lot of potential customers need when considering using an online advertising company that sells anyone the idea that “within 90 days you’re business will increase beyond expectation.”

Selling positive hype, rather than reality, should come with something only Townsquare Interactive gave, no contract.  I’ll give them credit for that.

I am very disappointed with the promises Yelp gave.  Deception at it’s best.

Spam In, Garbage Out – Why Google’s Recent Paper on Map Spam is Flawed

The claim made by Google that “…fewer than 0.5% of local searches lead to fake listings” in Google search is NOT a conclusion that can be drawn from Google’s recently published paper. This number understates the number of local searches that lead to the visibility of fake listings due to its assumptions and flawed methodology. And it may do so by a large margin.

The paper, Pinning Down Abuse on Google Maps,  while providing interesting insights into Map spam from 2014 and 2015 is  fundamentally flawed in its approach to the question of fake listings in Google Local and in no way warrants the optimistic conclusion that Google noted1  on their blog.


First you need to understand what Google defines as a fake listing for the purposes of this study. It only includes listings that were in gross violation of the guidelines and caught by their algo or human curation and suspended..  This  excludes any listing that manipulated its name or any listing that had manipulated their reviews2.  And more importantly it excludes fake listings that their algo didn’t catch.

Then you also need to understand what Google means when they say that “0.5% of local searches lead to fake listings”. They are not saying, like I erroneously thought, that only .5% of the listings are fake. They are saying that the listings that were fake & suspended were up for an average of X days and only seen Y times during that time. I.E. Compared to total searches,  fake listings constituted .5% of the user’s impressions in search and Maps. But as I will detail even the visibility assumption is flawed.

The Good, The Bad & The (very) Ugly of the Google Research & Blog : Continue reading Spam In, Garbage Out – Why Google’s Recent Paper on Map Spam is Flawed

Developing Knowledge about Local Search