It was highly effective. Catapulted a few local businesses (I believe one gained enough exposure to open a second location) and a few temporary internet celebrities owed at least some of their fame to it.

That said, the latter example on YouTube was not effective at all, but that was probably because the content wasn't great.