Please email me at:
![Jason [at] LiveRealNow [dot] net](https://liverealnow.net/wp-content/uploads/2010/11/email.jpg "Jason [at] LiveRealNow [dot] net"){kind=small}
Or use the form below.
[contact-form 1 “Contact form 1”]
Make Extra Money Part 4: Keyword Research
In this installment of the Make Extra Money series, I’m going to show you how I do keyword research.
Properly done–unless you get lucky–this is the single most time-consuming part of making a niche site. If you aren’t targeting search terms that people use, you are wasting your time. If you are targeting terms that everybody else is targeting, it will take forever to get to the top of the search results.
Spend the extra time now to do proper keyword research. It will save you a ton of time and hassle later. This is time well-spent.
If you remember from the last installment, when we researched products to promote, we narrowed our choices down to a few products.
What I’ve done is create a spreadsheet to score the products. You can see the spreadsheet here. I’ll explain the columns as we populate them.
The first column contains the name of the product. Easy. We’ve got 10 products. I’m going to walk through scoring 1 product, then, through the magic of the internet, I’ll populate the rest, and you’ll get to see the results instantly. Wow.
The second column is the global search volume for the exact search term. I base my product niche sites primarily on the demand for a given product. Everything else is a secondary consideration.
To find the demand for a product, go to the Google Adwords Keyword Tool. In the “word or phrase” box, enter your product name, exactly. In this case, it’s “X-Pain Method”. When the search results come up, change the match type to “Exact”. You should have something like this:
Enter the global search volume in column 2. In this case, it’s 73. Keep this window open, because we’ll be coming back to it.
Column 3 is the search competition. Go to google and enter your product name, in quotes. In this case, “X-Pain Method”. Put the total number of search results in column 3: 223000.
Column 4 is the search competition, but only what appears in a page’s title. Your search query is intitle:”X-Pain Method”, which yields 4400 results.
The next column is for the average PageRank of the first page of search results. For this, I use Traffic Travis. I use the 4th edition, which is paid software, but you can get the free version of version 3, instead. I’ll use version 3 for this example. Open the software and click on “SEO Analysis” on the bottom left of the screen. Put your search term (“X-Pain Method”) in the “phrase to analyze” and set the “Analyze Top” to 10, then hit “Analyze”. When it’s done running, just add up all of the PRs and divide by 10. Ignore Travis’s difficulty rating.
Now, for the rest of the columns, we’re going to look at the keyword tool again. We’re going to pick 3 alternate search terms. Here are the criteria:
- At least 1000 global monthly searches. We want terms that people are searching for.
- Competition bar at medium or less. This bar is just a rough guess on competition, so it’s really an arbitrary exclusion factor, but it helps narrow down the choices.
- A “buying” keyword is preferred, but not necessary. This is a term that indicates people are looking to spend money. “Back pain doctor” is a buying keyword, but it’s not an indicator that someone wants to buy a product, so we’ll skip it. A buying keyword isn’t absolutely necessary, because these will also be the terms we’ll use to generate content later.
- It has to be related to our product.
Once we pick the keywords, we’ll throw them into google to get the competition, just like we did to populate column 2.
“Exercises for back pain” has medium competition and 1900 monthly searches. It also has an estimated cost-per-click of $3.02, which means people are paying for this.
“Lower back pain exercises” has 6600 searches and medium competition. It’s actually on the lower end of medium, so it looks really promising.
“Lower back” has 4400 searches and low competition, with a CPC of $6.24. This should be a good one. Scratch that. It has 40 million search results, but only 4400 searches. That’s a lot of competition for a small market.
Instead, I’m going to search for “cure back pain” in the keyword tool and see what I get. “Upper back pain” is better. Low competition, 18000 searches each month, and only 2000000 competing search results. Now, I’ll score it.
You really want at least 500 searches per month for the product name. More than 2500 is better. I’m going to assign 1 point per 500 monthly searches.
You also want a lower number of search results. Less than 10,000 is ideal. Less than 100,000 is still decent. More than 250,000, I’d walk. So, under 10,000 gets 5 points. Under 50,001 gets 4. Under 100,001 gets 3. Under 200,001 gets 2. Under 250,001 gets 1. Any higher gets 0.
The ideal intitle search will have less than 2000 results. More than 100,000 is too time-consuming to deal with. 0-2000: 5 points; 2001-10,000: 4 points; 10001-25000: 3 points; 25001-50000: 2 points; 50001 to 100000: 1 point.
The perfect product will have the first page of search result all with a PageRank of 0. That’s a 5 point product. I’ll knock off half a point for every point of average PR.
The related terms are more relaxed. They are what’s known as “Latent Semantic Indexing” (LSI) terms. We will be creating articles to match those search terms, mostly to make our niche site look as natural and real as possible. Any actual traffic those pages drive is just gravy. Points for the related searches start at 10 and get 1 point knocked off for each 3 million results. We’ll be treating the 3 terms as one for this score.
That gives us a perfect score of about 25. There’s no actual upper limit, since the score for the search volume has no upper limit. X-Pain Method scored 18.22.
Now, excuse me a moment while I score the rest.
I’m back. Did you miss me?
I’ve finished scoring each of the products and sorted the results by score. The clear winner is the back pain product, but the lack of searches bothers me. The wedding guide looks much nicer, especially if I target the phrase “wedding planning guide” during the SEO phase of the project. That change alone brings the score almost to first place.
Frankly, I’d take either 2nd or 3rd place over the back pain product. The bare numbers don’t support it, but my judgement tells me they are better products to promote.
There is one final step before deciding on the product. I have to buy it. I can’t review the product without seeing it and I can’t promote it without approving of it.
That’s the secret to ethical niche marketing, you know. Only promote good products that you’ve personally read, watched, or used.
Your Budget is Worthless
When you realize that you’ve buried yourself in debt and decide to get out from under that terrible burden, the first thing you’ve got to do is build a budget because, without that, you’ve got no way to know how much money you have or need. After you’ve got a budget, you’ll start spending according to whatever it says. Hopefully, you’ll stay on budget, but what happens when an emergency does come up? What do you do when your car dies? When you suddenly find out your kids needs vision therapy? How do you manage when your job suddenly gets shipped off to East De Moines?
Your budget isn’t going to help you meet those expenses. Most people don’t have enough money in their bank account to make it all the way to the next payday, let alone enough to keep the lights on and food on the table. How can you possibly hope to deal with even the little things that come up?
You whip out your emergency fund.
The problem with a budget is that it does a poor job of accounting for the unexpected. That’s where an emergency fund comes in. An emergency fund is money that you have set aside in an available-but-not-too-accessible account. Its sole purpose is to give you a line of defense when life rears up and kicks you in the butt. Without an emergency fund, everything that comes unexpectedly is automatically an emergency. With an emergency fund, the things that come up are merely minor setbacks. Without an emergency fund, your budget is nothing but a good intention waiting to get shattered by the next thing that comes along. With an emergency fund, you are managing money. Without it, it’s managing you.
How much money do you need in an emergency fund?
Every “expert” has their own opinion on this. Dave Ramsey recommends $1000 to start. Suze Orman says 8 months. The average time spent looking for work after losing your job is 24.5 weeks(roughly 6 months), so I recommend 7 months of expenses. That’s enough to carry you through an average bout of unemployment and a little more, but that’s not a goal for your first steps toward financial perfection. To start with, get $1000 in a savings account. That’s enough to manage most run-of-the-mill emergencies, without unduly delaying the rest of your debt repayment and savings goals.
How do you build an emergency fund?
Let’s not kid ourselves, $1000 is a lot of money when can barely make it from one check to the next. Unfortunately, this vital first step can’t get ignored. If you really work at it, you should be able to come up with $1000 in a month or so. Here are some ideas on how to manage that:
- Cut. Drop every possible expense. If you drop cable, your cell phone, Netflix, and a weekly dinner out, you will already be saving $400 that month. You’d be almost halfway there.
- Sell. How much stuff do you have that you don’t need, want, or use? I’d be willing to be there’s more than you realize. Last spring, I had a garage sale that brought in about $1300. Everything we sold was just crap we don’t use any more. We sold candles and candle-holders, DVDs, books, clothes, toys, electronics, games, and anything else we could find. I spent a month going through every room in my house to find my inventory. Craigslist is a good way to sell just one or two things at a time.
- Work. Have you thought about delivering pizza or working weekends in a gas station? If you have some technical or writing ability, you could pick up some part time work on oDesk or eLance. Your opportunities are only limited by what you are willing to do.
Stop at a grand?
Dave Ramsey’s advice is to get your fund up to $1000 and then leave it alone until your debt is paid off. Screw that. I’ve got money going into my fund every month. It’s only $25 per month, but over the last two years, it has almost doubled my fund. Don’t dedicate so much money that you can’t meet your other goals, but don’t be afraid to keep some money flowing in .
Using the fund?
When can you pull the money out? That is entirely up to you. I have ju st two points to make about withdrawing from your emergency fund:
- Don’t keep the money in an easy-to-access account. If your fund is in the savings account that serves as your overdraft protection account, it’s too easy to spend it, and it will go away. I keep it in my INGDirect account. I don’t use the checking account for anything in person, so I don’t carry the card. If I want to spend that money, it will take 2-3 days to transfer into my main bank account.
- Never decide to spend the money on the spur of the moment. There are very few major financial decisions that can’t wait until morning to be answered. Sleep on it. If it’s still necessary tomorrow, you can spend it without guilt.
An emergency fund makes your life easier and your budget possible when the unexpectable happens. Don’t forget to fund yours.
How much money do you keep in your emergency fund? What would it take to get you to spend it?
Karate Guess So
“Walk on road, hm? Walk left side, safe. Walk right side, safe. Walk middle, sooner or later, [makes squish gesture] get squish just like grape. Here, karate, same thing. Either you karate do “yes”, or karate do “no”. You karate do “guess so”, [makes squish gesture] just like grape. Understand?” -Mr. Miyagi
It occurred to me that lately, I’ve changed my day-to-day cash flow plans a couple of times.
A year ago, I was running on a fairly strict cash-only plan.
A month ago, I was running on a strict budget, but doing it entirely out of my checking account.
Now, I’m loosening the budget reins, and moving all of my payments and day-to-day spending to a credit card, including a new balance that I can’t immediately pay off.
The thing is, changing plans too often scares me. Like the quote at the beginning of this post, I start worrying about being squished like a grape.
The simple fact is that any plan will work.
If you want to get out of debt, just pick a plan and run with it. If that means you follow Dave Ramsey and do the low-balance-first debt snowball, good for you. Do it. If you follow Suze Ormann and do a high-interest first repayment plan, great. Do it. If you follow Bach and pay based on a complicated DOLP formula to repay in the quickest manner, wonderful! Do it!
Just don’t switch plans every month. If you do that, you’ll lose momentum and motivation. Squish like grape! Just pick a plan and go. It really, truly does not matter which plan you are following as long as you are following through.
This applies to other parts of your life, too. For example, there are a thousand fad diets out there. Here’s a secret: they all work. Every single one of them, whether it’s Weight Watchers, slow carb, or the beer-only diet. The only thing that matters is that you stick to the diet. If you manage that, you will lose weight on any diet out there. Except for the jelly bean and lard diet. That one will make you extra soft.
Another secret: the productivity gurus are right. Every single one of them. David Allen, Stephen Covey, Steve Pavlina, and the rest. They all have the One True Secret to getting the most out of your day. Really. Pick a guru and go! But don’t try to Get Things Done in the morning and do 7 Habits at night. Changing systems, changing plans, changing your mind will make you sabotage yourself.
The real secret to accomplishing great things, whether it’s paying off $100,000 of debt, dropping 40 pounds in 3 months, or tripling your productivity is to do it. Just get started and, once you’ve started, don’t stop. If you keep going and stay consistent, you’ll accomplish more than anyone who hops from system to system every few weeks.
The Things That Bring You Here
I’ve been walking though my analytics data. That is the Big Brother software I use to know everything about each one of my dear readers. It’s all part of my master plan to rule the world. Muwahaha!
Some of the results are interesting.
The single most-used search term to find this site is “slow carb diet“, which is great, because I really enjoyed writing that post. I’ve been slacking on the diet lately, but I’m still down more than 30 pounds. I’m currently ranked #3 in Google for this term. If I move up 2 more spots, I’ll outrank Tim Ferriss for his own product. If I aggregated all of the “slow carb” variations, this post probably accounts for more than half of my traffic from Google.
Many of you come here by searching for “how to have a perfect life“. I’ll do everything I can to help you achieve that, but it’s going to take work on your part. There are no shortcuts.
“Beat the Check” is another popular search term, but a very bad game to play. It’s almost impossible to win it, since the Check 21 Act of 2004.
It’s interesting that “trained husband” brings a few of you each month. My question: are you shopping, or exploring a new fetish? Don’t be shy.
I’m a bit amazed that “zombie wheels” is something people actually search for, but 140 people hit Google looking for that term every month, and a few of them make it over here.
“How to stretch a meal“, “things you should buy online“, and “unsecured loan advice” are some of the top personal finance terms bringing you all in, though “how to make a bunker” and its variation are popular, too.
“Hoe can you force your wife” is a bit disturbing. Most of the results are naturally for sex. I can’t help but hope that I’ve either really disappointed this visitor, or convinced him that force is a bad idea.
“How much did a pound of gold weigh in 1854?” is a search that makes me giggle. To the best of my knowledge, the troy scale has been used to weigh gold for a lot longer than that.
That was a fun little stroll through my statistics. Hopefully the fact that I used “fetish” and “sex” in a post will draw more crazy search terms.
How did you find me? Inquiring minds want to know, so please tell me in the comments.
Carnival of Money Stories – Halloween Aftermath Edition
- Image by Dunechaser via Flickr
Welcome to the November 1, 2010 edition of the Carnival of Money Stories. One thing I didn’t do when volunteering to host this was to check my calendar. Did you know that November 1 follows October 31, every year? On Saturday, I had 30 people over for my annual Halloween party. On Sunday, I ran a haunt in my yard and coordinated to get a dozen kids out begging for candy while using my house as a base of operations. I’ve had guest from out-of-town since Friday. Halloween weekend is, by far, the busiest weekend of the year at my house.
Editor’s Picks
J. Savings presents Side Hustle Series: I’m a Restaurant Server posted at Budgets Are Sexy, saying, “Is serving tables thankless work? Yes. Are customers sometimes unpleasant? Of course. But the benefits are plenty!”
Wenchypoo presents Marketing, Marketing Everywhere–There’s No Escape! posted at Wisdom From Wenchypoo’s Mental Wastebasket.
The Wise Squirrel presents Does it Matter Who is the Main Provider Between Husband and Wife? posted at Squirrelers, saying, “Money story about a dual-income couple in which the husband had the opportunity for a big promotion that would have required a move, AND his wife to leave her job. Their different viewpoints are discussed.”
Business
Ryan @ CML presents Get a Tax Deduction for a Working Vacation posted at Cash Money Life, saying, “Tips on how to write off a business trip as a tax deduction.”
Career
Jeff Rose, CFP presents How to Pass the CPA Exam and Become a Certified Public Accountant posted at Jeff Rose, saying, “If you are interested in becoming a CPA, here are some of the experiences of someone who just recently passed the CPA exam.”
Jason @ Redeeming Riches presents What Sam Walton Teaches Us About Money, Success, and Family posted at Redeeming Riches, saying, “Sam Walton had it all – or did he? Find out the biggest regret he had on his death bed.”
Credit
Mr Credit Card presents Cash Vs. Credit, A Real World Experiment posted at Ask Mr Credit Card.
Debt
The Family CEO presents Debt Snowflakes: Or How I Made $821.73 in Extra Credit Card Payments This Month posted at The Family CEO.
Kaye presents Stuck in the Middle posted at Mrs Nespy’s World, saying, “The beginning of the journey was excited, the end will be exhilarating, but this “in the middle” stuff is for the birds.”
Kate Kashman presents Why Not To Bounce Checks posted at The Paycheck Chronicles, saying, “An accidental bounced check in college is still causing trouble, 20 years later.”
Michael Pruser presents Managing $225,000 in Debt Is Starting to Ware on Me posted at The Dough Roller, saying, “My struggles on managing a ton of debt!”
PT presents 5 Lessons Learned From Filing Bankruptcy posted at Prime Time Money, saying, “Lessons learned from an actual account of going through a bankruptcy.”
Silicon Valley Blogger presents Should You Pay Off Loans or Invest Your Money? posted at The Digerati Life, saying, “So you’ve got some money. Should you pay off your debt with it or invest the money? Here’s a personal account on what I’ve done.”
Housing
BWL presents Success Story: Paying Off A House In 5 Years While Tithing posted at Christian Personal Finance, saying, “This is an encouraging story of a woman who stuck to her convictions about giving 10% of her income and still managed to pay off her house in less than 5 years!”
Miranda presents Do I Really Want to Rent Out My House? posted at Personal Dividends – Money+Lifestyle.
Investing
2 Cents presents What Would Make Me Invest in the Stock Market? posted at Balance Junkie, saying, “We have not invested in the markets for a while now. A reader recently asked what it would take for us to get back in. Here’s my answer!”
FIRE Getters presents Early Retirement Case Study – Sandy Aldridge and Dale Lugenbehl posted at FIRE Finance, saying, “At times the fast pace of our city lives appear stifling making us long for a slower pace of life with more exposure to clean air and green vegetation. Our souls yearn for a simple life which is in greater harmony with Mother Nature. Of late our work related health problems have been making us yearn, almost every morning, for a more relaxed life with greater freedom. So we were thrilled to read about Sandy Aldridge and Dale Lugenbehl who retired early (at ages 48 and 47 respectively) more than a dozen years ago to their eight-acre farm in Cottage Grove, Oregon …”
Other
Neal Frankle presents Find A High Paying 2nd Job Using Craigslist posted at Wealth Pilgrim: Money Management Advice, Financial Stess Management, Addiction Recovery Plan & Resources, saying, “You Can Find A High Paying 2nd Job Using Craigs List If you’re looking for high paying 2nd jobs, look no further than your computer screen.”
Super Saver presents Retiree Financial Lessons from the Recession posted at My Wealth Builder, saying, “Although I wish this recession had not happened, I am glad that it happened early in our retirement, while we were better able to meet the financial challenges.”
Craig Ford presents Medi-Share Medical Sharing | A Health Insurance Substitue posted at Money Help For Christians, saying, “Medical sharing is a great way to reduce your health insurance costs.”
passive family income presents Cutting Out Wasted Expenses to Save More Income posted at Passive Family Income, saying, “How many wasted expenses are you paying for? After sorting through my family’s past years credit card and bank statements, I have found several small money leaks in our personal finances.”
Kristina presents Our Parents Estate posted at Dual Income No Kids, saying, “If your parents are divorced, how has their separation affect the way you have planned your estate?”
Donna Freedman presents Rockin’ the surveys — when it’s worth it. posted at Surviving and Thriving, saying, “Online surveys can be a nice source of extra income — except when they aren’t.”
Joe Plemon presents My Car Needs an Engine. Should I Sell it, Fix it or Junk it? posted at Personal Finance By The Book, saying, “What do you do when your beloved car needs an engine: sell it, fix it or junk it? This post explores the options.”
FMF presents My Type of Couple posted at Free Money Finance, saying, “Story of a couple who collected 400k cans to pay for their wedding.”
Lindy presents Once Upon a Time…I Used an Iron posted at Minting Nickels, saying, “One of the likely first stops in expense-slashing is the luxury of paying for laundered shirts. This is a tale of my ironing saga (yes, it qualifies as a saga). And it’s not as boring as this description sounds. Thanks!”
Sandy presents One Disaster Away posted at Yes, I Am Cheap, saying, “We sometimes pass judgment on others for the financial situation, but most of us need to realize that all it takes is one disaster to be in the same situation.”
Bucksome presents Top 7 Ways I Budget My Time posted at Buck$ome Boomer’s Journey to Retirement, saying, “Budgets are needed for more than money in this story about 7 ways to budget time.”
Tom @ Canadian Finance Blog presents How to Watch Cheap and Free TV in Canada posted at The Canadian Finance Blog, saying, “Want to know how to see free TV in Canada? You have a few options with over the air free HDTV, broadcaster’s websites and cheap services like Netflix!”
Lauren Mendel presents A Very Scary Money Story posted at Richly Reasonable – Successes and failures, all in the name of living reasonably., saying, “This Halloween week read the true, terrifying tale of how Husband and I almost lost literally every important document that we have. Muahahaha! You might want to lock your doors and close the blinds before reading this one…”
Sun presents What’s in My Wallet? posted at The Sun’s Financial Diary.
Shopping
Money Beagle presents Costco Coupon Policies – Truth or Fiction? You Decide posted at Money Beagle.
ctreit presents Our family budget has to accommodate this chocolate snob posted at Money Obedience, saying, “Name brands versus store brands.”
Rachel presents Sometimes Less Is More | MomVesting posted at MomVesting, saying, “Melinda talks about how the value of many things isn’t necessarily determined by their cost.”
That concludes this edition. Submit your blog article to the next edition of Carnival of Money Stories using the carnival submission form. Past posts and future hosts can be found on the blog carnival index page. Thank you, everyone, for participating!
