Since you are so hugry for knowledge, I wanted to share some videos I just watched. One of these videos was the one I referred to in the Canon example.
Its trying to sell a fairly new product called Micro Niche Finder.
I'm not suggesting you buy it, although I have read pretty good reviews.
Just watch the videos because it will give you some great insight and most of
what it shows could be done manually, it would just take more elbow grease.
Micro Niche Finder. Watch the very top video just to get an idea,
then if you learn something from that and want to learn more watch the others.