There's no definitive answer to how long SEO will be able to deliver substantial result'. Many factors are at play, such as the keywords used, their terms and locations, among others. We usually estimate an decent increase in three to six months, but the improvements could be observed from the beginning of the month.