Bot Filtering Setting in Google Analytics

A common problem when working with modern sites and tracking them is that there are certain bots and spiders that trigger false hits. Many users seem to be experiencing a similar issue with bots and trying to get and analyze only real traffic. In order to resolve this situation Google has added an option to your View Settings -> Report View Settings which allows you to exclude all hit from known bots. The check mark is located on the bottom area of the setting under the label “Exclude all hits from known bots and spiders”. After this option is selected all hits by IAB know bots and spiders will be excluded by the back end of the Google Analytics platform.

This will give you a real number of visitors on your site. Nestle is one of the companies that started testing it due to some issues they were having and the answer has been very positive. It’s team called it “essential to getting a deeper insight”. We will work with it and give you an update on how this new change allows us to provide you with a better service.

You can view the official post along with others from the Google Analytics+ Account

Are you and your business Yelping?

In the past years the influence created by social media portals across the web on businesses and customers alike is huge and it is only getting bigger. One of the biggest influencers on this growing frenzy is Yelp, a social portal that gives customers/visitors the ability to give any business a rating and review based on a previous experience with the business. Visitors of the portal as well can search for businesses, services and/or products they are thinking of acquiring. With over 4 million visitors per day it’s a great place to gain visibility, however if not maintained it can also be something that can hurt your authority and ability to sale greatly. We have seen for some of our customers that up to 70% of their sales are directly affected by this portal.

When correctly utilized and optimized Yelp can definitively be a tool that can increase your revenue exponentially in a relatively small period of time if used correctly. However, to begin you will have to first and foremost confirm your listing or create a new one using their Business Center. After confirming your listing it is very important to go over each of the sections on your listing and complete them as thoroughly as possible. Get creative as customers are usually looking for someone that they relate to, give them your full story and allow them to meet you even before they contact you. Take advantage of their multimedia tools like adding photos and videos as customers are much more likely to respond if you do. Another very important factor of having a successful listing is staying in constant contact with you customers and to make sure that all of their reviews are answered.

A great and useful tool that they offer for free is the ability to add coupons for your customers. Many times this will increase your conversion rate, and it might just give you that edge as well that you need to beat your local competitor. Another great tool they offer for free is their listing statistics, which are very complete including how many visitors have seen your listing, how many have called your business number and how many have clicked to go into your website.

There are other ways as well in which Yelp can indirectly assist you to get more customers which is by increasing your overall business inline authority. This will assist you in many ways, for example to get better rankings in the different search engines across the web. The majority of times your listing will be listed as well usually higher than any other citations on the SERP’s, this will assist you to create more a more reliable image as they will see your name multiple times one the results.

Let us know how Yelp has affected your business, and what actions you are taking to improve the quality of your listing on the comment section below.

Lesson 1: Introduction to Search Engine Optimization (SEO)

SEO or Search Engine Optimization is the process of optimizing a web page or portal for search engines. ξPeople are now spending 7 times more time on the Internet than on watching TV, what does this tell us as marketers. It tells us that we need to focus into online marketing, in which SEO is a major player. There are four major engines currentlyy on the market. The most important and complex of them is Google, by a far reach.

Search Market Share as of April 2011

  1. Google (65%)
  2. Bing (17%)
  3. Yahoo! (13.80%)
  4. Other (4.20%)

Before I can start teaching you about optimizing a web site you need to understand how search engines work. A search engine is an online portal that indexes and ranks web sites. Users will access the search engine portal to try to find the correct answers to their problems. Answers are created instantly by using a the engine???s search algorithm. This algorithm will take the the user???s query and compare it with the pages that are on it???s index. It will then create a list of web pages that will try to answer what the user was asking for.

So how does a search engine finds out about my web site? Search engines have an online application built in them known as a Web Crawler or Spider. The sole role of this application is to find and check for updates on web pages in the world wide web. Once a spider finds a web page it will check in the main engine directory to see if the page has been indexed before. If the given web page has not been indexed or if it was updated since the last time the spider visited the page, it will insert it into a separate queue. Another application/bot will access the page to cache the information and the code in it. If the page has not been updated since the last time the bot visited, it will leave it alone and move on to the next one.

I will be referring to Google’s algorithm when referring to a search engine algorithm as this is the one with the biggest search engine market piece. Be aware that search algorithms are constantly changing, so what I write today might change tomorrow.

Here are the major factors that are taken into consideration by the search algorithm to produce the results. Information gathered from SEOMoz

  • 24% Trust/Authority of the Host Domain
  • 22% Link Popularity of the Specific Page
  • 20% Anchor Text of External Links
  • 15% On-Page Keyword Usage
  • 7% Traffic and Click-Through Data
  • 6% Social Graph Metrics
  • 5% Registration and Hosting Data

To rank for a certain keyword you need to succeed in all of the algorithm ranking factors. The web site that has the best factors to it is the one that will rank best, or show up higher in the rankings. I will be teaching you how to optimize your web site to achieve the best results possible in all of the ranking factors. You need to have paciense and know than to rank for a term it takes time. You first need to get the page indexed, then get your content cached and then start building your authority. Once you get all of your this together you will begin seeing the results.

On my next lesson I will begin to explain the process of optimizing a web site, which is analyzing the market that you want to rank for and doing a proper keyword analysis. This is a very important step on your campaign as it will dictate how your whole pre-launch campaign will be based on. This is will get you categorized in the search engine eys for certain terms, the most accurate you get categorized the first time, the easier it will be to adjust and earn a higher authority.

Please feel free to leave any comments or questions below.

Creating Google Calendar Events with PHP

Many small businesses are now using the extensive Google Apps for Business framework to manage many of their daily activities. However due to the increase of Cloud Applications being programmed as well to assist this businesses, sometimes they have to be importing their online application information into their Google Apps. With the available API’s however this has not to be necessarily the case.

Using the new Google Calendar API and the following PHP code you can easily create events dynamically when they are generated in your cloud business application. Please be aware than in order to connect through their API you will need to have Zend installed on your server.

// Load required libraries
$path = 'Zend/Gdata';
$oldPath = set_include_path(get_include_path() . PATH_SEPARATOR . $path);
require_once 'Zend/Loader.php';

class google {
	public $client;
	public $service;

	function createCalendarEvent( ) {
		// Authentication with Google
		$user = '';
		$pass = 'userPass';
        // Load required libraries
		 // predefined service name for calendar
		$serviceName = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
		$this->client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $serviceName);
		$this->service = new Zend_Gdata_Calendar( $this->client );
		// get time
        $this->eventStart = "07:00:00";
        $this->eventEnd = "08:30:00";
		// Create a new event to add required parameters
		$event = $this->service->newEventEntry();
		// Create a new title for your calendar event
		$event->title = $this->service->newTitle( 'My First Google API Interaction' );
		// Set a location for your event
		$eventAddress = '123 Test St, Chula Vista';
		$event->where = array( $this->service->newWhere( $eventAddress  ) );
		// You can also add aditional information to your appoitnment
		$event->content = $this->service->newContent( 'Extra event information');
		$when = $this->service->newWhen();
		// Set start and end times
		$eventInfo = '2008-09-08';
		// 2008-09-08T22:47:31-07:00 (For Pacific Times)
		$when->startTime = $eventInfo . "T" . $this->eventStart . "-07:00";
		$when->endTime = $eventInfo . "T" . $this->eventEnd . "-07:00";
		// Set the when attribute for the event
		$event->when = array($when);
		// Create the event on google server
		$newEvent = $this->service->insertEvent($event);
		// URI of the new event which can be saved locally for later use
		$eventUri = $newEvent->id->text;


How much is Search Engine Optimization worth?

Many times clients are not aware of the actual worth of Search Engine Optimization (SEO) in their company’s website and they utilize other methods of internet marketing.  What they are not aware of is that if they were to use SEO they can save up to 80% of their budget and maximize their Return on their Investment (ROI). For example for a pest control company in San Diego going for the keyword “San Diego Pest Control” they could save an average of over $11,000 if they were to be on the number one spot of the organic results versus if they were using a pay per click (PPC) method.

We can calculate the worth of organic keywords by using a variety of methods. My prefer way is to use the Google Keyword Tool to calculate their value. On this tool Google gives us important information like how many times a keyword is searched and what is the approximate cost per click (CPC). This information combined with the know click-trough rate information on organic results will provide you the worth of any given keyword.


First here are some click-trough rate statistics

Rank 1 18%
Rank 2 10%
Rank in top 10 52%
Below the fold 4%


Now we will retrieve the desired keyword information using Google’s Keyword Tool

Keyword San Diego Pest Control
Global Monthly Searches 4,400
Approximate CPC $14.13


Using this information we can calculate the worth of the keyword using the following formula:

{Global Monthly Searches} X {Approximate CPC} X {Click Trough Rate}


Rank 1 4,400 X 14.13 X .18 $11,190.96
Rank 2 4,400 X 14.13 X .10 $6,217.20
Rank in top 10 4,400 X 14.13 X .52 $32,329.44
Below the fold 4,400 X 14.13 X .04 $2,486.88


As you can see the worth of a keyword in the organic search results is bigger that what the average person believes. Please note that this is only the worth of a single keyword, many search engine optimization campaigns when done properly can achieve infinity of number 1 ranks in searches with related keywords. There are many businesses that spend a large part of their budget in campaigns that will not maximize their ROI. Search Engine Optimization is not only more affordable that inbound marketing efforts but it will also create a better online reputation for your business.

Please leave any comments or questions in the form below

New Web Sites Do Not Validate

HTML and CSS Validation is a tool that was created in the beginning of the World Wide Web to make sure that web sites were constructed correctly. Many times when creating projects using new technologies, for multiple devices or that use third party applications we come to the problem that it does not validate according to the W3C standard. There are many developers and clients that react in a bad way when they see errors when validating and believe that the application still has bugs in it. Many time developers have to go back and change features just to make the site get a perfect score. Many times this makes the development time longer and the project more expensive. Developers and clients have to remember that validation is only a tool and nothing more than that, and while we do need to follow the standards set by the W3C we also have to make sure that usability and functionality are our top priority.

Usability over Technicalities

We always have to keep in mind that everything that we develop is intended for a person and not for a machine. Usability and Functionality for the target user of the application is the goal that we always try to achieve. While robots from search engines might crawl the application, we have to remember they are not our main audience. We also have to keep in mind that Google does not take validation as a ranking factor. You can see more about Google’s stand on this matter in the following video made by Matt Cuts for the Google Webmaster Forum:

When using many of the newer CSS3 techniques there will be an error created in the validation tool. For example when using border-radius that help us give rounded corners to our backgrounds. To go around this the designer has to design the curves and the developer implements them, which will take longer that using CSS3. We have to keep in mind that cases like this we have to always put user usability over irrelevant technicalities.

Validation is Irrelevant yet Important

While your validation score does not affect how search engine see you, it might still give you an extra boost in search engine optimization or SEO when the algorithm is looking at the web page overall usability. Validation as well still an important tool to review when working on a project. This tool will help you find unclosed tags and improperly nested div’s, extra semicolons, among other things. There will always be the error from Google’s Analytics or from that jQuery slider but as long as the integrity of the structure is impeccable you do not have to worry about the validation score from the W3C Tool. Remember that the score is only there to help you build a useable application; there is no target score you want to achieve just as long as you get 100% in usability with your target audience.

Please feel free to leave any questions or comments below.

Are your Internet Marketing Keywords targeted properly?

The most important step when starting an Internet Marketing Campaign is by far keyword research. There are many ways that this can be done depending on the goals that your business is trying to achieve. As an example, when your company is trying to achieve brand awareness your keywords will be more broadly worded. In the other hand, if your company is looking to make sales the keywords will be more specific to your target audience. The direction of your Internet Marketing Campaign needs to be fully established before any work can be even started, if not you will only be using assets or time that can be important later on.

Communication is very important to have with your Internet Marketing Agency. By this you will be making sure that the process flows with no inconveniences. While your keyword research is being complete be sure to give your feedback to your SEO Consultant, this is because there are many terms that are industry specific and by him knowing them it will make your campaign more successful.

There are many factors that will make your campaign successful but why is keyword research the most important of all? It is the most important Internet Marketing Campaign factor because all of your actions will be derived from this important document. You will decide what SEO Content to write using this list as well as how to structure your web site along other things. Be aware that if your keyword research is improper or not completed to suit your business needs the return on your investment will not be as high. Imagine a termite control business trying to generate sales leads in San Diego, ranking for “Termite Control” is great and is potentially bringing him a large amount of visitors. However, because the term is so broad it will not convert. But if the same company ranks for “San Diego Termite Control” then the number of visitors that is in their target audience is greater which will then turn into more conversions.

Take a look at your Internet Marketing Campaign Keyword Research and analyse your terms to see if they are the most appropriate one for your business goals. Please feel free to give us a call or send us a message with any questions, we will be happy to review your keyword analysis at no cost to you so that you have the tranquility that your business is in the right track.

Import CSV Files into a MySQL Database

Web Developer have to face a large amount of obstacles in their every day tasks in order to complete them. There are some thing that are easier to complete than other but a little bit of help can make a big difference when it comes down to finishing on time. Importing a CSV file into a MySQL database is often needed when creating projects for new clients. This is because they will use a variety of desktop software and they will probably tell you, “Here you go” when it comes to geting the data. To your advantage most of this applications have some way of exporting their data into Comma Separated Value files or CSV. Basically it’s a file that has a layout similar to a spreadsheet but instead of boxes for columns you have a coma separating the fields. In the same way in lieu of rows you will have a new line in the document.

The first step is to get that file from the customer or from it’s source and upload it into your server. After this you will need to access your server’s command line via an application like Putty and start your MySQL server.

$ mysql -h localhost -u root -ppassword

You will need to create your database with the fields that you will be needing. once your database has been set up you can import the data from your CSV file into your MySQL database. Here is the command that you will require in order to import the information into your database table.

load data local infile ''
into table phpdev.gc_cities
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(zipCode, city, state, county, areaCode);

In the first line of the command is where the location to your Comma Separated Values or CSV file is located at. The second line is the table that you want the information to go into. The third line is telling your MySQL server that the values are separated by comas. In the same way the fourth line is describing how the values are enclosed by single quotes. The fifth line is telling your server that your row ends when the line end. Finally the sixth lane is the fields in your database table. They need to be aligned with the order of your file for example if your files is ID, Price, Description then your locations will be (id, price, description) and so on.

Often there are times that the above command will not work. This is due to the fact that this option is considered to be a big security risk. Some hosting companies like Media Temple are disabling this by default so you will need to make a couple of small changes in order for it to work.

You will have to locate your MySQL configuration file which is usually located at ‘etc/my.cnf’ and comment out the line that prevents the import. You will have to do this while being a root user in your server, if not it will only allow you to read the file but not to reconfigure it. The line that you are looking for is:


You will have to comment it by adding a “#’ sign at the beginning of the line like:


You can learn more about this on the MySQL Documents. After you have completed the change you will need to restart the MySQL server and then do the process once more. The command to restart the server is:

service mysql restart

Hope that this helps any web developers out there. Please feel free to leave any comments, questions or suggestions down below and we will be happy to assist you.

Google +1 Button is Going International

The biggest search engine in the market Google has announced that they will be launching the +1 Button internationally. The Google +1 button is the company attempt to gain ground on Facebook Like button. However, because of the Google brand behind social meter it can assist brands to generate more trust in their sites when they have many +1’s. Until now this has been showed only on English results but it has now been released to sites across the world wide web. This is great news for Hispanic and international brands that are running an online marketing campaign.

Here are some of the countries where the +1 button is firstly going to be rolled out at:

  • Google.Co.Uk
  • Google.De
  • Google.Jp
  • Google.Fr

Quickly after this initial expansion has been completed they will start to expand further into all other Google search result portals. Webmasters can now go into Google Webmasters Central and use the +1 button tool to generate code snippets to +1 buttons which is available in 44 different languages. The Official Announcement was made today on Google’s Webmaster Central Blog.

A Successful Inbound Marketing Campaign

Many people now a days are starting to talk more and more about inbound marketing when it comes to creating a business advertising campaign. Inbound Marketing methods are ways in which the clients come to you instead of you reaching out to them. This is very important in this times because people know that by going to the internet they can get what they want in a more accurate way and without having to look at complicated ads or thing that they just dont want to see. A great example of this is how 90% of purchases are researched online before the actual purchase is made. Imagine if people go online to research what product to buy and you keep coming up in their searches they are more apt to select you versus any other competitor.

A great way to do inbound marketing is through search engine optimization for organic or non-paid search results. By doing this people use to trust your brand more than if they reach you by a paid advertisement method like it is on the case of a Pay Per Click Campaign. This however is not something that you will be able to succeed in just a few months; it will take a lot of time and dedication in order to see the full results of a successful inbound marketing campaign. There are more methods however that will assist you in having a successful and trusting inbound marketing campaign.

A very important factor that is growing exponentially is Social Media. It can be Twitter, Facebook, LinkedIn or any other channel but the fact is that people are spending more and more time in this channels and the conversations are going on with or without you. Twitter for example is a great way to let your customers know of what you do, how you do it, how your business interacts and so on. By this I’m not saying to just send advertisements out there but interact in conversation. Help people who need is looking for some answers, little tings will take you a long way in making friendships. This friendships will talks about how great you are to their friends and that will bring you more trusted business.

Even tough in order to run a successful inbound marketing campaign you will need more brains than money, in the long run it will make you more money while keeping your cost lower. Don’t be afraid of having to look for new friends, be afraid of you loosing them as that will be the first step for failure. Inbound Marketing is not the future of advertisement but the present, what are you doing about it?