Will Online Ad Revenue Beat Newspapers in 2011?

Note: I take on the newspaper revenue trend line in more depth here.  Thanks to Brian Solis for the link.

Brian Solis wrote an interesting article yesterday about the impending intersection between newspaper advertising revenues and online advertising. Solis predicts that “the collision could occur as soon as the end of this year.” But depending on how you analyze the numbers, I doubt it will occur that soon.

According to the Newspaper Association of America, total newspaper advertising revenue has dropped 23% since 2003. In the same time period, online advertising revenue has increase 64%. Here is the chart, dollars are in millions.

My chart differs from Solis with respect to the online numbers because I was unable to find the data he used in his article. His numbers may be accurate; I was unable to locate the exact figures. My numbers, however, still indicate online ad revenues are increasing along a similar slope line.

Excel Forecast Model

Using the available data from the NAA, I used Microsoft Excel’s FORECAST function to predict the point where newspaper ad revenue and online ad revenue might intersect. The slope lines intersect sometime during the second quarter of 2011.

My concern with this model is the steep decline in newspaper ad revenue during the next 18-24 months. Although newspaper ad revenue fell 21.5% between 2007 and 2008, it is unreasonable to expect them to fall 32.8% and 77% in 2009 and 2010. Therefore, I decided to test the lines using math analysis.

Regression Model

Again, using the available data from the NAA, I calculated that newspaper advertising revenue was falling along a Quadratic Regression line f(x)=ax²+bx+c, where a=-1189.160714, b=4767858.654, and c=-4779052928.

Similarly, online advertising revenue was increasing along a Quadratic Regression line f(x)=ax²+bx+c, where a=-32.96428571, b-132647.6643, and c=-133439153.1.

These regression lines filter out the 2008 numbers where newspaper ad revenue increased 6.7% while online ad revenue decreased 1.8%. Based upon this math analysis, online revenue will not intersect until 2024.

These numbers are slower, and probably more accurate, but I believe that it is unreasonable to predict an intersection fifteen years in the future based solely on six years worth of data. The margin of error is too great using this simple technique.

Will Online Overtake Print at All?

The runoff in classified advertising is dragging down newspapers the most, nearly 30% in 2008 alone. This dent is the result of internet services such as Craig’s List and others. Until newspapers adapt to changing business and economic models, advertising revenues will continue to fall.

On the other hand, both the Excel and Regression Models fail to show dramatic revenue gains for online advertising. The Excel Model even predicts than revenues will slow down and begin to decrease in 2013. Internet marketing has yet to fully develop and still remains subject to the economics surrounding luxury goods and services. The online advertising model needs to improve before it will grow further.

In conclusion, it is too early to predict the ride of online advertising as a replacement to newspapers given the little data available for analysis.

Here are other articles I have written on this topic:

Comments are closed.

Additional comments powered by BackType

 

Switch to our mobile site

PHVsPjxsaT48c3Ryb25nPndvb3RoZW1lc19zZXR0aW5nczwvc3Ryb25nPiAtIGE6MDp7fTwvbGk+PGxpPjxzdHJvbmc+d29vX2Fib3V0PC9zdHJvbmc+IC0gQnJpYW4gTWNEYW5pZWwgaXMgYSB2ZXRlcmFuIGJ1c2luZXNzIGNvbW11bmljYXRvciB3aXRoIG92ZXIgMjAgeWVhcnMgb2YgZXhwZXJpZW5jZSBpbiBtYXJrZXRpbmcsIHB1YmxpYyByZWxhdGlvbnMsIGFuZCBhZHZlcnRpc2luZy48L2xpPjxsaT48c3Ryb25nPndvb19hYm91dGxpbms8L3N0cm9uZz4gLSBodHRwOi8vd3d3LmJyaWFubWNkYW5pZWwub3JnL21lZXQtYnJpYW48L2xpPjxsaT48c3Ryb25nPndvb19hZHM8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2ltYWdlXzE8L3N0cm9uZz4gLSBodHRwOi8vY2xpY2tzZXJ2ZS5jYy1kdC5jb20vbGluay90cGxpbWFnZT9saWQ9NDEwMDAwMDAwMTU2OTYwMDcmcHViaWQ9MjEwMDAwMDAwMDAxNzI4MTU8L2xpPjxsaT48c3Ryb25nPndvb19hZF9pbWFnZV8yPC9zdHJvbmc+IC0gaHR0cDovL2NsaWNrc2VydmUuY2MtZHQuY29tL2xpbmsvdHBsaW1hZ2U/bGlkPTQxMDAwMDAwMDI4NjUyMTU2JnB1YmlkPTIxMDAwMDAwMDAwMTcyODE1PC9saT48bGk+PHN0cm9uZz53b29fYWRfaW1hZ2VfMzwvc3Ryb25nPiAtIGh0dHA6Ly9jbGlja3NlcnZlLmNjLWR0LmNvbS9saW5rL3RwbGltYWdlP2xpZD00MTAwMDAwMDAyODY1OTA2MCZwdWJpZD0yMTAwMDAwMDAwMDE3MjgxNTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2ltYWdlXzQ8L3N0cm9uZz4gLSBodHRwOi8vY2xpY2tzZXJ2ZS5jYy1kdC5jb20vbGluay90cGxpbWFnZT9saWQ9NDEwMDAwMDAwMjc0MjkzNzcmcHViaWQ9MjEwMDAwMDAwMDAxNzI4MTU8L2xpPjxsaT48c3Ryb25nPndvb19hZF91cmxfMTwvc3Ryb25nPiAtIGh0dHA6Ly9jbGlja3NlcnZlLmNjLWR0LmNvbS9saW5rL3RwbGNsaWNrP2xpZD00MTAwMDAwMDAxNTY5NjAwNyZwdWJpZD0yMTAwMDAwMDAwMDE3MjgxNTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX3VybF8yPC9zdHJvbmc+IC0gaHR0cDovL2NsaWNrc2VydmUuY2MtZHQuY29tL2xpbmsvdHBsY2xpY2s/bGlkPTQxMDAwMDAwMDI4NjUyMTU2JnB1YmlkPTIxMDAwMDAwMDAwMTcyODE1PC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzM8L3N0cm9uZz4gLSBodHRwOi8vc2VhcmNoLmJhcm5lc2FuZG5vYmxlLmNvbS9UaGUtRGF5LXRoZS1GYWxscy1TdG9vZC1TdGlsbC9DYXRoeS1NYXJpZS1CdWNoYW5hbi9lLzk3ODE0MDEzNDA5NzE/YWZzcmM9MSZsa2lkPUoyODY1OTA2MCZwdWJpZD1LMTcyODE1PC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzQ8L3N0cm9uZz4gLSBodHRwOi8vY2xpY2tzZXJ2ZS5jYy1kdC5jb20vbGluay90cGxjbGljaz9saWQ9NDEwMDAwMDAwMjc0MjkzNzcmcHViaWQ9MjEwMDAwMDAwMDAxNzI4MTU8L2xpPjxsaT48c3Ryb25nPndvb19hbHRfY29sb3Vyczwvc3Ryb25nPiAtIGJsdWUuY3NzPC9saT48bGk+PHN0cm9uZz53b29fYWx0X3N0eWxlc2hlZXQ8L3N0cm9uZz4gLSBjbGVhbi1saWdodC5jc3M8L2xpPjxsaT48c3Ryb25nPndvb19hcmNoaXZlczwvc3Ryb25nPiAtIGh0dHA6Ly93d3cuYnJpYW5tY2RhbmllbC5vcmcvYXJjaGl2ZXM8L2xpPjxsaT48c3Ryb25nPndvb19hc2lkZXNfY2F0ZWdvcnk8L3N0cm9uZz4gLSBBc2lkZXM8L2xpPjxsaT48c3Ryb25nPndvb19hc2lkZXNfZW50cmllczwvc3Ryb25nPiAtIDI8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzE8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMTAzPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzEwNDwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl8xMDU8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMTI2PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzEyNzwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl8xNjwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl8xNjI8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMjE8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMjI8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMjc8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl8zPC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMzQ8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfMzc8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfNDwvc3Ryb25nPiAtIHRydWU8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzQxPC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfNTA8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2NhdF9uYXZfNTE8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl81NDwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fY2F0X25hdl81ODwvc3Ryb25nPiAtIHRydWU8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzcwPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzcxPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzcyPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2XzczPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2Xzc4PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2Xzg1PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2Xzg2PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2Xzk2PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jYXRfbmF2Xzk3PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jdXN0b21fY3NzPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fY3VzdG9tX2Zhdmljb248L3N0cm9uZz4gLSBodHRwOi8vd3d3LmJyaWFubWNkYW5pZWwub3JnL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvMy1mYXZpY29uLmljbzwvbGk+PGxpPjxzdHJvbmc+d29vX2RlbGljaW91czwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2RpZ2c8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19mYWNlYm9vazwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2ZlZWRidXJuZXJfaWQ8L3N0cm9uZz4gLSBCcmlhbk1jRGFuaWVsPC9saT48bGk+PHN0cm9uZz53b29fZmVlZGJ1cm5lcl91cmw8L3N0cm9uZz4gLSBodHRwOi8vZmVlZHMuZmVlZGJ1cm5lci5jb20vQnJpYW5NY0RhbmllbDwvbGk+PGxpPjxzdHJvbmc+d29vX2ZsaWNrcjwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2ZsaWNrcl9pZDwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2dvb2dsZV9hbmFseXRpY3M8L3N0cm9uZz4gLSA8c2NyaXB0IHR5cGU9XCJ0ZXh0L2phdmFzY3JpcHRcIj4NCnZhciBnYUpzSG9zdCA9ICgoXCJodHRwczpcIiA9PSBkb2N1bWVudC5sb2NhdGlvbi5wcm90b2NvbCkgPyBcImh0dHBzOi8vc3NsLlwiIDogXCJodHRwOi8vd3d3LlwiKTsNCmRvY3VtZW50LndyaXRlKHVuZXNjYXBlKFwiJTNDc2NyaXB0IHNyYz1cJ1wiICsgZ2FKc0hvc3QgKyBcImdvb2dsZS1hbmFseXRpY3MuY29tL2dhLmpzXCcgdHlwZT1cJ3RleHQvamF2YXNjcmlwdFwnJTNFJTNDL3NjcmlwdCUzRVwiKSk7DQo8L3NjcmlwdD4NCjxzY3JpcHQgdHlwZT1cInRleHQvamF2YXNjcmlwdFwiPg0KdHJ5IHsNCnZhciBwYWdlVHJhY2tlciA9IF9nYXQuX2dldFRyYWNrZXIoXCJVQS0xMzE4MTc0LTFcIik7DQpwYWdlVHJhY2tlci5fdHJhY2tQYWdldmlldygpOw0KfSBjYXRjaChlcnIpIHt9PC9zY3JpcHQ+PC9saT48bGk+PHN0cm9uZz53b29fbGFzdGZtPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fbGF5b3V0PC9zdHJvbmc+IC0gaGVhZGVyLnBocDwvbGk+PGxpPjxzdHJvbmc+d29vX2xpbmtlZGluPC9zdHJvbmc+IC0gaHR0cDovL3d3dy5saW5rZWRpbi5jb20vaW4vYnJpYW5tY2RhbmllbDwvbGk+PGxpPjxzdHJvbmc+d29vX2xvZ288L3N0cm9uZz4gLSBodHRwOi8vd3d3LmJyaWFubWNkYW5pZWwub3JnL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvNi1sb2dvLnBuZzwvbGk+PGxpPjxzdHJvbmc+d29vX21hbnVhbDwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS9zdXBwb3J0L3RoZW1lLWRvY3VtZW50YXRpb24vdGhpY2svPC9saT48bGk+PHN0cm9uZz53b29fb3RoZXJfZW50cmllczwvc3Ryb25nPiAtIDc8L2xpPjxsaT48c3Ryb25nPndvb19yZXNpemU8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fc2hvcnRuYW1lPC9zdHJvbmc+IC0gd29vPC9saT48bGk+PHN0cm9uZz53b29fc2lkZV9pbWFnZTwvc3Ryb25nPiAtIGh0dHA6Ly9jbGlja3NlcnZlLmNjLWR0LmNvbS9saW5rL3RwbGltYWdlP2xpZD00MTAwMDAwMDAyNzg5ODY0MSZwdWJpZD0yMTAwMDAwMDAwMDE3MjgxNTwvbGk+PGxpPjxzdHJvbmc+d29vX3NpZGVfdXJsPC9zdHJvbmc+IC0gaHR0cDovL2NsaWNrc2VydmUuY2MtZHQuY29tL2xpbmsvdHBsY2xpY2s/bGlkPTQxMDAwMDAwMDI3ODk4NjQxJnB1YmlkPTIxMDAwMDAwMDAwMTcyODE1PC9saT48bGk+PHN0cm9uZz53b29fc3R1bWJsZTwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX3RoZW1lbmFtZTwvc3Ryb25nPiAtIFRIaUNLPC9saT48bGk+PHN0cm9uZz53b29fdHdpdHRlcjwvc3Ryb25nPiAtIEJyaWFuTWNEYW5pZWw8L2xpPjxsaT48c3Ryb25nPndvb191cGxvYWRzPC9zdHJvbmc+IC0gYTo0OntpOjA7czo2MjoiaHR0cDovL3d3dy5icmlhbm1jZGFuaWVsLm9yZy93cC1jb250ZW50L3dvb191cGxvYWRzLzYtbG9nby5wbmciO2k6MTtzOjYyOiJodHRwOi8vd3d3LmJyaWFubWNkYW5pZWwub3JnL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvNS1sb2dvLnBuZyI7aToyO3M6NjI6Imh0dHA6Ly93d3cuYnJpYW5tY2RhbmllbC5vcmcvd3AtY29udGVudC93b29fdXBsb2Fkcy80LWxvZ28ucG5nIjtpOjM7czo2NToiaHR0cDovL3d3dy5icmlhbm1jZGFuaWVsLm9yZy93cC1jb250ZW50L3dvb191cGxvYWRzLzMtZmF2aWNvbi5pY28iO308L2xpPjxsaT48c3Ryb25nPndvb195b3V0dWJlPC9zdHJvbmc+IC0gaHR0cDovL3d3dy55b3V0dWJlLmNvbS9LQzRMTUQ8L2xpPjwvdWw+