Web Application For Managing SQL Server data

Web application for managing SQL Server data


• Insert, Update, Delete records


• Map referencing columns for easier record editing


• Quick record search


• Execute any query against database

Find demo:

http://databaseclient.blogspot.com/

How Above The Fold Ads Reduce Google Traffic

This article is written for bloggers and website owners who have lost significant number of visitor on the beginning of 2012 year or finding their traffic reduced after adding large block of ads in above the fold area.

On January 19 2012 Google announced change in their algorithm. This change affects the web sites and blogs which have too much ads in the above the fold area. Change is called "page layout algorithm". Google check how much content is placed above the fold area. More content in above the fold area, better.

Why Google check above the fold area

The reason is complaints from users who have difficult to find the actual content and must scrolling down the page. Users want to see content right away, not bellow tons of ads. So Google wants to improve user experience.

Which sites will have traffic reduced?

• Google "page layout algorithm" does not affect sites which place ads above-the-fold to a normal degree


• sites where is hard to find actual original content


• Google traffic will be reduced for sites where relevant content is pushed down by large blocks of ads


• on sites where only a small amount of visible content located above the fold


• "page layout algorithm" change affects less than 1% of globally searches


• be careful with your header, if it is too big it take precious space and push the contend down

Good tool to estimate do you have content in above the fold area is Google Browser Size. This tool help to understand how much of a page’s content is visible to visitors under various screen resolutions. Type URL of your blog, click Go and take a look does you content is visible for specific resolution.

I learn about this topic from kezanari blog and later one more excellent in depth article at search engine land.

This is how my blog look before I make changes to adapt to push up content in above the fold area

Click on image to enlarge:

My blog traffic was reduced after "page layout algorithm" started. This image above was taken with the help of Google Browser Size.

From the image we can learn:

• Only 90% of visitors will see content title ("How To Send Money Online") without scrolling down. So 10% of visitors will have scroll down to see title.


• Only 80% of visitors will see content title and first sentence without scrolling down


• 70% of visitors will see content title and first two lines without scrolling

After adjustment to avoid Google traffic reduce

Click on image to enlarge:

When you enlarge image and look carefully you can conclude that:

• 99% of visitors will see the title and first two lines of content


• 98 % of visitors will see the title and fist three lines of content, "sending money online" is last sentence they will see


• 95% of visitors will see the title and fist six lines of content...

This is example of my blog which will not get Google penalty from "page layout algorithm". But this is my blog after I make changes on layout to move content closest to above the fold area.

Reduced Google traffic on my blog

My blog had significant traffic loss after January 19 2012, around 25% loss in pageviews. Also, I noticed fall of PageRank on some pages on my blog. I believe this reduced traffic is a result of "page layout algorithm".

Click on image to enlarge:

When traffic will be restored

When reduced traffic will be restored and google penalty removed? Unfortunately not immediately!

If you fix a problem (reduce the number of Ads in above the fold area) Google will make note on first re-crawl. But penalty on site will be removed after several weeks.

It can take several weeks for Googlebot to crawl and process enough pages to reflect layout changes on the site

My intention is to follow the traffic and to update this article after traffic will change.

Please do comment and leave your opinion and experience with "page layout algorithm".

How To Send Money Online

Recently I created account on PayPal and tested next two features:

• sending money online


• create and use buy now button

In this article I will briefly explained how sending money and buy now button works, how much does it cost (fees) and who is paying fees.

Send money online with PayPal

To send money with PayPal first you need to login on PayPal service. Of course if you are not registered on PayPal then you should Sign Up first.

Choose Send Payment tab.

In next step you need to:

• 1. Type Email of recipient


• 2. Enter Amount of money you want to send and currency


• 3. Choose whether your online sending money is Online purchase or Personal payments and check exactly purpose. For Online purchases it can be: Goods, Services or eBay items. For Personal payments it can be: Shared expenses, Payment owed, Rental charges or Others.

How much does it cost to send money online with PayPal

When you use a credit or debit card, you will be charged with 2.9% of the total amount sent plus $0.30 USD per transaction.

I make a test and try to send payment of $1 to PayPal account in same country and was charged with $0.33.

$0.30 USD per transaction
$0.03 USD as 3.1% of total amount
Total: $0.33 USD fee

Create and place Buy Now button on your site

With PayPal you can easily create Buy Now button. From PayPal site you can generate HTML code for Buy Now button, place this button on your site and start to sell to your visitors. You can sell material goods and send them using standard delivery or sell services and digital goods (e-books for example).

To find out how to make Buy Now button visit How to sell an ebook with paypal.

How much does it cost to sell items with PayPal Buy now button

For a testing purpose I make one Buy now button and put a price of $1 USD. My friend was making a purchase for $1 USD. He (buyer) doesn't need to pay any fee.
In this example seller received $0.67 USD
Fee is $0.30 USD per transaction
plus $0.03 USD as 3.1% of total amount.

There Is No Donate PayPal Type Button

How to add donate button on my site or blog?

And one more question

I have PayPal donation button on my site but when someone try to donate to me money he get message: "Your recipient is not able to receive funds at this time. Your recipient must first set up his or her account to receive funds."

I tried to create Donate PayPal button but I didn't fund option to create Donate button anywhere on the PayPal account when I was logged in. It should be at
My Account --> Profile -- My selling tools --> PayPal buttons --> Update --> Create New Button
but there you can choose only Shopping Cart, Buy Now, Gift certificates or Subscriptions button type. My PayPal account type is Premier.

Why Donate button type doesn't exists?

Because word "Donate" is reserved for a charity and Paypal doesn't allow Donate button in some countries (usually it is due to local legal/tax requirements incompatible with PayPal's mechanism).

How to add Donate button

On internet I found advice to go on:

https://www.paypal.com/us/cgi-bin/?cmd=_donate-intro-outside

without logging in. Then I create donate button, copy HTML code and paste it on my blog. Donate button appeared on my blog.

When I ask my friend to try sending me some funds for testing purpose he get this error:

"Your recipient is not able to receive funds at this time. Your recipient must first set up his or her account to receive funds."

Cause of this error in my case is PayPal does not support Donate button for some countries, in this case PayPal doesn't support donate button for my country.

Solution for "Your recipient is not able to receive funds at this time" error with Donate button

You can solve this problem with choosing Buy Now button type instead of Donate button type. PayPal says:

We can't quite recommend using "buy now" button to accept donations, but from technical perspective it should be working correctly. Such transaction will also show as purchase on the donor's account and credit card statement, which may be confusing.

So, they tolerate this approach, it is not perfect but it will do.

I will not going in details how to generate PayPal Buy Now button. Here is an excellent link which in details describe how to make your own Buy now button step by step with images : How to sell an ebook with paypal.

What is AdSense CTR, RPM and CPC

After adding AdSense ads on your site you want to find how successful is your AdSense combination placement with a help of performance AdSense reports. To analyze AdSense reports first you should learn what abbreviations like CTR means.


Here we will discuss most important AdSense report indicators like:

• AdSense CTR (Click Through Rate)


• AdSense RPM (Revenue Per thousand iMpressions)


• AdSense CPC (Cost Per Click)

What is AdSense CTR (Click Through Rate)

AdSense CTR (Click Through Rate) is the number of the ad clicks divided by the number of page views.

CTR = (Number of ad clicks * 100) / Number of page views

If my blog have 10,000 pageviews per month and 40 AdSense ad clicks then my CTR is 0,04%.

CTR = (40 * 100) / 10000 = 0,04%

Higher CTR (Click through rate) more AdSense ad clicked means more earnings. So every AdSense publisher want higher CTR.

How to calculate CTR for whole page

When you calculate CTR (Click Through Rate) for whole page or site you should sum up CTR for each individual ad. For example, if my site have two ads, one ad have CTR 0,15% and another ad have 0,25% then my site have total CTR 0,40%.

When you calculate CTR for whole page you could get all ads on your site not only AdSense ads.

What is a good or bad CTR

It is not easy to tell what is good or bad CTR. Click through rate (CTR) depends on specific niche, type of site, design of site and many other factors.

Important is to find your current CTR and keep an eye on CTR during time when you make various action to increase your CTR. Ad placement have great influence on CTR, so try to optimize your ad placement. After you make changes on ad placement keep track how it affect on your CTR. Something similar to my article: Increase blog adsense revenue real case scenario.

To help with AdSense CTR benchmark I will give information what I consider as good or bad CTR:

• under 0,10% - it is bad CTR, my blog have this CTR before any AdSense ad placement optimization


• 0,10% - 0,20% - it is acceptable CTR but it can be better


• 0,20% - 0,30% - it is good CTR


• above 0,30% - excellent CTR


• above 2% - by some sources on internet it is suspicious high CTR

Please, leave a comment about CTR on your site and your opinion what is good or bad CTR.

What is AdSense RPM (Revenue Per thousand iMpressions)

Page revenue per thousand impressions (RPM) is calculated by dividing your estimated earnings by the number of page views you received, then multiplying by 1000.

Page RPM = (Estimated earnings / Number of page views) * 1000

This is good indicator to estimate your earning in future, for example if your RPM is €1,12 then you can predict if you will have 15,000 pageviews your earnings will probably be around €16,8 (15 * €1,12).

What is AdSense CPC (Cost Per Click)

The cost-per-click (CPC) is the amount publisher earn each time a user clicks on his ad. In publisher reports, CPC is calculated by dividing the estimated earnings by the number of clicks received.

For example if your CPC is €0.26 then you need around 285 click to earn €100.

Make a blog plan for next year

New year 2012 is come. It is time to evaluate how my blog is doing in 2011 and to think about actions for improving blog results in next year. In first part of this article I will show some blog statistics in last year and in second part there will be a list of planning blog activity I intend to do in new year.

How successful was 2011

To better describe 2011 year there will be shown:


• number of visits per year


• AdSense blog earning per year


• traffic source overview


• a few words about guest posting

Number of visits per year and next year expectation

In the image below is showed number of visits in 2010 and in 2011 year. There is growth of 79 percent for 2010 to 2011 or 42260 new visits. I am satisfied with this result and hope that on the end of 2012 I will get at least 42260 more visit (in this case sum will be 138.876). Or even better if growth will be 79% in 2012 I would have 172.227 visits.

AdSense blog earning per year

AdSense earnings in 2010: 11,49$

AdSense earnings in 2011: 112,61$

My AdSense earning raise much more than traffic. While traffic increased about 2 times, AdSense earning raise 10 times. Why?

Well, one reason is that I optimize my AdSense placement and type. In article Increase blog adsense revenue real case scenario you can find more details about my attempts.

Traffic source overview

My main traffic source is Google 89%, and 10% my blog get from direct traffic. In my opinion it is good to get lot traffic from search engines but I believe that my blog can get much more traffic from referring sites and I intend to work on it this year.

Guest posting

In this year my blog reached PageRank 3 for two months and fall again on PageRank 2. In that period I used myblogguest service and get more than 30 guest posts. Unfortunately those guest article bring me very little traffic. In my opinion those guest posts are not bad but are written without proper keyword research and on page optimization techniques.

Blogging plan for this year

In this year I plan to:

• get more SEO driven traffic to my blog


• make a blogging tribe as described in article Increase website traffic - tips from the best


• improve blog structure - plan to make a few main sections pages which will lead to content pages of some topic (section). Something similar to Javascript effects tutorial. Links to those main section pages will be on main page of my blog


• improve monetization of my blog - plan to try with buysellads.com service. Unfortunately they do not accept blogspot subdomain so I will think about changing domain name


• prepare exact instructions for guest posting on my blog and put a visible offer for guest posting on my blog


• try to buy articles with earned money using a site www.freelancer.com


• publish some guest posts on A blogs. This is great way to reach audience.

Increase website traffic - tips from the best

How to increase website traffic? Many bloggers ask themselves this question and struggled to find the answer.

A few day ago I bumped on interview with Ana Hoffman on Michael Alexis site. In this interview Ana described her way of generating more and more internet traffic.

After a few minutes of interview I figured out that this interview is very helpful and give some new ways (unknow to me) of generating blogs traffic.

Why Ana Hoffman opinion is relevant?

Recently, I visited Ana blog trafficgenerationcafe for the first time. My first impression was that it is quality blog which stand out. This blog currently have Page Rank 4 which is good, but Alexa rank is around 8500. According to Michael Alexis, Ana started her site 1,5 year ago. In this light Alexa rank at around 8,500 is amazing achievement.

So, I believe that Ana is authority and her interview have real value based on two facts:

• Ana blog is interesting for reading


• her blog achieved high Alexa rank in only year and half

How to increase website traffic interview with Ana Hoffman

Original interview length is over one hour and you can find it by following the link on the beginning of this article. Here are interview notes I make and decide to share in this post.

How to pick a niche

• become authority in a niche, when you one become authority it is much easier to generate new traffic


• to choose a niche you have to find something that is in demand


• to succeed you must have passion for business, if you have passion only for niche it is not enough


• to find topics in demand you need observe and reading other blogs, comments and forums, find what a people want to learn more about


• pick a niche you have knowledge about, for example if you just start a blog, write about starting a blog not about how to make money with blog because you can't know how to make a money when you even don't have established blog and practically earn nothing


• start from your experience, it won't go to write about something you don't know about it, people will know that you faking it


• you must not just a talk about topic but show you know how to do it (like Ana generate traffic on her blog about generating traffic)


• don't write about topic everybody write, try with different approach from others, put your spin at a topic or different opinion but the most important do something different

How to establish authority

• there is no secret trick!


• content is very important, also pay attention how you represent your blog and how you stand out


• people have come to your blog and say : "Wow, I never read this before, this is amazingly helpful to me, I must come back!"


• write plainly, write the way you talk


• don't write fancy, do not put too many words in you post


• blog content should be simple and helpful


• you can't do it alone, you need a help of other people


• find blog that share a niche with you, try with established but not most popular blogs (because it is almost impossible to connect with A blog, they have many various proposals every day)


• try to form your own tribe (community) with 15 - 20 other blogs


• try to find a people who are good solid bloggers and a hungry for more attention


• spread a shares and comments on each other posts, with this method you give a life to your blog plus you learn from each other


• comment on another posts builds your brand and recognition

How to find and reach member of your tribe

• identify blogs in your niche


• start commenting on those blogs


• it is better chance to be noticed on blogs that doesn't have too much traffic, for example commenting on CopyBlogger or ProBlogger give minor chances to be noticed


• when you are noticed on this smaller blog send him request for mutually social sharing and commenting


• pick a blogs who have solid content


• keep your group small, up to 20, if a group is bigger it is difficult to control


• you can use facebook group to organize tribe


• if someone in a group doesn't comment or share he couldn't be member of the group anymore


• so, if there are 20 members of the group you will get 20 comments and shares per new post

Find traffic sources

• there are short term traffic (like social media) and long term traffic sources


• social media is just a way to find people who could be interested in your blog


• job for you is not to build relationship with them but to introduce and bring them back to your blog


• find something that works and concentrate on that (Ana is focused on twitter and facebook)


• stumbleupon have low conversion rate


• facebook have higher convert rate than twitter


• choosing right social network depend on niche


• when you find what work for you stick with that


• facebook like widget on your blog can be negative social proof if you have small number of facebook followers

A few words about twitter

• post 4 tweets one after another to make attention, 2 tweets would be links on other blogs, solid posts, 1 tweet a quote because people love quotes, a last one, a tweet to your blog (it will be at the top of tweet stream and chances are that people will click this one first)


• 25% tweets should be self promotion the rest just useful to other people


• it is important to provide a lot of value

Conversion

• pick exactly conversion goal


• put a call to action in post, for example "thanks on coming, now do this please"


• it must be only one call for action per post


• no to popups!!!


• in middle of quality post add this "if you like to hear more, I talk a more abut that with my subscribers" or lead a visitor to other page which have call to action

Two tips for increasing website traffic

• think like a regular visitor, if you are a casual visitor will you stay on your blog and read it, would you even scroll down?


• write a guest post it is best traffic generation strategy

I hope that my interview notes will help you to increase your website traffic. Please, leave comment does tips listed in this article are helpful for your website traffic.

Javascript effects tutorial

Few Javascript effects tutorial links can be found on this page. Learn how to hide HTML element on mouseover with javascript, various javascript image effects or how to change text with javascript on some event (like mouse click or mouse over).

So, here we have:


• javascript visual effects


• javascript image effects


• Other javascript effects

Find links to javascript effect code tips below!

Javascript visual effects

How to add a falling snow effect - learn how to add nice snowing effect on your web page or blog in few simple steps. Following this link more advanced users can also find how to make snow fall with a custom snow flakes.

How to show and hide HTML elements using Javascript - learn how to hide some HTML element (like textbox, div, table, table row) on click or mouse hover with javascript. There are over six samples to better explain how to do it.

Javascript image effects

Dynamically change image with javascript effect - tutorial how to dynamically change image when a mouse pointer is over image (onmouseover and onmouseout).

Or find out how to alternate image onclick with javascript.

Jquery image preview effect - learn how to show image preview when user hover mouse pointer over link.

Moving image on my web site effect - tree samples and guide which describe how to make animate effect to move image through web page.

jQuery image zoom effect - sample and step by step guide how to make zoom effect on your web page, so zoomed portion of image is showed when user put mouse over normal size image.

Other javascript effects

Changing text with javascript - change text with javacript on some event like click the link.

HTML5 scrolling text effect with javascript - how to make animated scrolling text within HTML5 like Marquee with jQuery. In HTML5 Marquee is obsolete.

Basic web effect with jQuery - in this article you can find demos and sample code for basic effect functions in jQuery. There are: hide and show effect, fadeIn and fadeOut (disappearing) effect, slide down and slide up effect and animate effect.

Web page optimization techniques

Web page optimization is a very important thing if you want to have visited web page. How to do it? There are different techniques but in this article we will concentrate on on-page SEO optimization.

To make successful web page optimization you need to:


• find best keywords with keyword research and pick one or two keyword phrases per page


• make a quality keyword placement

On site page optimization

Title tags

The most important HTML tag for Search Engine Optimization. It is very advisable to put your keywords inside title tags. Google search engine crawlers use these title tags as the main source for determining the page topic.

Text inside title tags will be showed in Google search engine result page too. On image below you can see how Google show title in result page for title: "Adding categories to blogspot (blogger) : Useful and interesting web sites". Words from search query are bolded.

Sample for title tag:
<title>Adding categories to blogspot (blogger) : Useful and interesting web sites</title>

Keyword on the beginning of the title have more weight than keywords on the end of the title. Blogspot users can find very good advice in article: Optimize blog - change title.

URL keyword optimization

Keywords in URL have important impact on your Google SERP (Search Engine Result Page) position. To prove this statement let's try type search term "Web page optimization" in Google. First five URL's in Google SERP are:

• www.websiteoptimization.com/services/analyze/
• www.websiteoptimization.com/
• www.google.com/websiteoptimizer
• en.wikipedia.org/wiki/Search_engine_optimization
• www.webpagetest.org/

Tips for good optimized URL:

• URL shouldn't be too long


• Keywords on the beginning of URL have stronger effect than keywords on the end of URL (for example www.websiteoptimization.com/ is better than www.web-source.net/webpage_optimizing.htm). For


• use hyphens as keyword separators in URLs. Blogger (Google's blog engine) use hyphens as separator for URL of particular posts.

Keyword position on web page

Keyword position also known as keyword prominence say :

The closer a word is to the front of the text area, the more relevant or important it is.

So put important keywords on the beginning of the page. Good practice is to use paragraphs in your web page. Use <p> and </p> tags to enclose text in paragraphs and put important keyword at start of paragraphs.

Keyword prominence rule is also valid for titles, URL's, headlines...

Keyword density

Keyword density is ratio between number of time keywords appear in page and total number of words on web page. Recommended keyword density is 2% to 8% by some authors, but it vary depending of source. Be careful too high density can trigger a spam penalty from Google. To find a keyword density for specific page check Page Analyzer.

Keyword proximity

Keyword proximity refers to how close the keywords that make up keyphrase are to each other.
To better explain there is an example:

• A. Web page optimization techniques
• B. Optimize your web page with best practice techniques

The A keyword phrase will make better Google result ranking for search query like "page optimization" as the relevant words appear next to one another and in the correct order. On the other side keyword phrase B will get better result for "Optimize web page".

Advice is to keep keywords together as a unit. When this is not possible, try to keep keywords not too far away from each other.

Optimization and body elements

Heading tag (<h1></h1>)- typically opinion is to be twice as important in weighting terms as regular body text (source Get to the Top on Google). However recent data from SEOMOZ study has shown that it has a very low correlation with rankings.

Image alt Attribute - it have significant impact on keyword web page optimization. So use keywords in alt attribute to describe images on your web page.

Bold and italic tags - it is good practice to use bold and italic tags on your keywords. By SEOMoz bold tag have a minor amount of SEO weight while italic tag have slightly more SEO weight.