What is going on? Again, three times in about a week, we are seeing increase chatter and the tools are lighting up around a Google search ranking algorithm update. Yesterday morning the chatter once again spiked up and also many of the tools are showing huge fluctuations in the Google rankings.Update note on the name: On Friday, Brett Tabke of WebmasterWorld named this update "Update Maverick" he said "Update Maverick (in honor of yesterdays Top Gun trailer release). Because this update looks a bit stealthy and precise. However, all the major algo tools are reporting an update has occurred." Personally, I am not a huge fan of naming an update for a movie, would have preferred something around the 50th anniversary of the moon landing but hey - Google had their opportunity to name it and they didn't get back to me after numerous attempts. Here is some of the new chatter in WebmasterWorld:Massive movements for me. All my keywords have dropped again sad I can't believe this Same … [Read more...] about Google Search Ranking Algorithm Update Again: Update Maverick
UPDATE: The form is back up - so maybe this was a small technical issue. Disregard the rest of this story... I get it Google, you can't handle all the Google Maps issues. You are seriously delayed with getting back to businesses. You are suspending businesses that should not be suspended. You are claiming those suspensions were fixed but they weren't. Now you drop the Google My Business local business reinstatement request?Try it, it is over here - there is no form as John McAlpin posted on Twitter. I don't see it. do you? This is what I see:So you take down the form? Is that to stop the requests from coming in? Tisk tisk tisk.Forum discussion at Twitter. … [Read more...] about Fixed Now: Google My Business Removes Reinstatement Request Form
19th July 2019 - 5 minutes read Google Search SEO Lily Dunn Goekjian - Data ScientistWe recently decided it would be very useful to know what percentage of people who see Google map packs, frequently found at the top of the SERPs, actually click on them. However, upon investigating this, it did not seem possible to find research on this topic anywhere online, so we decided to do it ourselves. The first thing we needed to do was find some data to use. We found that the accounts that had data on this tended to be ones where a physical location was particularly relevant, such as retail sites with physical stores, or the hospitality industry. This suggests there is a potential bias here. Putting that aside, however, we ended up discovering that we could easily find a fair number of accounts with search terms, impressions and clicks that we could use to estimate the click through rate. By the time we finished, these accounts totalled over 3.6 million … [Read more...] about How many people actually click on the Google Map packs?
“What’s the best…”Let me stop you right there. The answer is “It depends.”Ah yes, one of the most frustratingly glib retorts known to man.But you know what?I think it’s high time we started embracing it.It’s in the “it depends” moments when we:Start to think strategically.Stop latching onto every shiny new tactic we see in our news feed.Finally stop blindly following every “best practices” checklist or correlation study and start critically examining everything through the lens of our unique needs.We need to embrace the fact that there are no universal truths in content marketing.Sort of.What Are You Trying to Do?When I say there are no universal truths in content marketing, I’m not saying that there aren’t objective best practices we need to follow (hence the “sort of”).If we want something to show up in search results, we can’t accidentally leave a noindex tag on it.If we want our … [Read more...] about There Are No Universal Truths in Content Marketing (Sort Of)
This post is the first in a series exploring advanced functions in Excel. If you’ve ever worked on more data-intensive projects, you’ve probably run into Excel’s maximum row limit of just over 1 million per tab. There are many ways to get around this – using other database systems such as MySQL, or languages like R or Python to store and process the data – but did you know you can do it in Excel also? In this blog post, I will show you how to quickly merge, filter and process data files with over 1 million rows using Power Query and Power Pivot. Both of these tools are now part of Office 365 and can be activated within File -> Options -> Add-Ins -> Manage COM Add-ins. So, what are these tools exactly? As you can see in the diagram below, Power Query is responsible for merging, organising and cleaning the data you would like to work with. Power Pivot serves as the engine that processes the data and helps you create pivots, charts and grids. These … [Read more...] about Introduction to Power Query and Power Pivot for SEO