If you are looking for an overnight solution, you are looking for the golden goose. A comprehensive SEO strategy will take months to show results on all fronts, although results in certain areas can be attained sooner than others. On average, you can expect to see noticeable results from a comprehensive SEO campaign in 3-6 months.