Mechanisms setting the density decay in the scrape-off layer (SOL) at the outer midplane of a tokamak plasma are disentangled using two-fluid numerical simulations in a double-null magnetic configuration and analytical estimates. Typical experimental observations are retrieved, in particular increasing intermittency of the turbulence going from the near to the far SOL, which is reflected in two different density decay lengths. The decay length of the near SOL is well described as the result of transport driven by a nonlinearly saturated ballooning instability, while in the far SOL, the density decay length is described using a model of intermittent transport mediated by blobs. The analytical estimates of the decay lengths agree well with the simulation results and typical experimental values and can therefore be used to guide tokamak design and operation.