Trending March 2024 # How To Create Content That Ranks # Suggested April 2024 # Top 12 Popular

You are reading the article How To Create Content That Ranks updated in March 2024 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested April 2024 How To Create Content That Ranks

Sometimes quality content does not rank. Features such as depth, the authority of the author, how up to date the information is does not seem to matter. It’s not uncommon to see such high quality pages not rank in Google. The following is a strategy, a way of doing SEO, that in my experience ranking websites, has been useful to me for the past few years.

Reviewing the Definition of Quality Content

While quality factors are important to Google, in my experience, what is most important is how relevant that content is for answering the search intent that is latent within a search query.

There used to be a commercial for canned tuna featuring a tuna named Charlie. Charlie wanted to be selected by the picky and discriminating tuna company. So Charlie the tuna cultivates himself with fine clothes, a piano, and other signals of culture and good taste.

This is very much the position that publishers with high quality content can find themselves in. Focusing on traditional signals of “quality” is a good start. But there’s more.

Usually, what’s missing from a discussion about quality is the quality of how the content is useful to people who search on a particular search query.

Focusing on depth of content, how complete it is and so on can put a publisher in the same predicament as Charlie the tuna who was cultivating all the signals of good taste.

At the end of the commercial, a voice says, “Sorry Charlie. We don’t want tuna with good taste. We want tuna that tastes good.”

How to Write Relevant Content

In my opinion and experience, the better approach is to understand what those keywords mean to the people who are using them. This is what the meaning of relevance is today.

Relevance used to mean matching the keywords in a search query to content on a page. But for the past few years it has increasingly meant matching the content with the needs of the user who is typing in that search query.

Keyword research today means asking “What is Google ranking and why?”

Be Relevant to People

Firstly, I am not saying to abandon keywords. What I am saying is to expand on what you are currently doing by being relevant to people.

In 2024, almost three years ago, I wrote the following in an article about keyword research.  The concepts here are important to understand:

“Algorithms are tuned to satisfying user queries by answering questions. They are no longer merely matching search queries to keywords on a web page.

This does not mean that you should phrase your pages as questions and answers. It means understanding the user intent/search intent latent in the keywords and constructing your content so that it satisfies the user/search intent implicit in the keyword phrase.”

That first part is about being relevant to the people making the search queries, not to their keywords. Be relevant to the people making the search queries.

Now the second part is about how being relevant to people who can boost exposure of your web page with social sharing and boost rankings with links:

“Web pages rank because websites link to those pages. Websites link to those pages because those pages solved a problem, because it scratches an itch.

Nobody ever linked to a web page because of its keyword relevance. Only an SEO walks into a bar, a dive, a speakeasy. Nobody links to that.

…View your keyword list through the framework of user intent/search intent and then consider how the resulting content can be used to create a positive user experience.”

You see how being relevant to people works? It’s a killer strategy that in my opinion is tuned to how search engines rank sites today. There are many different approaches to this, including providing a good user experience, making your content easy to read and so on.

But at the heart of all of those actions that creates a path from the user to your content, it all  hinges on thinking in terms of being relevant to the user.

More Resources

Images by Shutterstock, Modified by Author

You're reading How To Create Content That Ranks

5 Examples Of Terrible Content That Ranks Remarkably Well

Google is constantly tweaking its ranking factors to ensure it shows only the best results to searchers.

Because only the most relevant, authoritative, and highest quality content ranks at the top of the SERPs. Right?


Not always.

Sometimes low-value webpages that offer little value to searchers still manage to rank well.

This article will highlight five of the most common types of content that, sadly, I come across too often in the organic search results.

1. Toxic Sites That Drive Traffic & Monetize It Through Banners

This page ranks well for such keywords as “seo techniques” and “seo tactics”.

The big problem with this page is that its major goal is to drive and monetize traffic through the swarm of banners placed everywhere on this website.

How does a user benefit from all of this? Unclear.

Alas this page isn’t the only one of its kind.

Here’s another example of a similar site.

Examples of this content type mentioned above demonstrate how a page can exist to fulfill only one purpose: to get as much organic search traffic as possible.

Often, this kind of websites blindly copy contents from other sites with higher authority. The script does it all, including all of the backlinks within the site.

Many SEO experts can remember the days when you could easily make a buck by creating a site like that and placing a couple of banners on it. The flow of traffic was outstanding.

Now Google does everything it can to eliminate such sites from the SERPs. But even artificial intelligence needs some time to locate and block all of these sites from the search results.

2. Tons of Pop-Ups & Zero Search Query Matches

As I was analyzing the search results for [CPA marketing] on Google, I noticed something interesting.

Check out this screenshot:

The page in Position 3 also ranks for a keyword that has more than 2,000 monthly searches, based on SEMrush data. Although the keyword here is “CPA marketing”, the content on this page has nothing to do with this particular subject.

It’s also hard not to notice the title of the third page mentions money twice.

Nobody argues that making a profit is important. But do you really need to be so blunt?

Apart from the author’s subtle humbleness and CTAs that whisper his accomplishments, there are several other issues with this page. Where to begin?

Content is locked out with tons of pop-ups.

You know who else is a big fan of pop-ups? Neil Patel.

That’s why, at times, I find it difficult to read his blog posts.

Because of the constant interruptions.

OK, let’s give Vladi here some credit. The post is decently written.

Yet, the content doesn’t match the search intent of “CPA marketing” (which is an informational search). The article covers how one can start making money by becoming a member of an affiliate network.

3. Poor Quality Content

More often than not, searching for a helpful article can be like taking a trip to a mall on a Sunday.


Take a closer look at this article:

While it’s miraculously resting on its laurels at the top of the SERPs, it is nothing but a digested and rewritten content, copied from other articles.

The keywords in this post are straightforward, hence it has a solid number of users coming to this page.

However, the quality of this content is low, to say the least, the post doesn’t even get close to explaining how to start making a killing on Snapchat.

Unfortunately, a lot of digital marketing blogs suffer from similar counterproductive content.

No doubt, your page may also get lucky and appear at the top of Google. But once a different page with higher-quality content comes around, your article won’t stand a chance.

4. Outdated Content

Do you ever see something that makes you say, “Am I really seeing this?”

Well, here’s another page.

Talk about a terrible user experience!

5. Poorly Structured Content

This post ranks in top three results for [ecommerce stats 2023] search term:

Fearing they might lose their readers too quickly, these guys decided to go all out for a win. They geared up with links, placing as many of them as possible.

Sure, they meant well, but the road to user experience hell is paved with good intentions.

Not all growth-hacking strategies are equally good, I suppose.

I have another example of an article that ranks well in Google:

Oh no, it’s me! Yes, I got caught producing something useless.

For some reason, online users don’t seem to enjoy reading my post. The bounce rate for that post is astronomically high compared to other pages:

Here’s the main search query that brings traffic is “best backlinks analysis tool”:

So what’s the problem with this post? I believe it’s mainly a result of poor structure:

There’s no summary table that would demonstrate the functionality of each tool featured in my analysis.

It lacks navigation and shortcuts to specific sections.

This post is for those few people who like to scroll and read lengthy studies. Apparently they haven’t found my article yet!


Even though these articles are doing strikingly well in terms of ranking and attract a lot of readers, I bet those readers don’t come back.

If you want to bring value to your online community and be recognized for good things, then create content that earns you readers’ trust and good business. And the traffic will come.

More Content Marketing Resources:

Image Credits

All screenshots taken by Alexandra Tachalova, May 2023.

It’s Alive…Alive! How To Create Electrifying Seo Content

Those of us that undertake the daily task of writing for our blog, articles for our clients or newsworthy press releases can sometimes lose the will to live when ideas are sparse. Words are fused together within a weave of conjunctions and contractions that make up an ugly, SEO monster that would terrify even the most experienced reader.

Fortunately, there are ways to become a modern day Frankenstein and create content to make it every bit electrifying as your last creation.

The brains of any content; The Title

Whether you are passionate about what you’re writing or understand little about a subject, an intriguing and interesting title can give you that burning desire to research and discover more about what you’re expressing to readers, rather than work your fingers to the bone for nothing in return.

Of course, in terms of SEO, the title holds many keys to success. With a clever, key word rich title, the appearance of said text will therefore appear within a search, exposing your business for all it’s worth.

Add meat to the bones; the main body

Regardless of how you devise content, writing all starts with a skeleton (idea) that needs padding out with fleshy sentences and muscular description. When it comes to creating the bulk of your article it is better to break down into bite-size chunks rather than sieve through dense ideas.

Neck and torso;

Similar to the head (title), the neck and torso (introduction) hold all of the other ideas together. Whatever is written after this will be a reflection of what was initiated at this stage. How you develop these ideas is up to you, but remember; A limp frame will not be able to support anything that is added on to it causing it to crumble under the weight of under developed ideas. A strong, sturdy start will make for a strong and sturdy article.

SEO is all about gaining exposure making you the best at what you do. Without proving this in everything you do, not only will people not take you seriously, but the search engines aren’t likely to either.


Developing your ideas from what you have set out to discuss in your introduction will make your content far easier to write. If you don’t know where you’re going with your ideas, neither will your readers; resulting in people fleeing in horror.

Keep to the point that you set out to make within the title and introduction. Everything attached to your initial idea should follow through and not leave readers disappointed.


Your lungs should breathe fresh air into a topic not create a stale atmosphere with rewritten text. Make sure if content has already being covered that your make it your own and take on an angle that makes you piece stand out against other works.


Wrap up your monstrous ideas within your conclusion, making it complete and ready to be sprung into life. The conclusion of any writing project should a pull everything together, completing the final piece and showing it in all its glory. All the bits and pieces used to create something new and interesting should all be finalised, anything left hanging around will not only frustrate your readers, but cause the whole piece to fall apart and seem disjointed.

Bringing Your Article To Life: Switch on the power.

Writing an article that is SEO friendly is all well and good, but sitting on your desktop will do nothing for your listings. It’s time to plug in and switch on and get that creation out there moving across the web. Submitting it to industry specific blogs, categories and exposing it on all forms of social media will make all the work worthwhile.

Don’t forget to link back to your website or blog and let readers know the inventor. If you’ve produced exciting and intriguing content, it will only spur you to keep creating and bringing words on a page to life.

4 Different Factors That Affect Where A Webpage Ranks In Google

While there are more and more ways for people to find your website today than there were even a few years ago, it’s still true that Google can impact its success or fuel its failure more than any other single platform.

The key is to ensure that your site is well optimized so that it plays nice with Google’s search algorithms, and to do this you need to know about what factors influence how this engine ranks web pages. So let’s look at the most important aspects of optimization, and what you can do to achieve them.

The Quality of Content on the Page

When it comes to SEO, content is still king. Google will reward webpages with high-quality content that provides true value for users. This means avoiding keyword stuffing and writing concisely about topics related to your website or niche in a way that educates, informs and entertains readers.

It also helps if you use strong formatting, such as headings and bullet points, to break up text and make for more pleasant reading overall.

Additionally, try to incorporate multimedia elements, such as images or videos, into your page’s content. This engages visitors and keeps them around longer, which in turn will lead to ranking higher in search engine results pages (SERPs).

Page load time is another important factor when it comes to SEO. Google rewards pages that load quickly, as this improves user experience and keeps visitors on your site longer.

To check your page’s loading speed, use a tool such as GTMetrix or Pingdom to identify areas of improvement. These tools can help you optimize images through compression, minimize redirects/HTTP requests, and enable browser caching, all of which contribute to faster loading times.

For further tweaking, look at reducing any large scripts or code bloat that may be slowing down your website. Getting rid of unnecessary elements will go a long way. And of course working with a provider like NameHero that provides simple web hosting packages at good prices will ensure you aren’t hampered by any server-side issues from a page load speed perspective.

The Use of Keywords and Meta Tags

Using the right keywords is essential for Google to understand what your page is about. It’s crucial that you target relevant keyword phrases in the body text, titles, headings and subheadings throughout your website.

Then, use meta tags to describe each page on your site. These are brief descriptions that search engines can read which help them identify what a web page is about without having to crawl through all its content. Make sure they’re unique per page however, because duplicate meta tags could result in penalties and lower rankings within SERPs.

Inbound Links From Other Sites

One ranking factor you definitely can’t afford to overlook when it comes to SEO is external links from other sites. These tell Google that your page is popular and trustworthy, thus making it more likely to get recommended higher up among the results for your target keywords.

Try encouraging other websites in your niche, or authoritative sites in related fields, to link back to yours. This could be done through guest blogging, or offering them content that can benefit their audience too.

Also look at creating social media accounts for your site and sharing its content as much as possible. This builds up a larger audience over time, which will lead to more inbound links being found on third party sites.


How To Create Excel Template?

Create Templates in Excel

We have different types and categories of templates available in Excel, which can access from the File menu ribbon’s New section. This has different types of Templates such as Business, Calendar, Budget, Planner, Financial Management, etc. To create customized templates other than these, we can use Data Validation for drop-down, Table, and Images and give them proper header names. We can also insert a logo for our template. To standardize the template, always fix the theme or template, and visuals should see the purpose of creation. In this article, we will learn about Create Templates in Excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to create Templates?

Templates can be made by saving an Excel file with a specialized extension and then saving the file in a specified directory.

What type of content can be stored as a Template?

Text data can be stored as a template. Various document sections, such as page titles, column and row labels, text, section headings, and any cell in Excel containing text or numbers, or any kind of data, can all be included in a template. We can also include any graphical shapes, logos of companies, or any background image and even Excel formulae.

The type of text formatting, such as font, color, or size, can be saved along with the data as a template. Formats of cells or worksheets, such as column width or background fill color or alignment of text and even formats of numbers and dates, and several sheets can be saved in templates.

All hidden and protected areas, such as locked cells that cannot be altered and hidden columns and rows, or even worksheets that may contain data not meant for general view.

All Macros are specially customized toolbars that may contain frequently used options; macros and the quick access toolbar can be saved as templates.

How to Create Templates in Excel?

To create a template in recent versions of Excel, very little work must be done.

Excel 2013 & later versions – Before saving a file as a template, one has to define the custom template directory.

Go to File.

Select the option Save in the menu ribbon.

Find the option Default personal templates location among the various options.

Choose a directory where you want to save all the templates. DocumentsCustom Office Templates is regarded as a good choice.

Firstly, go to the File.

Now, the option to provide a name to your template file appears.

Here we see that in the drop-down menu, there is an option called Excel Template (*.xltx)

Note: It is better to choose “Excel Macro-Enabled Template” (.xltm) for cases where the workbook might contain macros. “Excel 97-2003 Template” (.xlt) is to be chosen for the cases where the version of the Excel workbook is very old. “Excel Template” (.xltx) should be chosen for all other cases.

Examples to Create Templates in Excel

Below are some examples to create templates in Excel.

Example #1

First, we will make all the changes in a new file and modify it until all the items you wish to save in the template are ready. Then you have to save the file as a template. Template files have a special extension.

In the screenshot above, we have added an image and text as the template’s structure. Now we shall follow the steps below to create the Excel template.

Step 1 – Firstly, go to File.

Now, the option to provide a name to your template file appears.

Step 3 – Here, we see that in the drop-down menu, select Excel Template (*.xltx)

Now, automatically, Excel will place this template file in the appropriate directory. And new Excel documents can be created based on this template file by navigating and choosing “Personal” in the new file window (right next to Featured) and then choosing the appropriate template.

Concepts always become much clearer when we have more examples. So, let us look at yet another example of creating Excel Templates.

Example #2

Let us explore how to save a Macro-Enabled Excel template through an example. Suppose we have an Excel with some macros(s) to be used as a base for other files; then we need to save this Excel as a macro-enabled Excel template.

In the screenshots above, we added a macro in the template file, and now we shall create the template in Excel.

Now, the option to provide a name to your template file appears.

Here we see that in the drop-down menu, there is an option called Excel Macro-Enabled Template (*.xltm)

Now, automatically, Excel will place this template file in the appropriate directory. And new Excel documents can be created based on this template file by navigating.

Firstly, go to File.

Choose Personal in the new file window (next to Featured) and then choose Template 2.

Example #3

Now, let us look at another example. Firstly, we will make all the changes in the new file and modify it until all the items you wish to save in the template are ready. Then you have to save the file as a template. Template files have a special extension.

We have added an image and text as the template’s structure in the above screenshot. Now we shall follow the steps below to create the Excel template.

Now, the option to provide a name to your template file appears.

Step 2 – Here, we see that in the drop-down menu, select Excel Template (*.xltx)

Example #4

Now, let us look at yet another example. Now, we will make all the changes in a new file and modify it until all the items you wish to save in the template are ready. Then you have to save the file as a template. Template files have a special extension.

In the screenshot above, as you can see, we have added the template structure – we have added a world map, increased the default worksheets, and renamed them, and now we shall proceed to save this file as a template.

Now we shall follow the steps below to create the Excel template.

Now, the option to provide a name to your template file appears.

Step 2 – Here, from the drop-down menu, select Excel 97-2003 Template (*.xlt)

Example #5

Now we shall use a template file to create a new file in Excel. We will make use of the Example #4 template file.

Firstly, go to File.

Choose “Personal” in the new file window (next to Featured) and choose the appropriate template.

We shall choose Template 4 as the base and create a new file in Excel.

As we can see, all the template structures are retained, and the new file is named Template4 1 – the first file based on Template 4.

Example #6

Now we shall use another template file to create a new file in Excel. We will make use of the Example #3 template file.

We shall choose Template 3 as the base and create a new file in Excel.

Hence, we can see that the image and the header structure are retained in the new file. And it is also important to note that this new file is named Template 3 1 – signifying that it is the first file based on Template 3.

Example #7

Now we shall create another new template. We will create the template structure in Excel, as shown below.

Now we shall follow the steps below to create the Excel template.

Now, the option to provide a name to your template file appears.

Step 2 – Here, from the drop-down menu, select Excel Template (*.xltx)

This will create a Template 7 template with the template structure defined in the Default Template location in Excel.

Example #8

Now we shall attempt to use Template 7 to create another file in Excel.

Now, automatically, Excel will place this file in the appropriate directory.

Example #9

Let us see an example where we have Excel formulae in the Template file.

As we can see above, we have created a Template structure with the formula for Net Profit Margin defined as:

Net Profit Margin = (Net Profit/Total Revenue)*100

Since this is the template, no data is present here. Let us see how to create the template file in Excel.

Now we shall follow the steps below to create the Excel template.

Now, the option to provide a name to your template file appears.

Step 2 – Here, from the drop-down menu, select Excel Template (*.xltx)

This will create a Template 9. xltx template with the template structure defined in the Default Template location.

Example #10

Now, we shall attempt to use the previous example template to create a new file and see if that works in Excel.

We see that in the new file, we have the structure defined, and once we feed in the data on Columns A, B, and C, the Net Profit Margin in Column D is automatically calculated using the Template File formula.

Example #11

Let us now use our second example – Template 2 to create a new file in Excel. Template2 has a defined macro, so let us see if the same is available in the new file.

Now let us see what happens when we select “Template2”.

It opens up a new file with the same macro (that was defined in the template file) loaded automatically.

We will get the desired result.

Things to Remember

For versions of Excel 2013 and later, it is possible to change Excel’s default template for a workbook by saving the template at the appropriate location. All default templates must have a specific name – chúng tôi or chúng tôi and must be saved in Excel’s startup directory. C:Users%username%AppDataRoamingMicrosoftExcelXLSTART

The template has to be named xltx or Sheet to modify the template to add new sheets in existing files. xltm and must be saved in the same folder.

Recommended Articles

This is a guide to Create Templates in Excel. Here we discuss how to Create Templates in Excel, practical examples, and the type of content that can be stored as a Template. You can also go through our other suggested articles –

How We Create The Perfect Seo Brief That Aligns Teams & Beats Competition

Does aligning SEO goals with multiple teams and departments feel like herding cats?

To add fuel to the ever-extending timeline, you may have uninformed stakeholders who also need to provide their input.

Marketing, SEO, and content teams share many of the same goals, but how aligned are you in creating timely and consistently effective content?

It’s time to try the perfect SEO brief.

On June 22, I moderated a webinar with Ajay Rama, CEO of chúng tôi He demonstrated how to create a well-coordinated brief that seamlessly connects your teams, elevates your content program, and outperforms your competitors.

Here is a summary of the webinar.

To access the entire presentation, complete the form.

Challenges With Producing High-Performing Content

As you scale, these creating content can become more challenging.

Many companies have difficulty staying on track, resulting in deteriorating content quality.

Quality of content is highly subjective and hard to scale, as it depends on the content writer’s capability, which varies from person to person.

Research on the topic takes too much time, and the research quality is inconsistent.

Multiple stakeholders make aligning and executing a vision a challenge.

What’s needed then?

A content brief is a solution to addressing scaling challenges.

[Create the perfect content brief] Instantly access the webinar →

In reality, very few companies use content briefs.

Even when they use it, it isn’t comprehensive, high-level enough, or doesn’t provide the benefits an organization needs.

What An Effective Content Brief Covers & The Execution Steps

A well-structured brief can elevate your overall content performance.

Three steps address each aspect of the core pillars that make a solid piece of content.

[Discover the 3 core pillars of content creation] Instantly access the webinar →

Step 1: Research User Needs

Research the keyword landscape for your topic before you start writing. You’ll need to understand what queries people are typing into search engines.

Once you know this, you can finalize keywords with which you should optimize your content.

First, create a list of keywords for which you would like this page ranked.

Primary keywords.

Supporting keywords.

[See examples of each] Instantly access the webinar →

Step 2: Perform Competitive Research

The next step is creating quality content.

Competitive research can help you build quality content. You can achieve this by knowing:

What competitors are covering.

Titles and headers.

Popular questions.


How competitors are optimizing their content.

Words and phrases.

Elements that are optimized.

Aim for at least seven pages of comprehensive research.

Step 3: Optimize Your SEO Outline

Know the elements of how you plan to communicate your content to the search engines.

This can be achieved through:

Keyword targeting.

Addressing user queries.

Identifying and targeting the SERP packs.

[Dive deeper into each step] Instantly access the webinar →

Here’s what your content brief should look like.

Structured research will allow your team to focus on creative aspects of content creation without wasting time on operational details.

[Slides] How We Create The Perfect SEO Brief That Aligns Teams & Beats Competition

Here’s the presentation:

Join Us For Our Next Webinar! KPIs, Metrics & Benchmarks That Matter For SEO Success In 2023

Reserve my Seat

Image Credits

Featured Image: Paulo Bobita/Search Engine Journal

Update the detailed information about How To Create Content That Ranks on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!