It pales in comparison to sales. Everything pales in comparison to sales. Including competence. Including doing the work.
What content about you do you emphasize to find leads?
To a first approximation, finding leads consists of finding leads. Not making content. It means pounding the pavement. Making cold calls. Making warm calls to people you know to ask for leads.
Don't get me wrong, I love avoiding sales as much as anyone. I've built websites and used Linkedin and blogged to avoid selling. I joined the local Chamber of Commerce and Rotary to sit in a room eating instead of going out selling.
Selling is really hard because it is mostly rejection. It is even harder when starting out because good clients already have consultants. It is even harder when starting out because you have no idea what sells. And crazy ideas about what might...like consultant CTO who also handles hiring and builds the product. There probably is someone who might buy that. You are unlikely to find that person because there are not enough days in the world for you to meet them and close the sale.
Even worse, if you meet someone who thinks they might buy that thing, they are probably a bad client. In the best case bad because they have no experience working with people like you. In the average case, bad because they do have experience working with people like you...new desperate freelancers.
Sell something that sells. Sell what other people sell because that is what sells. Every snowflake is different. Being different, being niche, pitching a snowflake...these are all excuses to avoid selling. Selling into a niche works when you've found the niche is organically through experience.
Good luck.