- I tried to avoid it. I really did, but I’m still getting a much bigger refund than anticipated. #
- Did 100 pushups this morning–in 1 set. New goal: Perfect form by the end of the month. #
- RT @BudgetsAreSexy: Carnival of Personal Finance is live 🙂 DOLLAR DOODLE theme: http://tinyurl.com/ykldt7q (haha…) #
- Hosting my first carnival tomorrow. Up too late tonight. #
- Woot! My boy won his wreslting match! Proud daddy. #
- The Get Home Card is a prepaid emergency transportation card. http://su.pr/329U6L #
- Real hourly wage calculator. http://su.pr/1jV4W6 #
- Took my envelope budget out in cash, including a stack of $2s. That shouldn’t fluster the bank teller. #
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.
Twinkies: A Failure of Unionization
Twinkies may survive nuclear warfare, but the iconic sweet treat ultimately couldn’t withstand the might of the unionized workforce. Faced with mounting losses and overwhelming debt, due in no small part to the relentless demands of the various unions representing the nearly 19,000 employees, Hostess Brands filed bankruptcy for the second time in January 2012 and ultimately requested permission to liquidate it’s assets in November of last year when a buyer failed to materialize. While many factors played a part in the demise of the maker of such all-American snacks as Ding Dongs and Ring Dings, as well as childhood favorite Wonderbread, there is no denying the fact that costs imposed by union contracts were a major factor in the shuttering of this once-beloved company.
Certainly America’s changing eating habits, increased competition from such companies as McKee Foods, makers of Little Debbie snack cakes, and rising commodity costs all contributed to the ultimate demise of Twinkies. There is no doubt, though, that union contracts inhibited the company’s ability to adapt and make the necessary changes to remain profitable. Not only were employee costs out of control, ridiculous union rules made it nearly impossible for the company to make money. These are just a few of the rules that hampered Hostess’ management:
- Twinkies and Wonder Bread could not be delivered on the same truck.
- Drivers could only deliver one product, even if they did not have a load and a load of another product was waiting to go out.
- Drivers could only drive. They had to wait for loaders to fill their trucks.
- Likewise, loaders could only handle one product. Their contract prohibited a Twinkie loader from helping out if the Wonder Bread loaders were shorthanded.
Yes, management agreed to these terms, but often they were forced to do so in order to prevent a costly strike. In fact, it was a labor strike that lead to the decision to liquidate.
Unions are meant to protect workers from dangerous working conditions, overbearing management and unfair labor practices. Ensuring a living wage and decent benefits is another of their responsibilities. However, it is evident that in this case, the unions became as much an enemy of the Hostess employees as of the company’s management. As a result of their unwillingness to compromise and make wage and benefit concessions, almost 20,000 people no longer have a job that needs to be protected. In the end, the unions drove not only the company but themselves out of business.
Not to fear, however. Two private equity firms acquired Hostess’ assets last fall and are beginning to turn the company around. Production of Twinkies began again in June, and the gooey sponge cakes returned to store shelves on July 15. The workforce has been dramatically reduced and will not be unionized. In the end, probably the only winner in this battle is America’s sweet tooth.
Related articles
Refinancing Through the HARP Program
HARP Refinance
If you owe more than your house is worth, and want to refinance to today’s low interest rates, you need to check out the HARP program. Millions of homeowners with underwater homes are finding relief in a new version of the Home Affordable Refinance Program (HARP). Refinancing to lower interest rates could slash your monthly mortgage payment or shorten the time it takes to pay-off your mortgage.
The new HARP loosened qualification rules, making it it easier for underwater homeowners to qualify for a refinance. When HARP 2.0 was released in November 2011 you had to work with your original lender. Since March 2012, when Fannie Mae and Freddie Mac rolled out the automated underwriting systems, you can work with any participating HARP lender. That means more competition for your business and better rates for you
HARP 2.0’s Hurdles
There are two series of hurdles you must clear before you can refinance your loan under HARP 2.0. The first set of hurdles concerns the loan itself. The three key eligibility questions are:
- Is the loan owned by Fannie Mae or Freddie Mac?
- If so, was the loan purchased by Fannie or Freddie on or before May 31, 2009?
- The loan was not refinanced under HARP before (some exceptions apply).
If you answer yes to these three questions, then your loan may be eligible for HARP.
Tip: If your loan is a FHA loan, then check out a FHA streamline refinance loan.
The second set of hurdles concerns your finances and property. Fannie Mae and Freddie Mac set up the basic guidelines. There are two basic ways your loan can be processed:
- Manual Underwriting System: Only your original lender (who is also your current servicer) can process a HARP loan through the manual underwriting system.
- Automated Underwriting System: Any participating lender can process a HARP loan through the automated system.
Keep in mind that lenders are free to have stricter qualifying rules than the basic Fannie and Freddie requirements.
When shopping for a HARP loan, here are some of the main points to look out for:
- Credit Score Requirements: Fannie and Freddie have no minimum FICO score requirements. However, each lender has its own credit score requirements, so if you are denied by one lender, keep shopping.
- Income Requirements: Your original lender can approve a loan with no debt to income ratio (DTI) requirement. However other lenders must qualify you based on your DTI. The rule-of-thumb for a HARP loan is a 45% maximum DTI.
- Timely Mortgage Payments: The HARP program allows for no late mortgage payments in the last 6 months and one late (30 days) payment in the preceding 6 months. However, some lenders do not allow any late payments.
- Investment Properties Qualify: You can refinance a second home or rental property under HARP 2.0.
- Fees: Lenders are not consistent in the fees or the interest rates they charge for HARP 2.0 loans. Some lenders charge a few hundred dollars for HARP 2.0 loan fees, and others charge thousands. It pays to shop around, so you can compare interest rates and fees.
- Condos: While HARP guidelines for condos are tricky, many more condo owners will qualify for a loan under HARP 2.0 than under the first version of HARP.
Applying for HARP
First, go to the Fannie Mae and Freddie Mac Web sites to learn if either owns your loan and whether they bought your loan on or before May 31, 2009. If so, you can contact either your current mortgage servicer or shop around with the many lenders who are offering the HARP 2.0 loan.
If your application is rejected, ask for the specific reason why. If you applied with your original lender, find out whether the lender used the manual or automated system. Request manual underwriting if your original lender turned you down based on automated underwriting, as it may result in your loan being approved.
It pays to shop for HARP 2.0 refinance. Many homeowners report one lender will reject their application, but another will offer them an attractive refinance. Second, lenders are not consistent in their offers. As mentioned, closing costs are all over the map. Interest rates vary, too.
Summary
HARP 2.0’s rules are technical. Each lender creates different overlays. If you believe you qualify for HARP 2.0, be persistent! The rules that are in place today could very well be expanded in the future. This is one instance in life where shopping can be the solution to your problem.
Net Worth Update – January 2014
This may be the most boring type of post I write, but it’s important to me to track my net worth so I can see my progress. We are sliding smoothly from debt payoff mode to wealth building mode.
Our highlights right now are nothing to speak of. We did let our credit card grow a little bit over the last couple of months, but paid it off completely at the end of December. It grew mostly as a matter of not paying attention while we were doing our holiday shopping and dealing with some car repairs.
That’s it. We haven’t remodeled our bathrooms yet, but we have the money sitting in a savings account, waiting for the contractor. We haven’t bought a pony yet, but we did decide that a hobby farm wouldn’t be the right move for us. We’ll be boarding the pony instead of moving, at least for the foreseeable future.
Our net worth is up $13,000 since September. Our savings are up and our retirement accounts are down because there are two inherited IRAs that we need to slowly cash out and convert to regular IRAs.
Effen Carpets, Effen Pets
We’ve got pets. Lots of pets.
- 4 cats
- 3 kids
- 2 pythons
- 1 dog
- 1 hamster
And yours truly.
I count, I make a good mess.
Pets have hair. Well, except for the python and the horrible abominations of mis-evolved Chinese food known as bald cats.
Pet hair gets every-damn-where.
A few weeks ago, we watched our friend’s dogs for a few days.
Those things pee. Not in the backyard like good dogs, but on the girls’ bedroom carpet.
I hate pee.
Not my own, of course.
I really, really hate animal pee in my house.
So we got the carpets cleaned. Linda told me it would be a bit more than normal, since we were going to get the air ducts cleaned at the same time. I was fine with that. Animal hair gets everywhere, and in the ducts, it makes the furnace and air conditioner work poorly.
Then, I got an email alert from Capital One.
Seven hundred freaking dollars!
That’s about $400 more than I was expecting.
Not flipping thrilled! <—-Understatement.
Thankfully, we have money tucked aside for crap like this, but if stuff keeps coming up, we’re going to be hosed.