Archives

10 Great ideas for blog posts

Here are more ideas used a few times:

  1. Write about the latest silly thing a celebrity did. If Mel Gibson just stuck his foot in his mouth again, write about it. Connect it with what you do: If you’re in customer service (who isn’t?) maybe tell folks they should always pretend they’re being recorded. You get the idea.
  2. Answer the buttheads. Someone out there said something that ticked you off. Answer them. Don’t do it like me, though. Do it nicely – I don’t want your firing on my hands.
  3. Mea culpa. Apologize to someone you wronged. This doesn’t have to be a pistols-at-dawn offense. For example, maybe I panned a book the first time I read it, then loved it the second time so I decided to write a second review. Or, maybe I told someone (in a nice way) that they were wrong, but it turned out I was.
  4. Stream of consciousness. This is harder but fun. Just start writing with one thought in mind. I’ll do this with things like ‘SEO’ or ‘marketing’ or ‘purple things’. About 1/2 the time I get something really great. The other 1/2 it looks like I was freebasing cocoa powder again. A good exercise nonetheless.
  5. Ask. Send out a Tweet: Yo, people, what should I write about today? It works amazingly well, once you tune out all the folks asking you to write about, er, inappropriate topics.

Read more……

Advertisements

Tips For Successful Social Networking

I have heard many business owners question whether social networking is a successful marketing tool. I am a firm believer that it is. Social networking sites offer a place for you to reach out to prospects and customers at no cost to you. They can also be a lot of fun! So how do you make social networking work for you? Here are five tips to make your efforts more successful:

1. Be where your target market is. Any successful marketing strategy starts with knowing who your target market is and where they are. There are many different social networking sites available and no one can be involved in them all. The key is to actively participate in a few networks that will give you the results you are after by allowing you to reach people who want to know about your products and services. For example, if I sell dog food, I want to find social networks that dog owners are involved in. Speaking about my dog food to a group of cat owners won’t get me anywhere!

Successful Social Networking

2. Give first. Your prospects have a lot of different options in regards to who they do business with, and they want to do business with someone they know, like and trust. Don’t start off bombarding your prospects with sales pitches. This only causes them to see you as a spammer and ignore you. Instead, share helpful information without expecting anything in return. Give tips, share helpful links and answer questions. When they decide to make a purchase, they will remember how you helped them before.

3. Make a long term commitment. Building relationships is an ongoing process. If you expect to see results quickly, you will get discouraged and give up. Make the commitment to stick with it and keep…….

Read More….

SEO Excel Functions

SEO and Excel are like chocolate and peanut butter – great together. Here are some Excel functions (and two formulas) that can make SEO just a little bit easier.

LEN

Character Length in Excel

The LEN function returns the number of characters in a cell. It’s particularly handy in creating the right title and meta descriptions. Remember to keep your titles to ~60 characters and meta descriptions to ~150 characters.

TRIM

Phantom spaces at the beginning or end of a cell can be maddening. So before you go Office Space on your keyboard use the TRIM function which gets rid of any spaces before or after text. It’ll also get rid of any extra spaces between words. Think of TRIM as a vacuum cleaner for spaces.

SUBSTITUTE

This is just what it sounds like. Using the SUBSTITUTE function you can find specific text and substitute it for different text. It doesn’t sound all that interesting but it turns out to be vital in creating useful formulas.

Word Count Formula

There’s no out of the box word count function. But with a little creativity you can create a useful word count formula using the three functions above.

=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1

The first part of the formula returns the number of characters in the keyword phrase. We’re using TRIM to ensure extra spaces aren’t included in the LEN calculation.

The second part of the formula returns the number of characters in the keyword phrase without spaces. We’re using SUBSTITUTE to remove the spaces.

The difference between the two numbers tells you the total number of spaces in the keyword phrase. That’s where the +1 comes in. If there are three spaces, that means you actually have four words. Confused? Here’s an example.

This is three spaces

There’s a space between This and is, between is and three and between three and spaces. The number of words will always be one more than the number of spaces.

INT

The INT function is excellent if you’re downloading the new Google Webmaster Tools Top Queries report. You might see that your average position is sometimes not a whole number. This level of detail can be useful, but sometimes you want to aggregate. That’s where INT comes in. The INT function will return just the integer from that number.

You can actually do this in a number of ways including ROUND, ROUNDDOWN and ROUNDUP. If you use any of the ROUND functions you’ll simply specific that the number of digits you want to round to is 0. Here’s a look at how each one behaves in a real world example.

Rounding Numbers In Excel

Once you have your whole number rank you can use a number of methods to analyze it, my favorite being a pivot table.

Know More about SEO Excel Functions…..

Top Most Popular Search Engine Optimization,SEO marketing Websites

1) SearchEngineLand.com- Search Engine Land is a news and information site covering search engine marketing, searching issues and the search engine industry. This site is led by journalist Danny Sullivan, who has been covering search for the past 11 years. It is published by Third Door Media, which also produces the Search Marketing Expo conference series and the Search Marketing Now webcast events.

SearchEngineLand

2) Seobook.com- Launched in 2003, It is one of the oldest standing SEO sites that is still regularly updated. The site originally was designed as a blog that offered DIY SEO tips and helped sell the leading SEO ebook.

3) MattCutts.com –Matt Cutts is a qualified software engineer that works as the head of Google’s Webspam team. He is well known in the SEO community.

4) Seomoz.org – SEOmoz is the world’s most popular provider of SEO software. Their easy to use tools and tutorials make search engine optimization accessible to everyone. The powerful SEOmoz API delivers our Linkscape web crawl data to our SEO tools, Open Site Explorer and dozens of third-party applications.

Seomoz

5) SEOChat.com

6) SearchEngineWatch.com- Search Engine Watch helps search professionals and interactive marketers do their jobs better. SEW is devoted to issues surrounding customers—finding them, keeping them…

Know More about Popular SEO Websites….