Complete Beginner Struggling: How to Accurately Identify Specific User Needs for Low-Volume Keywords?

Hello everyone! As a complete newbie to the world of SEO, I’ve been avidly following discussions here, especially the recent one about struggling with low-volume keyword intent. It really resonated with me because I’m facing a very similar, perhaps even more basic, version of that challenge. I’ve just launched my super niche SaaS product, and to save on initial costs and honestly, to learn as much as I can, I’ve decided to tackle the SEO myself. It's been a steep learning curve, but I'm determined. The core problem I’m encountering is truly understanding the specific user needs and underlying search intent for those really low-volume, long-tail keywords that seem absolutely perfect for my niche product. I feel like I'm staring at a puzzle with half the pieces missing. I've tried using common SEO tools like Ahrefs and SEMrush, but for these highly specific, low-volume terms, they often show 'no data' or only very broad intent classifications, which isn't granular enough for what I need. When I manually search on Google, the SERP results are frequently a mixed bag—some informational articles, some commercial pages, and occasionally a transactional result. This makes it incredibly hard to pin down what users are *really* looking for when they type in these specific queries. My own attempts at guessing the intent based purely on logic or what I *think* my potential customers want have frequently led to creating content that simply doesn't resonate or convert, which is super disheartening. I'm trying to get better at user intent analysis, but the lack of clear data is a huge roadblock. The impact of this struggle is significant. I feel like I'm wasting valuable time and effort creating content that might not even be addressing what my potential customers are looking for, leading to zero engagement, no sign-ups, and a growing sense of frustration. It’s a bit like shouting into the void. So, I’m really hoping to get some very practical, step-by-step advice or beginner-friendly methods to truly understand the underlying intent when keyword data is scarce. Are there any specific techniques or free tools that experienced SEOs or founders use for this kind of deep dive into low-volume keyword intent, beyond just looking at the top few SERP results? I'm open to anything that can help me improve my user intent analysis for these niche terms. Eagerly awaiting any wisdom from experienced SEOs or founders who've cracked this specific challenge. Thank you in advance for any help!