Daily Archives: June 28, 2015

Complete On Page Search Engine Optimization Guide

Published by:

Well Designed Website make a sale. Please take some time to seriously evaluate your website and follow the steps provided in this guide that can help your to achieve high ranking in the search engine and can bring a lots of targeted traffic to your website. If you are able to implement the recommended methods in this guide. I am 100% sure, Your site will be in the top 10 in all the search engines.

Following are the most important factors any search engine give while ranking any website in their algorithm.

Title tag, The main body Text, Meta tag, Link popularity, Domain Name, Heading Tags, No of Keywords, Bold and Italics, Folder Name, Image Alt Tag , Title attribute and keyword in the beginning of the sentences.

On the Basis of their importance, we can rank them as follows

Title Tag 2.0
Link Popularity 2.0
The Main Body Text 1.5
Domain Name 1.0
Keyword Density 1.0
Heading Tags 0.5
Proximity of Keywords 0.5
Bold or Italic 0.4
Folder or Filename 0.4
Meta Description 0.3
Alt Tag 0.2
Title Attribute 0.1
Meta Keywords 0.1
Total Score 10
Title Tag

Title tag is the Most important tag of your webpage.It is Basically short description of your website, and the most important keywords ( words ) must go here. Must see video on Keywords research on Google adwords Keywords tool.

Every webpage must have a title tag and that must be unique.Don’t use the same title tag multiple times in your website. It should be inserted inside your webpage like this . Two most recommended tools for finding keywords are Google Adwords Tool for HTML based webpages and Keyword Spinner for WordPress.


101 Search Engine Optimization Guide Tips

How to write better Title Tag

.It should always appear just after the heading tag .
It should be specific and must contain your desired keywords or phrases
Use only keywords and phrases that are also available in your body text on your Page
You can use the same keyword twice to attain more keyword density, But make it very sure they must not appear side by side.
6-12 words ( Less than 60 Characters) are considered as a good length for a title tag.
Consider using both form of the keywords i,e singular and plural form of the keyword.
It should be readable like a phrase that make some grammatical and logical sense, not collection of keywords.
Try to place your primary keyword and the starting of the title tag.
Keep the words in Title case ( Example 101 Search Engine Optimization Tips )
Make sure to avoid search engine stop words or words Like Home, Index, No-Index, Default etc.
Avoid using superlative in your title Tag like Cheapest, fastest, The best , Oldest etc.)
Try to Minimize the use of Commas in the title tag.
Strive for Keyword Density between 25-30% for each Keyword.
Always remember to close this tag with
All pages must have unique and Descriptive Keyword Phrases in the title. One page of your site may be Seen as more relevant for a particular keyword when compared to another )
Try to Keep title tag as Unique as possible in your website.
Do not Change your title tags regularly.
BAD PRACTICES

Kerla, backwater, Land,river
money, online, earn <title/><br /> GOOD PRACTICES</p> <p><title> Kerla- The Land of river and Backwater
Earn Money Online
The Main Body Text

How to write better Main Body Tag

Keyword Prominence :Make sure to put the Most important keywords in the Beginning of your carefully crafted Paragraph at the beginning of your Page.A Keyword that appear nearer to the top of the page area will be considered the most important keyword/keywords.
Keyword Density : If your page contains less than 500 words. Keeping 1-3% keyword is considered a better one, if your page contains more than 500 words, your can consider between 3 to 5% keywords.
Try to provide minimum 250 words and maximum 750 words in each page. This is not a hard and Fast rule but it is observed that long pages are often bypassed by the visitors.
Use CSS instead of Tags.
Try to avoid all java scripts that are coming through some external files.
Try to avoid image button and Java scripts links,try to keep in pure text links.
Use heading tags ( h1,h2,h3) . Most search engine love h1,h2,h3 tags. Try to put your important keywords or phrases here.
Repeat the tag in the page heading if possible.<br /> keyword Proximity : It refers to the closeness between two or more than two keywords.Try to keep as close as possible your possible keywords or phrases , which is generally searched on the internet as a single phrase.<br /> Place some important keywords in Bold and Italic.<br /> Use alt tag to Describe your images.Alt tag are used to define the images, if the user turned off the graphics. This description will appear in that placeholder. Some Searching engine including Google search keywords in alt tags also.<br /> Insert comments tag in your Pages. Some search engine even read these comment, so you can use this feature to get some more traffic from these unknown search engines.<br /> Make sure the code of your home page should not bigger than 32K. Put only the most relevant and important information on your Home page.<br /> Try to keep Your font size to a minimum of 11px or 12px. These are highly recommended font size.<br /> Try to avoid nested Loops ,Specially in <Tables>. Instead of table try to use CSS to present your data in Tabular format or USE list tags.<br /> Use W3C technologies and Guidelines. Recommended browser is firefox with web development plugins to check your CSS and HTML.<br /> Try to target only two or three main keywords for a whole website.<br /> Try to avoid same keyword multiple times in the same row.<br /> Update your body text on regular intervals. ( Many Search Engine prefers website, which update it’s contents on regular basis )<br /> Meta Tags</p> <p>Meta tags are the tags which appear after the title tag in the code of your webpage.These are used to basically attract the search engines. The basic Syntax of meta tags are as follows</p> <p><HEAD><br /> <TITLE> Your page Title goes Here



How to Better USE Meta Description Tag

Write your meta description in sentence structure.
Should be relevant to the similar 25-30 word (under 150 characters) description of the first text within the visible page.
Do not repeat your keywords more than 3 times in description tag. If you need, make alternatives (e.g. ‘prescription’ and ‘prescriptions’ can be used 3 times each).
Minimize the use of “stop words” such as “and, the, of”.
Keyword phrases that appear earliest in the Meta description will generally receive higher ranking value.
Try to include this tag in all pages by describing the content and it should be unique.
Don’t load your Meta description with only keywords.
Strive for 6%-20% keyword density.
Use different Meta description tag for each pages.
How to Better Use META Keyword Tag

Keep 100 to 250 characters to get better results.
Start with the most important and then proceed to less important. Do not provide more than 5 or 6 keywords here.
Use keywords or Phrases related to your niche.
Do not repeat any word more than 3 times.
Do not place repeated keywords close together.
If your site has content of interest to a specific geographic location be sure to include the actual location in your keyword Meta.
Use keywords that are actually on the page and reflect the essence of your content.
Try to use keywords in your Meta keywords tag with comma, not by space.
Try to use small case in keyword/phrases
(eg: replace the keyword phrase – “Website Design” with “website design”)
Strive for 4%-10% keyword density.
Spider Friendly Navigation

Tips on Creating Spider Friendly Navigation

Use keyword/phrase that best describes the target page.
Always use your primary keywords in the link text least one or more on the page.
Try to place your primary keywords at the starting of a link text if possible.
Try to use Title Attribute in the text links.
eg: The link label goes here
Avoid using image maps, if needed make it sure to add text links at the bottom of all pages
Do not use long text; limit 40-50 characters in a link text.
Avoid using JavaScript links
Create text links and use a common navigational menu for all the pages.
Make sure the pages on your site to be linked to one another, especially the home page.
Try to include a Site map if you have more than 30 pages. ( Google XML sitemap is one of the best sitemap generator plugin for wordpress )
Submit an XML site map to Google, yahoo,Bing and other major search engine.
Limit the number of links per page to less than 20 for better results.
If your Website using Flash, make it sure to add text links at the bottom of the page as a supplement to the Flash navigation. (Google now takes links from Flash)
Try to use keyword phrases in the HTML and image file names
Keep your file names hyphenated (eg: http://www.make-money-online.htm)
Bad practice:

click here
Money
Good practice:

List of hotels in New York
Make Money Online Games
Increase Link Popularity

A Good optimized Website with higher link popularity will always rank higher in the search engines as compared to other having poor link popularity.

Tip to increase Link Popularity

Try to get reciprocal link between the site having same interest or same type of business/Industry.
Incoming Links should use your keywords. Whenever you are trying to exchange links use your keywords as the title of your Links
Links to others with higher page rank. You can use Google toolbar to check page rank information of any website.
Include your reciprocal page link from the main page of your website.
Avoid using link text such as “Links”, “Link Exchange” Use “Resource”, “Sites to watch”,” Friends and Partner”,”Networked Sites”
Try to build Link categories which best match your keywords or your site
Do not Provide more than 20 links per page, if required split them into pages.
Try to use brief information along with each outgoing links
Find out relevant blogs and forums without software, Post good comment on these sites to get some quality back-link to your site .
Some Useful General Tips for Search Engine Optimization

Make sure your website is complete in all aspect, Spell check , online before submitting to all the major search engine.
Try to include robot.txt , so that crawler should not index unwanted directories.
if a site was developed in some other language other than HTML like flash. Make is very sure crawlers have some static information to index. This static information must contain your vital keywords
Try to register your site in Dmoz if it is not already registered there.
Read each Search engine guideline exclusively and follow them strictly.
Use relevant meta tags in all the Pages
Use a proper keyword density checker software for your website pages. if these are HTML based then use SEO software like IBP ,WebCEO, if your website is based on wordpress YOAST SEO is highly recommended.
If you are using FRAMES, try to include tags with keyword rich contents in the main page.i,e the page contains .
Keep your all contents in the root directory if possible. it will be easier for the crawler to search and index and also takes less time to load.
Don’t use image links in the main pages. if anyhow used make use of ALT tags properly. Alt tags must contain your desired keywords.
Do not try to cover too many topics on the same pages. it dilutes the relevancy of your main keywords.
Try to include your company’s physical address on the main page, if possible include a Telephone Number.
Make Sure your home page must load in less than 6-8 seconds. Install Google Page speed to check your Landing page Loading time and some general suggestion to improve it.
Optimize your Images and try to keep it as low as possible. Smush-it is a popular wordpress plugin to optimize your webpage on wordpress Plate-form.
Don’t include more than 100 outgoing links from your home page.
Try to use CSS and always call them in tag.
Use Longer or plural versions of your keywords also wherever .possible.
Try to register your domain name with your targeted keywords or phrases separate keywords with hyphens.
Update your important pages on regular basis.
Check your pages for broken links properly and try to fix them if found anyone.
Use relevant Images for your webpage. A relevant image can increase the value of your webpage. Try to include at-least one Image per webpage with proper ALT tag.. Un-relevant Images can also tarnish your well crafted webpage.
Common Mistakes to Avoid on your website.

Strange color combination that make is really hard to read your contents.
Too small or too Large fonts on your web pages
Unrelated advertisement on your webpage- that can distract your viewer/reader.
Hidden text ( The text which match the background of your webpage color and does not appear or unreadable)
Instances or 5 or 6 keywords that reappear in a row.
Submitting to your website to FFA sites.
Duplicate Pages, doorway pages and cloaked pages.
Redirection from home page to other.
Automated Submission of your websites using some sort of software.
Submitting your site more than once in a month.
Keyword stuffing in comment tags, Meta keyword tags and ALT tags.
Participation in Link Farms.
Use of tag in HTML header.
Using Trademarks or Company Names belongs to others in your Meta tags.
If you Think all these things you can not handle easily and want a simple SEO software to streamline your on page optimization task, We highly recommend IBP and WebCEO. If you are running your site on wordpress, I personally recommend SEO Pressor.

These are some of most common On Page Search Engine Optimization tips and tricks. If you are ready to follow these tricks on your upcoming site or existing site. I am 200% sure you are going to rank your desired webpage on the first page of major search engine and will also receive a lots of targeted traffic.

If, I have missed something in this Tutorial or left something, Please correct me dropping message at the bottom of this post. I will be highly thankful to you.

Google Adsense Tricks:Get Approval In Just 2 Days

Published by:

Just creating the blog and writing articles will not earn you money from internet. Placing ads and affiliate marketing helps you to earn good from your blogs and that too with no investment. Just attract more visitors or readers to your blog and earn good amount from your web property. But now a day Google is very strict for the approval of google adsense account and other all revenue sharing ads programs are not so successful as adsense. People are trying hard to get approval from adsense but are not able to do so. In the start i had also tried for 3 times but all time my application was rejected.

After that i found 2 tricks to get Google adsense approval in just 2 days and that too with no need of website. So i thought to share the same with all and help all to generate revenue from their blog. You have to just follow few steps and then you get google adsense approval in just 2 days.

Trick 1:
Just follow the below mentioned steps and you will get adsense approval in just 2 days.

Go to http://www.flixya.com. It’s a Video sharing website.
Register your account there and share at least 3 videos or PPT Presentations. Create blogs and share your articles from that blogs, also share some images and photos.
Then when you create your profile on this website you get a new form in the 2nd step, i.e. the google adsense registration form. Enter a valid email address to open a adsense account. I prefer gmail for better results.
After you sign up it gives you a publication Id and then after 2 days your account will be approved.
This is one of the tricks to get you google adsense approval in just 2 days.

Trick 2:
If you do not have any videos or PPT presentations to share on the above website then i have another trick to get you approval of adsense in just 2 days. You have to just follow the mentioned steps and that all done.

You all may be aware of Indyarocks, the 1st step is to go to http://www.indyarocks.com/ and register a account with them.
After you register sign in to your account and click on earning link on the right sidebar in your profile.
Indyarocks is a channel partner with google adsense which helps you to earn revenue with them by sharing and creating blogs. But you need to satisfy their following conditions for adsense approval. Note the below mention conditions of indyarocks to be full filed for adsense approval.
Your Profile must be at least 80% complete.
Your profile privacy should be set to everyone.
You must upload at least 10 photos to your profile and the privacy of the photos must be set to everyone.
You must post at least 2/3 blogs and the content must be unique and the privacy of the blogs must be set to everyone.
Just statisy these above mentioned conditions and then apply for google adsense account from indyarocks, you will get a confirm approval in just 2 days.

Hope you all may benefit from the above mentioned tricks and get approval of google adsense account in just 2 days and earn a good amount from your web property. [original work of nikhildaiya of http://www.expertseoguide.co.cc/ ]

Easiest Way to Find Relevant blogs and Forums- without Software

Published by:

Every webmaster/blogger or link building professional wants relevant blogs, forums and all the other related sites on a particular keyword/ keywords to create link, but don’t know how to find them, A lost of companies promise SEO Software to do this simple task.

Google is always there to help you but a lots of people don’t know How to use Google and how to put a proper query in Google to get their Desired results.

No blah blah…. come to the point, Direct Solution.

How to Find Relevant Forums

KEYWORDS “powered by phpbb” inurl:/forum
KEYWORDS “powered by vbulletin” inurl:/forum
KEYWORDS “powered by smf” site: /forum

KEYWORDS “powered by phpbb” inurl:/community
KEYWORDS “powered by vbulletin” inurl:/community
KEYWORDS “powered by smf” inurl:/community

How to Find Relevant .edu forums

“powered by vbulletin” site:.edu
“powered by phpbb” site:.edu
“powered by smf” site:.edu

RELEVANT blogs that allow comments

KEYWORDS “powered by wordpress”
KEYWORDS “leave a comment”
KEYWORDS “reply to post”
KEYWORDS “leave comment”

RELEVANT blogs that allow comments with keywords as anchor text

KEYWORDS “this site uses keywordluv”
KEYWORDS “this site uses commentluv”

How to Find .edu sites that allow comments

KEYWORDS “powered by wordpress” site:.edu
KEYWORDS “leave a comment” site:.edu
KEYWORDS “reply to post” site:.edu

9 Business Plan That Guides Your Success

Published by:

Writing a business plan isn’t optional just because you consider this simply a home business. You are a small business owner. A written business plan is required to secure finances or investors in your new home business. Starting a home business with your own funds and ideas doesn’t mean you don’t need a business plan.

A written business plan is critical to every home business. The thought process and research involved in writing your business plan will reveal the blue print for your home business.

There are numerous paid and free business plan products that you can use to develop your own home business plan. Unless you are seeking investors in your small business, you can learn how to write a business plan that keeps your business working toward your goals. To have a well written small business plan, you will find your goals easier to reach and keep track of your progress both with building your customer base and sales.

Starting a home business without a writing a well thought out business plan is like building a house without a blue print to guide you every step of the way.

Your home business foundation built on these eight areas will give your business a strong identity and focused sense of direction to help you plan and manage your business effectively.

Tip #1 Business Summary.

dropBox

Check out the Landing Page of Dropbox.com and You will find that they have crystal clear vision about their vision and marketing plans and everything they want or offer.

Write out a description of your business. What kind of company do you want to build? A well written description or summary of your business often propels you through each step of how to write a business plan.

Writing the summary first means you will always have the basic premise of your home business idea at the top of everything you put in your business plan.

Tip #2 : Name Your Business.

business name

You may think that your direct sales business already has a company name but that is not the name of YOUR business. Creating a distinct name for your business will help make your plan. Before Naming your Business name answer these questions

Does your business name reflect what you offer? Just as i mentioned in my previous image DropBox, EverNote are some Good example.
Is it easy to remember? Google, Yahoo, Ask Simple easy to remember and also qualify the 12 criteria of a Good domain Name.
Does it have strong branding potential? It all depends on the type of service you have in your mind or how much you want to expend in future.
Should you reconsider your current business name if it not working with your product?
Recommended Avoid
Words That are difficult to pronounce.
Words That Can be pronounce in several ways.
words from a Language foreign to the target market.
initials or strings of
Recommendation
Combining relevant words : Combining two or more words that define your business can produce an original name. Good Example Travelocity, BhartaMatrimoney.com.
Paining an Image : Just like pepsi and cocacola has. These two does not fit anywhere in the criteria still have a Big Name. – IMAGE
Using Prefixes and word Segment : Combined words can convey a message. Using common prefixes or suffixes.
Make sure the name of your business fits not only your product or services but your mission statement.

Tip #3 : Itemize Your Products or Services.

Write out descriptions of your products; how do they look, smell, taste, feel or how your services will help others reach their own goals in life.

A typical product listing of Samsung Galaxy Tab on flipcart.com

NoteDown Specification

How will your offerings improve the lives of others? Sort through why others aren’t already doing it and if they are offering exactly what you are going to offer then what prevents the competition from doing it better or more cheaply than you are.

Tip #4 : Mission Statement.

a-good-mission-statement Your mission statement is a concise clear summary of the goals of your business. In your mission statement, you will define exactly what your business does, the products or services offered and what makes your business unique above the competition.

Writing the bottom line of your business goals into your mission statement will guide the rest of your business plan.

Tip #5 : Business Assessment.

A major portion of your home business plan is a detailed assessment of four areas: your strengths, your weaknesses or limitations, business and marketing opportunities and threats or barriers to your potential success.

At this stage of your business plan, you will be looking at your industry. Your work experience and talents that will add to your business would fall under your list of strengths.

Your lack of knowledge or funds could be listed as your weaknesses. Take into account how broad your industry is when you are looking at your strengths and weaknesses. If you have little money for start up then you will need to be creative in your marketing and running your business.

Will your weaknesses mean your opportunities for success are limited? Will your talent surpass your lack of funds?

Opportunities for business growth may be dependent on your networking contacts or website design. Every business owner should remain wary of all threats to business success.

Planning for problems before they arise will make running a business easier and more successful in the long run. As you can see this aspect of business planning is critical to all of your vision, your mission statement, your goal setting and running your home business.

Tip #6 : Goal Setting.

Write your vision for your business. Be specific. You can revise this as your goals and mission changes. How do you envision your business a year from now then five years from now? Write out your goals and objectives. Break down each product or service into their own set of goals. Plan for expansion as your business evolves.

Goals are useless unless you can measure your progress towards them and plan to regularly assess which goals have been met or still need to be fulfilled. Make your goals specific and time sensitive. With each business goal, itemize what needs to be in place to reach each of your goals.

Outline what steps you will take to reach the goals for your home business. Mark your calendar when its time to re-evaluate your goals and re-align your vision for your business to match the direction your business is going.

Celebrate when you reach your goals and regroup when you realize you missed the mark. It’s important to decide what you consider to be a major loss and what you will accept as unsuccessful. Knowing what you will accept and absorb as a business loss before it happens will help prepare you for when it actually happens.

Tip #7 : Target Market.

Research your desired target market. Identify who you expect to buy your products or services. Write a profile of your average customer. You need to know your target before you are able to aim.

Study your potential customer’s behavior.

Where do they shop?
What do they read? Do they move in specific social circles?
Who wants or needs your business?
Who will benefit from your product?
What type of people will find your business a necessity?
You cannot expect to fill a need or desire of a customer if you do not know what makes your offer unique and necessary. Look at those that offer similar products with success. Write out how you can rise above and differentiate yourself from the competition. At this stage of your business plan, describe how you can stand out from the crowd.

Write down how and why your company is better than the competition. Study the competitions latest marketing strategies then outline here how you plan to counteract their business moves to give you the edge you need to stay unique and effective.

While studying your customers and competition, take the extra time to identify complementary products or services that may fit your current business plan that may give the edge you need to compete in the future.

Tip #8 : Sales and Marketing Strategies.

How will anyone know your business exists? What steps will you take to make your business known? How will your customers find you? What can you do to ensure that you attract the customers you seek? How will you track your efforts? How much money do you have to put these strategies in place?

List your strategies – press release, printed catalogs, business cards, open house, craft fairs, business, conventions, virtual expos, sales letters, etc.

Determine whether you will market exclusively online, locally to your warm market or a combination of both. If online marketing is part of your business plan then include an internet marketing plan to include your domain name and host, whether you will hire a professional website designer or do it yourself, your business logo and e-commerce set up.

Tip #9 : Business Start Up.

Determine what equipment and services you will need to run your business to include setting up your home office, equipment, supplies, product inventory, customer record keeping, and book keeping.

Create a checklist of professionals you need to secure for legal and financial advice, advertising expertise, office assistance or tax expertise.

Starting a home business can be exciting and scary because it is Your dream that you are working towards with each work day.

To write a business plan, means a great deal of commitment to the process. The process of writing a business plan will bring you closer to understanding yourself, your business goals, your company identity and reaching your potential customers.

Although these areas are critical to writing a business plan, there is much more that will be added to your plan over time. Each time you reach a goal or discover a barrier to making the sale ~ you will return to your business plan and revise your goals, strategies and techniques.

Business success is in the plan and implementation but also in the ability to adjust and redefine your business goals to meet your customers need or desire while letting you design your home business your way!

How to write a good comment ?

Published by:

To write a quality wise Good comment on a blog or forum, I have some very good tips that can help you to improve back links and administrator will not try to mark your comment a spam, your Good comment will be live.

Good Comment
Why to write a Good Comment

Tip#1 : Write for a Purpose

People have different reasons to write comment ? Try to determine what is yours ….

You trying to get back-links, drive traffic to your website ?
You disagree with someone and want to tell the truth to people ?
You appreciate and want to say thank you for his/her jobs ?

Sometime, understand your motivation will help you decide what kind of comment you will write about.

Tip #2 : Understand Content

When I read comment in blogs/websites , it is of these kinds

Thanks for share that. Great
Thanks. Pretty good
It help me so much

We know people write comment for a purpose and don’t take much time in their comment. They just want to say thank you and leave, they don’t need to think about article content and what is it talking about. These are the comment’s mainly, posted and showing in comment pages.

It’s main reason to delete your comment without confusion. Save your time and comment to tell something useful or just give a minutes to think and write good comment. I know you’re not professional writer, I’m not too. But I am sure you can write better than others people.

Tip #3 : Make Link Carefully

As we are taking above, if you write comment to satisfy your purpose, think carefully before put a link in your comment. Don’t confused to put your link if comment box has a place to put ” Your Website ” or ” URL “. But, if there are no where to put your link, put your link into body of comment.

Tip #4 : Links are Risky ?

If you’re moderator or owner of blog/website, whenever you see a comment, short comment with irrelevant links , do you delete it ? I am sure I’ll remove it and and report as spam for next time. Many people will write ,follow my way, then beware.

Tip #5 : Grammar and Spelling

Not almost comment editor include spelling checker, you should review your comment before submit. How could you tell to people something when you can not spell it correctly?

Tip #6 : Tell More

We understand, short comment is okay and almost of it will accepted by site owner. You say ” thank you ” , ” love it ” or ” pretty good “. Just tell a bit more to people why you like it ? It will make more good point to your comment.

10 Best Article Submission Software, easy Link Builder

Published by:

Article Submission Software : Do you want to submit your article on thousand of article directories and blogs, But Don’t have time to do this submission manually, and wondering how these famous blogger are able to present their article on thousand of article directories .whether they are using article submission services ? No, not at all , they are Not using any type of article submission services, They use article submission Software.

Here are some of the best article submission software available on the internet to solve this problem and will also bring back a lots of back-links and targeted traffic to your site.

1. Quick Article Submitter

Quick Article Submitter is a user friendly article submission software that submits articles to more than 400 directories and regularly adds more sites to its database. It now submit your articles in minimum time with advanced functionality like Auto Submit and Scheduling of submission.

It enables you to check your article submission status and single out important directories by adding them to the list of favorites. Discover the power of having your article and content instantly indexed and crawled by search engine spiders when it is published on thousands of websites!

Download: Quick Article Submitter

2. Yoobids Article Submitter

Article submitter does not just allow you to load in 500 articles and hit a button a forget it. Any software that promises this is doing nothing more then spamming your articles all over the Net. Article Submitter software stores all of your personal information, resource box, and articles. It then will proceed one at a time to go to each of the articles sites for you, log you in and auto fill all of your content including your name, your article, your author resource box, even an article summery on any sites that ask for it. You will then need to manually select a category–this is the only real way to make sure your article ends up in the right place when we are talking about 163 article sites. You then click the submit button and boom… you have just submitted another article and it appears totally manual and natural to the article directory owner which is a must if you want your article to actually get published. As you can see, my Article Submitter is everything you need to start driving insane traffic to your Web site using the magic of free articles.

Download : Yoobids Article Submitter

3. Article Submitter

The Article Submitter SEO software provides these advantages like easily submit your content to multiple article directories. No more hand editing to meet different guidelines. Always have an up to date list of article directories. Save time by automating all phases of submission. Let’s you focus on writing content, not submitting it. With Article Submitter you can easily submit your content to over 500 article directories. With the click of a button, the software starts publishing your content. You won’t even have to get on the Web, submissions are all automatically done in the background, while you get back to work. Now with unique automatic updates.

Download : Article Submitter

4. SEO Suite

SEO Suite is the latest, high level state-of-the-art search engine optimization(SEO) management tool especially designed for SEO consultant to manage SEO campaigns in a large scale. All the functions you will ever need to optimize and get your Web site ranking higher in all major search engines include Google Yahoo and MSN. The features include Web site Optimizer, Search Engine Submission, Meta Tag Generator, Engine Builder, Froogle Submitter, Page Rank Checker, Link Analysis, Article Submitter, Reciprocal Link Creator, Link Partner Manager, Web Ranking Analysis Reporting, SEO Project Management & Reporting, and Network Support.

5. Best Free Article Directory Submitter

Millions of peoples are trying to get traffic to their websites and spending lots of money in this. Submit article to article directory is a good and popular way of getting SEO and traffic to website.There are lots of paid article directories available in web but a very few free. This software give you chance to submit your article to world’s best free article directory article. ognilab.com totally free of cost.

Download : Best Free Article Directory Submitter

6. Article Marketing Monster

Powerful mass article submitter software to submit your articles to top article directories include EzineArticles.com. The software lets you register for all article directories without actually having to go there. Easy sign up and submission process allows you to submit your article to all directories in 1 minute.

Download : Article Marketing Monster

7.Article Submitter Standard Edition

Article Submission Software Standard Edition helps to boost up 1-way links. EPractize Labs SEO Article Submission Software manages articles, generates RSS feeds, manages login and submit by submission wizards. It’s easy registration by registration wizard. One click submission by submission wizard. It’s Easy to communicate by email follow-up wizard. Our article directory database grows on a daily basis and now consists of more than 400+ titles of top ranked article sites. We constantly update our database to remove from the submission list all sites that are either obsolete or not do not correspond to our standards.

8. Article Submit Auto

Article submit pro comes with fully automatic submission engine. Fill up the forms and just forget about it. It automatically fill your selected article on High PR sites, blog and article Directories. Even can also spin article for you, Easy to learn and master.

9. Article Post Robot

Article Post Robot developers have recently upgraded their software, adding more features and article directories to it. Now, it can submit to more than 400 free article submission directories. As usual, you can do so either automatically or manually. Our preference is for automatic submission whenever we use it as it runs quietly in the background, posting to each article directory with precision in the article format and category. We find the way they organize the article submission software systematic, very simple to use and yet robust enough to handle so many submissions in one breathe. Article Post Robot also submits to Yahoo Groups and there is about 50 over groups built-into the software. This gives your articles a wider exposure and distribution network to reach more audience.

10. Instant Article Submitter

Instant Article Submitter is similar to Article Post Robot in the sense that it also allows automatic submission. The article submission software takes your article and submits it automatically to 200 over article directories and major publishers. It also has a function that allows for scheduled submission and a spelling checker to ensure that your article is free from errors. They also come with free software called Instant Article Creator that would assist you to write powerful and convincing articles within minutes.

15 Best SQL Queries For WordPress Database Administrator

Published by:

Do not run these SQL queries before taking the backup of your current database. How to take backup of you wordpress database is covered here in this tutorial.

To take backup of your Database you can use WP-DB-Backup or WP-DBManagerplugins from the wordpress plugins repository. Alternatively you can use phpMyAdmin

An easy way to run any of the queries below is to use phpMyAdmin.  phpMyAdmin is one of the most common database look-up and editing tool. Almost all the web hosting services’ control panels provide this. There is also WordPress SQL Executioner – a WordPress plugin that allow you to execute your SQL query.

General Purpose

Change Default Administrator Name

By default every wordPress installation creates an account with a default “Admin” username. This is wide spread knowledge, everyone who uses WordPress knows this. However, this can be a security issue because a hacker can use brute force your WordPress admin panel. A different default “Admin” username, means additional security.

Solution:

UPDATE p_users SET user_login = 'NewName' WHERE user_login = 'Admin';

How To Reset User Password

Forget your wordpress password or want to reset your password in WordPress, and do’t want to use password reset.php file to upload on your server.

Solution:

update wp_users set user_pass =md5(‘newpassword’) where user_login=’yourusername’);

How To Delete Post Meta

Installing or removing plugins is a very common task for WordPress. Some of the plugins make use of the post meta to store data related to the plugin. After you have removed the plugin, those data are still left inside the post_meta table, which will no longer be needed. Run the following query to clean up the unused post meta value. This will help to speed up and reduce the size of your database.

DELETE FROM wp_postmeta WHERE meta_key = 'plugin-meta-key';

How To Delete All Pingback

Some wordpress administrator does not like pingback on their blog. Suppose now you have disabled pingback on your wordress blog. but what about your stored pingback, There is no method available in wordpress to delete the records. Here is the solution from SQL queries to fight this menace.

Solution:

delete from wp_comments where comment_type=’pingback’;

Delete All Spam Comments From The Database

Spam comments and wordpress are two inseparable terms. Doesn’t matter how many methods you apply to fight spam, they will come up every time. So how to delete all these comment from the database use SQL queries

Solution:

delete from wp_comments where comment_approved=’spam’ ;

Delete All Trash Comments From The Database

There are simple methods now available in new wordpress 3.0 onwards , if you are still feel comfortable with SQL queries . Issue the following command and delete all  the trash comments form the database forever.

Solution:

delete from wp_comments where comment_approved=’trash’ ;

How To Remove Comment_agent

Comment agent is used to hold information of the commentator’s browser , operating system etc, most of the time this is use less, so how to remove this unimportant data from the database

Solution:

update wp_comment set comment_agent =’ ’ ;

How To Delete All Revision Posts From The Database :

When ever we revise any post on our wordpress blog it creates a same copy of the post with it’s post type as revision. The original post which is now current does not require all these post to show your current post. So if you have revised an article 20 times., it means your post has been saved 19 more times, Thus increase a lots of web-space on your server.

Below listed SQL query  will delete all the these revised posts from the database. leaving your original ( Latest ) contents

Solution:

delete from wp_posts where post_type=’revision’ ;

How To Find Out All Unique Email Address

Over a period of time, your blog will have received many comments. These comments will include the email addresses left by the commenter. You can retrieve all these emails for your mailing list without any duplicate.

select DISTINCT comment_author_email FROM wp_comments;

How To Identifying Unused Tags

In a WordPress database, if you run a query to delete old posts manually from MySQL, the old tags will remain and appear in your tag cloud/listing. This query allows you to identify the unused tags.

Solution:

SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy=’post_tag’ AND wtt.coun

Migration Specific SQL Queries

How To Change SITE URL  And HOME URL

WordPress stores the absolute path of the site URL and home URL in the database. Therefore, if you transfer your WordPress site from the localhost to your server, your site will not load online. This is because the absolute path URL is still pointing to your localhost. You will need to change the site URL and the home URL in order for the site to work.

Solution:

update wp_options set option_value =’http://yourwebsiteurl.com’ where option_name=’siteurl’ or option_name =’http://yoursiteurl.com’;

How To Change GUID

After you have migrated your blog from the localhost to your server or from another domain to a new domain, you will need to fix the URLs for the GUID field in wp_posts table. This is crucial because GUID is used to translate your post or page slug to the correct article absolute path if it is entered wrongly.

Solution:

update wp_posts set guid=replace(guid,’http://oldsite.com’,’http://newsite.com’);

How To Change URL In Post-Contents

WordPress uses absolute path in the URL link instead of a relative path in the URL link when storing them in the database. Within the content of each post record, it stores all the old URLs referencing the old source. Therefore you will need to change all these URLs to the new domain location.

Solution :

update wp_posts set post_content= replace(post_content,’http://oldsitename.com’,’http://newsitename.com’)

Change Image Path Only In Post Content

By default wordpress store absolute path of the relative images and this create a lots of problem whenever we change our server. SO how to change the image paths stored in the post contents

Solution:

update wp_posts SET post_content = REPLACE (post_content, 'src="http://www.oldsit.com','src="http://newsite.com'); The above query only change the source of images not the attachments available with that post, So issue the following query also along with the above one.

UPDATE wp_posts SET guid = REPLACE (guid,'http://www.oldsite.com','http://newsite.com') WHERE post_type = 'attachment';

Update/Change  Post Meta

Post meta is also stored as the same way as your post image and other URLs ie, absolute path, so change them according to new website address

Solution:

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value,'http://www.oldsit.com','http://www.newsit.com');

Though, I have tried my best to collect these SQL queries to help wordpress administrator/webmaster, if you find any problem or better solution for these aforesaid problem, kindly drop your message here so that we can update.


Tags: , , ,