Small Business Marketing Insight Tip:
Writing articles while keeping your keywords in mind just got easier.Now, as you know from following this series of blog posts, I'm a big fan of using RankTracker to compile a spreadsheet of keywords - then mining that spreadsheet with a database.
Then you write your articles keeping those keywords in mind. And you can do this all from OpenOffice.
I used to keep a list of keywords to hand, and then started keeping a spreadsheet open on a second monitor while I wrote my articles on my main one. What I found out today is that you can search your database in the same window while you have your article open - saving desktop real estate. Look at this partial screen capture:
The database is opened up above your editing window, so you can see the keywords you've already culled from your RankTracker research. In this case, I'm working on a series of articles on telemarketing - and you can see the highlighted keyword "telemarketer training" right above the article with that keyword in it's title. Note that it's all in the same window.
Makes it easier to see what you're talking about. Now, if you have multiple databases, they'll show up there as well (right now, I only have the "refund02a" database registered, but more will be coming, rest assured). So you can switch easily from one to the other to find the cross-keywords you need, which helps you out with your Latent Semantic Indexing.
As you update your spreadsheet on a regular basis, that keeps your database current, so when you are writing articles, you can tweak them however your research sends you.
A probable sequence on this would be to
- set out your categories according to your research,
- pile all of these into one massive spreadsheet and then
- set up multiple queries so that OpenOffice Base can do your heavy lifting.
- Then, set your categories in your WordPress blog to align with your keywords.
- Once you have all this, then you simply set your publishing schedule to account for holiday cycles and start sending content to social media about the niche products you are offering and so take over top search engine positions.
Follow your publishing schedule and then it's downhill for your work, and uphill for your sales and bank account.
Just wanted to keep you up to date on the latest and greatest - make us both more efficient that way, eh?
PS. Coming soon: How to break into Google Analytics without breaking a sweat - a newbie's guide.