Is generating seo leads still worth the effort?

probably a basic question, but how do you actually generate seo leads? it looked like it was working for about two weeks and then flattened out. how long before you'd expect to see anything? thanks in advance.