I want to become an affiliate and build a website. I want to work hard and make it a success. But I dont know what type of site to make or Niche to focus on. They say "Do what are you interested in" but when I research niches I like using Long Tail Pro everything seems brutally competitive. I made some Amazon stores but the earnings are tiny. Im afraid of spending years of time and money building a site only to find out its (yet another) failure or not a profitable area to be in. I know Wordpress and blogging but can work on any platform and different business model. But I dont know what site to make. How can I find a successful formula I can work?
I think we need to reframe the question around what audience do you want to serve? Who do you want to help? Focus on building the best possible resource to solve a certain problem, and trust that the money will follow.
One affiliate example I often point to is TripAdvisor. They didn't set out to "become an affiliate and build a website." They set out to build an authoritative brand in the travel space, and now earn a ton of money from flight and hotel bookings as an affiliate. They solve a specific problem (with my limited travel budget, what are my best options?) and found a way to monetize that.
Find a niche / subject that you love (you'll have to write a lot) and develop content around common problems in the niche. Try to monetize these first articles using adsense and product reviews to validate the niche and your angle (around 60 articles).
You can use guest posting to build your domain authority during this first phase.
There are many ways to bootstrap an authority website / affiliate website but this is the one i've used in the past. As soon as your website can finance content creation it'll scale quickly.
Hope it'll help.
I have been working in the affiliate industry for almost ten years and have helped numerous people start to make a living at it. Let's do a quick call to help you start making money. It's easier than you think actually to get started.