• Shortcuts : 'n' next unread feed - 'p' previous unread feed • Styles : 1 2

» Publishers, Monetize your RSS feeds with FeedShow:  More infos  (Show/Hide Ads)


Date: Wednesday, 20 Nov 2013 22:01

A lot of people are going to lose their company certifications.  I had to take another test because the reporting test is no longer offered even though I took it only 11 months ago.

Here is the email I got.

Google AdWords | Certification Program
Join Google Partners today
Partners combines AdWords certification with new tools for agencies
The Google Certification Program has been replaced by a new and improved experience for agencies and online marketing professionals—Google Partners. Inspired by your feedback, Partners includes improvements that make it easier and more meaningful to get certified in Google advertising solutions like AdWords.
How this affects certified professionals
Get leads from Google
When your company earns the new Partner badge, we’ll help connect you to new clients. Learn more
  • Access to your GCP account is no longer available.
  • Your GCP exam history and AdWords certification status will transfer to Partners when you join using your GCP login.
  • You now need a Google Partners account to take exams and get certified.
  • Taking exams and getting certified is now free. (previously $50 USD per exam)
  • All exams passed and certifications earned through GCP are not affected and will remain valid through their original expiration dates whether you join Partners or not.
Learn about transferring your AdWords certification to Partners
How this affects Google Certified Partner companies
  • A Google Partners account is now required to manage your company’s profile on Google Partner Search. You can manage both your individual certifications and company profile using the same Partners account.
  • Your company must now qualify for the new Google Partner badge to be listed on Google Partner Search.
  • Former Google Certified Partner companies will not automatically qualify for the new Partner badge. Certified Partners who don’t qualify for the new badge have been removed from Google Partner Search.
  • Google has retired the old ‘AdWords Certified Partner’ badge. Usage of this badge for promotional or other purposes is now prohibited.
Learn about adding your company to Partners
Joining Partners is easy. Simply sign up using your GCP login, ogletree@gmail.com, and we’ll automatically import your certification history.
Join Google Partners
If you have any questions about the change from GCP to Google Partners, visit ourHelp Center or contact us.
See you online,
The Google Partners Team

The post The Google Certification Program has been replaced by Google Partners appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Uncategorized"
Send by mail Print  Save  Delicious 
Date: Monday, 21 Oct 2013 22:25

I have been using a custom proposal generator over the last year and the guy who made it for me decided to make a commercial version. The new proposal generator is called www.phpProposal.com. It works like WordPress. You have to install it on your own server. It is very easy to install. They have a simple script to install on your web server that will tell you if your server is comparable. It works on most LAMP servers. If you have a “linux” web hosting account there is a very good chance this will work on it.

It was originally designed specifically for my needs. The new version is designed for everybody. You can make your own templates and change the wording to whatever you want. It still has built in features for SEO.

Some of the stats for potential clients

  • Ranking in Google, Yahoo, and Bing for keywords
  • How many .edu, .gov links
  • Alexa ranking

It has several pre built proposal templates or you can create one from scratch. It saves your proposals so you can print them out later. I always have to send out proposals and this program makes it real easy.

The post New PHP Proposal Generator Software appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Misc, SEO"
Send by mail Print  Save  Delicious 
Date: Monday, 21 Oct 2013 22:25

I know I covered web page size a few times but I thought a few more things to say. Web page Load times are very important especially for WordPress blogs. Many people are switching to dial up or switching to lower speed broadband to save money. AT&T offers a 750k service for $20 a month now. Even if that were not the case I know everybody has dealt with slow web page load times on their expensive high speed connections. If you have a cable modem you are sharing an Internet connection with your whole street probably. Not to mention many people share an Internet connection in their home. If you live with somebody that plays games and/or downloads movies and music you have seen slow web page load times. Even if Google analytics is showing you 5% dial up users that does not mean you don’t have to worry about slow web page load times.

There are many things that cause slow web page load times. Many people think all they have to do to lower web page load times is get rid of images or make them smaller. There is a lot more you can do. The number of items that your page loads adds to slow web page load times. If your webpage has 30 images 2 CSS files, 4 javascript files that is 36 things that have to load. Each time a new item is loaded that ads to a longer web page load time. Consider using CSS Sprites and combing images or code that don’t need to be in several files. Also you don’t need to load all js and css for every page give specific css and js files to each section that needs them. At the very least pick your top five busiest pages and set them up so they load only what they need and nothing else. Another thing that can slow down web page load time are nested tables. I have seen webpages with 120 nested tables before. A table will not display until all of the HTML for it has loaded.

The problem is that many websites are built on top of some CMS or shopping cart. It may be impossible for some people to make these changes. The advice I give is that if your website is doing well and making you money it is worth the investment to redo the site so that it loads faster. If your just starting out or already invested a lot into a website it may not be worth the extra expense. Slow web page load times will not kill your site I’m just talking about how to make your site better. If your running a business you should always be looking for little ways to squeeze out more profit. I mentioned in a previous post on this subject that Google Maps reduced their page size by 30% and traffic went up 30%. I have also read that you have anywhere from 3 to 5 seconds to convince people to not to hit the back button. If your content does not load very fast you will lose sales.

[tags]webpage load time, page size, google, web page load time[/tags]

The post Web Page load time is more important than you think appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google, web design, Website Marketing"
Send by mail Print  Save  Delicious 
Date: Thursday, 17 Oct 2013 04:10

I have heard a lot of people talk about how they won’t use Gmail because it is somehow unsafe or that Google is going to read all their email. Anybody who says this does not know much about email. Gmail is actually one of the safest places to host your email.

Every single email host that you get from your host or registrar is just as insecure as Gmail or each other. No matter what, your email is stored on a server that people have control over.  This means that at Gmail, Hostgator, 1and1, Godaddy, Bluehost, or any host there are employees that can read your email if they wanted to.  Some of the bigger companies like Hostgator and Godaddy have hundreds of low level employees that have access to your email.  At Hostgator every person in support including people in their first week of training has access to your email.

The next problem is that your email bounces around all over the Internet from server to server before it reaches its destination. Each one of those servers has the ability to intercept your emails and read them. So unless you only communicate using encrypted emails with everybody you communicate with your emails are not secure and can be read.  Even if you encrypt your emails the government has access to your encryption code by law.

Worst case Gmail is no better or worse than any other email host. I prefer to use Gmail because there are only a handful of people at Google that can read my email.  The other excuse is that my email is somehow insecure because Google sends me ads based on the text of my email. This is true but this is a computer program not a human. You are identified as a number and served ads based on your behavior.  The program nor the advertiser knows or cares who you are personally or what is in your email other than to send you ads.

I use Gmail because it is the best platform out there. Nothing comes close. Nobody is going to be reading your email.

The post Is Gmail safe and secure? appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Sunday, 27 Feb 2011 20:25

I have sold a lot of things online over the years and have seen all kinds of scams. I’m writing this post because I just ran into an old scam while trying to sell something on Craigs List.. This most important thing you can do when selling things online is to watch out for red flags. If it is too good to be true it is. The biggest flag is if somebody wants to pay full price and wants fast shipping. If you are selling on a craigslist type of site be very wary of somebody that does not haggle. Bad English is a big red flag as well. Shipping out of the country is also a huge red flag. Copy the first sentence or two of the offer they make to you into Google with quotes around it. This will catch the really stupid scammers.

Here is an email I got today. It has red flags all over it.

Thanks for the prompt response..I fully understand the condition of
what i am buying. I’m ready to buy it now for my personal use but am
not local and due to the nature of my work, phone calls making and
visiting of website are restricted but i squeezed out time to check
this advert and send you an email regarding it.Note that you will not
be responsible for shipping and handling. My shipping company will
come to your location for the pick up. Kindly provide me your name
and full address so i can forward it to the shipping company to
calculate the cost of pick up for me. And concerning the payment, i
will prefer PayPal because i don’t have access to my bank account
online as i don’t have internet banking but i can pay from my PayPal
account because i have my bank account attached to it. I will also
need you to give me your PayPal email address so i can make the
payments immediately and if you don’t have an account with PayPal yet,
it is very easy to set up, go to http://www.paypal.com and get it set
up, after you have set it up i will only need the e-mail address you
use for registration with PayPal so as to deposit the fund. So get
back to me with the following details:

Your Full Name:
The Pick Up Address including Zip Code:
Your PayPal email address for the payment.

Thanks and in anticipation of your response.

Best Regards,

Nina.

The post Don’t get scammed when selling things online appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Tuesday, 07 Dec 2010 14:00

Managing projects for multiple clients often requires dependent tasks and strict deadlines. To keep track of the “who does what by when” details, it is helpful to have a project management tool to insure you are achieving milestones while not getting stressed out!

SEO Fox needed a solution to manage and organize our projects and tasks in order for us to efficiently fulfill our client obligations. After previous experience with BasecampHQ, Zoho, and Central Desktop (and even demoing a few more), we found a free (donations welcome) hosted project management tool called ClockingIT to help us fulfill our client and sanity needs!

I have found setting up a project in ClockingIT is easy. The interface is intuitive and every user’s dashboard is customizable so users can rename titles and add or subtract widgets to make the dashboard information relevant to the specific user. Admins (configurable) are able to assign projects to clients and task to users and schedule the time allotted to both while seeing a live “timeline” feed of task completions (there is also a GANNT chart display for the PM nerds in a few of us).

A couple tools I really find helpful are the task timer and the very versatile report feature. The timer allows you to easily clock the time it took to do a task (and it can also be a pop-out window) and document any notes you might want other teammates to be aware of. Using the timer tied with the different reports you can run truly makes calculating project metrics upon project completion easy.

Having a hosted solution (one less thing to worry about) was one of our requirements in a project management solution, but ClockingIT also has a local version for organizations that have a strong network administrator who knows a bit about Ruby. For more information on getting the source code or joining the ClockingIT development community, visit their source wiki and join their github project.

The post ClockingIT: A Great Project Management Tool for Small Businesses appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "project management, reviews"
Send by mail Print  Save  Delicious 
Date: Thursday, 14 Oct 2010 22:02

There are all kinds of articles on how to use certain tools to do keyword research. I would like to talk about some other tricks I have used over the years.

Snail Mail

Check your junk mail and try to get junk mail from friends and neighbors. Many companies send out fliers with special domain names specifically for mail outs. Don’t forget that URL’s are keywords. I used to make $5000 a month from one kw that I did ppc for. These keywords won’t last forever so you have to keep finding new ones.

Open Analytics

There are a lot of sites that leave their analytics open. You can do certain searches in Google to find these sites. This way you can find out new keywords. Here are some of the searches.

  • july referrer usage statistics
  • “Top 8 of 8 Total Search Strings”
  • Total Search Strings” july

You will find links like http://example.com/.stat/ref_201007.html. What you do is start deleting the sub directories to find the links to every month. http://example.com/.stat/ You can also throw in some base keywords into those searches to find site in your area. The above searches are just something to get you started. You can come up with all kinds of searches to find sites. Look at different analytics packages to find out keywords they use on their reports to find even more.

The post Keyword Discovery Tips appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Friday, 02 Jul 2010 13:00

I was messing around in Google trends yesterday trying to find out how it matched my analytics data. In Raven tools I like to compare this year and last year to see how well I’m doing. I have it set to only show organic traffic from all search engines. I prefer the Raven interface to GA over Google’s.

I had two browser windows open going back and forth trying to see the difference. I was thinking it sure would be cool if I could get this Google Trends data in one place. I did some searches and discovered that if you log into your Google account you can download the Google Trends data. I downloaded the CSV from 2009 and 2010 for the main keyword for a client. I copied the data from 2010 to the 2009 spreadsheet. I deleted the percentage cols and the extra stuff on top and bottom. Since I was comparing 2009 to 2010 I deleted the weeks from 2010 that have not happened yet and the corresponding weeks from 2009. This left me with 4 cols. I changed the heading for the numbers to the year plus AD like 2009 AD because excel did not like just a number there.

I’m not an excel expert. If you really know excel you can really get fancy with this but this worked for my needs and it was fast. Then I click on the insert tab and clicked on Line and picked the first line graph. It made exactly what I wanted.

2007 Excel File
97-2003 Excel File

Google Trends in Excel
* Bottom numbers are week numbers so this shows the first 25 weeks of 2009 and 2010.

The post Using Google Trends in Excel to compare years appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Wednesday, 26 May 2010 21:11

Yesterday I was on Webmasterradio talking about link building. I was on with Disa Johnson aka airDisa and Daron Babin aka SEguru. We had a great time but there was just not enough time to talk about all the things I wanted to. Below is a list of link building tips that I prepared for the show.

  1. First step to link building is to make sure all your incoming links go to existing pages or pages that have been redirected to existing pages.
  2. Get a list of websites that mention you or your product but don’t link to your website and ask them to link to you. You can get this from Majestic SEO or by searching for your domain name or company name or product name in Google.
  3. Find websites that link to more than one of your competitors. This means somebody is making a list of similar sites and there is a very good chance you can get them to add your site to the list. One tactic to help in this is to offer a coupon code specifically for that site. Don’t just use a unique random code make it a word that reflects the site name or subject. Search Return will let you do this by uploading your backlinks from Yahoo or you can use an export from linkrep.seofox.com or many of the other backlink providers.
  4. Study your competitor’s backlink profile. This will let you see what types of sites they get links from. It helps to find out what types of sites link to your type of website. It also helps find the type of content people link to. This will give you ideas to create new content that will attract links. You can do this with many of the different backlink tools out there.
    Find broken links to your competitors and inform the site owner that the link is broken and ask them to link to you.
  5. Find sites that link to you with URL’s or junk words like “click here” or “more info” and contact the site owner to change it to a keyword.
  6. Find bloggers that have blogged about your competitors and ask them to write a blog about you. Offer them something like a free product, or service.
  7. Directory submissions still work for long tail keywords. I have run a lot of reports recently and we are seeing top sites with thousands of directory links. The key is getting a good list of directory links.

The post SEO Link Building Tips appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Thursday, 20 May 2010 22:25

Quality inbound links are key to achieving great results with organic search.

As SEOs, getting quality incoming links for clients is a time-consuming routine of content creation, web browsing, info submission, and link requests. The question is how to build link popularity efficiently without wasting time.

There are a number of ways to get incoming links, but two that show the most results are creating quality content (linkbait) and requesting links directly from relevant sites. We all know how to create quality content (or buy it). The question is really how to find relevant sites to approach for a link. Advanced keywords searches are a great way to get started. One of the most efficient ways to target potential linkbacks is still competitor backlink analysis.

Competitor backlink analysis is no stranger to SEO; our site owner David Ogletree has made several worthwhile posts about backlink research recently. There are a number of free and modestly priced tools on the market that streamline the link analysis of any website. But a new tool has entered the backlink analysis market that truly aids in streamlining your backlink management.

Link Hound is a great backlink research tool for discovering and managing any backlink endeavor. The process of adding a website campaign and relevant keywords to that campaign is simple. The tool actually suggests numerous websites to analyze based on any keyword phrase entered and determines the links with the most potential to backlink to your site based on the information you give. Link Hound also offers a contact management system within its results page which makes it easy to keep track of links and contacts within the tool instead of exporting that info to Excel. But if you are old-school, you can still export the data to CSV and have fun.

After spending an afternoon using the new tool, it definitely provided relevant potential. Even if you are already using link building software, Link Hound can serve to bolster your reservoir of potential link targets.

Bottom line: Link Hound will help you find relevant backlinks to pursue and help you manage them too.

The post Link Hound: A New Backlink Discovery Tool appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "reviews, SEO, backlinks, link building, ..."
Send by mail Print  Save  Delicious 
Date: Thursday, 04 Mar 2010 17:03

Some SEO’s have been doing competitor backlink research for a long time some people are just now discovering it and most have never heard of it.

Competitor link research is when you study your competitor’s backlinks as part of your link building efforts. There are quite a few different ways to acquire links using this practice. The possibilities are endless. The best place to find links are places that are already linking.

  • When you find pages that link to several of your competitors there is a good chance they will link to you too.
  • Get a list of blogs and forums that link to your competitors that don’t have nofollow. Make sure to leave good comments and post good threads. Don’t just say “great site” and spam links with anchor text. It is best to do comments or posts that don’t have links at first. Contribute to the site so they don’t mind your links later. Read the forum rules to find out if you have to make a certain
    number of posts before you can use links. Some forums moderate the first 4 or so posts you make.
  • Study the types of content websites link to and create that type of content. You can get them to link to your site as well or you can convince them that your content is better than the one they are linking to and they might replace your competitors link with yours.
  • When looking through your competitors links you might find that sites link to pages that no longer exist. You can create a page that reflects what was linked to and then inform the site owner of the broken link and let them know they can link to your page instead.
  • Get a list of sites that used to link to you or your competitor and try to get a link on those sites. If they used to link they might link again. Find out what the site used to link to and improve the content then show the owner why they should link to it again.
  • Find directories that link to your competitors to get your site in.
  • Study your own backlinks to find sites that link to you with URL’s or junk anchor text like “click here” or “articles”. Contact them to try to get that changed to a keyword.
  • Find wiki’s that link to your competitors and don’t use nofollow . Try to get added to that page or create your own page on that wiki with a link to your site.
  • Find run of sites links to your competitors. This might be blogrolls or sometimes paid links. Try to get the link for free. This is not about the right and wrong of buying links just ideas if you want to use them.

While you are doing all this research you might find types of sites that link to your subject area you did not know about. Any time you’re surfing the web you should be looking for new ideas to attract links.

My new backlink reports at SEO Fox can facilitate this type of link building. In the past it took a long time to get a lot of this information. My new service speeds things up so you can get links faster.

The post Using Competitor Backlink Research to Beat Your Competition appeared first on SEO & PPC Blog of David Ogletree.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Wednesday, 03 Mar 2010 21:50

I got a call today from a guy claiming to be from Today’s Business Report. He told me”Today’s Business Report” is an educational Business television show that is going to air on the FOX business network. I called up and had a long conversation where he leads me to believe that I am being screened to be on the TV show. He asks me all kinds of questions about my business. He finally starts talking about how my company will be featured at the end with a segment. At the end he asks me if I’m ok with a scheduling fee. For a 60 sec spot it costs $5900 to be on their show.

This is basically an infomercial. It is not a real show. They really don’t think you have some great information they just want your money. I did a press release yesterday so I thought somebody at FOX had seen it and wanted to put me on one of their business shows.

Author: "ogletree" Tags: "Google"
Send by mail Print  Save  Delicious 
Date: Sunday, 28 Feb 2010 06:31
Adwords Result that shows Electrician ads for Doctor search2

Click on image to see un-cropped image

I did a search for “Houston Electrician” earlier in the day without being logged in. Later on I did a search for “Houston Doctor”. This is when I got this result. I’m pretty sure the electricians are not advertising for “Houston Doctor”. I opend IE and logged out of Google and did the same search and did not get those results. I went back to Firefox did the same search and still got the electricians. I then searched for “houston doctor” several times in IE and never got the electricians. I then did a search for “houston electrician” and then did a search for “houston doctor” and got the electrician ads this time.

Google has decided that because I searched for electricians earlier that I should see some more electrician ads. The electrical ads are below number 4 when I type “houston electrician” so I know they don’t have a very high bid. I seriously doubt low end bidder on “Houston electricians” beat out high bidder for “houston doctor”

Looks to me like Google is ripping off some people. How would somebody making a ppc campaign for electricians know to put doctor as a negative keyword.

UPDATE: Barry over at Search Engine Roundtable pointed out that this is an old thing that Google is very open about.

http://www.seroundtable.com/archives/016297.html
http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=74246
http://www.google.com/support/forum/p/AdWords/thread?hl=en&tid=55c5caa9895ebfdb


Author: "ogletree" Tags: "Google"
Comments Send by mail Print  Save  Delicious 
Date: Thursday, 25 Feb 2010 17:40

Several products allow you to see all your competitors’ backlinks, including my newly released reports. You can see your competitors’ backlinks, and get a report that breaks the list down into manageable chunks that you can investigate. The best place to begin your link building process is to look at your competitor’s links. If they are ranked number one for a keyword term, you will know that it is their links that got them to that position. The first thing you do is:

  • Try to get some of the same links.
  • Get ideas to find your own links.

Links from Forums and Blogs

Look at the report’s links from forums and blogs that do not have the “no follow”. You can then go to these forums and blogs and make posts or comments. Read the thread or blog post and make a helpful comment. If it is a forum, you should get involved. Do not go and make some spam post. Link building is hard work and don’t go looking for short cuts.

Getting Backlinks

See what types of content people are linking to as you go through your competitor’s backlinks. You need to create a similar type of content if you don’t have it already. You can send a personal email if you find a site that links to content you already have, When sending emails, your success rate will be higher if you send the email from the domain you are requesting a link from. Be complementary to them in your email. Tell them how much you like their site. Talk about the specific page that you want a link on. If they are linking to your competitor you have two choices you can ask them to also link to you or you can ask them to change the link to link to you instead.

If you get a rejection email, try to figure out why. If they don’t tell you why then send them an email asking if there is something you can change so that they will link to your site. If they do reveal why you were rejected, change your content or create new content and ask them again to link to your new content.

There are several programs you can use to mange this. I use Squid. You can also use Digixmas. Digixmas is not just for submitting to directories. You can go to their manual mode to visit a website. Once you send an email, just mark it as success. This way you know which ones you have worked on. You can use the bypass and failed flags to mark different things as well to help you remember what step in the process you are on.

Come visit http://linkrep.seofox.com and get reports on your competitors. If you don’t want to do all this work SEO Fox can do for you.


Author: "ogletree" Tags: "Google"
Comments Send by mail Print  Save  Delicious 
Date: Saturday, 23 Jan 2010 20:49

If I had to pick only one plugin for firefox it would be the Web Developer Toolbar add on. I use it every day. I’m not really a developer. I do make simple web pages but I use it most the time evaluating websites. I use it to look at a site when I get an email or phone call from a prospect. I also use it when I’m link building.

When somebody comes to me to do their SEO the first thing I do is go to their website. I turn off CSS and Javascript using the toolbar to see what search got are seeing. You do this by clicking on the CSS pull down menu and clicking Disable Styles > All Styles and clicking on the disable pull down menu and click on “all javascript”.

The next thing that I do is click on the information tab and go to “view meta tag information”. I can tell if they are using meta tags at all. Sometimes you see all kinds of odd tags like “revisit after” which no search engine uses. Sometimes I see they have 2 descriptions.

I like to use the resize feature. Click on the resize pull down menu and change the size of the window to see how the site looks in different sizes.

This is not for SEO but I like to use the “Display Anchors” feature in the information pull down menu. I use this when I want to link to a specific forum post.

Under Images you can click on “display alt attributes” to see if they are using them. You can also tell it to show you images size. Find broken images is helpful too. “Show images full size” will show you real quick if they are not optimizing their images.

The Web Developer toolbar does quite a bit more but since I’m not a developer I don’t really use it. Let me know what your favorite features are in the comments. I would love to hear them.


Author: "ogletree" Tags: "Firefox, SEO, Tutorials"
Comments Send by mail Print  Save  Delicious 
Date: Sunday, 17 Jan 2010 04:47

I am always creating simple php websites that get data from a mysql db. The first step is to set up the db. You can do this in your control panel. Once you do this make a note of the db info. This will be db name, db password. Next you need to go into mysql and create a table. I normally do this with phpmyadmin. Most web hosts provide this for you.

Next you need to create a config.php file where you store the connection information. You will include this on any pages that access the db later. Most people stick this in a includes sub directory.

<?PHP
#most of the time this is localhost but some hosts like pair.com will assign you a db server name
$db_server ="localhost";
$db_name = "name_of_db";
$username = "user_name";
$password = "password";
$dbh = @mysql_connect($db_server,$username,$password) or die ("Connection failed."); $db = @mysql_select_db($db_name) or die ("Connection made. But database '$db_name' was not found.");
?>

Every page that you want to access the db from put this line of code at the top

<?php include "/includes/config.php"; ?>

Now you need to create a page. There are different types of pages. Some pages will show a list that comes from a db search and others that will show just one record. First lets create a page that creates a list of records from the db. Each one of the items in single quotes can also be a php variable. You can get this from something declared before on the page or you can get it from a var passed from the url. When you pass a variable you access by using $val = $_GET['word']; . If you have the URL http://www.example.com/page.php?myvar=test Then $val will contain “test”.

Create a sql search to get your data. What this does is pull the data from the db.

<?php
$query = "SELECT count(*) FROM `table_name` WHERE Row_Name  = 'some_text_your_looking_for' ORDER BY Row_Name";
$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
$query_data = mysql_fetch_row($result);
?>

Create a loop to display the data.

<?php
while ($row = mysql_fetch_assoc($result)) {
echo $row['Row1_Name'];
echo "<br>";
echo $row['Row2_Name'];
 
#you can also create links
echo '<a href="http://www.domain.com/page.php?var1=' . $row['Row1_Name'] . '">Anchor Text</a>';
}
?>

Next you can create a page that returns the data from a specific record. If you create a link like above you can create a page that uses the variable set in the url.

<php
$query = "SELECT * FROM Table_Name WHERE Row_Name = 'search_text' ";
$result=mysql_query($query);  
$row=mysql_fetch_assoc($result);  
echo $row['Row1_Name'];
echo $row['Row2_Name'];
?>

This is a very simple tutorial you may need a lot more depending on your needs. Sometimes you might have to search the db for data that does not exactly match. When this happens you can use the wildcard %.

SELECT * FROM Table_Name WHERE DISTNAME LIKE '%ISD'

What this does is return all the rows that end in ISD. You can also use AND and OR like if you want to pull city and state. You would have to do that because a city name is not unique to a state there would be several rows with the same city but with different states.


Author: "ogletree" Tags: "Google"
Comments Send by mail Print  Save  Delicious 
Date: Monday, 28 Dec 2009 18:39

I just recently created a new site for a client and he decided he wanted to do PPC. I created a landing page for him. I still wanted the users to be able to see the rest of the site but I wanted to show a specific phone number to PPC visitors. I created some PHP code that gives a 10 year cookie to anybody who hits my PPC landing page. On every other page in my site I put in some code that checks for that cookie and gives then a PPC phone number if they find that cookie.

Code for PPC landing page. Must be very first thing on page.

<?php
setcookie("ppc", "this works", time()+60*60*24*365*10);
?>

Code for every other page.

<?php
if (isset($_COOKIE["ppc"]))
    echo 'ppc info';
else
    echo 'non ppc info';
?>

You can use that code to display a different logo or image with phone number in it or special text. If you have your phone number all over the place I would put your phone numbers in different include files so that you can change them easily.

Code for include

<?php
if (isset($_COOKIE["ppc"]))
    include 'ppc-phone.inc';
else
    include 'phone.inc';
?>

Technorati Tags: ppc, php, adwords, SEM


Author: "ogletree" Tags: "Adwords, web design"
Comments Send by mail Print  Save  Delicious 
Date: Friday, 10 Jul 2009 14:15

Putting up an ecommerce website with the descriptions from the manufacture is bad for SEO. Putting up any content on your website that is not unique is not good for SEO. The excuse that “everybody does it” is not valid. Sure there are some people out there that rank well using manufacture descriptions but your not them. When you get the same kinds of links that they do you will outrank them because you have unique content. When Google spiders the web they notice that there are a lot of people selling the same item with the same description. If you want Google to notice you you’re going to have to be different. A very good example of a website doing this right is www.jpeterman.com.

If your serious about getting more sales through organic search traffic your going to have to spend the time or hire somebody to do it for you. Somebody is going to have to go in and rewrite your descriptions. When you rewrite the description you need to make sure you include keywords you want to rank for. Also add alt tags to your images. Another thing I recommend is to consider how Wikipedia is set up. In your description talk about other items that go with this item and link to them with anchor text. Notice in Wikipedia articles there are lots of links to other pages in Wikipedia. That is one of the reasons they rank so well. Internal linking can help you rank above your competitors. On page SEO is hard work and has to be done on large ecommerce websites.

Don’t forget that an ecommerce website is also a website. It should not just be a cart. You need to include articles. The more interesting your site is the more links you will get. Talk about your products. Talk about how they can be used in different ways. Talk about ways to augment them. Write stories about somebody using your product. Spend time on your template and try to keep the code down so that Google mostly finds text instead of tons of junk. Don’t forget that people will leave your website if your page is not loading very fast.

Austin PPC Company


Author: "ogletree" Tags: "Google, SEO"
Comments Send by mail Print  Save  Delicious 
Date: Tuesday, 30 Jun 2009 14:58

When Facebook launched new vanity URL’s I created a new account for www.seofox.com because I wanted an account that was not personal. They would not let me get a vanity url that night. Well I logged in today and got my Vanity url. www.facebook.com/seofox

Technorati Tags: facebook, vanity url


Author: "ogletree" Tags: "Google"
Comments Send by mail Print  Save  Delicious 
Next page
» You can also retrieve older items : Read
» © All content and copyrights belong to their respective authors.«
» © FeedShow - Online RSS Feeds Reader