How effective are ads?

In terms of cost of an ad to earnings, and how well, even a targeted ad, can hold a viewer's attention. Have we just become numb to ads? Does targeted advertising actually yield better results?