In 2018, the average time to fully load a mobile page was 15 seconds. That is substantially higher than Google’s recommended page load time of 3 seconds.So, of course, reducing the total load time remains a top priority for allowing user interaction as quickly as possible.But page speed isn’t only about total page load time; it’s also about what users experience in those 3 (or 15) seconds. It’s essential to consider how efficiently pages are rendering.This is accomplished by optimizing the critical rendering path to get to your first paint as quickly as possible.Basically, you’re reducing the amount of time users spend looking at a blank white screen to display visual content ASAP (see 0.0 below).Example of optimized vs. unoptimized rendering from GoogleThere’s a whole process on how to do this, outlined in Google’s developer guide documentation (thank you, Ilya Grigorik), but I’ll be focusing on one heavy hitter in particular: … [Read more...] about How to Identify & Reduce Render-Blocking Resources
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?
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
17th July 2019 - 20 minutes read SEO Uncategorised Richard Lewis - SEO LeadOne thing I always loved about Star Trek was the maps of the galaxy they had on the bridge of the Starship Enterprise, showing and labeling the stars and planets of different alien civilizations. I loved the rich backdrop these maps put behind the show, making its futuristic premise of an explored galaxy of technologically advanced civilizations seem real. This map of the Star Trek galaxy from Star Trek online has all my old favourites – the Federation stars & planets in blue (that’s us), the Klingon Empire in red, and even the ultimate bad guys – the Borg – in Purple on the right. My current vocation of SEO hasn’t yet taken me to navigating the galaxy on a starship, but it has taken me deep into keyword market analysis – and that’s something that can be made to (sort of) look like it’s from Mr Data’s computer terminal on the … [Read more...] about How to Make Your Market Analysis Look Like It’s From Star Trek
Here is a common and interesting duplicate content problem.You have a retailer like David Yurman with products available in different color variations and chooses to display each product color on its own URL.Each product/color URL would typically have the same content but change the main product image, which is not enough of a difference to set them apart.Should you canonicalize all product variants to one and consolidate duplicate content?Or should you rewrite the product name, description, etc. to keep each version separate and unique?When you consolidate pages with mostly the same content, you generally end up with higher performance. This illustration from Google shows why.You are indirectly building links to the canonical pages.When you have pages with mostly the same content, they compete in the SERPs for the same terms and most of them would get filtered at query time. Each one of the pages filtered accumulates links that go to waste.However, here is an interesting case. … [Read more...] about Advanced Duplicate Content Consolidation with Python