Categories
Website

Increase Traffic and Ranking in Search Engine 7 Title Tag (Title Tag) Tactic

You can now assume that the title tag in SEO is not very important and does not affect the rankings. But when we think about the rate of clicking on the link; We can’t ignore that the title still has a big impact. If the title is increased, your traffic will increase. Traffic allows you to increase in ranking.

So you can try to increase the traffic of your site by changing the first thing your visitors see. The following 7 tips can help you with this process; But don’t think it’s all right for your site. You can achieve real success through experimenting with different tactics. You can try some of these tips and have an idea about your title tag strategy.

How to be a Seo Title Search Engine

Numbers

The presence of a number in the title tag attracts visitors ‘ attention. Titles like ” 5 ways to Lose Weight”,“unemployment rate increased to 13%” encourage visitors to click on the link. This is because psychology is a phenomenon called ‘ cognitive bias ‘. Our brains choose things that attract attention and provide specific data. We’ll drown out a lot of information while we look at the search results. Our brains are looking for a result that can rely on and attract attention. At this point, it leads to the most likely data, i.e. numbers. You can increase your traffic in this way by using a number in the title tag.

Dates

Let’s look at a more specific type of number this time. “2017 SEO Trends”, will draw attention to a title in the style. It is also possible to give a more detailed date: “7 May 2017 match.” This strategy may not be suitable for every situation; But it will help you to sort your content by date, as well as to trigger the desire for visitors to reach up-to-date information.

Label length

In SEO, the most discussed topic in the title tag is the length of the titles. Sometimes when you encounter extreme short titles such as ” pants ,” you can sometimes see the long titles stacked with all the keywords like ” the cheapest arched narrow leg, black jeans women’s trousers and prices” . The problem of the first one is that it appeals to a large area. So when it’s called pants, it’s not understood whether it’s a man or a woman or a cloth or jeans. The second title is so long that the visitor will not want to read this tag on the search page. At the same time, the search engine will not predict what the title is about. is the content related to the belt or the related jeans; will be difficult to understand.

A recent study shortens the title tag of thousands of URLs. An increase in the rankings was observed at the end of this study. The number of best characters in the title tag is between 50 and 60. In this topic, your chosen keyword should be the word your visitor uses when searching. So the ” waist top black jeans prices” and the category “Women’s Pants” will add more accurate title tag.

Synonyms

In the previous example, we used the trousers in both the title and category, and the label was passed twice in the tag. This is not the desired thing in every situation. Let’s say you want to upgrade your ranking in the “cheap airline tickets” area. If you don’t have any other information, you can use synonyms to match the number of characters in your headline and search for visitors in different ways. For example, the title “Cheap and discounted airline tickets, the best flight booking” allows you to reach visitors who search for cheap or discounted prices instead. You can create different title tags using keyword tools such as keyword Explorer, SEMRush, and Google Search Console to find synonyms and variables of this type.

Call-to-action

It is a strategy that is incredibly contributing to the increase in traffic. Using the words ” buy”, ” find“, “Download”“Search”, “ listen“, ” Watch ” gives visitors excitement. Creates a click request on the link because they understand that they can perform an action. Even if they don’t write these words to the search engine, they will be careful to see them in the results. When you search for “Lion King,” the user who sees the word “watch” on the title tag knows that they can watch the movie if they click on that link. In this way, the rate of clicks increases.

Keywords

Using tools like Google Search Console, you can identify the keywords your site gets most clicks on. This way, you can provide a message with the title and increase your clickthrough rate. So we got the results for seohocasi.com. These keywords are the words that visitors write before entering Seo.

Questions

By asking a question like “What is SEO?” in the title, you are curious about the user. There is also another benefit of the bonus. This allows you to become a featured snippet; which will return you as a traffic increase. You can see an example of the featured snippet below.

Categories
Website

Delete Index

Search engines index all pages that a website sees, even pages it doesn’t see in some cases. As Web site owners, we may not want each of our content to be open to search engines. In such cases, it should be removed from the search engine results to not damage the site’s image.

In which cases the content can be cleaned

  • Pre-existing but subsequently deleted content

This situation is likely to happen if the content we have previously published on our site is outdated or if the sale of the product we sell is withdrawn.

  • External links to pages not included on our site

This is the links given by other sites, which are considered to be a page that is not actually included in the site.

  • As a result of moving the site to another address, the indexes on the old site must be deleted and transferred to the new site.

In which cases we may link to content that is not on our site

  • If a previously existing content was deleted, the link to that content might not have been deleted.
  • A link can be given due to coding errors or misunderstandings.
  • By adding REF codes, you can consciously link for advertising purposes.
  • Hidden content

In the case of confidential content, if the product or information on a site is only open to the desired member or persons, the index of such pages is cleaned up by search engines to prevent any visits to that content.

Content Cleanup Options

  • Clearing a site completely from search engines
  • Transferring all the results of a site to another site
    • This situation is preferred when the site is moved to another address.
    • Clearing specific content for a site
    • It is suspected of spam, considering that pages that are not on our site appear to have search engines and that sites have more index counts. For this reason, non-existent indexers can lead to the SEO work of the sites and even the sites to be punished by the search engines by filtering.
    • At the same time, invalid Indexs found in search engines are shadowing the site’s image. Visitors can think of any information or products they are looking for when they reach a page that is not on your site.
    • Apart from these, the Admin panel entry or official document and information belonging to the site must be confidential to any user who may come through the search engine.
    • Webmaster Tools
    • Robots.txt
    • Meta Code
    • .htaccess

Why should unwanted indexers be deleted?

Which methods with index are deleted

Webmaster Tools Configuration

Webmaster Tools allows search engines to notify website owners about search and scan situations.

In this article, the world’s most used search engine will be narrated through Google.

After registering our website with Google Webmaster Tools, in the Site configuration section, go to the Browser Access section and click on the Create Robots. txt tab to see all content of our website visible to Google or 2. With the option, you can have the entire site removed from Google search results.

If you want to remove the unique links from the site instead of the entire website content, we ask Google to enter the URLs we want removed from the browser Access URL tab.

Robots. txt edit

We can intervene on all site content by editing Robots. txt via Webmaster tools. However, by manually editing the Robots. txt file, you can delete the page, directory, category, and all site content you want removed from search engines.

To delete a whole site

User-Agent: *

Disallow:/

Only for desired page, index or category

User-Agent: *

Disallow:/Https://www.seohocasi.com/yanlis-url

Disallow:/Https://www.seohocasi.com/yanlis-kategori

Disallow:/Https://www.seohocasi.com/?ref

For Google image searches

Only desired image

User-Agent: Googlebot-image

Disallow:/images/seo.jpg

All pictures on the site

User-Agent: Googlebot-image

Disallow:/

Adding a Meta code

Meta robots code can be used to delete all site content or only the index of the requested content.

Placing the following code only on the desired pages, placing the index of those pages or all pages in the entire index of the site content, the next search engine will be removed from search engine results with the visit of the bot Can.

< meta content = “noindex, nofollow” >

If you want to delete the index of some search engines rather than all search engines, only the name of that bot should be entered, as in the example below.

< meta content = “noindex, nofollow” >

Otherwise, you’ll need to add the following code to prevent search engines from being able to cache your site or to delete pages in memory.

< meta content = “Noarchive” >

Htaccess Edit

As a result of changing the site address, the index of the old site is redirected to the new site, both the search engine and the future visits to the new site lossless redirect with this redirect and old indexes as new site index The htaccess arrangement is used to ensure that the

With htaccess , 301 can redirect the site to a complete other address.

For pages that do not open, the index of the 404 pages by creating the page 404 can be prevented by other methods.

We may be able to redirect an old product or information page to a new product page.

Redirect Permanent http://www.old-site.com/http://www.new-site.com/

How can I remove a URL on my website from the Google Index?

To remove a specific URL (for example, the page http://www.example.com/page4.html) of your own website from Google’s index, there are two options available:

Option #1: Use the robots meta-element with NOINDEX

Add the meta-element robots to the source code of the page which is not supposed to appear in the index and set the value to NOINDEX.

By adding the following to the source code of a page, it will be removed from the index:

<meta name="robots" content="noindex">

You have to add the meta-element in the <head> area of the specific page:

If the page already has the robots meta-element with the value INDEX, you can simply replace it with NOINDEX.

Done. Now you just have to wait until the desired URL is removed from the Google index.

By using the meta-robots value NOINDEX, the URL will also be removed from the index of Microsoft’s search engine Bing.

Option #2: Use the Google Search Console

Using a setting within the Google Search Console, you are able to easily have a URL removed from the Google index.

In case you are not yet using the Google Search Console, you can activate your website for the free (www.google.com/webmasters/tools/?hl=en) in just a few minutes. This also lets you remove URLs from the Google Index afterwards.

Removing a URL from the index with the Google Search Console:

  • Log into the Google Search Console and select the desired website
  • Click on “Optimization” in the left-hand navigation
  • Click on “Remove URL” in the sub-menu
  • Click on the button “create a new request for removal” on this page

  • You will now be asked to type in the URL of the page that you want to be removed and confirm your choice by clicking on “continue” (in our example this is the page http://www.example.com/page4.html)

Done. Now you have to wait some time until the desired URL is removed from Google’s index.

The Google Search Console will now also indicate the status of the removal process of the URL on this page.

The search engine Bing also provides their own webmaster tools, which you can use to have URLs removed from their index.

(http://www.bing.com/toolbox/webmaster)

Tip

If you use option #2 to remove a URL from the index, by using the Google Search Console / Bing Webmaster-Tools, the deletion may only be temporary in some cases.

The URL will definitely be removed from the search index for 90 days. Afterwards, there is a possibility that the URL may be re-introduced into the index, if the URL is still accessible and links still point to it.

If you want to make sure that a URL is permanently removed from the index, you should go with option #1 and use the robots meta-element with NOINDEX.

Categories
MySQL Uncategorized

10+ SQL Query that will save the life of your WordPress

If you have a 10+ SQL Query WordPress, I regret to say that you have a lot of work to do in organizing and periodic maintenance. And in some cases, you may have to be quick for specific problems that you encounter. In such cases, working directly on the database can really save lives. In this article you can see 10 + handy SQL query for WordPress. These quick and practical queries will certainly work for you when your WordPress is in a difficult state.

SQL query how to…

Let me briefly speak for those who do not know yet. SQL queries run in the MySQL command-line interpreter. Or it can be executed using a popular web interface, such as phpMyAdmin, which most of us use. I strongly recommend that you use the user-friendly interface and the SQL Executionner wordpress plugin, which allows direct interpretation of SQL queries.

Before queries…

Even though these SQL queries have been tested, don’t forget to make a backup of the database before you perform any queries.

Manually Changing your password

It could happen to you someday. The only solution if you forget your admin password is to create a new password in MySQL database. This is the only task of this interrogation. I would also like to draw your attention to the use of the MD5 function for password conversion only.

Transferring articles from one user to another

New WordPress users may not know or forget to write their articles with the name “admin” in terms of security. If you have made this error, you can transfer your old posts to the user you just created with this query. When using this query, you will need the old and new user name.

Delete Update information in posts

Update information can sometimes be useful. Especially in multi-user blogs. However, these update information is more than the records in the database appears. For example There are 100 pieces of articles on your blog and each one has been updated by editing it 10 times. All these transactions mean that the wp_posts table in the database has full 1000 records. However, it is enough to record 100 pieces.

This query helps to instantly delete the post update information and related text that we are talking about. It’s a very useful query to remove and relieve bulge in the database.

Deleting Spam comments in bulk

No need to say much, actually, the headline tells everything. It allows you to bulk delete spam comments accumulated in the checklist.

Find unused tags

tags are saved in the wp_terms table of the database. And sometimes there may be tags that have not been used since the day it was created. If you do not want these unused tags to occupy more space in the database, you can safely delete them with this query.

List unused text text

The meta information of the posts you write on your blog is created through plug-ins and custom fields. Most of the time, it causes the database to grow birdenire. You can list the meta information that occupies the database even though it is not used with this query.

Remove comments from old posts

For more than 1 year, the blog owner will know that the comments accumulated beneath the old posts are often unreadable, so they can take up unnecessary space. In the following query, you can instantly delete comments for posts before the date you specify by typing the date you want instead of 2009-01-01 . I’m guessing most people would be useful.

Change the Site links of reviewers

I mentioned how the replace () function in MySQL worked. The following query definitely proves it. In particular, it may be useful to change the URL addresses written for backlink.

Change the Email addresses of the reviewers

With this query, you can change the email addresses of the people who wrote the comments.

Delete comments found in Spam Link

Finally, a SQL query that is useful for you to avoid spam Links added in the form of comments to your blog. The “% wpbeginner%” section in the query means deleting all comments with the URL address between the “%” sign.

Categories
MySQL

MYSQL join two tables, MYSQL inner join

MYSQL join two tables, MYSQL inner join

SELECT books.ADI as bookName, categories. CATEGORY as categoryName
FROM books, categories
WHERE books.KAT_ID = categories.ID
AND bookName! = ”

Categories
MySQL

In SQL, insert data into another table, insert into select

SQL also throwing data from a table into another table. Add the data in the table to another table in SQL. With MySQL or phpMyAdmin, you can insert the data in the table into another table in SQL, insert into select.

INSERT INTO data-to-move-table (field1, field2, field3)
SELECT field-name-1, field-name-2, field-name-3
FROM data-moved-table
WHERE AGE> = 25