Introduction to Power Query and Power Pivot for SEO
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 […]
The post Introduction to Power Query and Power Pivot for SEO appeared first on Builtvisible.
Don’t underestimate the power of video
Global consumer Internet video traffic will account for 80% of all consumer Internet traffic. Pages with videos are 53 times more likely to rank on Google.
The post Don’t underestimate the power of video appeared first on Search Engine Watch.
Technical Audits – 10 Points to Cover
A good technical audit is one of the cornerstones of SEO. Make sure you know the essentials of what every audit should include in this post from Jo Turnbull.
Post from Turnbull
Research: The most common SEO errors
Every year our team analyzes site audit results of our users to find out the most common SEO errors. Light shed on the results we’ve got for last year.
The post Research: The most common SEO errors appeared first on Search Engine Watch.
How to Do Change Detection with Screaming Frog and Google Sheets
.png)
I made a Google Sheet that does change detection for you based on two Screaming Frog crawls.
Delete your pages and rank higher in search – Index bloat and technical optimization 2019
If you’re looking for a way to optimize your site for technical SEO and rank better, consider deleting your pages. I know, crazy, right? Lots of points covered with screenshots.
The post Delete your pages and rank higher in search – Index bloat and technical optimization 2019 appeared first on Search Engine Watch.
Four cool keyword research tools you can use for free now
Free or freemium keyword research tools (not including obvious ones like Google Ads Keyword Planner) to provide useful insight into organic ranking opportunities, persona building, competitive research, product development, and more.
The post Four cool keyword research tools you can use for free now appeared first on Search Engine Watch.
How to grab featured snippet rankings with zero link building effort
A brief idea of how you can rank a page on Google’s featured snippet, without building any links to that page. Types, techniques, and screenshots included.
The post How to grab featured snippet rankings with zero link building effort appeared first on Search Engine Watch.
How to Use Screaming Frog: A Beginners Guide
_(1).png)
If you are new to search engine optimization (SEO) or coming across your first time using Screaming Frog, this post is for you!
Why an SEO should lead your website migration
From URL mapping to testing, five ways in which the expertise of an SEO professional can propel your website towards successful migration.
The post Why an SEO should lead your website migration appeared first on Search Engine Watch.
Search engine results: The ten year evolution
Look around at a macro-level to see the trends vs. always focusing on detailed keyword level optimizations. Trends to help put your strategy in context.
The post Search engine results: The ten year evolution appeared first on Search Engine Watch.
Six HTTP status codes most critical to your SEO success
Understand your site’s critical HTTP codes to recognize errors that demand attention and find opportunities to help improve your SEO.
The post Six HTTP status codes most critical to your SEO success appeared first on Search Engine Watch.
Seven time-tested tactics to generate more Google reviews
A new research study reveals that Google review stars form social proof for your brand, boosting your site’s CTR by over 35 percent.
The post Seven time-tested tactics to generate more Google reviews appeared first on Search Engine Watch.
Three tools providing actionable competitive research insight
The powerful driving source of any business is its competition. Three competitive research tools that provide highly actionable insights.
The post Three tools providing actionable competitive research insight appeared first on Search Engine Watch.
Google Sandbox: Is it still affecting new sites in 2019?
Google never confirmed its existence, but many SEOs believe that Google Sandbox exists. So, does it exist in 2019? If yes, how to avoid getting affected?
The post Google Sandbox: Is it still affecting new sites in 2019? appeared first on Search Engine Watch.
Alexa.com adds more search tools to its competitive analysis
Now, the free tool “automatically generates top competing sites that it uses as the basis for a more in-depth competitive analysis report,” Alexa.com President Andrew Ramm told SEW.
The post Alexa.com adds more search tools to its competitive analysis appeared first on Search Engine Watch.
How to run a successful competitor-focused paid campaign
If you’re not running competitor-focused campaigns right now, you’re definitely missing out. Five steps to set up and run a successful SEM campaign.
The post How to run a successful competitor-focused paid campaign appeared first on Search Engine Watch.
Google Scholar: Indexation & Ranking
.png)
In this post, we will be looking at Google Scholar, how to optimise for it and how this Google platform can contradict traditional SEO practices.
Nine Google Ads hacks to improve your CTR and conversion rate
Flushing money into advertising without understanding its workflow is not cool. Top hacks every advertiser should use to improve Google Ads performance.
The post Nine Google Ads hacks to improve your CTR and conversion rate appeared first on Search Engine Watch.
Traffic forecasting: Predicting potential return from the 87% of buyers who start with search
Traffic forecasting is one of a CMO’s best resources to allocate marketing spend across the most useful tactics. Here’s how traffic forecasting could mean smarter ad spend.
The post Traffic forecasting: Predicting potential return from the 87% of buyers who start with search appeared first on Search Engine Watch.