Google Sheets to the Rescue
Tracking with Google Sheets
I use Google sheets quite a bit to track various things. One that I've been suggesting to others lately is tracking keywords.
While I have several websites, with just one site, you might still find this help
When doing topic and keyword research, I list my ideas in one column, then search for possible keywords. I add them to the next column, as I choose them. If I find more than one that I like for a topic, I can add more columns to refer back to later.
Once I've chosen the keywords, I still need my sheet.
I add a page to the sheet, copy the keywords as I begin writing, then add a date that I publish that post.
If you have just one or two websites, this is easily done on just one page. For me, with multiple sites, I need to keep it separate to make it easy to read.
One addition I do on my sheets is to add color. Each site has its own color. And each month has a different shade. That might be overkill, but it helps me stay focused on the area I'm working on at the time. And, it looks vibrant, too! 😀
As I publish, I add the keyword to the top of the list, shifting the older entries down. I hate scrolling down each time I want to add, so this works best for me.
“Organizing is a journey, not a destination.” -- Anonymous
A Big Benefit- Finding Older Keywords
I think most of us have experienced that "oh no" feeling of writing a post only to discover we've used that same keyword before. But keeping them on a sheet such as this helps prevent that.
When I'm adding keywords, I'll use my "control f" function to search for a word on the sheet. Almost instantly, I know if I've already used that keyword or written on that topic.
At that point, I can choose a different variation and write the post to another slant, or just choose another topic.
I stay focused!
Another Useful Tip
I like to keep a list of reference sites for those topics I'm researching and using as sources for information. Narrow columns (I use the "clip" format often, including for these columns) hold the URL for any reference sites I need. One site per column keeps me very organized.
If I will be relating to products, I also include a note for those.
Is this too much organization?
Probably. But it's been quite useful in keeping me organized and on-point, especially on those days with interruptions and crazy moments.
Do you use any of these techniques? Or do you have some useful ways you organize to keep you aiming for those targets?
If so, please share in the comments. I'm interested!