SEO is absolutely effective. If you have a brand new website, almost any SEO activity will increase your ranking chances. On the other hand, once you developed a mature SEO profile, you need to be careful on what strategies you employ. SEO effect the website after 6 months. But the result is best and increase day by day.