Managing Pay Per Click Keyword

Struggling to understand Niche Inspector CPC data?

Think about managing pay per click keyword data.

CPC (Cost Per Click) to you, the publisher, is the other side of the coin to advertiser’s PPC (Pay Per Click)

There’s a helluva lot of advertiser information in your Niche Inspector data. It is important to you as a publisher. You need to see where advertisers are spending money.

Once you find a niche where advertisers are spending you need to stand back, consider your goals, then develop a plan.

Do not just filter your list to get rid of keywords with a pay per click below an arbitrary level. Look at all your options, then rank your list.

Read the rest of this entry »

Related:
  • Niche Marketing Trio

    My niche marketing trio are excellent for any type of website strategy, but when you are working in a profitable niche, these tools really boost your results.

    Imagine a tool to find you profitable niches (you can probably guess which I’m talking about) working with a second tool to help you reach all corners of your niche.
    Imagine that second tool pushing the boundaries of your niche without losing advantages of your niche focus.
    Imagine a third tool to shine the light from your niche and let the world know about your site.

    Today, an interesting visitor showed me how my magnificent niche marketing trio are working together to burgeon and burnish my flourishing niche.

    Read the rest of this entry »

    Related:
  • Niche Inspector Review News

    Regular visitors will have noticed some strange happenings here at Niche Inspector Review.

    No posts for a month, then no site for a week, then site back but still no posts.

    If you are interested in what goes on here, then let me explain what has been happening, and how it is going to lead to some fantastic new developments.

    You’re loving Niche Inspector - just wait for Niche Exploiter!

    Read the rest of this entry »

    Related:
  • Niche Software Update

    I have just released a niche software update to my Niche Inspector Strategy Tool.
    This makes ranking your best niche keywords even easier. It is now more flexible, so you can match your rankings to your site objectives.

    Updating should be a simple process, except that Google has introduced a 1000 cell copy limit on it’s spreadsheets. I have not heard back from Google yet if this is a permanent limit.

    You have 2 choices:

    1. Use a spreadsheet program such as OpenOffice, or MS Office
    2. Copy and paste from a Google spreadsheet 62 rows at a time

    If you have a fairly tight niche, with less than 200 keywords, then option 2 is quite easy, and should not need much more explanation. Just open your exported Niche Inspector data in Google Spreadsheets, then copy 62 rows at a time into my niche software tool. You may find it easier to keep track of where you are if you copy and paste 60 row blocks.

    Option 1 is also very easy, but it does require that you have a spreadsheet program installed on your computer. OpenOffice is free, and easy to install from www.openoffice.org. If you use a spreadsheet, then most ask you for a starting row when you import a CSV. Make your life alittle easier by starting at Row 2 - you do not want the Niche Inspector Data headers because they are already in my Niche Strategy Tool.

    Improved Keyword Ranking

    Once you’ve got your data into my niche software, you now have more options for ranking.

    One ranking feature that wasn’t clear in the original version is that it is best to chose your CPC ranking and sort by it before you paste the data. Niche Inspector sorts by maximum CPC bid to give you the best idea of where advertisers are spending money. Once this gets into the Niche Strategy Tool, it becomes alphanumeric, with fairly useless sorting capability.

    You can decide all your other Ranking options once you’ve transferred the data.

    The big changes are:

    1. Ranking lists are now within the tool - no need to type your own rankings in. Just copy and paste.
    2. You can weight different factors by applying more rank points to some factors that others.

    This second new feature lets you prioritize your niche keywords much closer to your site objectives. If a quick start is important, give more weighting to KEI. If you want a consistently performing AdSense site, give more weighting to Number Of Google Advertisers. If you’re not sure yet, just get started with the standard rankings - you can always come back and change them later.

    If you need any help with this, or any other aspect of niche software, just ask me.

    Related:
  • Niche Strategy

    A few days ago, a friend asked me, “Can you help give me ideas to improve on my traffic and to monetize?”
    Today I realized how my reply was the basis of a fantastically easy niche strategy.
    A simple way to harness the power of Niche Inspector to build a system for strategic website growth.
    I have built a free niche strategy tool for you.

    First, let me explain how I came to develop this free niche strategy tool, and how it works.

    My friend’s site is based on a fairly tight niche activity, but I noticed related words, particularly for equipment required for that activity. By way of example, let’s assume that you are hooked on calculating. With today’s emphasis on fighting the effects of advancing years by exercising your brain, you might set up calculating-for-health.com (first person to do this can e-mail me for some publicity - let’s face it you will need all the help you can get)

    So assuming the site was about calculating, I also researched calculate and calculator. Depending on the speed of the Internet, this takes from 5 to 15 minutes, my example took 9.2 minutes total, plus the time it took to type in the keywords. On my friends site, this gave me 300 keywords, but this niche is so tight that we only manage 205. If your heart is set on wasting your time in this niche, you might easily think of a few related keywords to add, including obvious misspellings that I will write about on another day.

    Oops, I still had the settings on Germany (see my previous post). The demand and profitability did not look good enough to sustain a profitable site. They might in a US, or global market. If they do, remember where you got the idea.
    Back to my story.

    By sorting on the appropriate column headings, I quickly produced 4 lists of 20 keywords that meet different aspects of a good niche strategy. There is some overlap, but the combined list should give you enough topics to get a website big enough to get noticed.

    In the example that follows, I have kept all the keywords in place. In real life, I would have deleted terms that did not fit in with my theme of calculating for health.


    Niche Strategy To Exploit Maximum Revenue

    Look for the big earners. What are advertisers paying for? A quick click on Niche Inspector’s Broad Match CPC button shows the top 10 to be:

    1. student loan consolidation calculator
    2. debt consolidation loan calculator
    3. loan consolidation calculator
    4. refinance mortgage rate calculator
    5. mortgage refinance calculator
    6. refinance calculator
    7. retirement planning calculator
    8. home equity loan calculator
    9. calculator card consolidation debt credit
    10. reverse mortgage calculator

    In this case, most of the high earning clicks have several advertisers, but some only have a few. I have seen what happens when there are only a few advertisers. Their budgets soon get used up and you spend half a month displaying public service ads. We need a more diverse niche strategy.


    Niche Strategy For Most Consistent Revenue

    Look for popular advertising keywords. A quick click on Niche Inspector’s Number of Google Ads button shows the top 10 to be:

    1. debt consolidation calculator
    2. student loan consolidation calculator
    3. debt consolidation loan calculator
    4. home equity loan calculator
    5. calculator card consolidation debt credit
    6. mortgage refinance calculator
    7. debt calculator
    8. mortgage rate calculator
    9. retirement calculator
    10. refinance calculator

    As you see, a few overlaps, but I’ll cover this later. Before that, there are another couple of aspects to our niche strategy that generate two more lists.


    Niche Strategy For Maximum Traffic

    Look for high search volume keywords. A quick click on Niche Inspector’s Searches button shows the top 10 to be:

    1. mortgage calculator
    2. calculator
    3. loan calculator
    4. love calculator
    5. bmi calculator
    6. online calculator
    7. auto loan calculator
    8. ovulation calculator
    9. tax calculator
    10. pregnancy calculator

    These high volume search terms form our main longterm targets. On our website, they will often form the Tier 2 pages, or Main Categories, depending on how we build our website. This is really a topic for at least one separate article (send me a message if you can’t wait). To complement them, we need some short term topics that will get us started quickly.

    Niche Strategy For Quick Easy Traffic

    Look for keywords with high search:results ratio. Though Niche Inspector includes this simple ratio, it is better to use a demand weighted ratio called KEI. If you don’t know what KEI means, I will explain it better in a future article. If you do know about KEI, e.g. from WordTracker, don’t get too excited about the big numbers - they are due to me using the allintitle command, which I will explain in a separate article. A quick click on Niche Inspector’s KEI button shows the top 10 to be:

    1. formula to calculate mortgage payment
    2. weight watcher point calculator
    3. due date calculator
    4. weight watcher online point calculator
    5. calculate chess tactic
    6. calculate child support payment
    7. calculate due date for pregnancy
    8. calculating square foot
    9. mortgage calculator
    10. car payment calculator

    How Do 4 Lists Make A Niche Strategy?

    To build a workable niche strategy, you need a system. 4 lists do not a niche strategy make, so let us build a proper working model. With a few simple clicks, the Niche Inspector Keyword data is transformed into a niche strategy spreadsheet.

    After opening Niche Inspector’s CSV output in Google Spreadsheets, I added some ranking and other columns. The extra columns are:

    Notes
    Just a spare column for you to add some notes

    CPC Rank
    After sorting by column U (descending CPC) I numbered the top 100 in descending order. If you need help preparing a copy and paste list, or any other aspect of Google Spreadsheets, just ask. You can sort by other CPC columns and vary the number of keywords you rank. I just picked 100 out of thin air - there is no significance.

    Ads Rank
    All these ranking numbers are prepared the same way, by pasting (or typing if you like spending time on the number pad) in the 100 to 1 number list. Before you do this one, sort Column T (number of Google Ads) in descending order)

    Search Rank
    Sort by column J (Searches) before pasting in your 100-1 list as above.

    KEI Rank
    Sort by column L (Google KEI) before pasting in your 100-1 list as above. There are actually some good reason why to choose some of the other columns, K to S, at this stage. Remind me to write a separate article on this some time.

    Total Rank
    This helps you to prioritize which keywords to write about first. The unranked ones may have some value, but by the time you have written 193 pages, your content will probably being driven by your visitors anyway.

    Date Done
    To help you keep track of where you are, after you have published a page, type the date in this column. Before you do this, it is a good idea to click File - Spreadsheet Settings and choose your country, which sets an appropriate date format.

    URL
    When you set the date, as above, you can also paste the URL here. Sometimes, I make more than one page for a keyphrase, with words in a different order, or pluralized, or slightly different in some other way. In which case, I leave the Date Done blank until I have published all the pages.

    Your Own Niche Strategy Tool

    You can view the published version of this Niche Strategy Tool. This online document is completely free, but limited by it’s static nature.

    If you want to play around with the dynamic Google Spreadsheet, send me a message via my Contact Page, and I will add you as a collaborator. This will allow you to play around with the figures in the model, or if you are a Niche Inspector owner, you can paste in your own keyword data. In either case, you simply save your own private version of the spreadsheet and you have your own prioritized site plan.

    If you want me to do your keyword research and build a model based on your own site concept, it’s $20 for your own 3 keywords. If you do not have a clue where to start, I will even find a niche for you.

    Related:
  • Close
    E-mail It